google-marketing-solutions/crmint

BigQuery to Google Analytics pipeline

OugribeSara opened this issue · 2 comments

OugribeSara commented

Hi everyone !
I am trying to export customers segmentation in Google Analytics using « BQToStorageExporter » to export a BigQuery table to a CSV file and « GADataImporter » to import that CSV file into Google Analytics.
Google Analytics requires a specific header to import data (in my case ga:dimension2,ga:dimension1) but BigQuery doesn’t accept the symbol « : » in field names.
Any suggestions?

tyroneschiff commented

Hi there,
In a BQQueryLauncher job instantiate a table with this formatting. In a subsequent job you can append data to the table and then BQToStorageExporter job, etc., etc. Let me know if that helps!
example

dulacp commented

We are closing this issue since the new release of CRMint 2.0 should fix this issue, please see the details in the mentioned above.