Content Planner Dashboard Spreadsheet

About this template

This content calendar tracks where every post came from, not only when it goes out. It is for creators and small brands who turn one idea into a Reel, a carousel, a Short and a newsletter, and want to know which ideas, formats and platforms actually work.

Please read: This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).

The dashboard

Nothing on the dashboard is typed. Pick any month or the full year and the page follows.

• Reach from your published posts, month by month, and posts published with the change on the month before
• Posts by month: published, still in the works and missed, with reach over it
• Pillar mix: the share each content pillar got, next to the share you wanted
• Posting consistency: every day of the year, shaded by how many posts went out
• Posted as planned, and a pipeline showing where every post stands from idea to published
• Engagement rate by platform, and the next ten posts not out yet

Content repurposing, tracked

Every post on the Content Plan carries the idea it came from. You can see which ideas you have used fully, which became one post and stopped, and the reach and engagement rate for each idea rather than each post. Ideas used only once are flagged, so a good idea does not get retyped four times or forgotten.

Cadence and engagement

• Cadence: what you actually published each week across eight platforms, against the number you set, marked hit, close or short, with weeks where something was planned and nothing went out flagged
• An engagement tracker that calculates the rate on every post, then ranked by format, platform, content pillar and funnel stage: reach, nurture and convert
• Pillars: the share you wanted against the share you got, with drift flagged
• Platform followers gained and lost, against how much you posted that month

Sixteen connected tabs

Start Here, Setup, Brand, Pillars, Goals, Ideas, Content Plan, Repurposing, Cadence, Calendar, Hashtags, Collaborations, Content Analytics, Platform Analytics, Finance and Dashboard.

• A Content Plan with room for 400 posts
• A six-week calendar that reads the plan instead of being retyped
• Hashtags grouped by size, and collaborations with a cost per thousand reached
• Charts and figures that redraw from your own numbers, not static pictures

Light and dark editions

Every download includes a light edition and a dark mode template edition, with every tab restyled and the same formulas in both. Each comes as a blank copy and filled with half a year already planned and published: 62 posts, 54 of them live and 245,000 reach. It works as an Instagram planner, a TikTok planner or a social media planner across all eight platforms, and is built without TEXTJOIN so older Excel versions open it cleanly.

Works with

• Microsoft Excel 2016 or later, on Windows or Mac
• Google Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.
• No dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice
• No subscription

What you download

• Light edition: the Excel workbook filled with a worked example, and a blank one
• Dark edition: the same two files in the dark design
• The instruction guide, with one-click links to the Google Sheets versions (light and dark, filled and blank)
• The terms of use as a PDF

Your files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.

Frequently asked questions

Does it work in Excel or Google Sheets?

Both. The Excel workbooks run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.

How does the repurposing tracking work?

Every post on the Content Plan is linked to the idea it came from, so the Repurposing tab shows how many formats each idea became and flags ideas used only once.

Does it calculate engagement rate for me?

Yes. Engagement rate is calculated on every post and ranked by format, platform, pillar and funnel stage.

How many posts and platforms can it handle?

The Content Plan holds 400 posts, and cadence is measured across eight platforms.

Is it filled in or blank?

Both are included. One copy has half a year of example posts already planned and published, and the other is blank for your own content.