Skip to content
Blog Post Tracker cover: a sample sheet with posts tracked, live and average words per draft and a bar chart, beside the Dashboard and Posts tabs

Blog Post Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

The Blog Post Tracker is for a writer, marketer or small editorial team that publishes articles on a steady schedule. The Posts tab records each article with its category, author, target keyword, word count, status from Idea to Live, publish date, views and a tick for whether the meta description is written. The dashboard totals the live posts and their views, shows the average length of drafts and compares categories side by side.

Use the target keyword column to stop two articles from chasing the same search phrase, and scan it before you approve a new idea. Record the word count at the draft stage so the average stays current. Once a post has been live for about a month, review its views and decide whether it needs a refresh, a new internal link or a fresh headline.

Useful for

  • Plan a monthly run of guides, news items and case studies
  • Spot articles that have stalled in draft or editing
  • Compare views by category to choose the next topic

What's included

  • 3 tabs: Dashboard, Posts, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Posts: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Posts tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I avoid two posts targeting the same keyword?

Sort the Posts tab by the Target keyword column before you approve a new idea. If a similar phrase already appears, either choose a different angle or merge the two plans into one stronger article. Duplicate targets split the traffic between pages.

How frequently should the Views column be refreshed?

Once a month is enough for most blogs. Take the figure from your analytics tool for a fixed date range, such as the last thirty days, so each update is comparable with the one before. Add a column for the update date if you want a history.

What does the meta description tick box mean?

Tick it after you have written the snippet that sits under the title in search results and checked its length. Leave it empty for drafts. The box helps you find live posts that still need a summary, since they often attract fewer clicks.

  • #content-calendar
  • #blog-post-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More content calendar templates

See all 8

Also in Marketing

All marketing templates
Get this template

Preparing your template…