Data Sources
Google Search Console
Metrics & Dimensions List
Updated: 2026-01-25
Important
We provide two tables to accommodate different use cases:
search_console__query_daily: Contains raw data at the most granular level with dimensions like date, country, device, page, and query. Aggregated totals from this table may differ from Search Console UI numbers due to Google's internal aggregation rules, privacy thresholds, and deduplication logic, as explained in Google's performance data documentation.search_console__total_daily: Contains daily aggregated metrics (date dimension only). Totals from this table match the Search Console interface exactly, making it ideal for validating overall performance or comparing with the UI.
Query Table
account_id
Text
Account ID - The Site ID.
account_name
Text
Account Name - The Site name.
date
Date
Date - The date for which the metrics are being reported.
query
Text
Query - The search query that resulted in a search impression.
page
Text
Page - The landing page on your site.
country
Text
Country - The country name.
device
Text
Device - The Device Used for the Search.
clicks
Number
Clicks - The number of clicks.
impressions
Number
Impressions - The number of impressions.
position
Number
Position - The average position.
Total Table
account_id
Text
Account ID - The Site ID.
account_name
Text
Account Name - The Site name.
date
Date
Date - The date for which the metrics are being reported.
clicks
Number
Clicks - The number of clicks.
impressions
Number
Impressions - The number of impressions.
position
Number
Position - The average position.