Google Search Console opportunity sheet
Free Google Search Console opportunity sheet to rank queries by impressions, CTR gaps, ranking range, and page fit, then plan the next content action.
Metrics not filled unless verified. This asset is original to SEO Report Kit and uses synthetic sample data only — replace every sample value with your own verified analytics before sending a client report.
What a GSC Opportunity Sheet Is For
A Google Search Console opportunity sheet turns a raw query export into a shortlist of things worth doing. Search Console will hand you thousands of rows, most of which you will never act on. The sheet exists to filter that down: which queries already earn impressions but lose the click, which sit just outside the top results and could be nudged, and which point at a page that almost answers the intent but not quite. The output is not a report on what happened — it is a prioritized list of next content actions you can defend to a client.
This template is built for agencies and freelance consultants who run recurring optimization, not one-off audits. It sits between two other resources on this site: the GSC SEO report, which explains performance to the client, and the SEO report template, which frames the whole engagement. The opportunity sheet is the working layer underneath both — the place where you decide what to fix before any of it shows up in a client-facing update. You fill it from your own verified Search Console export and nothing else.
How the Sheet Is Organized
The workbook keeps one row per query so it stays sortable. Everything you need to triage a query lives on that row: the demand signal, the click gap, where it ranks, which page it lands on, and the action you have decided to take. Sorting by one column at a time is the whole method, so the columns are grouped to support the sorts you actually run during an engagement.
Three tabs keep the working file from collapsing into one giant table. The Queries tab is where triage happens. A Pages tab rolls queries up to the URL they serve, so you can see when several near-miss queries all point at one page that needs a single rewrite. A Decisions tab holds the shortlist you committed to, with owners and status, ready to feed the GSC SEO report at the end of the cycle.
- Queries tab: one row per query, carrying the demand, click-gap, ranking-range, page-fit, and action fields you sort and triage on.
- Pages tab: queries grouped by landing URL, so you can spot one page that several near-miss queries depend on.
- Decisions tab: the committed shortlist with owner, priority, and status, kept separate from the raw triage so the plan stays clean.
Field Map
Every query row uses the same columns so the sheet can be sorted by demand, by click gap, or by ranking range without reshaping it each time. The map below explains what each field is for and how to fill it from your own Search Console export rather than turning the sheet into a raw dump of the Performance report.
| Field | Purpose | How to use it |
|---|---|---|
| Executive summary | Gives the client the one-page decision surface before the tables. | Write what changed, why it matters, and what decision the client should make next. |
| KPI movement | Separates qualified traffic, visibility, conversions, and ranking movement. | Use verified exports only; leave unknown metrics blank instead of estimating them. |
| Work completed | Connects outcomes to actual SEO activity rather than implying every movement was caused by one task. | List shipped fixes, content updates, internal links, technical cleanup, and measurement changes. |
| Next actions | Turns the report into a scope tool for the next sprint or retainer month. | Assign an owner, a priority, and a reason for each action. |
Filling the Sheet During an Engagement
Work in passes, not one sweep. Export your Search Console query data for a sensible window, paste it into the Queries tab, then sort the file once per signal and tag candidates as you go. The order matters: you are narrowing a long list to a handful of decisions, and each pass throws out rows the previous pass kept for a different reason.
Resist the urge to write actions while you are still sorting. Tag candidates first, group them on the Pages tab, and only then decide what to do — because the right move for five queries pointing at one weak page is usually a single rewrite, not five separate notes. The sheet is finished for the cycle when the Decisions tab holds a short, owned list you could drop straight into the GSC SEO report.
- Sort by impressions to find queries with real demand, then ignore the long tail of one-off rows.
- Sort by the CTR gap to surface queries that get seen but not clicked, where a title or snippet rewrite is the cheap fix.
- Filter by ranking range to isolate queries sitting just outside the top results, where small on-page work tends to pay off.
- Group tagged candidates by page on the Pages tab, then commit the survivors to the Decisions tab with an owner.
Checks Before You Act on It
An opportunity sheet is only as trustworthy as the export behind it, and the actions you draw from it land in front of a client. Before you commit the Decisions tab, confirm the reporting window and property are stated on the file, that you have not mistaken a seasonal spike for durable demand, and that every committed action names the page it changes and why. The aim is a list you can stand behind in a review, not the longest list you can produce.
- The Search Console property, reporting window, and any market or filter are written on the sheet.
- Click-gap candidates are checked against intent, so you are not chasing queries the page should not rank for anyway.
- No invented numbers: every impression, position, and CTR value comes from the export, and unknown cells stay blank.
- Each committed action names a single page and a clear reason, ready to carry into the GSC SEO report.
FAQ
Google Search Console opportunity sheet FAQ
What is a Google Search Console opportunity sheet?
It is a working spreadsheet that turns your Search Console query export into a prioritized list of optimization actions. Instead of reading thousands of rows, you sort queries by demand, click gap, and ranking range, then commit a short list of next content actions. The GSC opportunity sheet CSV on this page gives you that structure already laid out.
How is this different from a GSC SEO report?
The opportunity sheet is the working layer where you decide what to fix; the GSC SEO report is the client-facing document that explains performance and the work you completed. You fill the sheet first to triage queries, then carry the committed decisions into the report. They are complementary, not interchangeable, and both are covered on this site.
Which queries should I prioritize in the sheet?
Start with queries that already earn meaningful impressions but lose the click, since a title or snippet rewrite is usually the cheapest fix. Then look at queries ranking just outside the top results where small on-page work can move them. Always sanity-check that the page is the right answer for the query before committing an action.
Does the sheet include any keyword or traffic numbers?
No. Every metric cell is filled from your own verified Search Console export, and the template ships with synthetic sample rows that you replace. The project rule is to never invent impressions, positions, CTR, or volume, so unknown values stay blank rather than estimated.
Can I use this opportunity sheet for client work?
Yes. The file is original and built from synthetic sample data, so you can adapt it freely for client engagements. Replace the sample rows with your own export, state the property and reporting window on the sheet, and keep the Decisions tab to actions you can defend in a review.