Users

1 min

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.