Chord Commerce Data Platform
...
Chord Data Attribute Definitio...
Shopify

Sessions

1min

x_fct_trans_sessions

Name

Description

Anonymous Completed Oms Order Ids

Array of OMS Order IDs associated to the anonymous_id, as collected by order completed or checkout completed front-end events, over time.

Anonymous Completed Order Ids

Array of order IDs associated to the anonymous_id, as collected by order completed or checkout completed front-end events, over time.

Anonymous Completed Order Numbers

Array of order numbers associated to the anonymous_id, as collected by order completed or checkout completed front-end events, over time.

Anonymous Current Blended User Id

Unique id derived from the user_id and the anonymous_id. Whenever a customer has a user_id, the user_anonymous_id will be constant for

Anonymous Current User Id

The current user_id associated with the anonymous_id. This unique user_id is created by Segment's Identify call. A user_id can be associated to many anonymous_ids.

Anonymous Id

Unique id created by Chord for each anonymous visitor per store.

Anonymous Segment Anonymous Id

Id created by Segment for each anonymous visitor. This id gets created as soon as a customer's browser loads the analytics javascript widget. The anonymous_id remains unchanged through the entire browsing session from a single device. Depending on configuration, two stores connected stores may have the same anonymous_id.

Anonymous Unique User Ids

Array of user IDs mapped to an anonymous ID.

Attribution Point First Touch

The first session associated with the user prior to conversion receives 100% of the attribution, all other sessions recieve 0 points. Reflected with a value of 0 or 1.

Attribution Point Forty Twenty Forty

The first and last sessions associated with the user prior to conversion receive 40% of the attribution points each, the remaining middle-touch sessions receive an equal portion of the 20%; 0.4, 0.4, and 0.2/number of remaining sessions.

Attribution Point Id

Sessions for a user that occor prior to conversion, or first completed order.

Attribution Point Last Touch

The last session associated with the user prior to conversion receives 100% of the attribution, all other sessions recieve 0 points. Reflected with a value of 0 or 1.

Attribution Point Linear

All sessions for the user prior to conversion recieve an equal percentage of the attribution points; calculated as 1.0 / number of sessions

End Date Day Num Of Year

The number representing the day of the year.

End Date Id

Unique key that uniquify a date.

End Date Month Num Of Year

The month number of the year.

Landing Page Browser Locale

Locale of browser.

Landing Page Device

The device on which the event was sent from.

Landing Page Device Category

The device category of the device on which the event was sent from. There are multiple supported values for this column such as 'iPhone',

Landing Page Event Table Name

The properly formatted name of the table of the event.

Landing Page Event Text

The name of the event.

Landing Page Event Text Id

The slug of the event name, mapping to the page or track event table.

Landing Page Gclid

The Google Click ID. Google Click ID (GCLID) is a parameter passed in the URL with ad clicks, to identify the campaign and other attributes of the click associated with the ad for ad tracking and campaign attribution.

Landing Page Id

Unique key generated by Segment for each tracking or page event.

Landing Page Oms Id

Unique key generated by our models that uniquifies an OMS.

Landing Page Host

The host of the event's URL. For example https://www.store-staging.assembly.dev/myPage would become store-staging.assembly.dev. This facilitates grouping events by host.

Landing Page Path

