12 November 2026
SEO content audit: decide what to keep, update or remove
Download the content audit worksheet (.xlsx)An SEO content audit is a review of the pages you already have: what each one helps a visitor do, whether its information is reliable, how people find it and what should happen next. The output should be a reasoned action list, not a spreadsheet of red warnings or an instruction to delete every article with little traffic.
This guide uses existing Craig Campbell blog posts as inspectable examples. The worksheet includes their real titles and addresses, but leaves search and enquiry figures blank. No private analytics or client results have been used. Suggested decisions are editorial starting points, not findings that these pages are underperforming.
Download the SEO content audit worksheet
Use the Excel workbook linked above. It contains an Instructions tab, six example articles and a blank Audit sheet with 50 starting rows. Open it in Excel or import it into Google Sheets. Choose an action and priority from the dropdowns, record the evidence and assign an owner before changing a page. You do not need to submit your email address to download it.
What does a content audit cover?
Start with purpose, accuracy, usefulness and performance. A technical crawl can identify broken links and indexing settings, but cannot decide whether an explanation is genuinely helpful. Read the page. Google's people-first content guidance asks whether it provides original value, a useful description and a heading that honestly represents the subject.
This is an editorial audit, not a replacement for the separate indexing diagnosis, keyword cannibalisation investigation or content brief. Those guides help with particular problems you may identify during the review.
SEO for small business: keep the content audit manageable
SEO for small business does not require reviewing every page at once. Choose a priority service page, the articles that support it and the pages readers reach from relevant coverage. Record the audience, intended action and evidence for each. Use the separate SEO for small business guide for the first £1,000 budget examples; this audit helps decide which existing content needs attention.
For an illustrative local service business, a service page explains the offer, a maintenance guide answers a practical question and a research page supports a press story. Those pages have different jobs. Review accuracy and useful next steps before comparing traffic totals. This is a hypothetical example, not a result from Craig’s clients.
Audit digital PR evidence and press resources
A digital PR page needs a different editorial check from a conversion guide. Inspect whether its sources support the claims, its figures carry dates and limitations, its biography is current and its contact route works. Check image permissions rather than assuming a photograph can be republished. An earned mention is not permission to reproduce a publication’s article or branding.
Craig’s digital PR advice and press kit offer a public example to review: the kit separates the two YouTube audiences, labels audience figures as owner-confirmed rather than live and provides background links and a press contact. The media appearances page links to published programmes and credit sources. Check those destinations and distinguish event portraits from actual appearance stills. These observations do not claim the pages have earned particular coverage or rankings.
Add a press resource to the worksheet’s Audit sheet with its purpose and evidence. If a figure cannot be verified, record “Review” and the missing source rather than inventing a replacement. When a research page has useful external references or coverage, check those dependencies before merging or removing it. Track coverage and referral enquiries separately from search clicks.
Step one: build an inventory you can trust
List the public pages within your chosen scope. Compare the published blog archive, sitemap and crawler results rather than assuming one export is complete. Crawlers can miss orphan pages; a sitemap can contain an address that no longer works. Deduplicate URLs and note redirects and canonical destinations.
For each page, record its title, primary audience and a one-sentence purpose. Include its current address and proposed next step. Keep the scope manageable: the six example posts in this worksheet are enough to practise before reviewing a large archive.
Step two: collect evidence without filling gaps with guesses
For performance, use Search Console page and query reports where you have access. Record the date range, country and search type alongside clicks and impressions. Use comparable periods and consider seasonality and changes to tracking or the site. The workbook gives you separate baseline and comparison columns.
Keep unavailable figures blank. A missing report row is not proof of zero demand: Search Console has reporting limits and some queries are withheld. Search Console clicks and analytics sessions measure different things, so do not silently substitute one for the other. Verified enquiries belong in their own column; an event or button click is not automatically a genuine lead.
A newly published guide needs a different assessment from an established article. Do not declare a recent post a failure because it has not immediately gained search traffic. Record that the observation period is limited and inspect its usefulness and discovery first.
Step three: read the page against its actual job
- Does the opening answer the visitor's main question?
- Does the title describe the content without exaggeration?
- Are facts, sources, examples and limitations clear?
- Can readers carry out the task, or does the page merely define terms?
- Are relevant links working and the next step appropriate?
- Is there a distinct reason for this page to exist alongside related articles?
Record a specific observation, such as “the source no longer supports this paragraph”, rather than “needs better SEO”. A useful audit distinguishes a factual correction, missing explanation, weak navigation and an unclear offer; each needs a different remedy.
Example: SEO reporting and SEO ROI are related, not interchangeable
The SEO reporting article explains what an agency should show a client: comparable measures, completed work, business outcomes and next priorities. The SEO ROI article explains how to assess return using contribution and investment rather than treating revenue as profit.
Both discuss measurement, but they serve different decisions. The worksheet suggests “Keep” as a provisional editorial action for each, with a note to verify sources and their distinct purpose. That does not assert either article ranks well. Shared terminology alone is not a reason to merge them.
If the reporting article starts duplicating the entire ROI calculation, an update could shorten that passage and direct readers to the focused explanation. Preserve enough context that the reporting page still answers its own question. Decide from the actual content and evidence, not a similarity score alone.
Example: an SEO content brief helps turn an audit into an assignment
The SEO content brief template covers audience, purpose, intent, questions, evidence and editorial responsibilities. A provisional audit action is “Review”: check that its copyable template is easy to use and that supporting links remain relevant.
If your own audit finds a missing explanation, write a focused brief for the update. For instance: explain how a service-business writer should distinguish a commercial service page from a supporting guide. Identify the available evidence and what the reader should be able to do afterwards. Do not brief “add 1,000 words” without specifying the missing value.
Example: keep the migration checklist focused on a website move
The SEO migration checklist is organised around before-and-after checks for moving a website. In the worksheet, “Review” means verify the checklist's current guidance, source links and usefulness for that task. It does not mean a migration problem has been detected on this site.
Do not expand it into a general audit of every SEO issue. If a reader needs indexing diagnosis after a move, link to the dedicated guide. If the reader needs an editorial inventory, this content audit provides a separate tool. Related resources should help the reader finish the task rather than make every article cover everything.
Example: distinguish internal linking from keyword cannibalisation
The internal linking guide concerns connecting useful pages and checking discovery. The cannibalisation article concerns overlapping page intent and whether that overlap is causing a problem. The example worksheet gives both a provisional “Keep” action, subject to checking current evidence.
An audit may reveal an important guide with few relevant internal links. That suggests a linking task, not necessarily a rewrite. Alternatively, two genuinely interchangeable pages may need a merge investigation. Diagnose the category before choosing the action.
Choose an action with a written reason
- Keep: the page has a distinct useful purpose and no material issue was found; record the checks performed.
- Update: retain the purpose and address while correcting or improving specific content.
- Merge: investigate combining substantially overlapping pages; name the surviving destination and preserve useful material.
- Remove: consider only when there is no useful purpose to retain, after checking links, visitors and dependencies.
- Review: evidence is incomplete or a decision needs another person.
Low traffic is a clue, not an automatic deletion rule. A niche explanation may answer a valuable enquiry; a recent article may not have had a meaningful observation period. Google's core-update guidance describes deleting content as a last resort when it cannot be salvaged, not a shortcut to recovery.
For a merge, verify that a permanent redirect leads to a genuinely relevant surviving page, and update internal links and sitemap entries. Do not redirect every removed article to the homepage. If no replacement exists, assess an appropriate not-found response instead of creating a misleading destination. Keep an approved URL-change record.
Prioritise accuracy and useful business decisions
A harmful factual error or a broken essential link normally deserves attention before a cosmetic heading change. Beyond urgent corrections, prioritise by audience need, relevance to the business, strength of evidence and effort. Traffic estimates alone do not tell you which task matters most.
The worksheet offers High, Medium and Low as manual planning labels, not an automated SEO score. Record the issue, proposed action, owner, due date and review date. A page waiting for evidence should remain “Review” instead of acquiring a confident-looking score.
How to use the workbook
- Read Instructions and set your audit scope and comparable periods.
- Open Examples to see six actual blog URLs, distinct purposes and provisional editorial decisions.
- Copy the pattern into Audit for your own pages; leave unavailable metrics blank.
- Use the Action, Priority and Status dropdowns, and write the reason for each decision.
- For merges or removals, record the destination and complete dependency checks before implementation.
- After editing, record the change date, verify the public page and schedule a review.
The workbook does not connect to your accounts, fetch data or publish changes. It contains no macros. Keep customer names and private enquiry details out of it; aggregated figures and public page observations are enough for this exercise.
Review the change, not just the spreadsheet
Check the edited page's main answer, links, metadata and intended next step. Where addresses change, verify redirects and discoverability. Then compare relevant performance over suitable periods, allowing for other work and changes in demand. An increase after an update does not prove the update alone caused it.
Use the reporting guide to communicate the work and its limitations. Do not hide an uncertain or disappointing result behind a completed-task count.
Need help deciding what to update?
Ask Craig for SEO advice with your public site address, a small group of pages and the decision you are struggling with. You can describe your observations without sending private client data. Find related reading in the consultancy blog.