How to Keep Track of Guest Post Submissions

Guest post opportunities are easy to lose when pitches, editor replies, drafts, revisions, and publication dates are scattered across email and notes. A simple tracking system gives every submission a clear next step and helps you follow up professionally without sending duplicate or premature messages.

Choose a single source of truth

The most important rule is to keep every guest post opportunity in one central system. You can use a spreadsheet, project-management app, customer relationship management tool, or a lightweight database. The tool matters less than using it consistently.

A spreadsheet is usually the best starting point because it is inexpensive, searchable, easy to customize, and simple to share with a team. Create one master sheet for all opportunities instead of maintaining separate lists for different websites or topics.

Useful alternatives include:

• Google Sheets or Excel: Best for straightforward tracking, filtering, sorting, and reporting.
• Trello, Notion, or Airtable: Useful when each submission needs cards, attachments, comments, and visual workflow stages.
• A CRM: Helpful if guest posting is part of a larger outreach or partnership process.
• A plain text file: Acceptable for a very small number of submissions, but harder to filter and maintain over time.

Do not rely on your email inbox as the tracking system. Email is useful for communication, but messages can be buried, threads can split, and deadlines are difficult to see at a glance.

Set up the right tracking columns

Your tracker should capture enough information to answer four questions quickly:

1. Who are you contacting?
2. What did you submit?
3. What is the current status?
4. What should happen next, and when?

A practical spreadsheet can use these columns:

Column	What to record	Why it matters
Website	Publication name and URL	Identifies the target site
Contact	Editor name, email, or submission page	Keeps contact details accessible
Topic	Proposed or assigned article topic	Prevents duplicate ideas
Pitch or draft URL	Link to the working document	Makes the latest version easy to find
Date contacted	Date of the first email or submission	Starts the follow-up schedule
Status	Current workflow stage	Shows what needs attention
Next action	Specific upcoming task	Prevents vague reminders
Follow-up date	Date to review or contact again	Creates accountability
Response	Summary of the editor’s reply	Preserves important context
Deadline	Agreed delivery or revision date	Prevents missed commitments
Publication URL	Live article link, when available	Confirms completion and records the result
Notes	Requirements, restrictions, or history	Stores useful details for future work

Use one row per submission. If a publication accepts multiple articles, each article should still have its own row, while the website and contact information can be repeated.

Keep URLs in dedicated columns rather than pasting them into long notes. This makes them clickable and easier to audit later.

Create clear submission statuses

Statuses should describe the current stage, not your feelings about the opportunity. Avoid labels such as “maybe” or “important” because they do not tell you what action is required.

A useful status sequence is:

• Prospect: The website appears relevant, but you have not contacted it.
• Researching: You are checking guidelines, topics, audience, and contact details.
• Pitch ready: Your idea and email are prepared for review.
• Pitch sent: The initial pitch has been submitted.
• Follow-up due: The expected response period has passed.
• Interested: The editor has expressed interest but has not yet assigned or approved the article.
• Draft requested: The publication wants a complete draft.
• Draft submitted: You sent the article for review.
• Revision requested: Changes are required before publication.
• Approved: The article is accepted or scheduled.
• Published: The article is live.
• Declined: The opportunity was rejected.
• Paused: The process is temporarily stopped because of timing, missing information, or another reason.
• Closed: The opportunity is no longer active, such as when a site stops accepting submissions.

Use a dropdown list when your spreadsheet supports it. Consistent labels make filtering reliable and prevent small spelling differences from creating separate categories.

Record the next action, not just the status

A status tells you where a submission is. The next-action field tells you what to do about it. These are different pieces of information.

For example, “Draft submitted” is a status. “Check for editor response on October 8” is a next action. “Interested” is a status. “Send outline after confirming word count and deadline” is a next action.

Write next actions as verbs with a date whenever possible:

• Review the publication’s updated contributor guidelines on October 3.
• Send a polite follow-up on October 10.
• Apply the editor’s requested revisions by October 14.
• Confirm whether the article is scheduled after the agreed publication week.
• Check the live link and verify the author bio after publication.

Avoid entries such as “follow up sometime” or “wait.” They create uncertainty and make the tracker less useful.

If an editor gives you a deadline, record it immediately. Do not assume that the email thread will be easy to find later. If no deadline is provided, add your own review date based on the conversation and the publication’s usual response time.

Build a simple follow-up schedule

Following up is normal, but the timing and tone matter. A reasonable schedule depends on whether you sent a pitch, a completed draft, or a revision.

For an unsolicited pitch, wait long enough for the editor to review it, then send one concise follow-up. If there is still no response, you can send a final check-in or close the opportunity. Avoid repeated messages every few days.

For a requested draft, follow the timeline the editor gave you. If no response period was provided, review the submission after approximately one to two weeks and send a polite status request. High-volume publications may need more time.

For an agreed publication date, contact the editor if the date passes without an update. Keep the message factual and easy to answer.

A follow-up record should include:

