• Write the order record before you pay: site, price, deliverables, link policy, timeline and replacement terms.
  • After publication, record the live URL, the anchor, the target page, the rel value and whether the page is indexed.
  • Re-check every placement monthly and log the result, so lost or changed links are caught early.
  • Keep publisher facts separate from seller promises, and keep screenshots or archive copies as evidence.
Guest post tracker template for orders and link monitoring
A structured guest post tracker records placement terms, link health and guarantee windows. It turns scattered email notes into an auditable link sheet.

A guest post tracker is a simple sheet with one row per placement. It records what you agreed before paying, what was delivered, and what happened to the link over time. Without one, placements quietly disappear, nofollow tags appear, and replacement deadlines pass unnoticed. The template below is the structure we use at RankPulse to track client placements. Copy the columns into any spreadsheet.

Part 1: the order record, before you pay

Agree the delivery terms first and the performance talk later. Write these fields down and get the publisher or provider to confirm them:

FieldWhat to record
PublisherThe exact domain, not just "a tech site"
Price and payment methodAmount, currency, and how buyer protection works
DeliverablesArticle length, who writes it, images, and the report you will get
Target page and anchorThe URL you want referenced and the planned anchor text
Link policyWhether the link will be marked sponsored, nofollow or neither
TimelineWhen the draft and the live post are due
ApprovalWhether you approve the draft before it goes live
IndexingWhether the post will be linked internally and in the sitemap
Replacement termsWhat happens if the link is removed, and for how long
Payment triggerWhat has to be true before payment is released

Keep facts about the publisher, such as its domain and link policy, separate from promises such as "fast indexing" or "high traffic". Only the first kind can be checked before you pay. Our guide to vetting guest post sites covers the checks to run on each publisher.

Part 2: the placement record, after publication

ColumnExample entry
Live URLThe full address of the published post
Date publishedThe date the post went live
Anchor textThe exact clickable words
Target URLThe page the anchor points to, after any redirects
rel valuenone, sponsored, nofollow or ugc
Indexed?Yes or no, and the date you checked
EvidenceA screenshot or archive copy of the live page
Referral visitsSessions from the publisher in GA4 after 30 days
StatusLive, changed, removed or replaced
NotesAny edits the publisher made

To check the rel value, right-click the link and choose Inspect, as shown in our guide to checking if a backlink is dofollow. To check indexing, search the exact URL in Google, or see what to do when a guest post is not indexed.

Part 3: the monthly check

  1. Is the page still live? It should load normally, without redirecting to the homepage.
  2. Is the anchor still there and pointing to the right URL?
  3. Has the rel value changed?
  4. Is the page still indexed?

Log the date and result in a new column each month. For many placements, a crawler in list mode with a custom search for your domain does this in minutes. See how to find broken backlinks and check link status.

Handling lost or changed links

  • Link removed: contact the publisher with the live URL, the date it went live and your order record. If you have replacement terms, claim them before they expire.
  • Nofollow or sponsored added: check what was agreed. If the order said sponsored, that is expected. If nothing was agreed, ask why it changed.
  • Page moved: find the new URL and confirm the link is still there.
  • Post deleted: ask whether it can be restored or replaced on a similar site.

Our guide to link replacement guarantees explains what good replacement terms look like.

Keep the metrics honest

Record third-party scores such as DA and DR with the date and the tool, because they change and differ between tools. Never mix estimates with the publisher's own analytics in the same column. And measure placements by what you can verify, such as referral visits and indexing, rather than by promises.

Every RankPulse order comes with a report that includes the live URL, metrics and the link attribute, which slots straight into this template. See the placement inventory.

Frequently asked questions

What should a guest post tracker include?

At minimum: the publisher, price, target URL, anchor text, live URL, publish date, rel value, indexing status, evidence of the live page, and a monthly status check.

How often should I check my guest post links?

Once a month is enough for most placements. Check more often in the first few weeks after publication, when edits and indexing problems are most likely.

What should I agree before paying for a guest post?

Agree the exact domain, the price, what is delivered, the target URL and anchor, how the link will be marked, the timeline, whether you approve the draft, and what happens if the link is removed.

How do I prove a guest post link was live?

Keep a dated screenshot or an archive copy of the live page, and note the date you checked it. That evidence helps when you claim a replacement.

Should I track DA and DR in my sheet?

You can, but record the tool and the date, because these scores change and differ between tools. Track verifiable results, such as indexing and referral visits, as well.

Sources

  1. Google Search Central: rel=sponsored, nofollow and UGC: the rel values to record (accessed November 9, 2026)
  2. Google Search Console Help: Links report: confirming that Google has found a link (accessed November 9, 2026)
  3. Google Analytics Help: default channel group: how referral visits are reported (accessed November 9, 2026)