Home / Connectors / Google Search Console
Connector

Google Search Console connector: datasets and metric definitionsBeta

Bring in Google search clicks, impressions and positions by day, query and page. Updates daily.

3 datasets5 metric definitionsRead-onlyRefreshes 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

DatasetWhat it holds
[Search Console] Daily performanceWhole-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 monthTop 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 monthTop 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

MetricHow it is calculatedDated byNotes
Search Console clicksSum of clicksdateClicks from Google Search results to the site, all queries included.
Search Console impressionsSum of impressionsdateTimes the site appeared in Google Search results.
Search Console weighted positionSum of position_weighteddateHelper for average position (position × impressions); not meaningful on its own.
Search Console CTRSearch Console clicks ÷ Search Console impressionsdateClicks per impression, as a decimal (0.03 = 3%).
Search Console average positionSearch Console weighted position ÷ Search Console impressionsdateAverage ranking in Google Search, weighted by impressions (1 = top; lower is better).

Works with other connectors

Questions to ask

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?
No. The Google Search Console connector is read-only. Quiriz reads the data into datasets and never writes back to Google Search Console.
How often does the Google Search Console data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine Google Search Console with other sources?
Yes. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.