Clickstream Data Column Reference

Table data describing the columns in the data feed.

Columns, Descriptions, and Data Types

Column name Column description Data type Example lookup
accept_language The accept language header from the browser. String (255 characters) en-us, ja;q=0.62, de
browser The browser ID (has lookup table) actually used for the hit. See pre_browser. 32-bit unsigned integer See Browser Lookup and Browser Type Lookup Key: FK
browser_height Height in pixels of browser window. 32-bit unsigned integer 806 Key: FK
browser_width Width in pixels of browser window. 32-bit unsigned integer 1280
c_color Color depth as generated from JavaScript. String (255 characters) 32
campaign The campaign value passed in on the hit. May not end up being the value that gets passed to the interface (see post_campaign). String (255 characters) [Custom]
carrier mobile carrier (requries lookup file) String (100); Media Optimizer solution variable
channel Custom traffic variable for site sections (channels). String (100 characters) [Custom]
click_action Visitor click map information. This information is what is contained in the address of the link the user clicked on (URL / JS function, etc.) String (255 characters) http://www.adobe.com
click_action_type Visitor click map information. The type of link clicked on. 8-bit unsigned integer 0
click_context Visitor click map information. This is the pagename (or URL if no pagename is declared) for the page on which the link click occurred String (255 characters) homepage
click_context_type Visitor click map information. The type of click_context (indicates whether the pagename or URL was used) 8-bit unsigned integer 0
click_sourceid Visitor click map information. This is the numeric ID for the location on the page where the link is located 32-bit unsigned integer 396
click_tag Visitor click map information. The type of link or form element that was clicked on. String (255 characters) A
code_ver The version of code in the JS file creating the image request. String (255 characters) G.7-pD-S
color Color depth ID (has lookup table) that we ended up using for the hit. See pre_color. 32-bit unsigned integer See Color Depth Lookup Key: FK
connection_type Connection type ID (has lookup table). 8-bit unsigned integer 0
cookies Specifies whether JavaScript session cookie is accepted. string (1 character) Y
country Country ID (has lookup table). 32-bit unsigned integer See Country Lookup Key: FK
ct_connect_type Connection type of the browsers computer. String (255 characters) modem
curr_factor How the currency rate is stored. 8-bit unsigned integer 2
curr_rate Current exchange rate when the transaction occurred. Decimal (24 significant digits,12 digits after the decimal point ) 1
currency Type of currency for the transaction. String (3 characters) USD
cust_hit_time_gmt (timestamp-enabled report suites only) The timestamp sent with the hit. This "timestamp" is in Unix time (number of seconds since Jan 1, 1970.) 32-bit unsigned integer 1102750716
cust_visid A visitor ID passed in with the hit to be used as the visitor ID for the hit (instead of using visid_high and visid_low) String (255 characters) UserID123ABC
daily_visitor A flag to determine if current hit is a new daily visitor. 8-bit unsigned integer 0
date_time The time in readable format in Time Zone specified by Report Suite ID. Set by Adobe servers. Adobe servers combine post_cust_hit_time_gmt and the report suite's time zone to create date_time. hit_time is in the timezone of the report suite datetime YYYY-MM-DD HH:MM:SS (this is not in Unix time.)
domain Domain of users ISP. String (255 characters) example.com
duplicate_events Lists each event that was counted as a duplicate. String (255 characters) [Custom]
duplicate_purchase A flag indicating that the purchase event for this hit should be ignored because it is a duplicate. 8-bit unsigned integer 0
duplicated_from The Report suite from which the hit was duplicated String (40 bytes) (rsid)
ef_id ef_id for Media Optimizer String (255 characters), AMO solution variable
evar1-250 Custom variable 1 - 250. String (255 characters) [Custom]
event_list Comma separated list of numeric IDs representing events passed in from the customer. String (64k characters) For event ID to name mapping, see the event.tsv file that is delivered with the data feed.
exclude_hit Hit excluded by client rule. 8-bit unsigned integer See Exclude Lookup Key: FK

Hits that have a value other than 0 for this column are not used by Analytics reports and should be ignored when calculated metrics.

Note that visit_num is not incremented for excluded hits

