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
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
