The Content Audit Template

You cannot improve what you have not properly reviewed.

Find out what your last 30 posts have actually been doing. Then use that to make the next 30 work harder.

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.

£49. Pre-built Airtable base, three PDF guides and instant access. Delivered immediately on purchase.

You are posting consistently. The effort behind it is real and sustained.

Content goes out regularly. You show up week after week with genuine standards and genuine care about what goes out under your name. The consistency is there. The commitment is there.

And yet at the end of most months you still cannot say with any certainty what the content has actually produced. Which posts moved the right people closer to enquiring. Which ones performed well on the platform but produced nothing commercially. Which ones earned their place and which ones quietly took time without giving anything back.

The instinct when that happens is to post more. Try a different format. Switch to a different platform. Refresh the approach. None of those things fix the actual problem. The actual problem is that without a structured review of what your content has been doing every planning decision that follows it is based on habit and instinct rather than evidence.

So the next 30 posts end up looking a lot like the last 30. What worked gets repeated by accident. What did not work gets repeated too because without a structured assessment you cannot tell the difference. The content that was quietly moving the right people closer to enquiring gets no more of your time than the content that produced nothing at all.

That is not a content problem. It is a review problem. And a review problem does not resolve itself with more content. It resolves when you look back at what has actually been happening and build your next decisions on what the evidence shows.

The Content Audit Template is a pre-built Airtable base that gives your last 30 posts a structured, honest review. Not a general sense of what performed well. A specific, evidence-based assessment of what each post was actually doing, who it was for, what business objective it served and whether it earned the time you spent on it.

This is not a scheduling tool. It is not a content calendar. It is a retrospective review system that separates what is working from what is not so your next planning decisions are built on evidence rather than instinct.

You open the base, duplicate it into your free Airtable account and start entering your last 30 posts. Each post is assessed across 18 focused fields covering content pillar, format, message intent, buyer awareness stage, engagement, enquiries generated and your honest assessment of how it felt to create. The patterns surface automatically through four built-in views. You do not need to sort or calculate anything manually. The summary table does the analysis while you audit.

Most people complete their content audit in two to four hours. What they leave with is a specific, evidenced picture of what their content has actually been doing and a clear direction for what the next 30 days should look like based on what the evidence shows rather than what instinct suggests.

Why it matters

The Content Audit Template Results and Interpretation Guide from The Efficient Penguin Co., showing the guide cover with branded title on a deep charcoal background and a styled desk with an open notebook and laptop.

Every month without a structured review of what your content has been doing is another month of decisions made without evidence. The cost of that accumulates quietly over time in four specific ways.

What is working in your content keeps getting diluted because you cannot see it clearly enough to do more of it deliberately. The posts that are quietly moving the right people closer to enquiring are treated the same as the posts that produced nothing. The content that is earning its place gets the same amount of your time as the content that is producing nothing. Without a structured review what works and what does not stays invisible and the planning that follows stays based on feel.

What is not working keeps getting repeated because without a structured assessment you cannot tell the difference between content that is performing and content that is simply going out. The formats that consistently underperform. The pillars you are relying on too heavily. The posts that take the most time and produce the least return. All of it continues because there has never been a structured moment to look at it honestly.

The decisions about where to focus your content effort stay based on instinct rather than evidence. Which platform to prioritise. Which format to invest more time in. Which topics to pursue and which to pull back from. Each of those decisions has a right answer that the data in your last 30 posts could give you. Without a structured review the answer stays a guess.

And the question of whether you should still be the one creating the content stays unanswered. Because without data showing what your content costs you in time and what it produces in return that decision cannot be made honestly. Most established service providers who complete the audit for the first time are genuinely surprised by both numbers. The time it actually costs. And the return it is actually producing. That is the most commercially useful thing the audit gives you.

Why I built this content audit tool, and what that means for you

Before building The Efficient Penguin Co., I spent 12.5 years in professional investigation and evidence gathering, followed by 18 months in leadership and quality assurance. That background gave me one habit I have never been able to work around, following what the evidence actually shows rather than what anyone hopes it might.

When I looked at my own content, I didn't have a structured way to review it honestly. Analytics platforms show numbers but they don't show whether your content is doing the actual job it's supposed to do, which is move the right people closer to working with you. So I built a system that does.

I ran my own 30-post social media content audit using this exact base before making it available. It surfaced patterns I hadn't seen and changed how I approach my own content decisions. It's a working tool, built on the same investigative principle that shapes everything I do: structure the data first so the decisions you make from it are based on what is actually there, not what you assumed.

Introducing the Content Audit Template

A pre-built Airtable content audit tool for established UK service providers. Open it, enter your last 30 posts, answer 18 focused fields for each one, and the base surfaces the patterns automatically.

This is not a course. There are no modules to work through before you start. You open it, work through it in a focused session, and finish with a clear picture of what your content has been doing, what to keep, what to change, and what to stop.

