Analytics field mappings

Last update: 2023-01-06
  • Topics:
  • Sources
    View more on this topic
  • Created for:
  • Developer
    User
    Admin
    Leader

Adobe Experience Platform allows you to ingest Adobe Analytics data through the Analytics source. Some of the data ingested through ADC can be mapped directly from Analytics fields to Experience Data Model (XDM) fields, while other data requires transformations and specific functions in order to be successfully mapped.

Direct mapping fields

Select fields are directly mapped from Adobe Analytics to Experience Data Model (XDM).

The following table includes columns that show the name of the Analytics field (Analytics field), the corresponding XDM field (XDM field) and its type (XDM type), as well as a description of the field (Description).

NOTE

Please scroll left/right to view the full contents of the table.

Analytics field XDM field XDM type Description
m_evar1 - m_evar250 _experience.analytics.customDimensions.eVars.eVar1 - _experience.analytics.customDimensions.eVars.eVar250 string A custom variable, which can range from 1-250. Each organization will use these custom eVars differently.
m_prop1 - m_prop75 _experience.analytics.customDimensions.props.prop1 - _experience.analytics.customDimensions.props.prop75 string Custom traffic variables, which can range from 1-75.
m_browser _experience.analytics.environment.browserID integer The number ID of the browser.
m_browser_height environment.browserDetails.viewportHeight integer The height of the browser, in pixels.
m_browser_width environment.browserDetails.viewportWidth integer The width of the browser, in pixels.
m_campaign marketing.trackingCode string The variable used in the Tracking Code dimension.
m_channel web.webPageDetails.siteSection string The variable used in the Site Sections dimension.
m_domain environment.domain string The variable used in the Domain dimension. This will be based on the user’s internet service provider (ISP).
m_geo_city placeContext.geo.city string The name of the city of the hit. This is based off of the hit’s IP address.
m_geo_dma placeContext.geo.dmaID integer The numeric ID of the demographic area for the hit. This is based off of the hit’s IP address.
m_geo_region placeContext.geo.stateProvince string The name of either the state or region of the hit. This is based off of the hit’s IP address.
m_geo_zip placeContext.geo.postalCode string The ZIP code of the hit. This is based off of the hit’s IP address.
m_keywords search.keywords string The variable used in the Keyword dimension.
m_os _experience.analytics.environment.operatingSystemID integer The numeric ID representing the operating system of the visitor. This is based on the user_agent column.
m_page_url web.webPageDetails.URL string The URL of the page hit.
m_pagename_no_url web.webPageDetails.name string A variable used to populate the Pages dimension.
m_referrer web.webReferrer.URL string The Page URL of the previous page.
m_search_page_num search.pageDepth integer Used by the All Search Page Rank dimension. Indicates which page of search results your site appeared on before the user clicked through to your site.
m_state _experience.analytics.customDimensions.stateProvince string State variable.
m_user_server web.webPageDetails.server string A variable used in the Server dimension.
m_zip _experience.analytics.customDimensions.postalCode string A variable used to populate the Zip Code dimension.
accept_language environment.browserDetails.acceptLanguage string Lists all the accepted languages, as indicated in the Accept-Language HTTP header.
homepage web.webPageDetails.isHomePage boolean No longer used. Indicated if the current URL is the browser’s homepage.
ipv6 environment.ipV6 string
j_jscript environment.browserDetails.javaScriptVersion string The vesrion of JavaScript supported by the browser.
user_agent environment.browserDetails.userAgent string The user agent string sent in the HTTP header.
mobileappid application.name string The mobile app ID, stored in the following format: [AppName][BundleVersion].
mobiledevice device.model string The name of the mobile device. 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.
pointofinterest placeContext.POIinteraction.POIDetail.name string Used by mobile services. Represents the point of interest.
pointofinterestdistance placeContext.POIinteraction.POIDetail.geoInteractionDetails.distanceToCenter number Used by mobile services. Represents the point of interest distance.
mobileplaceaccuracy placeContext.POIinteraction.POIDetail.geoInteractionDetails.deviceGeoAccuracy number Collected from the context data variable a.loc.acc. Indicates the accuracy of the GPS in meters at time of collection.
mobileplacecategory placeContext.POIinteraction.POIDetail.category string Collected from the context data variable a.loc.category. Describes the category of a specific place.
mobileplaceid placeContext.POIinteraction.POIDetail.POIID string Collected from the context data variable a.loc.id. Identifier for a given point of interest.
video media.mediaTimed.primaryAssetReference._id string The name of the video.
videoad advertising.adAssetReference._id string Identifier of the ad asset.
videocontenttype media.mediaTimed.primaryAssetViewDetails.broadcastContentType string The Video Content-Type. This is automatically set to “Video” for all video views.
videoadpod advertising.adAssetViewDetails.adBreak._id string The pod which the Video Ad is in.
videoadinpod advertising.adAssetViewDetails.index integer The position the Video Ad is in the pod.
videoplayername media.mediaTimed.primaryAssetViewDetails.playerName string The name of the Video player.
videochannel media.mediaTimed.primaryAssetViewDetails.broadcastChannel string The Video channel.
videoadplayername advertising.adAssetViewDetails.playerName string The name of the Video Ad player.
videochapter media.mediaTimed.mediaChapter.chapterAssetReference._id string The Video chapter’s name
videoname media.mediaTimed.primaryAssetReference._dc.title string The Video name.
videoadname advertising.adAssetReference._dc.title string The name of the Video Ad.
videoshow media.mediaTimed.primaryAssetReference._iptc4xmpExt.Series._iptc4xmpExt.Name string Video show.
videoseason media.mediaTimed.primaryAssetReference._iptc4xmpExt.Season._iptc4xmpExt.Name string Video Season.
videoepisode media.mediaTimed.primaryAssetReference._iptc4xmpExt.Episode._iptc4xmpExt.Name string Video episode.
videonetwork media.mediaTimed.primaryAssetViewDetails.broadcastNetwork string Video network.
videoshowtype media.mediaTimed.primaryAssetReference.showType string Video show type.
videoadload media.mediaTimed.primaryAssetViewDetails.adLoadType string Video ad loads.
videofeedtype media.mediaTimed.primaryAssetViewDetails.sourceFeed string Video feed type.
mobilebeaconmajor placeContext.POIinteraction.POIDetail.beaconInteractionDetails.beaconMajor number Mobile Services beacon major.
mobilebeaconminor placeContext.POIinteraction.POIDetail.beaconInteractionDetails.beaconMinor number Mobile Services beacon minor.
mobilebeaconuuid placeContext.POIinteraction.POIDetail.beaconInteractionDetails.proximityUUID string Mobile Services beacon UUID.
videosessionid media.mediaTimed.primaryAssetViewDetails._id string Video session ID.
videogenre media.mediaTimed.primaryAssetReference._iptc4xmpExt.Genre array Video genre.
mobileinstalls application.firstLaunches Object This is triggered at the first run after installation or re-installation
mobileupgrades application.upgrades Object Reports the number of app upgrades. Triggers at the first run after upgrade or any time the version number changes.
mobilelaunches application.launches Object The number of times the app has been launched.
mobilecrashes application.crashes Object
mobilemessageclicks directMarketing.clicks Object
mobileplaceentry placeContext.POIinteraction.poiEntries Object
mobileplaceexit placeContext.POIinteraction.poiExits Object
videotime media.mediaTimed.timePlayed Object
videostart media.mediaTimed.impressions Object
videocomplete media.mediaTimed.completes Object
videosegmentviews media.mediaTimed.mediaSegmentViews Object
videoadstart advertising.impressions Object
videoadcomplete advertising.completes Object
videoadtime advertising.timePlayed Object
videochapterstart media.mediaTimed.mediaChapter.impressions Object
videochaptercomplete media.mediaTimed.mediaChapter.completes Object
videochaptertime media.mediaTimed.mediaChapter.timePlayed Object
videoplay media.mediaTimed.starts Object
videototaltime media.mediaTimed.totalTimePlayed Object
videoqoetimetostart media.mediaTimed.primaryAssetViewDetails.qoe.timeToStart Object The video quality time to start.
videoqoedropbeforestart media.mediaTimed.dropBeforeStarts Object
videoqoebuffercount media.mediaTimed.primaryAssetViewDetails.qoe.buffers Object Video quality buffer count
videoqoebuffertime media.mediaTimed.primaryAssetViewDetails.qoe.bufferTime Object Video quality buffer time
videoqoebitratechangecount media.mediaTimed.primaryAssetViewDetails.qoe.bitrateChanges Object Video quality change count
videoqoebitrateaverage media.mediaTimed.primaryAssetViewDetails.qoe.bitrateAverage Object Video quality average bit rate
videoqoeerrorcount media.mediaTimed.primaryAssetViewDetails.qoe.errors Object Video quality error count
videoqoedroppedframecount media.mediaTimed.primaryAssetViewDetails.qoe.droppedFrames Object
videoprogress10 media.mediaTimed.progress10 Object
videoprogress25 media.mediaTimed.progress25 Object
videoprogress50 media.mediaTimed.progress50 Object
videoprogress75 media.mediaTimed.progress75 Object
videoprogress95 media.mediaTimed.progress95 Object
videoresume media.mediaTimed.resumes Object
videopausecount media.mediaTimed.pauses Object
videopausetime media.mediaTimed.pauseTime Object
videosecondssincelastcall media.mediaTimed.primaryAssetViewDetails.sessionTimeout integer

