Skip to main content

Google Analytics (GA4)

Adding Google Analytics as data source​

Do the following to add Google Analytics as data source:

  1. From the left navigation panel, click Lakehouse and then click Data Sources.
  2. From the upper right corner of the page, click the + New Data Source button to start the process of adding a new database.
  3. In the New Data Source page, click the Google Analytics icon.
  4. Specify the following details to add Google Analytics. Once you have connected a data source, the system immediately fetches its schema. After this schema retrieval process is complete you can browse and interact with the tables and data.
FieldDescription
Connection NameEnter a unique name for the connection.
Service Account JSON KeyEnter the contents of your Google Cloud Service Account JSON key file. Ensure the Service Account has been granted at least 'Viewer' access to the GA4 Property.
Property IDsSpecify the numeric Google Analytics Property IDs you want to sync (e.g., 123456789). You can list multiple IDs separated by commas.
Start DateEnter the date in the YYYY-MM-DD format. DataGOL will replicate the data updated on and after this date. If blank, the default is two years prior to the initial sync.
End DateEnter the date in the YYYY-MM-DD format to stop data replication at a specific point. If left blank, the sync will continue up to the current date.
  1. Click Submit.

Supported sync modes​

  • Full Refresh - Overwrite
  • Full Refresh - Append
  • Incremental - Append
  • Incremental - Append + Deduped

Supported streams​

The Google Analytics Data API connector provides a variety of preconfigured incremental streams and supports custom reporting.

Preconfigured Streams​

  • daily_active_users
  • devices
  • four_weekly_active_users
  • locations
  • pages
  • traffic_sources
  • website_overview
  • weekly_active_users
  • user_acquisition_first_user_medium_report
  • user_acquisition_first_user_source_report
  • user_acquisition_first_user_source_medium_report
  • user_acquisition_first_user_source_platform_report
  • user_acquisition_first_user_campaign_report
  • user_acquisition_first_user_google_ads_ad_network_type_report
  • user_acquisition_first_user_google_ads_ad_group_name_report
  • traffic_acquisition_session_source_medium_report
  • traffic_acquisition_session_medium_report
  • traffic_acquisition_session_source_report
  • traffic_acquisition_session_campaign_report
  • traffic_acquisition_session_default_channel_grouping_report
  • traffic_acquisition_session_source_platform_report
  • events_report
  • weekly_events_report
  • conversions_report
  • pages_title_and_screen_class_report
  • pages_path_report
  • pages_title_and_screen_name_report
  • content_group_report
  • ecommerce_purchases_item_name_report
  • ecommerce_purchases_item_id_report
  • ecommerce_purchases_item_category_report_combined
  • ecommerce_purchases_item_category_report
  • ecommerce_purchases_item_category_2_report
  • ecommerce_purchases_item_category_3_report
  • ecommerce_purchases_item_category_4_report
  • ecommerce_purchases_item_category_5_report
  • ecommerce_purchases_item_brand_report
  • publisher_ads_ad_unit_report
  • publisher_ads_page_path_report
  • publisher_ads_ad_format_report
  • publisher_ads_ad_source_report
  • demographic_country_report
  • demographic_region_report
  • demographic_city_report
  • demographic_language_report
  • demographic_age_report
  • demographic_gender_report
  • demographic_interest_report
  • tech_browser_report
  • tech_device_category_report
  • tech_device_model_report
  • tech_screen_resolution_report
  • tech_app_version_report
  • tech_platform_report
  • tech_platform_device_category_report
  • tech_operating_system_report
  • tech_os_with_version_report

Custom Streams​

  • Custom Reports (defined by user dimensions and metrics)

Was this helpful?