Skip to content
LinksElevateSEO & EDITORIAL OUTREACH
Menu

Guest Post Outreach Tracker: A Simple Spreadsheet Workflow

Over-the-shoulder view of a person tracking editorial outreach on a laptop spreadsheet with softly blurred cells, desk notebook and pen
AI-generated illustration of over-the-shoulder view of a person tracking editorial outreach on a laptop spreadsheet with softly blurred cells, desk notebook and pen.

A guest post outreach tracker should help you remember the next useful action, not simply count how many messages you have sent. For a small editorial campaign, a carefully maintained spreadsheet can show who owns each conversation, what the publisher requested and when contact should stop.

This guide covers the period from a qualified prospect to an editorial decision. It is different from a live-link monitoring sheet: a reply, an accepted idea and a published article are separate events and should not be counted as the same result.

Use one row for one conversation

Choose a consistent unit before entering data. A practical starting point is one row for a publication and a specific article proposal. Give that row a short internal reference so a revised title does not make it look like a different campaign.

If two team members work on the same publication, assign one conversation owner. They should check the existing record before contacting another editor. A second email address is not a reason to restart a conversation that has already been declined.

Keep the essential columns small

Begin with the following fields and add more only when they support a decision:

  • Publication and guidelines: the website and the relevant submission instructions.
  • Fit note: one specific reason the proposed topic serves its readers.
  • Proposal reference: a short identifier and working topic.
  • Contact route: the publisher’s appropriate business contact or submission form.
  • Owner: the person responsible for the conversation.
  • Status: a controlled label used consistently across the sheet.
  • Last meaningful activity: a date and a brief factual summary.
  • Next action: what needs doing, by whom and when.
  • Stop-contact flag: a clear record of a decline or request not to contact.

Do not turn the sheet into a collection of unnecessary personal information. Limit access to the people doing the work. Keep private correspondence in its appropriate business system and link to it only where authorised.

Define statuses before you count them

Try a small set such as Research complete, Proposal sent, Editor replied, Draft requested, Under review, Accepted, Published and Closed. Write a one-line definition for each label on a separate notes tab.

“Editor replied” means there is a response, not that the proposal has been accepted. “Draft requested” means the publisher asked to see an article, not that publication is guaranteed. Use “Published” only after checking the actual public page. This distinction keeps reports honest when a campaign has several promising conversations but no live articles yet.

Make the next action specific

Replace vague notes such as “chase” with a task that another team member could understand. For example: “Send the shorter outline requested by the editor after the author approves it.” If no action is appropriate, write that down too.

Follow the publisher’s stated response window. Do not turn a blank reply field into an automatic sequence of repeated messages. Our guest post content brief guide helps organise the agreed requirements; a clear refusal or stop-contact request should end follow-ups.

A fictional example row

Imagine a trade publication has requested a practical article about organising a small stockroom. The tracker might say:

  • Proposal: STOCK-01 — a stockroom labelling checklist.
  • Status: Draft requested.
  • Last activity: Editor asked for an outline suitable for independent retailers.
  • Next action: Writer prepares a five-point outline; campaign owner reviews it before sending.
  • Open question: Confirm whether the publication wants original photographs.

This example deliberately has no invented acceptance rate, traffic estimate or promised link. The record explains what is known and what still needs a decision.

Separate commercial details from editorial status

If a placement involves payment or another commercial relationship, record that clearly in the appropriate restricted business records. Agreement about a fee does not prove that an article is editorially approved or that it will appear in search results.

Google’s spam policies distinguish advertising links appropriately marked with sponsored or nofollow from links created to manipulate rankings. Do not use a tracker to demand ranking credit or disguise paid relationships. Keep disclosure and link treatment visible in the agreed publishing requirements.

Review the sheet for decisions, not activity totals

At a regular review, look for unanswered editorial questions, overdue internal tasks, duplicate contacts and closed conversations still showing a follow-up date. Ask whether each open row has a real next step.

Report stages separately. A count of proposals sent describes activity; a count of public articles describes a different outcome. Neither proves that rankings or enquiries improved. When a draft is ready, use our editorial handoff checklist to make the final submission clear.

Common questions

Do I need outreach software to start?

Not necessarily. A small team can begin with a spreadsheet if ownership and updates are consistent. Move to another tool when the workflow requires it, not simply to increase message volume.

Should I delete declined prospects?

Keep only the minimal business record needed to avoid repeat contact and follow your organisation’s retention rules. Do not erase a stop-contact instruction merely to make the active list shorter.

When does a row move to published?

After you verify the public article and record its correct URL. An editor’s planned date or an acceptance email is not the same as a live page.