How soon does the data get to Google BigQuery?
When you create a pipeline, OWOX BI imports historical data from your Google Analytics View:
- under scheme GA_ONLY — for the last 90 days;
- under scheme GA_NATIVE_PLUS_GBQ — for the last 30 days.
The tables with the imported data will be appearing in Google BigQuery gradually, starting with the latest date. Importing all the data takes up to 48 hours, depending on the data's overall amount.
The regular daily data import usually takes up to 2 hours: between 10 AM and 12 AM. If a large amount of your Google Analytics data has been retroactively updated, table updates and creation can take up to 24 hours.
How does the data upload process work
Data import and updating are performed on a daily basis according to the timezone set in your Google Analytics view:
- data import for the previous day starts at 10 AM;
- under scheme GA_ONLY, data updating for the previous 90 days starts at 12 AM;
- under scheme GA_NATIVE_PLUS_GBQ, data updating for the previous 30 days starts at 4 AM.
10 AM is chosen as the upload and update start time because by this time cost data becomes available in all cost data sources' API.
The upload process begins with checking for which of the previous days the cost data was altered in Google Analytics. This usually takes up to 10 minutes. After the check, the list of days for which the data must be updated is made up. Then the new data for these days is uploaded.
Note:If the cost data appeared in Google Analytics after 10 AM, then this data will not be considered in the current day's update and will be uploaded retrospectively during the next day's update.
If you don't see cost data from certain channels in OWOX BI, the reason for their absence may be the data upload time in Google Analytics.
There also can be an import holdup when the Google Analytics API query limit is exceeded. This may happen when other services, aside from OWOX BI, make queries to your View's data. In this case, data import for some of the days can be postponed, but these data will appear in BigQuery during one of the next daily updates.