How to Do a Content Audit Using Google Search Console Data (Free Method)

Last quarter I finally sat down and audited all the content on one of my side project blogs. It had 47 published posts. I expected most of them to be doing at least something in search. The reality was painful. 19 of those 47 posts had exactly zero impressions over the previous 3 months. Not low impressions. Zero. Almost 40% of my content was invisible to Google.

After consolidating 8 of those posts, deleting 6, and updating the remaining 5, my overall impressions went up 22% in the following 6 weeks. Not because I created anything new, but because I removed the dead weight that was diluting my site's quality signals.

That experience convinced me that content audits are one of the most underrated activities in SEO. Everyone talks about publishing more content. Almost nobody talks about evaluating whether the content you already have is helping or hurting. Here is the exact process I use, and you can do the entire thing for free using Google Search Console and Google Sheets.

Why Content Audits Matter

Most websites accumulate dead weight over time. You publish posts, some perform well, some do not, and you move on to the next one. After a year or two, you end up with a significant chunk of content that Google has evaluated and decided is not worth showing to anyone.

This is not just a missed opportunity. It can actively hurt your site. Google evaluates your entire site when deciding how much to trust your content. If 30% of your pages are thin, outdated, or irrelevant, that drags down the perceived quality of your entire domain. This is especially true after Google's Helpful Content updates, which specifically target sites with a high ratio of unhelpful pages.

A content audit forces you to look at every page through Google's eyes and make a clear decision about each one. Keep it, improve it, consolidate it, or remove it. No page gets to just sit there doing nothing.

How to Export Your GSC Data

The first step is getting your data out of Google Search Console and into a spreadsheet where you can work with it.

Step 1. Open the Performance Report

Log into Google Search Console, click Performance in the left sidebar, and select Search Results. Enable all four metrics at the top: Total clicks, Total impressions, Average CTR, and Average position.

Step 2. Set the Date Range to the Last 3 Months

Click the date filter and select "Last 3 months." Three months gives you enough data to see real patterns without being skewed by seasonal fluctuations or one-off spikes.

Step 3. Switch to the Pages Tab

Below the chart, click the "Pages" tab. This shows performance data for every URL on your site that received at least one impression during the period.

Step 4. Export the Data

Click the Export button in the top right corner and choose Google Sheets or download as a CSV. If you choose Google Sheets, it creates a new spreadsheet automatically with your data already formatted.

The 4 Buckets to Sort Your Pages Into

Once you have your data in a spreadsheet, you need a framework for evaluating each page. I sort every URL into one of four buckets based on its performance data.

Bucket 1. Winners

Pages ranking in positions 1 through 4 with strong and growing click-through rates. These are your best performing pages. The action here is simple: leave them alone. Do not try to "optimize" a page that is already winning. You are more likely to break something than improve it.

The one exception is if a winner page has declining impressions over the 3-month period. That could signal early content decay, and a refresh might be warranted before it drops further.

Bucket 2. Striking Distance

Pages ranking in positions 5 through 15 with decent impressions but low clicks. These are your biggest opportunities. A page at position 8 with 2,400 impressions and 1.2% CTR is sitting on a goldmine. Small improvements to the content, title tag, or internal linking could push it to page 1 and multiply its traffic.

I wrote an entire guide on striking distance keywords that covers exactly how to identify and act on these opportunities. If you have never worked on striking distance optimization, that guide is the place to start.

Bucket 3. Underperformers

Pages that are indexed and have some impressions but almost no clicks. These are pages where Google has seen the content, decided it is somewhat relevant, but does not think it deserves a good ranking. Typical characteristics are an average position between 20 and 50, fewer than 10 clicks in 3 months, and content that is thin, outdated, or covers a topic you have addressed better in another post.

The action for underperformers is to update or consolidate. If the topic is still relevant, rewrite the content with better depth and freshness. If another page on your site covers the same topic more thoroughly, redirect the underperformer to that page and let the stronger page absorb its signals. Watch out for keyword cannibalization here, because underperforming pages are often the ones cannibalizing your better content.

Bucket 4. Dead Weight

Pages with zero impressions over the entire 3-month period. Google is not showing these pages to anyone for any query. They are invisible. A page at position 22 with 3 clicks in 90 days is an underperformer. A page with literally zero impressions is dead weight.

The action for dead weight depends on the content. If the topic is genuinely valuable and the content just needs a complete rewrite, update it. If the content is thin, outdated, or covers something nobody is searching for, either noindex it or delete it entirely. Removing dead weight is the fastest way to improve your site's overall content quality ratio.

Setting Up Your Audit Spreadsheet

Here is how I structure the spreadsheet after exporting from GSC.

