How could I import google analytics data to Google Cloud Platform?

0
votes

I need to import data from Google Analytics to Google Cloud Platform (Cloud Storage maybe) and then process this information and exported to google cloud SQL.

I have not a clear idea what Google Cloud Service I can use to run the process of importing the data.

I was thinking to use Google DataFlow to do the Extraction Transformation and Load into Cloud SQL.

2
google-analyticsgoogle-cloud-platformgoogle-cloud-storagegoogle-cloud-sqlgoogle-cloud-dataflow
But if you are on GA Premium, you can always connect it to Google Big Query! Doesn't that help ? – Tushar
@Tushar Yes I have read that there is that option but we currently not have GA Premium at the moment. – jfk83
If you had a way to export data from Google Analytics to any of the Google Cloud storage products, Apache Beam/Dataflow would be able to ingest that into Cloud SQL, e.g. using JdbcIO. However, I believe the only way to export raw data from GA is GA Premium (currently called GA 360). – jkff

2 Answers

2
votes

As @jkff mentioned in the comments if you have Google Analytics 360 you can enable the bigQuery integration and your raw data will be exported daily to BigQuery.

If you don't then there's no way to export raw data easily.

You could try to run some queries on the API to extract data and create jobs to load this data into BigQuery or some other storage. But you'll run into multiple problems with this. Beyond the actual architecture of the system to run the ETL, your queries can only return specific reports, you can't run a query to export everything. So you'll have to figure out what data you need and export that specific report, and then repeat.

0
votes

onlyGA 360 can export data, not for standard GA