Users

1min

x_fct_trans_users
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.
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.
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.
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 A La Carte Gross Revenue
Sum of gross revenue generated by all completed a la carte orders for a user.
Average A La Carte Net Revenue
Sum of net revenue generated by all completed a la carte orders for a user.
Average Additional Tax Total
When taxes are not included in the subtotal, this is total tax added to the order.
Average First Order Gross Revenue
Gross revenue of the first completed order.
Average First Order Net Revenue
Net revenue of the first completed order.
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 Last Order Gross Revenue
Gross revenue of the most recent completed order.
Average Last Order Net Revenue
Net revenue of the most recent completed 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 Order Gross Revenue
The average order gross revenue of completed orders per user.
Average Order Net Revenue
The average order net revenue of completed orders per user.
Average Order Transaction Total
The average transaction total of completed orders per user.
Average Payment Total
Sum of all sales transaction with gateway of type 'shopify_payments'.
Average Promo Total
The total discounts applied to the price of the order in the location's currency.
Average Refund Total
Sum of all the transactions that are of kind 'refund' applied to the order.
Average Subscription Gross Revenue
Sum of gross revenue generated by all completed subscription orders for a user.
Average Subscription Net Revenue
Sum of net revenue generated by all completed subscription orders for a user.
Average Tax Total
The sum of all the taxes applied to the order in the location's currency.
Average Total Ordered Quantity
The total quantity of variant SKUs purchased the user.
Average Total Price
The sum of all line item prices, discounts, shipping, taxes, and tips in the
Average Total Unique Ordered Products
The count of unique products purchased the user.
Average Transaction Total
Sum of all sale transactions for the order.
A La Carte Gross Revenue
Sum of gross revenue generated by all completed a la carte orders for a user.
A La Carte Net Revenue
Sum of net revenue generated by all completed a la carte orders for a user.
Additional Tax Total
When taxes are not included in the subtotal, this is total tax added to the order.
First Order Gross Revenue
Gross revenue of the first completed order.
First Order Net Revenue
Net revenue of the first completed order.
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.
Last Order Gross Revenue
Gross revenue of the most recent completed order.
Last Order Net Revenue
Net revenue of the most recent completed 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`
Total Ordered Quantity
The total quantity of variant SKUs purchased the user.
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
Promo Total
The total discounts applied to the price of the order in the location's currency.
Refund Total
Sum of all the transactions that are of kind 'refund' applied to the order.
Subscription Gross Revenue
Sum of gross revenue generated by all completed subscription orders for a user.
Subscription Net Revenue
Sum of net revenue generated by all completed subscription orders for a user.
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.
Total Unique Ordered Products
The count of unique products purchased the user.
﻿

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.
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.
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.
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 A La Carte Gross Revenue	Sum of gross revenue generated by all completed a la carte orders for a user.
Average A La Carte Net Revenue	Sum of net revenue generated by all completed a la carte orders for a user.
Average Additional Tax Total	When taxes are not included in the subtotal, this is total tax added to the order.
Average First Order Gross Revenue	Gross revenue of the first completed order.
Average First Order Net Revenue	Net revenue of the first completed order.
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 Last Order Gross Revenue	Gross revenue of the most recent completed order.
Average Last Order Net Revenue	Net revenue of the most recent completed 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 Order Gross Revenue	The average order gross revenue of completed orders per user.
Average Order Net Revenue	The average order net revenue of completed orders per user.
Average Order Transaction Total	The average transaction total of completed orders per user.
Average Payment Total	Sum of all sales transaction with gateway of type 'shopify_payments'.
Average Promo Total	The total discounts applied to the price of the order in the location's currency.
Average Refund Total	Sum of all the transactions that are of kind 'refund' applied to the order.
Average Subscription Gross Revenue	Sum of gross revenue generated by all completed subscription orders for a user.
Average Subscription Net Revenue	Sum of net revenue generated by all completed subscription orders for a user.
Average Tax Total	The sum of all the taxes applied to the order in the location's currency.
Average Total Ordered Quantity	The total quantity of variant SKUs purchased the user.
Average Total Price	The sum of all line item prices, discounts, shipping, taxes, and tips in the
Average Total Unique Ordered Products	The count of unique products purchased the user.
Average Transaction Total	Sum of all sale transactions for the order.
A La Carte Gross Revenue	Sum of gross revenue generated by all completed a la carte orders for a user.
A La Carte Net Revenue	Sum of net revenue generated by all completed a la carte orders for a user.
Additional Tax Total	When taxes are not included in the subtotal, this is total tax added to the order.
First Order Gross Revenue	Gross revenue of the first completed order.
First Order Net Revenue	Net revenue of the first completed order.
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.
Last Order Gross Revenue	Gross revenue of the most recent completed order.
Last Order Net Revenue	Net revenue of the most recent completed 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`
Total Ordered Quantity	The total quantity of variant SKUs purchased the user.
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
Promo Total	The total discounts applied to the price of the order in the location's currency.
Refund Total	Sum of all the transactions that are of kind 'refund' applied to the order.
Subscription Gross Revenue	Sum of gross revenue generated by all completed subscription orders for a user.
Subscription Net Revenue	Sum of net revenue generated by all completed subscription orders for a user.
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.
Total Unique Ordered Products	The count of unique products purchased the user.

Updated 20 Sep 2024

Did this page help you?

Sessions

Forecasts