Every publisher has more topic ideas than they have capacity to produce. The editorial calendar is always oversubscribed, and someone has to decide what makes it in and what doesn’t.

In most operations, that decision is made through a combination of editorial judgment, team brainstorming, trending conversations, and intuition about what the audience wants. These inputs have value — experienced editors often have strong instincts about their readers. But intuition alone leaves too much to chance.

The data that would make these decisions more precise is already available. Keyword research shows what your audience is actually searching for. Performance analytics show which of your existing content works and which doesn’t. Audience behavior data shows how readers move through your site and where they drop off. Competitive data shows where the gaps and opportunities in your market exist.

The publishers who use this data systematically in their editorial planning consistently outproduce those who rely on instinct — not because they publish more, but because a higher percentage of what they publish actually performs.

The data sources

Four categories of data inform what to publish next. Each answers a different question, and the strongest editorial decisions draw from all four.

Search demand data

What it tells you: What your audience is actively looking for — the exact queries they’re typing into search engines.

Where it comes from: Keyword research tools (Ahrefs, SEMrush, Moz), Google Search Console, Google Trends, AnswerThePublic, AlsoAsked.

How to use it:

Volume indicates interest. A keyword with 2,000 monthly searches represents a validated audience for that topic. A topic with no measurable search volume might be editorially interesting but isn’t an organic traffic opportunity.

Question-format queries reveal intent. “How to measure content ROI” tells you exactly what the searcher wants to learn. Building content that directly answers these questions aligns with search intent and ranks well.

Trending vs. stable demand. Google Trends distinguishes between topics with growing search interest and topics with stable or declining interest. Prioritize topics with stable or growing demand for evergreen content.

Keyword difficulty reveals feasibility. A high-volume keyword that your site has no realistic chance of ranking for isn’t a practical opportunity. Combine volume with difficulty scores to identify keywords where both interest and feasibility align.

Performance data from your existing content

What it tells you: What’s already working on your site, what’s close to working, and where your strengths and weaknesses lie.

Where it comes from: Google Analytics, Google Search Console, your CMS analytics.

How to use it:

Your top-performing articles indicate topic authority. If your best organic content is about content operations, that’s a signal — your domain has authority in that space, and additional content on related topics will benefit from it. Double down on what’s working.

Your “almost there” content indicates immediate opportunities. Articles ranking between positions 4 and 20 for valuable keywords represent topics where you’ve already demonstrated relevance. Publishing supporting content in the same cluster can strengthen these rankings — sometimes without touching the original article.

Your underperforming content indicates misfires. Look for patterns in content that generates no organic traffic. Is it targeting keywords with no demand? Is it competing in segments that are too competitive? Are the articles too thin? These patterns reveal what to avoid in future editorial planning.

Query data from Search Console reveals unmet demand. Search Console shows every query your site appears for in search results — including queries where you’re appearing at position 20 or 30 with minimal clicks. These are topics Google already associates with your site but where you lack strong, dedicated content. They’re free topic suggestions backed by data.

Audience behavior data

What it tells you: How readers actually interact with your content — what they engage with, where they drop off, and what they do after reading.

Where it comes from: Google Analytics (behavior flow, engagement metrics), heatmap tools (Hotjar, Microsoft Clarity), internal search data, newsletter engagement data, social engagement data.

How to use it:

On-site search queries show unmet needs. If readers are searching your site for “content audit template” and you don’t have a page for it, that’s an editorial gap identified directly by your audience.

Pages with high traffic but high bounce rates indicate intent mismatch. The topic is right (people are coming), but the content isn’t satisfying (they’re leaving immediately). This might mean the content needs to be different — more specific, more practical, or structured differently.

Content that generates navigation indicates interest. Articles where readers frequently click through to other pages are signaling that the topic area has depth worth exploring. Invest more content in these areas.

Newsletter performance reveals audience preferences. Which topics get the highest open rates and click-through rates in your newsletter? This is direct audience feedback on what they want to read — and it’s a strong indicator of what they’d search for.

Competitive data

What it tells you: Where your competitors are investing their content resources, where they’re succeeding, and where they’ve left gaps.

Where it comes from: SEO tools (Ahrefs, SEMrush), competitor site analysis, industry monitoring.

How to use it:

Competitor content gaps are your opportunities. If competitors in your space aren’t covering a topic that has search demand, that’s an underserved niche you can fill.

Competitor keyword gains indicate market shifts. If a competitor is gaining rankings for a set of keywords you haven’t targeted, it might signal emerging demand in that area. Evaluate whether to invest there.

Competitor weaknesses indicate beatable positions. If a competitor ranks for a keyword with thin, outdated, or low-quality content, that’s an opportunity to produce something better and take the position.

The decision framework

Data from these four sources needs to be synthesized into editorial decisions. Here’s a framework for doing that.

Step 1: Generate candidates

Combine inputs from all four data sources into a single candidate list. Each candidate is a potential topic for the editorial calendar. Sources include:

