Claude SEO Prompt: Search Console Export to Refresh Plan

Prompt

Act as an SEO content strategist working in Claude who reads a site's Google Search Console performance export row by row, recomputes CTR from clicks and impressions, and picks the few pages worth refreshing first, with reasons a site owner can check.

Inputs:
- Search Console rows: page, query, clicks, impressions, average position: [SearchConsoleExport]
- The date range of the export: [DateRange]
- Each page's URL, purpose, word count, and last update: [PageInventory]
- What the site needs from search (signups, sales, readers): [SiteGoal]
- Hours available for edits this month: [EditBudget]
- Brand voice and words to avoid: [BrandVoice]

Generate:
1. Data check: a table of every row with CTR recomputed as clicks divided by impressions, and any row where the export's numbers look inconsistent.
2. Striking distance: queries with an average position of roughly 8 to 20 and real impressions, each with the page that ranks and what the page is missing for that query.
3. Pages competing for one query: any query where two or more pages from PageInventory appear, which page should be the main one, and what to change on the other (shorten, link, or merge), without deleting pages.
4. Refresh shortlist: the top three pages to edit within EditBudget, ranked, each with a one-line reason tied to the numbers.
5. For each shortlisted page: two title options and one meta description in BrandVoice that front-load the query; the new sections or answers to add, written as H2s; and internal links to add from PageInventory with anchor text.
6. Leave alone: rows that are doing well and should not be touched now, and why.
7. Measurement plan: the date to log each change, the comparison window in Search Console (the same number of days before and after), and the two numbers to compare per page.

Rules:
- Use only the rows in SearchConsoleExport and pages in PageInventory; no search volumes, competitors, or rankings that were not pasted.
- No fixed character rules for titles or metas; Google truncates by pixel width and may rewrite them.
- Show every CTR to two decimals and recheck the math.

Instructions

Export the Performance report from Google Search Console (queries and pages for one date range), paste it into a Claude chat with your page list, and fill in the brackets. To reuse it every month, create a Claude Project, add the export and page list to the project's knowledge, and paste the Rules into the project instructions. Claude only sees what you paste or upload, so check every number against Search Console before you change a page. Google may rewrite titles and snippets, and no change guarantees a ranking.

Generated Output

This image was generated using the prompt above.

Claude SEO Prompt: Search Console Export to Refresh Plan - Result

Examples

Example Input

SearchConsoleExport:
/blog/sourdough-starter-guide | sourdough starter not rising | 18 clicks | 2,400 impressions | position 9.4
/blog/sourdough-starter-guide | how to feed sourdough starter | 41 clicks | 1,150 impressions | position 4.2
/blog/sourdough-discard-recipes | sourdough discard crackers | 6 clicks | 1,900 impressions | position 12.8
/recipes/discard-crackers | sourdough discard crackers | 22 clicks | 860 impressions | position 7.1
/blog/banneton-care | how to clean a banneton | 3 clicks | 640 impressions | position 15.3
DateRange: August 1 to September 30, 2026.
PageInventory: crumbandcrust.example. /blog/sourdough-starter-guide (how to make and feed a starter, 1,800 words, updated March 2025, no troubleshooting section); /blog/sourdough-discard-recipes (list of 8 discard recipes, 2,100 words, crackers section is 150 words); /recipes/discard-crackers (full cracker recipe with steps, 700 words); /blog/banneton-care (300 words, no steps); /shop/banneton-kit (product page).
SiteGoal: newsletter signups first, banneton kit sales second.
EditBudget: 6 hours this month.
BrandVoice: warm, practical, home baker to home baker; avoid "ultimate" and "hack".

Example Output

1. DATA CHECK (CTR = clicks / impressions)
- starter guide | starter not rising | 18 / 2,400 = 0.75% | pos 9.4
- starter guide | how to feed | 41 / 1,150 = 3.57% | pos 4.2
- discard recipes | discard crackers | 6 / 1,900 = 0.32% | pos 12.8
- discard crackers recipe | discard crackers | 22 / 860 = 2.56% | pos 7.1
- banneton care | clean a banneton | 3 / 640 = 0.47% | pos 15.3
No rows look inconsistent.

2. STRIKING DISTANCE
- "sourdough starter not rising" (pos 9.4, 2,400 impressions): the starter guide has no troubleshooting section, so it answers this query only in passing.
- "how to clean a banneton" (pos 15.3, 640 impressions): banneton care is 300 words with no steps.

3. PAGES COMPETING FOR ONE QUERY
"sourdough discard crackers": the recipe page (pos 7.1) should be the main page. On the discard recipes list, cut the 150-word crackers section to two sentences and link to the recipe with the anchor "sourdough discard crackers recipe". Keep both pages.

4. REFRESH SHORTLIST (6 hours)
1) Starter guide, about 3 hours: most impressions of any row at a page-one-edge position.
2) Banneton care, about 2 hours: thin page, and it supports the kit, your second goal.
3) Discard recipes list, about 1 hour: one section edit and a link.

5. PAGE EDITS
Starter guide
- Titles: "Sourdough Starter Not Rising? How to Make, Feed, and Fix It" / "Sourdough Starter Guide: Feeding, Timing, and When It Won't Rise"
- Meta: "Starter not rising? Check these common causes, then feed and time your starter with a simple home baker routine."
- Add H2s: "Why is my sourdough starter not rising?" (answer first, then each cause as a short step) and "How long should a starter take to rise?"
- Links: to /blog/banneton-care ("caring for your banneton") and a newsletter signup box after the troubleshooting section.
Banneton care
- Titles: "How to Clean a Banneton After Every Bake" / "Banneton Care: Clean, Dry, and Store Your Proofing Basket"
- Meta: "How to clean a banneton after each bake, dry it fully, and store it, in a few simple steps from one home baker to another."
- Add H2s: "How to clean a banneton, step by step" and "How to dry and store it".
- Links: to /shop/banneton-kit ("banneton kit") and to /blog/sourdough-starter-guide ("starter guide").
Discard recipes list
- Shorten the crackers section and link to /recipes/discard-crackers as above.

6. LEAVE ALONE
"how to feed sourdough starter" (pos 4.2, CTR 3.57%) is already on page one; do not change the section that answers it while you edit the guide.

7. MEASUREMENT PLAN
Log the date of each edit. After 28 days, compare those 28 days with the 28 days before the edit in Search Console's date comparison, filtered to the page. Compare impressions and clicks for the target query on each page.