How to Run a Content Audit in 30 Minutes: Template and Decision Matrix

Content audits often become multi-week projects: hundreds of URLs are exported, a complex spreadsheet is built, and the team still does not know where to start. For a small or medium-sized website, the first useful audit can be much simpler.

You cannot review every sentence in 30 minutes. You can, however, identify the pages with the greatest growth potential, detect duplication, and create a concrete worklist for the next month.

This guide provides a copyable spreadsheet structure, a decision matrix, and a prioritisation formula you can use immediately.

What you need

• Google Search Console data for the last 90 days;
• the previous 90-day period for comparison;
• GA4 if you want to include leads and key events;
• Google Sheets or Excel;
• approximately 30 minutes for the first prioritisation pass.

Use clicks, impressions, CTR, and average position from the Search Console Performance report. Break the data down by query, page, country, and device when necessary. When combining Search Console and GA4, use matching date ranges and filters.

Copyable content-audit spreadsheet

Paste this tab-separated row into Google Sheets or Excel.

URL	Page type	Primary topic/cluster	Clicks 90d	Impressions 90d	CTR	Average position	Leads/key events	Internal links in	Last updated	Business value 0–3	Decision	Priority	Notes

Do not begin with the entire website. Start with 20–50 important service pages and articles that already receive impressions or support a commercially important service.

The 30-minute workflow

Minutes 0–5: export the data

In Search Console, select the last three months, compare them with the previous period, and export the Pages tab.

Do not assess performance by position alone. Start with changes in clicks and impressions. Average position is a useful diagnostic signal, but it varies by country, device, and personalisation.

Minutes 5–10: clean the list

Separate:

• legal and privacy pages;
• thank-you and technical form pages;
• parameter URLs;
• redirects, 404s, and 410s;
• language variants of the same page.

Do not delete these pages automatically. Simply assess them separately from commercial and informational content.

Minutes 10–20: assign a decision

Choose one action for each page.

Keep — the page earns clicks or leads, remains accurate, and has a clear purpose.

Update — the page receives impressions and ranks approximately 4–30, but its content, title, examples, or offer is outdated.

Merge — several URLs answer the same search intent and compete with one another. Choose the primary URL, consolidate the useful content, and only then create a 301 redirect.

Repackage — the topic is useful but the format does not meet the user's need. Turn a generic article into a checklist, calculator, comparison, or template.

Noindex — the page is useful to visitors but should not appear in search. Keep it crawlable so Google can read the `noindex` directive.

Remove — the page has no demand, links, business value, or suitable replacement. Use a 301 only when an exact equivalent exists. Otherwise, a genuine 404 or 410 is better than redirecting to the homepage.

Minutes 20–25: calculate the opportunity score

Use this formula:

Opportunity score = demand + ranking proximity + business value + ease of improvement

Score each factor from 0 to 3.

• 9–12: complete this sprint;
• 6–8: schedule this month;
• 0–5: backlog, merge, or consider removal.

This is not a Google formula. It is a simple internal model for making consistent decisions.

Minutes 25–30: create five tasks

Do not build a list of 80 tasks. Choose only the five highest-scoring pages and record for each one:

1. 1.which search intent the page serves;
2. 2.what must change in the title and introduction;
3. 3.which information or example is missing;
4. 4.which 2–4 pages should link to it internally;
5. 5.which metric you will review after 28 days.

Quick decision matrix

Worked example

Assume a company has an SEO service page and three articles about technical audits, semantic mapping, and Search Console.

The service page earns few clicks but carries high business value. The articles earn impressions but rarely lead visitors to the service. The solution is not to delete them, but to build a clear topic cluster:

• add contextual links from the articles to the service page;
• link from the service page to the detailed guides;
• check whether the articles answer an identical intent;
• update the articles with fresher examples and a clear next step.

Use the semantic-core methodology to map themes to pages. Diagnose technical problems with a technical SEO audit, and analyse real queries in Google Search Console.

Copyable content-update brief

Page:
Primary search intent:
Query cluster:
Current 90-day data:
Main problem:
What must be preserved:
What must be added or rewritten:
Missing evidence, examples, or data:
Internal links to add:
CTA and next user step:
Metric to review after 28 days:
Owner and deadline:

Common mistakes

• deleting a page because it had no clicks in a single month;
• redirecting every old URL to the homepage or a generic service hub;
• looking only at average position;
• rewriting copy without checking the result format and intent;
• creating a new article when an existing page can be improved;
• failing to add links from older, stronger content;
• not measuring the result after the update.

How often should you audit content?

Run a light review every month: sharp click or impression declines, pages ranking 4–20, and new articles without internal links. Run a complete audit every quarter, including update, merge, and removal decisions.

If visitors reach the page but do not take the next step, also check the UX issues that cause people to leave a website.

Conclusion

The purpose of a content audit is not to build an impressive spreadsheet. It is to decide where to invest time, which topics to consolidate, and which content no longer helps the user or the business.

If you need a content system that connects useful articles with commercial pages, explore our content marketing services. For technical and organic-search improvements, see our SEO services.

Frequently asked questions