Google Analytics Universal API → Google BigQuery: data schema

NoteYou can also export ‘Custom reports’ with a set of available dimensions and metrics in the API. But this export has several limitations: no more than 7 dimensions and compatibility of dimensions and metrics with each other.

daily_active_users

Field name Type  
ga_date STRING  
view_id STRING  
ga_1dayUsers INTEGER  
isDataGolden BOOLEAN  

 

devices

Field name Type  
ga_date STRING  
view_id STRING  
ga_users INTEGER  
ga_browser STRING  
ga_exitRate FLOAT  
ga_newUsers INTEGER  
ga_sessions INTEGER  
ga_pageviews INTEGER  
isDataGolden BOOLEAN  
ga_bounceRate FLOAT  
ga_avgTimeOnPage FLOAT  
ga_deviceCategory STRING  
ga_operatingSystem STRING  
ga_sessionsPerUser FLOAT  
ga_avgSessionDuration FLOAT  
ga_pageviewsPerSession FLOAT  

 

four_weekly_active_users

Field name Type  
ga_date STRING  
view_id STRING  
isDataGolden BOOLEAN  
ga_28dayUsers INTEGER  

 

locations

Field name Type  
ga_city STRING  
ga_date STRING  
view_id STRING  
ga_metro STRING  
ga_users INTEGER  
ga_region STRING  
ga_country STRING  
ga_exitRate FLOAT  
ga_newUsers INTEGER  
ga_sessions INTEGER  
ga_continent STRING  
ga_pageviews INTEGER  
isDataGolden BOOLEAN  
ga_bounceRate FLOAT  
ga_subContinent STRING  
ga_avgTimeOnPage FLOAT  
ga_sessionsPerUser FLOAT  
ga_avgSessionDuration FLOAT  
ga_pageviewsPerSession FLOAT  

 

monthly_active_users

Field name Type  
ga_date STRING  
view_id STRING  
isDataGolden BOOLEAN  
ga_30dayUsers INTEGER  

 

pages

Field name Type  
ga_date STRING  
view_id STRING  
ga_exits INTEGER  
ga_exitRate FLOAT  
ga_hostname STRING  
ga_pagePath STRING  
ga_entrances INTEGER  
ga_pageviews INTEGER  
isDataGolden BOOLEAN  
ga_bounceRate FLOAT  
ga_entranceRate FLOAT  
ga_avgTimeOnPage FLOAT  
ga_uniquePageviews INTEGER  

 

traffic_sources

Field name Type  
ga_date STRING  
view_id STRING  
ga_users INTEGER  
ga_medium STRING  
ga_source STRING  
ga_exitRate FLOAT  
ga_newUsers INTEGER  
ga_sessions INTEGER  
ga_pageviews INTEGER  
isDataGolden BOOLEAN  
ga_bounceRate FLOAT  
ga_avgTimeOnPage FLOAT  
ga_socialNetwork STRING  
ga_sessionsPerUser FLOAT  
ga_avgSessionDuration FLOAT  
ga_pageviewsPerSession FLOAT  

 

two_weekly_active_users

Field name Type  
ga_date STRING  
view_id STRING  
isDataGolden BOOLEAN  
ga_14dayUsers INTEGER  

 

website_overview

Field name Type  
ga_date STRING  
view_id STRING  
ga_users INTEGER  
ga_exitRate FLOAT  
ga_newUsers INTEGER  
ga_sessions INTEGER  
ga_pageviews INTEGER  
isDataGolden BOOLEAN  
ga_bounceRate FLOAT  
ga_avgTimeOnPage FLOAT  
ga_sessionsPerUser FLOAT  
ga_avgSessionDuration FLOAT  
ga_pageviewsPerSession FLOAT  

 

weekly_active_users

Field name Type  
ga_date STRING  
view_id STRING  
ga_7dayUsers INTEGER  
isDataGolden BOOLEAN  
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.