Loganix Ops

New Site Listing — QA Review Form

Schema Mapping

How each form field maps to the new loganix_ops database. This form collects the data that populates these tables when a publisher or vendor adds a new site.

supplier_sites
site_idDomain (looked up in sites)
link_typeDofollow toggle
tatTurnaround time (days)
content_chargeWriting services price
word_count_minimumMin word count
preapprove_topicTopic pre-approval
accepted_anchor_typesAnchor types checkboxes
marked_as_sponsoredMark posts sponsored
article_styleArticle style prefs
guidelines_urlGuidelines (extracted URL)
guidelines_textGuidelines (full text)
live_linkExample link
site_notesAdditional notes
vendor_notesAdditional notes
review_statusAuto: "pending"
supplier_site_pricing
service_typeguest_post / niche_edit
nichegeneral / cbd / crypto / etc.
costPrice per niche+type
supplier_site_meta
indexedGoogle indexed toggle
youtube_embedVideo/map embed toggle
images_acceptedImages in content toggle
updates_after_liveUpdates toggle
permanent_linkPermanent link toggle
accepts_competitor_linksCompetitor content toggle
site_geoAuto-detected from domain
accepts_foreign_linksClient geo radio
accepts_other_languagesOther languages toggle
accepts_local_contentCity/state content toggle
link_insert_placementLink insert placement
author_bio_detailsAuthor bio details
do_we_postWe post directly
low_metricsLow metrics restriction
ai_detection_toolAI detection tool name
author_bioAuthor bio required
adds_internal_linksPublisher adds links (radio)
adds_external_linksDerived from same radio
client_link_typeAccepted page types

Legacy Source

publishers.loganix.com/new_site.php
3-step wizard → publisher_sites_purgatory → staff reviews → publisher_sites + GPv2

QA Review Form — Not Connected to Database

This form shows every data point collected when a publisher or vendor adds a new site listing. Use it to verify field completeness against the legacy wizard (publishers.loganix.com/new_site.php). Nothing is saved — this is for review by Angelo, John, Lore, and Sara.

Add New Site Listing

All the data a publisher or vendor provides when listing a new site. Each field shows which database column it maps to.

1

Site & Pricing

supplier_sites + supplier_site_pricing
The domain the publisher owns. Auto-checked against existing sites table. No www/http prefix.
You cannot swap subdomains or TLD for this domain.
supplier_sites.site_id → sites.domain
Default cost per service type. Leave blank if that service is not offered.
supplier_site_pricing.service_type + .niche(general) + .cost
Guest Post
$
Link Insert
$
Toggle on niches this site accepts. Each reveals separate Guest Post and Link Insert pricing for that niche.
supplier_site_pricing.niche + .cost
CBD
Guest Post$
Link Insert$
Crypto
Guest Post$
Link Insert$
Adult
Guest Post$
Link Insert$
Gambling
Guest Post$
Link Insert$
Payday
Guest Post$
Link Insert$
Pharma
Guest Post$
Link Insert$
Other
Guest Post$
Link Insert$
Does this site sell anything beyond guest posts and link inserts? Examples: banner ads, footer links, social media posts, sponsored YouTube videos, on-air interviews, PR placements.
supplier_site_products.name + .price + .billing_cycle + .notes
$
2

Listing Options