• The date of the previous message.
• The submission or article title.
• Any agreed deadline or publication date.
• A direct question about the next step.
• A short offer to resend the document or provide anything missing.

For example:

Subject: Checking in on “Article Title”

Hi [Name],

I’m checking in on the article I sent on [date]. You mentioned that it might be reviewed by [timeframe]. Could you let me know whether it is still under consideration or if you need any changes from me? I’m happy to resend the document or adjust the draft.

Best, [Name]

Once a publication has declined or clearly said it is not interested, update the status and stop the follow-up sequence unless the editor invites another submission.

Use filters and color carefully

Filters turn a large tracker into a daily task list. Create saved views or filtered tabs for:

• Follow-ups due today.
• Drafts with deadlines in the next seven days.
• Submissions waiting for an editor response.
• Revision requests that are not complete.
• Published posts without a confirmed live URL.
• Opportunities by publication, topic, or campaign.

Color can make urgent items easier to notice, but color should support written statuses rather than replace them. For example, use one color for follow-ups due, another for revision requests, and a third for completed submissions. Make sure the text remains readable and accessible if the sheet is printed or viewed without color.

Conditional formatting can highlight dates that are overdue. A useful rule is to mark a follow-up date when it is earlier than today and the status is not “Published,” “Declined,” or “Closed.” Review these alerts regularly so old rows do not become permanent background noise.

Keep submission documents organized

A tracker is much more useful when its document links work and the files have predictable names. Store pitches, drafts, images, bios, and revision versions in organized folders.

A practical naming format is:

Publication - Article Topic - Version - Date

For example:

Example Site - Beginner Link Building Guide - Draft 2 - 2026-10-05

Keep the main document link in the tracker and use document history for minor changes when possible. If an editor requests substantial revisions, save a clearly labeled version rather than overwriting the original without a record.

Check sharing permissions before submitting. Editors should be able to open the document without requesting access. If a publication requires an attachment, record the filename in the tracker and keep a copy of the exact submitted version.

Do not store sensitive passwords or private client information in a broadly shared tracker. Use restricted folders or a password manager for confidential data.

Track quality and publication results

The goal is not simply to send more pitches. You should learn which topics, publications, and approaches produce useful results.

After an article is published, record:

• The live URL.
• The publication date.
• The final headline.
• The author bio or business link used.
• Whether the link works and points to the intended destination.
• Any social promotion or newsletter mention.
• Notes about traffic, referrals, inquiries, or other meaningful outcomes.

Do not treat every published link as equally valuable. Consider audience relevance, editorial quality, brand fit, link placement, and whether the site remains active. A high number of submissions can hide poor results if you do not review outcomes.

You can add optional columns for response time, word count, accepted topic category, and estimated effort. These fields help you decide where to spend time in future campaigns.

Review the tracker on a regular schedule

A tracking system only works if it is maintained. Set aside a short review period at least once or twice a week.

During each review:

1. Sort by follow-up date.
2. Complete or reschedule overdue actions.
3. Update statuses from recent email conversations.
4. Add deadlines immediately.
5. Close opportunities that are no longer realistic.
6. Check that document and publication links still work.
7. Review whether new pitches duplicate existing topics.

At the end of each month, look for patterns. You may discover that certain sites respond quickly, some topics receive more interest, or particular pitch formats lead to better outcomes. Use those observations to improve your process instead of continuing every submission in exactly the same way.

Troubleshooting common tracking problems

You lose track of the latest version. Keep one primary document link in the tracker and record version numbers in the file name or document history.

You send duplicate pitches. Search the tracker by publication, contact, and topic before submitting. Add declined or closed opportunities instead of deleting them.

You forget to follow up. Use a required follow-up date for every active submission. If there is no appropriate date, decide when you will review it and record that date.

Your tracker becomes too large. Archive old closed rows into a separate sheet or table, but retain enough history to recognize previous contacts and topics.

Several team members update the same row. Add an owner column and agree on who is responsible for each next action. Use comments for discussion and the main columns for final decisions.

An editor’s message conflicts with the tracker. Treat the most recent direct instruction as authoritative, then update the row immediately with the new status, deadline, and a short summary of the change.

A publication stops responding. Record the last contact date, send a final concise message if appropriate, and move the row to “Paused” or “Closed” rather than leaving it indefinitely in an active queue.

Limitations of a submission tracker

A tracker cannot make editors respond, guarantee publication, or replace good writing and respectful communication. Dates are reminders, not promises. Editors may change roles, publication schedules can shift, and websites may alter their contributor policies without notice.

Your records may also become inaccurate if you copy information without verifying it. Recheck submission guidelines before pitching, especially when an opportunity has been inactive for several months. Track uncertainty openly by writing notes such as “guidelines unclear” or “awaiting confirmation” instead of treating assumptions as facts.

Start with the smallest system you will actually maintain: one master list, clear statuses, a next action, and a follow-up date for every active submission. As the volume grows, add document links, ownership, deadlines, and performance fields without making the workflow so complicated that updates stop happening.