The KUCK Framework: Your Action Grid
| Category | Signals | Action | Timeline |
|---|---|---|---|
| Keep | Top 20% traffic, above-average engagement, converting well | Monitor. Do not touch. | Ongoing |
| Update | Declining traffic, outdated info, thin content (under 500 words) | Refresh within 30 days | 30 days |
| Consolidate | Keyword cannibalization, 3+ similar pages, fragmented authority | Merge into one page. Redirect others. | 60 days |
| Kill | Zero traffic 90+ days, no backlinks, outdated beyond repair | Delete and 410, or noindex | Immediate |
The Problem: Why Content Audits Fail
Most content audits fail for one reason. They are too manual.
You export data from five different tools. You spend hours copying and pasting. By the time you finish, the data is already outdated.
This is the "CSV Hell" problem. And it kills more content strategies than bad writing ever did.
Here is what happens:
- You export GSC data for your top 100 pages
- You export GA4 engagement metrics
- You run a Screaming Frog crawl
- You manually cross-reference everything in a spreadsheet
- Three days later, you have a "complete" audit
But here is the catch. Your data is already stale. Google has re-indexed pages. Traffic has shifted. You are making decisions on yesterday's news.
A good audit spreadsheet has three layers: Inventory (what exists), Performance (how it performs), and Action (what to do). Most teams stop at layer two. That is a mistake.
The FITS Solution: Automated Content Audit
FITS turns your Google Sheet into an automated audit machine. No more CSV exports. No more stale data.
Step 1: Auto-Import Your Content Inventory
Pull your complete content inventory with one formula:
This pulls all indexed URLs, page titles, word counts, last modified dates, and internal link counts. Your inventory updates automatically.
Step 2: Connect Performance Data
Layer in GSC and GA4 data:
Fresh performance data for every URL. Updated whenever you open the sheet.
Step 3: Apply KUCK Classification
Now categorize each page:
Returns Keep, Update, Consolidate, or Kill with reasoning.
Information Gain: The 2026 Metric
Traditional audits miss something important. They only measure YOUR content. But Google compares you to everyone else.
Information Gain measures how much NEW value your page adds compared to what already exists.
Why it matters for SEO:
- Google's helpful content system rewards unique insights
- AI-generated content floods the web with duplicates
- Information Gain is your competitive moat
Returns a score from 0-100. Higher is better.
Zombie Pages: The Hidden Traffic Killer
Zombie pages exist but add no value. They dilute your site authority. They waste crawl budget. They confuse users.
How to identify them:
- Zero clicks in 90 days
- No internal links pointing to them
- Orphaned pages (no path from homepage)
- Duplicate or near-duplicate content
Returns all zombie pages with one click.
AEO Readiness: Preparing for AI Search
Answer Engine Optimization is no longer optional. Perplexity, Gemini, and ChatGPT are the new search engines. They need different content.
What they want:
- Clear, direct answers
- Structured data (FAQ, HowTo, Table)
- Entity clarity (who, what, where)
- Source citations
Returns readiness score and specific improvements.
Your Action Plan
You have the framework. Now execute.
Week 1: Build Your Audit Sheet
- Import content inventory with FITS
- Connect GSC and GA4 data
- Add KUCK classification column
Week 2: Process Your Queue
- Identify all Update pages
- Identify all Consolidate opportunities
- Identify all Kill candidates
Week 3: Execute
- Refresh top 5 Update pages
- Merge first Consolidate group
- Delete first batch of Kills
Week 4: Measure
- Check traffic change
- Check crawl efficiency
- Check information gain scores
Get Started With FITS
The old way of content audits is dead. Manual exports and stale data do not work in 2026. FITS automates the entire process in Google Sheets.