Features | Details |
Release Status | Released |
Source API Version | v5 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | AppsFlyer App Id App Token |
Replication Type | Key Based Incremental |
Replication Key | Date |
Suggested Replication Frequency | ​ |
Tables/APIs Supported | ​ |
InstallsReport | InAppEventsReport |
UninstallEventsReport | OrganicInstallsReport |
OrganicInAppEventsReport | InvalidInstallsReport |
InvalidInAppEventsReport | ​ |
Signin to Daton
Select AppsFlyer from Integrations page
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide AppsFlyer App Id and Token. Follow the to get your details
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
InstallsReport
Purpose: Can fetch the details of data includes time of installation, type of device, operating system, region, city, country and more.
Source API Documentation https://support.appsflyer.com/hc/en-us/articles/207034506#Introduction​
Replication: Key-Based Replication
Replication Key: LastRunDate
Fields
Name | Target Datatype |
attributed_touch_type | STRING |
attributed_touch_time | DATETIME |
install_time | DATETIME |
event_time | DATETIME |
event_name | STRING |
event_value | STRING |
event_revenue | STRING |
event_revenue_currency | STRING |
event_revenue_usd | STRING |
event_source | STRING |
is_receipt_validated | BOOLEAN |
af_prt | STRING |
media_source | STRING |
af_channel | STRING |
af_keywords | STRING |
campaign | STRING |
af_c_id | STRING |
af_adset | STRING |
af_adset_id | STRING |
af_ad | STRING |
af_ad_id | STRING |
af_ad_type | STRING |
af_siteid | STRING |
af_sub_siteid | STRING |
af_sub1 | STRING |
af_sub2 | STRING |
af_sub3 | STRING |
af_sub4 | STRING |
af_sub5 | STRING |
af_cost_model | STRING |
af_cost_value | STRING |
af_cost_currency | STRING |
contributor1_af_prt | STRING |
contributor1_media_source | STRING |
contributor1_campaign | STRING |
contributor1_touch_type | STRING |
contributor1_touch_time | DATETIME |
contributor2_af_prt | STRING |
contributor2_media_source | STRING |
contributor2_campaign | STRING |
contributor2_touch_type | STRING |
contributor2_touch_time | DATETIME |
contributor3_af_prt | STRING |
contributor3_media_source | STRING |
contributor3_campaign | STRING |
contributor3_touch_type | STRING |
contributor3_touch_time | DATETIME |
region | STRING |
country_code | STRING |
state | STRING |
city | STRING |
postal_code | STRING |
dma | STRING |
ip | STRING |
wifi | BOOLEAN |
operator | STRING |
carrier | STRING |
language | STRING |
appsflyer_id | STRING |
advertising_id | STRING |
idfa | STRING |
android_id | STRING |
customer_user_id | INTEGER |
imei | STRING |
idfv | STRING |
platform | STRING |
device_type | STRING |
os_version | STRING |
app_version | STRING |
sdk_version | STRING |
app_id | STRING |
app_name | STRING |
bundle_id | STRING |
is_retargeting | BOOLEAN |
retargeting_conversion_type | STRING |
af_attribution_lookback | STRING |
af_reengagement_window | STRING |
is_primary_attribution | BOOLEAN |
user_agent | STRING |
http_referrer | STRING |
original_url | STRING |
InAppEventsReport
Purpose: Can fetch the details of report contains all the actions performed by your non-organic users, which were sent to AppsFlyer from the SDK or via the server to server API or via native web view.
Source API Documentation https://support.appsflyer.com/hc/en-us/articles/115004574886-In-App-Events-Raw-Data-Report​
Replication: Key-Based Replication
Replication Key: LastRunDate
Fields
Name | Target Datatype |
attributed_touch_type | STRING |
attributed_touch_time | DATETIME |
install_time | DATETIME |
event_time | DATETIME |
event_name | STRING |
event_value | STRING |
event_revenue | STRING |
event_revenue_currency | STRING |
event_revenue_usd | STRING |
event_source | STRING |
is_receipt_validated | BOOLEAN |
af_prt | STRING |
media_source | STRING |
af_channel | STRING |
af_keywords | STRING |
campaign | STRING |
af_c_id | STRING |
af_adset | STRING |
af_adset_id | STRING |
af_ad | STRING |
af_ad_id | STRING |
af_ad_type | STRING |
af_siteid | STRING |
af_sub_siteid | STRING |
af_sub1 | STRING |
af_sub2 | STRING |
af_sub3 | STRING |
af_sub4 | STRING |
af_sub5 | STRING |
af_cost_model | STRING |
af_cost_value | STRING |
af_cost_currency | STRING |
contributor1_af_prt | STRING |
contributor1_media_source | STRING |
contributor1_campaign | STRING |
contributor1_touch_type | STRING |
contributor1_touch_time | DATETIME |
contributor2_af_prt | STRING |
contributor2_media_source | STRING |
contributor2_campaign | STRING |
contributor2_touch_type | STRING |
contributor2_touch_time | DATETIME |
contributor3_af_prt | STRING |
contributor3_media_source | STRING |
contributor3_campaign | STRING |
contributor3_touch_type | STRING |
contributor3_touch_time | DATETIME |
region | STRING |
country_code | STRING |
state | STRING |
city | STRING |
postal_code | STRING |
dma | STRING |
ip | STRING |
wifi | BOOLEAN |
operator | STRING |
carrier | STRING |
language | STRING |
appsflyer_id | STRING |
advertising_id | STRING |
idfa | STRING |
android_id | STRING |
customer_user_id | INTEGER |
imei | STRING |
idfv | STRING |
platform | STRING |
device_type | STRING |
os_version | STRING |
app_version | STRING |
sdk_version | STRING |
app_id | STRING |
app_name | STRING |
bundle_id | STRING |
is_retargeting | BOOLEAN |
retargeting_conversion_type | STRING |
af_attribution_lookback | STRING |
af_reengagement_window | STRING |
is_primary_attribution | BOOLEAN |
user_agent | STRING |
http_referrer | STRING |
original_url | STRING |
UninstallEventsReport
Purpose: Can fetch the details of uninstall raw data for all non-organic installs
Source API Documentation https://support.appsflyer.com/hc/en-us/articles/115000807786-Non-Organic-Uninstall-Raw-Data-Reports​
Replication: Key-Based Replication
Replication Key: LastRunDate
Fields
Name | Target Datatype |
attributed_touch_type | STRING |
attributed_touch_time | DATETIME |
install_time | DATETIME |
event_time | DATETIME |
event_name | STRING |
event_value | STRING |
event_revenue | STRING |
event_revenue_currency | STRING |
event_revenue_usd | STRING |
event_source | STRING |
is_receipt_validated | BOOLEAN |
af_prt | STRING |
media_source | STRING |
af_channel | STRING |
af_keywords | STRING |
campaign | STRING |
af_c_id | STRING |
af_adset | STRING |
af_adset_id | STRING |
af_ad | STRING |
af_ad_id | STRING |
af_ad_type | STRING |
af_siteid | STRING |
af_sub_siteid | STRING |
af_sub1 | STRING |
af_sub2 | STRING |
af_sub3 | STRING |
af_sub4 | STRING |
af_sub5 | STRING |
af_cost_model | STRING |
af_cost_value | STRING |
af_cost_currency | STRING |
contributor1_af_prt | STRING |
contributor1_media_source | STRING |
contributor1_campaign | STRING |
contributor1_touch_type | STRING |
contributor1_touch_time | DATETIME |
contributor2_af_prt | STRING |
contributor2_media_source | STRING |
contributor2_campaign | STRING |
contributor2_touch_type | STRING |
contributor2_touch_time | DATETIME |
contributor3_af_prt | STRING |
contributor3_media_source | STRING |
contributor3_campaign | STRING |
contributor3_touch_type | STRING |
contributor3_touch_time | DATETIME |
region | STRING |
country_code | STRING |
state | STRING |
city | STRING |
postal_code | STRING |
dma | STRING |
ip | STRING |
wifi | BOOLEAN |
operator | STRING |
carrier | STRING |
language | STRING |
appsflyer_id | STRING |
advertising_id | STRING |
idfa | STRING |
android_id | STRING |
customer_user_id | INTEGER |
imei | STRING |
idfv | STRING |
platform | STRING |
device_type | STRING |
os_version | STRING |
app_version | STRING |
sdk_version | STRING |
app_id | STRING |
app_name | STRING |
bundle_id | STRING |
is_retargeting | BOOLEAN |
retargeting_conversion_type | STRING |
af_attribution_lookback | STRING |
af_reengagement_window | STRING |
is_primary_attribution | BOOLEAN |
user_agent | STRING |
http_referrer | STRING |
original_url | STRING |
OrganicInstallsReport
Purpose: Can fetch the details of the report also includes the attribution type (click or view), the media source, campaign, ad set and ad type
Source API Documentation https://support.appsflyer.com/hc/en-us/articles/115002095726-Organic-Raw-Data-Reports​
Replication: Key-Based Replication
Replication Key: LastRunDate
Fields
Name | Target Datatype |
attributed_touch_type | STRING |
attributed_touch_time | DATETIME |
install_time | DATETIME |
event_time | DATETIME |
event_name | STRING |
event_value | STRING |
event_revenue | STRING |
event_revenue_currency | STRING |
event_revenue_usd | STRING |
event_source | STRING |
is_receipt_validated | BOOLEAN |
af_prt | STRING |
media_source | STRING |
af_channel | STRING |
af_keywords | STRING |
campaign | STRING |
af_c_id | STRING |
af_adset | STRING |
af_adset_id | STRING |
af_ad | STRING |
af_ad_id | STRING |
af_ad_type | STRING |
af_siteid | STRING |
af_sub_siteid | STRING |
af_sub1 | STRING |
af_sub2 | STRING |
af_sub3 | STRING |
af_sub4 | STRING |
af_sub5 | STRING |
af_cost_model | STRING |
af_cost_value | STRING |
af_cost_currency | STRING |
contributor1_af_prt | STRING |
contributor1_media_source | STRING |
contributor1_campaign | STRING |
contributor1_touch_type | STRING |
contributor1_touch_time | DATETIME |
contributor2_af_prt | STRING |
contributor2_media_source | STRING |
contributor2_campaign | STRING |
contributor2_touch_type | STRING |
contributor2_touch_time | DATETIME |
contributor3_af_prt | STRING |
contributor3_media_source | STRING |
contributor3_campaign | STRING |
contributor3_touch_type | STRING |
contributor3_touch_time | DATETIME |
region | STRING |
country_code | STRING |
state | STRING |
city | STRING |
postal_code | STRING |
dma | STRING |
ip | STRING |
wifi | BOOLEAN |
operator | STRING |
carrier | STRING |
language | STRING |
appsflyer_id | STRING |
advertising_id | STRING |
idfa | STRING |
android_id | STRING |
customer_user_id | INTEGER |
imei | STRING |
idfv | STRING |
platform | STRING |
device_type | STRING |
os_version | STRING |
app_version | STRING |
sdk_version | STRING |
app_id | STRING |
app_name | STRING |
bundle_id | STRING |
is_retargeting | BOOLEAN |
retargeting_conversion_type | STRING |
af_attribution_lookback | STRING |
af_reengagement_window | STRING |
is_primary_attribution | BOOLEAN |
user_agent | STRING |
http_referrer | STRING |
original_url | STRING |
OrganicInAppEventsReport
Purpose: Can fetch the details of the raw data report for all organic installs and In-App Events.
Source API Documentation https://support.appsflyer.com/hc/en-us/articles/115002095726-Organic-Raw-Data-Reports​
Replication: Key-Based Replication
Replication Key: LastRunDate
Fields
Name | Target Datatype |
attributed_touch_type | STRING |
attributed_touch_time | DATETIME |
install_time | DATETIME |
event_time | DATETIME |
event_name | STRING |
event_value | STRING |
event_revenue | STRING |
event_revenue_currency | STRING |
event_revenue_usd | STRING |
event_source | STRING |
is_receipt_validated | BOOLEAN |
af_prt | STRING |
media_source | STRING |
af_channel | STRING |
af_keywords | STRING |
campaign | STRING |
af_c_id | STRING |
af_adset | STRING |
af_adset_id | STRING |
af_ad | STRING |
af_ad_id | STRING |
af_ad_type | STRING |
af_siteid | STRING |
af_sub_siteid | STRING |
af_sub1 | STRING |
af_sub2 | STRING |
af_sub3 | STRING |
af_sub4 | STRING |
af_sub5 | STRING |
af_cost_model | STRING |
af_cost_value | STRING |
af_cost_currency | STRING |
contributor1_af_prt | STRING |
contributor1_media_source | STRING |
contributor1_campaign | STRING |
contributor1_touch_type | STRING |
contributor1_touch_time | DATETIME |
contributor2_af_prt | STRING |
contributor2_media_source | STRING |
contributor2_campaign | STRING |
contributor2_touch_type | STRING |
contributor2_touch_time | DATETIME |
contributor3_af_prt | STRING |
contributor3_media_source | STRING |
contributor3_campaign | STRING |
contributor3_touch_type | STRING |
contributor3_touch_time | DATETIME |
region | STRING |
country_code | STRING |
state | STRING |
city | STRING |
postal_code | STRING |
dma | STRING |
ip | STRING |
wifi | BOOLEAN |
operator | STRING |
carrier | STRING |
language | STRING |
appsflyer_id | STRING |
advertising_id | STRING |
idfa | STRING |
android_id | STRING |
customer_user_id | INTEGER |
imei | STRING |
idfv | STRING |
platform | STRING |
device_type | STRING |
os_version | STRING |
app_version | STRING |
sdk_version | STRING |
app_id | STRING |
app_name | STRING |
bundle_id | STRING |
is_retargeting | BOOLEAN |
retargeting_conversion_type | STRING |
af_attribution_lookback | STRING |
af_reengagement_window | STRING |
is_primary_attribution | BOOLEAN |
user_agent | STRING |
http_referrer | STRING |
original_url | STRING |
InvalidInstallsReport
Purpose: Can fetch the details of all invalid installations.
Source API Documentation https://support.appsflyer.com/hc/en-us/articles/115004703926#targeting-targeting-validation-rules-export-data​
Replication: Key-Based Replication
Replication Key: LastRunDate
Fields
Name | Target Datatype |
attributed_touch_type | STRING |
attributed_touch_time | DATETIME |
install_time | DATETIME |
event_time | DATETIME |
event_name | STRING |
event_value | STRING |
event_revenue | STRING |
event_revenue_currency | STRING |
event_revenue_usd | STRING |
event_source | STRING |
is_receipt_validated | BOOLEAN |
af_prt | STRING |
media_source | STRING |
af_channel | STRING |
af_keywords | STRING |
campaign | STRING |
af_c_id | STRING |
af_adset | STRING |
af_adset_id | STRING |
af_ad | STRING |
af_ad_id | STRING |
af_ad_type | STRING |
af_siteid | STRING |
af_sub_siteid | STRING |
af_sub1 | STRING |
af_sub2 | STRING |
af_sub3 | STRING |
af_sub4 | STRING |
af_sub5 | STRING |
af_cost_model | STRING |
af_cost_value | STRING |
af_cost_currency | STRING |
contributor1_af_prt | STRING |
contributor1_media_source | STRING |
contributor1_campaign | STRING |
contributor1_touch_type | STRING |
contributor1_touch_time | DATETIME |
contributor2_af_prt | STRING |
contributor2_media_source | STRING |
contributor2_campaign | STRING |
contributor2_touch_type | STRING |
contributor2_touch_time | DATETIME |
contributor3_af_prt | STRING |
contributor3_media_source | STRING |
contributor3_campaign | STRING |
contributor3_touch_type | STRING |
contributor3_touch_time | DATETIME |
region | STRING |
country_code | STRING |
state | STRING |
city | STRING |
postal_code | STRING |
dma | STRING |
ip | STRING |
wifi | BOOLEAN |
operator | STRING |
carrier | STRING |
language | STRING |
appsflyer_id | STRING |
advertising_id | STRING |
idfa | STRING |
android_id | STRING |
customer_user_id | INTEGER |
imei | STRING |
idfv | STRING |
platform | STRING |
device_type | STRING |
os_version | STRING |
app_version | STRING |
sdk_version | STRING |
app_id | STRING |
app_name | STRING |
bundle_id | STRING |
is_retargeting | BOOLEAN |
retargeting_conversion_type | STRING |
af_attribution_lookback | STRING |
af_reengagement_window | STRING |
is_primary_attribution | BOOLEAN |
user_agent | STRING |
http_referrer | STRING |
original_url | STRING |
InvalidInAppEventsReport
Purpose: Can fetch the details of all in-app events generated from invalid installations only
Source API Documentation https://support.appsflyer.com/hc/en-us/articles/115004703926#targeting-targeting-validation-rules-export-data​
Replication: Key-Based Replication
Replication Key: LastRunDate
Fields
Name | Target Datatype |
attributed_touch_type | STRING |
attributed_touch_time | DATETIME |
install_time | DATETIME |
event_time | DATETIME |
event_name | STRING |
event_value | STRING |
event_revenue | STRING |
event_revenue_currency | STRING |
event_revenue_usd | STRING |
event_source | STRING |
is_receipt_validated | BOOLEAN |
af_prt | STRING |
media_source | STRING |
af_channel | STRING |
af_keywords | STRING |
campaign | STRING |
af_c_id | STRING |
af_adset | STRING |
af_adset_id | STRING |
af_ad | STRING |
af_ad_id | STRING |
af_ad_type | STRING |
af_siteid | STRING |
af_sub_siteid | STRING |
af_sub1 | STRING |
af_sub2 | STRING |
af_sub3 | STRING |
af_sub4 | STRING |
af_sub5 | STRING |
af_cost_model | STRING |
af_cost_value | STRING |
af_cost_currency | STRING |
contributor1_af_prt | STRING |
contributor1_media_source | STRING |
contributor1_campaign | STRING |
contributor1_touch_type | STRING |
contributor1_touch_time | DATETIME |
contributor2_af_prt | STRING |
contributor2_media_source | STRING |
contributor2_campaign | STRING |
contributor2_touch_type | STRING |
contributor2_touch_time | DATETIME |
contributor3_af_prt | STRING |
contributor3_media_source | STRING |
contributor3_campaign | STRING |
contributor3_touch_type | STRING |
contributor3_touch_time | DATETIME |
region | STRING |
country_code | STRING |
state | STRING |
city | STRING |
postal_code | STRING |
dma | STRING |
ip | STRING |
wifi | BOOLEAN |
operator | STRING |
carrier | STRING |
language | STRING |
appsflyer_id | STRING |
advertising_id | STRING |
idfa | STRING |
android_id | STRING |
customer_user_id | INTEGER |
imei | STRING |
idfv | STRING |
platform | STRING |
device_type | STRING |
os_version | STRING |
app_version | STRING |
sdk_version | STRING |
app_id | STRING |
app_name | STRING |
bundle_id | STRING |
is_retargeting | BOOLEAN |
retargeting_conversion_type | STRING |
af_attribution_lookback | STRING |
af_reengagement_window | STRING |
is_primary_attribution | BOOLEAN |
user_agent | STRING |
http_referrer | STRING |
original_url | STRING |