AppsFlyer Connector Reference

99 metrics191 dimensions

Fields

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

The AppsFlyer connector exposes 290 fields (99 metrics, 191 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

AppsFlyer Fields

AppsFlyer master_api fields

The master_api report of the AppsFlyer connector includes 73 fields.

AppsFlyer master_api fields (master_api__activity_average_arpdau to master_api__event_counter_af_add_to_cart)

ID	Type	Name	Description
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__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__activity_average_dau_mau_rate	NUMERIC	Average DAU/MAU Rate (Master API)	Average DAU/MAU rate (requires access to the 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__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__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__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__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__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__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__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__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__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__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__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__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__activity_revenue	NUMERIC	Activity Revenue (Master API)	Revenue reported within the selected time frame (requires access to the 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__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__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__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__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__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__activity_sessions	NUMERIC	Activity Sessions (Master API)	Number of sessions performed within the selected time frame (requires access to the Master API)
master_api__ad_id	TEXT	Ad ID (Master API)	Ad ID (requires access to the Master API)
master_api__af_ad	TEXT	Ad (Master API)	Ad (requires access to the Master API)
master_api__af_adset	TEXT	Adset (Master API)	Adset (requires access to the Master API)
master_api__af_adset_id	TEXT	Adset ID (Master API)	Adset ID (requires access to the Master API)
master_api__af_keywords	TEXT	Keywords	Keywords (requires access to the Master API)
master_api__af_prt	TEXT	Partner (Master API)	Partner (Agency) (requires access to the 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__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__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__campaign	TEXT	Campaign (Master API)	Campaign Name (requires access to the Master API)
master_api__campaign_id	TEXT	Campaign ID (Master API)	Campaign ID (requires access to the Master API)
master_api__channel	TEXT	Channel (Master API)	Channel (requires access to the 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__country	COUNTRY	Country (Master API)	Country (requires access to the Master API)
master_api__cr	PERCENT	Conversion Rate (Master API)	Conversion Rate (requires access to the 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)

AppsFlyer master_api fields (master_api__event_counter_af_complete_registration to master_api__unique_users_af_purchase)

ID	Type	Name	Description
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__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__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__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__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__impressions	NUMERIC	Impressions (Master API)	Number of impressions within the selected time frame (requires access to the Master API)
master_api__install_time	TIMESTAMP	Install Time (Master API)	Install Time (requires access to the 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__is_primary	TEXT	Is Primary Attribution (Master API)	Is Primary Attribution (requires access to the 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__loyal_users_rate	PERCENT	Loyal Users/Installs (Master API)	Loyal users/installs (requires access to the Master API)
master_api__publisherid	TEXT	Publisher ID (Master API)	Publisher ID (requires access to the 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__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__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__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__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__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__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__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__source	TEXT	Source (Master API)	Media Source (requires access to the Master API)
master_api__spend	NUMERIC	Spend (Master API)	Total cost in the selected time frame (requires access to the 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__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__transactions	NUMERIC	Transactions (Master API)	Number of installs within the selected time frame (requires access to the 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__uninstalls_rate	PERCENT	Uninstall Rate (Master API)	Uninstallation rate (requires access to the 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__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__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__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__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__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)

AppsFlyer pull_api fields

The pull_api report of the AppsFlyer connector includes 200 fields.

AppsFlyer pull_api fields (account_id to device_model)

ID	Type	Name	Description
account_id	TEXT	Account ID	The App ID
account_name	TEXT	Account Name	The App Name
ad_id	TEXT	Ad ID	Ad ID. Available in the raw data reports only: with installs it gives installs per ad id from the installs report, with aggregate metrics such as spend, clicks or impressions it stays empty
ad_type	TEXT	Ad Type	Ad Type
advertising_id	TEXT	Advertising ID	Advertising ID
af_ad	TEXT	Ad (appsflyer)	Ad. Available in the raw data reports only: with installs it gives installs per ad from the installs report, with aggregate metrics such as spend, clicks or impressions it stays empty
af_adset	TEXT	Adset	Adset. Available in the raw data reports only: with installs it gives installs per adset from the installs report, with aggregate metrics such as spend, clicks or impressions it stays empty
af_adset_id	TEXT	Adset ID	Adset ID. Available in the raw data reports only: with installs it gives installs per adset id from the installs report, with aggregate metrics such as spend, clicks or impressions it stays empty
af_prt	TEXT	Partner	Partner (Agency)
af_sub1	TEXT	Sub Param 1	Sub Param 1 (af_sub1), a custom parameter on the attribution link
af_sub2	TEXT	Sub Param 2	Sub Param 2 (af_sub2), a custom parameter on the attribution link
af_sub3	TEXT	Sub Param 3	Sub Param 3 (af_sub3), a custom parameter on the attribution link
af_sub4	TEXT	Sub Param 4	Sub Param 4 (af_sub4), a custom parameter on the attribution link
af_sub5	TEXT	Sub Param 5	Sub Param 5 (af_sub5), a custom parameter on the attribution link
android_id	TEXT	Android ID	Android ID
app_id	TEXT	App ID	The App ID
app_name	TEXT	App Name	App Name
app_version	TEXT	App Version	App Version
appsflyer_id	TEXT	AppsFlyer ID	AppsFlyer ID
attributed_touch_time	TIMESTAMP	Attributed Touch Time	Attributed Touch Time
attributed_touch_type	TEXT	Touch Type	Touch Type (requires access to the Master API)
attribution_lookback	TEXT	Attribution Lookback	Attribution Lookback
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.
average_revenue_per_user	NUMERIC	ARPU	Average revenue per user, for the users who installed in the selected time frame (LTV)
campaign	TEXT	Campaign	Campaign Name
campaign_id	TEXT	Campaign ID	Campaign ID
carrier	TEXT	Carrier	Carrier
channel	TEXT	Channel	Channel
city	CITY	City	City
clicks	NUMERIC	Clicks	Number of clicks within the selected time frame
cost_currency	TEXT	Cost Currency	Cost Currency
cost_model	TEXT	Cost Model	Cost Model
cost_value	NUMERIC	Cost Value	Cost Value
country	COUNTRY	Country	Country
country_code	COUNTRY	Country Code	Country Code
cr	NUMERIC	Conversion rate	Conversion Rate
ctr	PERCENT	CTR	Click-Through Rate
customer_user_id	TEXT	Customer User ID	Customer User ID
date	DATE	Date	Date
device_model	TEXT	Device Model	Device Model

AppsFlyer pull_api fields (device_region to non_organic_attribution_lookback)

ID	Type	Name	Description
device_region	REGION	Device Region	Region
devicecategory	TEXT	Device Category	Device Category
dma	TEXT	DMA	DMA
event_counter_af_add_to_cart	NUMERIC	Event Counter - af_add_to_cart	Number of occurrences of the event 'af_add_to_cart' (LTV)
event_counter_af_complete_registration	NUMERIC	Event Counter - af_complete_registration	Number of occurrences of the event 'af_complete_registration' (LTV)
event_counter_af_content_view	NUMERIC	Event Counter - af_content_view	Number of occurrences of the event 'af_content_view' (LTV)
event_counter_af_initiated_checkout	NUMERIC	Event Counter - af_initiated_checkout	Number of occurrences of the event 'af_initiated_checkout' (LTV)
event_counter_af_login	NUMERIC	Event Counter - af_login	Number of occurrences of the event 'af_login' (LTV)
event_counter_af_purchase	NUMERIC	Event Counter - af_purchase	Number of occurrences of the event 'af_purchase' (LTV)
event_name	TEXT	Event Name	Event Name
event_revenue	NUMERIC	Event Revenue	Event Revenue
event_revenue_aud	NUMERIC	Event Revenue AUD	Event Revenue AUD
event_revenue_currency	TEXT	Event Revenue Currency	Event Revenue Currency
event_source	TEXT	Event Source	Event Source
event_time	TIMESTAMP	Event Time	Event Time
event_type	TEXT	Event Type	Specifies if an event is organic or not
event_value_object	OBJECT	Event Value Object	Event Value Object
http_referrer	TEXT	HTTP Referrer	HTTP Referrer
idfa	TEXT	IDFA	IDFA
idfv	TEXT	IDFV	IDFV
imei	TEXT	IMEI	IMEI
impressions	NUMERIC	Impressions	Number of impressions within the selected time frame
install_time	TIMESTAMP	Install Time	Install Time (requires access to the Master API)
installs	NUMERIC	Installs	Number of installs within the selected time frame
ip	TEXT	IP	IP
is_primary	TEXT	Is Primary Attribution	Is Primary Attribution
is_retargeting	TEXT	Is Retargeting	Is Retargeting
language	TEXT	Language	Language
loyal_users	NUMERIC	Loyal Users	Number of loyal users who installed within the selected time frame
loyal_users_rate	PERCENT	Loyal Users/Installs	Loyal users/installs
match_type	TEXT	Match Type	Match Type
non_organic_ad_type	TEXT	Ad Type (non-organic)	Ad Type (Non-organic only)
non_organic_advertising_id	TEXT	Advertising ID (non-organic)	Advertising ID (Non-organic only)
non_organic_af_prt	TEXT	Partner (non-organic)	Partner (Agency) (Non-organic only)
non_organic_android_id	TEXT	Android ID (non-organic)	Android ID (Non-organic only)
non_organic_app_name	TEXT	App Name (non-organic)	App Name (Non-organic only)
non_organic_app_version	TEXT	App Version (non-organic)	App Version (Non-organic only)
non_organic_appsflyer_id	TEXT	AppsFlyer ID (non-organic)	AppsFlyer ID (Non-organic only)
non_organic_attributed_touch_time	TIMESTAMP	Attributed Touch Time (non-organic)	Attributed Touch Time (Non-organic only)
non_organic_attribution_lookback	TEXT	Attribution Lookback (non-organic)	Attribution Lookback (Non-organic only)

AppsFlyer pull_api fields (non_organic_carrier to non_organic_user_agent)

ID	Type	Name	Description
non_organic_carrier	TEXT	Carrier (non-organic)	Carrier (Non-organic only)
non_organic_channel	TEXT	Channel (non-organic)	Channel (Non-organic only)
non_organic_city	CITY	City (non-organic)	City (Non-organic only)
non_organic_cost_currency	TEXT	Cost Currency (non-organic)	Cost Currency (Non-organic only)
non_organic_cost_model	TEXT	Cost Model (non-organic)	Cost Model (Non-organic only)
non_organic_cost_value	NUMERIC	Cost Value (non-organic)	Cost Value (Non-organic only)
non_organic_country_code	COUNTRY	Country Code (non-organic)	Country Code (Non-organic only)
non_organic_customer_user_id	TEXT	Customer User ID (non-organic)	Customer User ID (Non-organic only)
non_organic_device_model	TEXT	Device Model (non-organic)	Device Model (Non-organic only)
non_organic_device_region	REGION	Device Region (non-organic)	Region (Non-organic only)
non_organic_devicecategory	TEXT	Device Category (non-organic)	Device Category (Non-organic only)
non_organic_dma	TEXT	DMA (non-organic)	DMA (Non-organic only)
non_organic_event_name	TEXT	Event Name (non-organic)	Event Name (Non-organic only)
non_organic_event_revenue	NUMERIC	Event Revenue (non-organic)	Event Revenue (Non-organic only)
non_organic_event_revenue_aud	NUMERIC	Event Revenue AUD (non-organic)	Event Revenue AUD (Non-organic only)
non_organic_event_revenue_currency	TEXT	Event Revenue Currency (non-organic)	Event Revenue Currency (Non-organic only)
non_organic_event_source	TEXT	Event Source (non-organic)	Event Source (Non-organic only)
non_organic_event_time	TIMESTAMP	Event Time (non-organic)	Event Time (Non-organic only)
non_organic_event_type	TEXT	Event Type (non-organic)	Specifies if an event is organic or not (Non-organic only)
non_organic_event_value_object	OBJECT	Event Value Object (non-organic)	Event Value Object (Non-organic only)
non_organic_http_referrer	TEXT	HTTP Referrer (non-organic)	HTTP Referrer (Non-organic only)
non_organic_idfa	TEXT	IDFA (non-organic)	IDFA (Non-organic only)
non_organic_idfv	TEXT	IDFV (non-organic)	IDFV (Non-organic only)
non_organic_imei	TEXT	IMEI (non-organic)	IMEI (Non-organic only)
non_organic_ip	TEXT	IP (non-organic)	IP (Non-organic only)
non_organic_is_retargeting	TEXT	Is Retargeting (non-organic)	Is Retargeting (Non-organic only)
non_organic_language	TEXT	Language (non-organic)	Language (Non-organic only)
non_organic_match_type	TEXT	Match Type (non-organic)	Match Type (Non-organic only)
non_organic_operator	TEXT	Operator (non-organic)	Operator (Non-organic only)
non_organic_original_url	TEXT	Original URL (non-organic)	Original URL (Non-organic only)
non_organic_os_version	TEXT	OS Version (non-organic)	OS Version (Non-organic only)
non_organic_platform	TEXT	Platform (non-organic)	Platform (Non-organic only)
non_organic_postal_code	TEXT	Postal Code (non-organic)	Postal Code (Non-organic only)
non_organic_reengagement_window	TEXT	Reengagement Window (non-organic)	Reengagement Window (Non-organic only)
non_organic_retargeting_conversion_type	TEXT	Retargeting Conversion Type (non-organic)	Retargeting Conversion Type (Non-organic only)
non_organic_sdk_version	TEXT	SDK Version (non-organic)	SDK Version (Non-organic only)
non_organic_site_id	TEXT	Site ID (non-organic)	Site ID (Non-organic only)
non_organic_state	TEXT	State (non-organic)	State (Non-organic only)
non_organic_store_product_page	TEXT	Store Product Page (non-organic)	Store Product Page (Non-organic only)
non_organic_user_agent	TEXT	User Agent (non-organic)	User Agent (Non-organic only)

AppsFlyer pull_api fields (operator to organic_original_url)

ID	Type	Name	Description
operator	TEXT	Operator	Operator
organic_ad_type	TEXT	Ad Type (organic)	Ad Type (Organic only)
organic_advertising_id	TEXT	Advertising ID (organic)	Advertising ID (Organic only)
organic_af_prt	TEXT	Partner (organic)	Partner (Agency) (Organic only)
organic_android_id	TEXT	Android ID (organic)	Android ID (Organic only)
organic_app_name	TEXT	App Name (organic)	App Name (Organic only)
organic_app_version	TEXT	App Version (organic)	App Version (Organic only)
organic_appsflyer_id	TEXT	AppsFlyer ID (organic)	AppsFlyer ID (Organic only)
organic_attributed_touch_time	TIMESTAMP	Attributed Touch Time (organic)	Attributed Touch Time (Organic only)
organic_attribution_lookback	TEXT	Attribution Lookback (organic)	Attribution Lookback (Organic only)
organic_carrier	TEXT	Carrier (organic)	Carrier (Organic only)
organic_channel	TEXT	Channel (organic)	Channel (Organic only)
organic_city	CITY	City (organic)	City (Organic only)
organic_cost_currency	TEXT	Cost Currency (organic)	Cost Currency (Organic only)
organic_cost_model	TEXT	Cost Model (organic)	Cost Model (Organic only)
organic_cost_value	NUMERIC	Cost Value (organic)	Cost Value (Organic only)
organic_country_code	COUNTRY	Country Code (organic)	Country Code (Organic only)
organic_customer_user_id	TEXT	Customer User ID (organic)	Customer User ID (Organic only)
organic_device_model	TEXT	Device Model (organic)	Device Model (Organic only)
organic_device_region	REGION	Device Region (organic)	Region (Organic only)
organic_devicecategory	TEXT	Device Category (organic)	Device Category (Organic only)
organic_dma	TEXT	DMA (organic)	DMA (Organic only)
organic_event_name	TEXT	Event Name (organic)	Event Name (Organic only)
organic_event_revenue	NUMERIC	Event Revenue (organic)	Event Revenue (Organic only)
organic_event_revenue_aud	NUMERIC	Event Revenue AUD (organic)	Event Revenue AUD (Organic only)
organic_event_revenue_currency	TEXT	Event Revenue Currency (organic)	Event Revenue Currency (Organic only)
organic_event_source	TEXT	Event Source (organic)	Event Source (Organic only)
organic_event_time	TIMESTAMP	Event Time (organic)	Event Time (Organic only)
organic_event_type	TEXT	Event Type (organic)	Specifies if an event is organic or not (Organic only)
organic_event_value_object	OBJECT	Event Value Object (organic)	Event Value Object (Organic only)
organic_http_referrer	TEXT	HTTP Referrer (organic)	HTTP Referrer (Organic only)
organic_idfa	TEXT	IDFA (organic)	IDFA (Organic only)
organic_idfv	TEXT	IDFV (organic)	IDFV (Organic only)
organic_imei	TEXT	IMEI (organic)	IMEI (Organic only)
organic_ip	TEXT	IP (organic)	IP (Organic only)
organic_is_retargeting	TEXT	Is Retargeting (organic)	Is Retargeting (Organic only)
organic_language	TEXT	Language (organic)	Language (Organic only)
organic_match_type	TEXT	Match Type (organic)	Match Type (Organic only)
organic_operator	TEXT	Operator (organic)	Operator (Organic only)
organic_original_url	TEXT	Original URL (organic)	Original URL (Organic only)

AppsFlyer pull_api fields (organic_os_version to user_agent)

ID	Type	Name	Description
organic_os_version	TEXT	OS Version (organic)	OS Version (Organic only)
organic_platform	TEXT	Platform (organic)	Platform (Organic only)
organic_postal_code	TEXT	Postal Code (organic)	Postal Code (Organic only)
organic_reengagement_window	TEXT	Reengagement Window (organic)	Reengagement Window (Organic only)
organic_retargeting_conversion_type	TEXT	Retargeting Conversion Type (organic)	Retargeting Conversion Type (Organic only)
organic_sdk_version	TEXT	SDK Version (organic)	SDK Version (Organic only)
organic_site_id	TEXT	Site ID (organic)	Site ID (Organic only)
organic_state	TEXT	State (organic)	State (Organic only)
organic_store_product_page	TEXT	Store Product Page (organic)	Store Product Page (Organic only)
organic_user_agent	TEXT	User Agent (organic)	User Agent (Organic only)
original_url	TEXT	Original URL	Original URL
os_version	TEXT	OS Version	OS Version
platform	TEXT	Platform	Platform
postal_code	TEXT	Postal Code	Postal Code
reengagement_window	TEXT	Reengagement Window	Reengagement Window
retargeting_conversion_type	TEXT	Retargeting Conversion Type	Retargeting Conversion Type
roi	PERCENT	ROI	Return on Investment over a certain time frame
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)
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)
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)
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)
sales_in_usd_af_login	NUMERIC	Sales in USD - af_login	Revenue reported as part of the reported events 'af_login' (LTV)
sales_in_usd_af_purchase	NUMERIC	Sales in USD - af_purchase	Revenue reported as part of the reported events 'af_purchase' (LTV)
sdk_version	TEXT	SDK Version	SDK Version
sessions	NUMERIC	Sessions	Number of sessions created by the users who installed within the selected time frame (LTV)
site_id	TEXT	Site ID	Site ID
source	TEXT	Source	Media Source
spend	NUMERIC	Spend	Total cost in the selected time frame
state	TEXT	State	State
store_product_page	TEXT	Store Product Page	Store Product Page
totalcost	NUMERIC	Total Cost	Total cost in the selected time frame (alias for Spend)
transactionrevenue	NUMERIC	Total Revenue	Lifetime revenue generated by the users who installed in the selected time frame
transactions	NUMERIC	Transactions	Number of installs within the selected time frame
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)
unique_users_af_complete_registration	NUMERIC	Unique Users - af_complete_registration	Number of unique users who performed the event 'af_complete_registration' (LTV)
unique_users_af_content_view	NUMERIC	Unique Users - af_content_view	Number of unique users who performed the event 'af_content_view' (LTV)
unique_users_af_initiated_checkout	NUMERIC	Unique Users - af_initiated_checkout	Number of unique users who performed the event 'af_initiated_checkout' (LTV)
unique_users_af_login	NUMERIC	Unique Users - af_login	Number of unique users who performed the event 'af_login' (LTV)
unique_users_af_purchase	NUMERIC	Unique Users - af_purchase	Number of unique users who performed the event 'af_purchase' (LTV)
user_agent	TEXT	User Agent	User Agent

AppsFlyer other fields

The AppsFlyer connector has 17 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
today	DATE	Today	Today's date
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_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
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

API Connectors