first_hit_page_url The original entry page URL. String (255 characters) http://www.adobe.com
first_hit_pagename The original entry page pagename. String (255 characters) homepage
first_hit_ref_domain The referring domain of the hit (based on referrer). String (255 characters) http://www.yahoo.com
first_hit_ref_type Integer representing the type of referral for the hit. Lookup values can be obtained from referrer_type.csv lookup table. 8-bit unsigned integer
first_hit_referrer Original referrer - referrer of first hit ever for the visitor. String (255 characters) http://www.yahoo.com
first_hit_time_gmt Timestamp of the first hit in GMT. 32-bit unsigned integer 1102750716
geo_city City from Digital Envoy. String (255 characters) los angeles
geo_country Country from Digital Envoy. String (255 characters) usa
geo_dma DMA from Digital Envoy. 32-bit unsigned integer [Custom]
geo_region Region / State from Digital Envoy. String (255 characters) ca
geo_zip Zip code based on IP-address lookup String (255 characters) 84103
hier1-5 Delimited list of values as passed in on the image request. The delimiter is chosen by the client during implementation. String (255 characters) [CUSTOM],[CUSTOM],[CUSTOM]
hit_source A flag for the back-end processing to know what type of hit the data is. 8-bit unsigned integer See Hit Source Lookup
hit_time_gmt Set by Adobe servers, this is the timestamp used for non-timestamped report suites. This "timestamp" is in Unix time (number of seconds since Jan 1, 1970.) 32-bit unsigned integer 1096614122
hitid_high Used to uniquely identify a hit. The combination of hitid_low and hitid_high creates a unique ID for the row. 64-bit unsigned integer
  1. 14988E+15 Key: PRI
hitid_low Used to uniquely identify a hit. The combination of hitid_low and hitid_high creates a unique ID for the row. 64-bit unsigned integer
  1. 50367E+16 Key: PRI
homepage Homepage flag, whether or not this page was the user's homepage string (1 character) N
hourly_visitor A flag to determine if current hit is a new hourly visitor. 8-bit unsigned integer 0
ip IP address of user's computer, from users ISP. String (255 characters)
  1. 112.89.14
ip2 A second IP address to be used by VISTA to determine validity of hits. String (255 characters)
j_jscript Version of JavaScript supported by browser. String (255 characters)
  1. 3
java_enabled Flag indicating whether or not java is enabled. string (1 character) Y
javascript Version of Javascript. 8-bit unsigned integer See Javascript Version Lookup Key: FK
language Language ID (has lookup table). 32-bit unsigned integer See Languages Lookup Key: FK
last_hit_time_gmt Timestamp of the previous hit in GMT 32-bit unsigned integer 1102751965
last_purchase_num The purchase number of the previous purchase. 32-bit unsigned integer 0
last_purchase_time_gmt The time of the previous purchase. 32-bit unsigned integer 0
mc_audiences Marketing Cloud audiences String (255 characters)
mcvisid Marketing Cloud Visitor ID The Marketing Cloud Visitor ID is a 128-bit number that consists of 2 signed, positive, 64-bit numbers in base 10, both padded to 19 zeros, and then concatenated. String (255 characters)
  1. 64983E+37
