Marketing Attribution

2min

x_fct_trans_order
Name
Description
Billing Address 1
The street address of the billing address.
Billing Address 2
An additional field for the street address of the billing address.
Billing Address City
The city, town, or village of the billing address.
Billing Address Company
The company associated to this billing address.
Billing Address Country
The name of the country of the billing address.
Billing Address Country Code
The two-letter code (ISO 3166-1 format) for the country of the billing address.
Billing Address First Name
The first name of the person associated to this billing address.
Billing Address Id
Unique identifier generated by Chord for a Billing Address.
Billing Address Last Name
The last name of the person associated to this billing address.
Billing Address Latitude
The latitude of the billing address.
Billing Address Longitude
The longitude of the billing address.
Billing Address Name
The full name of the person associated to this billing address.
Billing Address Oms Billing Address Id
Unique key generated by Shopify that identifies a billing address.
Billing Address Phone
The phone number associated to this billing address.
Billing Address Province
The name of the region (province, state, prefecture, …) of the billing address.
Billing Address Province Code
The two-letter abbreviation of the region of the billing address.
Billing Address Zip
The postal code of the billing address.
First Fulfillment Id
Unique identifier for a Shopify Fulfillment at a specific point in time
First Fulfillment Oms Fulfillment Id
Unique key generated by Shopify that identifies a fulfillment.
First Fulfillment Shipment Status
Represent the status of the shipment.
First Fulfillment Status
The status of the fulfillment.
First Fulfillment Tracking Company
The name of the tracking company.
First Fulfillment Tracking Numbers
A list of tracking numbers provided by the tracking company.
First Fulfillment Tracking Urls
The URLs of tracking pages for the fulfillment.
Last Transaction Amount
The amount of money included in the transaction.
Last Transaction Error Code
The error code explaining why the transaction failed.
Last Transaction Gateway
The name of the gateway the transaction was issued through.
Last Transaction Id
Unique identifier for a Shopify Transaction at a specific point in time
Last Transaction Is Failed
Whether or not the transaction / payment has failed.
Last Transaction Is Successful
Whether or not the transaction / payment has succeeded.
Last Transaction Is Test
Whether this is a test transaction or not.
Last Transaction Kind
The type of transaction.
Last Transaction Message
Additional information provided the payment provider about the transaction.
Last Transaction Oms Transaction Id
Unique key generated by Shopify that identifies a transaction.
Last Transaction Status
The status of the transaction.
Location Id
Unique identifier for a Shopify Location at a specific point in time
Location Is Active
Whether the location is active or not.
Location Is Online
Whether or not this location represents an online location.
Location Is Physical
Whether or not this location represents a physical location.
Location Name
The name of a location.
Location Oms Location Id
Unique key generated by Shopify that identifies a location.
Order Admin Url
Contains the full URL directing to the admin dashboard of Shopify for that given order.
Order App Id
The ID of the app from Shopify that created the order.
Order App Name
App name associated with the app id. This field will be generated if the Hub Configuration is enabled and the value has been set.
Order Applied Discount Codes
The discount 'codes' applied or a given order.
Order Applied Discount Codes Count
The total number of applied discount code for a given order.
Order Cancel Reason
The reason as to why the order was cancelled.
Order Cart Website Locale
When available, this is the shopify international site activated prior to cart creation.
Order Completed Order Rank By User
Allows to rank customer carts by completion date. In other words, this will rank the customer's completed order from 1 to X (X being the most recent order that was completed).
Order Completed Subscription Order Rank By User
Allows to rank customer subscription orders by completion date.
Order Contains First Subscription Order
A boolean value to indicate whether an order contains the first subscription order or not. An order may contain a mix of first and recurring subscriptions.
Order Created Order Rank By User
Allows to rank customer carts by creation date. In other words, this will rank the customer's creation order from 1 to X (X being the last order that was created). An order can be created but never completed.
Order Created Subscription Order Rank By User
Allows to rank customer subscription orders by creation date.
Order Customer Lifetime Month
Number of months between the current order's creation date and the user's first order creation date. First orders have a value of 1.
Order Customer Lifetime Week
Number of weeks between the current order's creation date and the user's first order creation date. First orders always have a value of 1.
Order Filtered Order
Whether or not this order will be flagged by custom filter.
Order Financial State
The status of transaction associated with the order.
Order Fulfillment State
The summarized status of the 'shipment/fulfillment' associated with the order.
Order Has Discount
Whether or not the order has had a discount applied to it.
Order Has Order Tag
Whether or not the order has an order tag applied to it.
Order Id
Unique identifier generated by Chord for an order.
Order Included Fulfillment Codes
Aggregated array of fulfillment codes, represented as a string.
Order Included Fulfillment Methods
Aggregated array of fulfillment methods, represented as a string.
Order Included Payment Gateways
This is the rolled up successful payment gateway for an order. Successful payments are included if they are sale or capture transactions.
Order Included Source Subscription Ids
String list of included source subscription ids per order. Subscription information received from tenant-enabled platforms including Recharge and Shopify Plus.
Order Included Subscription Ids
String list of included subscription ids per order. Subscription information received from tenant-enabled platforms including Recharge and Shopify Plus.
Order Is Admin
Whether or not the order was created by an admin.
Order Is Cancelled
Whether or not the order was cancelled. If `cancelled_at` is non-null then we consider the order has being cancelled.
Order Is Completed
Whether or not the order was completed. An order is considered completed if it has a closed_at timestamp and has been fully fulfilled. Closed_at is generated for orders in Shopify that are automatically archived. If this feature is not enabled, the last updated closed fulfillment date is used as the completed at date.
Order Is First Completed Order
Whether the order was the customer's first completed order or not.
Order Is First Order
Whether the order was the customer's first order or not.
Order Is First Subscription Completed Order
Whether the order was the customer's first completed subscription order or not.
Order Is First Subscription Order
Whether the order was the customer's first subscription order or not.
Order Is Part Of Subscription
Boolean flag to indicate whether the order was a part of a subscription plan or not.
Order Is Test
Whether this is a test order or not.
Order Item Id
Unique identifier generated by Chord for an order.
Order Item Is First Product Type Order
Whether this order contains the first product type basket for the user.
Order Item Is Last Product Type Order
Whether this order contains the last, most recent, product type basket for the user.
Order Item Is Repeat Product Type Order
Whether this order contains a repeat product type basket for the user.
Order Item Product Basket Count
The count of products for a given order.
Product Basket
The titles of products for a given orderarray converted to a string.
Order Item Product Purchased Quantity
The total number of product purchased for a given order.
Order Item Rank Product Type Order
Rank orders with the same product type basket per user.
Order Item Unique Product Basket Count
The count of unique products for a given order.
Unique Product Basket
The unique titles of products for a given order array converted to a string.
Order Item Unique Product Type
The unique line item product types for a given order.
Order Item Unique Variant Basket Count
The count of unique SKUs for a given order.
Unique Variant Basket
The unique SKUs of variants for a given order array converted to a string.
Order Item Variant Basket Count
The count of variants for a given order.
Variant Basket
The SKUs of variants for a given order array converted to a string.
Order Item Variant Purchased Quantity
The total number of variants purchased for a given order.
Order Name
Unique name generated by Shopify that is displayed to the customer (e.g.
Order Number Of Non Reactivated Subscriptions
Number of non reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Order Number Of Reactivated Subscriptions
Number of reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Order Oms Order Id
Unique key generated by Shopify that identifies an order.
Order Tags
The order tags applied to a given order, in alphabetical order.
Order Tags Count
The total number of order tags for a given order.
Order Processing Method
How the payment was processed.
Order Segment Anonymous Id
When available, this is where we store Segment's anonymous_id at the time of checkout.
Order Source Name
Where did the order get created from.
Shipping Address 1
The street address of the shipping address.
Shipping Address 2
An additional field for the street address of the shipping address.
Shipping Address City
The city, town, or village of the shipping address.
Shipping Address Company
The company associated to this shipping address.
Shipping Address Country
The name of the country of the shipping address.
Shipping Address Country Code
The two-letter code (ISO 3166-1 format) for the country of the shipping address.
Shipping Address First Name
The first name of the person associated to this shipping address.
Shipping Address Id
Unique identifier generated by Chord for a Shipping Address.
Shipping Address Last Name
The last name of the person associated to this shipping address.
Shipping Address Latitude
The latitude of the shipping address.
Shipping Address Longitude
The longitude of the shipping address.
Shipping Address Name
The full name of the person associated to this shipping address.
Shipping Address Oms Shipping Address Id
Unique key generated by Shopify that identifies a shipping address.
Shipping Address Phone
The phone number associated to this shipping address.
Shipping Address Province
The name of the region (province, state, prefecture, ...) of the shipping address.
Shipping Address Province Code
The two-letter abbreviation of the region of the shipping address.
Shipping Address Zip
The postal code of the shipping address.
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 Completed Oms Order Ids
List of all completed OMS order ids for a user.
User Completed Order Names
List of all completed order names for a user.
User Email
The email of the customer.
User First Completed Oms Order Id
Order id from the OMS for the first completed order.
User First Completed Order Name
Order name for the first completed order.
User First Name
The first name of the customer.
User First Name Last Initial
The first name and last name initials of the customer. This appends the value of `first_name` and the first character of `last_name` together.
User First Order Unique Ordered Products
List of unique products purchased by the user in their first completed order.
User First Order Unique Ordered Skus
List of unique variant SKUs purchased by the user in their first completed order.
User First Subscription Ids
Array of first subscription ids purchased by the user. The user may have more than one subscription created at the same time, resulting in more than one subscription counted as first.
User Full Name
The full name of the customer. This appends the value of `first_name` and `last_name` together.
User Has Ordered A La Carte
Whether or not the user has had at least one order that is not a part of a subscription.
User Has Promo Applied In First Order
Whether the first completed order has a promo applied or not.
User Has Reactivation Subscription
Whether or not the user has at least one subscription created after the first subscription is cancelled.
User Has Subscription In First Order
Whether or not the user's first order is linked to a subscription.
User Has Verified Email
Whether the customer has verified their email address.
User Id
Unique identifier generated by Chord to identify the 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. Subscribers may have completed subscription orders on inactive subscriptions, but will not be considered active if their current subscription has no completed orders.
User Is Customer
Whether the user has completed at least one order or not.
User Is New Customer
Whether the user has completed one order or not.
User Is Not Customer
Whether the user has no completed orders or not.
User Is Returning Customer
Whether the user has completed more than one order or not.
User Is Subscriber
Whether or not the user has completed at least one subscription order.
User Last Name
The last name of the customer.
User Last Subscription Ids
Array of last subscription ids purchased by a user. The user may have more than one subscription created at the same time, resulting in more than one subscription counted as last.
User Number Of Cancelled Subscriptions
Total number of subscriptions the user has cancelled.
User Number Of Completed A La Carte Orders
Total number of orders completed by a user that are a la carte.
User Number Of Completed Orders
Total count of completed orders by the user.
User Number Of Completed Subscription Orders
Total number of orders completed by a user that are part of a subscription.
User Number Of Created Subscription Orders
Total number of orders created by a user that are part of a subscription.
User Number Of Orders With Promos
Count of completed orders with a promo applied.
User Number Of Reactivated Subscriptions
Total number of subscriptions for a user that are reactivations. These subscriptions may be active, inactive, or concurrent.
User Number Of Subscriptions
Total number of subscriptions linked to a user. These subscriptions may be active, inactive, or concurrent.
User Oms User Id
Unique identifier generated by the OMS to identify the user.
User Phone
The phone number of the customer.
User Unique Ordered Product Type
List of unique product types purchased by the user across all completed orders.
User Unique Ordered Products
List of unique products purchased by the user across all completed orders.
User Unique Ordered Skus
List of unique variant SKUs purchased by the user across all completed orders.
Order Cancelled At (Universal)
Reflects when the order was cancelled in Shopify - Universal Time Zone.
Order Completed At (Central)
The timestamp when this order became completed - Cental Time Zone.
Order Completed At (Eastern)
The timestamp when this order became completed - Eastern Time Zone.
Order Completed At (Mountain)
The timestamp when this order became completed - Mountain Time Zone.
Order Completed At (Pacific)
The timestamp when this order became completed - Pacific Time Zone.
Order Completed At (Universal)
The timestamp when this order became completed - Universal Time Zone.
Order Created At (Central)
Reflects when the entity was first created in Shopify - Cental Time Zone.
Order Created At (Eastern)
Reflects when the entity was first created in Shopify - Eastern Time Zone.
Order Created At (Mountain)
Reflects when the entity was first created in Shopify - Mountain Time Zone.
Order Created At (Pacific)
Reflects when the entity was first created in Shopify - Pacific Time Zone.
Order Created At (Universal)
Reflects when the entity was first created in Shopify - Universal Time Zone.
Order Last Fulfillment At (Universal)
The maximum timestamp for the last update order fulfillment - Universal Time Zone.
Order Updated At (Universal)
Reflects when the entity was last updated in Shopify - Universal Time Zone.
User First Completed Order Completed At (Universal)
Timestamp for the first order completed - Universal Time Zone.
User First Completed Order Created At (Universal)
Timestamp for the first completed order created - Universal Time Zone.
User First Order Created At (Universal)
Timestamp of the first created order for the user - Universal Time Zone.
User First Subscription Created At (Universal)
Timestamp of when the first subscription was created per user - 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 First Subscription Order Created At (Universal)
The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone.
User Last Completed Order Completed At (Universal)
Timestamp for the most recent order completed - Universal Time Zone.
User Last Completed Order Created At (Universal)
Timestamp for the most recent completed order created - Universal Time Zone.
Average Additional Tax Total
When taxes are not included in the subtotal, this is total tax added to the order.
Average Fulfillment Tax Total
Total tax applied to the order's fulfillment fee.
Average Fulfillment Total
The sum of all shipping prices in the location's currency.
Average Gross Revenue
Gross revenue of the order calculated as `item_total` + `fulfillment_total`
Average Included Tax Total
When taxes are included in the subtotal, this is the total tax included in the order.
Average Item Total
The sum of all line item prices in the location's currency.
Average Line Item Tax Total
Total tax applied to the line items of the order.
Average Manual Transaction Total
Sum of all sales transaction with gateway of type 'manual'.
Average Net Revenue
Net revenue of the order calculated as `item_total` + `fulfillment_total` - `promo_total` - `refund_total`
Average Non Reactivated Subscription Unit Total
Sum of unit price for non reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Average Payment Capture Total
Sum of successful capture transactions.
Average Payment Total
Sum of all sales transaction with gateway of type 'shopify_payments'.
Average Product Basket Count
The count of products for a given order.
Average Product Purchased Quantity
The total number of product purchased for a given order.
Average Promo Total
The total discounts applied to the price of the order in the location's currency.
Average Reactivated Subscription Unit Total
Sum of unit price for reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Average Refund Total
Sum of all the transactions that are of kind 'refund' applied to the order.
Average Tax Total
The sum of all the taxes applied to the order in the location's currency.
Average Total Price
The sum of all line item prices, discounts, shipping, taxes, and tips in the
Average Transaction Total
Sum of all sale transactions for the order.
Average Variant Basket Count
The count of variants for a given order.
Average Variant Purchased Quantity
The total number of variants purchased for a given order.
Additional Tax Total
When taxes are not included in the subtotal, this is total tax added to the order.
Fulfillment Tax Total
Total tax applied to the order's fulfillment fee.
Fulfillment Total
The sum of all shipping prices in the location's currency.
Gross Revenue
Gross revenue of the order calculated as `item_total` + `fulfillment_total`
Included Tax Total
When taxes are included in the subtotal, this is the total tax included in the order.
Item Total
The sum of all line item prices in the location's currency.
Line Item Tax Total
Total tax applied to the line items of the order.
Manual Transaction Total
Sum of all sales transaction with gateway of type 'manual'.
Net Revenue
Net revenue of the order calculated as `item_total` + `fulfillment_total` - `promo_total` - `refund_total`
Non Reactivated Subscription Unit Total
Sum of unit price for non reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Payment Capture Total
Sum of successful capture transactions.
Payment Total
Sum of all sales transaction with gateway of type 'shopify_payments'.
Total Price
The sum of all line item prices, discounts, shipping, taxes, and tips in the
Product Basket Count
The count of products for a given order.
Product Purchased Quantity
The total number of product purchased for a given order.
Promo Total
The total discounts applied to the price of the order in the location's currency.
Reactivated Subscription Unit Total
Sum of unit price for reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Refund Total
Sum of all the transactions that are of kind 'refund' applied to the order.
Tax Total
The sum of all the taxes applied to the order in the location's currency.
Transaction Total
Sum of all sale transactions for the order.
Variant Basket Count
The count of variants for a given order.
Variant Purchased Quantity
The total number of variants purchased for a given order.
x_fct_acc_anonymous
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.
Current User Address 1
The first line of the street address.
Current User Address 2
The optional second line of the address.
Current User Address City
The city of the address.
Current User Address Country
The country of the address.
Current User Address Name
The full name of the customer, based on firstName and lastName.
Current User Address State
The region of the address, such as the province, state, or district.
Current User Address Zip
The postal code of the address.
Current 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.
Current 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.
Current 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.
Current User Email
The email associated with the user.
Current 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.
Current 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 ].
Current User Ip
IP address associated with the user.
Current 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 ].
Current User Last Segment Anonymous Id
This column is not documented.
Current User Segment User Id
The unique ID of the user.
Current 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 ].
Current 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.
First Page Browser Locale
Locale of browser.
First Page Date Day Num Of Year
The number representing the day of the year.
First Page Date Id
Unique key that uniquify a date.
First Page Date Month Num Of Year
The month number of the year.
First Page Device
The device on which the event was sent from.
First 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',
First Page Event Table Name
The properly formatted name of the table of the event.
First Page Event Text
The name of the event.
First Page Event Text Id
The slug of the event name, mapping to the page or track event table.
First 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.
First Page Id
Unique key generated by Segment for each tracking or page event.
First Page Oms Id
Unique key generated by our models that uniquifies an OMS.
First 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.
First 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.)
First Page Query
The query string portion of the URL of the page.
First Page Referrer
The referrer of the page. The referrer is the webpage that sends visitors to the site using a link. In
First Page Title
The title/name of the page.
First Page Url
The URL of the page.
First 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.
First Page Segment User Id
The unique ID of the user.
First Page Store Id
Unique key generated by our models that uniquifies a store.
First Page Tenant Id
Unique key generated by Chord that uniquifies a tenant.
First 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
First Page User Id
Unique key generated by Chord to identify the user.
First Page Utm Campaign
The campaign name represented by the UTM tags.
First Page Utm Content
The campaign content represented by the UTM tags.
First Page Utm Medium
The campaign medium represented by the UTM tags.
First Page Utm Source
The campaign source represented by the UTM tags.
First Page Utm Term
The campaign term represented by the UTM tags.
First Page Website Locale
Locale of website. This will either be collected from the url or from the drop-down link on the store
First Session Activity Count
Total count of activities, pave views and tracked events within the session.
First 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.
First 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'.
First Session Attribution First Page Url Has Gclid
Indicates if the first page event of the session has a Google Click ID.
First Session Attribution First Page Url Has Utm
Indicates if the first page event of the session has any utm information.
First Session Attribution Has Referrer
Indicates if the first page event of the session has a referrer host.
First Session Attribution Medium
The campaign medium represented by the UTM tags for the first page event of the session.
First Session Attribution Source
The campaign source represented by the UTM tags for the first page event of the session.
First Session Attribution Sub Channel
Sub-Channel is a granular level of attribution.
First 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.
First Session Completed Order Ids
Array of order IDs associated to the session_id, as collected by order completed or checkout completed front-end events.
First Session Completed Order Numbers
Array of order numbers associated to the session_id, as collected by order completed or checkout completed front-end events.
First Session Days Since Last Session End
The days between the last session's end and the start of this session.
First Session Device
The device on which the event was sent from.
First 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',
First Session Duration In Seconds
Total seconds between start and end activities within the session.
First 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.
First Session Has Order Completion
Flag for sessions with an order completed or checkout completed front-end events
First Session Id
Unique ID for the session.
First Session Number
Session number per anonymous id.
First 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.
First 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.
Last Page Browser Locale
Locale of browser.
Last Page Date Day Num Of Year
The number representing the day of the year.
Last Page Date Id
Unique key that uniquify a date.
Last Page Date Month Num Of Year
The month number of the year.
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
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.
Current User Created At (Universal)
The timestamp when the user was created - Universal Time Zone.
Current 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.
First Page Ts (Universal)
The timestamp calculated by Segment correcting clock skew - Universal Time Zone.
First Session End Ts (Universal)
Last activity timestamp for a session - Universal Time Zone.
First 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.
First 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.
First Session Start Ts (Central)
First activity timestamp for a session - Cental Time Zone.
First Session Start Ts (Eastern)
First activity timestamp for a session - Eastern Time Zone.
First Session Start Ts (Mountain)
First activity timestamp for a session - Mountain Time Zone.
First Session Start Ts (Pacific)
First activity timestamp for a session - Pacific Time Zone.
First Session Start Ts (Universal)
First activity timestamp for a session - Universal Time Zone.
Last Page Ts (Universal)
The timestamp calculated by Segment correcting clock skew - Universal Time Zone.
User Anonymous Last Seen Ts (Central)
The last timestamp the anonymous ID was registered, seen, on the site - Cental Time Zone.
User Anonymous Last Seen Ts (Eastern)
The last timestamp the anonymous ID was registered, seen, on the site - Eastern Time Zone.
User Anonymous Last Seen Ts (Mountain)
The last timestamp the anonymous ID was registered, seen, on the site - Mountain Time Zone.
User Anonymous Last Seen Ts (Pacific)
The last timestamp the anonymous ID was registered, seen, on the site - Pacific Time Zone.
User Anonymous Last Seen Ts (Universal)
The last timestamp the anonymous ID was registered, seen, on the site - Universal Time Zone.
﻿

