Data Sources
Google Search Console
Metrics & Dimensions List
Updated: 2026-08-01
Important
Two tables are provided to cover different use cases:
search_console__query_dailyholds the most granular data, with date, country, device, page and query. Aggregated totals from this table may differ from the Search Console interface because of Google's own aggregation rules, privacy thresholds and deduplication, as explained in Google's performance data documentation.search_console__total_dailyholds daily totals, with the date as the only dimension. Its totals match the Search Console interface exactly, which makes it the right table for validating overall performance.
Query Table
account_idText
The Site ID.
account_nameText
The Site name.
dateDate
The date for which the metrics are being reported.
queryText
The search query that resulted in a search impression.
pageText
The landing page on your site.
country_codeText
The country name.
country_nameText
The name of the country where the search query originated, used as a dimension to group search performance data.
deviceText
The Device Used for the Search.
clicksNumber
The number of clicks.
impressionsNumber
The number of impressions.
positionNumber
The average position.
Total Table
account_idText
The Site ID.
account_nameText
The Site name.
dateDate
The date for which the metrics are being reported.
clicksNumber
The number of clicks.
impressionsNumber
The number of impressions.
positionNumber
The average position.