Lucen syncs your Google Search Console data (Analytics) to your warehouse and models it into the tables below. You connect Google Search Console with one OAuth sign-in. By default your data refreshes every day at 07:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing.
Your plan sets how much history the first sync loads, see pricing.
Finalized performance date in Google's Pacific calendar. Missing rows alone do not prove zero activity.
search_type
Search type
STRING
Search surface; web only in this version. Keep in grouping and join keys.
country_code
Country code
STRING
Google three-letter code for the search country, not residence or conversion location.
country
Country
STRING
English country name derived from country_code; null when the code has no known name.
clicks
Clicks
FLOAT64
Clicks for this country, using byProperty aggregation. Not a repeated site-total column. Sum within this model before joins; never add across reports.
impressions
Impressions
FLOAT64
Impressions for this country, using byProperty aggregation. Not a repeated site-total column. Sum within this model before joins; never add across reports.
ctr
Ctr
FLOAT64
Clicks / impressions, as a fraction. For groups use SUM(clicks) / NULLIF(SUM(impressions), 0); never SUM or AVG this column.
average_position
Average position
FLOAT64
Average position at this model's aggregation basis. For groups use SUM(position_impression_sum) / NULLIF(SUM(impressions), 0); never SUM or unweighted AVG.
position_impression_sum
Position impression sum
FLOAT64
Position numerator: average_position * impressions. Sum within this model, then divide by summed impressions to calculate group position.
aggregation_type
Aggregation type
STRING
Google aggregation basis: byProperty. Page and property metrics are not interchangeable, even for identical dates.
client_id
Client id
STRING
Tenant identifier. Keep in grouping and join keys; never combine tenants.
data_updated_at
Data updated at
TIMESTAMP
Timezone-aware extraction instant of the selected snapshot. Use MAX(date) for the latest performance date.
Finalized performance date in Google's Pacific calendar. Missing rows alone do not prove zero activity.
search_type
Search type
STRING
Search surface; web only in this version. Keep in grouping and join keys.
device
Device
STRING
Google device category. An independent breakdown; joining other facts cannot infer query or country attribution.
clicks
Clicks
FLOAT64
Clicks for this device, using byProperty aggregation. Not a repeated site-total column. Sum within this model before joins; never add across reports.
impressions
Impressions
FLOAT64
Impressions for this device, using byProperty aggregation. Not a repeated site-total column. Sum within this model before joins; never add across reports.
ctr
Ctr
FLOAT64
Clicks / impressions, as a fraction. For groups use SUM(clicks) / NULLIF(SUM(impressions), 0); never SUM or AVG this column.
average_position
Average position
FLOAT64
Average position at this model's aggregation basis. For groups use SUM(position_impression_sum) / NULLIF(SUM(impressions), 0); never SUM or unweighted AVG.
position_impression_sum
Position impression sum
FLOAT64
Position numerator: average_position * impressions. Sum within this model, then divide by summed impressions to calculate group position.
aggregation_type
Aggregation type
STRING
Google aggregation basis: byProperty. Page and property metrics are not interchangeable, even for identical dates.
client_id
Client id
STRING
Tenant identifier. Keep in grouping and join keys; never combine tenants.
data_updated_at
Data updated at
TIMESTAMP
Timezone-aware extraction instant of the selected snapshot. Use MAX(date) for the latest performance date.
Finalized performance date in Google's Pacific calendar. Missing rows alone do not prove zero activity.
search_type
Search type
STRING
Search surface; web only in this version. Keep in grouping and join keys.
query
Query
STRING
Returned search term, part of the row grain. Omitted queries are absent, not zero-valued rows.
query_word_count
Query word count
INT64
Number of whitespace-separated words in the returned search query.
brand_classification
Brand classification
STRING
Configured classification: branded, non_branded or unclassified. Without brand terms, brand share is unavailable; otherwise it covers disclosed queries only.
clicks
Clicks
FLOAT64
Clicks for this returned query, using byProperty aggregation. Not a repeated site-total column. Sum within this model before joins; never add across reports.
impressions
Impressions
FLOAT64
Impressions for this returned query, using byProperty aggregation. Not a repeated site- total column. Sum within this model before joins; never add across reports.
ctr
Ctr
FLOAT64
Clicks / impressions, as a fraction. For groups use SUM(clicks) / NULLIF(SUM(impressions), 0); never SUM or AVG this column.
average_position
Average position
FLOAT64
Average position at this model's aggregation basis. For groups use SUM(position_impression_sum) / NULLIF(SUM(impressions), 0); never SUM or unweighted AVG.
position_impression_sum
Position impression sum
FLOAT64
Position numerator: average_position * impressions. Sum within this model, then divide by summed impressions to calculate group position.
aggregation_type
Aggregation type
STRING
Google aggregation basis: byProperty. Page and property metrics are not interchangeable, even for identical dates.
client_id
Client id
STRING
Tenant identifier. Keep in grouping and join keys; never combine tenants.
data_updated_at
Data updated at
TIMESTAMP
Timezone-aware extraction instant of the selected snapshot. Use MAX(date) for the latest performance date.
Finalized performance date in Google's Pacific calendar. Missing rows alone do not prove zero activity.
search_type
Search type
STRING
Search surface; web only in this version. Keep in grouping and join keys.
clicks
Clicks
FLOAT64
Clicks for this site, using byProperty aggregation. Headline site total. Sum within this model before joins; never add across reports.
impressions
Impressions
FLOAT64
Impressions for this site, using byProperty aggregation. Headline site total. Sum within this model before joins; never add across reports.
ctr
Ctr
FLOAT64
Clicks / impressions, as a fraction. For groups use SUM(clicks) / NULLIF(SUM(impressions), 0); never SUM or AVG this column.
average_position
Average position
FLOAT64
Average position at this model's aggregation basis. For groups use SUM(position_impression_sum) / NULLIF(SUM(impressions), 0); never SUM or unweighted AVG.
position_impression_sum
Position impression sum
FLOAT64
Position numerator: average_position * impressions. Sum within this model, then divide by summed impressions to calculate group position.
aggregation_type
Aggregation type
STRING
Google aggregation basis: byProperty. Page and property metrics are not interchangeable, even for identical dates.
client_id
Client id
STRING
Tenant identifier. Keep in grouping and join keys; never combine tenants.
data_updated_at
Data updated at
TIMESTAMP
Timezone-aware extraction instant of the selected snapshot. Use MAX(date) for the latest performance date.
SELECT date, site_url, search_type, clicks, impressions
FROM `your-project.your_org_gold.gold_search_console_traffic`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, site_url, search_type, page_url, hostname
FROM `your-project.your_org_gold.gold_search_console_page`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, site_url, search_type, query, query_word_count
FROM `your-project.your_org_gold.gold_search_console_query`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;
sql
SELECT date, site_url, search_type, device, clicks
FROM `your-project.your_org_gold.gold_search_console_device`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY date DESC
LIMIT 100;