Data column reference

Use this page to learn what data is contained in each column. Most implementations don’t use every column, so this page can be referenced when determining which columns to include in a data feed export.

IMPORTANT
For any given column (for instance, one that is defined as 255 characters), a data feed can send additional characters due to the addition of characters escaping values in a string. Keep these potential extra characters in mind if your implementation regularly sends values that exceed character limits.

Columns, Descriptions, and Data Types

NOTE
Most columns contain a similar column with a prefix of post_. Post columns contain values after server-side logic, processing rules, and VISTA rules. Adobe recommends using post columns in most cases. See Data feeds FAQ for more information.

Previous updates to this table can be found on this page’s commit history on GitHub.

Post
Column name
Column description
Data type
accept_language
Lists all accepted languages, as indicated in the Accept-Language HTTP header in an image request.
char(20)
post_
adload
Media ad loads
varchar(255)
post_
aemassetid
A multi-value variable corresponding to Asset IDs (GUIDs) of a set of Adobe Experience Manager Assets. Increments Impression Events.
text
post_
aemassetsource
Identifies the source of the asset event. Used in Adobe Experience Manager.
varchar(255)
post_
aemclickedassetid
Asset ID of an Adobe Experience Manager asset. Increments Click Events.
varchar(255)
post_
amo_cid
The AMO ID dimension, used in Adobe Advertising integrations.
varchar(255)
post_
amo_ef_id
The AMO EF ID dimension, used in Adobe Advertising integrations.
varchar(255)
browser
A numeric ID that represents the browser. References the browser.tsv lookup table.
int unsigned
post_
browser_height
The Browser Height dimension.
smallint unsigned
post_
browser_width
The Browser Width
smallint unsigned
post_
campaign
The Tracking Code dimension.
varchar(255)
carrier
Adobe Advertising integration variable. Specifies the mobile carrier. The key value for carrier.tsv Dynamic lookup.
varchar(100)
post_
channel
The Site sections dimension.
varchar(100)
ch_hdr
Client hints collected through the HTTP request header.
text
ch_js
Client hints collected through the User-Agent Client Hints JavaScript API.
text
post_
clickmaplink
The Activity Map link dimension.
varchar(255)
post_
clickmaplinkbyregion
The Activity Map link by region dimension.
varchar(255)
post_
clickmappage
The Activity Map page dimension.
varchar(255)
post_
clickmapregion
The Activity Map region dimension.
varchar(255)
code_ver
API or client SDK version used to compile and send the image request.
char(16)
color
Color depth ID based on the value of the c_color column. References the color_depth.tsv lookup table.
smallint unsigned
connection_type
Numeric ID representing the Connection type dimension. References the connection_type.tsv lookup table.
tinyint unsigned
post_
cookies
The Cookie support dimension.
Y: Enabled
N: Disabled
U: Unknown
char(1)
country
A numeric ID that represents the country of the visitor. References the country.tsv lookup table.
smallint unsigned
post_
currency
The currency code that was used during the transaction. Set using currencyCode.
char(8)
ct_connect_type
Related to the connection_type column. The most common values are LAN/Wifi, Mobile Carrier, and Modem.
char(20)
curr_factor
Determines the currency decimal place. Used for currency conversion. For example, USD uses two decimal places, so this column value would be 2.
tinyint
curr_rate
The exchange rate when the transaction occurred. Adobe partners with XE to determine the current day’s exchange rate.
decimal(24,12)
post_
customer_perspective
Determines if the hit is a mobile background hit. See Context-aware sessions for more information.
tinyint unsigned
post_
cust_hit_time_gmt
Timestamp-enabled report suites only. The timestamp sent with the hit, based in UNIX® time.
int
post_
cust_visid
The custom visitor ID, if set using visitorID.
varchar(255)
c_color
Bit depth of the color palette. Used as part of calculating the Color depth dimension. AppMeasurement uses the JavaScript function screen.colorDepth().
char(20)
daily_visitor
A flag that determines if the hit is a new daily visitor.
tinyint unsigned
dataprivacyconsentoptin
The Consent management opt-in dimension. Multiple values can be present per hit, separated by a pipe (|). Valid values include DMP and SELL.
varchar(100)
dataprivacyconsentoptout
The Consent management opt-out dimension. Multiple values can be present per hit, separated by a pipe (|). Valid values include SSF, DMP, and SELL.
varchar(100)
date_time
The time of the hit in readable format, based on the report suite’s time zone.
datetime
domain
The Domain dimension. Based on the visitor’s Internet access point.
varchar(100)
duplicated_from
Only used in report suites containing hit copy VISTA rules. Indicates which report suite that the hit was copied from.
varchar(40)
duplicate_events
Lists each event that was counted as a duplicate.
varchar(255)
duplicate_purchase
A flag that determines if the purchase event for this hit is ignored because it is a duplicate.
tinyint unsigned
post_
ef_id
The EF ID, used in Adobe Advertising integrations.
varchar(255)
post_
evar1 - evar250
Custom variables 1-250. Used in eVar dimensions. Each organization uses eVars differently. The best place for more information on how your organization populates respective eVars would be a solution design document specific to your organization.
varchar(255)
post_
event_list
Comma-separated list of numeric IDs that represent events triggered on the hit. Includes both commerce events and custom events 1-1000. Uses event.tsv lookup.
text
exclude_hit
A flag that determines if the hit is excluded from reporting. The visit_num column is not incremented for excluded hits.
1: Not used. Part of a scrapped feature.
2: Not used. Part of a scrapped feature.
3: No longer used. User agent exclusion
4: Exclusion based on IP address
5: Vital hit info missing, such as page_url, pagename, page_event, or event_list
6: JavaScript did not correctly process hit
7: Account-specific exclusion, such as in a VISTA rules
8: Not used. Alternate account-specific exclusion.
9: Not used. Part of a scrapped feature.
10: Invalid currency code
11: Hit missing a timestamp on a timestamp-only report suite, or a hit contained a timestamp on a non-timestamp report suite
12: Not used. Part of a scrapped feature.
13: Not used. Part of a scrapped feature.
14: Target hit that did not match up with an Analytics hit
15: Not currently used.
16: Advertising Cloud hit that did not match up to an Analytics hit
tinyint unsigned
first_hit_pagename
The Entry page original dimension. The original entry page name of the visitor.
varchar(100)
first_hit_page_url
The very first URL of the visitor.
varchar(255)
first_hit_referrer
The very first referring URL of the visitor.
varchar(255)
first_hit_ref_domain
The Original referring domain dimension. Based on first_hit_referrer. The very first referring domain of the visitor.
varchar(100)
first_hit_ref_type
A numeric ID that represents the referrer type of the very first referrer of the visitor. References the referrer_type.tsv lookup table.
tinyint unsigned
first_hit_time_gmt
Timestamp of the very first hit of the visitor in UNIX® time.
int
geo_city
The name of the city that the hit came from, based on IP. Used in the Cities dimension.
char(32)
geo_country
The abbreviation of the country that the hit came from, based on IP. Used in the Countries dimension.
char(4)
geo_dma
A numeric ID of the demographic area that the hit came from, based on IP. Used in the US DMA dimension.
int unsigned
geo_region
The name of the state or region that the hit came from, based on IP. Used in the Regions dimension.
char(32)
geo_zip
The zip code that the hit came from, based on IP. Helps populate the Zip code dimension. See also zip.
varchar(16)
hitid_high
Used with hitid_low to identify a hit.
bigint unsigned
hitid_low
Used with hitid_high to identify a hit.
bigint unsigned
hit_source
The source that the hit came from. Hit sources 1 and 2 are billed.
1: Standard image request without timestamp
2: Standard image request with timestamp
3: Live data source upload with timestamps
4: Not used
5: Generic data source upload
6: No longer used; full processing data source upload
7: TransactionID data source upload
8: No longer used; Previous versions of Adobe Advertising data sources
9: No longer used; Adobe Social summary metrics
10: Audience Manager server-side forwarding used
tinyint unsigned
hit_time_gmt
The timestamp of the hit Adobe data collection servers received the hit, based in UNIX® time.
int
hourly_visitor
A flag that determines if the hit is a new hourly visitor.
tinyint unsigned
ip
The IPv4 address, based on the HTTP header of the image request. Mutually exclusive to ipv6; if this column contains a non-obfuscated IP address, ipv6 is blank.
char(20)
ipv6
The compressed IPv6 address, if available. Mutually exclusive to ip; if this column contains a non-obfuscated IP address, ip is blank.
varchar(40)
javascript
A lookup ID of JavaScript version, based on j_jscript. References the javascript_version lookup table.
tinyint unsigned
post_
java_enabled
The Java enabled.
Y: Enabled
N: Disabled
U: Unknown
char(1)
j_jscript
Version of JavaScript supported by the browser.
char(5)
language
A numeric ID that represents the visitor’s language. References the languages.tsv lookup table.
smallint unsigned
last_hit_time_gmt
Timestamp (in UNIX® time) of the prior hit. Used to calculate the Days since last visit dimension.
int
last_purchase_num
The Customer loyalty dimension. The number of previous purchases the visitor has made.
0: No prior purchases (not a customer)
1: 1 prior purchase (new customer)
2: 2 prior purchases (return customer)
3: 3 or more prior purchases (loyal customer)
int unsigned
last_purchase_time_gmt
Used in the Days since last purchase dimension. Timestamp (in UNIX® time) of the last purchase made. For first-time purchases and visitors that have not made a purchase before, this value is 0.
int
latlon1
Location (down to 10 km)
varchar(255)
latlon23
Location (down to 100 m)
varchar(255)
latlon45
Location (down to 1 m)
varchar(255)
mcvisid
Experience Cloud Visitor ID. 128-bit number consisting of two concatenated 64-bit numbers padded to 19 digits.
varchar(255)
post_
mc_audiences
List of Audience Manager segment IDs that the visitor belongs to. The post_mc_audiences column changes the delimiter to --**--.
text
post_
mobileaction
Mobile action. Automatically collected when trackAction is called in mobile implementations. Allows for automatic action pathing in the app.
varchar(100)
post_
mobileappid
Mobile app ID. Stores the application name and version in the following format: [AppName] [BundleVersion]
varchar(255)
mobileappperformanceappid
Used in the Apteligent data connector. The App ID used in Apteligent.
varchar(255)
mobileappperformancecrashid
Used in the Apteligent data connector. The crash ID used in Apteligent.
varchar(255)
mobileappstoreobjectid
Used in the Appfigures data connector. App store object ID.
varchar(255)
mobilebeaconmajor
Mobile Services beacon major
varchar(100)
mobilebeaconminor
Mobile Services beacon minor
varchar(100)
mobilebeaconproximity
Mobile Services beacon proximity
varchar(255)
mobilebeaconuuid
Mobile Services beacon UUID
varchar(100)
post_
mobilecampaigncontent
The name or ID of the content that displayed the link. Populated by Mobile App Acquisition.
varchar(255)
post_
mobilecampaignmedium
Marketing medium, such as banner or email. Populated by Mobile App Acquisition.
varchar(255)
post_
mobilecampaignname
The name of the campaign, also stored in the campaign variable. Populated by Mobile App Acquisition.
varchar(255)
post_
mobilecampaignsource
Original referrer, such as newsletter or social media network. Populated by Mobile App Acquisition.
varchar(255)
post_
mobilecampaignterm
Paid keywords or other terms you want to track with this acquisition. Populated by Mobile App Acquisition.
varchar(255)
post_
mobiledayofweek
Number of the weekday that the app was launched on.
varchar(255)
post_
mobiledayssincefirstuse
Number of days since the app was run for the first time.
varchar(255)
post_
mobiledayssincelastuse
Number of days since the app was last run.
varchar(255)
mobiledeeplinkid
Collected from the context data variable a.deeplink.id. Used in acquisition reports as an identifier for mobile acquisition link.
varchar(255)
post_
mobiledevice
Mobile device name. On iOS, it is stored as a comma-separated 2-digit string. The first number represents the device generation, and the second number represents the device family.
varchar(255)
post_
mobilehourofday
Defines the hour of the day that the app was launched. Follows 24-hour numerical format.
varchar(255)
post_
mobileinstalldate
Mobile install date. Provides the date of the first time that a user opens the mobile app.
varchar(255)
post_
mobilelaunchnumber
Increments by one each time the mobile app is launched.
varchar(255)
post_
mobilemessagebuttonname
Collected from the context data variable a.message.button.id. Used for in-app messaging to identify the button that closed the message.
varchar(100)
post_
mobilemessageid
In-app Message ID
varchar(255)
post_
mobilemessageonline
In-app Message Online
varchar(255)
post_
mobilemessagepushoptin
Collected from the context data variable a.push.optin. Set to “true” when the user opts in to push messaging; otherwise the value is “false”.
varchar(255)
post_
mobilemessagepushpayloadid
Collected from the context data variable a.push.payloadid. Used in push messaging as the payload identifier.
varchar(255)
post_
mobileosversion
Mobile Services operating system version
varchar(255)
mobileplaceaccuracy
Collected from the context data variable a.loc.acc. Indicates the accuracy of the GPS in meters at time of collection.
varchar(255)
mobileplacecategory
Collected from the context data variable a.loc.category. Describes the category of a specific place.
varchar(255)
mobileplaceid
Collected from the context data variable a.loc.id. Identifier for a given point of interest.
varchar(255)
post_
mobilepushoptin
Mobile Services Push opt-in
varchar(255)
post_
mobilepushpayloadid
Mobile Services Push payload ID
varchar(255)
mobilerelaunchcampaigncontent
Mobile Services launch content
varchar(255)
mobilerelaunchcampaignmedium
Mobile Services launch medium
varchar(255)
mobilerelaunchcampaignsource
Mobile Services launch source
varchar(255)
mobilerelaunchcampaignterm
Mobile Services launch term
varchar(255)
mobilerelaunchcampaigntrackingcode
Collected from the context data variable a.launch.campaign.trackingcode. Used in acquisition as the tracking code for launch campaign.
varchar(255)
post_
mobileresolution
Resolution of the mobile device. [Width] x [Height] in pixels.
varchar(255)
mobile_id
If the user is using a mobile device, the numeric ID of the device. The key value for mobile_attributes.tsv Dynamic lookup.
int
monthly_visitor
A flag that determines if the visitor is unique to the current month.
tinyint unsigned
post_
mvvar1 - mvvar3
List variable values. Contains a delimited list of custom values depending on implementation. The post_mvvar1 - post_mvvar3 columns replace the original delimiter with --**--.
text
post_
mvvar1_instances - mvvar3_instances
The list variable values that were set on the current hit. Replaces the original delimiter with --**--. The post columns typically do not contain data.
text
new_visit
A flag that determines if the current hit is a new visit. Set by Adobe after 30 minutes of visit inactivity.
tinyint unsigned
os
A numeric ID that represents the operating system of the visitor. Based on the user_agent column. The key value for operating_system.tsv standard lookup and operating_system_type.tsv Dynamic lookup.
int unsigned
post_
pagename
The Page dimension. If the pagename variable is empty, Analytics uses page_url instead.
varchar(100)
post_
pagename_no_url
Similar to pagename, except it does not fall back to page_url. Only the post column is available.
varchar(100)
post_
page_event
The type of hit that is sent in the image request (standard hit, download link, custom link, exit link). See Page event lookup.
tinyint unsigned
post_
page_event_var1
Only used in link tracking image requests. The URL of the download link, exit link, or custom link clicked.
text
post_
page_event_var2
Only used in link tracking image requests. The custom name (if specified) of the link. Sets the Custom link, Download link, or Exit link depending on the value in page_event.
varchar(100)
post_
page_type
The Pages not found dimension, which is typically used for 404 pages.
char(20)
post_
page_url
page_url: The URL of the hit. Uses a data type of text.
post_page_url: Stripped for link tracking image requests (tl()). Uses a data type of varchar(255).
text
varchar(255)
paid_search
A flag that determines if the hit matches paid search detection.
tinyint unsigned
post_
persistent_cookie
Used in the Persistent cookie support dimension. Indicates if the visitor supports cookies that are not discarded after each hit.
char(1)
post_
pointofinterest
Mobile Services point of interest name
varchar(255)
post_
pointofinterestdistance
Mobile Services distance to point of interest center
varchar(255)
post_
product_list
The products page variable. Helps populate several dimensions and metrics, including Category, Product, Units, and Revenue.
text
post_
prop1 - prop75
Custom traffic variables 1-75. Used in Prop dimensions.
varchar(100)
post_
purchaseid
Unique identifier for a purchase, as set using the purchaseID variable. Used by the duplicate_purchase column.
char(20)
quarterly_visitor
A flag that determines if the hit is a new quarterly visitor.
tinyint unsigned
post_
referrer
The Referrer dimension. Note that while referrer uses a data type of varchar(255), post_referrer uses a data type of varchar(244).
varchar(255)
varchar(244)
ref_domain
The Referring domain dimension. Based on the referrer column.
varchar(100)
ref_type
A numeric ID that represents the type of referral for the hit. Used in the Referrer type dimension.
1: Inside your site
2: Other web sites
3: Search engines
4: Hard drive
5: USENET
6: Typed/Bookmarked (no referrer)
7: Email
8: No JavaScript
9: Social Networks
10: Conversational AI tools
tinyint unsigned
resolution
A numeric ID that represents the resolution of the monitor. Used in the Monitor resolution dimension. Uses resolution.tsv lookup table.
smallint unsigned
post_
search_engine
A numeric ID that represents the search engine that referred the visitor to your site. Used in Search Engine dimensions. References the search_engines.tsv lookup table.
smallint unsigned
search_page_num
Used by the All Search Page Rank dimension. Indicates which page of search results that your site appeared on before the user clicked through to your site.
smallint unsigned
secondary_hit
A flag that determines if the hit is a secondary hit. This flag typically originates from multi-suite tagging and VISTA rules that copy hits.
tinyint unsigned
sourceid
Source ID
int unsigned
stats_server
Not of use. Adobe internal server that processed the hit.
char(30)
post_
s_kwcid
Keyword ID used in Adobe Advertising integrations.
varchar(255)
s_resolution
Raw screen resolution value. Gathered using the JavaScript function screen.width x screen.height.
char(20)
post_
tnt
Used in Adobe Target integrations. Represents all tests currently qualified for. Format is: TargetCampaignID:TargetRecipeID:TargetType|Event/Action.
text
post_
tnt_action
Used in Adobe Target integrations. Represents all tests the hit qualified for.
text
tnt_instances
Used in Adobe Target integrations. Target instances variable.
text
post_
transactionid
A unique identifier where various data points can be uploaded later through data sources. Collected using the transactionID variable.
text
truncated_hit
A flag indicating that the image request was truncated (a partial hit was received).
Y: Hit was truncated; partial hit received
N: Hit was not truncated; full hit received
char(1)
post_
t_time_info
Local time for the visitor. Format is: M/D/YYYY HH:MM:SS Month (0-11, 0=January) Timezone offset (in minutes)
varchar(100)
userid
Not of use. The numeric ID for the report suite ID. Use username instead.
int unsigned
username
The report suite ID for the hit.
char(40)
user_agent
The user agent string sent in the HTTP header of the image request.
text
user_hash
Not of use. Hash on the report suite ID. Use username instead.
int unsigned
post_
user_server
Used in the Server dimension.
varchar(100)
va_closer_detail
The Last touch detail dimension.
varchar(255)
va_closer_id
A numeric ID that identifies the Last touch channel dimension. The lookup for this ID can be found in the Marketing Channel Manager.
tinyint unsigned
va_finder_detail
The First touch detail dimension.
varchar(255)
va_finder_id
A numeric ID that identifies the First touch channel dimension. The lookup for this ID can be found in the Marketing Channel Manager.
tinyint unsigned
va_instance_event
A flag that identifies Marketing Channel Instances.
tinyint unsigned
va_new_engagement
A flag that identifies Marketing Channel New engagements.
tinyint unsigned
post_
video
The Content streaming media services dimension.
varchar(255)
post_
videoad
The Ad streaming media services dimension.
varchar(255)
post_
videoadinpod
The Ad in pod position streaming media services dimension.
varchar(255)
post_
videoadlength
The Ad length (variable) streaming media services dimension.
integer
post_
videoadname
The Ad name (variable) streaming media services dimension.
varchar(255)
post_
videoadplayername
The Ad player name streaming media services dimension.
varchar(255)
post_
videoadpod
The Ad pod streaming media services dimension.
varchar(255)
post_
videoadvertiser
The Advertiser streaming media services dimension.
varchar(255)
videoaudioalbum
The Album streaming media services dimension.
varchar(255)
videoaudioartist
The Artist streaming media services dimension.
varchar(255)
videoaudioauthor
The Author streaming media services dimension.
varchar(255)
videoaudiolabel
The Label streaming media services dimension.
varchar(255)
videoaudiopublisher
The Publisher streaming media services dimension.
varchar(255)
videoaudiostation
The Station streaming media services dimension.
varchar(255)
post_
videocampaign
The Campaign ID streaming media services dimension.
varchar(255)
post_
videochannel
The Content channel streaming media services dimension.
varchar(255)
post_
videochapter
The Chapter streaming media services dimension.
varchar(255)
post_
videocontenttype
The Content type streaming media services dimension.
varchar(255)
post_
videodaypart
The Day part streaming media services dimension.
varchar(255)
post_
videoepisode
The Episode streaming media services dimension.
varchar(255)
post_
videofeedtype
The Media feed type streaming media services dimension.
varchar(255)
post_
videogenre
The Genre streaming media services dimension. This dimension allows multiple values in the same hit, delimited by a comma.
text
post_
videolength
The Content length (variable) streaming media services dimension.
integer
post_
videomvpd
The MVPD streaming media services dimension.
varchar(255)
post_
videoname
The Content name (variable) streaming media services dimension.
varchar(255)
post_
videonetwork
The Network streaming media services dimension.
varchar(255)
post_
videopath
The Media path streaming media services dimension.
varchar(100)
post_
videoplayername
The Content player name streaming media services dimension.
varchar(255)
post_
videoqoebitrateaverageevar
The Average bitrate streaming media services dimension.
varchar(255)
post_
videoqoebitratechangecountevar
The Bitrate changes streaming media services dimension.
varchar(255)
post_
videoqoebuffercountevar
The Buffer events streaming media services dimension.
varchar(255)
post_
videoqoebuffertimeevar
The Total buffer duration streaming media services dimension.
varchar(255)
post_
videoqoedroppedframecountevar
The Dropped frames streaming media services dimension.
varchar(255)
post_
videoqoeerrorcountevar
The Errors streaming media services dimension.
varchar(255)
videoqoeextneralerrors
The External error IDs streaming media services dimension. This dimension allows multiple values in the same hit.
text
post_
videoqoeplayersdkerrors
The Player SDK error IDs streaming media services dimension. This dimension allows multiple values in the same hit.
text
post_
videoqoetimetostartevar
The Time to start streaming media services dimension.
varchar(255)
post_
videoseason
The Season streaming media services dimension.
varchar(255)
post_
videosegment
The Content segment streaming media services dimension.
varchar(255)
post_
videosessionid
The Media session ID streaming media services dimension.
varchar(255)
post_
videoshow
The Show streaming media services dimension.
varchar(255)
post_
videoshowtype
The Show type streaming media services dimension.
varchar(255)
videostreamtype
The Stream type streaming media services dimension.
varchar(255)
post_
visid_high
Used with visid_low to uniquely identify a visitor.
bigint unsigned
post_
visid_low
Used with visid_high to uniquely identify a visitor.
bigint unsigned
visid_new
A flag that determines if the hit contains a newly generated visitor ID.
char(1)
visid_timestamp
If a visitor ID is newly generated, provides the timestamp in UNIX® time of when the visitor ID was generated.
int
post_
visid_type
Not for external use; internally used by Adobe for processing optimizations. A numeric ID that represents the method used to identify the visitor.
0: Custom visitor ID or Unknown/not applicable
1: IP and user agent fallback
2: HTTP Mobile Subscriber Header
3: Legacy cookie value (s_vi)
4: Fallback cookie value (s_fid)
5: Identity Service
tinyint unsigned
post_
visit_keywords
The Search keyword dimension. This column uses a non-standard character limit of varchar(244) to accommodate back-end logic used by Adobe. The post-processed column is **post_keywords**, not **post_visit_keywords**.
varchar(244)
visit_num
The Visit number dimension. Starts at 1, and increments each time a new visit starts per visitor.
int unsigned
visit_page_num
The Hit depth dimension. Increases by 1 for each hit that the visitor generates. Resets each visit.
int unsigned
visit_referrer
The first referrer of the visit.
varchar(255)
visit_ref_domain
Based on the visit_referrer column. The first referring domain of the visit.
varchar(100)
visit_ref_type
A numeric ID that represents the referrer type of the first referrer of the visit. References the referrer_type.tsv lookup table.
tinyint unsigned
visit_search_engine
A numeric ID that represents the first search engine of the visit. References the search_engines.tsv lookup table.
smallint unsigned
visit_start_pagename
Page of the first hit of the visit.
varchar(100)
visit_start_page_url
URL of the first hit of the visit.
varchar(255)
visit_start_time_gmt
Timestamp (in UNIX® time) of the first hit of the visit.
int
weekly_visitor
A flag that determines if the hit is a new weekly visitor.
tinyint unsigned
yearly_visitor
A flag that determines if the hit is a new yearly visitor.
tinyint unsigned
post_
zip
Helps populate the Zip code dimension. See also geo_zip.
varchar(50)