Name	Description
Billing Address 1	The street address of the billing address.
Billing Address 2	An additional field for the street address of the billing address.
Billing Address City	The city, town, or village of the billing address.
Billing Address Company	The company associated to this billing address.
Billing Address Country	The name of the country of the billing address.
Billing Address Country Code	The two-letter code (ISO 3166-1 format) for the country of the billing address.
Billing Address First Name	The first name of the person associated to this billing address.
Billing Address Id	Unique identifier generated by Chord for a Billing Address.
Billing Address Last Name	The last name of the person associated to this billing address.
Billing Address Latitude	The latitude of the billing address.
Billing Address Longitude	The longitude of the billing address.
Billing Address Name	The full name of the person associated to this billing address.
Billing Address Oms Billing Address Id	Unique key generated by Shopify that identifies a billing address.
Billing Address Phone	The phone number associated to this billing address.
Billing Address Province	The name of the region (province, state, prefecture, …) of the billing address.
Billing Address Province Code	The two-letter abbreviation of the region of the billing address.
Billing Address Zip	The postal code of the billing address.
First Fulfillment Id	Unique identifier for a Shopify Fulfillment at a specific point in time
First Fulfillment Oms Fulfillment Id	Unique key generated by Shopify that identifies a fulfillment.
First Fulfillment Shipment Status	Represent the status of the shipment.
First Fulfillment Status	The status of the fulfillment.
First Fulfillment Tracking Company	The name of the tracking company.
First Fulfillment Tracking Numbers	A list of tracking numbers provided by the tracking company.
First Fulfillment Tracking Urls	The URLs of tracking pages for the fulfillment.
Last Transaction Amount	The amount of money included in the transaction.
Last Transaction Error Code	The error code explaining why the transaction failed.
Last Transaction Gateway	The name of the gateway the transaction was issued through.
Last Transaction Id	Unique identifier for a Shopify Transaction at a specific point in time
Last Transaction Is Failed	Whether or not the transaction / payment has failed.
Last Transaction Is Successful	Whether or not the transaction / payment has succeeded.
Last Transaction Is Test	Whether this is a test transaction or not.
Last Transaction Kind	The type of transaction.
Last Transaction Message	Additional information provided the payment provider about the transaction.
Last Transaction Oms Transaction Id	Unique key generated by Shopify that identifies a transaction.
Last Transaction Status	The status of the transaction.
Location Id	Unique identifier for a Shopify Location at a specific point in time
Location Is Active	Whether the location is active or not.
Location Is Online	Whether or not this location represents an online location.
Location Is Physical	Whether or not this location represents a physical location.
Location Name	The name of a location.
Location Oms Location Id	Unique key generated by Shopify that identifies a location.
Order Admin Url	Contains the full URL directing to the admin dashboard of Shopify for that given order.
Order App Id	The ID of the app from Shopify that created the order.
Order App Name	App name associated with the app id. This field will be generated if the Hub Configuration is enabled and the value has been set.
Order Applied Discount Codes	The discount 'codes' applied or a given order.
Order Applied Discount Codes Count	The total number of applied discount code for a given order.
Order Cancel Reason	The reason as to why the order was cancelled.
Order Cart Website Locale	When available, this is the shopify international site activated prior to cart creation.
Order Completed Order Rank By User	Allows to rank customer carts by completion date. In other words, this will rank the customer's completed order from 1 to X (X being the most recent order that was completed).
Order Completed Subscription Order Rank By User	Allows to rank customer subscription orders by completion date.
Order Contains First Subscription Order	A boolean value to indicate whether an order contains the first subscription order or not. An order may contain a mix of first and recurring subscriptions.
Order Created Order Rank By User	Allows to rank customer carts by creation date. In other words, this will rank the customer's creation order from 1 to X (X being the last order that was created). An order can be created but never completed.
Order Created Subscription Order Rank By User	Allows to rank customer subscription orders by creation date.
Order Customer Lifetime Month	Number of months between the current order's creation date and the user's first order creation date. First orders have a value of 1.
Order Customer Lifetime Week	Number of weeks between the current order's creation date and the user's first order creation date. First orders always have a value of 1.
Order Filtered Order	Whether or not this order will be flagged by custom filter.
Order Financial State	The status of transaction associated with the order.
Order Fulfillment State	The summarized status of the 'shipment/fulfillment' associated with the order.
Order Has Discount	Whether or not the order has had a discount applied to it.
Order Has Order Tag	Whether or not the order has an order tag applied to it.
Order Id	Unique identifier generated by Chord for an order.
Order Included Fulfillment Codes	Aggregated array of fulfillment codes, represented as a string.
Order Included Fulfillment Methods	Aggregated array of fulfillment methods, represented as a string.
Order Included Payment Gateways	This is the rolled up successful payment gateway for an order. Successful payments are included if they are sale or capture transactions.
Order Included Source Subscription Ids	String list of included source subscription ids per order. Subscription information received from tenant-enabled platforms including Recharge and Shopify Plus.
Order Included Subscription Ids	String list of included subscription ids per order. Subscription information received from tenant-enabled platforms including Recharge and Shopify Plus.
Order Is Admin	Whether or not the order was created by an admin.
Order Is Cancelled	Whether or not the order was cancelled. If `cancelled_at` is non-null then we consider the order has being cancelled.
Order Is Completed	Whether or not the order was completed. An order is considered completed if it has a closed_at timestamp and has been fully fulfilled. Closed_at is generated for orders in Shopify that are automatically archived. If this feature is not enabled, the last updated closed fulfillment date is used as the completed at date.
Order Is First Completed Order	Whether the order was the customer's first completed order or not.
Order Is First Order	Whether the order was the customer's first order or not.
Order Is First Subscription Completed Order	Whether the order was the customer's first completed subscription order or not.
Order Is First Subscription Order	Whether the order was the customer's first subscription order or not.
Order Is Part Of Subscription	Boolean flag to indicate whether the order was a part of a subscription plan or not.
Order Is Test	Whether this is a test order or not.
Order Item Id	Unique identifier generated by Chord for an order.
Order Item Is First Product Type Order	Whether this order contains the first product type basket for the user.
Order Item Is Last Product Type Order	Whether this order contains the last, most recent, product type basket for the user.
Order Item Is Repeat Product Type Order	Whether this order contains a repeat product type basket for the user.
Order Item Product Basket Count	The count of products for a given order.
Product Basket	The titles of products for a given orderarray converted to a string.
Order Item Product Purchased Quantity	The total number of product purchased for a given order.
Order Item Rank Product Type Order	Rank orders with the same product type basket per user.
Order Item Unique Product Basket Count	The count of unique products for a given order.
Unique Product Basket	The unique titles of products for a given order array converted to a string.
Order Item Unique Product Type	The unique line item product types for a given order.
Order Item Unique Variant Basket Count	The count of unique SKUs for a given order.
Unique Variant Basket	The unique SKUs of variants for a given order array converted to a string.
Order Item Variant Basket Count	The count of variants for a given order.
Variant Basket	The SKUs of variants for a given order array converted to a string.
Order Item Variant Purchased Quantity	The total number of variants purchased for a given order.
Order Name	Unique name generated by Shopify that is displayed to the customer (e.g.
Order Number Of Non Reactivated Subscriptions	Number of non reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Order Number Of Reactivated Subscriptions	Number of reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Order Oms Order Id	Unique key generated by Shopify that identifies an order.
Order Tags	The order tags applied to a given order, in alphabetical order.
Order Tags Count	The total number of order tags for a given order.
Order Processing Method	How the payment was processed.
Order Segment Anonymous Id	When available, this is where we store Segment's anonymous_id at the time of checkout.
Order Source Name	Where did the order get created from.
Shipping Address 1	The street address of the shipping address.
Shipping Address 2	An additional field for the street address of the shipping address.
Shipping Address City	The city, town, or village of the shipping address.
Shipping Address Company	The company associated to this shipping address.
Shipping Address Country	The name of the country of the shipping address.
Shipping Address Country Code	The two-letter code (ISO 3166-1 format) for the country of the shipping address.
Shipping Address First Name	The first name of the person associated to this shipping address.
Shipping Address Id	Unique identifier generated by Chord for a Shipping Address.
Shipping Address Last Name	The last name of the person associated to this shipping address.
Shipping Address Latitude	The latitude of the shipping address.
Shipping Address Longitude	The longitude of the shipping address.
Shipping Address Name	The full name of the person associated to this shipping address.
Shipping Address Oms Shipping Address Id	Unique key generated by Shopify that identifies a shipping address.
Shipping Address Phone	The phone number associated to this shipping address.
Shipping Address Province	The name of the region (province, state, prefecture, ...) of the shipping address.
Shipping Address Province Code	The two-letter abbreviation of the region of the shipping address.
Shipping Address Zip	The postal code of the shipping address.
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 Completed Oms Order Ids	List of all completed OMS order ids for a user.
User Completed Order Names	List of all completed order names for a user.
User Email	The email of the customer.
User First Completed Oms Order Id	Order id from the OMS for the first completed order.
User First Completed Order Name	Order name for the first completed order.
User First Name	The first name of the customer.
User First Name Last Initial	The first name and last name initials of the customer. This appends the value of `first_name` and the first character of `last_name` together.
User First Order Unique Ordered Products	List of unique products purchased by the user in their first completed order.
User First Order Unique Ordered Skus	List of unique variant SKUs purchased by the user in their first completed order.
User First Subscription Ids	Array of first subscription ids purchased by the user. The user may have more than one subscription created at the same time, resulting in more than one subscription counted as first.
User Full Name	The full name of the customer. This appends the value of `first_name` and `last_name` together.
User Has Ordered A La Carte	Whether or not the user has had at least one order that is not a part of a subscription.
User Has Promo Applied In First Order	Whether the first completed order has a promo applied or not.
User Has Reactivation Subscription	Whether or not the user has at least one subscription created after the first subscription is cancelled.
User Has Subscription In First Order	Whether or not the user's first order is linked to a subscription.
User Has Verified Email	Whether the customer has verified their email address.
User Id	Unique identifier generated by Chord to identify the 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. Subscribers may have completed subscription orders on inactive subscriptions, but will not be considered active if their current subscription has no completed orders.
User Is Customer	Whether the user has completed at least one order or not.
User Is New Customer	Whether the user has completed one order or not.
User Is Not Customer	Whether the user has no completed orders or not.
User Is Returning Customer	Whether the user has completed more than one order or not.
User Is Subscriber	Whether or not the user has completed at least one subscription order.
User Last Name	The last name of the customer.
User Last Subscription Ids	Array of last subscription ids purchased by a user. The user may have more than one subscription created at the same time, resulting in more than one subscription counted as last.
User Number Of Cancelled Subscriptions	Total number of subscriptions the user has cancelled.
User Number Of Completed A La Carte Orders	Total number of orders completed by a user that are a la carte.
User Number Of Completed Orders	Total count of completed orders by the user.
User Number Of Completed Subscription Orders	Total number of orders completed by a user that are part of a subscription.
User Number Of Created Subscription Orders	Total number of orders created by a user that are part of a subscription.
User Number Of Orders With Promos	Count of completed orders with a promo applied.
User Number Of Reactivated Subscriptions	Total number of subscriptions for a user that are reactivations. These subscriptions may be active, inactive, or concurrent.
User Number Of Subscriptions	Total number of subscriptions linked to a user. These subscriptions may be active, inactive, or concurrent.
User Oms User Id	Unique identifier generated by the OMS to identify the user.
User Phone	The phone number of the customer.
User Unique Ordered Product Type	List of unique product types purchased by the user across all completed orders.
User Unique Ordered Products	List of unique products purchased by the user across all completed orders.
User Unique Ordered Skus	List of unique variant SKUs purchased by the user across all completed orders.
Order Cancelled At (Universal)	Reflects when the order was cancelled in Shopify - Universal Time Zone.
Order Completed At (Central)	The timestamp when this order became completed - Cental Time Zone.
Order Completed At (Eastern)	The timestamp when this order became completed - Eastern Time Zone.
Order Completed At (Mountain)	The timestamp when this order became completed - Mountain Time Zone.
Order Completed At (Pacific)	The timestamp when this order became completed - Pacific Time Zone.
Order Completed At (Universal)	The timestamp when this order became completed - Universal Time Zone.
Order Created At (Central)	Reflects when the entity was first created in Shopify - Cental Time Zone.
Order Created At (Eastern)	Reflects when the entity was first created in Shopify - Eastern Time Zone.
Order Created At (Mountain)	Reflects when the entity was first created in Shopify - Mountain Time Zone.
Order Created At (Pacific)	Reflects when the entity was first created in Shopify - Pacific Time Zone.
Order Created At (Universal)	Reflects when the entity was first created in Shopify - Universal Time Zone.
Order Last Fulfillment At (Universal)	The maximum timestamp for the last update order fulfillment - Universal Time Zone.
Order Updated At (Universal)	Reflects when the entity was last updated in Shopify - Universal Time Zone.
User First Completed Order Completed At (Universal)	Timestamp for the first order completed - Universal Time Zone.
User First Completed Order Created At (Universal)	Timestamp for the first completed order created - Universal Time Zone.
User First Order Created At (Universal)	Timestamp of the first created order for the user - Universal Time Zone.
User First Subscription Created At (Universal)	Timestamp of when the first subscription was created per user - 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 First Subscription Order Created At (Universal)	The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone.
User Last Completed Order Completed At (Universal)	Timestamp for the most recent order completed - Universal Time Zone.
User Last Completed Order Created At (Universal)	Timestamp for the most recent completed order created - Universal Time Zone.
Average Additional Tax Total	When taxes are not included in the subtotal, this is total tax added to the order.
Average Fulfillment Tax Total	Total tax applied to the order's fulfillment fee.
Average Fulfillment Total	The sum of all shipping prices in the location's currency.
Average Gross Revenue	Gross revenue of the order calculated as `item_total` + `fulfillment_total`
Average Included Tax Total	When taxes are included in the subtotal, this is the total tax included in the order.
Average Item Total	The sum of all line item prices in the location's currency.
Average Line Item Tax Total	Total tax applied to the line items of the order.
Average Manual Transaction Total	Sum of all sales transaction with gateway of type 'manual'.
Average Net Revenue	Net revenue of the order calculated as `item_total` + `fulfillment_total` - `promo_total` - `refund_total`
Average Non Reactivated Subscription Unit Total	Sum of unit price for non reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Average Payment Capture Total	Sum of successful capture transactions.
Average Payment Total	Sum of all sales transaction with gateway of type 'shopify_payments'.
Average Product Basket Count	The count of products for a given order.
Average Product Purchased Quantity	The total number of product purchased for a given order.
Average Promo Total	The total discounts applied to the price of the order in the location's currency.
Average Reactivated Subscription Unit Total	Sum of unit price for reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Average Refund Total	Sum of all the transactions that are of kind 'refund' applied to the order.
Average Tax Total	The sum of all the taxes applied to the order in the location's currency.
Average Total Price	The sum of all line item prices, discounts, shipping, taxes, and tips in the
Average Transaction Total	Sum of all sale transactions for the order.
Average Variant Basket Count	The count of variants for a given order.
Average Variant Purchased Quantity	The total number of variants purchased for a given order.
Additional Tax Total	When taxes are not included in the subtotal, this is total tax added to the order.
Fulfillment Tax Total	Total tax applied to the order's fulfillment fee.
Fulfillment Total	The sum of all shipping prices in the location's currency.
Gross Revenue	Gross revenue of the order calculated as `item_total` + `fulfillment_total`
Included Tax Total	When taxes are included in the subtotal, this is the total tax included in the order.
Item Total	The sum of all line item prices in the location's currency.
Line Item Tax Total	Total tax applied to the line items of the order.
Manual Transaction Total	Sum of all sales transaction with gateway of type 'manual'.
Net Revenue	Net revenue of the order calculated as `item_total` + `fulfillment_total` - `promo_total` - `refund_total`
Non Reactivated Subscription Unit Total	Sum of unit price for non reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Payment Capture Total	Sum of successful capture transactions.
Payment Total	Sum of all sales transaction with gateway of type 'shopify_payments'.
Total Price	The sum of all line item prices, discounts, shipping, taxes, and tips in the
Product Basket Count	The count of products for a given order.
Product Purchased Quantity	The total number of product purchased for a given order.
Promo Total	The total discounts applied to the price of the order in the location's currency.
Reactivated Subscription Unit Total	Sum of unit price for reactivated subscriptions per order. Reactivation is a customer who returned after having canceled the first subscription.
Refund Total	Sum of all the transactions that are of kind 'refund' applied to the order.
Tax Total	The sum of all the taxes applied to the order in the location's currency.
Transaction Total	Sum of all sale transactions for the order.
Variant Basket Count	The count of variants for a given order.
Variant Purchased Quantity	The total number of variants purchased for a given 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.
Current User Address 1	The first line of the street address.
Current User Address 2	The optional second line of the address.
Current User Address City	The city of the address.
Current User Address Country	The country of the address.
Current User Address Name	The full name of the customer, based on firstName and lastName.
Current User Address State	The region of the address, such as the province, state, or district.
Current User Address Zip	The postal code of the address.
Current 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.
Current 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.
Current 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.
Current User Email	The email associated with the user.
Current 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.
Current 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 ].
Current User Ip	IP address associated with the user.
Current 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 ].
Current User Last Segment Anonymous Id	This column is not documented.
Current User Segment User Id	The unique ID of the user.
Current 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 ].
Current 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.
First Page Browser Locale	Locale of browser.
First Page Date Day Num Of Year	The number representing the day of the year.
First Page Date Id	Unique key that uniquify a date.
First Page Date Month Num Of Year	The month number of the year.
First Page Device	The device on which the event was sent from.
First 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',
First Page Event Table Name	The properly formatted name of the table of the event.
First Page Event Text	The name of the event.
First Page Event Text Id	The slug of the event name, mapping to the page or track event table.
First 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.
First Page Id	Unique key generated by Segment for each tracking or page event.
First Page Oms Id	Unique key generated by our models that uniquifies an OMS.
First 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.
First 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.)
First Page Query	The query string portion of the URL of the page.
First Page Referrer	The referrer of the page. The referrer is the webpage that sends visitors to the site using a link. In
First Page Title	The title/name of the page.
First Page Url	The URL of the page.
First 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.
First Page Segment User Id	The unique ID of the user.
First Page Store Id	Unique key generated by our models that uniquifies a store.
First Page Tenant Id	Unique key generated by Chord that uniquifies a tenant.
First 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
First Page User Id	Unique key generated by Chord to identify the user.
First Page Utm Campaign	The campaign name represented by the UTM tags.
First Page Utm Content	The campaign content represented by the UTM tags.
First Page Utm Medium	The campaign medium represented by the UTM tags.
First Page Utm Source	The campaign source represented by the UTM tags.
First Page Utm Term	The campaign term represented by the UTM tags.
First Page Website Locale	Locale of website. This will either be collected from the url or from the drop-down link on the store
First Session Activity Count	Total count of activities, pave views and tracked events within the session.
First 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.
First 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'.
First Session Attribution First Page Url Has Gclid	Indicates if the first page event of the session has a Google Click ID.
First Session Attribution First Page Url Has Utm	Indicates if the first page event of the session has any utm information.
First Session Attribution Has Referrer	Indicates if the first page event of the session has a referrer host.
First Session Attribution Medium	The campaign medium represented by the UTM tags for the first page event of the session.
First Session Attribution Source	The campaign source represented by the UTM tags for the first page event of the session.
First Session Attribution Sub Channel	Sub-Channel is a granular level of attribution.
First 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.
First Session Completed Order Ids	Array of order IDs associated to the session_id, as collected by order completed or checkout completed front-end events.
First Session Completed Order Numbers	Array of order numbers associated to the session_id, as collected by order completed or checkout completed front-end events.
First Session Days Since Last Session End	The days between the last session's end and the start of this session.
First Session Device	The device on which the event was sent from.
First 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',
First Session Duration In Seconds	Total seconds between start and end activities within the session.
First 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.
First Session Has Order Completion	Flag for sessions with an order completed or checkout completed front-end events
First Session Id	Unique ID for the session.
First Session Number	Session number per anonymous id.
First 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.
First 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.
Last Page Browser Locale	Locale of browser.
Last Page Date Day Num Of Year	The number representing the day of the year.
Last Page Date Id	Unique key that uniquify a date.
Last Page Date Month Num Of Year	The month number of the year.
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
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.
Current User Created At (Universal)	The timestamp when the user was created - Universal Time Zone.
Current 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.
First Page Ts (Universal)	The timestamp calculated by Segment correcting clock skew - Universal Time Zone.
First Session End Ts (Universal)	Last activity timestamp for a session - Universal Time Zone.
First 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.
First 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.
First Session Start Ts (Central)	First activity timestamp for a session - Cental Time Zone.
First Session Start Ts (Eastern)	First activity timestamp for a session - Eastern Time Zone.
First Session Start Ts (Mountain)	First activity timestamp for a session - Mountain Time Zone.
First Session Start Ts (Pacific)	First activity timestamp for a session - Pacific Time Zone.
First Session Start Ts (Universal)	First activity timestamp for a session - Universal Time Zone.
Last Page Ts (Universal)	The timestamp calculated by Segment correcting clock skew - Universal Time Zone.
User Anonymous Last Seen Ts (Central)	The last timestamp the anonymous ID was registered, seen, on the site - Cental Time Zone.
User Anonymous Last Seen Ts (Eastern)	The last timestamp the anonymous ID was registered, seen, on the site - Eastern Time Zone.
User Anonymous Last Seen Ts (Mountain)	The last timestamp the anonymous ID was registered, seen, on the site - Mountain Time Zone.
User Anonymous Last Seen Ts (Pacific)	The last timestamp the anonymous ID was registered, seen, on the site - Pacific Time Zone.
User Anonymous Last Seen Ts (Universal)	The last timestamp the anonymous ID was registered, seen, on the site - Universal Time Zone.

Updated 20 Sep 2024

Did this page help you?

Line Items

Orders