How to Run a Content Marketing Audit in One Afternoon

by | Aug 6, 2026

Ahrefs studied roughly 14 billion webpages and found that 96.55% of them get no traffic from Google at all. A handful of those dead pages are almost certainly sitting on your site right now, quietly absorbing budget and crawl attention. A content marketing audit is how you find them, and it does not have to be a six week project with a 40 tab spreadsheet. The version that actually changes what you publish next month fits in a single afternoon.

Key Takeaways

  • Most of the value in a content marketing audit comes from about 20 URLs. Audit the pages that already have impressions and skip the rest.
  • Four hours is enough for a full content marketing audit: one hour pulling data, one hour sorting URLs into five buckets, one hour checking content marketing KPIs, one hour building the action list.
  • Pages sitting at average position 8 to 20 with steady impressions are your highest return fixes, because they are close enough to page one that a rewrite moves them.
  • Deleting content is the most over prescribed advice in this space. For a site under 100 pages, consolidating usually beats pruning.
  • If you have published fewer than 15 pages, skip the audit entirely and go publish. There is nothing to analyze yet.

What a Content Marketing Audit Actually Tells You

A content marketing audit answers three questions, and only three. Which pages are earning attention, which pages are close to earning attention, and which pages are dead weight.

Everything else is decoration. A pattern we see constantly in the accounts we audit is a beautifully formatted 200 row spreadsheet scoring every page on tone, brand voice, readability, and image quality, with no column anywhere for whether the page produced a lead.

That confusion is widespread. In the Content Marketing Institute’s annual B2B research with MarketingProfs, 56% of marketers named difficulty attributing ROI to content as their top measurement problem, and 58% rated their own content strategy as only moderately effective.

Here is what a content marketing audit will not do. It will not create demand that does not exist. If nobody in your service area is searching for what you sell, no amount of sorting and scoring fixes that, and a keyword research project is the better use of your afternoon.

What You Need Before You Start Your Content Marketing Audit

Setup takes about 20 minutes. Do it before you block the four hours, or you will burn the first hour hunting for logins.

The five minute checklist:

  • Google Search Console access with at least 12 months of data
  • Google Analytics 4 with at least one conversion event configured, ideally form submissions and phone clicks
  • A crawl of your site (Screaming Frog is free up to 500 URLs, which covers most local business sites)
  • A blank Google Sheet
  • Your CMS open in another tab so you can see publish and last modified dates

That is the whole stack. You do not need an enterprise platform for this, and if you are weighing options, our breakdown of content tools for small teams covers what is worth paying for at different sizes.

One warning on Search Console. Set your date range to the last 12 months and export from the Pages tab, not the Queries tab. Query level data will pull you into rabbit holes you do not have time for today.

The Four Hour Content Marketing Audit, Hour by Hour

This is the sequence we use internally. It is deliberately rigid, because the failure mode of every content marketing audit is curiosity. Follow the clock.

Hour 1: Pull the Data and Build One Sheet

Export the Search Console Pages report for the last 12 months. Export a GA4 report with landing page, sessions, engaged sessions, and conversions for the same period. Export your Screaming Frog crawl with URL, title tag, meta description, word count, and internal inlinks.

Paste all three into one sheet and match them on URL. VLOOKUP or XLOOKUP is fine. You want one row per URL with these columns:

URL, impressions, clicks, CTR, average position, sessions, engaged sessions, conversions, word count, internal inlinks, last modified date.

Now the step most guides skip. Delete every row with fewer than 30 impressions in 12 months. On a typical 80 page local business site, that removes 40 to 55 rows and leaves you with the pages Google is actually willing to show. Those deleted URLs are not lost, they just go in the Retire pile by default and you will spot check them in hour four.

Your working set should be 20 to 40 URLs. If it is bigger than 60, sort by impressions and take the top 60.

Hour 2: Sort Every URL Into Five Buckets

Add a column called Bucket. Every URL gets exactly one label, no hedging, no “maybe.”

BucketWhat it looks like in the dataThe action
KeepAverage position 1 to 7, stable or rising clicks, at least one conversion in 12 monthsLeave it alone. Recheck in six months.
RefreshAverage position 8 to 20, impressions steady or growing, clicks flat or fallingRewrite the first 200 words, add the subtopics you skipped, update every date and statistic
ConsolidateTwo or more URLs ranking for the same query, none in the top 10Merge into one strongest page, 301 the others into it
FixAverage position 5 or better but CTR under 2%Rewrite the title tag and meta description only. Do not touch the body copy.
RetireUnder 30 impressions in 12 months, zero conversions, fewer than three internal inlinksNoindex, redirect to a relevant page, or merge the useful paragraphs elsewhere