Most people complete their content audit in two to four hours.

What is inside, and what each element does for you

You start seeing patterns within hours, not weeks

The pre-built Airtable base has 30 pre-populated rows, one per post, already linked to the summary table. Open it, duplicate it into your free Airtable account, and you are auditing in minutes. No building from scratch, no setup beyond one click.

Every post gets asked the questions it has never been asked

18 fields per post cover content pillar, format, message intent, buyer awareness stage, engagement, enquiries generated, how writing it felt, and your honest assessment. Not vanity metrics. The specific questions a structured social media content audit needs to answer to separate what is working from what is not.

The patterns surface without manual sorting

Four built-in views, including a best performing posts filter, pillar breakdown and format breakdown, make the patterns visible automatically. You see which pillars you are over-relying on, which formats consistently underperform, and which posts earned their place without having to work it out yourself.

The summary does the analysis while you audit

The linked summary table and interface report with bar charts and totals give you a clear picture of the full 30-day period. This is where the content audit tool earns its place. The summary shows you the full picture so your decisions are based on the whole body of work, not individual posts.

Setup takes minutes, not days

The step-by-step setup guide uses screenshots from a real Airtable account at every stage. No prior Airtable experience needed. No figuring anything out for yourself.

You fill it in accurately, not just quickly

The completion guide walks through every field so you know exactly what each one is asking. The quality of your audit depends on the honesty of your entries. This guide makes sure you are answering the right question in each column.

You know what to do with what you find

The results interpretation guide explains in plain language what your summary table is telling you and specifically what to do with it. Knowing what worked is only useful if you know how to act on it. This guide closes that gap.

Works across every platform and format

Facebook, Instagram, LinkedIn, video, carousel, text posts. If you posted it, you can audit it.

Everything you receive for £49

Pre-built Airtable content audit base with 30 pre-populated rows and linked summary table - value £60
Step-by-step setup guide with full screenshots - value £15
Completion guide with field-by-field walkthrough - value £25
Results interpretation guide explaining what your findings mean and what to do next - value £25

Total value: £125

Your Investment: £49

My guarantee

The Content Audit Template is a digital product delivered immediately on purchase. Because access is provided instantly, I am not able to offer a refund once it's been delivered.

What I can guarantee is if the base does not work exactly as described, I will fix it. If the 30 pre-populated rows are not there, if the summary table is not linked correctly, or if anything in the setup guide is unclear, contact me at [email protected] and I will resolve it the same day.

At £49, the financial risk is low. The value is in what you learn about your content and what you decide to do differently because of it.

The Content Audit Template will be here whenever you are ready. There is no pressure and no deadline.

What is worth considering honestly is this. The last 30 posts you have published contain the most accurate picture available of what your content has actually been doing. That picture becomes less useful with every week that passes as new posts replace the ones that would tell you the most. The patterns that are currently visible in your recent content will not be as clear in another month.

The audit takes two to four hours. It costs £49. What it gives you is a specific, evidenced picture of what has been working, what has not and what your content has actually been costing you in time. Every planning decision that follows that picture is more accurate than every planning decision made without it.

The next 30 posts will be planned on something. The Content Audit Template is what makes that something evidence rather than instinct.

Questions you may have before you buy

Do I need to already use Airtable?

No. The setup guide walks you through creating a free account and duplicating the base step by step, with screenshots from a real account at every stage.

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

Use however many you have. The base works with any number of entries.

What if I want to review more than 30 posts?

You can add rows and link them to the summary table. Instructions are included in the setup guide.

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.

Is this a course or a training programme?

No. It's a ready-built Airtable system. Open it and start.

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

Spreadsheet tracking captures numbers. This captures the qualitative picture alongside the quantitative one. Message intent, buyer awareness stage, writing experience, honest assessment. That combination is what surfaces patterns a numbers-only approach misses and what separates the content worth compounding from the content worth stopping.

What is your refund policy?

Because the template is delivered immediately on purchase, I'm not able to offer a refund once access has been provided. If anything doesn't work as described, contact [email protected] and I'll fix it the same day.

Everything included. One payment. No subscription.

Pre-built Airtable content audit base with 30 pre-populated rows and linked summary table - value £60
Step-by-step setup guide with full screenshots - value £15
Completion guide with field-by-field walkthrough - value £25
Results interpretation guide - value £25

Total value: £125

Your one-time investment: £49.

How this fits with the Strategic Content Planner

If you use the Strategic Content Planner, this sits beside it. The Planner takes you forward. The Content Audit Template shows you what has already happened so the next round of planning is built on evidence rather than a fresh start.

If you don't have the Planner, the template works as a standalone content audit tool that feeds into whatever planning system you already use.

Either way the outcome is the same. A clear picture of what your content has been doing, what to keep and compound, and what to change, so the next 30 days are a deliberate set of decisions rather than a repeat of the last 30 by default.