Getting Analytics 360 Data Out of BigQuery with Analytics Canvas:
You will need a trial license key or a Premium subscription to use the features discussed in this tutorial. If you haven’t already done so, sign-up for a free 30-day trial and instantly get your license key so you can begin.
If you are an existing customer, contact email@example.com to request a free 30-day trial of the Premium subscription.
- Open Analytics Canvas and apply your license key (you only need to do this once)
- Go to New Source > Google Analytics and choose Analytics 360 BigQuery
- Select the View you wish to query from your list of Google Analytics 360 Accounts and Properties.
- Make your query by selecting your dimensions and metrics. That’s right, no SQL required! Canvas will generate the SQL for you. And unlike the Reporting APIs, there is no limit to the number of dimensions and metrics that you can select in this query.
Here’s a “simple” query looking at landingPagePath by date and country:
That’s about 175 words and nearly 2,000 characters of pure SQL that Canvas has generated on the fly as you select the dimensions and metrics needed for your query!
- Select the Time Period, Filter, and Sort Options. These will all be added to the BigQuery SQL.
- Determine whether you want the data loaded directly to another BigQuery Table where you can query it from your visualization tool, or import your results directly to the Canvas where you can further process it before publishing and analyzing it.
- To Import your data directly to the Canvas, simply select that option and the data will begin to download.
- To save the data to a new or existing BigQuery table, click “Save to BigQuery Table”. On the next screen, click “Select Table”. You now have two options
After making your selection, click “OK”.
That’s it! By generating the SQL programmatically, you do not need to worry about syntax errors or the complex functions required to deal with date partitioned tables, nor do you need to worry about flattening/unnesting your data in order to get meaningful results.
The data will either land on your canvas for further processing, or it will be loaded to a BigQuery dataset of your choosing.
You can either read that new table into Canvas or work with the table that was landed to further process the data and make it available to your favorite reporting tool, whether that’s Tableau, Data Studio, Excel or something else.