AppsFlyer Field Reference
Sample
The AppsFlyer connector loads aggregate, raw and master API data from AppsFlyer.
https://connectors.windsor.ai/appsflyer?api_key=[your API key]&date_preset=last_7d&fields=date,country,source,campaign,spend,sessions,clicks,impressions,transactions,transactionrevenue,loyal_users&_renderer=csv
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The App ID | pull_api |
| account_name | TEXT | Account Name | The App Name | pull_api |
| ad_id | TEXT | Ad ID | Ad ID | pull_api |
| ad_type | TEXT | Ad Type | Ad Type | pull_api |
| advertising_id | TEXT | Advertising ID | Advertising ID | pull_api |
| af_ad | TEXT | Ad (appsflyer) | Ad | pull_api |
| af_adset | TEXT | Adset | Adset | pull_api |
| af_adset_id | TEXT | Adset ID | Adset ID | pull_api |
| af_prt | TEXT | Partner | Partner (Agency) | pull_api |
| android_id | TEXT | Android ID | Android ID | pull_api |
| app_id | TEXT | App ID | The App ID | pull_api |
| app_name | TEXT | App Name | App Name | pull_api |
| app_version | TEXT | App Version | App Version | pull_api |
| appsflyer_id | TEXT | AppsFlyer ID | AppsFlyer ID | pull_api |
| attributed_touch_time | TIMESTAMP | Attributed Touch Time | Attributed Touch Time | pull_api |
| attributed_touch_type | TEXT | Touch Type | Touch Type (requires access to the Master API) | pull_api |
| attribution_lookback | TEXT | Attribution Lookback | Attribution Lookback | pull_api |
| average_ecpi | NUMERIC | Average eCPI | Effective Cost per Installation (eCPI) over a certain time frame. Available only if cost and installs are included in the call. | pull_api |
| average_revenue_per_user | NUMERIC | ARPU | Average revenue per user, for the users who installed in the selected time frame (LTV) | pull_api |
| campaign | TEXT | Campaign | Campaign Name | pull_api |
| campaign_id | TEXT | Campaign ID | Campaign ID | pull_api |
| carrier | TEXT | Carrier | Carrier | pull_api |
| channel | TEXT | Channel | Channel | pull_api |
| city | CITY | City | City | pull_api |
| clicks | NUMERIC | Clicks | Number of clicks within the selected time frame | pull_api |
| cost_currency | TEXT | Cost Currency | Cost Currency | pull_api |
| cost_model | TEXT | Cost Model | Cost Model | pull_api |
| cost_value | NUMERIC | Cost Value | Cost Value | pull_api |
| country | COUNTRY | Country | Country | pull_api |
| country_code | TEXT | Country Code | Country Code | pull_api |
| cr | NUMERIC | Conversion Rate | Conversion Rate | pull_api |
| ctr | PERCENT | CTR | Click-Through Rate | pull_api |
| customer_user_id | TEXT | Customer User ID | Customer User ID | pull_api |
| date | DATE | Date | Date | pull_api |
| device_model | TEXT | Device Model | Device Model | pull_api |
| device_region | TEXT | Device Region | Region | pull_api |
| devicecategory | TEXT | Device Category | Device Category | pull_api |
| dma | TEXT | DMA | DMA | pull_api |
| event_counter_af_add_to_cart | NUMERIC | Event Counter - af_add_to_cart | Number of occurrences of the event 'af_add_to_cart' (LTV) | pull_api |
| event_counter_af_complete_registration | NUMERIC | Event Counter - af_complete_registration | Number of occurrences of the event 'af_complete_registration' (LTV) | pull_api |
| event_counter_af_content_view | NUMERIC | Event Counter - af_content_view | Number of occurrences of the event 'af_content_view' (LTV) | pull_api |
| event_counter_af_initiated_checkout | NUMERIC | Event Counter - af_initiated_checkout | Number of occurrences of the event 'af_initiated_checkout' (LTV) | pull_api |
| event_counter_af_login | NUMERIC | Event Counter - af_login | Number of occurrences of the event 'af_login' (LTV) | pull_api |
| event_counter_af_purchase | NUMERIC | Event Counter - af_purchase | Number of occurrences of the event 'af_purchase' (LTV) | pull_api |
| event_name | TEXT | Event Name | Event Name | pull_api |
| event_revenue | NUMERIC | Event Revenue | Event Revenue | pull_api |
| event_revenue_aud | NUMERIC | Event Revenue AUD | Event Revenue AUD | pull_api |
| event_revenue_currency | TEXT | Event Revenue Currency | Event Revenue Currency | pull_api |
| event_source | TEXT | Event Source | Event Source | pull_api |
| event_time | TIMESTAMP | Event Time | Event Time | pull_api |
| event_type | TEXT | Event Type | Specifies if an event is organic or not | pull_api |
| event_value_object | OBJECT | Event Value Object | Event Value Object | pull_api |
| http_referrer | TEXT | HTTP Referrer | HTTP Referrer | pull_api |
| idfa | TEXT | IDFA | IDFA | pull_api |
| idfv | TEXT | IDFV | IDFV | pull_api |
| imei | TEXT | IMEI | IMEI | pull_api |
| impressions | NUMERIC | Impressions | Number of impressions within the selected time frame | pull_api |
| install_time | TEXT | Install Time | Install Time (requires access to the Master API) | pull_api |
| installs | NUMERIC | Installs | Number of installs within the selected time frame | pull_api |
| ip | TEXT | IP | IP | pull_api |
| is_primary | TEXT | Is Primary Attribution | Is Primary Attribution | pull_api |
| is_retargeting | TEXT | Is Retargeting | Is Retargeting | pull_api |
| language | TEXT | Language | Language | pull_api |
| loyal_users | NUMERIC | Loyal Users | Number of loyal users who installed within the selected time frame | pull_api |
| loyal_users_rate | PERCENT | Loyal Users/Installs | Loyal users/installs | pull_api |
| master_api__activity_average_arpdau | NUMERIC | ARPDAU (Master API) | Average revenue per daily active user - the average revenue of a given day out of all unique users (requires access to the Master API) | master_api |
| master_api__activity_average_dau | NUMERIC | Activity Average DAU (Master API) | Average daily active users (DAU) within the selected time frame (requires access to the Master API) | master_api |
| master_api__activity_average_dau_mau_rate | NUMERIC | Average DAU/MAU Rate (Master API) | Average DAU/MAU rate (requires access to the Master API) | master_api |
| master_api__activity_average_mau | NUMERIC | Activity Average MAU (Master API) | Average monthly active users within the selected time frame (one MAU day represents the unique users in the preceding 30 days) (requires access to the Master API) | master_api |
| master_api__activity_average_unique_users_af_add_to_cart | NUMERIC | Activity - Average Unique Users - af_add_to_cart (Master API) | Average unique users performing a given event within the selected time frame, for the event 'af_add_to_cart' (requires access to the Master API) | master_api |
| master_api__activity_average_unique_users_af_complete_registration | NUMERIC | Activity - Average Unique Users - af_complete_registration (Master API) | Average unique users performing a given event within the selected time frame, for the event 'af_complete_registration' (requires access to the Master API) | master_api |
| master_api__activity_average_unique_users_af_content_view | NUMERIC | Activity - Average Unique Users - af_content_view (Master API) | Average unique users performing a given event within the selected time frame, for the event 'af_content_view' (requires access to the Master API) | master_api |
| master_api__activity_average_unique_users_af_initiated_checkout | NUMERIC | Activity - Average Unique Users - af_initiated_checkout (Master API) | Average unique users performing a given event within the selected time frame, for the event 'af_initiated_checkout' (requires access to the Master API) | master_api |
| master_api__activity_average_unique_users_af_login | NUMERIC | Activity - Average Unique Users - af_login (Master API) | Average unique users performing a given event within the selected time frame, for the event 'af_login' (requires access to the Master API) | master_api |
| master_api__activity_average_unique_users_af_purchase | NUMERIC | Activity - Average Unique Users - af_purchase (Master API) | Average unique users performing a given event within the selected time frame, for the event 'af_purchase' (requires access to the Master API) | master_api |
| master_api__activity_event_counter_af_add_to_cart | NUMERIC | Activity - Event Counter - af_add_to_cart (Master API) | Number of events generated by users within the selected time frame, for the event 'af_add_to_cart' (requires access to the Master API) | master_api |
| master_api__activity_event_counter_af_complete_registration | NUMERIC | Activity - Event Counter - af_complete_registration (Master API) | Number of events generated by users within the selected time frame, for the event 'af_complete_registration' (requires access to the Master API) | master_api |
| master_api__activity_event_counter_af_content_view | NUMERIC | Activity - Event Counter - af_content_view (Master API) | Number of events generated by users within the selected time frame, for the event 'af_content_view' (requires access to the Master API) | master_api |
| master_api__activity_event_counter_af_initiated_checkout | NUMERIC | Activity - Event Counter - af_initiated_checkout (Master API) | Number of events generated by users within the selected time frame, for the event 'af_initiated_checkout' (requires access to the Master API) | master_api |
| master_api__activity_event_counter_af_login | NUMERIC | Activity - Event Counter - af_login (Master API) | Number of events generated by users within the selected time frame, for the event 'af_login' (requires access to the Master API) | master_api |
| master_api__activity_event_counter_af_purchase | NUMERIC | Activity - Event Counter - af_purchase (Master API) | Number of events generated by users within the selected time frame, for the event 'af_purchase' (requires access to the Master API) | master_api |
| master_api__activity_revenue | NUMERIC | Activity Revenue (Master API) | Revenue reported within the selected time frame (requires access to the Master API) | master_api |
| master_api__activity_sales_in_usd_af_add_to_cart | NUMERIC | Activity - Sales in USD - af_add_to_cart (Master API) | Revenue reported as part of the reported events within the selected time frame, for the events 'af_add_to_cart' (requires access to the Master API) | master_api |
| master_api__activity_sales_in_usd_af_complete_registration | NUMERIC | Activity - Sales in USD - af_complete_registration (Master API) | Revenue reported as part of the reported events within the selected time frame, for the events 'af_complete_registration' (requires access to the Master API) | master_api |
| master_api__activity_sales_in_usd_af_content_view | NUMERIC | Activity - Sales in USD - af_content_view (Master API) | Revenue reported as part of the reported events within the selected time frame, for the events 'af_content_view' (requires access to the Master API) | master_api |
| master_api__activity_sales_in_usd_af_initiated_checkout | NUMERIC | Activity - Sales in USD - af_initiated_checkout (Master API) | Revenue reported as part of the reported events within the selected time frame, for the events 'af_initiated_checkout' (requires access to the Master API) | master_api |
| master_api__activity_sales_in_usd_af_login | NUMERIC | Activity - Sales in USD - af_login (Master API) | Revenue reported as part of the reported events within the selected time frame, for the events 'af_login' (requires access to the Master API) | master_api |
| master_api__activity_sales_in_usd_af_purchase | NUMERIC | Activity - Sales in USD - af_purchase (Master API) | Revenue reported as part of the reported events within the selected time frame, for the events 'af_purchase' (requires access to the Master API) | master_api |
| master_api__activity_sessions | NUMERIC | Activity Sessions (Master API) | Number of sessions performed within the selected time frame (requires access to the Master API) | master_api |
| master_api__ad_id | TEXT | Ad ID (Master API) | Ad ID (requires access to the Master API) | master_api |
| master_api__af_ad | TEXT | Ad (Master API) | Ad (requires access to the Master API) | master_api |
| master_api__af_adset | TEXT | Adset (Master API) | Adset (requires access to the Master API) | master_api |
| master_api__af_adset_id | TEXT | Adset ID (Master API) | Adset ID (requires access to the Master API) | master_api |
| master_api__af_keywords | TEXT | Keywords | Keywords (requires access to the Master API) | master_api |
| master_api__af_prt | TEXT | Partner (Master API) | Partner (Agency) (requires access to the Master API) | master_api |
| master_api__attributed_touch_type | TEXT | Touch Type (Master API) | Touch Type (requires access to the Master API) (requires access to the Master API) | master_api |
| master_api__average_ecpi | NUMERIC | Average eCPI (Master API) | Effective Cost per Installation (eCPI) over a certain time frame. Available only if cost and installs are included in the call. (requires access to the Master API) | master_api |
| master_api__average_revenue_per_user | TEXT | ARPU (Master API) | Average revenue per user, for the users who installed in the selected time frame (LTV) (requires access to the Master API) | master_api |
| master_api__campaign | TEXT | Campaign (Master API) | Campaign Name (requires access to the Master API) | master_api |
| master_api__campaign_id | TEXT | Campaign ID (Master API) | Campaign ID (requires access to the Master API) | master_api |
| master_api__channel | TEXT | Channel (Master API) | Channel (requires access to the Master API) | master_api |
| master_api__clicks | NUMERIC | Clicks (Master API) | Number of clicks within the selected time frame (requires access to the Master API) | master_api |
| master_api__country | TEXT | Country (Master API) | Country (requires access to the Master API) | master_api |
| master_api__cr | PERCENT | Conversion Rate (Master API) | Conversion Rate (requires access to the Master API) | master_api |
| master_api__event_counter_af_add_to_cart | NUMERIC | Event Counter - af_add_to_cart (Master API) | Number of occurrences of the event 'af_add_to_cart' (LTV) (requires access to the Master API) | master_api |
| master_api__event_counter_af_complete_registration | NUMERIC | Event Counter - af_complete_registration (Master API) | Number of occurrences of the event 'af_complete_registration' (LTV) (requires access to the Master API) | master_api |
| master_api__event_counter_af_content_view | NUMERIC | Event Counter - af_content_view (Master API) | Number of occurrences of the event 'af_content_view' (LTV) (requires access to the Master API) | master_api |
| master_api__event_counter_af_initiated_checkout | NUMERIC | Event Counter - af_initiated_checkout (Master API) | Number of occurrences of the event 'af_initiated_checkout' (LTV) (requires access to the Master API) | master_api |
| master_api__event_counter_af_login | NUMERIC | Event Counter - af_login (Master API) | Number of occurrences of the event 'af_login' (LTV) (requires access to the Master API) | master_api |
| master_api__event_counter_af_purchase | NUMERIC | Event Counter - af_purchase (Master API) | Number of occurrences of the event 'af_purchase' (LTV) (requires access to the Master API) | master_api |
| master_api__impressions | NUMERIC | Impressions (Master API) | Number of impressions within the selected time frame (requires access to the Master API) | master_api |
| master_api__install_time | TEXT | Install Time (Master API) | Install Time (requires access to the Master API) | master_api |
| master_api__installs | NUMERIC | Installs (Master API) | Number of installs within the selected time frame (requires access to the Master API) | master_api |
| master_api__is_primary | TEXT | Is Primary Attribution (Master API) | Is Primary Attribution (requires access to the Master API) | master_api |
| master_api__loyal_users | NUMERIC | Loyal Users (Master API) | Number of loyal users who installed within the selected time frame (requires access to the Master API) | master_api |
| master_api__loyal_users_rate | PERCENT | Loyal Users/Installs (Master API) | Loyal users/installs (requires access to the Master API) | master_api |
| master_api__publisherid | TEXT | Publisher ID (Master API) | Publisher ID (requires access to the Master API) | master_api |
| master_api__roi | NUMERIC | ROI (Master API) | Return on Investment over a certain time frame (requires access to the Master API) | master_api |
| master_api__sales_in_usd_af_add_to_cart | NUMERIC | Sales in USD - af_add_to_cart (Master API) | Revenue reported as part of the reported events 'af_add_to_cart' (LTV) (requires access to the Master API) | master_api |
| master_api__sales_in_usd_af_complete_registration | NUMERIC | Sales in USD - af_complete_registration (Master API) | Revenue reported as part of the reported events 'af_complete_registration' (LTV) (requires access to the Master API) | master_api |
| master_api__sales_in_usd_af_content_view | NUMERIC | Sales in USD - af_content_view (Master API) | Revenue reported as part of the reported events 'af_content_view' (LTV) (requires access to the Master API) | master_api |
| master_api__sales_in_usd_af_initiated_checkout | NUMERIC | Sales in USD - af_initiated_checkout (Master API) | Revenue reported as part of the reported events 'af_initiated_checkout' (LTV) (requires access to the Master API) | master_api |
| master_api__sales_in_usd_af_login | NUMERIC | Sales in USD - af_login (Master API) | Revenue reported as part of the reported events 'af_login' (LTV) (requires access to the Master API) | master_api |
| master_api__sales_in_usd_af_purchase | NUMERIC | Sales in USD - af_purchase (Master API) | Revenue reported as part of the reported events 'af_purchase' (LTV) (requires access to the Master API) | master_api |
| master_api__sessions | NUMERIC | Sessions (Master API) | Number of sessions created by the users who installed within the selected time frame (LTV) (requires access to the Master API) | master_api |
| master_api__source | TEXT | Source (Master API) | Media Source (requires access to the Master API) | master_api |
| master_api__spend | NUMERIC | Spend (Master API) | Total cost in the selected time frame (requires access to the Master API) | master_api |
| master_api__totalcost | NUMERIC | Total Cost (Master API) | Total cost in the selected time frame (alias for Spend) (requires access to the Master API) | master_api |
| master_api__transactionrevenue | NUMERIC | Total Revenue (Master API) | Lifetime revenue generated by the users who installed in the selected time frame (requires access to the Master API) | master_api |
| master_api__transactions | NUMERIC | Transactions (Master API) | Number of installs within the selected time frame (requires access to the Master API) | master_api |
| master_api__uninstalls | NUMERIC | Uninstalls (Master API) | Uninstalling users, who installed in the selected timeuninstalls_rate frame (requires access to the Master API) | master_api |
| master_api__uninstalls_rate | PERCENT | Uninstall Rate (Master API) | Uninstallation rate (requires access to the Master API) | master_api |
| master_api__unique_users_af_add_to_cart | NUMERIC | Unique Users - af_add_to_cart (Master API) | Number of unique users who performed the event 'af_add_to_cart' (LTV) (requires access to the Master API) | master_api |
| master_api__unique_users_af_complete_registration | NUMERIC | Unique Users - af_complete_registration (Master API) | Number of unique users who performed the event 'af_complete_registration' (LTV) (requires access to the Master API) | master_api |
| master_api__unique_users_af_content_view | NUMERIC | Unique Users - af_content_view (Master API) | Number of unique users who performed the event 'af_content_view' (LTV) (requires access to the Master API) | master_api |
| master_api__unique_users_af_initiated_checkout | NUMERIC | Unique Users - af_initiated_checkout (Master API) | Number of unique users who performed the event 'af_initiated_checkout' (LTV) (requires access to the Master API) | master_api |
| master_api__unique_users_af_login | NUMERIC | Unique Users - af_login (Master API) | Number of unique users who performed the event 'af_login' (LTV) (requires access to the Master API) | master_api |
| master_api__unique_users_af_purchase | NUMERIC | Unique Users - af_purchase (Master API) | Number of unique users who performed the event 'af_purchase' (LTV) (requires access to the Master API) | master_api |
| match_type | TEXT | Match Type | Match Type | pull_api |
| operator | TEXT | Operator | Operator | pull_api |
| original_url | TEXT | Original URL | Original URL | pull_api |
| os_version | TEXT | OS Version | OS Version | pull_api |
| platform | TEXT | Platform | Platform | pull_api |
| postal_code | TEXT | Postal Code | Postal Code | pull_api |
| reengagement_window | TEXT | Reengagement Window | Reengagement Window | pull_api |
| retargeting_conversion_type | TEXT | Retargeting Conversion Type | Retargeting Conversion Type | pull_api |
| roi | PERCENT | ROI | Return on Investment over a certain time frame | pull_api |
| sales_in_usd_af_add_to_cart | NUMERIC | Sales in USD - af_add_to_cart | Revenue reported as part of the reported events 'af_add_to_cart' (LTV) | pull_api |
| sales_in_usd_af_complete_registration | NUMERIC | Sales in USD - af_complete_registration | Revenue reported as part of the reported events 'af_complete_registration' (LTV) | pull_api |
| sales_in_usd_af_content_view | NUMERIC | Sales in USD - af_content_view | Revenue reported as part of the reported events 'af_content_view' (LTV) | pull_api |
| sales_in_usd_af_initiated_checkout | NUMERIC | Sales in USD - af_initiated_checkout | Revenue reported as part of the reported events 'af_initiated_checkout' (LTV) | pull_api |
| sales_in_usd_af_login | NUMERIC | Sales in USD - af_login | Revenue reported as part of the reported events 'af_login' (LTV) | pull_api |
| sales_in_usd_af_purchase | NUMERIC | Sales in USD - af_purchase | Revenue reported as part of the reported events 'af_purchase' (LTV) | pull_api |
| sdk_version | TEXT | SDK Version | SDK Version | pull_api |
| sessions | NUMERIC | Sessions | Number of sessions created by the users who installed within the selected time frame (LTV) | pull_api |
| site_id | TEXT | Site ID | Site ID | pull_api |
| source | TEXT | Source | Media Source | pull_api |
| spend | NUMERIC | Spend | Total cost in the selected time frame | pull_api |
| state | TEXT | State | State | pull_api |
| store_product_page | TEXT | Store Product Page | Store Product Page | pull_api |
| totalcost | NUMERIC | Total Cost | Total cost in the selected time frame (alias for Spend) | pull_api |
| transactionrevenue | NUMERIC | Total Revenue | Lifetime revenue generated by the users who installed in the selected time frame | pull_api |
| transactions | NUMERIC | Transactions | Number of installs within the selected time frame | pull_api |
| unique_users_af_add_to_cart | NUMERIC | Unique Users - af_add_to_cart | Number of unique users who performed the event 'af_add_to_cart' (LTV) | pull_api |
| unique_users_af_complete_registration | NUMERIC | Unique Users - af_complete_registration | Number of unique users who performed the event 'af_complete_registration' (LTV) | pull_api |
| unique_users_af_content_view | NUMERIC | Unique Users - af_content_view | Number of unique users who performed the event 'af_content_view' (LTV) | pull_api |
| unique_users_af_initiated_checkout | NUMERIC | Unique Users - af_initiated_checkout | Number of unique users who performed the event 'af_initiated_checkout' (LTV) | pull_api |
| unique_users_af_login | NUMERIC | Unique Users - af_login | Number of unique users who performed the event 'af_login' (LTV) | pull_api |
| unique_users_af_purchase | NUMERIC | Unique Users - af_purchase | Number of unique users who performed the event 'af_purchase' (LTV) | pull_api |
| user_agent | TEXT | User Agent | User Agent | pull_api |
| today | DATE | Today | Today's date |