Stop 1 of 8 · Weekly
Search Console to opportunities
Two exports in, one ranked list of ten out, with the reason each page is on it.
The month starts with two files
On the first Monday, Priya exports two reports from Search Console for Summit Physical Therapy: queries and pages, last three months against the previous three, comparison switched on. Two CSVs, a few thousand rows each. They used to sit in a folder until a quiet afternoon that never came.
The change is not that Claude reads them faster. It is that you stop asking "what does this data say" and start asking for the three patterns that turn into work.
The three patterns worth pulling out
| Pattern | What it looks like in the export | What it buys you |
|---|---|---|
| Striking distance | Position 8 to 20, real impressions, one page ranking | A title, an H2 and a paragraph on a page you already have |
| Declining page | Clicks down over 20 percent, position roughly flat | Something changed on the result page, not on yours |
| Cannibalisation | One query, two of your URLs swapping as the ranked page | A merge, a redirect, or an internal link pointing one way |
Striking distance is where a six-clinic site earns fastest, because the page exists and the writer is not involved. Cannibalisation is the one nobody finds by eye, because it only shows up when you compare the ranking URL across two periods.
Try this
[upload the Search Console query export and the page export, both with comparison on] From the query export, list every query at average position 8 to 20 with more than 300 impressions and a click-through rate under 2 percent. For each one, use the page export to name the URL that ranks for it now. One table: query, impressions, position, ranking URL, and one line on what that page is probably missing. Sort by impressions. Do not guess search volume, use only the impressions in the file.
[upload both exports] List every page whose clicks fell more than 20 percent between the two periods. Split them into two groups: pages where average position also fell, and pages where position held or improved. For the second group, tell me what to check on the live result page, because a click loss with a steady position usually means something new appeared above us.
[upload the query export for both periods] Find every query where the ranking URL is different in the two periods and both URLs are on our domain. For each, show the query, both URLs, and impressions and position for each period. Then tell me which of the two pages looks like the better target and what the other one should become: a merge, a redirect, or a supporting page that links up.
The list Priya actually hands out
Three tables are not a plan. The last ask of the session turns them into one:
"Combine everything above into one ranked list of ten. Each line: the URL, the query, the reason it is on the list, and whether the fix is copy, a technical change, or a new page. Rank by impressions at stake, not by how easy it is."
Ten is the number because it fits a month with one writer and an agency queue. Anything past ten is next month's list.