There is a limit in the Essential plan that is related to Google BigQuery.
Limit: Weekly automatic sync to BigQuery
Data is automatically collected every day, but is only synced automatically to BigQuery on a weekly basis. This is how it works:
- Your data is synced to BigQuery when you choose a BigQuery project to sync to
- After that it is automatically synced to BigQuery once every 7 days (counting from the day you registered).
This means that you might not always see the most recent data in BigQuery. The example below shows the consequences of the weekly automatic sync to BigQuery for Essential plan users.
When you choose a BigQuery project in Cervinodata on the day you register (let's call this day 0), the data of all accounts that are switched to ON will be synced to that project. Because of this limit for Essential plan users, your data in BigQuery will look like this:
- On day 1, 2, 3, 4, 5 and 6, you will see the data from January 1st the previous year to day 0
- On day 7, the weekly the automatic weekly sync to BigQuery is activated and new data will be made available for you, you will see the data from January 1st the previous year to day 7.
Can I avoid the weekly automatic sync?
Yes, you can manually trigger the synchronisation to BigQuery.
- Go to the Sync to project page in Cervinodata (under Destinations > BigQuery)
- Press manual refresh
- When pressing this button, fresh data will be synced to BigQuery once, including accounts you just switched to ON and newly created campaign groups.
Or you can move to the Bronze plan (at 99 euros per month), which includes automatic daily sync to BigQuery. Go to the subscription page