Appsflyer

Appsflyer ETL connector for data replication

Snapshot

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

Integrate AppsFlyer with Daton

1. Sign in to Daton.

2. Select AppsFlyer from the Integrations page.

3. Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.

4. Provide AppsFlyer App Id and Token.

5. Post successful authentication, you will be prompted to choose from the list of available tables.

6. Select all the required fields for each table.

7. Submit the integration.

Workflow

1. Integrations would be in the Pending state initially and will be moved to the Active state as soon as the first job loads data successfully onto the configured warehouse.

2. Users would be able to edit/pause/re-activate/delete integration anytime.

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list.

AppsFlyer Data

InstallsReport

Purpose: Can fetch the details of data including 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 the report that 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