Appsflyer

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.

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