Windsor brings all your AppsFlyer data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
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 | COUNTRY | 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 |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date | pull_api |
| day_of_month | TEXT | Day of month | Day of the month | |
| device_model | TEXT | Device Model | Device Model | pull_api |
| device_region | REGION | 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 | TIMESTAMP | 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 | COUNTRY | 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 | TIMESTAMP | 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 |
| month | TEXT | Month | Number of the month | |
| 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 |
| today | DATE | Today | Today's date | |
| 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 |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |