> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/appsflyer/appsflyer-supported-columns.md). # 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](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/appsflyer.md) page. Which of these arrive depends on the export URL the connector reads, since AppsFlyer builds the report from that URL. ## Dimensions | Column | Name | Group | Type | Description | | --------------------------------------------------------------- | ------------------------------ | --------------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `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 | Column | Name | Group | Type | Description | | --------------- | ------------- | ----------- | ------- | -------------------------------------------------------------------------------------- | | `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 | Column | Name | Group | Type | Description | | ----------------------------- | ------------------------------ | ----------- | -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | `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:flag\_mm: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 |