---
title: "Content Gap Spreadsheet: Fields a Lean Team Should Log Before Briefing"
description: "Copy the fields a content gap analysis template must lock—topic, existing URL, evidence, information gain, and create, expand, merge, or skip—before any brief."
url: "https://articles.flowcrews.com/content-gap-spreadsheet-fields-a-lean-team-should-log-before-briefing"
category: "Guides"
date_published: 2026-11-12
reading_time_minutes: 8
word_count: 1908
---

# Content Gap Spreadsheet: Fields a Lean Team Should Log Before Briefing

*A fail-closed field list so a one-person sheet decides create, expand, merge, or skip before a brief opens.*

![Content Gap Spreadsheet: Fields a Lean Team Should Log Before Briefing](https://pub-07fb5e4955ba485b822d6b388be96d9a.r2.dev/2e474d51-a072-472e-ab2f-1a43a8990566/content-gap-spreadsheet-fields-a-lean-team-should-log-before-briefing/hero-c12550dc-da80-4000-889b-5bbdc49b66c8.jpg)

**TL;DR:**

- Log one row per topic cluster, not per keyword.
- Every row needs an existing URL or none, a gap type, competitor evidence, and a create, expand, merge, or skip decision.
- Do not brief a new URL when a relevant page already exists.
- Inside-out gaps from Search Console, roughly positions 8 to 30, often beat a raw competitor export.
- AI visibility notes belong on the same sheet only when the observation repeats.

## What fields should a content gap spreadsheet include before a brief?

## Content gap vs keyword gap

## How many competitors a one-person team should compare—and which URLs may enter the brief

## When a gap becomes a new page, an update, a merge, or a skip

## How to run a content gap analysis without Ahrefs or Semrush

## Turn hundreds of gap keywords into one topic row

## How to score priority when search volume is a poor proxy

## How to log an AI citation or GEO gap so one prompt run is not proof

## How often to rerun the gap sheet—and what it should refuse to automate

## Conclusion

- Brief-ready row — Log the buyer question, evidence source, an existing URL or an explicit none, gap type, two to five similar-size sources, an information-gain note, and a locked create, update, merge-and-redirect, or skip call before anyone opens a brief.
- Keyword gap versus content gap — A missing query stays in the evidence column; a content gap is a competitor-covered topic plus a page action, and a page-level gap almost never justifies a new URL.
- Competitor cap — A one-person team compares two to five similar-size rivals, and a URL enters the brief only after a human confirms it answers the same buyer question—raw exports and single AI-prompt URLs do not.
- Action rule — Create only when no live page can absorb the question; otherwise update a close page, merge and redirect competing URLs, or skip thin, irrelevant, or low-gain queries, because a blank decision blocks the brief.
- Lean fill and clustering — Inventory URLs with a free crawl, treat Search Console queries around positions 8 to 30 as update candidates, and collapse hundreds of keywords into one topic row per buyer question.
- Priority, AI, and reruns — Score impressions, buyer fit, a close existing URL, and a specific information-gain note rather than volume; log an AI or GEO miss only if it repeats, then rerun when inventory, shipped URLs, or rivals change—not on a weekly export—and never automate the decision.

Lock the action cell on each topic row, then hand only those closed decisions to the brief generator and date them on the content calendar.

## Frequently Asked Questions

### What is a content gap analysis template actually for?

It is a decision sheet, not a keyword dump. Ahrefs defines content gap analysis as finding topics competitors have covered that you have not, then assigning a page action.

### Should each keyword get its own row?

No. Log one row per topic cluster. Keywords with fewer than 10 monthly searches make up almost 93% of Ahrefs' US keyword database, so a page per term creates work that will not rank.

### When should a gap become a new page?

Only when the row records an explicit none for the existing URL and the topic is relevant. Creating a new URL when a relevant page already exists is the most common way gap analysis backfires.

### Why prefer expand over create?

A page that is already close is usually faster to improve. Only 1.74% of newly published pages reached Google's top 10 within a year in Ahrefs' 2025 study.

### How many competitors belong on the sheet?

Two to five real search competitors keeps the list usable. Ahrefs Content Gap can compare up to 10 and Semrush Keyword Gap up to five, but more sources do not make a better brief.

### Can one AI prompt run justify a brief?

No. Across 972 repeated runs, 42.9% of prompt-engine pairs flipped between mentioning and not mentioning the brand. Log AI gaps only as repeated observations.

## Sources

- [https://www.rickwhittington.com/blog/how-to-use-a-content-gap-analysis](https://www.rickwhittington.com/blog/how-to-use-a-content-gap-analysis)
- [https://ahrefs.com/blog/content-gap-analysis/](https://ahrefs.com/blog/content-gap-analysis/)
- [https://qck.co/blog/content-gap-analysis](https://qck.co/blog/content-gap-analysis)
- [https://www.airanklab.com/blog/ai-content-gap-analysis](https://www.airanklab.com/blog/ai-content-gap-analysis)
