Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Appsflyer

Appsflyer ETL connector for data replication

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        Need help with something?

        Talk to data expert

        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

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Jungle Scout

        Table of Contents

        Snapshot Integrate AppsFlyer with Daton Workflow AppsFlyer Data InstallsReport InAppEventsReport OrganicInstallsReport

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand