Activities
x_fct_trans_activities
Activity Event Text
The name of the event.
Activity Event Text Id
The slug of the event name, mapping to the page or track event table.
Activity Id
The unique identifier of an activities (i.e. Track or Page event).
Activity 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.)
Activity Page Query
The query string portion of the URL of the page.
Activity Page Title
The title/name of the page.
Activity Page Url
The URL of the page.
Activity Session Activity Count
Total count of activities, pave views and tracked events within the session.
Activity 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.
Activity 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'.
Activity Session Attribution First Page Url Has Gclid
Indicates if the first page event of the session has a Google Click ID.
Activity Session Attribution First Page Url Has Utm
Indicates if the first page event of the session has any utm information.
Activity Session Attribution Has Referrer
Indicates if the first page event of the session has a referrer host.
Activity Session Attribution Medium
The campaign medium represented by the UTM tags for the first page event of the session.
Activity Session Attribution Source
The campaign source represented by the UTM tags for the first page event of the session.
Activity Session Attribution Sub Channel
Sub-Channel is a granular level of attribution.
Activity 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.
Activity Session Completed Order Ids
Array of order IDs associated to the session_id, as collected by order completed or checkout completed front-end events.
Activity Session Completed Order Numbers
Array of order numbers associated to the session_id, as collected by order completed or checkout completed front-end events.
Activity Session Days Since Last Session End
The days between the last session's end and the start of this session.
Activity Session Device
The device on which the event was sent from.
Activity 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',
Activity Session Duration In Seconds
Total seconds between start and end activities within the session.
Activity 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.
Activity Session Has Order Completion
Flag for sessions with an order completed or checkout completed front-end events
Activity Session Id
Unique ID for the session.
Activity Session Number
Session number per anonymous id.
Activity 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.
Activity 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.
Activity Utm Campaign
The campaign name represented by the UTM tags.
Activity Utm Content
The campaign content represented by the UTM tags.
Activity Utm Medium
The campaign medium represented by the UTM tags.
Activity Utm Source
The campaign source represented by the UTM tags.
Activity Utm Term
The campaign term represented by the UTM tags.
Activity Website Locale
Locale of website. This will either be collected from the url or from the drop-down link on the store
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.
Date Day Num Of Year
The number representing the day of the year.
Date Id
Unique key that uniquify a date.
Date Month Num Of Year
The month number of the year.
Last Seen Page Browser Locale
Locale of browser.
Last Seen Page Device
The device on which the event was sent from.
Last Seen 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 Seen Page Event Table Name
The properly formatted name of the table of the event.
Last Seen Page Event Text
The name of the event.
Last Seen Page Event Text Id
The slug of the event name, mapping to the page or track event table.
Last Seen 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 Seen Page Id
Unique key generated by Segment for each tracking or page event.
Last Seen Page Oms Id
Unique key generated by our models that uniquifies an OMS.
Last Seen 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 Seen 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 Seen Page Query
The query string portion of the URL of the page.
Last Seen Page Referrer
The referrer of the page. The referrer is the webpage that sends visitors to the site using a link. In
Last Seen Page Title
The title/name of the page.
Last Seen Page Url
The URL of the page.
Last Seen 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 Seen Page Segment User Id
The unique ID of the user.
Last Seen Page Store Id
Unique key generated by our models that uniquifies a store.
Last Seen Page Tenant Id
Unique key generated by Chord that uniquifies a tenant.
Last Seen 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 Seen Page User Id
Unique key generated by Chord to identify the user.
Last Seen Page Utm Campaign
The campaign name represented by the UTM tags.
Last Seen Page Utm Content
The campaign content represented by the UTM tags.
Last Seen Page Utm Medium
The campaign medium represented by the UTM tags.
Last Seen Page Utm Source
The campaign source represented by the UTM tags.
Last Seen Page Utm Term
The campaign term represented by the UTM tags.
Last Seen Page Website Locale
Locale of website. This will either be collected from the url or from the drop-down link on the store
Session Landing Page Browser Locale
Locale of browser.
Session Landing Page Device
The device on which the event was sent from.
Session 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 ,
Session Landing Page Event Table Name
The properly formatted name of the table of the event.
Session Landing Page Event Text
The name of the event.
Session Landing Page Event Text Id
The slug of the event name, mapping to the page or track event table.
Session 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.
Session Landing Page Id
Unique key generated by Segment for each tracking or page event.
Session Landing Page Oms Id
Unique key generated by our models that uniquifies an OMS.
Session 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.
Session 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.)
Session Landing Page Query
The query string portion of the URL of the page.
Session Landing Page Referrer
The referrer of the page. The referrer is the webpage that sends visitors to the site using a link. In
Session Landing Page Title
The title/name of the page.
Session Landing Page Url
The URL of the page.
Session 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.
Session Landing Page Segment User Id
The unique ID of the user.
Session Landing Page Store Id
Unique key generated by our models that uniquifies a store.
Session Landing Page Tenant Id
Unique key generated by Chord that uniquifies a tenant.
Session 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
Session Landing Page User Id
Unique key generated by Chord to identify the user.
Session Landing Page Utm Campaign
The campaign name represented by the UTM tags.
Session Landing Page Utm Content
The campaign content represented by the UTM tags.
Session Landing Page Utm Medium
The campaign medium represented by the UTM tags.
Session Landing Page Utm Source
The campaign source represented by the UTM tags.
Session Landing Page Utm Term
The campaign term represented by the UTM tags.
Session Landing Page Website Locale
Locale of website. This will either be collected from the url or from the drop-down link on the store
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.
Last updated
Was this helpful?