• High-potential keywords from keyword research
• Topic gaps identified from Search Console query data
• Supporting content needed for existing clusters
• Refresh opportunities for underperforming existing content
• Gaps identified in competitive analysis
• Topics with strong audience engagement signals (newsletter, on-site search, social)

This list will be larger than your production capacity — that’s the point. You want more options than slots so you can prioritize.

Step 2: Score each candidate

For each topic on the list, evaluate against four criteria:

Demand (1–5): Is there validated search demand? A score of 5 means high, stable search volume. A score of 1 means no measurable search demand (the topic is editorially motivated, not search-motivated).

Feasibility (1–5): Can you realistically rank for this topic? A score of 5 means low competition, existing domain authority in the area, and a clear path to page one. A score of 1 means dominant competitors with insurmountable authority advantages.

Strategic value (1–5): Does this topic support a cluster you’re building? Does it fill a gap in your content architecture? Does it target an audience segment you’re trying to reach? A score of 5 means it’s architecturally important. A score of 1 means it’s a standalone piece with no structural role.

Revenue potential (1–5): Does the topic attract an audience you can monetize? High-intent queries with commercial relevance score higher. Purely informational topics with no monetization path score lower.

A simple weighted total — or even an unweighted sum — gives you a rank-ordered priority list. The top of the list is where your editorial resources should go.

Step 3: Map to the editorial calendar

Take your prioritized list and map topics to your production capacity:

• Top-priority topics get assigned to your best writers with the most thorough briefs
• Cluster-building topics get grouped into production batches for efficiency
• Refresh candidates get allocated to the maintenance portion of your editorial capacity
• Lower-priority topics stay on the backlog for future planning cycles

Step 4: Review and iterate monthly

The data changes. Search volumes shift. Competitors publish new content. Your own performance data reveals new patterns. Run the scoring process monthly (or at minimum quarterly) to ensure the editorial calendar reflects current reality rather than last quarter’s analysis.

What this process replaces

To be clear about what this framework is displacing: it’s not replacing editorial judgment. It’s augmenting it with data that makes the judgment better.

Before (intuition-driven):

• Topic brainstorming → “This feels like an important topic”
• Limited keyword check → “It has some search volume”
• Assignment → “Write 1,500 words on this”
• Publish → hope for the best

After (data-informed):

• Systematic demand analysis → “This keyword has 1,800 monthly searches, difficulty of 25, and we already rank for 3 related terms”
• Competitive and audience validation → “Top-ranking content is thin and outdated; our newsletter data shows strong audience interest”
• Structured brief → “Here’s the target keyword, search intent, competitive gaps, recommended structure, and internal linking plan”
• Publish → measure against specific expectations and feed data back into the next planning cycle

The second process takes more upfront time — roughly 2–3 hours per planning cycle for a month’s editorial calendar. But the content it produces has a dramatically higher expected return because every piece is validated before production begins.

Common resistance and how to address it

”This kills editorial creativity”

It doesn’t. It focuses creativity. A writer given a well-researched brief with a clear keyword target, competitive gaps to exploit, and a specific audience need to address has more creative fuel than a writer given a blank page and a vague topic.

The data answers “what to write about.” The writer still decides how to write about it — the angle, the voice, the structure, the storytelling. Data-informed doesn’t mean formulaic.

”We know our audience better than the data does”

Maybe. But the data often reveals things that even experienced editors miss. The keyword your audience is searching 2,000 times a month that nobody on the editorial team considered. The topic cluster where your domain already has authority that nobody realized. The content gap where a competitor is weak that nobody checked.

Editorial knowledge and data are complementary, not competing. The strongest decisions use both.

”This takes too long”

The initial setup — building keyword maps, establishing performance baselines, creating the scoring framework — takes 1–2 weeks of focused work. After that, the monthly planning cycle adds 2–3 hours to editorial planning.

The alternative — the time lost to producing content that never ranks, the opportunity cost of targeting the wrong topics, the months wasted on articles with no search demand — costs far more.

”What about timely content that doesn’t have search data?”

Not every article needs to be a search play. News analysis, opinion columns, event coverage, and trend commentary serve brand and audience engagement purposes that are separate from organic search.

The data-informed framework applies to content intended for organic search — which, for most publishers, should be the majority of production. Reserve a portion of editorial capacity (20–30%) for timely and brand content that isn’t evaluated against search metrics.

The compounding effect

Data-informed editorial planning doesn’t just improve individual article performance. It compounds.

Each planning cycle builds on the last — the performance data from previous articles informs the next round of decisions. Each cluster grows stronger as new supporting content is added to areas where the data shows authority building. Each successful article raises the domain’s authority, making the next article easier to rank.

A publisher running this process for 12 months has a fundamentally different content portfolio than one publishing on instinct for the same period — more articles performing, more clusters building authority, more organic traffic compounding.

The data to make better editorial decisions is already available. The question is whether you’re using it — or whether you’re still deciding what to publish next based on what felt right in last Tuesday’s brainstorm.