-
. Google Analytics API: Historical Data
“Hey, I’ve been able to link GA4 and Bigquery since May 6th and have been getting data incrementally. Now I want to grab the historical data from before May 6th. Does Google provide any tools that can help with this? If not, I’m considering writing a Python script to take care of it. What do you think? FYI, I tried searching for solutions online and all I found was Fivetran or Supermetrics.”
-
2 Replies
-
Sure thing, Google itself doesn’t provide a straightforward tool to pull your historical GA4 data into BigQuery. So your idea of writing a Python script to do the job sounds like a good plan of action. And don’t worry, it’s not going to be overly complex. Happy coding!
-
Currently, if you link GA4 and BigQuery, Google only provides data from the day you linked it and won’t backfill historical data prior to that. Therefore, if you want to access the data from before May 6th, you would need to find another method. Writing a Python script could potentially solve this problem. However, it would depend on your coding skill, the complexity of the script and whether GA4 and BigQuery have the APIs needed for your script. Using a third party tool like Fivetran or Supermetrics is also an option, as they provide functionalities to backfill historical data by exporting it from Google Analytics to BigQuery.
Log in to reply.