mobile* Mobile solution variables. See Mobile Solution Variables
mobile_id The ID of the mobile device which passed the hit into marketing reports. 32-bit unsigned integer 23
monthly_visitor A flag to determine if current hit is a new monthly visitor. 8-bit unsigned integer 0
mvvar1-3 Mvvars are multi-value fields provided to allow customers to implement custom multi-value projects. Also known as "list variables" in Adobe Marketing Reports & Analytics. String (64k characters)
namespace Not currently populated; reserved for future release. String (255 characters)
new_visit A flag that determines if the current hit is a new visit. 8-bit unsigned integer 0
os Operating system ID (has lookup table). 32-bit unsigned integer See Operating Systems Lookup Key: FK
p_plugins List of plugins available to the browser. String (64k characters)
page_event Page event ID, the type of hit that is sent in the request. Look-ups provided for type of event (normal,download, exit, custom) 8-bit unsigned integer 0 See Page Event Lookup
page_event_var1 Related to the page_event column. It is the URL of the download link, exit link or custom link clicked. String (64k characters) http://www.adobe.com
page_event_var2 If you have individually named your link, this column contains the link name. String (255 characters) homepage_buy
page_event_var3 Used for both Survey and Media module, and serves as the pre-version for both modules. (This column contains the value passed in on the hit for the page event.) String (64k characters)
page_type page type variable (only used for error page). String (255 characters) errorPage
page_url The URL of the pageview. The address of the page in the address bar of the browser. String (64k characters) http://www.adobe.com/search/search_results.htm
pagename The name of the page (if set). String (100 characters) search_results
paid_search A (1/0) flag that determines if the hit was used for paid search tracking. 8-bit unsigned integer 1
partner_plugins Not usable by customers. This is a comma-separated list of plungin_ids (usually about 5 characters each) for plugins that partners have registered with us. String (255 characters)
persistent_cookie A flag indicating if 3rd party cookies and/or persistent cookies are enabled. String (1 character) Y
plugins List of plugin IDs available to the browser (has lookup table) This is the post value. String (255 characters) See Plugins Lookup Key: FK
post_browser_height Height in pixels of the browser window. 32-bit unsigned integer 600
post_browser_width Width in pixels of the browser window. 32-bit unsigned integer 868
post_campaign Persisting value of campaign. String (255 characters) [Custom]
post_channel Custom traffic variable for site sections (channels). String (100 characters) [Custom]
post_cookies Specifies whether JavaScript session cookie is accepted. string (1 character) Y
post_currency Type of currency for the transaction. String (3 characters) USD
post_cust_hit_time_gmt Timestamp actually used for the hit, this is cust_hit_time_gmt for timestamp-enabled report suites, or hit_time_gmt otherwise. 32-bit unsigned integer 1102750716
post_cust_visid Post version of the cust_visid field. What we ended up using for the hit. 8-bit unsigned integer
post_ef_id post verion of ef_id String (255 characters); AMO solution variable
post_evar1-250 Persisting value of evar1-250. String (255 characters) [Custom]
post_event_list Comma separated list of numeric IDs representing events passed in from the customer. String (64k characters) For event ID to name mapping, see the event_lookup.tsv that is delivered with the data feed. Key: FK
post_hier1-5 Delimited list of values as passed in on the image request. The delimiter is chosen by the client during implementation. String (255 characters) [CUSTOM],[CUSTOM],[CUSTOM]
post_java_enabled Flag indicating whether or not java is enabled. string (1 character) Y
post_keywords The keywords that were actually used for the hit. String (100 characters) my keyword
post_mc_audiences Marketing Cloud audiences String (255 characters)

post_mobile*

Mobile solution variables. See Mobile Solution Variables
post_mvvar1-3 Post-processed mvvars. "What we ended up using for the hit."

Data in the post_mvvar columns will be separated by a 6-character delimiter:

--**--

The delimiter in column mvvar will be replaced in post_mvvar by

--**--
String (64k characters)
post_page_event Page event ID, the type of hit that is sent in the request. 8-bit unsigned integer 0 See Page Event Lookup
post_page_event_var1 Related to the page_event column. It is the URL of the download link, exit link or custom link clicked. String (100 characters) http://www.adobe.com
post_page_event_var2 If you have individually named your link, this column contains the link name. String (100 characters) homepage_buy
post_page_event_var3 Used for both Survey and Media module, and serves as the pre-version for both modules. (This column contains the value passed in on the hit for the page event.) String (64k characters)
post_ page_type page type variable (only used for error page). String (100 characters) errorPage
post_page_url The URL of the pageview. The address of the page in the address bar of the browser. String (255 characters) http://www.adobe.com/search/search_results.htm
post_pagename The name of the page (if set). If no page is specified the URL is placed in this value. String (100 characters) search_results
post_pagename_no_url The name of the page (if set). If no page is specified this value is left empty. String (100 characters) search_results
post_partner_plugins List of partner plugins available to the browser (has lookup table). String (100 characters)
post_persistent_cookie Flag indicating if 3rd party cookies and/or persistent cookies are enabled. string (1 character) Y
post_product_list The product list as passed in through the JavaScript. String (64k characters) Format is comma separated list of: category; product; quantity; cost; custEventsDecValues; merchandisingValues

Computers;HP Pavillion;1;1000;200|201,Office Supplies

