Skip to main content
Sitecore Documentation
  • Learn
  • Downloads
  • Changelog
  • Roadmap
CDPCloud Portal
Sitecore CDP Developer Documentation
  • Developing with Sitecore CDP
    • Access your data
    • Writing SQL queries
        • Guests
        • Orders
        • Order items
        • Experience definitions
        • Events
        • Sessions
  1. Data entities reference
  1. Sitecore CDP Developer Documentation
  2. Data lake export service

Sessions

The following table includes some of the attributes that are available in the sessions entity.

Your organization will have additional attributes.

AttributeDescriptionTypeExample
meta_refThe unique session reference.string"a60e670f-52d6-5cd0-aec3-59de082e3953"
bxtA collection of name-value pair attributes that store various session data points. This attribute is owned and maintained by Sitecore. See the following table for a list of fields stored in the bxt attribute.map{numSelects=0, numConfirms=0, numSearches=0, numCheckouts=0, cartType=BROWSED, language=EN}
core_channelThe channel associated with the session.string"WEB", "MOBILE_WEB", "MOBILE_APP"
core_currency_codeThe organization’s currency code for the order associated with the session.3 letter ISO 4217"EUR", "NZD", "USD"
core_durationThe duration of the session in minutes and seconds.integer double44.55
core_started_atThe date and time when the session started.ISO 8601 Date/Time UTC"2026-10-04T22:30
.516Z"
core_ended_atThe date and time when the session ended.ISO 8601 Date/Time UTC"2026-10-04T23:15
.516Z"
core_point_of_saleThe point of sale associated with the session. The point of sale is preconfigured by your organization.string"myretailsite.com", "bestretailsite.co.uk"
core_statusThe status of the session.string"OPEN", "CLOSED"
core_valueMonetary value of the order in original currency associated with session. Populated for sessions where an order was submitted.integer double100.50
meta_client_keyThe unique client reference that identifies your organization.string"mhbWwbHYfhpheu86hp60oR76S4jQMmZr"
meta_created_atDate and time when the session record was created in Sitecore CDP.ISO 8601 Date/Time UTC"2026-01-01T16:17
.000Z"
meta_created_at_dateDate when the session record was created in Sitecore CDP.ISO 8601 Date"2026-01-01"
meta_flow_execution_refThe unique reference of the experience or flow executed in the session.string"dd7e9c6c-b5bf-4204-8cc5-3c8380a4e993"
meta_guest_refThe unique ID of the guest associated with the session.string"9d94ee11-7043-4b71-980c-a777d00a7b46"
meta_modified_atDate and time when the session record was modified in Sitecore CDP.ISO 8601 Date/Time UTC"2026-09-08T16:17
.000Z"
meta_browser_refThe unique browser ID generated by Sitecore CDP. This is used for guest identification.string"405bbc9f-bb43-451d-98e5-4fa899ce6a75"
session_dataA collection of name-value pair attributes that store your organization's custom session data.map <string, string>{a=alpha, b=beta}
typeThe type of session.string"WEB", "MOBILE_WEB"
raw_jsonThe overall session representation as raw JSON.JSON stringN/A

The following table describes the properties stored in the bxt map field. Different properties might be stored for different sessions.

NameDescriptionTypeExample
cartTypeThe cart interaction for the session. Possible values are:

  • "BROWSED" - no cart interaction.
  • "ABANDONED" - at least one item was added to the cart, but no transaction occurred.
  • "CONVERTED" - a successful cart transaction.
string"CONVERTED"
firstPageURIThe uniform resource identifier (URI) of the page on which this session started.string"homepage"
languageThe language for this session.string"EN"
lastPageURIThe uniform resource identifier (URI) of the page on which this session ended.string"searchpage"
numAddsThe number of items added to the cart during this session.integer2
numCheckoutsThe number of times the visitor started the checkout process.integer1
numConfirmsThe number of times the visitor confirmed payment during this session. The value is usually 0 or 1.integer1
numPaymentsThe number of times payment details were submitted during this session. The value is usually 0 or 1.integer0
numSearchesThe number of searches performed during this session.integer4
numSelectsThe number of times a product was selected (clicked) during this session.integer6
numViewsThe number of page view events recorded for this session.integer5
operatingSystemThe operating system used in this session.string"Windows 10"
userAgentThe user agent used in this session.string"Chrome 10"
utmCampaignThe UTM campaign included in this session.string"contentpromotion"
utmContentThe UTM content included in this session.string"call_to_action"
utmMediumThe UTM medium included in this session.string"social"
utmSourceThe UTM source included in this session.string"bing"
utmTermThe UTM term included in this session.string"New York"
If you have suggestions for improving this article, let us know!

Documentation Assistant

This assistant uses AI to generate responses based on Sitecore documentation. While it has access to official sources, answers may be incomplete or inaccurate and should not be considered official advice or support.
Powered by
k
kapa.ai
Protected by reCAPTCHA

© Copyright 2026, Sitecore A/S or a Sitecore affiliated company.
All rights reserved.

Privacy policySitecore Trust CenterTerms of use