Initial data import
When a new Ad service → Google BigQuery pipeline is created, OWOX BI uploads historical data according to your settings for the data import start date, ad service API limitations, and your subscription terms. Read more in this article.
Daily regular data import
After the initial data import, the OWOX BI algorithm will download data for the new day and update historical data according to the schedule in the table below.
IMPORTANT Uploading data can take up to 24 hours depending on the Ad service API limitations.
| Pipeline | Data import for yesterday | Data import for actualization update |
|---|---|---|
| Meta Ads (Facebook & Instagram) → Google BigQuery |
00:00 (UTC) This time can be customized individually for your pipelines. Contact us at bi@owox.com for help. |
05:00 (UTC) |
| LinkedIn Ads → Google BigQuery |
00:00 (UTC) This time can be customized individually for your pipelines. Contact us at bi@owox.com for help. |
05:00 (UTC) |
| Google Ads → Google BigQuery |
3:00 AM The time zone from your Ad account |
Customizable In the pipeline settings, we recommend you schedule the pipeline run between 3:00 and 4:00 AM in the same time zone. |
| Microsoft Advertising (Bing) → Google BigQuery | 16:00 (UTC) | 03:00 (UTC) |
| X Ads (Twitter) → Google BigQuery | 00:00 (UTC) | 03:00 (UTC) |
| Criteo → Google BigQuery | 00:00 (UTC) | 03:00 (UTC) |
| Hotline → Google BigQuery | 00:00 (UTC+2/UTC+3 or Europe/Kyiv) |
You might be interested in:
How is the Ad Service → Google BigQuery Pipeline Data Updated?
0 Comments