A content audit helps you decide what each page on your website needs next: keep it, improve it, combine it with a similar page, or remove it. Use the template and decision framework below to turn a list of URLs into a practical SEO action plan.
A low-traffic page is not automatically a bad page—and a high-traffic page is not automatically doing its job. Consider search performance alongside usefulness, accuracy, business value, backlinks, and whether the content meets the needs of its audience. Google’s guidance emphasizes helpful, reliable, people-first content, so the goal is not simply to delete pages with weak numbers; it is to make your content library more useful.
What a content audit template includes
A content audit template is a spreadsheet that gives you a consistent way to review pages and record what to do with them. You can make one in Google Sheets or Excel and add one row per URL.
Start with these columns:
| Column | What to record |
|---|---|
| URL | The page’s canonical URL |
| Page title | The current title tag or article title |
| Content type | Blog post, guide, landing page, case study, and so on |
| Topic or cluster | The main subject the page covers |
| Primary search intent | What the searcher is trying to do or learn |
| Target keyword | The main query the page is intended to address |
| Last updated | The date of the last meaningful content update |
| Organic clicks | Clicks from organic search over a chosen period |
| Impressions | How often the page appeared in search results |
| Average position | A directional view of ranking performance |
| Organic sessions | Visits from organic search, if available |
| Conversions | Leads, sign-ups, or other meaningful outcomes |
| Referring domains | Unique websites linking to the page |
| Content quality | Accurate, original, complete, clear, and useful? |
| Overlap or cannibalization | Are other pages targeting a similar need? |
| Business relevance | Does this topic attract or help your intended customers? |
| Recommended action | Keep, update, combine, remove, or investigate |
| Reason | The evidence behind the decision |
| Owner and priority | Who will act, and when |
| Follow-up date | When you’ll review the result |
You don’t need every metric for every site. If you’re starting small, focus on URL, topic, organic clicks and impressions, conversions, backlinks, overlap, action, and reason.
How to use the template
1. Set the scope and time period
Choose which section of your site to audit—such as the blog, resource centre, or all indexable pages—and define the purpose. For example, you might want to improve organic leads, refresh outdated advice, or find overlapping articles.
Use a consistent date range when comparing pages. For a first pass, review a meaningful period that accounts for seasonality; compare it with an earlier period where possible. A short-term dip can have causes other than content quality, so avoid making decisions based on one metric or one snapshot.
2. Build a complete URL inventory
Collect the URLs in scope using a site crawl, your XML sitemap, and your analytics or search data. Compare the lists so you don’t miss important pages that are not linked well internally or included in the sitemap.
Check that the inventory distinguishes live pages from redirects, duplicates, and URLs that should not be indexed. If you find technical issues—such as broken internal links or an accidental noindex directive—record them rather than treating them as a content-quality problem.
3. Add performance and quality signals
Gather available search and analytics data, then review the actual page. Metrics help you identify candidates; reading the page helps you understand why it may be underperforming.
Ask:
- Does the page answer the searcher’s likely question?
- Is the information still accurate and complete?
- Does it offer a useful perspective, examples, or expertise?
- Is the page easy to scan and navigate?
- Does it support your audience and business goals?
- Does another page already serve the same purpose?
- Does it earn relevant links, referrals, or conversions?
4. Assign an action and reason
Give every URL an action—even if the action is “investigate further.” Record the reason in plain language, such as “outdated statistics,” “two posts target the same intent,” or “low traffic but generates qualified leads.”
This makes the audit actionable and helps prevent arbitrary pruning.
The decision framework: update, combine, or remove
| Action | Choose it when | What to do |
|---|---|---|
| Keep | The page is useful, accurate, distinct, and meeting its purpose | Preserve it; schedule a review when the topic or data may change |
| Update | The topic still matters, but the page is outdated, incomplete, unclear, or underperforming | Improve the substance, structure, evidence, and on-page elements |
| Combine | Several pages substantially overlap or split useful information across URLs | Create one stronger page from the best material, then redirect retired URLs where relevant |
| Remove | The page has no useful purpose, no meaningful value, and no relevant replacement | Remove it carefully and update internal links |
| Investigate | The data is incomplete or signals conflict | Check the page’s traffic sources, links, intent, and technical status before deciding |
Update a page when its topic still deserves a page
An update is usually the right choice when the page targets a relevant topic but needs meaningful improvement. Examples include an outdated process, missing subtopics, weak explanations, unclear structure, or content that no longer matches the current search intent.
A useful update is more than changing the date. Verify claims, improve the answer, add relevant examples, remove stale advice, and make the page easier to use. If search results have changed, check whether the intent or expected format has changed too.
Combine pages when they serve the same need
Consider combining pages when they answer substantially the same question, target similar queries, or compete to satisfy the same search intent. Similar wording in the titles alone is not enough; review the content and the search results to confirm that the pages are genuinely overlapping.
Choose the best destination URL based on relevance, history, links, and usefulness—not only on which page currently has the most traffic. Bring over the unique, valuable material from the other pages, edit it into a coherent article, and redirect the retired URLs to the closest relevant destination. Google recommends permanent server-side redirects when a page has moved or been merged; a 301 is one type of permanent redirect.
Remove a page only when it has no useful role
Removal may make sense when a page is irrelevant, obsolete, thin beyond repair, or no longer supports users or the business—and there is no suitable replacement. Before deleting it, check for backlinks, referral traffic, conversions, and any other reason people may still need the page.
If a genuinely relevant replacement exists, redirect the old URL to it. If there is no suitable replacement, don’t send visitors to an unrelated page just to avoid a 404; update internal links and handle the retired URL appropriately.
Worked example
Suppose your blog has three posts about “SEO audit checklists.” One is a broad checklist, one focuses on technical checks, and one is an older version of the broad checklist.
Before combining them, compare their intent and search results. If two posts answer the same broad question, you could keep the stronger URL, incorporate the useful material from the other broad post, and redirect that retired URL to the updated article. The technical SEO checklist may deserve to remain separate if it serves a distinct audience need.
In the spreadsheet, record the chosen URL as Update, the overlapping URL as Combine, and document the redirect destination. This gives your team a clear implementation plan rather than a vague instruction to “clean up the blog.”
Implement and measure the changes
Before publishing updates or removing URLs, prepare a simple checklist:
- Save a copy of the original content and record the original URL.
- Update the page and review it for accuracy, clarity, and search intent.
- Add or revise internal links so they point to the best current resource.
- For merged or moved content, implement the appropriate permanent redirect and test that it reaches the intended page.
- Check that the destination page is indexable and included in the sitemap if appropriate.
- Record the launch date, owner, and expected outcome in the audit sheet.
After implementation, compare performance using the same metrics and a comparable time period. Review rankings, impressions, clicks, conversions, and relevant referral traffic. Look at the results in context: seasonality, site changes, and search-result changes can all affect performance.
Common content-audit mistakes
- Deleting pages based only on traffic. A page may contribute leads, referrals, or valuable links despite modest organic visits.
- Updating only the publication date. Refresh the information and usefulness, not just the timestamp.
- Combining pages without checking intent. Related topics are not always duplicate topics.
- Redirecting everything to the homepage. Use a closely relevant destination, or remove the page without an irrelevant redirect.
- Changing URLs unnecessarily. If the URL is already useful and established, preserve it where practical.
- Making changes without a record. Document the reason and outcome so future audits build on evidence.
Copy-and-paste content audit template
Paste this header row into a spreadsheet, then add one URL per row:
URL | Page title | Content type | Topic/cluster | Search intent | Target keyword | Last updated | Organic clicks | Impressions | Average position | Organic sessions | Conversions | Referring domains | Content quality notes | Overlap/cannibalization | Business relevance | Recommended action | Reason | Redirect destination | Owner | Priority | Follow-up date | ResultUse a short, consistent action vocabulary: Keep, Update, Combine, Remove, or Investigate. With a clear reason attached to each decision, your audit becomes a working plan for improving the quality and usefulness of your site—not just a spreadsheet of page metrics.