supplier_sites + supplier_site_meta
No robots.txt or noindex tags blocking indexing. If "No" — domain is recorded and blacklisted.
meta: indexed
Yes, posts will be indexed No — not indexed (blacklist)
If your articles are labeled in any way that indicates the content is paid, promotional, or not purely editorial — we need to know. Examples: Sponsored Article, Sponsored Content, Paid Post, Advertorial, Branded Content, "In partnership with," or any similar disclosure. Basically, if a reader could tell the post is an ad or paid placement, select Yes.
NOT sponsored: Simple attribution like "Contributed by" or "Written by" does not count.
supplier_sites.marked_as_sponsored
Yes — link or article is marked as sponsored No — not marked as sponsored
Dofollow links are NOT marked as sponsored, paid or nofollow.
supplier_sites.link_type
Dofollow Nofollow
How many days to upload content once provided.
supplier_sites.tat
Publisher provides WP login so we post directly. Faster TAT.
meta: do_we_post
Yes — we post directly (requires login credentials) No — publisher posts
Can we embed YouTube videos, Google Maps, or other media in the content?
meta: youtube_embed + google_map_embed
Yes — embeds allowed No
Can we include images (stock photos, infographics, screenshots) in the article?
meta: images_accepted
Yes — images accepted No
After a post goes live, can we request edits?
meta: updates_after_live
Yes — updates allowed No
One-time payment for permanent placement. If not, show renewal terms.
meta: permanent_link + renewable_comments
Permanent Renewable — describe terms below
Will you accept a link to a competitor, or publish guest posts from companies that directly compete with each other in the same niche?
meta: accepts_competitor_links + accepts_direct_competitors
Yes — accepts competitor links and posts No
Some publishers won't accept sites with low DA/DR/traffic. Used to filter at card level to reduce cancellation rate.
meta: low_metrics + low_metrics_charge
Yes, has restrictions No
3

Content Details

supplier_sites + supplier_site_meta
Which pages or sections of the site are available for link inserts? If all blog pages are fair game, say so (e.g. "any page under /blog"). If only specific categories or pages, describe them here.
meta: link_insert_placement
Where can the companies you work with be based? This determines which clients we match to your site.
meta: site_geo + accepts_foreign_links
Other than the detected site language. If yes, specify which languages you'll accept.
meta: accepts_other_languages
Yes — other languages accepted No — site language only
Locally-targeted content that mentions specific cities, states, or regions (e.g. "Best plumbers in Austin, TX").
meta: accepts_local_content
Yes — city/state content accepted No
Sample published post(s) on the site to verify quality. Must be from within the last 3 months. You can provide multiple links.
supplier_sites.live_link
What types of articles this site accepts.
supplier_sites.article_style
What types of client pages can be linked.
meta: client_link_type
What anchor text styles the publisher allows.
supplier_sites.accepted_anchor_types
Word or character limit on anchor text.
meta: anchor_limit + anchor_limit_details
Yes, has anchor text limits No
Publisher's rules for how content should be written. URL is auto-extracted if present.
supplier_sites.guidelines_url + .guidelines_text
Publisher can write content instead of us, at an additional charge.
supplier_sites.content_charge
Yes, offers writing No
$ content charge
Must the article topic be approved before writing starts?
supplier_sites.preapprove_topic
Yes, topic must be approved first No
"About the author" section at the bottom of the article. This is an opportunity for the client to describe their company, link to social profiles (Twitter/X, YouTube, LinkedIn), and add a headshot.
meta: author_bio + author_bio_details
Yes, include author bio No
Minimum article length the publisher requires.
supplier_sites.word_count_minimum
After we provide the article, will you insert any additional links — either to your own site or to other clients/partners?
meta: adds_internal_links + adds_external_links
Which tool they use so we can pre-check content.
meta: ai_detection_tool
Yes, uses detection tools No
Anything else — banner ads, social media, special services, restrictions.
supplier_sites.site_notes
4

Bulk Listings

optional

Have multiple sites with similar settings?

Add additional domains below. They will inherit all the pricing, options, and content settings from this listing. You can adjust individual sites later from your dashboard.

One domain per line. These will be cloned from the listing above with the same pricing and settings.
Creates additional supplier_sites rows
Each domain gets its own listing with the same settings. Override pricing per-site from your dashboard.
If some of the bulk domains need different pricing, note them here. Otherwise they all get the same price.
Yes — some sites have different pricing No — all same price
Coming soon: CSV upload and API access for large inventories. For now, use this form for up to ~50 domains. For larger batches, contact your account manager.
5

Terms & Conditions

  • We do not control guest post content after it goes live. Once published, the publisher manages the content on their site.
  • You cannot swap subdomains or TLD for this domain. The listing is for the exact domain entered above.