- 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.

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:
| Field | What to record |
|---|---|
| Publisher | The exact domain, not just "a tech site" |
| Price and payment method | Amount, currency, and how buyer protection works |
| Deliverables | Article length, who writes it, images, and the report you will get |
| Target page and anchor | The URL you want referenced and the planned anchor text |
| Link policy | Whether the link will be marked sponsored, nofollow or neither |
| Timeline | When the draft and the live post are due |
| Approval | Whether you approve the draft before it goes live |
| Indexing | Whether the post will be linked internally and in the sitemap |
| Replacement terms | What happens if the link is removed, and for how long |
| Payment trigger | What 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
| Column | Example entry |
|---|---|
| Live URL | The full address of the published post |
| Date published | The date the post went live |
| Anchor text | The exact clickable words |
| Target URL | The page the anchor points to, after any redirects |
| rel value | none, sponsored, nofollow or ugc |
| Indexed? | Yes or no, and the date you checked |
| Evidence | A screenshot or archive copy of the live page |
| Referral visits | Sessions from the publisher in GA4 after 30 days |
| Status | Live, changed, removed or replaced |
| Notes | Any 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
- Is the page still live? It should load normally, without redirecting to the homepage.
- Is the anchor still there and pointing to the right URL?
- Has the rel value changed?
- 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
- Google Search Central: rel=sponsored, nofollow and UGC: the rel values to record (accessed November 9, 2026)
- Google Search Console Help: Links report: confirming that Google has found a link (accessed November 9, 2026)
- Google Analytics Help: default channel group: how referral visits are reported (accessed November 9, 2026)
