1

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?

Improve this question
1

1 Answer 1

Reset to default
1

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.

Improve this answer
2
  • 1
    Thanks for your comment - you appear right, through all my investigation I believe that there's no option to get it out. I find it absolutely unbelievable that Google doesn't offer an option for historical data.
    – user1048175
    Commented Jun 5, 2021 at 10:49
  • @MichelePisani The BigQuery Export schema tracks fewer raw data points than the GA4 Data API does...
    – TheAddonDepot
    Commented Jun 11, 2021 at 19:45

Not the answer you're looking for? Browse other questions tagged or ask your own question.