post_prop1-75 Custom traffic variables 1 - 75. String (100 characters) [Custom]
post_purchaseid Unique identifer for a purchase. Identifies a duplicate purchase (see duplicate_purchase). String (100 characters) 1584A9646G
post_referrer Page prior to the current page. String (244 characters)
post_s_kwcid post version of s_kwcid String (255 characters); AMO solution variable
post_search_engine The numeric ID of the search engine that was actually used and stored. 32-bit unsigned integer Search Engine Lookup

post_social*

Social solution variables. See Social Solution Variables
post_state Geographical region (i.e. Arizona, Utah, Saxony [German Region]) passed in on JavaScrip. Normally only set on a purchase page. String (100 characters) AZ
post_survey Post column for the marketing reports and Survey integration. Processed based on page_event_var3. String (64k characters) 3826-0-0--**--3826-1-1--**--3826-2-0
post_t_time_info Raw time info from JavaScript. Used to determine the visitor's timezone. String (100 characters) 12/11/2004 4:23:31 1 +420
post_tnt Post column for Analytics and Target integration. String (64k characters)
post_tnt_action Post column for Analytics and Target integration. String (64k characters)
post_transactionid A unique identifier where various data points can be uploaded later via Data Sources. String (100 characters) A1B2C3D4

post_video*

Video solution variables. See Video Solution Variables
post_visid_high The visid_high value that we ended up using for the hit. 64-bit unsigned integer
post_visid_low The visid_low value that we ended up using for the hit. 64-bit unsigned integer
post_visid_type Post version of the visid_type column. What we ended up using for the hit. 8-bit unsigned integer

0=Custom VisitorID (A custom visitor ID was set in the code using s.visitorID)

1=IP&UA fallback (cookies were rejected by browser)

2=Wireless (HTTP Mobile Subscriber Header identified as mobile carrier)

3=Adobe (server generated, stored in s_vi on client) Default method.

4=Fallback cookie (new fallback ID, JavaScript generated, stored in s_fid on client, added in H25.3)

5=Visitor ID Service

See Identifying Unique Visitors.

post_zip Post version of the zip field. What we use for the hit. String (100 characters)
prev_page The page id of the previous page. This is an internal identifier and not useful to the customer. 32-bit unsigned integer 0
product_list The product list as passed in through the JavaScript. String (64k characters)

Format is comma separated list of: category; product; quantity; cost; custEventsDecValues; merchandisingValues

Computers;HP Pavillion;1;1000;200|201,Office Supplies

product_merchandising Replaced by post_product_list as of April 2011. Contains data for Merchandising evars as they relate to products.
prop1-75 Custom traffic variables 1 - 75. String (100 characters) [Custom]
purchaseid Unique identifier for a purchase. Identifies a duplicate purchase (see duplicate_purchase). String (255 characters) 1584A9646G
quarterly_visitor A flag to determine if current hit is a new quarterly visitor. 8-bit unsigned integer [Custom]
ref_domain The referring domain of the hit (based on referrer). String (255 characters)
ref_type Integer representing the type of referral for the hit. Lookup values can be obtained from referrer_type.csv lookup table. 8-bit unsigned integer
referrer Page prior to the current page. String (255 characters)
resolution Resolution id (has lookup table). 32-bit unsigned integer See Resolution Lookup Key: FK
s_kwcid s_kwcid for Media Optimizer String (255 characters); AMO solution variable
s_resolution Screen resolution as passed in from JavaScript. String (255 characters) 1024x768
sampled_hit A (Y/N) field if the hit was used (sampled) or not for ad hoc analysis. string (1 character) N
search_engine Search engine ID, has lookup table 32-bit unsigned integer See Search Engine Lookup Key: FK
search_page_num The page number of search results that the keywords were on from the search engine. 32-bit unsigned integer 1
secondary_hit Used to track secondary hits. Secondary hits are charged at a rate of 50% of the normal costs. 8-bit unsigned integer 0
service Deprecated. pe or ss - type of hit coming through. The page_event column gives the same information but in more detail. String (2 characters) ss
socialaccountandappids social account and app ids String (255 characters)
social* Social solution variables. See Social Solution Variables
sourceid Adobe proprietary column information 32-bit unsigned integer
state Geographical region (i.e. Arizona, Utah, Saxony [German Region]) passed in on JavaScript. Normally only set on a purchase page. String (255 characters) AZ
stats_server Adobe internal server that processed the hit. String (255 characters) www263.omniture.com
t_time_info Raw time information from JavaScript. Used to determine the visitor's timezone. String (255 characters) 26/11/2013 4:23:31 1 420
tnt Pre column for Analytics and Target integration. String (64k characters)
tnt_action Pre column for Analytics and Target integration. String (64k characters)
tnt_post_vista Same information as the tnt field but with any modifications made by Vista Rules, etc. String (64k characters) 52060:81:1 or