Sorting 40 URLs takes about 45 minutes once you stop debating. Give yourself 60 seconds per URL and move on.

The Refresh bucket is where the money is. Ahrefs data shows that 72.9% of pages ranking in Google’s top 10 are more than three years old, which tells you something useful: age plus updates beats brand new content more often than people expect. A page stuck at position 12 with 4,000 annual impressions is worth more attention than any blank document.

Hour 3: Check the Content Marketing KPIs That Change Decisions

You have buckets. Now sanity check them against performance, because raw position numbers lie in a few predictable ways.

Work through these thresholds in order:

KPISourceFlag it when
Impressions, 12 monthsSearch ConsoleUnder 30 (retire) or over 2,000 with under 50 clicks (fix the title)
Average positionSearch ConsoleBetween 8 and 20 (refresh candidate)
CTRSearch ConsoleUnder 2% while ranking position 5 or better
Engaged sessions rateGA4Under 40% on a page over 1,200 words
Conversions, 12 monthsGA4Zero on a page with more than 500 sessions
Internal inlinksScreaming FrogFewer than three pointing at a Refresh or Keep page
Last modifiedCMSOlder than 18 months on any commercial page

Two of those deserve explanation. Zero conversions on a high traffic page usually means the page has no offer on it, not that the topic is bad. Fewer than three internal inlinks on a page you care about is the cheapest fix in the entire content marketing audit, and it takes about four minutes per page.

With our health and wellness clients, the internal linking gap is almost always the biggest single miss. Service pages get linked from the nav and nothing else, while ten blog posts about the same treatment sit there pointing nowhere. If that sounds familiar, our guide to how search and content work together walks through the structure that fixes it.

Hour 4: Turn the Sheet Into an Action List

A spreadsheet nobody acts on is a hobby. Spend the last hour converting buckets into a dated task list.

Rank the work by effort against impact, in this order:

  1. Title and meta rewrites for every Fix bucket URL. Roughly 15 minutes each, results show inside two to four weeks.
  2. Internal link additions for Keep and Refresh pages. About five minutes each.
  3. Consolidations. One to two hours each including redirects. Do these before refreshes so you are not rewriting a page you are about to merge.
  4. Refreshes, in descending order of impressions. Budget three to five hours per page if you are doing it properly.
  5. Retirements. Batch them into a single session at the end of the quarter.

Cap the list at 12 items. A content marketing audit that generates 47 tasks produces zero completed tasks, which we have watched happen more times than we would like.

One more pass worth making. Your top three Keep pages are proven audience interest, so they are the obvious candidates to turn into video, short form clips, or a lead magnet rather than starting a new topic from scratch. That is usually the most valuable output of the whole exercise, and it is where creative production help pays for itself faster than net new blog posts.

The Content Marketing Analytics Traps That Skew Your Read

Your numbers are not neutral. Three things distort content marketing analytics badly enough to change your bucket assignments if you do not account for them.

AI Overviews are suppressing clicks without suppressing impressions. Ahrefs found that AI Overviews are associated with a 58% lower average CTR for the top ranking organic result. If a page held its position but lost half its clicks over the past year, check whether an AI Overview now appears for its main query before you label the page a failure.

GA4 and Search Console will never match, and that is fine. Search Console counts clicks from Google. GA4 counts sessions from everywhere, minus whatever ad blockers and consent banners eat. Expect a 10% to 30% gap and stop trying to reconcile it.

Averaged position is an average. A page showing average position 11 might be ranking 4 for one query and 40 for eight others. Before you refresh, open the query filter for that single URL and check what it actually ranks for.

Honest caveat here. If your site gets fewer than 500 organic sessions a month, your content marketing analytics do not contain enough signal to support confident decisions. Run the content marketing audit anyway for the structural fixes, titles, internal links, consolidations, but treat the performance conclusions as directional. Attribution gets meaningful somewhere north of that threshold, and our content marketing ROI breakdown covers how to measure it when volume is still small.

If your best pages deserve better assets than a stock photo and a text block, that is exactly what a video production team is for.

Common Mistakes That Ruin a Content Marketing Audit

After enough of these you learn that a content marketing audit fails in the same five ways.

Auditing everything. The instinct is to be thorough. Thoroughness is why 70% of content audits are abandoned somewhere around row 120. Filter to pages with impressions and accept that you are ignoring the long tail on purpose.