Step 1. Clean Up the Raw Data

Your export will have columns for Page, Clicks, Impressions, CTR, and Position. Add a new column called "Bucket" and another called "Action." These are where you will record your decisions.

Step 2. Sort by Impressions

Sort the entire sheet by impressions from highest to lowest. Start your evaluation from the top. Pages with the most impressions represent the most traffic potential, so you want to evaluate those first.

Step 3. Color-Code by Bucket

Go through each row and assign a bucket based on the criteria above. I use green for Winners, yellow for Striking Distance, orange for Underperformers, and red for Dead Weight. Apply conditional formatting or manually highlight each row.

For a site with 50 pages, this takes about 30 minutes. For a site with 200 pages, budget about 90 minutes. It is tedious but you only need to do it once per quarter.

Step 4. Add Context for Each Page

For Striking Distance and Underperformer pages, add notes about what might be causing the low performance. Is the content outdated? Is the title tag weak? Is there a better page on your site covering the same topic? These notes will guide your optimization work over the next few weeks.

Step 5. Identify Pages Not in GSC at All

Your GSC export only includes pages that received at least one impression. But you might have published pages that Google never showed to anyone. Cross-reference your export against your full list of published URLs (check your sitemap or CMS). Any page that does not appear in the GSC data at all is either not indexed or has been completely ignored by Google. Add those to the Dead Weight bucket.

What to Do With Each Bucket

After sorting, here is your action plan for each bucket.

Winners (green). Monitor monthly. Set a calendar reminder to check these pages each month for any decline in impressions or position. Otherwise, do not touch them.

Striking Distance (yellow). Prioritize these for optimization in the next 2 to 4 weeks. For each page, evaluate the title tag, content depth, internal linking, and whether the content matches the search intent of its primary keyword. Even small improvements can push a page from position 8 to position 4 and double or triple its traffic.

Underperformers (orange). Schedule these for content updates over the next 1 to 2 months. For each page, decide whether to update, consolidate into a stronger page, or redirect. If two pages target the same keyword, always consolidate. Two weak pages will never outperform one strong page.

Dead Weight (red). Handle these immediately. For each page, choose one of three actions. Update the content completely if the topic is still valuable. Redirect to a related, stronger page using a 301 redirect. Or noindex the page to remove it from Google's index while keeping it live for anyone who has a direct link.

How Often to Repeat This

Quarterly is the right cadence for most sites. Every 3 months, export fresh GSC data and re-evaluate your pages. Content that was performing well last quarter might have started decaying. New posts you published might have entered the Striking Distance bucket and need optimization work.

I mark it on my calendar for the first Monday of every quarter. The entire process takes 1 to 2 hours depending on the size of the site. That investment pays for itself many times over in recovered traffic and cleaner site architecture.

If you want to skip the manual spreadsheet work, GSCdaddy automates the content decay detection by continuously monitoring your Google Search Console data. It flags pages that are losing rankings or impressions over time and gives you AI-powered recommendations for what to do about each one. But the manual process described in this guide works perfectly well on its own, especially for sites with fewer than 100 published pages.

Frequently Asked Questions

How often should I do a content audit?

Quarterly is the sweet spot for most sites. It is frequent enough to catch content decay before it costs you significant traffic, but not so frequent that you are constantly auditing instead of creating. If your site publishes more than 10 posts per month, consider auditing monthly.

Should I delete underperforming pages or try to fix them first?

Try to fix them first unless the content is completely irrelevant or outdated beyond repair. Update the content with fresh information, improve the title and meta description, add internal links from stronger pages, and give it 6 to 8 weeks to respond. If it still shows zero impressions after that, consolidate it into a related page or remove it.

Can a content audit hurt my rankings if I delete or noindex pages?

Removing genuinely low-quality pages typically helps your overall site quality in Google's eyes. However, do not noindex or delete pages that still receive organic traffic, even if the traffic is small. Focus on pages with zero impressions and zero clicks over a 3-month period. Those pages are not contributing anything and may be dragging down your site's average quality.

What is the difference between a content audit and a technical SEO audit?

A content audit evaluates the performance and quality of your individual pages and posts. You are asking whether each piece of content is helping or hurting your site. A technical SEO audit focuses on infrastructure like crawlability, site speed, mobile usability, and indexing issues. Both are important, but they answer different questions. A content audit tells you what to write, update, or remove. A technical audit tells you what to fix.

How much GSC data do I need before running a content audit?

You need at least 3 months of data to make confident decisions. With less data, you might delete a page that was simply in a seasonal dip or had not been indexed long enough to find its audience. If your site is brand new with less than 3 months of GSC data, wait before running a full audit.