The page path part of the URL. A page path is the part of URL that comes after the hostname (domain) and before the query parameters, URL fragment, or port. (e.g. /pages/contact-us/ for https://chord.co/pages/contact-us/?ref=internal-banner.)

Landing Page Query

The query string portion of the URL of the page.

Landing Page Referrer

The referrer of the page. The referrer is the webpage that sends visitors to the site using a link. In

Landing Page Title

The title/name of the page.

Landing Page Url

The URL of the page.

Landing Page Referrer Host

The host of the referrer. For example https://www.store-staging.assembly.dev/myPage would become store-staging.assembly.dev. This facilitates grouping events by host.

Landing Page Segment User Id

The unique ID of the user.

Landing Page Store Id

Unique key generated by our models that uniquifies a store.

Landing Page Tenant Id

Unique key generated by Chord that uniquifies a tenant.

Landing Page User Agent

The User agent of the device making the request. A User agent request header is a characteristic string that lets servers and

Landing Page User Id

Unique key generated by Chord to identify the user.

Landing Page Utm Campaign

The campaign name represented by the UTM tags.

Landing Page Utm Content

The campaign content represented by the UTM tags.

Landing Page Utm Medium

The campaign medium represented by the UTM tags.

Landing Page Utm Source

The campaign source represented by the UTM tags.

Landing Page Utm Term

The campaign term represented by the UTM tags.

Landing Page Website Locale

Locale of website. This will either be collected from the url or from the drop-down link on the store

Last Page Browser Locale

Locale of browser.

Last Page Device

The device on which the event was sent from.

Last Page Device Category

The device category of the device on which the event was sent from. There are multiple supported values for this column such as 'iPhone',

Last Page Event Table Name

The properly formatted name of the table of the event.

Last Page Event Text

The name of the event.

Last Page Event Text Id

The slug of the event name, mapping to the page or track event table.

Last Page Gclid

The Google Click ID. Google Click ID (GCLID) is a parameter passed in the URL with ad clicks, to identify the campaign and other attributes of the click associated with the ad for ad tracking and campaign attribution.

Last Page Id

Unique key generated by Segment for each tracking or page event.

Last Page Oms Id

Unique key generated by our models that uniquifies an OMS.

Last Page Host

The host of the event's URL. For example https://www.store-staging.assembly.dev/myPage would become store-staging.assembly.dev. This facilitates grouping events by host.

Last Page Path

The page path part of the URL. A page path is the part of URL that comes after the hostname (domain) and before the query parameters, URL fragment, or port. (e.g. /pages/contact-us/ for https://chord.co/pages/contact-us/?ref=internal-banner.)

Last Page Query

The query string portion of the URL of the page.

Last Page Referrer

The referrer of the page. The referrer is the webpage that sends visitors to the site using a link. In

Last Page Title

The title/name of the page.

Last Page Url

The URL of the page.

Last Page Referrer Host

The host of the referrer. For example https://www.store-staging.assembly.dev/myPage would become store-staging.assembly.dev. This facilitates grouping events by host.

Last Page Segment User Id

The unique ID of the user.

Last Page Store Id

Unique key generated by our models that uniquifies a store.

Last Page Tenant Id

Unique key generated by Chord that uniquifies a tenant.

Last Page User Agent

The User agent of the device making the request. A User agent request header is a characteristic string that lets servers and

Last Page User Id

Unique key generated by Chord to identify the user.

Last Page Utm Campaign

The campaign name represented by the UTM tags.

Last Page Utm Content

The campaign content represented by the UTM tags.

Last Page Utm Medium

The campaign medium represented by the UTM tags.

Last Page Utm Source

The campaign source represented by the UTM tags.

Last Page Utm Term

The campaign term represented by the UTM tags.

Last Page Website Locale

Locale of website. This will either be collected from the url or from the drop-down link on the store

Session Activity Count

Total count of activities, pave views and tracked events within the session.

Session Attribution Channel

The attribution channel for the first page event of the session. Sessions with an attribution of 'Unknown' indicates that there is no attributable data for that session.

Session Attribution Channel Paid Or Organic

Indicates if the session's first page attribution is paid or organic. Attribution is considered Organic if the attribution channel is 'Direct', 'Other', 'Organic Search', 'Organic Social', 'Email', or 'SMS'.

Session Attribution First Page Url Has Gclid

Indicates if the first page event of the session has a Google Click ID.

Session Attribution First Page Url Has Utm

Indicates if the first page event of the session has any utm information.

Session Attribution Has Referrer

Indicates if the first page event of the session has a referrer host.

Session Attribution Medium

The campaign medium represented by the UTM tags for the first page event of the session.

Session Attribution Source

The campaign source represented by the UTM tags for the first page event of the session.

Session Attribution Sub Channel

Sub-Channel is a granular level of attribution.

Session Completed Oms Order Ids

Array of OMS Order IDs associated to the session_id, as collected by order completed or checkout completed front-end events.

Session Completed Order Ids

Array of order IDs associated to the session_id, as collected by order completed or checkout completed front-end events.

Session Completed Order Numbers

Array of order numbers associated to the session_id, as collected by order completed or checkout completed front-end events.

Session Days Since Last Session End

The days between the last session's end and the start of this session.

Session Device

The device on which the event was sent from.

Session Device Category

The device category of the device on which the event was sent from. There are multiple supported values for this column such as 'iPhone',

Session Duration In Seconds

Total seconds between start and end activities within the session.

Session Duration In Seconds Tiers

Total seconds between start and end activities within the session, aggregated into tiers: 0-9s, 10-29s, 30-59s, and 60s or more.

Session Has Order Completion

Flag for sessions with an order completed or checkout completed front-end events

Session Id

Unique ID for the session.

Session Number

Session number per anonymous id.

Session Unique Completed Order Count

Count of unique order ids associated to the session_id, as collected by order completed or checkout completed front-end events.

Session Unique Completed Order Number Count

Count of unique order numbers associated to the session_id, as collected by order completed or checkout completed front-end events.

Start Date Day Num Of Year

The number representing the day of the year.

Start Date Id

Unique key that uniquify a date.

Start Date Month Num Of Year

The month number of the year.

Store Id

Unique key generated by our models that uniquifies a store.

Store Name

The name of the store.

Store Oms Admin Url

The Admin URL of that OMS.

Store Oms Id

Unique key generated by Chord that uniquifies an OMS.

Store Oms Store Id

Unique key generated by our models that uniquifies a store.

Store Oms Type

The type of the OMS.

Store Id

Unique key generated by our models that uniquifies a store.

Store Tenant Id

Unique key generated by Chord that uniquifies a tenant.

Store Url

The Storefront URL of of the store.

User Address 1

The first line of the street address.

User Address 2

The optional second line of the address.

User Address City

The city of the address.

User Address Country

The country of the address.

User Address Name

The full name of the customer, based on firstName and lastName.

User Address State

The region of the address, such as the province, state, or district.

User Address Zip

The postal code of the address.

User Completed Oms Order Ids

Array of OMS Order IDs associated to the user_id, as collected by order completed or checkout completed front-end events, over time.

User Completed Order Ids

Array of order IDs associated to the user_id, as collected by order completed or checkout completed front-end events, over time.

User Completed Order Numbers

Array of order numbers associated to the user_id, as collected by order completed or checkout completed front-end events, over time.

User Email

The email associated with the user.

User Id

Unique ID per user. It is equal to either 1) a identified_user_id as identified by Segment in the Identify call, or 2) an anonynous_id.