52060:81:1,13234:23:0,9132:12:1

transactionid A unique identifier where various data points can be uploaded later via Data Sources. String (255 characters) A1B2C3D4
truncated_hit A (Y/N) field that determines if the query string of the hit was truncated or not. i.e. String (1 character) N
ua_color Screen color depth. Stands for User Agent Color. From HTTP header sent by older browsers. String (255 characters)
ua_os Screen color depth. Stands for User Agent Operating System. From HTTP header sent by older browsers. String (255 characters)
ua_pixels Screen color depth. Stands for User Agent Pixels. From HTTP header sent by older browsers. String (255 characters)
user_agent User agent as found in the HTTP header sent from the browser. String (64k characters)
user_hash The hash on the report suite ID. 32-bit unsigned integer 3757249664
user_server Custom traffic variable for servers. String (255 characters) [Custom]
userid The numeric ID for the report suite ID (normally seen in the name of DW files). 32-bit unsigned integer 644614
username The report suite ID. String (255 characters) adobe
va_closer_detail Detail for last-touch value in Marketing Channels reports. String (255 characters)
va_closer_id ID for [first/last] -touch value in Marketing Channels reports. ID labels are found in the Marketing Channel Manager. 8-bit unsigned integer
va_finder_detail Detail for first-touch value in the Marketing Channels Report. String (255 characters)
va_finder_id ID for [first/last] -touch value in Marketing Channels reports. ID labels are found in the Marketing Channel Manager. 8-bit unsigned integer
va_instance_event Instance event for last-touch value in Marketing Channels reports 8-bit unsigned integer 1=A channel instance (displayed as "Click Throughs" in the reporting interface). Otherwise, the value is 0.
va_new_engagement New engagement for first-touch value in Marketing Channels reports 8-bit unsigned integer
video* Video solution variables. See Video Solution Variables
visid_high Part 1 of the visitorID. The combination of two visitor IDs (visid_high and visid_low) creates a unique visitor ID. 64-bit unsigned integer
  1. 70E+18
visid_low Part 2 of the visitorID. The combination of two visitor IDs (visid_high and visid_low) creates a unique visitor ID. 64-bit unsigned integer
  1. 21E+17
visid_new Indicates whether this is a newly-generated visitorID. Only available if visid_type=3 (Example: a new s_vi cookie was generated). string (1 character)
visid_timestamp If the visitorID was generated by us (visid_type=3), this is the timestamp for when the ID was originally created. 32-bit unsigned integer
visid_type Integer that specifies how the visitorID was calculated (based on a lookup). 8-bit unsigned integer

0=Custom VisitorID (A custom visitor ID was set in the code using s.visitorID)

1=IP&UA fallback (cookies were rejected by browser)

2=Wireless (HTTP Mobile Subscriber Header identified as mobile carrier)

3=Adobe (server generated, stored in s_vi on client) Default method.

4=Fallback cookie (new fallback ID, JavaScript generated, stored in s_fid on client, added in H25.3)

5=Visitor ID Service

See Identifying Unique Visitors.

visit_keywords Keywords used to find the site. String (255 characters) my keyword
visit_num The number of the current visit (Incremented each time a visitor returns to the site). 32-bit unsigned integer 1

Note that visit_num is not incremented for excluded hits (hits where exclude_hit column > 0).

