Content SEO Templates: Brief, Audit, Decay, Cannibalization, Calendar and CTR Test
Content SEO Templates: Brief, Audit, Decay, Cannibalization, Calendar and CTR Test
Six free content SEO templates for the full content lifecycle: brief new pages for search and AI answers, audit and prune what exists, diagnose decay, fix cannibalization, schedule production and test titles honestly.
- 6 Excel workbooks with dashboards
- 6 PDF field guides
- Blank and worked CSV templates
- DataForSEO import scripts
Free, no email required. Version 3.0, updated November 2026.

Every Content SEO template connects to DataForSEO
Each workbook names its endpoint, ships with an example request and converts the saved response with one command.
DataForSEO APILabs, SERP, On-Page, Backlinks and AI Optimization endpointsapi.dataforseo.com/v3/
Save the JSON responseYour untouched source of truth.response.json
Run one commandThe included script maps it to the template's columns.dataforseo_import.py import
Paste and decideDashboard, checks and action list update.Workspace!A13
dataforseo_labs/google/keyword_overview/liveon_page/task_postdataforseo_labs/google/ranked_keywords/liveWhat this toolkit is for
Content programs swing between two failures: publishing new pages nobody needed, and ignoring old pages that quietly lose traffic. A content system needs both a way to make good pages and a way to maintain them.
This content SEO toolkit gives you both halves. The content brief template is built around real questions and original evidence, so pages are worth citing. The audit, decay and cannibalization templates tell you what to keep, refresh, merge or retire and why. The calendar turns all of it into scheduled work, and the CTR test tells you whether a title change actually helped.
The 6 templates, in the order to use them
New pages start at the brief. Existing content starts at the audit, with decay and cannibalization as the diagnostic follow-ups. Everything lands in the calendar.
SEO Content Brief Template
A content brief built for Google and AI answers: real questions, original evidence, sources and a three-step approval workflow.
Which sections of a page are ready to publish, and what each unfinished section needs next: writing, fact-checking or editor approval.
Content Audit Template
Score every URL by lost clicks, conversions and links, choose keep, refresh, merge or retire, and catch the risky calls.
What to do with each existing page (keep, refresh, merge or retire) and which decisions would throw away conversions, links or a merge destination.
Content Decay Analysis Template
Separate lost impressions, lower CTR and falling demand, so you refresh the pages that really decayed.
Whether a page lost clicks because it lost rankings, lost CTR or the market lost interest, and how big the demand-adjusted gap is.
Keyword Cannibalization Checker Template
Find queries splitting clicks across two URLs, check whether intent really overlaps and decide whether to consolidate.
Which query and URL pairs are true cannibalization worth consolidating, which are distinct intents to leave alone, and which page should win.
SEO Content Calendar Template
Track owners, due dates and estimated vs completed hours, and flag overdue work automatically.
What's published, what's in production, what's overdue, and how many production hours remain against your capacity.
Title Tag CTR Test Calculator
Compare two CTRs with a 95% interval and plain-English verdicts, so you don't ship a title change that was just noise.
Whether a title or snippet change produced a CTR difference that's distinguishable from noise, with honest labels for small samples and non-randomized comparisons.
Built to run on DataForSEO
Every template in the Content SEO Toolkit is designed around a DataForSEO endpoint. Pull the data, convert it with the included script, add the inputs only you know, and paste.
dataforseo_import.py turns the saved JSON response into the template's input CSV. It runs offline and never touches your credentials.| Template | DataForSEO source | Columns it fills for you |
|---|---|---|
| SEO Content Brief Template | Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live |
Keyword |
| Content Audit Template | On-Page APIon_page/task_post |
Page URL |
| Content Decay Analysis Template | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Page URL |
| Keyword Cannibalization Checker Template | Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live |
Keyword, Landing page A |
| SEO Content Calendar Template | Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live |
Keyword |
| Title Tag CTR Test Calculator | On-Page APIon_page/task_post |
Page URL |
Each template page walks through its exact request, and each ZIP includes HOW-TO-USE-WITH-DATAFORSEO.txt, an example request file and the import script. Estimate costs first with the DataForSEO pricing calculator.
What's in every workbook
- Start Here: the decision it answers, a four-step setup and a colour key.
- Dashboard: KPI cards, a result breakdown or Top 10 chart, and an automatic action list of the rows that need attention.
- Workspace: the working table with dropdowns, Yes/No fields, range checks and colour-coded results.
- Delivery QA: a sign-off register that only counts a check as Verified with evidence, an owner and a date.
- Field Guide: every input defined and every formula written out in plain English.
Each ZIP also includes the PDF field guide, blank and worked CSV templates, and an offline script that turns saved DataForSEO API responses into the input CSV.
Frequently asked questions
What is the best content audit template?
One that ends in a decision per URL and protects value. This one records lost clicks, conversions and links, then flags risky retirements and merges without destinations.
How do I write a content brief for AI search?
Organize it around specific questions, name the original evidence you'll add and cite primary sources. The SEO content brief template is built that way.
How often should I audit content?
Annually for most sites, with quarterly checks on your most valuable pages.
Can freelancers use these templates?
Yes. They're plain XLSX files that also work in Google Sheets.
The other five toolkits
Keyword Research Toolkit
Six connected spreadsheets that take you from a raw keyword export to a ranked, mapped, season-aware plan: prioritization, keyword mapping, SERP clustering, gap analysis, seasonality and visibility tracking.
SEO Migration Toolkit
Everything a site migration needs to keep its traffic: a URL inventory, a redirect map with built-in QA, a launch checklist with blocker flags, control-adjusted post-launch monitoring, and indexability and hreflang audits.
Technical SEO Toolkit
Turn crawl findings into a ranked fix queue, then validate the work: fix prioritization, crawl budget and log analysis, Core Web Vitals, internal links, XML sitemaps and schema markup QA.
AI Visibility & GEO Toolkit
Measure and improve how AI answer engines see you: prompt research, an AI citation tracker, AI share of voice, an answer evidence audit, a brand entity audit and AI referral tracking.
SEO Business & Delivery Toolkit
The business side of SEO in ten workbooks: forecasting, ROI, split testing, link reclamation, local rank grids, ecommerce prioritization, programmatic SEO QA, API budgeting, client onboarding and a 90-day roadmap.
Built by Jourdan Rombough, technical SEO and GEO consultant. About Jourdan or see SEO services.






