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

      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