Content Audit Template: Evaluate and Improve Existing Content

Most businesses focus on creating new content while their existing library slowly decays. Blog posts with outdated statistics, landing pages targeting keywords you no longer rank for, and guides that reference tools and trends from three years ago — all sitting on your website, silently undermining your credibility and SEO performance.

A content audit fixes this. It is a systematic review of every piece of content on your site, evaluating each against clear criteria and assigning specific actions — keep, update, merge, or delete. For Singapore businesses that have been publishing content for years, a well-executed audit can improve organic traffic by 20 to 40 per cent simply by optimising what you already have.

This article provides a complete content audit template, including the spreadsheet fields you need, scoring criteria for evaluating content, action categories for decision-making, and a prioritisation framework so you know where to start. Whether you manage 50 pages or 5,000, this template scales to your needs.

What Is a Content Audit and When to Conduct One

A content audit is a comprehensive inventory and evaluation of all content on your website. Unlike a quick review of your most-visited pages, an audit examines every published piece — blog posts, landing pages, service pages, resource articles, and any other indexed content — against defined performance and quality criteria.

When to Conduct a Content Audit

You should run a content audit in these situations:

Annually as part of your content strategy review — Make it a recurring exercise, ideally in Q4 before planning the following year’s content
After a website redesign or migration — Ensure all content transferred correctly and still serves its purpose in the new structure
When organic traffic declines — A traffic drop may signal content decay, cannibalisation, or quality issues that an audit will surface
Before a new content strategy is implemented — You need to know what you have before you can plan what to create
When your business direction changes — Pivots in services, target market, or positioning mean some existing content is no longer relevant

For Singapore businesses with active blogs publishing weekly, a full audit every 12 months and a focused review of top-performing pages every six months is a practical cadence.

Content Audit Spreadsheet Fields

Your content audit spreadsheet is the backbone of the entire exercise. Here are the fields to include for each piece of content:

Identification Fields

Field	설명	예
URL	Full URL of the page	/blog/seo-cost-singapore/
Page Title	H1 or title tag of the page	How Much Does SEO Cost in Singapore?
Content Type	Blog post, landing page, service page, etc.	Blog post
Topic / Pillar	Which content pillar it belongs to	SEO
Publish Date	When the content was originally published	12 Jan 2024
Last Updated	When it was last meaningfully revised	5 Aug 2025
Word Count	Total word count of the page	2,150

Performance Fields

Field	설명	Source
Organic Sessions (Last 12 Months)	Total organic traffic over the past year	Google Analytics
Organic Sessions Trend	Growing, stable, or declining	Google Analytics (compare periods)
Primary Keyword	Main keyword the page ranks for	Google Search Console
Keyword Position	Average ranking position for the primary keyword	Google Search Console or rank tracker
Backlinks	Number of referring domains linking to this page	Ahrefs, SEMrush, or Moz
Conversions	Leads, signups, or purchases attributed to this page	Google Analytics (goals or events)
Bounce Rate	Percentage of single-page sessions	Google Analytics
Average Time on Page	How long visitors spend on the page	Google Analytics

Quality Fields

Field	설명	How to Assess
Accuracy	Is the information still correct and current?	Manual review
Relevance	Does it still align with your business and audience?	Manual review
SEO Optimisation	Is it properly optimised for target keywords?	On-page SEO check
Content Quality Score	Overall quality rating (1-5 scale)	Manual review using scoring criteria below
Action	Keep, update, merge, or delete	Based on combined assessment
Priority	High, medium, or low	Based on prioritisation framework
Notes	Specific changes needed or observations	Manual review

Scoring Criteria for Evaluating Content

Subjective quality assessments lead to inconsistent decisions. Use a standardised scoring system so every piece is evaluated against the same criteria, regardless of who reviews it.

The Five-Point Scoring System

Rate each piece on a scale of 1 to 5 across four dimensions:

