Record Contents

Tracking Request Id

id

Unique identifier of the tracking event.

String

id

Depends on the event type.

DEPENDS (for example, request_id, form_request_id)

This ID always refers to the current event, so the ID depends on what kind of event it is (for example, if it is a form event, then form_request_id is displayed here).

Tracking  Timestamp

timestamp

The instant when our pixel/ SDK tracked the event.

String

(ISO 8601 Date Time with Offset : YYYY-MM-ddTHH:mm:ssZ)

timestamp

Most files

times

The time is for the respective action/event.

Referrer URL

referrerUrl

The referrer URL of the tracked event.

String

referrerUrl

n/a

n/a

Contains the information provided by the Pixel Tracking script. In general, it contains the complete URL, for example " http://www.example.com/path?param1=xx&param2=yy"

There are some exceptions:

The Raw Data Export does not provide the raw referrer URL provided by the Pixel Tracking script but provides the referrer domain and referrer URL without any query parameters.

Request URL

requestUrl

The request URL of the tracked event.

String

requestUrl

n/a

n/a

-

Tracking Request Query URL

trackUrlQueryString

The query string of the tracked URL.

String

trackUrlQueryString

n/a

n/a

-

Ingestion timestamp

eventMetadata.ingestionTimestamp

eventMetadata_ingestionTimestamp

Long

The UTC timestamp when the event was accepted by the tracking server.

Tracking server ID

eventMetadata.source

eventMetadata_source

Text

Server ID on which the request was initially received.

Version of the event schema

eventMetadata.version

eventMetadata_version

Text

The version of the event schema.

Detected tracking context

processingMetadata.detectedContext

processingMetadata_detectedContext

Text

Detected type of event. Values: Page, Action, Heatmap or Unknown.

Track ID

account.id

You customer account identification.

String

account_id

n/a

n/a

-

User Id (URM Visitor Id)

user.id

A unique visitor ID, that is generated by the "End device Visitor Ids" (cookie ID) and/or the "URM - Custom Visitor Id" (customer ID).

String

user_id

getFullVisitors

urm_visitor_id

May change within a session.

User First Visit Timestamp

user.timestamp

The instant where the user data was tracked.

String (ISO 8601 Date Time with Offset: YYYY-MM-ddTHH:mm:ssZ)

user_timestamp

n/a

n/a

-

Customer Id ("cd")

user.customerId

Customized identifier for the tracked customer.

String

user_customerId

getFullCustomer

customer_id

Example:

}

"USER_CATEGORIES_NUMERICVALUES_001_VALUE":  12345.0,

"USER_CUSTOMERID": "TestUser"

}

Global User Id

user.guid

