AppsFlyer - Supported Columns
Every column the AppsFlyer connector can download.
These are the columns available to an AppsFlyer connector. The recommended template uses a small subset, listed on the AppsFlyer page. Which of these arrive depends on the export URL the connector reads, since AppsFlyer builds the report from that URL.
Dimensions
af_ad
Ad
Attribution
String
Ad name
af_ad_id
Ad ID
Attribution
String
Ad ID
af_ad_type
Ad type
Attribution
String
Example: banner, footer
af_adset_id
Adset ID
Attribution
String
Ad set ID, the ID of an Ad set.
campaign
Campaign
Attribution
String
Contains one or more ad sets
af_c_id
Campaign ID
Attribution
String
Campaign ID
af_channel
Channel
Attribution
String
Media source channel. Example: YouTube for Google, Instagram for Facebook
campaign_type
Campaign type
Attribution
String
[List]
conversion_type
Conversion type
Attribution
String
[List]
af_cost_model
Cost model
Attribution
String
Cost model reported on the attribution link. CPC/CPI/CPM/Other. Currently, all cost is calculated according to CPI regardless of this value.
af_keywords
Keywords
Attribution
String
Word(s) used in the user's online search. As reported by the ad network
af_prt
Partner
Attribution
String
Agency or PMD
af_siteid
Site ID
Attribution
String
Publisher ID
af_sub_siteid
Sub site ID
Attribution
String
Sub-publisher ID
af_sub1
Sub param 1
Attribution
String
Parameter populated by the advertiser in the SDK
af_sub2
Sub param 2
Attribution
String
Parameter populated by the advertiser in the SDK
af_sub3
Sub param 3
Attribution
String
Parameter populated by the advertiser in the SDK
af_sub4
Sub param 4
Attribution
String
Parameter populated by the advertiser in the SDK
af_sub5
Sub param 5
Attribution
String
Parameter populated by the advertiser in the SDK
media_source
Media source
Attribution
String
The media source attributed to an event or�restricted
user_agent
User agent
Attribution
String
The URL user agent
android_id
Android ID
Device info
String
Permanent device ID
app_id
App ID
App
String
[List]
app_name
App name
App
String
Set by the advertiser
app_version
App version
App
String
Set by the advertiser
appsflyer_id
AppsFlyer ID
Device info
String
[List]
bundle_id
Bundle ID
App
String
ios: Identification to match either a single app or a group of apps in iOS (See Apple developer bundle ID) Android: The app name Note: This field is not related to AppsFlyer PBA
carrier
Carrier
Device info
String
The carrier name provided by Android using�getSimCarrierIdName().�See also carrier mapping.
country_code
Country code
Device location
String
[List]
customer_user_id
Customer user ID
Device info
String
A unique app user ID, set by the app owner.
deeplink_url
Deeplink URL
Attribution
String
The path for an internal activity in the app that users are deep linked into. Use this for deep linking and deferred deep linking.
device_category
Device category
Device info
String
[List]
device_type
Device type
Device info
String
The commercial model name of the device. Use the field Device model. For the present in Push API, Device type is equivalent to Device model. [Deprecation planned. Sunset date to be advised]
device_model
Device model
Device info
String
The commercial model name of the device.Example: SM-GM284 or iPhone7
idfv
IDFV
Device info
String
Vendor ID provided by iOS
imei
IMEI
Device info
String
Permanent device ID
install_app_store
Install app store
Attribution
String
The Android store where the app was downloaded from (details)
install_time
Install time
Attribution
String
[List]
ip
IP
Device location
String
IP address�being IPV4 or IPV6
language
Language
Device info
String
Language (locale) reported by the device and set by the device OS. Usually has the form ll-DD. Where ll is the language and DD is the dialect.� For example, en-ZA means English as used in South Africa.
oaid
OAID
Device info
String
User-resettable ID on some Android devices usually as an alternative to GAID
att
ATT
Device info
String
ATT (starting iOS 14) is normally populated using ATTrackingManager values or other values determined by AppsFlyer. About ATT field values Use this field to gain insights into user privacy preferences.
operator
Operator
Device info
String
The name of the mobile operator derived from the SIM MCCMNC. Available if the user is registered to the network using Android�getNetworkOperatorName()
os_version
OS version
Device info
String
Device operating system version
platform
Platform
Device info
String
Device platform: iOS, Android, or Windows Mobile
sdk_version
SDK version
App
String
AppsFlyer SDK version
wifi
WIFI
Device info
Boolean
TRUE/FALSE
amazon_aid
Amazon Fire ID
Device info
String
User-resettable advertising ID on Amazon devices.
city
City
Device location
String
The most granular location of the user based on the device IP. Usually, the value holds a city name, but it can also be districts, boroughs, etc., which are more accurate.
contributor1_af_prt
Contributor 1 partner
Attribution
String
Agency or PMD -� always converted to lowercase
contributor2_af_prt
Contributor 2 partner
Attribution
String
Agency or PMD -� always converted to lowercase
contributor3_af_prt
Contributor 3 partner
Attribution
String
Agency or PMD -� always converted to lowercase
contributor4_af_prt
Contributor 4 partner
Attribution
String
Agency or PMD -� always converted to lowercase
contributor5_af_prt
Contributor 5 partner
Attribution
String
Agency or PMD -� always converted to lowercase
contributor1_campaign
Contributor 1 campaign
Attribution
String
contributor2_campaign
Contributor 2 campaign
Attribution
String
contributor3_campaign
Contributor 3 campaign
Attribution
String
contributor4_campaign
Contributor 4 campaign
Attribution
String
contributor5_campaign
Contributor 5 campaign
Attribution
String
contributor1_match_type
Contributor 1 match type
Attribution
String
Possible values are the same as match type.
contributor2_match_type
Contributor 2 match type
Attribution
String
Possible values are the same as match type.
contributor3_match_type
Contributor 3 match type
Attribution
String
Possible values are the same as match type.
contributor4_match_type
Contributor 4 match type
Attribution
String
Possible values are the same as match type.
contributor5_match_type
Contributor 5 match type
Attribution
String
Possible values are the same as match type.
contributor1_media_source
Contributor 1 media source
Attribution
String
contributor2_media_source
Contributor 2 media source
Attribution
String
contributor3_media_source
Contributor 3 media source
Attribution
String
contributor4_media_source
Contributor 4 media source
Attribution
String
contributor5_media_source
Contributor 5 media source
Attribution
String
contributor1_touch_time
Contributor 1 touch time
Attribution
String
contributor2_touch_time
Contributor 2 touch time
Attribution
String
contributor3_touch_time
Contributor 3 touch time
Attribution
String
contributor4_touch_time
Contributor 4 touch time
Attribution
String
contributor5_touch_time
Contributor 5 touch time
Attribution
String
contributor1_touch_type
Contributor 1 touch type
Attribution
String
Possible values:�click, impression, TV
contributor2_touch_type
Contributor 2 touch type
Attribution
String
Possible values:�click, impression, TV
contributor3_touch_type
Contributor 3 touch type
Attribution
String
Possible values:�click, impression, TV
contributor4_touch_type
Contributor 4 touch type
Attribution
String
Possible values:�click, impression, TV
contributor5_touch_type
Contributor 5 touch type
Attribution
String
Possible values:�click, impression, TV
dma
DMA
Device location
String
Designated Market Area - regions or the geographic areas in the US where local television viewing is measured by the Nielsen company.
event_source
Event source
Event
String
Either SDK or S2S
http_referrer
HTTP referrer
Attribution
String
Identifies the address of the webpage that linked to the AppsFlyer click URL. By checking the referrer, you can see where the request originated.
is_receipt_validated
Is receipt validated
Event
Boolean
TRUE/FALSE/NULL when implemented in the SDK, empty otherwise
match_type
Match type
Attribution
String
[List]
postal_code
Postal code
Device location
String
Using the device IP address reported by the SDK
region
Region
Device location
String
Using the device IP address reported by the SDK
state
State
Device location
String
Using the device IP address reported by the SDK
keyword_id
Keyword ID
Attribution
String
Keyword ID returned by the ad network. This is the ID of the af_keyword.
keyword_match_type
Keyword match type
Attribution
String
The keyword match type returns by search networks APIs or attribution links shall be mapped to the raw report. Note: Google AdWords and Apple Search Ads are the only networks that return this parameter for search campaigns.
network_account_id
Network account ID
Attribution
String
Advertiser's account ID with the partner
rejected_reason_value In Data Locker: validation_reason_value
Rejected reason value
Protect360
String
Protect360:�Displays the valid contributor (media source) for post-attribution hijacked installs/in-app events. Populated with either�contributor[1-3]�or�organic. In Data Locker, this displays as validation_reason_value.
rejected_reason
Rejected reason
Protect360
String
Protect360: See blocked reason.
blocked_reason
Blocked reason
Protect360
String
Protect360: the reason the install is blocked. Example: install_hijacking, bots
blocked_sub_reason
Blocked sub reason
Protect360
String
Protect360: particular sub reason for a blocked install. Example: Reason: install_hijacking. Sub-reason: referer hijack, CTIT_anomalies, validation_rules
blocked_reason_value
Blocked reason value
Protect360
String
Protect360:Additional information regarding the block. Example: Site ID, validation rule name/s
gp_broadcast_referrer
Google Play broadcast referrer
Attribution
String
Google Play Broadcast Referrer
custom_dimension
Custom dimension
Attribution
String
Reserved for AppsFlyer future use
app_type
App type
Attribution
String
Not yet available Values: app_clip, full_app
fraud_reason
Fraud reason
Protect360
String
Protect360: See blocked reason.
fraud_sub_reason
Fraud sub reason
Protect360
String
Protect360: See blocked sub reason.
is_organic
Is organic
Protect360
String
Indication of whether the in-app event is associated with an organic install.
detection_date
Detection date
Protect360
String
Date post-attribution fraud is detected.
Metrics
af_cost_value
Cost value
Attribution
Decimal
Amount of Cost Currency. 4 digits after the decimal point permitted. Example: 320.5095
event_revenue
Event revenue
Event
String
[List]
Other columns
af_cost_currency
Cost currency
Attribution
String
3-letter currency code (USD, EUR) that complies with�ISO-4217. Default is USD.
af_attribution_lookback
Attribution lookback
Attribution
String
[List]
is_retargeting
Is Retargeting
Attribution
Boolean
[List]
original_url
Original URL
Attribution
String
[List]
custom_data
Custom data
Attribution
String
[List]
device_download_time
Device download time
Device info
String
App download completion time using the device's (Android, iOS) clock and converted to UTC. The value always displays as� UTC time. Format: yyyy-mm-dd hh🇲🇲ss.sss
event_name
Event name
Event
String
Attribution raw data (installs, retargeting, and so on) the type of event. For example: Install, re-attribution, re-engagement. Note! In Data Locker retargeting conversions the value is set as follows retargeting means re-engagement, install means re-attribution. In-app event raw data: The relevant event name.
event_revenue_currency
Event revenue currency
Event
String
The event revenue currency code reported to the SDK.
event_time
Event time
Event
String
UA: time the event happened Retargeting: will be the same as the install time
event_value
Event value
Event
DateTime
Detailed event content sent from the SDK.�Note: Don't send more than 1000 characters they may be truncated
store_reinstall
Store reinstall
Attribution
String
[List]
attributed_touch_time
Attributed touch time
Attribution
String
UA: time of the touch we attributed to. Retargeting: retargeting engagement time
attributed_touch_type
Attributed touch type
Attribution
DateTime
UA: Possible values: Click, impression, TV, pre-installed Re-engagement: click, impression (re-attribution only)
is_primary_attribution
Is primary attribution
Attribution
String
UA: True Retargeting: During a re-engagement window, we attribute to both the original media source (prior to the re-engagement) and to the re-engagement media source. While the event is within the re-engagement window. The original media source will be FALSE (not primary attribution). The re-engagement media source will be TRUE.
retargeting_conversion_type
Retargeting conversion Type
Attribution
String
UA: N/A Re-targeting:�Re-engagement, Re-attribution Pre-deprecation notice: This field will be deprecated in the future. Use conversion_type and campaign_type to determine the context of the conversion.
gp_click_time
Google Play click time
Attribution
String
Time of app page load in Google Play after an ad click. Time source: Google API Available from Android SDK version 4.8.5 Example: Compare install_time to gp_click_time. This gives an insight into how much time passes between app download, until the user opens it.
gp_install_begin
Google Play install begin time
Attribution
DateTime
Time that installation begins Time source: User device. Meaning the time that displays on the device. Available from Android SDK V4.8.5
gp_referrer
Google Play referrer
Attribution
DateTime
The referrer URL of the installed package. Available from Android SDK V4.8.5
Was this helpful?