Content Inventory Audit: Spreadsheet Template
Template spreadsheet untuk audit content inventory: identify thin content, duplicate, cannibalization, dan candidate untuk refresh atau deprecation.
Domain dengan 100+ konten butuh inventory audit tahunan. Tanpa ini, decay invisible: thin content diproduce, duplicate content accumulate, cannibalization steal rank. Template spreadsheet bawah yang saya pakai.
Columns spreadsheet
| Column | Data |
|---|---|
| URL | Full URL |
| Title | Current title tag |
| Published date | Original publish |
| Last updated | Last edit |
| Word count | Body text count |
| Organic traffic 90d | GSC atau GA |
| Top query | Query top 1 impression |
| Position | Average position 90d |
| Backlinks | Unique referring domain |
| Schema types | Schema.org used |
| Internal links in | Count |
| Internal links out | Count |
| Image count | Visual asset count |
| Author | Byline |
| Category / cluster | Topical grouping |
| Status | Active / refresh / deprecate |
| Notes | Action needed |
Decision matrix
| Content profile | Action |
|---|---|
| High traffic + recent + accurate | Active. Monitor only. |
| High traffic + old + accurate | Minor refresh. Update date + stat. |
| High traffic + old + inaccurate | Major refresh. Rewrite inaccurate section. |
| Medium traffic + old + accurate | Leave + add to refresh queue. |
| Low traffic + old + accurate | Evaluate. Either boost internal link atau deprecate. |
| Zero traffic 365+ days + thin | Deprecate (301 to related). |
| Duplicate dengan content lain | Consolidate. 301 smaller one. |
| Cannibalize (2 halaman rank untuk same query) | Merge atau differentiate. |
| Off-topic / irrelevant to current business | Noindex atau deprecate. |
Workflow
- Export semua URL dari sitemap
Atau crawl Screaming Frog.
- Populate data dari GSC, GA, tools
Batch export, copy ke spreadsheet.
- Sort by traffic descending
Focus high-traffic first.
- Categorize setiap URL
1-2 menit per URL. For 200 URL, 6-8 jam.
- Prioritize action list
P1 (high traffic + issue), P2 (medium), P3 (low impact).
- Execute batch action
Refresh, deprecate, consolidate.
- Re-audit 90 days later
Compare changes.
Frequency
Full inventory audit annual. Spot check quarterly. For high-velocity sites (news, blog heavy), semi-annually.
