Skip to content

Google Analytics 4

A minimum of Analyst permissions are required. Administrator permissions are preferred.

The GA4 Add, edit, and delete Analytics users and user groups support article can provide guidance.

The Google Analytics API limits each request to 10 dimensions/metrics combined. Since we need more data points than that, we split the data into 5 primary grains.

Table: ga4_landing_sessions

Dimensions

  • date
  • landingPagePlusQueryString
  • sessionSource
  • sessionMedium
  • sessionCampaignName
  • sessionManualTerm
  • sessionManualAdContent
  • customUser:crm_id

Metrics

  • engagedSessions
  • activeUsers

Table: ga4_page_views

Dimensions

  • date
  • pagePathPlusQueryString
  • sessionSource
  • sessionMedium
  • sessionCampaignName
  • sessionManualTerm
  • sessionManualAdContent
  • customUser:crm_id

Metrics

  • screenPageViews
  • activeUsers
  • eventCount

Table: ga4_events

Dimensions

  • date
  • eventName
  • sessionSource
  • sessionMedium
  • sessionCampaignName
  • sessionManualTerm
  • sessionManualAdContent
  • customUser:crm_id

Metrics

  • eventCount
  • totalUsers

Table: ga4_geo

Dimensions

  • date
  • country
  • region
  • city
  • sessionSource
  • sessionMedium
  • sessionCampaignName
  • sessionManualTerm
  • sessionManualAdContent
  • customUser:crm_id

Metrics

  • engagedSessions
  • activeUsers