Auditing Two Hundred Pages

I’ve lost count of how many times I’ve sat in a meeting with a founder who has just spent five figures on a “comprehensive digital asset audit” from a big agency. They’re handed a 60-page slide deck full of jargon and colorful charts, only to realize they have no idea how to actually use any of it. Most advice on how to audit existing content is designed to make you feel like you need a dedicated department and a massive budget just to see what’s working. It’s a total scam. You don’t need a complex framework or a month of data crunching; you just need to stop wasting time on things that aren’t moving the needle.

I’m not here to sell you a methodology that requires a PhD in data science. My promise is simple: I am going to show you how to figure out what to keep, what to fix, and what to kill without losing your entire week to the process. We are going to do this in a single afternoon, using nothing but your existing tools and a bit of common sense. No fluff, no enterprise nonsense—just practical steps you can actually finish before your next pub quiz.

Building Your Lean Content Inventory Spreadsheet

Forget the enterprise-grade software that promises “holistic ecosystem visibility.” You don’t need a subscription; you need a basic content inventory spreadsheet. Open a fresh Google Sheet and create four columns: URL, Topic, Last Updated, and Page Views (from the last 90 days). That’s it. If you spend more than twenty minutes setting up the columns, you’re procrastinating.

Once your list is populated, it’s time for the actual work. I want you to look at your numbers and start identifying low performing pages immediately. Don’t get bogged down in the nuances of why a post failed; if a page has zero traffic and hasn’t been touched in a year, it’s dead weight. I use this quick scan to spot what’s actually driving value versus what’s just digital clutter.

As you go through the list, keep an eye out for “zombie content”—those posts that used to work but have clearly lost their edge. This isn’t a deep-dive content decay assessment; it’s a triage. You are simply deciding which pages deserve ten minutes of your time to refresh and which ones should be deleted to clean up your site. Keep it moving.

Identifying Low Performing Pages Without the Headache

Stop trying to run a complex content decay assessment using enterprise-grade software that requires a PhD to navigate. You don’t need a dashboard with fifty moving parts; you just need to see what’s dead weight. Open your content inventory spreadsheet and look at your traffic numbers from the last ninety days. If a page has zero visits and hasn’t generated a single lead or inquiry, it’s not “brand building”—it’s just digital clutter.

I want you to focus on identifying low performing pages by looking for the outliers. Sort your list by page views. Anything sitting at the bottom of the pile for three months straight is a candidate for deletion or a total rewrite. Don’t get precious about old blog posts you wrote three years ago that no one reads; they are actively dragging down your site’s authority.

The goal here is optimizing content ROI with minimal friction. If a page is getting a handful of hits but zero conversions, it’s a broken link in your chain. Spend an hour deciding whether to fix the call-to-action or just pull the plug entirely. If you can’t find a way to make a page work within a single afternoon of tweaking, cut it loose.

5 Ways to Stop Wasting Time on Content That Doesn't Work

• Stop chasing SEO gurus. Pick your top 10 most visited pages from the last six months and look at them. If they aren’t converting or providing actual value, they are just digital clutter.
• Update the “dead” stuff. If a post from 2021 is still getting traffic but the links are broken or the stats are old, spend 45 minutes fixing the numbers and refreshing the links. It’s faster than writing something new.
• Kill your darlings. If you have a “pillar page” that’s a massive, 3,000-word slog that no one actually reads, delete it or chop it into three smaller, punchier posts. Length doesn’t equal authority.
• Check your calls to action. Most small business content fails because it ends abruptly. Spend an hour ensuring every single useful page has one clear, simple instruction for the reader.
• Group your winners. If you find three posts that all perform well on the same topic, don’t write a fourth. Link them together into a mini-resource hub so you keep the reader on your site longer.

The Three-Point Audit Checklist

Stop chasing vanity metrics; if a page isn’t driving a lead or a sale, it’s just digital clutter taking up space.

Don’t aim for perfection in your spreadsheet—if you can’t list your top 20 URLs in under an hour, you’re overthinking it.

Use your findings to make one quick fix, like updating a broken link or a dead CTA, rather than planning a month-long content overhaul.

Stop Overthinking and Start Cleaning

Look, we’ve covered the basics: you’ve built a lean spreadsheet that doesn’t require a PhD to navigate, and you’ve identified which pages are actually pulling their weight and which ones are just digital clutter. You don’t need a six-month strategic roadmap or a fancy dashboard to tell you that a blog post from 2017 with zero clicks is dead weight. The goal here wasn’t to build a monument to data; it was to identify what is actually working so you can stop wasting energy on the rest. You have the list, you have the numbers, and most importantly, you have a clear path forward without needing to hire an agency to tell you what you already know.

Now, the hardest part for most small business owners is actually pulling the trigger. It is tempting to keep adding new content to hide the fact that your old content is messy, but that is just digging a deeper hole. Take the wins you found today and double down on them. Update one good post, delete one bad one, and get back to running your business. Marketing shouldn’t be a full-time job that keeps you up at night; it should be a series of practical, repeatable actions that actually move the needle. Now, close this tab and go get something done.

Frequently Asked Questions

I don't have a fancy SEO tool; can I really do this with just a basic spreadsheet?

Please. If you need a $200-a-month subscription to tell you your blog posts aren’t working, you’re doing it wrong. You don’t need a dashboard; you need eyes and a spreadsheet. Open your Google Analytics or Search Console, grab your top URLs from the last six months, and dump them into your sheet. That’s it. If the data is there, you have everything you need to make a decision. Stop looking for a magic tool and start looking at your numbers.

How do I know if a page is actually "dead" or if it just needs a quick rewrite?

Check your traffic and your intent. If a page has zero hits and solves nothing, kill it. It’s dead weight. But if you see steady, albeit small, traffic, it’s not dead; it’s just tired. If the data shows people are landing there but leaving immediately, don’t delete it—just spend ninety minutes sharpening the headline and fixing the call to action. If it can’t be fixed in a single session, let it go.

What do I do once I've identified the bad content—do I delete it or fix it?

Don’t touch the delete key just yet. Deleting content can tank your existing traffic, even if it’s low-quality. Instead, give yourself a two-hour window to triage. If a page is salvageable, spend the afternoon updating the facts and sharpening the call to action. If it’s truly dead weight that serves no purpose, redirect that URL to your most relevant live page. Fix what’s useful, redirect what’s useless, and move on.

How much time should I realistically spend on this before I'm just wasting an afternoon?

Stop looking for perfection. If you spend more than ninety minutes staring at a spreadsheet, you aren’t auditing; you’re procrastinating. Set a timer for two hours. Use that time to flag the obvious winners and the absolute losers, then close the laptop. The goal is to find actionable data, not to build a museum of your digital history. If you haven’t made a decision by the time the timer dings, you’ve already lost the afternoon.