Appsflyer
Appsflyer ETL connector for data replication
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 | ​ |
- 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.
- 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.
InstallsReport
Purpose: Can fetch the details of data including 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 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 |