Activities
Name | Description |
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. |
Activity Session End Ts (Universal) | Last activity timestamp for a session - Universal Time Zone. |
Activity 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. |
Activity 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. |
Activity Session Start Ts (Central) | First activity timestamp for a session - Cental Time Zone. |
Activity Session Start Ts (Eastern) | First activity timestamp for a session - Eastern Time Zone. |
Activity Session Start Ts (Mountain) | First activity timestamp for a session - Mountain Time Zone. |
Activity Session Start Ts (Pacific) | First activity timestamp for a session - Pacific Time Zone. |
Activity Session Start Ts (Universal) | First activity timestamp for a session - Universal Time Zone. |
Activity Ts (Central) | The timestamp calculated by Segment correcting clock skew - Cental Time Zone. |
Activity Ts (Eastern) | The timestamp calculated by Segment correcting clock skew - Eastern Time Zone. |
Activity Ts (Mountain) | The timestamp calculated by Segment correcting clock skew - Mountain Time Zone. |
Activity Ts (Pacific) | The timestamp calculated by Segment correcting clock skew - Pacific Time Zone. |
Activity Ts (Universal) | The timestamp calculated by Segment correcting clock skew - Universal Time Zone. |
Last Seen Page Ts (Universal) | The timestamp calculated by Segment correcting clock skew - Universal Time Zone. |
Session Landing Page Ts (Universal) | The timestamp calculated by Segment correcting clock skew - 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. |
Name | Description |
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. |
Ts (Universal) | The truncated UTC date the order was created - Universal Time Zone. |
Average Completed Order Count | The total count of orders created on the UTC date that have been completed. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. |
Average Created Order Count | The total count of orders created on the UTC date. |
Average Gross Sales | The gross sales for completed orders. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. |
Average Net Revenue | The net sales for completed orders. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. |
Average Placed Gross Revenue | Gross Revenue is the pre-tax, pre-adjusted total line item price (unit price * quantity) + the fulfillment total. |
Average Placed Net Revenue | Net Revenue is the adjusted line item price (unit price * quantity - line adjustments) + the adjusted fulfillment (fulfillment total - line adjustments) - order level adjustments - refunds. |
Completed Order Count | The total count of orders created on the UTC date that have been completed. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. |
Created Order Count | The total count of orders created on the UTC date. |
Gross Sales | The gross sales for completed orders. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. |
Net Revenue | The net sales for completed orders. An order is considered complete if it has a status of 'Fulfilled' or 'Returned' or it has a status 'Canceled' and has a payment associated with it. |
Placed Gross Revenue | Gross Revenue is the pre-tax, pre-adjusted total line item price (unit price * quantity) + the fulfillment total. |
Placed Net Revenue | Net Revenue is the adjusted line item price (unit price * quantity - line adjustments) + the adjusted fulfillment (fulfillment total - line adjustments) - order level adjustments - refunds. |