Google BigQuery

The Google Analytics 360 (GA360) integration with Google BigQuery produces one partitioned table for each day’s worth of data.

As part of Google Analytics 360, you can have all of your Google Analytics data exported daily into Google BigQuery, in its entirety, in the form of a new table per day.

We love Google Cloud Functions for its simplicity in allowing us to quickly deploy code without having to worry about servers, networking, and security. 

There are several benefits to be gained from exporting your billing data to BigQuery:

Google Data Studio is an amazingly flexible tool which we use pretty much all the time here at Data Runs Deep.

Be careful of tracking additional user info, as it may constitute PII. That said, with BigQuery you have a lot of options.