Score	Quality	Relevance	SEO	Performance
5 — Excellent	Comprehensive, well-written, original insights	Perfectly aligned with current business goals and audience	Fully optimised, ranking in top 3	High traffic, strong conversions
4 — Good	Well-written with minor gaps	Relevant with minor alignment issues	Well optimised, ranking positions 4-10	Above-average traffic and engagement
3 — Average	Adequate but not differentiated	Somewhat relevant, could be more focused	Partially optimised, ranking positions 11-20	Average traffic, low conversions
2 — Below Average	Thin, outdated, or poorly structured	Marginally relevant to current direction	Poorly optimised, ranking beyond page 2	Low traffic, declining trend
1 — Poor	Inaccurate, embarrassingly dated, or duplicative	No longer relevant to business or audience	Not optimised, no rankings	Negligible traffic, zero conversions

Calculate a composite score by averaging the four dimensions. This gives you a single number per piece that enables easy sorting and comparison across your entire content library.

Action Categories: Keep, Update, Merge, or Delete

Based on your scoring, assign each piece to one of four action categories. These categories create a clear decision framework that eliminates ambiguity about what to do next.

Keep (No Action Needed)

Content that scores 4 or 5 across all dimensions. It is accurate, relevant, well-optimised, and performing well. Leave it as is and focus your effort elsewhere. Review it again at the next audit cycle.

Update (Refresh and Optimise)

Content that scores 3 to 4 and has clear potential to improve with targeted revisions. Updates might include:

Refreshing outdated statistics, examples, and year references
Improving on-page SEO — updating title tags, meta descriptions, and heading structure
Adding new sections to improve depth and comprehensiveness
Updating internal links to reflect your current site structure
Improving formatting with tables, lists, or visual elements
Adding a FAQ section to target featured snippets

Updated content often recovers lost rankings within four to eight weeks and can outperform the original version significantly.

Merge (Consolidate Related Pieces)

When you find multiple pieces covering the same or heavily overlapping topics, merge them into a single, comprehensive piece. This is common on blogs that have published for several years — you might have three separate posts about Google 광고 budgeting, each covering different angles but competing with each other for the same keyword.

The merge process:

Identify the strongest-performing piece as the primary URL
Combine the best content from all pieces into the primary URL
Set up 301 redirects from the secondary URLs to the primary URL
Update internal links across your site to point to the merged URL

Merging consolidates backlinks and ranking signals into a single page, often resulting in stronger rankings than any individual piece achieved alone.

Delete (Remove Entirely)

Content that scores 1 to 2 across all dimensions and offers no path to improvement. Delete candidates include:

Event announcements or news items about past events with no evergreen value
Content about products or services you no longer offer
Extremely thin content (under 300 words) with no traffic or backlinks
Duplicate or near-duplicate pages
Content targeting keywords that are no longer relevant to your business

When deleting, set up 301 redirects to the most relevant existing page. This preserves any residual link equity and prevents 404 errors for pages that might be bookmarked or linked from external sites.

Prioritising Your Audit Actions

A content audit of 200 pages might yield 80 updates, 15 merges, and 20 deletions. You cannot do everything at once. Prioritise based on impact and effort.

Prioritisation Matrix

Priority	Criteria	예제
High Priority	High traffic or conversion potential + low effort to fix	Top-20 pages needing minor SEO updates; pages ranking positions 4-10 that could reach top 3 with optimisation
Medium Priority	Moderate potential + moderate effort, or high potential + high effort	Pages needing substantial rewriting; merge candidates requiring content consolidation
Low Priority	Low potential regardless of effort, or low effort but minimal impact	Pages with no traffic history and no keyword opportunity; simple deletions of irrelevant content

Quick Wins to Start With

Begin your post-audit work with these quick wins that deliver disproportionate results:

Update title tags and meta descriptions on your top 20 pages — this takes minutes per page and can improve click-through rates by 10 to 30 per cent
Add internal links from high-authority pages to newer content that needs ranking support
Refresh year references and statistics in evergreen content — changing “2024” to “2026” takes seconds but signals freshness to both readers and search engines
Fix broken internal and external links — these damage user experience and waste crawl equity
Delete or redirect obvious low-value pages — thin content with no traffic that clutters your site index

Step-by-Step Content Audit Process

Follow this process to complete your content audit efficiently:

