Marketing Attribution
Name | Description |
Affiliate Email | Email address of the affiliate. |
Affiliate Id | Unique key generated by Chord to identify a unique affiliate. |
Affiliate Name | Full name of the user. |
Affiliate Seen Emails | List of email addresses seen. |
Affiliate User Id | Unique key generated by Chord to identify a unique user. |
Billing Address Address1 | The street address of the customer. |
Billing Address Address2 | The optional second address of the customer. |
Billing Address Alternative Phone | The customer's alternative phone number. |
Billing Address City | The city where the address is. |
Billing Address Company | A company name. |
Billing Address Country Abbr | |
Billing Address Country Name | Full name of the country. |
Billing Address Firstname | First name of the customer. |
Billing Address Id | Unique key generated by Chord to identify a unique address. |
Billing Address Lastname | Last name of the customer. |
Billing Address Oms Address Id | Unique key generated by Solidus that identifies an address. |
Billing Address Phone | The customer's phone number. |
Billing Address State Abbr | |
Billing Address State Name | Full name of the state. |
Billing Address Zipcode | The postal code. |
Order Adjustment Types | List of distinct adjustment reasons for adjustments made to the order. |
Order Admin Url | The Admin URL of pointing to the order. |
Order Applied Discount Codes | List of promotion codes applied to the order. |
Order Applied Discount Codes Count | Count of promotion codes applied to the order. |
Order Applied Discount Ids | List of promotion ids applied to the order. |
Order Applied Discount Names | List of promotion names applied to the order. |
Order Applied Discount Names Count | Count of promotion names applied to the order. |
Order Cart Url | Url of the cart which contains the order. |
Order Channel | The channel from which the order is created. |
Order Completed Order Rank By Subscription | Allows to rank completed orders by completion date for a subscription. |
Order Completed Order Rank By User | Allows to rank completed orders by completion date for a user. |
Order Contains Refund | Whether or not the order contains refund adjustments or refunds that are processed outside of the Chord OMS adjustment systems (for example via RMAs or cancellations). |
Order Contains Replacement | Whether or not the order contains replacement adjustments or shipped replacement items (following an RMA authorization). |
Order Contains Return | Whether or not the order contains returns (authorized RMAs). |
Order Contains Rma Refund | Whether or not the order contains RMA refunds (refunds issued after an RMA was requested and authorized). |
Order Contains Rma Store Credits | This column is not documented. |
Order Currency | The currency for this order. |
Order Customer Lifetime Month | Number of months between the current order's completion date and the user's first order completion date. First orders have a value of 1. |
Order Customer Lifetime Week | Number of weeks between the current order's completion date and the user's first order completion date. First orders always have a value of 1. |
Order Email | The email address of the customer that made the order. |
Order Financial State | The current payment state of the order. |
Order Fulfillment Ids | Array of unique keys generated by Chord to identify the unique shipments for an order. |
Order Fulfillment Numbers | The unique identifier for this shipment. |
Order Fulfillment State | The current shipment state of the order. |
Order Has Discount | Whether or not the order has promotions applied to it. |
Order Has Order Tags | Whether or not that order has tags. |
Order Hours From Order To First Fulfillment | Number of hours between order completion and first order shipment; how long it takes a company to get the initial product out to a customer. |
Order Hours From Order To Last Fulfillment | Number of hours between order completion and last order shipment. |
Order Id | Unique key generated by Chord to identify a unique order. |
Order Is Canceled | Whether or not the order is canceled. The order is considered canceled when the canceled_at date is not null. |
Order Is Completed | Whether or not that order is completed. The order is considered completed when the completed_at date is not null. This means that the order does not necessarily have a state = 'complete', since states can change after the order completion (for example in the case of a refund). |
Order Is First Completed Order | Whether or not that order was the first completed order for a user. |
Order Is First Order | Whether or not that order was the first order for a user. |
Order Is First Subscription Completed Order | Whether or not that order was the first completed order for a subscription. |
Order Is First Subscription Order | Whether or not that order was the first order for a subscription. |
Order Is Fulfilled | Whether or not that order has shipped. |
Order Is Part Of Subscription | Whether or not that order is part of a subscription. |
Order Is Pre Paid Purchase | Whether the order the orderincludes the purchase of a pre-payment; this could be a gift subscription, pre-pay subscription, or gift card. |
Order Is Pre Paid Redemption | Whether the order included the redemption of a pre-payment; this could be the redemption of a gift subscription, pre-pay subscription, or gift card. |
Order Is Referred By Affiliate | Whether or not the user is referred by an affiliate. |
Order Is Referred By Referrer | Whether or not the user is referred by a referrer. |
Order Is Replacement | True when the order is a replacement order. |
Order Is Suspicious Referral Conversion | Wether this represents a suspicous referral conversions or not. |
Order Item Id | Unique key generated by Chord to identify a unique order. |
Order Item Line Items Quantity | Sum of line items quantities per order. |
Order Item Product Basket | List of product names per in the order. |
Order Item Product Basket Count | Number of products in the order. |
Order Product Basket | The titles of products for a given order array converted to a string. |
Order Item Total Line Item Unit Quantity | Sum of line item units in the order. |
Order Item Total Line Items Quantity | Sum of line items quantities per order. |
Order Item Unique Product Basket | List of unique product names per in the order. |
Order Item Unique Product Basket Count | Number of unique products in the order. |
Order Unique Product Basket | The list of unique products for a given order array converted to a string. |
Order Item Unique Unit Basket | List of unique units in the order. |
Order Item Unique Unit Basket Count | Count of unique units in the order. |
Order Unit Basket | The list of units for a given order array converted to a string. |
Order Item Unique Variant Basket | List of unique variant names per in the order. |
Order Item Unique Variant Basket Count | Number of unique variants in the order. |
Order Unique Variant Basket | The list of unique variants for a given order array converted to a string. |
Order Item Unit Basket | List of all units in the order. |
Order Item Unit Basket Count | Count of all units in the order. |
Order Unique Unit Basket | The list of unique units for a given order array converted to a string. |
Order Item Variant Basket | List of variant names per in the order. |
Order Item Variant Basket Count | Number of variants in the order. |
Order Variant Basket | The titles of variants for a given order array converted to a string. |
Order Number | Human-readable unique key generated by Solidus that identifies an order. It begins with a set of Tenant-Store defined letters and ends in a nine-digit number (for example, CHORD-123456789). This number is shown to the users in various places. These combinations are unique for a given Store. |
Order Oms Order Id | Unique key generated by Solidus that identifies an order. |
Order Rank By User | Allows to rank completed orders by completion date for a user. |
Order Tags | List of tags associated to the order. |
Order Tags Count | Number of tags associated to the order. |
Order Referral Conversion Suspicious Reasons | A list of reasons explaining why the referral conversion is suspicious. |
Order Referrer User Email | The email address of the customer identified with the referral. |
Order Special Instructions | Any special shipping instructions that have been specified by the customer during checkout. |
Order State | The current state of the order. |
Order Store Id | Unique key generated by our models that uniquifies a store. |
Order Store Name | The name of the store. |
Order Store Oms Admin Url | The Admin URL of that OMS. |
Order Store Oms Id | Unique key generated by Chord that uniquifies an OMS. |
Order Store Oms Store Id | Unique key generated by our models that uniquifies a store. |
Order Store Oms Type | The type of the OMS. |
Order Store Id | Unique key generated by our models that uniquifies a store. |
Order Store Tenant Id | Unique key generated by Chord that uniquifies a tenant. |
Order Store Url | The Storefront URL of of the store. |
Order Subscription Customer Lifetime Month | Number of months between the current order's completion date and the user's first subscription order completion date. First orders have a value of 1. |
Order Subscription Customer Lifetime Week | Number of weeks between the current order's completion date and the user's first subscription order completion date. First orders always have a value of 1. |
Order User Referral Code | Unique key generated by Solidus that represents the user's referral code. |
Order Website Locale | Locale of website. This will either be collected from the url or from the drop-down link on the store. |
Referral Conversion Rank By Referrer | Allows to rank a referral conversion by referrer. |
Referral Id | Unique key generated by Chord to identify a unique referral identifier. |
Referral Is Converted | Wether this represents a converted referral or not. |
Referral Is First Conversion | Whether or not the referral was the referrer's first converted referral. |
Referral Is First Non Suspicious Conversion | Whether or not the referral was the referrer's first non suspicious converted referral. |
Referral Is Suspicious | Wether this represents a suspicous referral conversions or not. |
Referral Non Suspicious Conversion Rank By Referrer | Allows ranking of non-suspicious referral conversion by the referrer. |
Referral Oms Referral Conversion Id | Unique key generated by Solidus that identifies a referral conversion. |
Referral Suspicious Reasons | A list of reasons explaining why the referral conversion is suspicious. |
Referrer Currency | The currency for this referral identifier. |
Referrer Email | The email address of the customer identified with the referral. |
Referrer Id | Unique key generated by Chord to identify a unique referral identifier. |
Referrer Oms Referral Identifier Id | Unique key generated by Solidus that identifies a referral identifier. |
Referrer User Referral Code | Unique key generated by Solidus that represents the user's referral code. |
Shipping Address Address1 | The street address of the customer. |
Shipping Address Address2 | The optional second address of the customer. |
Shipping Address Alternative Phone | The customer's alternative phone number. |
Shipping Address City | The city where the address is. |
Shipping Address Company | A company name. |
Shipping Address Country Abbr | |
Shipping Address Country Name | Full name of the country. |
Shipping Address Firstname | First name of the customer. |
Shipping Address Id | Unique key generated by Chord to identify a unique address. |
Shipping Address Lastname | Last name of the customer. |
Shipping Address Oms Address Id | Unique key generated by Solidus that identifies an address. |
Shipping Address Phone | The customer's phone number. |
Shipping Address State Abbr | |
Shipping Address State Name | Full name of the state. |
Shipping Address Zipcode | The postal code. |
Subscription Completed Oms Order Ids | List of completed OMS order ids by a subscription. |
Subscription Completed Order Count | Total amount of orders completed by a subscription. |
Subscription Completed Order Ids | List of completed order ids by a subscription. |
Subscription First Order Unique Product Basket | Array of unique product names ordered in the first order per subscription. |
Subscription First Order Unique Variant Basket | Array of unique SKUs ordered in the first order per subscription. |
Subscription Has Subscription Tags | Whether or not the subscription has tags. |
Subscription Id | Unique key generated by Solidus that identifies a subscription. |
Subscription Interval In Days | The number of days in the subscription interval. |
Subscription Is Auto Redeemed | Whether the pre-paid subscription will be auto-redeemed or if an action is required by the recepient. |
Subscription Is Gift | Whether or not the pre-paid subscription is a gift. |
Subscription Is Recurring | Whether the pre-paid subscription is recurring. |
Subscription Last Order Unique Product Basket | Array of unique product names ordered in the latest order per subscription. |
Subscription Last Order Unique Variant Basket | Array of unique SKUs ordered in the latest order per subscription. |
Subscription Oms Pre Paid Subscription Id | ID generated by ChordOMS to identify a unique pre-paid subscription. |
Subscription Oms Subscription Id | Unique key generated by Solidus that identifies a subscription. |
Subscription Pre Paid Subscription Id | Chord generated unique id for the pre-pay subscription. |
Subscription State | The current state of the subscription, enhanced with values for `paused` if the subscription is active and paused. |
Subscription Tags | The list of tags associated with a subscription. |
Subscription Tags Count | The number of tags associated with a subscription. |
Subscription Unique Product Basket | Array of unique product names ever ordered per subscription. |
Subscription Unique Variant Basket | Array of unique SKUs ever ordered per subscription. |
User Completed Oms Order Ids | List of completed OMS order ids by a user. |
User Completed Order Ids | List of completed order ids by a user. |
User Credit Category Basket | Array of credit categories (Gift Card, Reimbursement, Referral Credits, Prepaid Subscription, GMA) issued per user. |
User Email | Email address of the user. |
User First Completed Oms Order Id | OMS order id of the first order completed by a user. |
User First Completed Order Id | Unique order id of the first order completed by a user. |
User First Order Unique Ordered Products | Unique products ordered by the user in their first completed order. |
User First Order Unique Ordered Skus | Unique SKUs ordered by the user in their first completed order. |
User Has Ordered A La Carte | Whether or not the user has had at least one order that is not part of a subscription. |
User Has Promo Applied In First Order | Whether or not the user has a promo applied to their first completed order. |
User Has Subscription In First Order | Whether or not the user's first order is linked to a subscription. |
User Id | Unique key generated by Chord to identify a unique user. |
User Is Active Subscriber | Whether or not the user has an active subscription with at least one completed subscription order. An active subscription is one that is not cancelled or paused. |
User Is Customer | Whether or not the user is a customer. |
User Is New Customer | Whether or not the user is a new customer. |
User Is Not Customer | Whether or not the user is not a customer. |
User Is Returning Customer | Whether or not the user is a returning customer. |
User Is Subscriber | Whether or not the user has completed at least one subscription order. |
User Login | The login email address of the user. |
User Name | Full name of the user. |
User Number Of Completed A La Carte Orders | Total amount of orders completed by a user that are a la carte. |
User Number Of Completed Subscription Orders | Total amount of orders completed by a user that was part of a subscription. |
User Number Of Orders With Promos | The count of completed orders with a promo applied. |
User Number Of Subscriptions | Total amount of subscriptions linked to a user. |
User Oms User Id | Unique key generated by Solidus that identifies a user. |
User Phone | Phone number of the user. |
User Total Completed Order Count | Total amount of orders completed by a user. |
User Unique Ordered Products | Unique products ordered by the user across all orders. |
User Unique Ordered Skus | Unique SKUs ordered by the user across all orders. |
Billing Address Created At (Universal) | Timestamp at which the address row was created - Universal Time Zone. |
Billing Address Updated At (Universal) | Timestamp at which the address row was last updated - Universal Time Zone. |
Order Approved At (Universal) | Reflects when the entity was approved in Solidus - Universal Time Zone. |
Order Canceled At (Universal) | Reflects when the order was cancelled - Universal Time Zone. |
Order Completed At (Central) | Reflects when the entity was moved to the 'completed' state - Cental Time Zone. |
Order Completed At (Eastern) | Reflects when the entity was moved to the 'completed' state - Eastern Time Zone. |
Order Completed At (Mountain) | Reflects when the entity was moved to the 'completed' state - Mountain Time Zone. |
Order Completed At (Pacific) | Reflects when the entity was moved to the 'completed' state - Pacific Time Zone. |
Order Completed At (Universal) | Reflects when the entity was moved to the 'completed' state - Universal Time Zone. |
Order Created At (Central) | Reflects when the entity was first created in Solidus - Cental Time Zone. |
Order Created At (Eastern) | Reflects when the entity was first created in Solidus - Eastern Time Zone. |
Order Created At (Mountain) | Reflects when the entity was first created in Solidus - Mountain Time Zone. |
Order Created At (Pacific) | Reflects when the entity was first created in Solidus - Pacific Time Zone. |
Order Created At (Universal) | Reflects when the entity was first created in Solidus - Universal Time Zone. |
Order First Fulfillment Fulfilled At (Universal) | Timestamp at which the first shipment for that order was shipped - Universal Time Zone. |
Order Last Adjustment Refund At (Universal) | Timestamp of the last return adjustment for an order - Universal Time Zone. |
Order Last Adjustment Replacement At (Universal) | Timestamp of the last replacement adjustment for an order - Universal Time Zone. |
Order Last Fulfillment Fulfilled At (Universal) | Timestamp at which the last shipment for that order was shipped - Universal Time Zone. |
Order Updated At (Universal) | Reflects when the entity was last updated in Solidus - Universal Time Zone. |
Referral Converted At (Universal) | Reflects when the referral entity was first converted in Solidus - Universal Time Zone. |
Referral Created At (Universal) | Reflects when the entity was first created in Solidus - Universal Time Zone. |
Referral Updated At (Universal) | Reflects when the entity was last updated in Solidus - Universal Time Zone. |
Referrer Created At (Universal) | Reflects when the entity was first created in Solidus - Universal Time Zone. |
Referrer Updated At (Universal) | Reflects when the entity was last updated in Solidus - Universal Time Zone. |
Shipping Address Created At (Universal) | Timestamp at which the address row was created - Universal Time Zone. |
Shipping Address Updated At (Universal) | Timestamp at which the address row was last updated - Universal Time Zone. |
Subscription Actionable Date (Universal) | The date of the next subscription installment. This date is updated after each successful installment. Subscriptions in an inactive state will be null - Universal Time Zone. |
Subscription Created At (Universal) | Reflects when the entity was first created in Solidus - Universal Time Zone. |
Subscription First Order Completed At (Universal) | The timestamp of the subscription's first completed order - Universal Time Zone. |
Subscription Last Order Completed At (Universal) | The timestamp of the subscription's last completed order - Universal Time Zone. |
Subscription Updated At (Universal) | Reflects when the entity was last updated in Solidus - Universal Time Zone. |
User Created At (Universal) | Timestamp at which the users row was created - Universal Time Zone. |
User Date Of Birth (Universal) | Date of birth of the user - Universal Time Zone. |
User Deleted At (Universal) | Timestamp at which the user's account was deleted - Universal Time Zone. |
User First Order Completed At (Universal) | The timestamp of the user's first completed order - Universal Time Zone. |
User First Subscription Order Completed At (Universal) | The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone. |
User Last Order Completed At (Universal) | The timestamp of the user's last completed order - Universal Time Zone. |
User Last Sign In At (Universal) | The last sign in timestamp for the user - Universal Time Zone. |
User Updated At (Universal) | Timestamp at which the users row was last updated - Universal Time Zone. |
Average Additional Tax Total | Total additional taxes for an order. |
Average Adjustment Fulfillment Tax Total | Total adjustment shipment taxes for an order. |
Average Adjustment Fulfillment Total | Total shipment adjustments applied to an order. |
Average Adjustment Other Charges Total | Total of included additional adjustment charges paid for an order. |
Average Adjustment Other Credits Total | Total of credits issued for an order. |
Average Adjustment Refund Total | Total of return dollars for an order. |
Average Adjustment Replacement Total | Total of replacement dollars for an order. |
Average Adjustment Rma Refund Total | Total of refund dollards associated to an order that was returned via the RMA functionality of the Chord OMS. |
Average Adjustment Tax Total | Total adjustment taxes an order. |
Average Adjustment Total | Total of adjustment applied for an order as on the order. |
Average Applied Gift Card Total | Total of gift card dollars that were used as a payment method in the order |
Average Commission Total | Commission for an order. |
Average Fulfillment Total | Total shipment for an order. |
Average Gross Revenue | Gross amount of revenue generated by the order including items and shipments totals. Gross revenue = total - included_tax_total + shipment_total - purchased_gift_card_total - pre-payment subscription purchase amount |
Average Included Tax Total | Total included taxes for an order. |
Average Item Total | Total price for the order before adjustments. |
Average Net Revenue | Net revenue generated by the order's items after promotions. Net revenue = total - included_tax_total + shipment_total + adjustment_total - additional_tax_total - purchased_gift_card_total - pre-payment subscription purchase amount |
Average Pre Paid Purchase Total | The amount of the order that was purchased as a pre-payment; this could be a gift subscription, pre-pay subscription, or gift card. |
Average Pre Paid Redemption Total | The amount of the order that was the redemption of a pre-payment; this could be the redemption of a gift subscription, pre-pay subscription, or gift card. |
Average Promo Total | Promotions applied to an order. |
Average Purchased Gift Card Total | Total of gift card dollars that were purchased in the order. |
Average Reimbursement Credit Total | The amount of store credits owed back in an order |
Average Tax Total | Total taxes for an order. |
Average Total Price | Total to be paid by the customer for an order. |
Average Transaction Total | Total paid by the customer for a completed order. |
Additional Tax Total | Total additional taxes for an order. |
Adjustment Fulfillment Tax Total | Total adjustment shipment taxes for an order. |
Adjustment Fulfillment Total | Total shipment adjustments applied to an order. |
Adjustment Other Charges Total | Total of included additional adjustment charges paid for an order. |
Adjustment Other Credits Total | Total of credits issued for an order. |
Adjustment Refund Total | Total of return dollars for an order. |
Adjustment Replacement Total | Total of replacement dollars for an order. |
Adjustment Rma Refund Total | Total of refund dollards associated to an order that was returned via the RMA functionality of the Chord OMS. |
Adjustment Tax Total | Total adjustment taxes an order. |
Adjustment Total | Total of adjustment applied for an order as on the order. |
Applied Gift Card Total | Total of gift card dollars that were used as a payment method in the order |
Commission Total | Commission for an order. |
Fulfillment Total | Total shipment for an order. |
Gross Revenue | Gross amount of revenue generated by the order including items and shipments totals. Gross revenue = total - included_tax_total + shipment_total - purchased_gift_card_total - pre-payment subscription purchase amount |
Included Tax Total | Total included taxes for an order. |
Item Total | Total price for the order before adjustments. |
Net Revenue | Net revenue generated by the order's items after promotions. Net revenue = total - included_tax_total + shipment_total + adjustment_total - additional_tax_total - purchased_gift_card_total - pre-payment subscription purchase amount |
Pre Paid Purchase Total | The amount of the order that was purchased as a pre-payment; this could be a gift subscription, pre-pay subscription, or gift card. |
Pre Paid Redemption Total | The amount of the order that was the redemption of a pre-payment; this could be the redemption of a gift subscription, pre-pay subscription, or gift card. |
Total Price | Total to be paid by the customer for an order. |
Promo Total | Promotions applied to an order. |
Purchased Gift Card Total | Total of gift card dollars that were purchased in the order. |
Reimbursement Credit Total | The amount of store credits owed back in an order |
Tax Total | Total taxes for an order. |
Transaction Total | Total paid by the customer for a completed order. |
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. |
Name | Description |
User Completed Order Numbers | User completed order numbers |