Global, the unique identifier for the customer (only relevant if participating on Mapp's Cross Device Bridge).

String

user_guid

getFullVisitors

global_user_id

May change within a session, CDB only.

User (Text) Categories

user.categories.textValues

Categories for the user if available.

Map<String, TextCategory>

user_categories_textValues

n/a

n/a

May change within a session.

User (Numeric) Categories

user.categories.numericValues

Categories for the user if available.

Map<String, NumericCategory>

user_categories_numericValues

n/a

n/a

May change within a session.

 Predefined URM Categories (e.g. Address, Email, etc)

n/a

n/a

n/a

n/a

n/a

n/a

Available in the future.

 User Lifetime metrics (e.g. Lifetime Page Impressions etc)

n/a

n/a

n/a

n/a

n/a

n/a

Available in the future.

 User Micro / Macro Status

n/a

n/a

n/a

n/a

n/a

n/a

Available in the future.

Session Id

session.id

Identifier of the session where the customer is being tracked.

String

session_id

Most tables

sid

-

Session beginning timestamp

session.startTimestamp

The instant where the session the event belongs to was started.

String (ISO 8601 Date Time with Offset: YYYY-MM-ddTHH:mm:ssZ)

session_startTimestamp

getFullVisitors

visit_time

-

Session end timestamp

n/a

The instant where the session the event belongs to was ended.

n/a

n/a

getFullVisitors

visit_time_end

-

Session  (Text) Parameters

session.parameters.textValues

Parameters for the session.

Map<String, TextParameter>

session_parameters_textValues

getFullCustParaSession_X

cust_para_string_y, cust_para_generic_y

-

Session  (Numeric) Parameters

session.parameters.numericValues

Parameters for the session.

Map<String, NumericParameter>

session_parameters_numericValues

getFullCustParaSession_X

cust_para_number_y

-

Request sequence number

session.requestSequenceNumber

The request position (natural order) within the session.

Integer

session_requestSequenceNumber

n/a

n/a

-

Page (Request) Id

page.id

Identifier of the tracked content.

String

page_id

Depends on the event (for example, getFullForms).

request_id

This field depends on the event. If the event is not a page call, but a form event, for example, then this is the equivalent of request_id in the getFullForms table.

Page Ranking

page.pageOrder

Classifies page views in the order of all page views associated with the visit.

Integer

page_pageOrder

getContents

page_order

-

Page Timestamp

page.startTimestamp

The instant where the page was tracked.

String (ISO 8601 Date Time with Offset: YYYY-MM-ddTHH:mm:ssZ)

page_startTimestamp

getContents

times

-

Page name (content id)

page.name

The name of the page.

String

page_name

getContents

content

-

Page URL

page.url

The URL to the page.

String

page_url

n/a

n/a

-

Page (Text) Categories

page.categories.textValues

Categories for the page.

Map<String, TextCategory>

page_categories_textCategories

n/a

n/a

-

 Page (Numeric) Categories

page.categories.numericValues

Categories for the page.

Map<String, NumericCategory>

page_categories_numericCategories

n/a

n/a

-

Page (Text) Parameters

page.parameters.textValues

Parameters for the page.

Map<String, TextParameter>

page_ parameters _textParameters

getFullCustParaPage_X

cust_para_string_y, cust_para_generic_y

-

Page (Numeric) Parameters

page.parameters.numericValues

Parameters for the page.

Map<String, NumericParameter>

page_ parameters _numericParameters

getFullCustParaPage_X

cust_para_number_y

-

Internal search phrase

page.internalSearchPhrase

The search phrase when the internal search bar of the website was used.

String

page_internalSearchPhrase

FullSearchPhraseInternFullSearchPhraseIntern

search_phrase

-

External search phrase

page.externalSearchPhrase

The search phrase when an external search engine was used, e.g. Google.

String

page_externalSearchPhrase

getFullSearchPhrase

search_phrase

-

 Search Engine (Flag)

n/a

n/a

n/a

n/a

n/a

n/a

Available in the future.

Referrer Domain

n/a

n/a

n/a

n/a

n/a

n/a

See referrerUrl. The Raw Data Export does not provide the complete URL.

Page duration

n/a

n/a

n/a

n/a

n/a

n/a

-

* Referrer Domain

page.referrerDomain

Domain of the detected referrer.

Text

page_referrerDomain

-

-

new field, contains the domain of the referrer

*Search Engine Flag

page.searchEngine

Flag indicating the referrer is a search engine.

Boolean

page_searchEngine

-

-

new field, contains a flag indicating the referrer is a search engine

Media Start Timestamp

media.startTimestamp

The instant where the media started playing.

String

(ISO 8601 Date Time with Offset : YYYY-MM-ddTHH:mm:ssZ)

media_startTimestamp

getFullMedia

times

-

Media Session Id

media.mediaSessionId

Identifies requests belonging to the same active media session. A user may have multiple media sessions open at the same time.

String

media_mediaSessionId

Contains an ID to identify media requests belonging to the same media session.

Media Name

media.name

The name of the media item.

String

media_name

getFullMedia

media

-

Media Length

media.length

The total length of the media item in seconds.

Integer

media_length

getFullMedia

media_time

-

Media Elapsed time

media.elapsed

The total amount of seconds of the media that were played including rewinding and forwarding.

Integer

media_elapsed

getFullMedia

duration

The current state in the raw data stream refers to the time of the event. In the raw data export, it is the final state of the media session. Limited, does not reflect complete duration. Use mediaAction.position.

Media Bandwidth

media.bandwidth

The bandwidth of the media item.

Integer

media_bandwidth

getFullMedia

bandwidth

-

Media Played time

media.played

The total amount of seconds of the media that were played excluding rewinding and forwarding.

Integer

media_played

getFullMedia

max_duration

The current state in the raw data stream refers to the time of the event. In the raw data export, it is the final state of the media session.

Media Volume

media.volume

The volume level the media was being played on from zero to hundred.

Integer

media_volume

getFullMedia

volume

Available only at init command.

Media Mute

media.mute

The flag that determines if the media has been muted or not.

Boolean

media_mute

getFullMedia

mute

Available only at init command.

Media (Text) Categories

media.categories.textValues

Categories for the media.

Map<String, TextCategory>

media_categories_textValues

n/a

n/a

Available for known media only (at latest beginning of the next day)

 Media (Numeric) Categories

media.categories.numericValues

Categories for the media.

Map<String, NumericCategory>

media_categories_numericValues

n/a

n/a

Available in the future.

Media Action name

mediaAction.name

The name of the media action, which is the click identifier.

String

mediaAction_name

getFullClicks

click

-

Media Action Ranking

mediaAction.ranking

The ranking of the media action within all the media actions on the session.

Integer

mediaAction_ranking

n/a

n/a

-

Media Action Position

mediaAction.position

The current position in elapsed seconds from the beginning of the media.

Integer

mediaAction_position

getFullMediaAction

_a_start_

-

Action Name

action.name

The name of the action, which is the click identifier.

String

action_name

getFullClicks

click

-

Action (Text) Parameters

action.parameters.textValues

Parameters for the action.

Map<String, TextParameter>

action_parameters_textValues

getFullCustParaClick_X

cust_para_string_y, 
cust_para_generic_y

-

Action (Numeric) Parameters

action.parameters.numericValues

Parameters for the action.

Map<String, NumericParameter>

action_parameters_numericValues

getFullCustParaClick_X

cust_para_number_y

-

Form Name

form.name

The name of the form.

String

form_name

getFullForms

form

-

Form Submitted

form.submitted

Specifies whether the form was sent by the user.

String

form_submitted

getFullForms

submitted

-

 Form Fields

n/a

n/a

n/a

n/a

n/a

n/a

Available in the future.

Heatmap Position X

heatmap.positionX

The position of the heatmap on the x-axis.

Integer

heatmap_positionX

n/a

n/a

-

Heatmap Position Y

heatmap.positionY

The position of the heatmap on the y-axis.

Integer

heatmap_positionY

n/a

n/a

-

Basket Status

basket.status

Current status of the shopping basket of items.

Value: Add, Conf, View, List

String

basket_status

getFullBasket

state

Note that the basket status of the raw data stream contains the additional state "list" (this is not included in the raw data export).

Basket Item Quantity

basket.items[X].quantity

Amount of this item that exists on the basket.

Integer

basket_items_X_quantity

getFullBasket

quantity

Custom stream contain up to 25 items only.

Root Stream: available as a nested array structure

Custom Stream: X starts at 1

Basket Item Price

basket.items[X].price

Price of each unit of this item.

Double

basket_items_X_price

getFullBasket

price

-

Basket Item Product

basket.items[X].product

Product information on this item (see product information below).

Product

basket_items_X_product

getFullBasket

bas_pos

The order of the articles in the list indicates the basket position of this article.

Basket Item Rank

basket.items[X].rank

Contains the item rank(position) in the shopping cart/basket

Integer

basket_items_X_rank

Basket Item Product List Position

basket.items[X].listPosition

Contains the product list position of the item in the basket.

Integer

basket_items_X_listPosition

Product (Text) Parameters

basket.parameters.textValues

Parameters for the basket if available.

Map<String, TextParameter>

basket_parameters_textValues

getFullCustParaProduct_X

cust_para_string_y, cust_para_generic_y

Note that product parameters are provided in a single file in the RDE. In Data Streams those are separated as Product Parameters with single values relate to the basket and not the Product.

Product (Numeric) Parameters

basket.parameters.numericValues

Parameters for the basket if available.

Map<String, NumericParameter>

basket_parameters_numericValues

getFullCustParaProduct_X

cust_para_number_y

Note that product parameters are provided in a single file in the RDE. In Data Streams those are separated as Product Parameters with single values relate to the basket and not the Product.

Product Name

  basket.items[X].product.name

The name of a product.

String

basket_items_X_product_name

getFullBasket

product

Custom stream contain up to 25 items only.

Root Stream: available as a nested array structure

Custom Stream: X starts at 1

Product URL

basket.items[X].product.url

The name of a product.

String

basket_items_X_product_url

getFullBasket

product

-

Product (Text) Categories

basket.items[X].product.categories.textValues

Categories for the product.

Map<String, TextCategory>

basket_items_X_product_categories_textValues

n/a

n/a

Available for known products only (at latest beginning from the next day)

Product (Numeric) Categories

basket.items[X].product.categories.numericValues

Categories for the product.

Map<String, NumericCategory>

basket_items_X_product_categories_numericValues

n/a

n/a

-

Product (Text) Parameters

  basket.items[X].product.parameters.textValues

Parameters for the product.

Map<String, TextParameter>

basket_items_X_product_parameters_textValues

getFullCustParaProduct_X

cust_para_string_y, cust_para_generic_y

-

Product (Numeric) Parameters

basket.items[X].product.parameters.numericValues

Parameters for the product.

basket.items[X].product.parameters.numericValues

basket_items_X_product_parameters_numericValues

getFullCustParaProduct_X

cust_para_number_y

-

Order Id

order.id

The identifier of the order to which this event refers.

String

order_id

getFullOrders

order_id

-

Order Value

order.value

The total value of the order.

Double

order_value

getFullOrders

total_price

-

Order Currency

order.currency

The currency of the order.

String

oder_currency

n/a

n/a

-

Order (Text) Parameters

order.parameters.textValues

Parameters for the order.

Map<String, TextParameter>

order_parameters_textValues

n/a

n/a

Not supported by Mapp Intelligence.

Order (Numeric) Parameters

order.parameters.numericValues

Parameters for the order.

Map<String, NumericParameter>

order_parameters_numericValues

n/a

n/a

Not supported by Mapp Intelligence.

Campaign Name

campaign.name

The name of the campaign within this even is enclosed.

String

campaign_name

getFullCampaigns

campaign

-

Campaign Keyword

campaign.keyword

The campaign keyword.

String

campaign_keyword

getFullCampaigns

keyword

-

Website Goal Id

campaign.websiteGoalId

The identifier of the reached website goal.

Integer

campaign_websiteGoalId

n/a

n/a

Contains the internal id of the defined website goal. Usually "order" goal is 1.

Campaign Track Type

campaign.campaignTrackType

The type of campaign.

Values: View, Engagement, Click, WebsiteGoal

String

campaign_campaignTrackType

n/a

n/a

-

Campaign (Text) Categories

campaign.categories.textValues

Categories for the campaign.

Map<String, TextCategory>

campaign_categories_textValues

n/a

n/a

Categories are provided only for "known" campaigns. Campaign categories will be available for new campaigns after some hours, so newly detected campaigns will not provide categories within the first hours.

 Campaign  (Numeric) Categories

campaign.categories.numericValues

Categories for the campaign.

Map<String, NumericCategory>

campaign_categories_numericValues

n/a

n/a

Available in the future.

Campaign (Text) Parameters

campaign.parameters.textValues

Parameters for the campaign.

Map<String, TextParameter>

campaign_parameters_textValues

getFullCustParaCampaign_X

cust_para_string_y, cust_para_generic_y

-

Campaign  (Numeric) Parameters

campaign.parameters.numericValues

Parameters for the campaign.

Map<String, NumericParameter>

campaign_parameters_numericValues

getFullCustParaCampaign_X

cust_para_number_y

Not supported by Mapp Intelligence.

* Device Full Name

device.fullName

The full name of the detected device including device vendor, device name and device family.

String (e.g. Samsung Galaxy S9+)

device_fullName

n/a

mobile_client

Will be deprecated. Please see new Device tab

*  Device Name

device.name

The detected device name.

String (e.g. Galaxy S9+)

device_name

n/a

n/a

Will be deprecated. Please see new Device tab

*  Device Family

device.family

The detected device family.

String (e.g. Galaxy)

device_family

n/a

n/a

Will be deprecated. Please see new Device tab

* Device Vendor

device.vendor

The detected device manufacturer.

String (e.g. Samsung)

device_vendor

n/a

n/a

Will be deprecated. Please see new Device tab

* Device Model

device.model

The detected device model.

String (e.g SM-G965F)

device_model

n/a

n/a

Will be deprecated. Please see new Device tab

*Device Device Class

device.deviceClass

The type of detected device according to Mapp's classification.

Values: Desktop, SmartPhone, Tablet, TV, Console, Smartwatch, EReader, MediaHub, other

String (e.g. SmartPhone)

device_deviceClass

n/a

n/a

Deprecated, but still available. Please see new Device tab

*Device Screen Resolution

device.screen.resolution

The detected device screen resolution in width x height format.

String

device_screen_resolution

getFullVisitors

resolution

-Deprecated, but still available. Please see new Device tab

*Device Screen Colordepth

device.screen.colorDepth

The color depth of the screen of the detected device in bits.

Integer

devicescreen_colorDepth

getFullVisitors

colordepth

-Deprecated, but still available. Please see new Device tab

* Device Screen Inches Diagonal

device.screen.inchesDiagonal

The inches diagonal size of the screen of the detected device.

String

device_screen_inchesDiagonal

n/a

n/a

Will be deprecated. Please see new Device tab

* Device Release Year

device.release.year

The release year of the detected device.

String

device_release_year

n/a

n/a

Will be deprecated. Please see new Device tab

* Device Release Month

device.release.month

The release month of the detected device.

String

device_release_month

n/a

n/a

Will be deprecated. Please see new Device tab

Device Ever Id (Cookie)

device.deviceEverId

Device cookie ID (DEID).

String

device_deviceEverId

getFullVisitors

EID

-

*Browser Full Name

browser.fullName

The full name of the detected web browser.

Text

browser_fullName

n/a

n/a

new field, contains the "marketing name" of the browser

*Browser Name

browser.name

The name of the detected web browser.

String ( e.g. Mozilla Firefox)

browser_name

getFullVisitors

browser_name

existing field, now filled, contains the browser name

*Browser Vendor

browser.vendor

The vendor of the detected web browser.

String ( e.g. Mozilla)

browser_vendor

browser_vendor

existing field, now filled, contains the browser vendor

*Browser Version

browser.version

The version of the detected web browser.

String ( e.g. 64.0.2)

browser_version

getFullVisitors

browser_version

existing field, now filled, contains the browser version

Browser Major Version

browser.majorVersion

The major version of the detected web browser.

Integer

browser_majorVersion

browser_majorVersion

new field, contains the browser major version

Browser Minor Version

browser.minorVersion

The minor version of the detected web browser.

Integer

browser_minorVersion

browser_minorVersion

new field, contains the browser minor version

Browser Javascript Version

browser.javaScriptVersion

The Javascript version of the detected browser.

Text

browser_javaScriptVersion

n/a

n/a

existing field, now filled, contains the javascript version

User Agent String

userAgent

The user agent string from the browser of the tracked user.

String

userAgent

n/a

n/a

-

Browser ID

browser.browserId

Unique ID of the deteced browser.

Text

browser_browserId

n/a

n/a

new field, contains a unique id of the browser

Browser Release Year

browser.release.year

Release year of the detected browser.

Text

browser_release_year

n/a

n/a

new field, contains the release year

Browser Release Month

browser.release.month

Release month of the detected browser.

Text

browser_release_month

n/a

n/a

new field, contains the release month

*  Operation System Name

os.name

The name of the operating system on which the detected device runs.

String ( e.g. Windows 10)

os_name

getFullVisitors

os

Deprecated. Please see new Platform tab

*  Operation System Vendor

os.vendor

The vendor of the operating system on which the detected device runs.

String ( e.g. Microsoft)

os_vendor

n/a

n/a

Deprecated. Please see new Platform tab

*  Operation System Version

os.version

The version of the operating system on which the detected device runs.

String ( e.g. 10)

os_version

getFullVisitors

os

Deprecated. Please see new Platform tab

Operating System Full Name

platform.fullName

The full name of the operating system on which the detected device runs.

Text

platform_fullName

-

-

new field, contains marketing name

Operating System Name

platform.name

The name of the operating system on which the detected device runs.

Text

platform_name

os_name

new field, contains name

Operating System Vendor

platform.vendor

The vendor of the operating system on which the detected device runs.

Text

platform_vendor

os_vendor

new field, contains vendor

Operating System Version

platform.version

The version of the operating system on which the detected device runs.

Text

platform_version

os_version

new field, contains version

Operating System Major Version

platform.majorVersion

The major version of the operating system on which the detected device runs.

Integer

platform_majorVersion

os_major_version

new field, contains major version

Operating System Minor Version

platform.minorVersion

The minor version of the operating system on which the detected device runs.

Integer

platform_minorVersion

os_minor_version

new field, contains minor version

Operating System ID

platform.platformId

Unique ID of the detected operating system.

Text

platform_platformId

-

-

new field, contains a unique id of the platform

Operating System Release Year

platform.release.year

Release year of the detected operating system.

Text

platform_release_year

-

-

new field, contains the release year

Operating System Release Month

platform.release.month

Release month of the detected operating system.

Text

platform_release_month

-

-

new field, contains the release month

Country Code

location.countryCode

The detected ISO 3166 2-letter country code where the visit was originated

String ( e.g. DE)

location_countryCode

getFullVisitors

country

Root & Custom Stream contain country code (e.g. DE), whereas Raw Data export contains country name (e.g. Germany)

City

location.city

The detected city where the visit was originated

String

location_city

getFullVisitors

city

-

 Region

n/a

n/a

n/a

n/a

n/a

n/a

Available in the future.

Connection Speed

connection.speed

The detected connection speed the of the tracked user.

Values:  unknown, modem_isdn, cable_dsl, coorporate, mobile, satellite, wireless

String

Integer

connection_speed

getFullVisitors

netspeed

Data Streams provides a String value, whereas the Raw data export provides a numeric code.

Connection ISP

connection.isp

The detected Internet Service Provider name of the tracked user.

String

connection_isp

getFullVisitors

isp

-

Connection Organization

connection.organisation

The detected organization name of the tracked user.

String

connection_organisation

getFullVisitors

organization

-

 Customer Journey data

n/a

n/a

n/a

n/a

n/a

n/a

Might be added later to Data Streams.

New vs Returning Visitor

n/a

n/a

n/a

n/a

n/a

n/a

-

Javascript Flag

n/a

n/a

n/a

n/a

n/a

n/a

-

Java Flag

n/a

n/a

n/a

n/a

n/a

n/a

-

 Browser Language

n/a

n/a

n/a

n/a

n/a

n/a

Might be added later to Data Streams.

 Client Timezone

n/a

n/a

n/a

n/a

n/a

n/a

Might be added later to Data Streams.

Geid

n/a

n/a

n/a

n/a

n/a

n/a

Deprecated feature, not supported by Mapp Intelligence.

 Browser Window size

n/a

n/a

n/a

n/a

n/a

n/a

Might be added later to Data Streams.