Appsflyer

Appsflyer ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

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

Sign in to Daton.
Select AppsFlyer from the Integrations page.
Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.
Provide AppsFlyer App Id and Token.
Post successful authentication, you will be prompted to choose from the list of available tables.
Select all the required fields for each table.
Submit the integration.

Workflow

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.
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.

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

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

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

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

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

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

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

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

PreviousAnalytics Platforms NextGA4

Last updated 1 year ago