Content SEO Templates: Brief, Audit, Decay, Cannibalization, Calendar and CTR Test

Free SEO & GEO resources, 6 templates

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.

Content SEO Toolkit

Content SEO Toolkit preview

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.

How the connection works

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

2templates on Labs: Keyword Overviewdataforseo_labs/google/keyword_overview/live
2templates on On-Page APIon_page/task_post
2templates on Labs: Ranked Keywordsdataforseo_labs/google/ranked_keywords/live

What 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.

Step 1, template 19

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.

Step 2, template 20

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.

Step 3, template 21

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.

Step 4, template 22

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.

Step 5, template 23

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.

Step 6, template 24

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.

1. Pull the dataEach template names the exact DataForSEO endpoint and includes an example request. Labs, SERP, On-Page, Backlinks and AI Optimization (LLM Mentions) are all covered.
2. Run one commandThe included dataforseo_import.py turns the saved JSON response into the template's input CSV. It runs offline and never touches your credentials.
3. Paste and decideAdd the business inputs the API can't know, paste at Workspace cell A13, and the dashboard, checks and action list update.
Template DataForSEO source Columns it fills for you
SEO Content Brief Template Labs: Keyword Overview
dataforseo_labs/google/keyword_overview/live
Keyword
Content Audit Template On-Page API
on_page/task_post
Page URL
Content Decay Analysis Template Labs: Ranked Keywords
dataforseo_labs/google/ranked_keywords/live
Page URL
Keyword Cannibalization Checker Template Labs: Ranked Keywords
dataforseo_labs/google/ranked_keywords/live
Keyword, Landing page A
SEO Content Calendar Template Labs: Keyword Overview
dataforseo_labs/google/keyword_overview/live
Keyword
Title Tag CTR Test Calculator On-Page API
on_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.

Complete SEO & GEO Toolkit

All 40 templates and the field handbook in one download.

Jourdan Rombough

Built by Jourdan Rombough, technical SEO and GEO consultant. About Jourdan or see SEO services.

More on digital marketing in our blog

See all posts