See the section for Premium Users who’s queries would experience sampling.

If your queries experiences more than 500,000 sessions, you should change how the query is sent to Google.

Choose this option, then name for the Google CSV file that will hold the data. It will be stored on Google Drive when it is ready.

Build your query and click the Get Fresh Data button.

Get the data as a CSV file. Use it in Excel or Save to a Google Spreadsheet and use it with Google Data Studio

Google Analytics will process your query and store the data in the Google Spreadsheet.

  • Google Analytics saves the data in a format that is in-compatible with Google Data Studio (GDS) (circa April 2017). GDS prefers that you store the column headers in Row 1 whereas Google Analytics inserts 5 rows of contextual information first. NEXT Analytics fixes that and also offers a great deal of post download value-added analytic capability.

You can build a dashboard in Excel, using a combination of NEXT Analytics and the Google Spreadsheet as data source. The means to do that is documented in the resulting workbook.

You could alternatively use Google Spreadsheet Data Connector, with Google Data Studio.

Put the data into Google Cloud SQL, use Excel or Google Data Studio

Google Analytics can save data directly to Google Cloud SQL.

Google Data Studio can use a Data Connector to access data from Google Cloud SQL.

The only problem is the lack of value-add analytics that’s available to you.  For more info on the types of analytics you would need (and don’t get), please see this article.

You can, instead, use NEXT Analytics to read the data from Google Cloud SQL, analyze it, and put the analyzed data into either a Google Spreadsheet (would work well since the data has been reduced), or back into a different database table in Google Cloud SQL.

Send the data into a Microsoft Azure database, use it with Excel or Microsoft Power BI

Using the same technique as the prior section, you can request the data to be stored in Google Cloud SQL.

After that, NEXT Analytics can analyze it, and then transfer the analyzed result set to a Microsoft Azure database.

Once it’s there, you can build dashboards using Microsoft Power BI.