Google Analytics to BigQuery

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


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

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:


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,