OWOX BI automatically tracks the discrepancies between the data you collect via the Google Analytics → Google BigQuery pipeline and the data in your Google Analytics property.
You can find the statistics, including the timestamp of the last data update in both services, under the Sessions tab on your OWOX BI pipeline page:
Also, you can identify data discrepancies manually by comparing Google Analytics reports and your BigQuery data. You can use this method if the information on the OWOX BI page is not updated yet.
NoteOWOX BI tables in Google BigQuery are updated faster than Google Analytics data. It can take up to 48 hours for data to be processed in GA. It is recommended to compare the data only after it is fully actualized.
If you still see data discrepancies, find the possible reasons for that in our documentation.
Below you can find sample queries in standard SQL to run them in Google BigQuery for future data comparison. Before you run a query, make sure you replace the following parameters in string “Project.Dataset.owoxbi_sessions_20190821” with your own data:
- "Project" with your Google BigQuery project name;
- "Dataset" with your dataset dame in the required project;
- "owoxbi_sessions_20190909" with the required table name in the format "year-month-day".
Request for the number of page views within a certain day
SELECT COUNT (DISTINCT hits.hitId) pageviews FROM `Project.Dataset.owoxbi_sessions_20190821`, UNNEST (hits) hits WHERE hits.type = 'pageview'
To review the data in Google Analytics, navigate to Audience > Overview report. Make sure you select the correct data for the report.
Request for the number of events for a certain day
SELECT COUNT (DISTINCT hits.hitId) events FROM `Project.Dataset.owoxbi_sessions_20190821`, UNNEST (hits) hits WHERE hits.type = 'event'
To review the data in Google Analytics, navigate to Behavior > Events > Overview report. Make sure you select the correct data for the report.
Request for the number of transactions for a certain day
SELECT COUNT (hits.transaction.transactionId) transactions FROM `Project.Dataset.owoxbi_sessions_20190821`, UNNEST (hits) hits WHERE hits.eCommerceAction.action_type ='purchase'
To review the data in Google Analytics, navigate to Conversions > Ecommerce > Overview report. Make sure you select the correct data for the report.
NoteIf you identify a discrepancy that exceeds the acceptable level, check out the possible reasons for data differences, and find the appropriate solution for your case in our documentation:
Troubleshoot the hit data discrepancies
Troubleshoot the transaction data discrepancies
Troubleshoot the session data discrepancies
Troubleshoot the ad cost data discrepancies
0 Comments