The Content Audit Template

Find Out What Your Last 30 Posts Actually Did

You scroll back through last month's posts and cannot tell which ones worked to support your business growing. A few got likes, one or two got a comment, and the rest just sit there, published and forgotten, with no way of knowing whether any of it moved your business forward. What you actually want is simple, a proper content audit, not a guess.

The Content Audit Template How To Complete Guide from The Efficient Penguin Co., showing the guide cover with branded title on a deep charcoal background and a styled desk with a laptop and white lamp.

You Are Not Ready To Hand This Over. You Just Want To Know How You Are Actually Doing.

You know social media supports your business, this has never been in question, and posting where you can has been the reality, around everything else the business actually needs from you. You are not looking to hand it over, you are curious, and you want to know what is actually working, so you know what is worth improving and what is already assisting the business enough to simply keep doing.

There is a gap between wanting to improve and having any real way to see what is worth improving, or protecting. Nobody ever sat down with you and turned a scroll back through your last 30 posts into something you could actually learn from, week to week, on your own, so the not knowing just sits there quietly, the same way it did last month, and the month before that.

The Content Audit Template is a content audit built specifically for social media, structured in Airtable, that gives your last 30 posts a structured, honest review instead of a general impression. Each post is assessed across 17 focused fields, content pillar, format, message intent, buyer awareness stage, engagement, enquiries generated, and how it actually felt to create, so nothing is left to memory.

Picture opening it and finally seeing, properly, which pillars you have leaned on too heavily, which formats quietly underperform every time, and which single post this month did more work than the rest of them combined. That is the shift, from a vague sense that some things work better than others, to a specific, evidenced picture you can actually act on.

I built this content audit tool because I did not have a structured way to review my own content honestly. Analytics platforms show numbers, but they do not show whether your content did the actual job it was supposed to do, moving the right people closer to working with you. So I ran my own audit using this exact base before I ever offered it to anyone else, and it surfaced patterns I had not seen, patterns that have changed how I plan every month since.

What Is Inside

30 pre-populated rows, linked to a summary table

Open it, duplicate it, and you are auditing within minutes, no building from scratch. Need to review more than 30 posts? Add as many rows as you need.

17 focused fields per post

Content pillar, format, message intent, buyer awareness stage, engagement, enquiries generated, and your honest reflection, not vanity metrics.

Four built-in views

A best-performing filter, a content format breakdown and a content pillar breakdown, so the patterns surface without you sorting or calculating anything.

Three honest reflection fields per post

What worked, what you would change, and whether you would post it again, so the data tells you more than any platform analytics dashboard ever will.

A summary that does the analysis for you

Bar charts and totals across the full 30-day period, so your decisions are based on the whole body of work, not one post in isolation.

Works across every platform

Facebook, Instagram, LinkedIn, video, carousel, text, if you posted it, you can audit it, on whichever platforms you actually use.

Use it every month

The same base works again and again, and like the Strategic Content Planner, Airtable's free plan holds up to 1,000 records, so once you eventually reach that limit, a fresh, empty duplicate takes a couple of minutes and you carry straight on.

Setup guide, completion guide, and results interpretation guide

Three short guides that walk you from opening the base to knowing what your results mean and what to do about them.

Everything you receive for £49

Content audit template Airtable base (valued at £125)
30 posts already structured and waiting, 17 fields each, linked straight to a summary table that does the analysis while you work, so patterns surface without you sorting anything by hand.
Step-by-step setup guide (valued at £25)
Screenshots from a real Airtable account for every stage, so nothing about getting started needs figuring out alone.
Completion guide (valued at £50)
A field-by-field walkthrough so you know what every column is actually asking, because the quality of your audit depends on the honesty and accuracy of what goes into it.
Results interpretation guide (valued at £50)
Plain language explaining what your summary table is telling you, and specifically what to do next, because knowing what worked is only useful once you know how to act on it.

Total value: £250

Your Investment: £49

This is a digital product delivered immediately, so once access is provided, I am not able to offer a refund. What I can guarantee is that everything included is built to the same standard I bring to every piece of work I do, and if the base does not work as described, contact me and I will fix it the same working day.

How This Pairs With The Strategic Content Planner

Used together, the Content Audit Template and the Strategic Content Planner give your content a strong foundation, real answers about what is working and what is not, so nothing gets planned on a guess and no more time gets spent creating something that was never going to work. The audit shows you what has already happened, the planner takes that forward, and completing your audit first means every planning session after it starts from evidence instead of a blank page. If you do not have the Planner yet, the template still works on its own, feeding into whatever planning process you already use.

If The Data Tells You Something Bigger

Sometimes what the audit finds is not a formatting fix, it is confirmation that content has never really been the problem, or that creating it yourself is costing you more than it is giving back. If that is what your results show, the Brand Alignment Audit or Social Media Management are the honest next steps, worth knowing they exist once you know what your own data says.

FAQs

Do I need to already use Airtable?

No prior experience is needed, the setup guide walks you through everything from scratch.

What if I have posted fewer than 30 posts in the last month?

Use whatever you have. Even a smaller sample still surfaces real patterns worth knowing.

What if I want to review more than 30 posts?

You can add as many rows as you need. Each new row links to your summary table with one extra step, selecting it from the Summary Link field, and your results update automatically from there.

Can I keep using this every month?

Yes. The same base works for as long as you are posting. Airtable's free plan allows up to 1,000 records, so once you eventually reach that limit, duplicating a fresh, empty copy takes a couple of minutes and you carry straight on.

What platforms does it work for?

Any platform where you publish content. Facebook, Instagram, LinkedIn, and any combination of formats including video, carousel and text.

How long does it take to complete the audit?

Most people complete their social media content audit in two to four hours depending on how they access their post history.

I already track my post performance in a spreadsheet. Is this different?

A spreadsheet shows you numbers. This asks the commercial questions behind them, what each post was actually for, and whether it earned the time you spent on it.

What is your refund policy?

Because this is a digital product delivered immediately, I am not able to offer a refund once access has been provided. If anything about access goes wrong, I will fix it the same working day.