Split mapping fields

These fields have a single source, but map to multiple XDM locations.

Analytics field XDM field XDM type Description
s_resolution device.screenWidth, device.screenHeight integer Numeric ID representing the resolution of the monitor.
mobileosversion environment.operatingSystem, environment.operatingSystemVersion string Mobile operating system version.
videoadlength advertising.adAssetReference._xmpDM.duration integer Video Ad length.

Generated mapping fields

Select fields coming from ADC need to be transformed, requiring logic beyond a direct copy from Adobe Analytics in order to be generated in XDM.

The following table includes columns that show the name of the Analytics field (Analytics field), the corresponding XDM field (XDM field) and its type (XDM type), as well as a description of the field (Description).

NOTE

Please scroll left/right to view the full contents of the table.

Analytics field XDM field XDM type Description
m_prop1 - m_prop75 _experience.analytics.customDimensions.listprops.prop1 - _experience.analytics.customDimensions.listprops.prop75 Object Custom traffic variables, ranging from 1-75
m_hier1 - m_hier5 _experience.analytics.customDimensions.hierarchies.hier1 - _experience.analytics.customDimensions.hierarchies.hier5 Object Used by hierarchy variables. It contains a
m_mvvar1 - m_mvvar3 _experience.analytics.customDimensions.lists.list1.list[] - _experience.analytics.customDimensions.lists.list3.list[] array List of variable values. Contains a delimited list of custom values, depending on the implementation
m_color device.colorDepth integer The color depth ID, which is based off of the value of the c_color column.
m_cookies environment.browserDetails.cookiesEnabled boolean A variable used in the Cookie Support dimension.
m_event_list commerce.purchases, commerce.productViews, commerce.productListOpens, commerce.checkouts, commerce.productListAdds, commerce.productListRemovals, commerce.productListViews Object Standard commerce events triggered on the hit.
m_event_list _experience.analytics.event1to100.event1 - _experience.analytics.event1to100.event100, _experience.analytics.event101to200.event101 - _experience.analytics.event101to200.event200, _experience.analytics.event201to300.event201 - _experience.analytics.event201to300.event300, _experience.analytics.event301to400.event301 - _experience.analytics.event301to400.event400, _experience.analytics.event401to500.event401 - _experience.analytics.event401to500.event500, _experience.analytics.event501to600.event501 - _experience.analytics.event501to600.event600, _experience.analytics.event601to700.event601 - _experience.analytics.event601to700.event700, _experience.analytics.event701to800.event701 - _experience.analytics.event701to800.event800, _experience.analytics.event801to900.event801 - _experience.analytics.event801to900.event900, _experience.analytics.event901to1000.event901 - _experience.analytics.event901to1000.event1000 Object Custom events triggered on the hit.
m_geo_country placeContext.geo.countryCode string Abbreviation of the country where the hit came from, which is based off of the IP.
m_geo_latitude placeContext.geo._schema.latitude number
m_geo_longitude placeContext.geo._schema.longitude number
m_java_enabled environment.browserDetails.javaEnabled boolean A flag indicating whether Java is enabled.
m_latitude placeContext.geo._schema.latitude number
m_longitude placeContext.geo._schema.longitude number
m_page_event_var1 web.webInteraction.URL string A variable that is only used in link tracking image requests. This variable contains the URL of the download link, exit link, or custom link clicked.
m_page_event_var2 web.webInteraction.name string A variable that is only used in link tracking image requests. This lists the custom name of the link, if it is specified.
m_page_type web.webPageDetails.isErrorPage boolean A variable that is used to populate the Pages Not Found dimension. This variable should either be empty, or contain “ErrorPage”.
m_pagename_no_url web.webPageDetails.pageViews.value number The name of the page (if set). If no page is specified this value is left empty.
m_paid_search search.isPaid boolean A flag that is set if the hit matches paid search detection.
m_product_list productListItems[].items array The product list, as passed in through the products variable.
m_ref_type web.webReferrer.type string A numeric ID representing the type of referral for the hit. 1 means inside your site, 2 means other websites, 3 means search engines, 4 means hard drive, 5 means USENET, 6 means Typed/Bookmarked (no referrer), 7 means email, 8 means No JavaScript, and 9 means Social Networks.
m_search_engine search.searchEngine string The numeric ID representing the search engine that referred the visitor to your site.
post_currency commerce.order.currencyCode string The currency code that was used during the transaction.
post_cust_hit_time_gmt timestamp string This is only used in timestamp-enabled datasets. This is the timestamp sent with the it, based on Unix time.
post_cust_visid identityMap object The customer visitor ID.
post_cust_visid endUserIDs._experience.aacustomid.primary boolean The customer visitor ID.
post_cust_visid endUserIDs._experience.aacustomid.namespace.code string The customer visitor ID.
post_visid_high + visid_low identityMap object A unique identifier for a visit.
post_visid_high + visid_low endUserIDs._experience.aaid.id string A unique identifier for a visit.
post_visid_high endUserIDs._experience.aaid.primary boolean Used in conjunction with visid_low to uniquely identify a visit.
post_visid_high endUserIDs._experience.aaid.namespace.code string Used in conjunction with visid_low to uniquely identify a visit.
post_visid_low identityMap object Used in conjunction with visid_high to uniquely identify a visit.
hit_time_gmt receivedTimestamp string The timestamp of the hit, based in Unix time.
hitid_high + hitid_low _id string A unique identifier to identify a hit.
hitid_low _id string Used in conjunction with hitid_high to uniquely identify a hit.
ip environment.ipV4 string The IP Address, based on the HTTP header of the image request.
j_jscript environment.browserDetails.javaScriptEnabled boolean The version of JavaScript used.
mcvisid_high + mcvisid_low identityMap object The Experience Cloud Visitor ID.
mcvisid_high + mcvisid_low endUserIDs._experience.mcid.id string The Experience Cloud ID (ECID) is also known as MCID and sometimes used in namespaces.
mcvisid_high endUserIDs._experience.mcid.primary boolean The Experience Cloud ID (ECID) is also known as MCID and sometimes used in namespaces.
mcvisid_high endUserIDs._experience.mcid.namespace.code string The Experience Cloud ID (ECID) is also known as MCID and sometimes used in namespaces.
mcvisid_low identityMap object The Experience Cloud Visitor ID.
sdid_high + sdid_low _experience.target.supplementalDataID string Hit Stitching ID. The analytics field sdid_high and sdid_low is the supplemental data id used to stitch two (or more) incoming hits together.
mobilebeaconproximity placeContext.POIinteraction.POIDetail.beaconInteractionDetails.proximity string Mobile Services beacon proximity.
videochapter media.mediaTimed.mediaChapter.chapterAssetReference._xmpDM.duration integer The name of the video chapter.
videolength media.mediaTimed.primaryAssetReference._xmpDM.duration integer The length of the video.

