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.
    Signin to Daton
    2.
    Select AppsFlyer from Integrations page
    3.
    Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
    4.
    Provide AppsFlyer App Id and Token. Follow the to get your details
    5.
    Post successful authentication, you will be prompted to choose from the list of available tables
    6.
    Then select all required fields for each table
    7.
    Submit the integration

Workflow

    1.
    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
    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 includes time of installation, type of device, operating system, region, city, country and more.
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.
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
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
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.
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.
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