Unused or retired columns

The following list of columns are unused, retired, or otherwise do not contain value in reporting. Some of these columns are tied to features that have been sunset, while others are no longer needed because of new and more robust features. Most of these columns do not contain data; columns that might still contain data are not supported by current data collection libraries and are not available dimensions in Analysis Workspace.

Post
Column name
post_
adclassificationcreative
click_action
click_action_type
click_context
click_context_type
click_sourceid
click_tag
dataprivacydmaconsent
post_
hier1 - hier5
homepage
ip2
mobileacquisitionclicks
mobileactioninapptime
mobileactiontotaltime
mobileappperformanceaffectedusers
mobileappperformanceappid.app-perf-app-name
mobileappperformanceappid.app-perf-platform
mobileappperformancecrashes
mobileappperformancecrashid.app-perf-crash-name
mobileappperformanceloads
mobileappstoreavgrating
mobileappstoredownloads
mobileappstoreinapprevenue
mobileappstoreinapproyalties
mobileappstoreobjectid.app-store-user
mobileappstoreobjectid.application-name
mobileappstoreobjectid.application-version
mobileappstoreobjectid.appstore-name
mobileappstoreobjectid.category-name
mobileappstoreobjectid.country-name
mobileappstoreobjectid.device-manufacturer
mobileappstoreobjectid.device-name
mobileappstoreobjectid.in-app-name
mobileappstoreobjectid.platform-name-version
mobileappstoreobjectid.rank-category-type
mobileappstoreobjectid.region-name
mobileappstoreobjectid.review-comment
mobileappstoreobjectid.review-title
mobileappstoreoneoffrevenue
mobileappstoreoneoffroyalties
mobileappstorepurchases
mobileappstorerank
mobileappstorerankdivisor
mobileappstorerating
mobileappstoreratingdivisor
mobileavgprevsessionlength
mobilecrashes
mobilecrashrate
mobiledailyengagedusers
mobiledayssincelastupgrade
mobiledeeplinkid.name
mobileinstalls
mobilelaunches
mobilelaunchessincelastupgrade
post_
mobileltv
mobileltvtotal
post_
mobilemessageclicks
post_
mobilemessageid.dest
post_
mobilemessageid.name
post_
mobilemessageid.type
post_
mobilemessageimpressions
post_
mobilemessagepushpayloadid.name
post_
mobilemessageviews
mobilemonthlyengagedusers
mobileosenvironment
mobileplacedwelltime
mobileplaceentry
mobileplaceexit
mobileprevsessionlength
mobilerelaunchcampaigntrackingcode.name
mobileupgrades
namespace
p_plugins
post_
page_event_var3
post_
partner_plugins
plugins
prev_page
product_merchandising
sampled_hit
service
post_
socialaccountandappids
post_
socialassettrackingcode
post_
socialauthor
post_
socialaveragesentiment
post_
socialaveragesentiment (deprecated)
post_
socialcontentprovider
post_
socialfbstories
post_
socialfbstorytellers
post_
socialinteractioncount
post_
socialinteractiontype
post_
sociallanguage
post_
sociallatlong
post_
sociallikeadds
post_
sociallink
post_
sociallink (deprecated)
post_
socialmentions
post_
socialowneddefinitioninsighttype
post_
socialowneddefinitioninsightvalue
post_
socialowneddefinitionmetric
post_
socialowneddefinitionpropertyvspost
post_
socialownedpostids
post_
socialownedpropertyid
post_
socialownedpropertyname
post_
socialownedpropertypropertyvsapp
post_
socialpageviews
post_
socialpostviews
post_
socialproperty
post_
socialproperty (deprecated)
post_
socialpubcomments
post_
socialpubposts
post_
socialpubrecommends
post_
socialpubsubscribers
post_
socialterm
post_
socialtermslist
post_
socialtermslist (deprecated)
post_
socialtotalsentiment
post_
state
post_
survey
survey_instances
tnt_post_vista
ua_color
ua_os
ua_pixels
videoadload
post_
videoauthorized
videoaverageminuteaudience
videochaptercomplete
videochapterstart
videochaptertime
videopause
videopausecount
videopausetime
videoplay
videoprogress10
videoprogress25
videoprogress50
videoprogress75
videoprogress96
videoqoebitrateaverage
videoqoebitratechange
videoqoebuffer
videoqoedropbeforestart
videoqoedroppedframes
videoqoeerror
videoresume
videotime
videototaltime
videouniquetimeplayed
recommendation-more-help
6b7d49d5-f5fe-4b7f-91ae-5b0745755ed2