What Is Google Search Console? How to Find Content Opportunities In It
Google Search Console is the only free record of what people searched before they saw you. Here is how to read it and turn the queries report into content.

Google Search Console is the only free source of the actual words people typed before they saw your site. Not estimated volumes from a keyword tool, not a sample, not a guess. The real queries, with the real positions you held and the real number of times you appeared.
Most businesses verify it, look at the traffic graph for a month, and never open it again. That is a shame, because the queries report is a list of things your customers want that you have already half-ranked for, which makes it the cheapest content brief you will ever get. This guide covers what each report is for, the one limit that costs people data permanently, and five specific opportunities that sit in the Performance report waiting to be read.
What Search Console Is
Search Console reports on the search side of your site: what Google crawled, what it indexed, which queries you appeared for, and where you ranked. You verify ownership of a property, and from then on Google shows you its own record of your site.
That makes it different from Google Analytics in a way worth being precise about. Analytics starts when someone arrives on your site. Search Console covers everything before that: the impression, the position, the click that did or did not happen. A page with 4,000 impressions and 11 clicks is invisible in Analytics and obvious in Search Console.
Two things it will not tell you. It reports a sampled and truncated set of queries, so the totals in the queries table will not add up to the totals in the chart. And it says nothing about why a page underperforms, only that it does. Causes you work out yourself.
The Reports Worth Your Time
Six parts of the interface carry almost all the value.
Performance. Impressions, clicks, average CTR and average position, filterable by query, page, country, device and search appearance. This is where content decisions get made.
Pages (indexing). Which URLs are indexed and which are excluded, with the reason for each exclusion. Check this after any site migration or template change.
URL Inspection. What Google knows about one specific URL: last crawl, rendered HTML, canonical chosen, indexing status. The fastest way to settle an argument about whether a page is live in Google's eyes.
Sitemaps. Submit your XML sitemap and see how many of its URLs Google has processed.
Experience. Core Web Vitals field data from real users, split by mobile and desktop.
Enhancements. Validation for the structured data types Google recognises on your pages, so broken schema shows up here rather than silently failing.
If a page is missing from Google entirely, the indexing reports are the starting point, and our guide on why a website is not showing up on Google walks the full diagnostic path. If pages were ranking and then slipped, the pattern in Performance matters more than the absolute numbers, which is the subject of why Google rankings drop.
The 16-Month Limit Costs People Data Permanently
Search Console keeps 16 months of data. Month 17 is gone, and no support request brings it back.
For a business that wants a year-over-year comparison, that window is tighter than it sounds: by the time you think to compare this October against last October, you are close to the edge. Export the Performance report monthly, by query and by page, into a spreadsheet you own. Five minutes a month protects the only first-party search history your business has.
This matters more as AI search grows, because the baseline of what your traffic looked like before AI Overviews started absorbing clicks is becoming the most useful comparison you can hold, and it expires on a rolling basis.
Sitting on a Search Console account nobody has read in six months? Get a Free Visibility Audit โ
The Export Limit Nobody Mentions Until It Bites
Here is the detail that undermines most Search Console analysis: Google caps exports from the interface at 1,000 rows. If your site appears for 8,000 queries, the spreadsheet you just downloaded is the top 1,000 and the long tail is simply absent. Every opportunity in the section below gets harder to find, because the interesting queries are rarely in the top thousand.
Three ways around it, in order of effort.
Slice by date and by page. Running the same export across four separate weeks, or filtered to one page at a time, returns a different 1,000 rows each time. Tedious, free, works today.
Use the API, which returns up to 50,000 rows per day per search type. This is the right choice for most businesses with a few thousand pages.
Set up Bulk data export to BigQuery, which sends all available Performance data with no row cap. It is owner-only, configured under Settings then Bulk data export, and it needs a Google Cloud project with billing enabled, the BigQuery API turned on, and the service account [email protected] granted the BigQuery Job User and Data Editor roles. Two warnings: Search Console wants the project ID rather than the project number, and the export is not retroactive. Your first delivery arrives within 48 hours and contains data from that point forward, which is another reason to set it up before you need it. Storage and queries above the free quota are billed to you.
The 24-Hour View, and What It Is Good For
In December 2024 Google added a "24 hours" tab to the Performance report, showing hourly data for Search, Discover and News in your browser's local time zone. Google said the change cut the average data delay across Search Console by roughly half. Comparison mode followed on 16 July 2025, so you can now set yesterday's hours against the day before, and hourly data can be exported.
Use it for one thing: confirming that something you just published or just fixed has been picked up. Publish a post in the morning, check the hourly graph that evening, and you know whether Google has started serving it.
Do not make content decisions from it. A day of hourly data is noise at the volumes most sites run, and acting on it produces the kind of thrashing where a title gets rewritten three times in a week.
Five Content Opportunities in the Queries Report
Open Performance, set the date range to the last three months, enable all four metrics, and open the Queries tab. Everything below comes from that one screen.
1. Striking distance. Filter position greater than 8 and less than 20, then sort by impressions. These are queries where you already appear on page one or two and get almost no clicks. You do not need a new article for any of them. You need the existing page to cover that query properly: a heading that uses the phrasing, a direct answer in the first paragraph under it, and the specifics that the current page skips. Rank movement from 12 to 6 on a query with real impressions beats a brand new post that nobody finds.
2. High impressions, low CTR. Filter impressions above a few hundred and sort CTR ascending, then compare each row against the average CTR for its position. A page sitting at position 4 with a 1% CTR has a title and description problem, not a content problem. Rewrite the title to match the query's phrasing and promise the specific thing the searcher wants. This is the fastest work in the entire list because no page content changes.
3. Queries your page ranks for but does not answer. Switch to the Pages tab, click a page, then switch back to Queries to see what that single URL appears for. You will find queries that are adjacent to the page's topic rather than central to it. Each of those is a candidate for its own post, and you already have evidence that Google associates your domain with the subject.
4. Question queries. Filter queries containing "how", "why", "what", "can" or "does". These are answer-engine territory, where a clear question heading with a direct two-sentence answer underneath can win a position above the standard results. The mechanics of claiming those boxes are covered in how to win the People Also Ask boxes.
5. Cannibalisation. Filter to a single important query and look at the Pages tab. Two or three of your own URLs appearing for one query means you have split the signal, and Google is choosing between them, often picking the weaker one. Consolidate into the strongest page and redirect the others, or differentiate them so each targets a distinct intent.
| Signal in Performance | What it usually means | What to do |
|---|---|---|
| Position 8 to 20, high impressions | Page is close but thin on that query | Add a section answering it directly |
| Position under 5, CTR under 2% | Title and description mismatch | Rewrite the title to the query |
| Impressions rising, clicks flat | AI Overview or SERP feature absorbing clicks | Target the question format instead |
| Many queries, one page | Page is doing too many jobs | Split into focused posts |
| One query, many pages | Cannibalisation | Consolidate and redirect |
| Impressions near zero on a new page | Indexing or discovery problem | URL Inspection, then internal links |
The Problem Search Console Will Not Show You
A page with almost no impressions might be a content problem. It might also be a page nothing on your own site links to.
Search Console reports the symptom and stays quiet about this particular cause, which makes it easy to misdiagnose. We audited our own blog while writing this and found eleven published articles with no inbound internal links from anywhere else on the site, including an entire set of industry guides. Those pages were not bad. They were unreachable except by sitemap, and no amount of editing them would have fixed that.
So pair the Performance report with a check your analytics cannot do for you: for every page you care about, count the internal links pointing at it. Anything on zero gets a link from the most closely related article you have published, using anchor text that describes the destination. This is the cheapest ranking work available, and it needs no new content at all. Build it into your on-page checklist so it happens at publish time instead of in an audit two years later.
A Monthly Routine That Takes Twenty Minutes
- Export Performance by query and by page for last month, and save it where you keep your own records.
- Pull the striking-distance list, positions 8 to 20 sorted by impressions, and pick the top three.
- Pull the low-CTR list for positions under 5 and rewrite those titles.
- Check the Pages report for newly excluded URLs and read the reason given.
- Scan for any query where two of your URLs now compete.
- Count internal links to anything you published last month.
Three content decisions and one technical check, from data you already own. If the routine keeps slipping, that is usually the point at which our SEO service earns its fee, because the work is small, monthly and easy to postpone forever.
What to Do First
If Search Console is not verified, do that today and accept that your data starts accumulating from now rather than retroactively. Domain property verification covers every subdomain and protocol at once, so prefer it over a URL-prefix property.
With it verified and a few months of history, start with the low-CTR rows at strong positions, because title rewrites are the only work in search that can pay off within a week. Then take the striking-distance list to your content calendar and let it decide what you write next, rather than deciding by instinct. Keyword tools estimate what a market searches; the queries report records what your site was actually shown for, and those two lists are never the same. Our guide to keyword research covers how to combine them without duplicating effort.
Want the three highest-value pages on your site identified from your own Search Console data?
A Free Visibility Audit reads your queries report against your page inventory, finds the striking-distance and low-CTR opportunities, and tells you which existing pages are worth more than any new article you could commission.
Related reading: Website Not Showing Up on Google | How to Do Keyword Research | On-Page SEO Checklist

Search Beyond Google
Search Beyond Google is a digital marketing growth agency helping ambitious businesses in the GTA and across North America build compounding visibility across SEO, Local SEO, AEO, AIEO, Google Ads, and Social Media. Every article is researched and written by the SBG team โ practitioners who build and test these strategies daily across real client campaigns.
Ready to apply this to your business?
A free 45-minute Visibility Audit maps these frameworks to your specific market, competitors, and current digital presence.
Get Your Free Visibility Audit โRelated Articles

The 500 Most Popular Websites, With a Method You Can Check
The 500 most popular websites ranked from a dated, sourced dataset, with the methodology spelled out and an honest account of what the ranking gets wrong.

Keyword Density Is Not a Ranking Factor: What to Measure Instead
There is no target keyword density and there has not been one for over a decade. Here is what the number is still useful for, and what to measure in its place.

robots.txt in 2026: What Changed, and What You Should Actually Block
Most robots.txt files block the wrong things and miss the things worth blocking. A practical guide to what belongs in the file now, and what does not.