Daily web-analytics export into your own warehouse

Every day the scenario exports the core analytics reports into your data warehouse and sends you a summary when it's done.

  • History doesn't expire — the data is yours
  • Thirteen reports at once: traffic, geo, devices, products
  • Each report lands in its own table in Google BigQuery
  • A summary lands in botHelp when the run finishes
Set it upScriptera

How it works

To move data from Google Analytics to Google BigQuery automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Schedule Trigger
  2. Then: Backfill Config
  3. Then: GA4 - Transaction Items
  4. Then: BQ - ga4_transaction_items
  5. Check: Merge
  6. Check: Merge1
  7. Then: Code
  8. Then: Send a text message
  9. Then: GA4 - Session Channel Group
  10. Then: BQ - ga4_data_session_channel_group
  11. Then: GA4 - Session Source/Campaign/Medium
  12. Then: BQ - ga4_data_session_source_campaign_medium
  13. Then: GA4 - Country/Language/City
  14. Then: BQ - ga4_data_country_language_city
  15. Then: GA4 - Item Name
  16. Then: BQ - ga4_data_item_name
  17. Then: GA4 - Browser/OS/Device
  18. Then: BQ - ga4_data_browser_os_device
  19. Then: GA4 - First User Source/Medium
  20. Then: BQ - ga4_data_first_user_source_medium
  21. Then: GA4 - First User Channel Group
  22. Then: BQ - ga4_data_first_user_channel_group
  23. Then: GA4 - Ads Data
  24. Then: BQ - ga4_ads_data
  25. Then: GA4 - All Metrics
  26. Then: BQ - ga4_all_metrics_data
  27. Then: GA4 - Event Metrics
  28. Then: BQ - ga4_event_metrics_data
  29. Then: GA4 - Page Location
  30. Then: BQ - ga4_page_location_data
  31. Then: GA4 - Landing Page
  32. Then: BQ - ga4_landing_page_data

You can launch this Google Analytics + Google BigQuery integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios