CODEWITHSUNDEEP
google-analyticsgoogle-analytics-apifirebase-analytics
user1048175
user1048175

Reputation: 1130

Extracting historical data out of Google Analytics

Any ideas how I get historical data out of Google Analytics?

My problem here is I didn't realise the Firebase / Analytics export to BigQuery wasn't retrospective for history, so I only have data from when I turned on the integration and I need everything from when the Firebase App was launched. The main data I need is events with their parameters.

I have tried a few things:

  1. Connect PowerBI to Google Analytics. I can authenticate and it only shows "Default Account for Firebase" with no children - it doesn't show the apps underneath that account.
  2. https://ga-dev-tools.appspot.com/query-explorer/ has the same problem (not showing child properties).
  3. I can load the properties and therefore analytics dataset using Google Data Studio, but this does not have the functionality I require that is in Power BI. I also couldn't locate the event parameters which I need either.

Any ideas on how to export the data?

Upvotes: 1

Views: 1828

Answers (1)

Michele Pisani
Michele Pisani

Reputation: 14197

You can try to use Google Analytics Data API to export report programmatically: https://developers.google.com/analytics/devguides/reporting/data/v1

However the data are not raw like with BigQuery Export. So if you want raw data there are no solution for the historical data.

Upvotes: 1

Related Questions