How to find which keywords actually bring clicks in Search Console
In 15 minutes, see which searches send clicks and whether your agency's keywords do. One firm ranked #1 for 7 months and won 0 paying jobs.
In 15 minutes, Search Console's Queries table shows which searches actually send clicks, so you can see whether your agency's ranking keywords bring anyone. One IT firm ranked #1 for its target keyword for 7 months and won 0 paying jobs; 10 of 63 businesses that left or weighed leaving their agency in 2024–2026 named missing leads. Any Search Console access; free.
You end up with the searches that send people to your site, sorted by clicks, and a note of which of them your agency tracks.
Step 1: Open the Queries table
Go to Performance → Search results. Set the date range to the last 3 months and click the Queries tab under the chart. Turn on Average position at the top so it shows in the table.
Step 2: Sort by clicks and export
Click the Clicks column header to sort, then Export (top right) to Google Sheets or CSV.
Step 3: Label each query
Add a column and mark each query as one of: service (something you sell), location, brand (your business name), or unrelated. The service and location queries are the ones that bring new customers.
Step 4: Compare with the agency's keyword list
Paste the keywords from the agency's ranking report into the sheet and check which appear among your top queries. A keyword that "ranks #1" but isn't in this list brings little or no traffic.
Step 5: See which pages earn the clicks
Click the Pages tab. Open the top pages and check each has a clear way to call or enquire. Then click a page and switch back to Queries to see what brings people to it.
What it takes
About 15 minutes. Any Search Console permission level works. Free.
What the result means
- Most clicks come from your brand name: people who already know you. See how to split branded and non-branded clicks.
- The agency's keywords barely appear: the reported rankings aren't driving traffic.
- Service queries bring clicks but leads don't follow: the problem is on the page or in the contact path. Track forms and calls as GA4 key events.
An IT services buyer ranked first for its target keyword and got no paying work from it in seven months (source). This check shows whether a keyword like that brings anyone at all.
If your agency does this for you
Ask for the top 20 queries by clicks each month next to their tracked keywords, with the page each query lands on.
Good to know
- Average position is averaged over every time your site appeared, so treat it as a trend, not an exact rank.
- The export holds up to 1,000 rows; Looker Studio or the Search Console API give more.
- Some rare queries are hidden for privacy, so query clicks add up to less than the total.
- Up to 1,000 rows per table from the Export button (Google); Looker Studio or the Search Console API give more.
- No: it's averaged over every impression, across places and devices (Google), so a #1 in one town can show as a much lower average. One IT firm's #1 brought 0 paying jobs in 7 months (source).
Sources
- Search Console Help: Performance report
- Meridian answer: My SEO agency got me to #1 but I get no leads: why?




