Data Integration Template:

Prepare standard google analytics report

Extract Traffic, Events, Sessions and Users reports from Google analytics objects to prepare a standard google analytics report

Standard Google Analytics template Flow The flow view of this template

This template shows how to extract reports from google analytics objects like Traffic, Events, Sessions and Users data from a typical google analytics database.

The flow comes with detailed annotation of each dataset. Once you understand the sql logic, you can customize this flow to jumpstart your own development or share it with others in your workspace.

The flow comprises of standard datasets like events, sessions, accounts and users data. Each dataset is a report ranging from StartDate to EndDate.

This template is a pre-packaged, customisable and modular flow that leverage industry standard practices to report and analyze google analytics data.

The input datasets are dummy datasets that need to be replaced by your google analytics data. You can utilize this document to create your connection to google analytics.

The flow canvas also has detailed instructions of how to replace the dummy datasets(csv) with a SQL data from your google analytics datasource. You don’t have to create the SQL from scratch but simply copy the SQL corresponding to each dataset from the flow note and paste the SQL in “Create dataset with SQL” from the import page.

Once you have replaced the input datasets, follow the instructions to create output and run job.

New user?

If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Designer Cloud.

Use in Designer Cloud Use in Dataprep