Skip to content

fmgarate/bq-ga360

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
README.md
README.md
 
 
dropdown_numbers_of_user_left_early.sql
dropdown_numbers_of_user_left_early.sql
 
 
dropdown_numbers_of_user_no_show.sql
dropdown_numbers_of_user_no_show.sql
 
 
dropdown_numbers_of_user_saw_dropdown.sql
dropdown_numbers_of_user_saw_dropdown.sql
 
 
dropdown_people_buying_product_at_different_timings.sql
dropdown_people_buying_product_at_different_timings.sql
 
 
info_event_actions.sql
info_event_actions.sql
 
 
landind_people_selecting_watch_later.sql
landind_people_selecting_watch_later.sql
 
 
landind_people_selecting_watch_later_by_source.sql
landind_people_selecting_watch_later_by_source.sql
 
 
landind_people_selecting_watch_now.sql
landind_people_selecting_watch_now.sql
 
 
landind_people_selecting_watch_now_by_source.sql
landind_people_selecting_watch_now_by_source.sql
 
 
landing_bounce_rate_by_source.sql
landing_bounce_rate_by_source.sql
 
 
landing_bounce_rate_by_source_01.sql
landing_bounce_rate_by_source_01.sql
 
 
landing_bounce_rate_by_source_and_device.sql
landing_bounce_rate_by_source_and_device.sql
 
 
landing_conversions_by_source.sql
landing_conversions_by_source.sql
 
 
landing_conversions_overall.sql
landing_conversions_overall.sql
 
 
landing_leads_by_source.sql
landing_leads_by_source.sql
 
 
landing_leads_by_source_and_device.sql
landing_leads_by_source_and_device.sql
 
 
landing_sessions_by_source.sql
landing_sessions_by_source.sql
 
 
landing_sessions_overall.sql
landing_sessions_overall.sql
 
 
landing_visits_by_source.sql
landing_visits_by_source.sql
 
 
landing_visits_by_source_and_device.sql
landing_visits_by_source_and_device.sql
 
 
webinar_minute_by_minute_people_dropping_down_from_webinar.sql
webinar_minute_by_minute_people_dropping_down_from_webinar.sql
 
 

Repository files navigation

Google Analytics 360 and BigQuery

This repo collects a set of queries for an exported Google Analytics 360 dataset into BigQuery.

Google Analytics sample dataset for BigQuery

The sample dataset provides an obfuscated Google Analytics 360 dataset that can be accessed via BigQuery. It’s a great way to look at business data and experiment and learn the benefits of analyzing Google Analytics 360 data in BigQuery. https://support.google.com/analytics/answer/7586738

How to run queries

Using the GCP console:

  • Open the BigQuery web UI in the GCP Console.
  • Click Compose new query.
  • Enter a valid BigQuery SQL query in the Query editor text area.
  • Click Run.

Using the command line:

Open a command line console and execure this command (Google Cloud SDK is required):

bq query --use_legacy_sql=false $(cat landing_visits_by_source.sql)

About

Google Analytics 360 and BigQuery

Topics

bigquery google-analytics-360

Resources

Readme
Activity

Stars

2 stars

Watchers

1 watching

Forks

3 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages