Google Search Console connector: datasets and metric definitionsBeta
Bring in Google search clicks, impressions and positions by day, query and page. Updates daily.
When you connect Google Search Console, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.
DatasetsMetric definitionsWorks withQuestionsFAQ
Datasets
| Dataset | What it holds |
|---|---|
| [Search Console] Daily performance | Whole-site totals per day, anonymized queries included. Days are Pacific Time; Google adds the newest 2-3 days once final. For any period, CTR = sum(clicks) / sum(impressions) and average position = sum(position_weighted) / sum(impressions); never sum or average the ctr or position columns.7 columnsdate, site, clicks, impressions, ctr, position, position_weighted |
| [Search Console] Queries by month | Top 5,000 search queries per month by clicks. Google leaves out anonymized (rare) queries, so these rows add up to less than the daily totals in [Search Console] Daily performance. For any period, CTR = sum(clicks) / sum(impressions) and average position = sum(position_weighted) / sum(impressions); never sum or average the ctr or position columns.8 columnsmonth, query, site, clicks, impressions, ctr, position, position_weighted |
| [Search Console] Pages by month | Top 5,000 pages per month by clicks. Search Console counts each page separately (one search result can show several of the site's pages), so these rows do not add up to the daily totals in [Search Console] Daily performance: impressions can be higher, clicks lower. For any period, CTR = sum(clicks) / sum(impressions) and average position = sum(position_weighted) / sum(impressions); never sum or average the ctr or position columns.8 columnsmonth, page, site, clicks, impressions, ctr, position, position_weighted |
Metric definitions
Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.
[Search Console] Daily performance
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Search Console clicks | Sum of clicks | date | Clicks from Google Search results to the site, all queries included. |
| Search Console impressions | Sum of impressions | date | Times the site appeared in Google Search results. |
| Search Console weighted position | Sum of position_weighted | date | Helper for average position (position × impressions); not meaningful on its own. |
| Search Console CTR | Search Console clicks ÷ Search Console impressions | date | Clicks per impression, as a decimal (0.03 = 3%). |
| Search Console average position | Search Console weighted position ÷ Search Console impressions | date | Average ranking in Google Search, weighted by impressions (1 = top; lower is better). |
Works with other connectors
- Google Search Console + Bing Webmaster Tools: Google and Bing search. Clicks, impressions and position from both search engines side by side. Read the guide.
Questions to ask
- How did our Google search clicks and impressions change each month this year?
- Which search queries brought the most clicks last month?
- Which pages got the most clicks from Google search last month?
- Which queries have many impressions but a low click-through rate?
Related guides
- Google Search Console Dashboard: What to Put on It and How to Build It
- Find Declining Pages and CTR Opportunities in Search Console
- Pages That Rank but Don't Convert: Search Console and GA4
- SEO Report Template: A Monthly SEO Report, With an Example
Ask Google Search Console in plain words
Try the questions on sample data with no signup, then connect Google Search Console read-only and ask your own.
Try Quiriz free →Frequently asked questions
Does Quiriz change anything in Google Search Console?
How often does the Google Search Console data refresh?
Can I change how a metric is calculated?
Can I combine Google Search Console with other sources?
All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.