visit_page_num The page sequence number in the current visit. 32-bit unsigned integer 17
visit_ref_domain The referring domain of the visit (based on referrer). String (255 characters)
visit_ref_type Integer representing the type of referral for the visit. Lookup values can be obtained from referrer_type.csv lookup table. 8-bit unsigned integer
visit_referrer The referrer to the visit. String (255 characters) http://www.google.com
visit_search_engine The search engine used to find the site. 32-bit unsigned integer 0
visit_start_page_url The start page for the visit. String (255 characters) http://www.adobe.com
visit_start_pagename The pagename the visit started on. String (255 characters) homepage
visit_start_time_gmt The GMT timestamp of the first pageview in this visit. 32-bit unsigned integer 1102750716
weekly_visitor A flag to determine if current hit is a new weekly visitor. 8-bit unsigned integer [Custom]
yearly_visitor A flag to determine if current hit is a new yearly visitor. 8-bit unsigned integer 0
zip Zip code (i.e. 84604,85381) passed in by JavaScript, or populated by GeoSegmentation data. String (255 characters) 84604

Events Lookup for Solution Variables

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

This applies to columns in the following sections:

App Store Solution Variables

Variable/Event Description Type Events Lookup
AppStore Downloads

The number of mobile application downloads.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

AppStore Purchases

The number of in app purchases.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

AppStore Rank

Used to calculate the average app ranking. This calculated metric is defined using the following formula:

[AppStore Rank] / [AppStore Rank (divisor)]

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

AppStore Rank Divisor

Used to calculate the average app ranking. This calculated metric is defined using the following formula:

[AppStore Rank] / [AppStore Rank (divisor)]

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

AppStore In-App Revenue

The amount of in app revenue.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

AppStore One-off Revenue

The amount of revenue associated with the purchase of an app.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

AppStore In-App Royalties

The amount of in app revenue minus amount retained by app store.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

AppStore One-off Royalties

The amount of one off revenue minus amount retained by app store.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

AppStore Rating

Used to calculate the average app ranking. This calculated metric is defined using the following formula:

[AppStore Rating] / [AppStore Rating (divisor)]

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

AppStore Rating Divisor

Used to calculate the average app ranking. This calculated metric is defined using the following formula:

[AppStore Rating] / [AppStore Rating (divisor)]

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

Mobile Solution Variables

Note that pre* and post* versions of these variables are available. The post versions are prepended with "post_".

Variable/Event Description Type Events Lookup
mobileaction Populated from the a.action context data automatically passed in when trackAction is called in the SDK. Allows for automatic action pathing in the app. string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobileactioninapptime Action Time In App

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobileactiontotaltime Action Time Total

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobileappid

App Id. Stores the Application name and version in the following format:

[AppName] [BundleVersion]

For example, myapp 1.1

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilecampaigncontent Mobile Campaign Content

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilecampaignmedium Mobile Campaign Medium

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilecampaignname Mobile Campaign Name

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilecampaignsource Mobile Campaign Source

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilecampaignterm Mobile Campaign Term

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilecrashes Crashes. Triggered when the application does not exit gracefully. Event is sent on application start after crash (the application is considered to crash if quit is not called).

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobiledayofweek

Day of Week. Number of the week day the app was launched.

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobiledayssincefirstuse

Days Since First Use. Number of days since first run.

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobiledayssincelastuse

Days Since Last Use. Number of days since last use.

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobiledevice

Device Name. Stores the device name.

On iOS, this is a comma-separated 2 digit string that Identifies the iOS device. The first number typically represents the device generation, and the second number typically versions different members of the device family.

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilehourofday

Hour of Day. Measures the hour the app was launched. 24 hour numerical format. Used for time parting to determine peak usage times.

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobileinstalldate First Launch Date. Date of first launch after installation. MM/DD/YYYY

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobileinstalls First Launches. Triggered on first run after installation (or re-installation).

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilelaunches Launches. Triggered on any run that is not an install or an upgrade. This also triggers when the application is brought out of the background.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilelaunchnumber

Launch Number. Number of times the application was launched or brought out of the background.

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilemessageid Mobile message id

String (255 characters); Mobile solution variable

mobilemessageonline mobile message online

String (255 characters); Mobile solution variable

mobileosversion Operating System Version.

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobileprevsessionlength Previous Session Length. Aggregated total Previous Session Length.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobilepushoptin Indicates whether or not a user has opted in for push messaging boolean

Example:

1

mobilepushpayloadid Identifier for a push message that has been clicked-through by the user

String

Example:

"83659238-7428-0174-7538-056718462846"

mobileresolution

Resolution. Width x Height in actual pixels.

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobileltv Lifetime Value (evar)

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobileltvtotal Lifetime Value (event)

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

