Marketing Attribution

3min

extend_x_fct_trans_orders_for_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.
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.
user_completed_order_numbers
Name
Description
User Completed Order Numbers
User completed order numbers
﻿

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

Updated 20 Sep 2024

Did this page help you?

Line Items By Units

Orders