Google Analytics to BigQuery

  • 111Views
  • Last Post 04 January 2023
0
votes
Riley Unsicker posted this 04 January 2023

Hello,

I am trying to pull google analytics data into BigQuery. I beleive I have successfully limited the number of dimensions and metrics. But when I go to load the data it errors out with this message: Object 'CompleteAnalytics' not found.

Any idea of what I need to do? Thanks

0
votes
Mariia Zaharova posted this 04 January 2023

Hi Riley,

 

Thank you for contacting us.

 

This error occurs because there is no corresponding target object (in Google BigQuwery) and Skyvia fails to copy data there.

 

Please select the "Create Tables" check box, save the package and run it again

 

As for the error Invalid field name "1dayActiveUsers". Fields must contain only letters, numbers, and underscores, start with a letter or underscore, and be at most 300 characters long. it is a self-explained error and it relates to the BigQuery naming limitations:

https://cloud.google.com/bigquery/docs/tables

 

You can either exclude this field from the Replication task or rename it in the source (if it is possible) so that it corresponds BigQuery rules.

 

Please let us know if this helps.

 

Best regards,

Mariia

Close