mobileupgrades Upgrades. Triggered on first run after upgrade (anytime the version number changes).

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

pointofinterest Point of Interest Name

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

pointofinterestdistance Distance to Point of Interest Center

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

post_mobileaction

post version of mobileaction String

post_mobileappid

post version of mobileappid String

post_mobilecampaigncontent

post version of mobilecampaigncontent String

post_mobilecampaignmedium

post version of mobilecampaignmedium String

post_mobilecampaignname

post version of mobilecampaignname String

post_mobilecampaignsource

post version of mobilecampaignsource String

post_mobilecampaignterm

post version of mobilecampaignterm String

post_mobiledayofweek

post version of mobiledayofweek String

post_mobiledevice

post version of mobiledevice String

post_mobiledayssincelastuse

post version of mobiledayssincelastuse String

post_mobiledayssincefirstuse

post version of mobiledayssincefirstuse String

post_mobilehourofday

post version of mobilehourofday String

post_mobileinstalldate

post version of mobileinstalldate String

post_mobilelaunchnumber

post version of mobilelaunchnumber String

post_mobilemessageid

post version of mobilemessageid String (255 characters); Mobile solution variable

post_mobilemessageonline

post version of mobilemessageonline String (255 characters); Mobile solution variable

post_mobileosversion

post version of mobileosversion String
post_mobilepushoptin post version of mobilepushoptin boolean
post_mobilepushpayloadid post version of mobilepushpayloadid String

post_mobileresolution

post version of mobileresolution String

post_mobileltv

post version of mobileltv String
pointofinterest post version of pointofinterest

string (255 characters)

pointofinterestdistance post version of pointofinterestdistance

string (255 characters)

Social Solution Variables

Note that pre* and post* versions of these variables are available. The post versions are prepended with "post_".

Variable/Event Description Type Events Lookup
socialassettrackingcode Social Campaign Variable 255

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialauthor Authors.

text

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialaveragesentiment Not in use.
socialcontentprovider Social Platforms / Properties.

text

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialfbstories Facebook Interactions.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialfbstorytellers People Talking About This.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialinteractioncount

social interaction count String (255 characters)

socialinteractiontype

social interaction type String (255 characters)
sociallanguage Language.

text

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

sociallatlong Latitude / Longitude.

text

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

sociallikeadds Like Adds.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

sociallink Not in use.

socialmentions Mention.

text

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialowneddefinitioninsighttype

social owned definition insight type String (255 characters)

socialowneddefinitioninsightvalue

social owned definition insight value String (255 characters)

socialowneddefinitionmetric

social owned definition metric String (255 characters)

socialowneddefinitionpropertyvspost

social owned definition property vs post String (255 characters)

socialownedpostids

social owned post IDs String (255 characters)

socialownedpropertyid

social owned property id String (255 characters)

socialownedpropertyname

social owned property name String (255 characters)

socialownedpropertypropertyvsapp

String (255 characters)
socialpageviews Social Property Views.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialpostviews Post Views.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialproperty Not in use.

socialpubcomments Comments.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialpubposts Posts.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialpubrecommends Recommends.

String (255 characters)

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialpubsubscribers Followers.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialterm Social Listening Query, hashed value

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

socialtermslist Not in use.
socialtotalsentiment Sentiment.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

post_socialaccountandappids

post version of socialaccountandappids String (255 characters)

post_socialassettrackingcode

String (255 characters)

post_socialauthor

String (255 characters)

post_socialcontentprovider

String (255 characters)

post_socialfbstories

String (255 characters)

post_socialfbstorytellers

String (255 characters)

post_socialinteractioncount

post version of socialinteractioncount String (255 characters)

post_socialinteractiontype

post version of socialinteractiontype String (255 characters)

post_sociallanguage

String (255 characters)

post_sociallatlong

String (255 characters)

post_sociallikeadds

String (255 characters)

post_socialmentions

String (255 characters)

post_socialowneddefinitioninsighttype

post version of socialowneddefinitioninsighttype String (255 characters)

post_socialowneddefinitioninsightvalue

post version of socialowneddefinitioninsightvalue String (255 characters)

post_socialowneddefinitionmetric

post version of socialowneddefinitionmetric String (255 characters)

