Analytics & SEO
Google Analytics schema
SightShark syncs Google Analytics into a data warehouse you own. It creates 52 tables holding 521 fields, refreshed daily. GA4 through the Data API, as one table per report rather than one wide table. Acquisition, traffic, pages, events, ecommerce, publisher ads, demographics and technology.
52 tables / 521 fields / Tables from the production sync
Tables and fields
Every table this connector creates, and every field in it, named as you will query it.
traffic_acquisition_session_source_medium
13 fields
- property_id
- date
- sessionMedium
- sessionSource
- engagedSessions
- engagementRate
- eventCount
- eventsPerSession
- keyEvents
- sessions
- totalRevenue
- totalUsers
- userEngagementDuration
user_acquisition_first_user_source_medium
12 fields
- property_id
- date
- firstUserMedium
- firstUserSource
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
- userEngagementDuration
landing_page
12 fields
- property_id
- date
- landingPage
- engagedSessions
- sessions
- screenPageViews
- newUsers
- totalUsers
- userEngagementDuration
- eventCount
- keyEvents
- totalRevenue
events
7 fields
- property_id
- date
- eventName
- eventCount
- eventCountPerUser
- totalRevenue
- totalUsers
ecommerce_purchases_item_name
9 fields
- property_id
- date
- itemName
- cartToViewRate
- itemRevenue
- itemsAddedToCart
- itemsPurchased
- itemsViewed
- purchaseToViewRate
user_acquisition_first_user_medium_report
11 fields
- property_id
- date
- firstUserMedium
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
- userEngagementDuration
user_acquisition_first_user_source
11 fields
- property_id
- date
- firstUserSource
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
- userEngagementDuration
user_acquisition_first_user_source_platform
11 fields
- property_id
- date
- firstUserSourcePlatform
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
- userEngagementDuration
user_acquisition_first_user_campaign
11 fields
- property_id
- date
- firstUserCampaignName
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
- userEngagementDuration
user_acquisition_first_user_google_ads_network_type
11 fields
- property_id
- date
- firstUserGoogleAdsAdNetworkType
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
- userEngagementDuration
user_acquisition_first_user_google_ads_ad_group_name
11 fields
- property_id
- date
- firstUserGoogleAdsAdGroupName
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
- userEngagementDuration
traffic_acquisition_total
11 fields
- property_id
- date
- engagedSessions
- engagementRate
- eventCount
- eventsPerSession
- keyEvents
- sessions
- totalRevenue
- totalUsers
- userEngagementDuration
ga4_traffic_source
17 fields
- property_id
- date
- sessionSource
- sessionDefaultChannelGrouping
- sessionMedium
- sessionCampaignName
- landingPage
- eventName
- country
- deviceCategory
- engagedSessions
- sessions
- screenPageViews
- newUsers
- totalUsers
- userEngagementDuration
- eventCount
traffic_acquisition_session_medium
12 fields
- property_id
- date
- sessionMedium
- engagedSessions
- engagementRate
- eventCount
- eventsPerSession
- keyEvents
- sessions
- totalRevenue
- totalUsers
- userEngagementDuration
traffic_acquisition_session_source
12 fields
- property_id
- date
- sessionSource
- engagedSessions
- engagementRate
- eventCount
- eventsPerSession
- keyEvents
- sessions
- totalRevenue
- totalUsers
- userEngagementDuration
traffic_acquisition_session_campaign
12 fields
- property_id
- date
- sessionCampaignName
- engagedSessions
- engagementRate
- eventCount
- eventsPerSession
- keyEvents
- sessions
- totalRevenue
- totalUsers
- userEngagementDuration
traffic_acquisition_session_default_channel_grouping
12 fields
- property_id
- date
- sessionDefaultChannelGrouping
- engagedSessions
- engagementRate
- eventCount
- eventsPerSession
- keyEvents
- sessions
- totalRevenue
- totalUsers
- userEngagementDuration
traffic_acquisition_session_source_platform
12 fields
- property_id
- date
- sessionSourcePlatform
- engagedSessions
- engagementRate
- eventCount
- eventsPerSession
- keyEvents
- sessions
- totalRevenue
- totalUsers
- userEngagementDuration
key_events
6 fields
- property_id
- date
- eventName
- keyEvents
- totalRevenue
- totalUsers
pages_title_and_screen_class
10 fields
- property_id
- date
- unifiedScreenClass
- eventCount
- keyEvents
- newUsers
- screenPageViews
- totalRevenue
- totalUsers
- userEngagementDuration
pages_path
10 fields
- property_id
- date
- pagePath
- eventCount
- keyEvents
- newUsers
- screenPageViews
- totalRevenue
- totalUsers
- userEngagementDuration
pages_title_and_screen_name
10 fields
- property_id
- date
- unifiedScreenName
- eventCount
- keyEvents
- newUsers
- screenPageViews
- totalRevenue
- totalUsers
- userEngagementDuration
content_group
10 fields
- property_id
- date
- contentGroup
- eventCount
- keyEvents
- newUsers
- screenPageViews
- totalRevenue
- totalUsers
- userEngagementDuration
ecommerce_purchases_item_id
9 fields
- property_id
- date
- itemId
- cartToViewRate
- itemRevenue
- itemsAddedToCart
- itemsPurchased
- itemsViewed
- purchaseToViewRate
ecommerce_purchases_item_category_report_combined
13 fields
- property_id
- date
- itemCategory
- itemCategory2
- itemCategory3
- itemCategory4
- itemCategory5
- cartToViewRate
- itemRevenue
- itemsAddedToCart
- itemsPurchased
- itemsViewed
- purchaseToViewRate
ecommerce_purchases_item_category
9 fields
- property_id
- date
- itemCategory
- cartToViewRate
- itemRevenue
- itemsAddedToCart
- itemsPurchased
- itemsViewed
- purchaseToViewRate
ecommerce_purchases_item_category_2
9 fields
- property_id
- date
- itemCategory2
- cartToViewRate
- itemRevenue
- itemsAddedToCart
- itemsPurchased
- itemsViewed
- purchaseToViewRate
ecommerce_purchases_item_category_3
9 fields
- property_id
- date
- itemCategory3
- cartToViewRate
- itemRevenue
- itemsAddedToCart
- itemsPurchased
- itemsViewed
- purchaseToViewRate
ecommerce_purchases_item_category_4
9 fields
- property_id
- date
- itemCategory4
- cartToViewRate
- itemRevenue
- itemsAddedToCart
- itemsPurchased
- itemsViewed
- purchaseToViewRate
ecommerce_purchases_item_category_5
9 fields
- property_id
- date
- itemCategory5
- cartToViewRate
- itemRevenue
- itemsAddedToCart
- itemsPurchased
- itemsViewed
- purchaseToViewRate
ecommerce_purchases_item_brand
9 fields
- property_id
- date
- itemBrand
- cartToViewRate
- itemRevenue
- itemsAddedToCart
- itemsPurchased
- itemsViewed
- purchaseToViewRate
publisher_ads_ad_unit
7 fields
- property_id
- date
- adUnitName
- adUnitExposure
- publisherAdClicks
- publisherAdImpressions
- totalAdRevenue
publisher_ads_page_path
7 fields
- property_id
- date
- pagePath
- adUnitExposure
- publisherAdClicks
- publisherAdImpressions
- totalAdRevenue
publisher_ads_ad_format
7 fields
- property_id
- date
- adFormat
- adUnitExposure
- publisherAdClicks
- publisherAdImpressions
- totalAdRevenue
publisher_ads_ad_source
7 fields
- property_id
- date
- adSourceName
- adUnitExposure
- publisherAdClicks
- publisherAdImpressions
- totalAdRevenue
demographic_country
9 fields
- property_id
- date
- country
- engagedSessions
- engagementRate
- keyEvents
- newUsers
- totalRevenue
- totalUsers
demographic_region
9 fields
- property_id
- date
- region
- engagedSessions
- engagementRate
- keyEvents
- newUsers
- totalRevenue
- totalUsers
demographic_city
9 fields
- property_id
- date
- city
- engagedSessions
- engagementRate
- keyEvents
- newUsers
- totalRevenue
- totalUsers
demographic_language
9 fields
- property_id
- date
- language
- engagedSessions
- engagementRate
- keyEvents
- newUsers
- totalRevenue
- totalUsers
demographic_age
9 fields
- property_id
- date
- userAgeBracket
- engagedSessions
- engagementRate
- keyEvents
- newUsers
- totalRevenue
- totalUsers
demographic_gender
9 fields
- property_id
- date
- userGender
- engagedSessions
- engagementRate
- keyEvents
- newUsers
- totalRevenue
- totalUsers
demographic_interests
9 fields
- property_id
- date
- brandingInterest
- engagedSessions
- engagementRate
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_browser
10 fields
- property_id
- date
- browser
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_device_category
10 fields
- property_id
- date
- deviceCategory
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_device_model
10 fields
- property_id
- date
- deviceModel
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_screen_resolution
10 fields
- property_id
- date
- screenResolution
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_app_version
10 fields
- property_id
- date
- appVersion
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_platform
10 fields
- property_id
- date
- platform
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_os_version
10 fields
- property_id
- date
- operatingSystemVersion
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_platform_device_category
11 fields
- property_id
- date
- deviceCategory
- platform
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_operating_system
10 fields
- property_id
- date
- operatingSystem
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
tech_os_with_version
10 fields
- property_id
- date
- operatingSystemWithVersion
- engagedSessions
- engagementRate
- eventCount
- keyEvents
- newUsers
- totalRevenue
- totalUsers
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Site analytics counts a conversion its own way and the ad platforms count it theirs, so the same week produces two different answers depending on which tab you opened.
Questions people ask
What tables does SightShark create from Google Analytics?
52 tables, including traffic_acquisition_session_source_medium, user_acquisition_first_user_source_medium, landing_page. traffic_acquisition_session_source_medium is one row per property, per source and medium, per day. Every one is listed on this page, with its fields.
Which Google Analytics fields can I get?
All 521 listed fields are on this page, table by table, named as they appear in your warehouse.
How often does Google Analytics data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Google Analytics data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Google Analytics and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 6 min read
How to measure a client's traffic from AI search.
A lot of it lands in Direct and gets credited to nothing. Here is how to pull it apart.
Read it - 7 min read
A GA4 and tracking audit checklist for new clients.
What to check, in the order that stops the most bad data, and how to tell whether Consent Mode is actually working.
Read it - 7 min read
What a consent choice does to your reporting data.
It decides what is collected, what gets estimated on your behalf, and why two figures for the same week are both correct.
Read it
Get started
Want Google Analytics in your own warehouse?
A call with someone who can answer the schema questions.