如何将Google Analytics(分析)数据导入Google Cloud Platform? [英] How could I import google analytics data to Google Cloud Platform?

问题描述

我需要将数据从 Google Analytics(分析)导入到Google Cloud Platform(可能是Cloud Storage)，然后处理该信息并导出到Google Cloud SQL.

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.

我不清楚我可以使用什么Google Cloud Service来运行数据导入过程.

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

我当时正在考虑使用 Google DataFlow 进行提取转换并加载到 Cloud SQL 中.

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

推荐答案

如评论中@jkff所述，如果您拥有Google Analytics(分析)360，则可以启用bigQuery集成，并且每天将原始数据导出到BigQuery.

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.

您可以尝试在API上运行一些查询以提取数据并创建作业以将该数据加载到BigQuery或其他存储中.但是您会遇到很多问题.除了运行ETL的系统的实际体系结构之外，您的查询只能返回特定的报告，而不能运行查询以导出所有内容.因此，您必须确定所需的数据并导出该特定报告，然后重复进行.

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.

这篇关于如何将Google Analytics(分析)数据导入Google Cloud Platform?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！