User Identified User Id

Unique ID per identified user. (See Segment's documentation on user_id)[ https://segment.com/docs/connections/spec/identify/#user-id ].

User Ip

IP address associated with the user.

User Last Anonymous Id

Last seen anonymous_id per user. An anonymous_id is a unique ID per anonymous visitor. (See Segment's documentation on anonymous_id)[ https://segment.com/docs/connections/spec/identify/#anonymous-id ].

User Last Segment Anonymous Id

This column is not documented.

User Segment User Id

The unique ID of the user.

User Unique Anonymous Ids

Array of all seen anonymous_ids per user. An anonymous_id is a unique ID per anonymous visitor. (See Segment's documentation on anonymous_id)[ https://segment.com/docs/connections/spec/identify/#anonymous-id ].

User Unique Completed Order Count

Count of unique order ids associated to the user_id, as collected by order completed or checkout completed front-end events, over time.

End Ts (Universal)

Last activity timestamp for a session - Universal Time Zone.

Landing Page Ts (Universal)

The timestamp calculated by Segment correcting clock skew - Universal Time Zone.

Last Page Ts (Universal)

The timestamp calculated by Segment correcting clock skew - Universal Time Zone.

Session End Ts (Universal)

Last activity timestamp for a session - Universal Time Zone.

Session Last Session End Ts (Universal)

The timestamp of the previous session's end per blended user id, if this is not the user's first session - Universal Time Zone.

Session Last Session Start Ts (Universal)

The timestamp of the previous session's start per blended user id, if this is not the user's first session - Universal Time Zone.

Session Start Ts (Central)

First activity timestamp for a session - Cental Time Zone.

Session Start Ts (Eastern)

First activity timestamp for a session - Eastern Time Zone.

Session Start Ts (Mountain)

First activity timestamp for a session - Mountain Time Zone.

Session Start Ts (Pacific)

First activity timestamp for a session - Pacific Time Zone.

Session Start Ts (Universal)

First activity timestamp for a session - Universal Time Zone.

Start Ts (Central)

First activity timestamp for a session - Cental Time Zone.

Start Ts (Eastern)

First activity timestamp for a session - Eastern Time Zone.

Start Ts (Mountain)

First activity timestamp for a session - Mountain Time Zone.

Start Ts (Pacific)

First activity timestamp for a session - Pacific Time Zone.

Start Ts (Universal)

First activity timestamp for a session - Universal Time Zone.

User Created At (Universal)

The timestamp when the user was created - Universal Time Zone.

User First Seen At (Universal)

The first time the user was seen on the site, identified as either anonymous ID or user ID - Universal Time Zone.



Updated 20 Sep 2024
Did this page help you?