Playbooks
How to run a content audit without an enterprise SEO tool
A full content audit is possible with zero SEO software budget: Screaming Frog's free tier crawls up to 500 URLs, which covers most small-business sites; Google Search Console and Google Analytics supply the performance data an enterprise tool would otherwise charge for; and Google Sheets (or Airtable) holds the inventory. The workflow takes longer to set up than an enterprise dashboard but costs nothing and works for any team under roughly 500 published URLs.
Last updated Aug 21 · 14 min read
Content audit vs SEO audit: what you're actually doing
These two terms get used interchangeably, and that confusion wastes time before a small team even starts. A technical/SEO audit looks at crawlability, indexation, and on-page/technical factors — is Google able to find and read your pages at all. A content audit inventories and evaluates the content itself: relevance, performance, gaps, and duplication (Fact & Form, Syptus). You need both eventually, but a content audit is the cheaper, faster one to run first for a small team, because it doesn't require deep technical tooling — mostly a crawl, a spreadsheet, and your existing analytics.
Semrush's standalone Content Audit tool has actually been discontinued as a dedicated product (Semrush), which is itself a useful data point: even the enterprise platforms have moved away from treating "content audit" as a tool you buy and toward treating it as a process you run using data you already have access to.
The free tool stack that replaces a paid platform
The stack that shows up consistently across practitioner guides is:
1. Screaming Frog (free tier) — crawls and inventories every URL, title tag, meta description, word count, and internal link on the site. The free version caps at 500 URLs, which is enough for the overwhelming majority of small-business and blog sites (GoMega, Mike Ginley).
2. Google Search Console — free performance data: clicks, impressions, average position, and which queries actually drive traffic to each page.
3. Google Analytics — engagement data: time on page, bounce/engagement rate, conversion events tied to specific URLs.
4. Google Sheets (or Airtable) — where the crawl export and the performance data get merged into one prioritized inventory. Airtable's generous free tier can import a Screaming Frog crawl export directly for a more structured, filterable inventory than a flat spreadsheet (theStacc).
If a site is larger than 500 URLs and Screaming Frog's free tier won't cover it, SiteOne Crawler and Google Lighthouse are cited as no-cost crawler alternatives for the basic technical checks a paid crawler would otherwise handle (Prerender.io).
Step-by-step: running the audit
1. Crawl the site. Run Screaming Frog's free crawl to export every live URL along with title, meta description, word count, status code, and canonical tag.
2. Pull performance data. Export Search Console's Pages report (clicks, impressions, average position over the last 12–16 months) and match it to the crawl by URL.
3. Pull engagement data. Add Analytics engagement metrics for the same URL set.
4. Merge into one sheet. One row per URL, columns for the crawl data plus the performance data.
5. Score each page. Flag pages as keep, update, consolidate, or remove, based on a combination of traffic, relevance to current business priorities, and content quality.
6. Prioritize. Sort by traffic potential and effort so the highest-impact, lowest-effort fixes surface first.
7. Write the plan. A short executive summary of the 3–5 highest-impact findings plus a 30/60/90-day roadmap is the recommended minimum deliverable, even for an internal audit with no external client (Rankz).
Auditing doesn't have to happen all at once. Lullabot's guidance for teams with limited bandwidth recommends working section by section rather than attempting a full-site audit in one pass — a team can audit the blog this month and the product pages next month, and still make real progress (Lullabot).
Organizing the spreadsheet
HubSpot's guidance on running a content audit recommends a column structure built around URL, issue, impact, effort, owner, and status, with findings grouped by content type so priorities are visible at a glance rather than buried in a 2,000-row flat list (HubSpot). A practical column set:
– URL – Page title – Word count – Publish/update date
– Search Console clicks (trailing 12 months)
– Search Console average position – Primary target keyword (if known)
– Issue (thin, outdated, duplicate, cannibalizing another page, technically broken)
– Impact (high/medium/low) – Effort (high/medium/low)
– Recommended action (keep, update, consolidate, remove)
– Owner – Status Free Search Console and Analytics data can substitute for a paid rank tracker's metrics in a basic audit — clicks, impressions, and average position tell you almost everything a rank-tracking subscription would tell you at the individual-page level, just without daily granularity (HubSpot).
Spotting thin content without a paid tool
Thin content is one of the easiest things to flag for free. Running a word-count check across every page — using a free tool like a website word counter — and cross-referencing low word counts against Search Console performance data quickly surfaces pages that are both short and underperforming, which is usually the highest-priority cleanup list on the sheet (Website Word Counter). A page under roughly 300 words with near-zero Search Console impressions is a strong candidate for either expansion or consolidation into a stronger page.
Consolidation is worth calling out specifically: merging several lower-ranking, overlapping posts into one comprehensive pillar page is described as one of the more effective moves available to small, resource-constrained teams — it concentrates whatever link equity and relevance signal those pages had individually into a single stronger asset, instead of leaving three thin posts to compete with each other (Neal Schaffer).
Practical examples
Illustrative example (labeled as such): A three-person marketing team at a 40-page small-business site runs a Screaming Frog crawl in under 20 minutes, exports it, and merges it with a 16-month Search Console pull. Sorting by word count reveals nine pages under 250 words, six of which cover overlapping topics ("what is X," "X explained," "X guide"). The team merges those six into two comprehensive guides, redirects the old URLs, and rewrites the three remaining thin pages that had unique, non-overlapping topics. Total tool cost: $0. Total time: roughly one working day for the crawl-and-merge step, spread across a week for the actual content work.
Sourced pattern: The workflow combining Screaming Frog's free crawl with Google Sheets is documented directly as a practitioner pattern by Mike Ginley, specifically framed as a free alternative for teams that can't justify Semrush or Ahrefs pricing (Mike Ginley).
Data and evidence
– Screaming Frog's free tier crawl limit is 500 URLs, confirmed as sufficient for most small-business sites (GoMega).
– Semrush discontinued its standalone Content Audit tool as a product (Semrush) — a signal that even paid-platform vendors treat this as a process, not a single tool.
– A commonly cited audit cadence is one full audit per year layered with quarterly mini-audits on top-traffic/top-revenue pages (Portent).
– No independently verified industry-wide statistic on "average cost saved by DIY content audits vs. paid tools" was found during this research pass — that specific claim is evidence not sufficiently verified, and this article does not state a dollar figure for it.
Comparisons
### Screaming Frog vs Semrush for a content audit
Screaming Frog's free tier handles the crawl/inventory step that a paid platform like Semrush would otherwise charge a monthly subscription for, provided the site is under 500 URLs. Semrush (where still used) adds convenience — automated reporting, integrated keyword data, one dashboard — but for a site that fits inside the free crawl limit, the free stack produces comparable raw data at zero cost, just with more manual merging work.
### Content audit vs SEO audit A content audit asks "is this page worth keeping, updating, or removing." An SEO audit asks "can search engines even find and read this page." Skipping the SEO audit and doing only a content audit risks investing rewrite effort into pages that have an underlying crawl/indexation problem the content quality never gets a chance to fix (Fact & Form).
Real-world use cases
Freelance SEO consultants working with small-business clients who have no software budget are a clear, sourced audience for this exact workflow — several of the practitioner guides reviewed here are explicitly framed for consultants advising clients who can't justify enterprise tool pricing (Rankz). A startup marketing team of one or two people preparing for a content refresh before a product relaunch is another common real-world scenario the free-tool workflow fits well, since the audit doesn't require procurement approval for new software.
Common mistakes
– Auditing the whole site at once with no bandwidth plan, and abandoning the project halfway — section-by-section auditing is the recommended alternative for small teams (Lullabot).
– Treating word count as the only quality signal. Low word count is a useful flag, not a verdict — some short pages (a clear how-to, a definition page) are genuinely fine at 300 words.
– Skipping the Search Console pull and judging pages on gut feel instead of actual click/impression data.
– No prioritization column. A flat list of 200 issues with no impact/effort scoring rarely gets acted on.
– Deleting instead of consolidating thin-but-relevant content that could be merged into a stronger page and retain its existing backlinks/traffic instead of losing it entirely.
Best practices
– Merge the crawl export and Search Console data into one sheet before drawing conclusions about any single page.
– Score every finding on impact and effort, and sort by that combination, not by URL alphabetically.
– Consolidate overlapping thin pages into a single stronger page rather than defaulting to deletion.
– Run a full audit annually and a lighter quarterly check on top-traffic pages only.
– Keep the deliverable to a short executive summary plus a 30/60/90-day roadmap, even for an internal, no-client audit.
Key takeaways
– A content audit and an SEO audit are different things; the free-tool workflow described here is primarily a content audit and works best paired with a basic technical check.
– Screaming Frog's free tier (500 URLs) plus Search Console, Analytics, and Sheets replicates most of what a paid content-audit platform provides for small sites.
– Consolidating overlapping thin pages into one stronger page is often more effective than deleting or individually rewriting each one.
– Score every finding on impact and effort, and keep the deliverable to a short prioritized summary rather than a raw data dump.
– Audit annually in full, with lighter quarterly checks on your highest-traffic pages.
Relevant tools.scult.in resources
– Word Counter — run every page through it to flag thin content fast, without needing a crawler subscription.
– SEO & GEO/AEO prompts — for drafting the audit summary, prioritization rationale, and rewrite briefs once your spreadsheet is built.
Frequently asked questions
What is a content audit?
A structured inventory and evaluation of every page on a site, assessing relevance, performance, and quality to decide what to keep, update, consolidate, or remove.
What's the difference between a content audit and an SEO audit?
A content audit evaluates the content itself; an SEO audit evaluates crawlability, indexation, and technical/on-page factors (Fact & Form).
Do I need to buy Semrush or Ahrefs to run a content audit?
No — Screaming Frog's free tier plus Google Search Console, Analytics, and Sheets covers the same core data for sites under 500 URLs (Mike Ginley).
What is Screaming Frog's free crawl limit?
500 URLs (GoMega).
What if my site has more than 500 pages?
Consider SiteOne Crawler or Google Lighthouse as free alternatives, or run the crawl in sections (Prerender.io).
What's "thin content"?
Pages with very little substantive text or value relative to what a searcher needs — often flagged by a low word count combined with low search performance.
How often should a small team audit its content?
A common pattern is one full audit per year plus quarterly mini-audits on top-traffic pages (Portent).
Can I use Airtable instead of Google Sheets?
Yes — Airtable's free tier can import a Screaming Frog crawl export directly and offers more structured filtering than a flat spreadsheet (theStacc).
Is Semrush's Content Audit tool still available?
No, Semrush discontinued its standalone Content Audit tool (Semrush).
Do I need technical SEO knowledge to run a content audit?
Basic familiarity helps, but the process is largely about organizing existing performance data and making editorial judgment calls, not deep technical work.
What data does Google Search Console actually provide for an audit?
Clicks, impressions, average position, and the specific queries driving traffic to each URL, over whatever date range you select (up to 16 months).
What does Google Analytics add on top of Search Console data?
On-page engagement signals — time on page, bounce/engagement rate, and any conversion events tied to that URL — which Search Console alone doesn't provide.
Why does Screaming Frog matter if I already have Search Console?
Search Console shows performance but not content structure — Screaming Frog's crawl gives you word count, title tags, meta descriptions, and internal links across every page in one export.
What counts as a "page" for the 500-URL free limit?
Any crawlable URL on the site, including non-content pages like category or tag archives — worth excluding those from the crawl scope if they're inflating your count unnecessarily.
Should I audit paginated or filtered URLs too?
Generally no for a content audit — focus the crawl on canonical, indexable content pages, not parameter-based duplicates.
How long does a basic content audit take for a 40-page site?
Realistically a day or two for the data-gathering and merge step, spread over a longer window for the actual content decisions and rewrites.
What's the minimum viable audit output?
A prioritized spreadsheet plus a short summary of the top 3–5 findings and a rough roadmap — not a polished 40-page report (Rankz).
Can I run this process on a Shopify or Squarespace site, not just WordPress?
Yes — Screaming Frog crawls any publicly accessible site regardless of CMS; the Search Console/Analytics data is CMS-independent too.
Do I need developer help to run a content audit?
No — the crawl, spreadsheet merge, and editorial scoring can all be done by a marketer with no coding background.
What's the realistic cost of this entire free-tool workflow?
$0 in software cost; the only investment is staff time.
How do I organize my content audit spreadsheet?
Use columns for URL, issue, impact, effort, owner, and status, grouped by content type (HubSpot).
How do I run a Screaming Frog crawl step by step?
Enter the root domain, start the crawl, wait for it to complete (capped at 500 URLs on the free tier), then export the internal HTML report as a CSV.
How do I pull the matching Search Console data?
In Search Console's Performance report, filter by page, export the full table for your chosen date range, and match rows to the crawl export by URL.
How do I merge the two exports into one sheet?
Use a VLOOKUP or INDEX/MATCH formula keyed on the URL column to pull Search Console metrics into the same row as each URL's crawl data.
How do I score pages for prioritization?
Assign a simple high/medium/low rating for both impact (traffic/revenue potential) and effort (time to fix), then sort by the combination that surfaces high-impact, low-effort work first.
How do I spot thin content without a paid tool?
Sort the merged sheet by word count and cross-reference low counts against Search Console impressions to flag genuinely underperforming thin pages (Website Word Counter).
How do I decide whether to consolidate two pages instead of just updating one?
Consolidate when both pages target overlapping keywords or intent and neither is individually strong — merging concentrates their combined signal into one stronger page (Neal Schaffer).
How do I redirect old URLs after consolidating content?
Set up 301 redirects from the removed URL(s) to the surviving consolidated page, so any existing links and rankings transfer rather than being lost.
How do I present the audit findings to a small-business owner with no SEO background?
Lead with the 3–5 highest-impact findings in plain language and a simple 30/60/90-day plan, not a raw data dump.
How do I avoid auditing the whole site in one overwhelming pass?
Break the audit into sections (blog, product pages, landing pages) and complete one section at a time, as recommended for teams with limited bandwidth (Lullabot).
What's an advanced way to detect content cannibalization during a free audit?
Group Search Console query data by topic and check whether multiple URLs are ranking for the same query cluster — a sign the pages are competing with each other rather than reinforcing a topic.
Can I automate parts of this workflow with Google Apps Script?
Yes — Apps Script can automate pulling Search Console data into a Sheet on a schedule, reducing the manual export step for recurring quarterly audits.
How do I audit content for AI-search/AEO readiness without a paid tool?
Manually check whether each page directly answers a clear question near the top, and whether it's structured with clear headings — the same crawl-and-review process works, just with an added evaluation criterion.
Should a content audit include a competitive comparison, or just internal review?
A basic free-tool audit is primarily internal; adding competitive analysis requires either manual review of competitor pages or a paid tool, so most DIY audits skip this layer initially.
How do I handle a very large site that exceeds Screaming Frog's free limit without paying?
Crawl in sections by subdirectory, or switch to a free alternative crawler like SiteOne for the portions beyond the 500-URL cap (Prerender.io).
Screaming Frog free tier vs Semrush — which is better for a content audit?
Screaming Frog's free tier covers the crawl/inventory step at no cost for sites under 500 URLs; Semrush adds convenience and integrated reporting but at a monthly cost, and no longer even offers a dedicated content-audit tool (Semrush).
Google Sheets vs Airtable for the content inventory — which should I use?
Sheets is simpler and universally familiar; Airtable offers better filtering/views and can import a crawl export more cleanly, at the cost of a small learning curve (theStacc).
A content audit vs. a full technical SEO audit — which should a small team do first?
A content audit is usually cheaper and faster to start since it needs less technical tooling, but a technical audit is worth doing in parallel if pages aren't indexing at all — content quality can't fix a crawlability problem.
Manual spreadsheet audit vs. automated crawl-tool dashboard — what's the real trade-off?
A manual spreadsheet costs nothing but takes more setup time per audit cycle; an automated dashboard costs a subscription but re-runs the analysis with less manual effort each time.
Consolidating thin pages vs. rewriting them individually — which produces better results?
Consolidation tends to concentrate scattered relevance/link signal into one stronger page when pages overlap in topic; individual rewrites make more sense when each thin page targets a genuinely distinct query (Neal Schaffer).
My Screaming Frog crawl stopped at 500 URLs and my site is bigger — what do I do?
Crawl by subdirectory to stay under the free limit per crawl, or use a free alternative crawler for the remainder (Prerender.io).
My Search Console data doesn't match my crawl export URLs — why?
Check for trailing-slash, HTTP vs HTTPS, or www vs non-www mismatches between the two exports; these are the most common causes of failed VLOOKUP matches.
I flagged a page as thin but it still ranks well — should I still rewrite it?
Not urgently — prioritize pages that are both thin and underperforming; a short page that already ranks well for its intent may not need expansion.
My audit spreadsheet has 300 rows and no one is acting on it — what went wrong?
Add impact/effort scoring and an owner column, and cut the initial action list down to the top 10–15 items rather than presenting the full raw list as the deliverable.
I consolidated two pages but lost some traffic — what happened?
Check that the 301 redirect was implemented correctly and that the surviving page actually covers the intent of both original pages; a rushed consolidation can lose relevance for one of the merged topics.
Is it ever worth paying for an SEO tool instead of doing this manually?
Once a site exceeds a few hundred URLs or a team needs to run audits monthly rather than annually, the time saved by an automated dashboard can outweigh the subscription cost — the free-tool workflow is most efficient for smaller sites and lower audit frequency.
What should I look for if I do eventually pay for an SEO/content platform?
Prioritize tools that combine crawl data with performance data in one view, since that merge step is the most time-consuming part of the free workflow.
Is a freelance SEO consultant justified in charging for this workflow even though the tools are free?
Yes — the value is in the analysis, prioritization, and editorial judgment, not the tools; several practitioner guides referenced here are explicitly written for consultants running this exact process for clients (Rankz).
How do I know if my small business has outgrown the free-tool workflow?
If audits are needed more than quarterly, the site exceeds a few hundred URLs, or you need automated alerting on ranking changes, it's a reasonable point to evaluate a paid platform.
What's the single highest-leverage first step if I've never audited my content before?
Run the Screaming Frog crawl and Search Console export today, merge them, and just look at your lowest-word-count, lowest-traffic pages first — that one pass usually surfaces the clearest quick wins.
Sources
- https://blog.hubspot.com/marketing/company-content-audit
- https://www.gomega.ai/blog/screaming-frog-seo-audit/
- https://www.mikeginley.com/blog/seo-content-audit/
- https://rankz.co/blog/how-to-do-an-seo-audit-reddit/
- https://prerender.io/blog/screaming-frog-alternative/
- https://thestacc.com/blog/best-content-inventory-tools/
- https://websitewordcounter.com/
- https://www.lullabot.com/articles/content-audits-heavy-lift-huge-payoff
- https://factandform.com/seo-audit-vs-content-audit-differences/
- https://portent.com/blog/content/how-often-you-need-to-audit-content-to-stay-on-top.htm
- https://nealschaffer.com/content-audit/