Crawl your website — Use Screaming Frog, Sitebulb, or a similar crawler to generate a complete list of all indexed URLs. This ensures you do not miss pages buried deep in your site structure.
Export performance data — Pull organic traffic, keyword rankings, and conversion data from Google Analytics and Google Search Console. Export backlink data from Ahrefs or SEMrush. Match this data to your URL list.
Populate your audit spreadsheet — Fill in the identification, performance, and quality fields for each URL. Automate where possible — the crawl tool and analytics exports handle most identification and performance fields.
Score each piece — Review each piece against the five-point scoring criteria. This is the most time-intensive step. For large sites, start with your highest-traffic pages and work downward.
Assign actions — Based on scores, categorise each piece as keep, update, merge, or delete. Add specific notes about what needs to change for updates and merges.
Prioritise — Apply the prioritisation matrix to rank all action items by impact and effort. Create a phased plan for implementation.
Execute and track — Work through your prioritised list, tracking what changes were made and when. Monitor performance in the weeks following each change to measure impact.

For a site with 100 to 200 pages, expect the audit to take three to five working days. For larger sites, consider auditing in segments — by content pillar or section — rather than attempting everything at once.

What to Do After the Audit

A content audit is not a one-time project. It should feed directly into your ongoing 콘텐츠 마케팅 operations.

Integrate Findings Into Your Content Strategy

Your audit reveals gaps in topic coverage, over-served areas, and content types that perform best. Use these insights to refine your content pillars, adjust your editorial calendar, and allocate resources more effectively.

Establish Ongoing Monitoring

Set up automated alerts for significant traffic drops on key pages. Review your top 20 pages quarterly for accuracy and freshness. Track the performance of updated content to confirm that your changes are having the desired effect.

Build a Content Maintenance Schedule

Create a rolling schedule for reviewing and refreshing evergreen content. Assign each piece a review date based on its topic’s velocity — content about fast-moving topics like social media algorithms needs reviewing every three to six months, while foundational guides on core concepts may only need annual updates.

Document Your Process

Record your audit methodology, scoring criteria, and lessons learned so future audits are faster and more consistent. If you hire new team members or engage an agency, this documentation ensures continuity in how content quality is assessed and maintained.

자주 묻는 질문

How long does a content audit take?

For a website with 50 to 100 pages, expect two to three working days. For 100 to 300 pages, three to five days. For sites with 500 or more pages, plan for one to two weeks or consider auditing in phases by content section. The most time-consuming step is the manual quality review — data collection and spreadsheet setup can be largely automated.

Should I delete content that gets no traffic?

Not automatically. Some content serves purposes beyond organic traffic — sales enablement materials, onboarding resources, or pages that support other pages through internal linking. Only delete content that has no traffic, no backlinks, no internal linking value, and no longer aligns with your business. Always set up 301 redirects when deleting.

How do I know if two pieces should be merged?

Merge candidates share at least one of these characteristics: they target the same or very similar keywords, they cover substantially overlapping topics, or they compete with each other in search results (keyword cannibalisation). Check Google Search Console to see if multiple URLs on your site appear for the same search queries — this is a clear signal that consolidation would benefit your SEO.

What tools do I need for a content audit?

At minimum, you need Google Analytics, Google Search Console, and a spreadsheet (Google Sheets or Excel). For a more thorough audit, add a website crawler (Screaming Frog is free for up to 500 URLs) and a backlink analysis tool (Ahrefs, SEMrush, or Moz). These tools automate data collection and surface issues like broken links, thin content, and missing meta tags.

How often should I conduct a full content audit?

A full audit once per year is sufficient for most businesses. Supplement this with quarterly mini-audits of your top 20 to 30 pages by traffic and conversion value. If your site publishes more than 10 pieces per month, consider conducting a full audit every six months to prevent content quality from degrading.

Can a content audit improve my SEO rankings?

Yes. Content audits improve SEO in several ways: removing thin or duplicate content improves your site’s overall quality signals; updating existing content with fresh information and better optimisation recovers lost rankings; merging competing pages consolidates ranking signals into a single stronger page; and fixing internal linking improves crawlability and distributes page authority more effectively. Many sites see measurable traffic improvements within four to eight weeks of implementing audit recommendations.

Content Audit Template: Evaluate and Improve Existing Content