Advanced mapping fields

Select fields (known as “postvalues”) require more advanced transformations before they can successfully mapped from Adobe Analytics fields to Experience Data Model (XDM). Performing these advanced transformations involves the use of Adobe Experience Platfrom Query Service and prebuilt functions (called Adobe-defined functions) for sessionization, attribution, and deduplication.

To learn more about performing this transformations using Query Service, please visit the Adobe-defined functions documentation.

The following table includes columns that show the name of the Analytics field (Analytics field), the corresponding XDM field (XDM field) and its type (XDM type), as well as a description of the field (Description).

NOTE

Please scroll left/right to view the full contents of the table.

Analytics field XDM field XDM type Description
post_evar1 - post_evar250 _experience.analytics.customDimensions.eVars.eVar1 - _experience.analytics.customDimensions.eVars.eVar250 string A custom variable, which can range from 1-250. Each organization will use these custom eVars differently.
post_prop1 - post_prop75 _experience.analytics.customDimensions.props.prop1 - _experience.analytics.customDimensions.props.prop75 string Custom traffic variables, which can range from 1-75.
post_browser_height environment.browserDetails.viewportHeight integer The height of the browser, in pixels.
post_browser_width environment.browserDetails.viewportWidth integer The width of the browser, in pixels.
post_campaign marketing.trackingCode string The variable used in the Tracking Code dimension.
post_channel web.webPageDetails.siteSection string The variable used in the Site Sections dimension.
post_cust_visid endUserIDs._experience.aacustomid.id string The custom visitor ID, if set.
post_first_hit_page_url _experience.analytics.endUser.firstWeb.webPageDetails.URL string The URL of the first page the visitor reaches.
post_first_hit_pagename _experience.analytics.endUser.firstWeb.webPageDetails.name string A variable used in the Entry Page Original dimension. The page name of the entry page of the visitor.
post_keywords search.keywords string The keywords that were collected for the hit.
post_page_url web.webPageDetails.URL string The URL of the page hit.
post_pagename_no_url web.webPageDetails.name string A variable used to populate the Pages dimension.
post_purchaseid commerce.order.purchaseID string Variable that is used to uniquely identify purchases.
post_referrer web.webReferrer.URL string The URL of the previous page.
post_state _experience.analytics.customDimensions.stateProvince string State variable.
post_user_server web.webPageDetails.server string A variable used in the Server dimension.
post_zip _experience.analytics.customDimensions.postalCode string A variable used to populate the Zip Code dimension.
browser _experience.analytics.environment.browserID integer The numeric ID of the browser.
domain environment.domain string The variable used in the Domain dimension. This will be based on the user’s internet service provider (ISP).
first_hit_referrer _experience.analytics.endUser.firstWeb.webReferrer.URL string The first referring URL for the visitor.
geo_city placeContext.geo.city string The name of the city of the hit. This is based off of the hit’s IP address.
geo_dma placeContext.geo.dmaID integer The numeric ID of the demographic area for the hit. This is based off of the hit’s IP address.
geo_region placeContext.geo.stateProvince string The name of either the state or region of the hit. This is based off of the hit’s IP address.
geo_zip placeContext.geo.postalCode string The ZIP code of the hit. This is based off of the hit’s IP address.
os _experience.analytics.environment.operatingSystemID integer The numeric ID representing the operating system of the visitor. This is based on the user_agent column.
search_page_num search.pageDepth integer This variable is used by the All Search Page Rank dimension, and indicates which page of search results your site
visit_keywords _experience.analytics.session.search.keywords string A variable used in the Search Keywords dimension.
visit_num _experience.analytics.session.num integer A variable used in the Visit Number dimension. This starts at 1, and increments each time a new visit starts (per user).
visit_page_num _experience.analytics.session.depth integer A variable used in the Hit Depth dimension. This value increases by 1 for each hit the user generates, and resets after each visit.
visit_referrer _experience.analytics.session.web.webReferrer.URL string The first referrer of the visit.
visit_search_page_num _experience.analytics.session.search.pageDepth integer The first Page Name of the visit.
post_prop1 - post_prop75 _experience.analytics.customDimensions.listprops.prop1 - _experience.analytics.customDimensions.listprops.prop75 Object Custom traffic variables 1-75.
post_hier1 - post_hier5 _experience.analytics.customDimensions.hierarchies.hier1 - _experience.analytics.customDimensions.hierarchies.hier5 Object Used by hierarchy variables and contains a delimited list of values.
post_mvvar1 - post_mvvar3 _experience.analytics.customDimensions.lists.list1.list[] - _experience.analytics.customDimensions.lists.list3.list[] array A list of variable values. Contains a delimited list of custom values, depending on implementation.
post_cookies environment.browserDetails.cookiesEnabled boolean Variable used in the Cookie Support dimension.
post_event_list commerce.purchases, commerce.productViews, commerce.productListOpens, commerce.checkouts, commerce.productListAdds, commerce.productListRemovals, commerce.productListViews Object Standard commerce events triggered on the hit.
post_event_list _experience.analytics.event1to100.event1 - _experience.analytics.event1to100.event100, _experience.analytics.event101to200.event101 - _experience.analytics.event101to200.event200, _experience.analytics.event201to300.event201 - _experience.analytics.event201to300.event300, _experience.analytics.event301to400.event301 - _experience.analytics.event301to400.event400, _experience.analytics.event401to500.event401 - _experience.analytics.event401to500.event500, _experience.analytics.event501to600.event501 - _experience.analytics.event501to600.event600, _experience.analytics.event601to700.event601 - _experience.analytics.event601to700.event700, _experience.analytics.event701to800.event701 - _experience.analytics.event701to800.event800, _experience.analytics.event801to900.event801 - _experience.analytics.event801to900.event900, _experience.analytics.event901to1000.event901 - _experience.analytics.event901to1000.event1000 Object Custom events triggered on the hit.
post_java_enabled environment.browserDetails.javaEnabled boolean A flag indicating whether Java is enabled.
post_latitude placeContext.geo._schema.latitude number
post_longitude placeContext.geo._schema.longitude number
post_page_event web.webInteraction.type string The type of hit that is sent in the image request (standard hit, download link, exit link, or custom link clicked).
post_page_event web.webInteraction.linkClicks.value number The type of hit that is sent in the image request (standard hit, download link, exit link, or custom link clicked).
post_page_event_var1 web.webInteraction.URL string This variable is only used in link tracking image requests. This is the URL of the donwload link, exit link, or custom link clicked.
post_page_event_var2 web.webInteraction.name string This variable is only used in link tracking image requests. This will be the custom name of the link.
post_page_type web.webPageDetails.isErrorPage boolean This is used to populate the Pages Not Found dimension. This variable should either be empty or contain “ErrorPage”
post_pagename_no_url web.webPageDetails.pageViews.value number The name of the page (if set). If no page is specified this value is left empty.
post_product_list productListItems[].items array The product list, as passed in through the products variable.
post_search_engine search.searchEngine string The numeric ID representing the search engine that referred the visitor to your site.
mvvar1_instances .list.items[] Object List of variable values. Contains a delimited list of custom values, depending on implementation.
mvvar2_instances .list.items[] Object List of variable values. Contains a delimited list of custom values, depending on implementation.
mvvar3_instances .list.items[] Object
color device.colorDepth integer Color depth ID, based on the value of the c_color column.
first_hit_ref_type _experience.analytics.endUser.firstWeb.webReferrer.type string The numeric ID, representing the referrer type of the very first referrer of the visitor.
first_hit_time_gmt _experience.analytics.endUser.firstTimestamp integer Timestamp of the very first hit of the visitor in Unix time.
geo_country placeContext.geo.countryCode string Abbreviation of the country the hit came from, based on IP.
geo_latitude placeContext.geo._schema.latitude number
geo_longitude placeContext.geo._schema.longitude number
paid_search search.isPaid boolean A flag that is set if the hit matches paid search detection.
ref_type web.webReferrer.type string A numeric ID representing the type of referral for the hit.
visit_paid_search _experience.analytics.session.search.isPaid boolean A flag (1=paid, 0=not paid) indicating if the first hit of the visit was from a paid search hit.
visit_ref_type _experience.analytics.session.web.webReferrer.type string Numeric ID representing the referrer type of the first referrer of the visit.
visit_search_engine _experience.analytics.session.search.searchEngine string Numeric ID of the first search engine of the visit.
visit_start_time_gmt _experience.analytics.session.timestamp integer Timestamp of the first hit of the visit in Unix time.
Previous page
Next page

On this page