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:
- 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.
- https://ga-dev-tools.appspot.com/query-explorer/ has the same problem (not showing child properties).
- 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?