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 Analytics导入到Google云平台（可能是云存储），然后处理此信息并导出到Google云端SQL。
I have not a clear idea what Google Cloud Service I can use to run the process of importing the data.
我不清楚我可以使用哪种Google Cloud Service来运行导入数据的过程。
I was thinking to use Google DataFlow to do the Extraction Transformation and Load into Cloud SQL.
我当时正在考虑使用Google DataFlow进行提取转换并加载到Cloud SQL中。
2 个解决方案
#1
1
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.
正如@jkff在评论中提到的，如果你有Google Analytics 360，你可以启用bigQuery集成，你的原始数据将每天导出到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.
您可以尝试在API上运行一些查询以提取数据并创建作业以将此数据加载到BigQuery或其他存储中。但是你会遇到很多问题。除了运行ETL的系统的实际体系结构之外，您的查询只能返回特定的报告，您无法运行查询来导出所有内容。因此，您必须找出所需的数据并导出该特定报告，然后重复。
#2
1
The easy way to import Google Analytics data to Google BigQuery is to use OWOX BI Pipeline. With its help, you can avoid sampling and get raw, accurate data down to a single hit, even without GA360. OWOX BI is a Google Cloud Platform Authorized Technology Partner.
将Google Analytics数据导入Google BigQuery的简便方法是使用OWOX BI Pipeline。在它的帮助下，即使没有GA360，您也可以避免采样并获得原始，准确的数据，直至一次点击。 OWOX BI是Google云平台授权技术合作伙伴。
#1
1
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.
正如@jkff在评论中提到的，如果你有Google Analytics 360，你可以启用bigQuery集成，你的原始数据将每天导出到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.
您可以尝试在API上运行一些查询以提取数据并创建作业以将此数据加载到BigQuery或其他存储中。但是你会遇到很多问题。除了运行ETL的系统的实际体系结构之外，您的查询只能返回特定的报告，您无法运行查询来导出所有内容。因此，您必须找出所需的数据并导出该特定报告，然后重复。
#2
1
The easy way to import Google Analytics data to Google BigQuery is to use OWOX BI Pipeline. With its help, you can avoid sampling and get raw, accurate data down to a single hit, even without GA360. OWOX BI is a Google Cloud Platform Authorized Technology Partner.
将Google Analytics数据导入Google BigQuery的简便方法是使用OWOX BI Pipeline。在它的帮助下，即使没有GA360，您也可以避免采样并获得原始，准确的数据，直至一次点击。 OWOX BI是Google云平台授权技术合作伙伴。