Try out all OWOX BI features with a trial period Start for free

OWOX BI interacts with AppsFlyer via AppsFlyer Push API V2.0 that sends raw event data in real-time to the OWOX BI endpoint. Which data will be sent to the endpoint depends on the settings you provide for the Endpoint Configuration in your AppsFlyer account. Once data is received, OWOX BI uploads it to the selected dataset in your Google BigQuery project.

Note that the Push API provides OWOX BI with the Activity data that is all events made by active users during the specified date range. Therefore, when you need to validate the data received by OWOX BI, you should refer to the relevant reports in your AppsFlyer account. It can be either the Activity dashboard or raw data reports.

To compare data received by OWOX BI with data stored in your AppsFlyer account, follow the steps below:

Step 1. Export data from your Google BigQuery project using the following query samples.

In the following query samples:
- enter Android or IOS instead of PlatformName;
- for ProjectName.DatasetName.TableName, specify the name of your Google BigQuery project and dataset, then enter ios_events or android_events as a table name;
- type the required date instead of YYYY-MM-DD.

Installs and Registrations

SELECT
  FROM (
  SELECT
  'PlatformName' as platform, count (distinct idfa) as installs
  FROM
  'ProjectName.DatasetName.TableName'
  WHERE
  event_name='install'
  AND af_prt LIKE '%ealweb%'
  AND event_time>='YYYY-MM-DD'
  AND event_time <=''YYYY-MM-DD' )
  FULL JOIN (
  SELECT
  'PlatformName' as platform, count (distinct idfa) as registrations
  FROM
  'ProjectName.DatasetName.TableName'
  WHERE
  event_name='registration_success'
  AND af_prt LIKE '%ealweb%'
  AND event_time>='YYYY-MM-DD'
  AND event_time <='YYYY-MM-DD' )
  USING
  ( platform)

Purchases

SELECT
  COUNT(DISTINCT(SUBSTR((SPLIT(event_value,'af_receipt_id":') [SAFE_ORDINAL(2)]),1,7) )) 
AS orders, SUM(CAST(event_revenue AS float64)) AS revenue FROM 'ProjectName.DatasetName.TableName' WHERE event_name = 'af_purchase' AND af_prt LIKE '%ealweb%' AND event_time>='YYYY-MM-DD' AND event_time <='YYYY-MM-DD'

Step 2. Retrieve data from your AppsFlyer account using one of the options below.

1) Use data from the Activity dashboard.

af_activity.png

2) Use the reports under the Export data > Raw data.

To fetch the required data, find a difference between “Raw data non-organic in-app events” and “Re-engagement”, then add “Export page-raw data-in-app events retargeting” to the obtained value.

af_export_data.png

Step 3. Compare the retrieved data.

Note that the acceptable level of data discrepancy is up to 3%. If the discrepancy in your data exceeds this limit, contact us at bi@owox.com for further investigation.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.