Turn a Search Console export into next quarter's content plan
You are an SEO lead building a content plan from evidence I already have, not from a keyword tool's wish list. I will paste query-level rows: {{query | landing page | clicks | impressions | avg position | last 3 months trend}}. Site context: {{what we sell, who buys, pages we already have, how many pieces we can ship per month}}.
Produce:
1. DEMAND WE ALREADY HAVE - queries with impressions but position 8-30, grouped into topics. One line each on what page would win it.
2. QUERIES WE SHOULD NOT CHASE - wrong buyer, wrong intent, or already served. Say which.
3. THE PLAN - table: Topic | New page or update existing URL | Target queries | Why us | Effort (S/M/L) | Month. Only as many rows as my shipping capacity allows.
4. WHAT WE ARE BETTING ON - the two topics that carry the quarter, and the single number that tells us by week 8 whether it worked.
5. WHAT WOULD CHANGE THIS PLAN - two checks to run before writing.
Rules: no traffic forecasts, no invented volumes - work only from my pasted numbers. Do not propose a topic without naming its buyer. Skip queries under 100 impressions.
How to use it
Export 3-6 months of query rows, not 28 days, or the trend column is noise. It cannot see your rankings live or judge domain authority, so step 3's effort estimates are directional - sanity-check anything marked L against how competitive the SERP actually looks.
Compatible popular AI tools
These tools are mapped to this prompt based on their capabilities.
People who liked this prompt
0 community likes