post_socialowneddefinitionpropertyvspost

post version of socialowneddefinitionpropertyvspost String (255 characters)

post_socialownedpostids

post version of socialownedpostids String (255 characters)

post_socialownedpropertyid

post version of socialownedpropertyid String (255 characters)

post_socialownedpropertyname

post version of socialownedpropertyname String (255 characters)

post_socialownedpropertypropertyvsapp

post version of socialownedpropertypropertyvsapp String (255 characters)

post_socialpageviews

post version of socialpageviews String (255 characters)

post_socialpostviews

post version of socialpostviews String (255 characters)

post_socialpubcomments

post version of socialpubcomments String (255 characters)

post_socialpubposts

post version of socialpubposts String (255 characters)

post_socialpubrecommends

post version of socialpubrecommends String (255 characters)

post_socialpubsubscribers

post version of socialpubsubscribers String (255 characters)

post_socialterm

post version of socialterm String (255 characters)

post_socialtotalsentiment

post version of socialtotalsentiment String (255 characters)

Video Solution Variables

Note that pre* and post* versions of these variables are available. The post versions are prepended with "post_".

Variable/Event Description Type Events Lookup
video Video name

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videoad Ad name

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videoadcomplete Ad Completes. Indicates that a user has viewed a complete video or ad.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videoadinpod Ad in Pod position

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videoadplayername Ad Player Name

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videoadpod Ad Pod

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videoadstart Ad Views. Indicates that a visitor has viewed some portion of an ad. However, it does not provide any information about how much, or what part, of a video the visitor viewed.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videoadtime Ad Time Viewed. Total time spent viewing the ad.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videochannel Channel

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videochapter Chapter name

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videocomplete Video Completes. Indicates that a user has viewed a complete video or ad.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videocontenttype Content Type. Content type is set to "Video" automatically for all video views.

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videopath String (100 Bytes)
videoplayername Player Name

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videoqoebitrateaverageevar Video quality evar
videoqoebitratechangecountevar Video quality evar
videoqoebuffercountevar Video quality evar
videoqoebuffertimeevar Video quality evar
videoqoedroppedframecountevar Video quality evar
videoqoeerrorcountevar Video quality evar
videoqoetimetostartevar Video quality evar
videosegment Segment

string (255 characters)

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videosegmentviews Video Segment Views. Sent on all close events, which occur on video complete or when the users stops viewing at some point before the complete occurs.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videostart Video Views. Indicates that a visitor has viewed some portion of a video. However, it does not provide any information about how much, or what part, of a video the visitor viewed.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

videotime Video Time Viewed. Total time spent viewing the video.

Contained in event_list

Solution variable events appear as numeric codes in the event_list and post_event_list, and are custom to each report suite. You must use the event_lookup.tsv file that is delivered with each data feed to decode the event numbers in the post_event_list.

post_video post version of video string (255 characters)
post_videoad post version of videoad string (255 characters)
post_videoadinpod post version of videoadinpod string (255 characters)
post_videoadlength post version of videoadlength string (255 characters)
post_videoadname post version of videoadname string (255 characters)
post_videoadplayername post version of videoadplayername string (255 characters)
post_videoadpod post version of videoadpod string (255 characters)
post_videochannel post version of videochannel string (255 characters)
post_videochapter post version of videochapter string (255 characters)
post_videocontenttype post version of videocontenttype string (255 characters)
post_videolength post version of videolength string (255 characters)
post_videoname post version of videoname string (255 characters)
post_videopath post version of videopath string (255 characters)
post_videoplayername post version of videoplayername string (255 characters)
post_videoqoebitrateaverageevar post version of videoqoebitrateaverageevar string (255 characters)
post_videoqoebitratechangecountevar post version of videoqoebitratechangecountevar string (255 characters)
post_videoqoebuffercountevar post version of videoqoebuffercountevar string (255 characters)
post_videoqoebuffertimeevar post version of videoqoebuffertimeevar string (255 characters)
post_videoqoedroppedframecountevar post version of videoqoedroppedframecountevar string (255 characters)
post_videoqoeerrorcountevar post version of videoqoeerrorcountevar string (255 characters)
post_videoqoetimetostartevar post version of videoqoetimetostartevar string (255 characters)
post_videosegment post version of videosegment string (255 characters)