Google Search Console → Google BigQuery: data schema
search_analytics_all_fields
| Field name |
Type |
ctr |
FLOAT |
date |
STRING |
page |
STRING |
query |
STRING |
clicks |
INTEGER |
device |
STRING |
country |
STRING |
position |
FLOAT |
site_url |
STRING |
impressions |
INTEGER |
search_type |
STRING |
search_analytics_by_country
| Field name |
Type |
ctr |
FLOAT |
date |
STRING |
clicks |
INTEGER |
country |
STRING |
position |
FLOAT |
site_url |
STRING |
impressions |
INTEGER |
search_type |
STRING |
search_analytics_by_date
| Field name |
Type |
ctr |
FLOAT |
date |
STRING |
clicks |
INTEGER |
position |
FLOAT |
site_url |
STRING |
impressions |
INTEGER |
search_type |
STRING |
search_analytics_by_device
| Field name |
Type |
ctr |
FLOAT |
date |
STRING |
clicks |
INTEGER |
device |
STRING |
position |
FLOAT |
site_url |
STRING |
impressions |
INTEGER |
search_type |
STRING |
search_analytics_by_page
| Field name |
Type |
ctr |
FLOAT |
date |
STRING |
page |
STRING |
clicks |
INTEGER |
position |
FLOAT |
site_url |
STRING |
impressions |
INTEGER |
search_type |
STRING |
search_analytics_by_query
| Field name |
Type |
ctr |
FLOAT |
date |
STRING |
query |
STRING |
clicks |
INTEGER |
position |
FLOAT |
site_url |
STRING |
impressions |
INTEGER |
search_type |
STRING |
search_analytics_by_query2
| Field name |
Type |
date |
DATE |
search_type |
STRING |
query |
INTEGER |
sites
| Field name |
Type |
siteUrl |
STRING |
permissionLevel |
STRING |
Have more questions?
Submit a request
0 Comments