Deleting too aggressively. Pruning became popular advice because it worked on sites with 10,000 pages of thin syndicated junk. On a 60 page local business site, deleting 20 pages mostly removes internal linking surface area and a few long tail entry points. Consolidate first, retire only what is genuinely orphaned and unconverting.

Scoring quality without a rubric. “This page feels thin” is not a finding. Google’s own documentation on creating helpful, reliable, people first content gives you a usable question set: does the page show first hand experience, does it answer the question completely, would someone bookmark it. Score against those, not vibes.

Refreshing without changing anything. Updating the publish date and swapping two adjectives is not a refresh. A real refresh means new sections, updated numbers, better examples, and a rewritten opening. Anything less is a date change that Google sees straight through.

Doing it alone every time. You wrote the content, so you cannot see it clearly. Once a year it is worth having an outside look at your online marketing specifically because an outsider has no attachment to the post you spent nine hours on.

There is a sixth mistake worth naming: auditing traffic when your problem is conversion. If your Keep pages get sessions and produce nothing, the fix lives in offers and calls to action, not in content. Our notes on turning content into leads go deeper on that gap.

Where to Start This Week

Block four hours for the content marketing audit. Pull the three exports, cut everything under 30 impressions, and sort what remains into the five buckets. You will finish with a 12 item list and a much shorter opinion about what to publish next quarter.

If you would rather have someone else run the content marketing audit and hand you the action list, that is work we do regularly for local and wellness brands, and it usually surfaces two or three fixes worth more than a quarter of new posts. Wake and Make Media was founded by Corey Turner and Megan Nager, who produced content for UFC, Amazon, MTV, and Professional Bull Riding before setting up in Stuart, Florida to work with local businesses. Tell us what you are publishing now and we will show you where the content creation budget is actually going.

Frequently Asked Questions

How long does a content marketing audit take?

For a site under 100 pages, four focused hours is enough to produce a prioritized action list. Larger sites with 500 or more URLs need one to two full days, mostly because crawl processing and query level analysis take longer. The audit itself is fast, but implementing the findings typically spans four to eight weeks.

How often should you run a content audit?

Once a year is the right cadence for most small businesses, with a lighter quarterly check on your top 20 pages. Audit sooner if you have had a traffic drop of 20% or more, migrated your site, or changed your service offering. Auditing more frequently than quarterly usually means you are analyzing instead of publishing.

What are the most important content marketing KPIs to track?

Impressions, average position, click through rate, engaged session rate, and conversions per page cover the majority of decisions. Impressions tell you whether Google will show the page, position and CTR tell you whether people click, and conversions tell you whether the page earns its place. Track internal inlinks alongside those, because it is the cheapest lever you have.

Should you delete underperforming blog content?

Usually not on a small site. Consolidate pages competing for the same query into one stronger page and redirect the rest, which preserves any links and long tail rankings they had. Reserve deletion or noindexing for pages with zero impressions, zero conversions, and no internal links after 12 months.

Do you need paid tools to run a content marketing audit?

No. Google Search Console, GA4, a spreadsheet, and the free tier of Screaming Frog handle everything described above for sites up to 500 URLs. Paid tools like Ahrefs or Semrush add competitor comparison and keyword gap data, which is useful once you are past the basics but not required for your first audit.

Pick a Tuesday afternoon, run the four hours, and you will know exactly what to fix before you write another word.

Corey Turner

Corey Turner

Corey Turner Co-Founder & Creative Director | Wake & Make Media Corey Turner is a Hollywood-trained filmmaker turned digital marketing strategist who has spent over a decade creating content that moves people, and moves products. With credits spanning UFC, Google, Amazon, and Ryan Reynolds, Corey knows exactly what separates scroll-stopping content from everything else. As co-founder of Wake & Make Media, he writes about video production, social media advertising, and digital marketing strategies that actually work, because he's built and tested them in the real world. Every article on this blog comes straight from the field, not a textbook. Have a question or ready to grow your brand? Reach Corey directly at (772) 247-1974.
Gym and Fitness Studio Marketing: How Local Studios Win Members Online

Gym and Fitness Studio Marketing: How Local Studios Win Members Online

Short answer How does a gym marketing agency help local studios win members online? A gym marketing agency gets a local studio found on Google Maps and search, runs Google search ads for people ready to join and Instagram and Facebook video ads for people who aren't...

Med Spa Marketing: How to Keep Your Calendar Booked Out

Med Spa Marketing: How to Keep Your Calendar Booked Out

Med spa marketing agency is usually hired to solve a traffic problem. In the accounts we audit, the empty slots almost always trace back to something else: slow replies to new inquiries, weak local search visibility, and past patients who never got asked to come back....