Users

3min

dim_user_revenue_predictions
Name
Description
Frequency
The user's count of completed orders
Frequency Bucket
The user's count of completed orders, bucketed into pentile
Frequency Bucket Max
The maximum count of completed orders in the pentile bucket
Frequency Bucket Min
he minimum count of completed orders in the pentile bucket
Frequency Bucket Ranges
The range of completed orders in the pentile bucket
Monetary
The user's total net revenue for completed orders
Monetary Bucket
The user's total net revenue for completed orders, bucketed into pentiles
Monetary Bucket Max
The maximum total net revenue for completed orders in the pentile bucket
Monetary Bucket Min
The minimum total net revenue for completed orders in the pentile bucket
Monetary Bucket Ranges
The range of total net revenue for completed orders in the pentile bucket
User Prediction Lifetime Net Revenue
﻿
User Prediction Probability Alive
﻿
Recency
The days between user's last completed order and prediction date
Recency Bucket
The days between user's last completed order and prediction date, bucketed into pentile
Recency Bucket Max
The maximum days between last completed order and prediction date in the pentile bucket
Recency Bucket Min
The minimum days between last completed order and prediction date in the pentile bucke
Recency Bucket Ranges
The range of days between last completed order and prediction date in the pentile bucket
RFM Group
Recency, frequency, and monetary score. Concatenated values of the recency pentile, frequency pentile, and monetary pentile
Rfm Score
Recency, frequency, and monetary score. Calculated as (1/R) * F * √M
Rfm Score Bucket
Recency, frequency, and monetary score. Calculated as (1/R) * F * √M, bucketed into deciles
User Prediction Completed (Universal)
Date of the most recent prediction batch run - Universal Time Zone.
Average Predicted Lifetime Net Revenue
Average of Chord's predicted lifetime net revenue per user
Average Predicted Probability Alive
Average of Chord's predicted probability alive per user
Average RFM Score
Average of RFM Score
Predicted User Lifetime Net Revenue Total
Sum of Chord's predicted lifetime net revenue per user
dim_user_product_recommendations
Name
Description
Product Recommendation 1
User's first recommended product.
Product Recommendation 2
User's second recommended product.
Product Recommendation 3
User's third recommended product.
Product Recommendation 4
User's fourth recommended product.
Product Recommendation 5
User's fifth recommended product.
User Prediction Completed (Universal) Date
Date of the most recent prediction batch run - Universal Time Zone.
x_fct_trans_users
Name
Description
Billing Address Address1
The street address of the customer.
Billing Address Address2
The optional second address of the customer.
Billing Address Alternative Phone
The customer's alternative phone number.
Billing Address City
The city where the address is.
Billing Address Company
A company name.
Billing Address Country Abbr
﻿
Billing Address Country Name
Full name of the country.
Billing Address Firstname
First name of the customer.
Billing Address Id
Unique key generated by Chord to identify a unique address.
Billing Address Lastname
Last name of the customer.
Billing Address Oms Address Id
Unique key generated by Solidus that identifies an address.
Billing Address Phone
The customer's phone number.
Billing Address State Abbr
﻿
Billing Address State Name
Full name of the state.
Billing Address Zipcode
The postal code.
Last Subscription Completed Oms Order Ids
List of completed OMS order ids by a subscription.
Last Subscription Completed Order Count
Total amount of orders completed by a subscription.
Last Subscription Completed Order Ids
List of completed order ids by a subscription.
Last Subscription First Order Unique Product Basket
Array of unique product names ordered in the first order per subscription.
Last Subscription First Order Unique Variant Basket
Array of unique SKUs ordered in the first order per subscription.
Last Subscription Has Subscription Tags
Whether or not the subscription has tags.
Last Subscription Id
Unique key generated by Solidus that identifies a subscription.
Last Subscription Interval In Days
The number of days in the subscription interval.
Last Subscription Is Auto Redeemed
Whether the pre-paid subscription will be auto-redeemed or if an action is required by the recepient.
Last Subscription Is Gift
Whether or not the pre-paid subscription is a gift.
Last Subscription Is Recurring
Whether the pre-paid subscription is recurring.
Last Subscription Last Order Unique Product Basket
Array of unique product names ordered in the latest order per subscription.
Last Subscription Last Order Unique Variant Basket
Array of unique SKUs ordered in the latest order per subscription.
Last Subscription Oms Pre Paid Subscription Id
ID generated by ChordOMS to identify a unique pre-paid subscription.
Last Subscription Oms Subscription Id
Unique key generated by Solidus that identifies a subscription.
Last Subscription Pre Paid Subscription Id
Chord generated unique id for the pre-pay subscription.
Last Subscription State
The current state of the subscription, enhanced with values for `paused` if the subscription is active and paused.
Last Subscription Tags
The list of tags associated with a subscription.
Last Subscription Tags Count
The number of tags associated with a subscription.
Last Subscription Unique Product Basket
Array of unique product names ever ordered per subscription.
Last Subscription Unique Variant Basket
Array of unique SKUs ever ordered per subscription.
Shipping Address Address1
The street address of the customer.
Shipping Address Address2
The optional second address of the customer.
Shipping Address Alternative Phone
The customer's alternative phone number.
Shipping Address City
The city where the address is.
Shipping Address Company
A company name.
Shipping Address Country Abbr
﻿
Shipping Address Country Name
Full name of the country.
Shipping Address Firstname
First name of the customer.
Shipping Address Id
Unique key generated by Chord to identify a unique address.
Shipping Address Lastname
Last name of the customer.
Shipping Address Oms Address Id
Unique key generated by Solidus that identifies an address.
Shipping Address Phone
The customer's phone number.
Shipping Address State Abbr
﻿
Shipping Address State Name
Full name of the state.
Shipping Address Zipcode
The postal code.
User Completed Oms Order Ids
List of completed OMS order ids by a user.
User Completed Order Ids
List of completed order ids by a user.
User Credit Category Basket
Array of credit categories (Gift Card, Reimbursement, Referral Credits, Prepaid Subscription, GMA) issued per user.
User Email
Email address of the user.
User First Completed Oms Order Id
OMS order id of the first order completed by a user.
User First Completed Order Id
Unique order id of the first order completed by a user.
User First Order Unique Ordered Products
Unique products ordered by the user in their first completed order.
User First Order Unique Ordered Skus
Unique SKUs ordered by the user in their first completed order.
User Has Ordered A La Carte
Whether or not the user has had at least one order that is not part of a subscription.
User Has Promo Applied In First Order
Whether or not the user has a promo applied to their first completed order.
User Has Subscription In First Order
Whether or not the user's first order is linked to a subscription.
User Id
Unique key generated by Chord to identify a unique user.
User Is Active Subscriber
Whether or not the user has an active subscription with at least one completed subscription order. An active subscription is one that is not cancelled or paused.
User Is Customer
Whether or not the user is a customer.
User Is New Customer
Whether or not the user is a new customer.
User Is Not Customer
Whether or not the user is not a customer.
User Is Returning Customer
Whether or not the user is a returning customer.
User Is Subscriber
Whether or not the user has completed at least one subscription order.
User Login
The login email address of the user.
User Name
Full name of the user.
User Number Of Completed A La Carte Orders
Total amount of orders completed by a user that are a la carte.
User Number Of Completed Subscription Orders
Total amount of orders completed by a user that was part of a subscription.
User Number Of Orders With Promos
The count of completed orders with a promo applied.
User Number Of Subscriptions
Total amount of subscriptions linked to a user.
User Oms User Id
Unique key generated by Solidus that identifies a user.
User Phone
Phone number of the user.
User Total Completed Order Count
Total amount of orders completed by a user.
User Unique Ordered Products
Unique products ordered by the user across all orders.
User Unique Ordered Skus
Unique SKUs ordered by the user across all orders.
Billing Address Created At (Universal)
Timestamp at which the address row was created - Universal Time Zone.
Billing Address Updated At (Universal)
Timestamp at which the address row was last updated - Universal Time Zone.
Last Subscription Actionable Date (Universal)
The date of the next subscription installment. This date is updated after each successful installment. Subscriptions in an inactive state will be null - Universal Time Zone.
Last Subscription Created At (Universal)
Reflects when the entity was first created in Solidus - Universal Time Zone.
Last Subscription First Order Completed At (Universal)
The timestamp of the subscription's first completed order - Universal Time Zone.
Last Subscription Last Order Completed At (Universal)
The timestamp of the subscription's last completed order - Universal Time Zone.
Last Subscription Updated At (Universal)
Reflects when the entity was last updated in Solidus - Universal Time Zone.
Shipping Address Created At (Universal)
Timestamp at which the address row was created - Universal Time Zone.
Shipping Address Updated At (Universal)
Timestamp at which the address row was last updated - Universal Time Zone.
User Created At (Universal)
Timestamp at which the users row was created - Universal Time Zone.
User Date Of Birth (Universal)
Date of birth of the user - Universal Time Zone.
User Deleted At (Universal)
Timestamp at which the user's account was deleted - Universal Time Zone.
User First Order Completed At (Universal)
The timestamp of the user's first completed order - Universal Time Zone.
User First Subscription Order Completed At (Universal)
The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone.
User Last Order Completed At (Universal)
The timestamp of the user's last completed order - Universal Time Zone.
User Last Sign In At (Universal)
The last sign in timestamp for the user - Universal Time Zone.
User Updated At (Universal)
Timestamp at which the users row was last updated - Universal Time Zone.
Average Additional Tax Total
Sum of additional taxes paid for all completed orders for a user.
Average Adjustment Total
Sum of adjustment applied for all completed orders for a user as on the order.
Average Applied Gift Card Total
Sum of gift card amount(s) applied (used as payment method) by a user.
Average Commission Total
Sum of commission paid for all completed orders for a user.
Average Credit Authorized
Total amount of authorized credit per user. An authorized store credit decrements the amount of credit available.
Average Credit Balance
Total amount of credit issued per user.
Average Credit Invalidated
Total amount of invalidated credit per user.
Average Credit Issued
Total amount of credit issued per user.
Average Credit Used
Total amount of credit used per user.
Average First Order Gross Revenue
Gross revenue generated by the first completed order for a user.
Average First Order Net Revenue
Net revenue generated by the first completed order for a user.
Average Fulfillment Total
Sum paid for fulfillment for all completed orders for a user.
Average Gross Revenue
Sum of gross revenue generated by all completed orders for a user.
Average Included Tax Total
Sum of included taxes paid for all completed orders for a user.
Average Item Total
Sum of items price paid for all completed orders for a user.
Average Last Order Gross Revenue
Gross revenue generated by the last completed order for a user.
Average Last Order Net Revenue
Net revenue generated by the last completed order for a user.
Average Net Revenue
Sum of net revenue generated by all completed orders for a user.
Average Order Gross Revenue
Average gross revenue generated for a completed orders for a user.
Average Order Net Revenue
Average net revenue generated for a completed orders for a user.
Average Order Total Price
Average total price for a completed orders for a user.
Average Purchased Gift Card Total
Sum of gift card amount(s) purchased by a user.
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
Sum of total taxes paid for all completed orders for a user.
Average Total Price
Sum total paid for all completed orders for a user.
Average Transaction Total
Sum paid on all transactions for a user.
Additional Tax Total
Sum of additional taxes paid for all completed orders for a user.
Adjustment Total
Sum of adjustment applied for all completed orders for a user as on the order.
Applied Gift Card Total
Sum of gift card amount(s) applied (used as payment method) by a user.
Commission Total
Sum of commission paid for all completed orders for a user.
Credit Authorized
Total amount of authorized credit per user. An authorized store credit decrements the amount of credit available.
Credit Balance
Total amount of credit issued per user.
Credit Invalidated
Total amount of invalidated credit per user.
Credit Issued
Total amount of credit issued per user.
Credit Used
Total amount of credit used per user.
First Order Gross Revenue
Gross revenue generated by the first completed order for a user.
First Order Net Revenue
Net revenue generated by the first completed order for a user.
Fulfillment Total
Sum paid for fulfillment for all completed orders for a user.
Gross Revenue
Sum of gross revenue generated by all completed orders for a user.
Included Tax Total
Sum of included taxes paid for all completed orders for a user.
Item Total
Sum of items price paid for all completed orders for a user.
Last Order Gross Revenue
Gross revenue generated by the last completed order for a user.
Last Order Net Revenue
Net revenue generated by the last completed order for a user.
Net Revenue
Sum of net revenue generated by all completed orders for a user.
Total Price
Sum total paid for all completed orders for a user.
Purchased Gift Card Total
Sum of gift card amount(s) purchased by a user.
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
Sum of total taxes paid for all completed orders for a user.
Transaction Total
Sum paid on all transactions for a user.
﻿

Name	Description
Frequency	The user's count of completed orders
Frequency Bucket	The user's count of completed orders, bucketed into pentile
Frequency Bucket Max	The maximum count of completed orders in the pentile bucket
Frequency Bucket Min	he minimum count of completed orders in the pentile bucket
Frequency Bucket Ranges	The range of completed orders in the pentile bucket
Monetary	The user's total net revenue for completed orders
Monetary Bucket	The user's total net revenue for completed orders, bucketed into pentiles
Monetary Bucket Max	The maximum total net revenue for completed orders in the pentile bucket
Monetary Bucket Min	The minimum total net revenue for completed orders in the pentile bucket
Monetary Bucket Ranges	The range of total net revenue for completed orders in the pentile bucket
User Prediction Lifetime Net Revenue
User Prediction Probability Alive
Recency	The days between user's last completed order and prediction date
Recency Bucket	The days between user's last completed order and prediction date, bucketed into pentile
Recency Bucket Max	The maximum days between last completed order and prediction date in the pentile bucket
Recency Bucket Min	The minimum days between last completed order and prediction date in the pentile bucke
Recency Bucket Ranges	The range of days between last completed order and prediction date in the pentile bucket
RFM Group	Recency, frequency, and monetary score. Concatenated values of the recency pentile, frequency pentile, and monetary pentile
Rfm Score	Recency, frequency, and monetary score. Calculated as (1/R) * F * √M
Rfm Score Bucket	Recency, frequency, and monetary score. Calculated as (1/R) * F * √M, bucketed into deciles
User Prediction Completed (Universal)	Date of the most recent prediction batch run - Universal Time Zone.
Average Predicted Lifetime Net Revenue	Average of Chord's predicted lifetime net revenue per user
Average Predicted Probability Alive	Average of Chord's predicted probability alive per user
Average RFM Score	Average of RFM Score
Predicted User Lifetime Net Revenue Total	Sum of Chord's predicted lifetime net revenue per user

Name	Description
Product Recommendation 1	User's first recommended product.
Product Recommendation 2	User's second recommended product.
Product Recommendation 3	User's third recommended product.
Product Recommendation 4	User's fourth recommended product.
Product Recommendation 5	User's fifth recommended product.
User Prediction Completed (Universal) Date	Date of the most recent prediction batch run - Universal Time Zone.

Name	Description
Billing Address Address1	The street address of the customer.
Billing Address Address2	The optional second address of the customer.
Billing Address Alternative Phone	The customer's alternative phone number.
Billing Address City	The city where the address is.
Billing Address Company	A company name.
Billing Address Country Abbr
Billing Address Country Name	Full name of the country.
Billing Address Firstname	First name of the customer.
Billing Address Id	Unique key generated by Chord to identify a unique address.
Billing Address Lastname	Last name of the customer.
Billing Address Oms Address Id	Unique key generated by Solidus that identifies an address.
Billing Address Phone	The customer's phone number.
Billing Address State Abbr
Billing Address State Name	Full name of the state.
Billing Address Zipcode	The postal code.
Last Subscription Completed Oms Order Ids	List of completed OMS order ids by a subscription.
Last Subscription Completed Order Count	Total amount of orders completed by a subscription.
Last Subscription Completed Order Ids	List of completed order ids by a subscription.
Last Subscription First Order Unique Product Basket	Array of unique product names ordered in the first order per subscription.
Last Subscription First Order Unique Variant Basket	Array of unique SKUs ordered in the first order per subscription.
Last Subscription Has Subscription Tags	Whether or not the subscription has tags.
Last Subscription Id	Unique key generated by Solidus that identifies a subscription.
Last Subscription Interval In Days	The number of days in the subscription interval.
Last Subscription Is Auto Redeemed	Whether the pre-paid subscription will be auto-redeemed or if an action is required by the recepient.
Last Subscription Is Gift	Whether or not the pre-paid subscription is a gift.
Last Subscription Is Recurring	Whether the pre-paid subscription is recurring.
Last Subscription Last Order Unique Product Basket	Array of unique product names ordered in the latest order per subscription.
Last Subscription Last Order Unique Variant Basket	Array of unique SKUs ordered in the latest order per subscription.
Last Subscription Oms Pre Paid Subscription Id	ID generated by ChordOMS to identify a unique pre-paid subscription.
Last Subscription Oms Subscription Id	Unique key generated by Solidus that identifies a subscription.
Last Subscription Pre Paid Subscription Id	Chord generated unique id for the pre-pay subscription.
Last Subscription State	The current state of the subscription, enhanced with values for `paused` if the subscription is active and paused.
Last Subscription Tags	The list of tags associated with a subscription.
Last Subscription Tags Count	The number of tags associated with a subscription.
Last Subscription Unique Product Basket	Array of unique product names ever ordered per subscription.
Last Subscription Unique Variant Basket	Array of unique SKUs ever ordered per subscription.
Shipping Address Address1	The street address of the customer.
Shipping Address Address2	The optional second address of the customer.
Shipping Address Alternative Phone	The customer's alternative phone number.
Shipping Address City	The city where the address is.
Shipping Address Company	A company name.
Shipping Address Country Abbr
Shipping Address Country Name	Full name of the country.
Shipping Address Firstname	First name of the customer.
Shipping Address Id	Unique key generated by Chord to identify a unique address.
Shipping Address Lastname	Last name of the customer.
Shipping Address Oms Address Id	Unique key generated by Solidus that identifies an address.
Shipping Address Phone	The customer's phone number.
Shipping Address State Abbr
Shipping Address State Name	Full name of the state.
Shipping Address Zipcode	The postal code.
User Completed Oms Order Ids	List of completed OMS order ids by a user.
User Completed Order Ids	List of completed order ids by a user.
User Credit Category Basket	Array of credit categories (Gift Card, Reimbursement, Referral Credits, Prepaid Subscription, GMA) issued per user.
User Email	Email address of the user.
User First Completed Oms Order Id	OMS order id of the first order completed by a user.
User First Completed Order Id	Unique order id of the first order completed by a user.
User First Order Unique Ordered Products	Unique products ordered by the user in their first completed order.
User First Order Unique Ordered Skus	Unique SKUs ordered by the user in their first completed order.
User Has Ordered A La Carte	Whether or not the user has had at least one order that is not part of a subscription.
User Has Promo Applied In First Order	Whether or not the user has a promo applied to their first completed order.
User Has Subscription In First Order	Whether or not the user's first order is linked to a subscription.
User Id	Unique key generated by Chord to identify a unique user.
User Is Active Subscriber	Whether or not the user has an active subscription with at least one completed subscription order. An active subscription is one that is not cancelled or paused.
User Is Customer	Whether or not the user is a customer.
User Is New Customer	Whether or not the user is a new customer.
User Is Not Customer	Whether or not the user is not a customer.
User Is Returning Customer	Whether or not the user is a returning customer.
User Is Subscriber	Whether or not the user has completed at least one subscription order.
User Login	The login email address of the user.
User Name	Full name of the user.
User Number Of Completed A La Carte Orders	Total amount of orders completed by a user that are a la carte.
User Number Of Completed Subscription Orders	Total amount of orders completed by a user that was part of a subscription.
User Number Of Orders With Promos	The count of completed orders with a promo applied.
User Number Of Subscriptions	Total amount of subscriptions linked to a user.
User Oms User Id	Unique key generated by Solidus that identifies a user.
User Phone	Phone number of the user.
User Total Completed Order Count	Total amount of orders completed by a user.
User Unique Ordered Products	Unique products ordered by the user across all orders.
User Unique Ordered Skus	Unique SKUs ordered by the user across all orders.
Billing Address Created At (Universal)	Timestamp at which the address row was created - Universal Time Zone.
Billing Address Updated At (Universal)	Timestamp at which the address row was last updated - Universal Time Zone.
Last Subscription Actionable Date (Universal)	The date of the next subscription installment. This date is updated after each successful installment. Subscriptions in an inactive state will be null - Universal Time Zone.
Last Subscription Created At (Universal)	Reflects when the entity was first created in Solidus - Universal Time Zone.
Last Subscription First Order Completed At (Universal)	The timestamp of the subscription's first completed order - Universal Time Zone.
Last Subscription Last Order Completed At (Universal)	The timestamp of the subscription's last completed order - Universal Time Zone.
Last Subscription Updated At (Universal)	Reflects when the entity was last updated in Solidus - Universal Time Zone.
Shipping Address Created At (Universal)	Timestamp at which the address row was created - Universal Time Zone.
Shipping Address Updated At (Universal)	Timestamp at which the address row was last updated - Universal Time Zone.
User Created At (Universal)	Timestamp at which the users row was created - Universal Time Zone.
User Date Of Birth (Universal)	Date of birth of the user - Universal Time Zone.
User Deleted At (Universal)	Timestamp at which the user's account was deleted - Universal Time Zone.
User First Order Completed At (Universal)	The timestamp of the user's first completed order - Universal Time Zone.
User First Subscription Order Completed At (Universal)	The timestamp of the user's first completed subscription order, regardless of subsequent subscriptions - Universal Time Zone.
User Last Order Completed At (Universal)	The timestamp of the user's last completed order - Universal Time Zone.
User Last Sign In At (Universal)	The last sign in timestamp for the user - Universal Time Zone.
User Updated At (Universal)	Timestamp at which the users row was last updated - Universal Time Zone.
Average Additional Tax Total	Sum of additional taxes paid for all completed orders for a user.
Average Adjustment Total	Sum of adjustment applied for all completed orders for a user as on the order.
Average Applied Gift Card Total	Sum of gift card amount(s) applied (used as payment method) by a user.
Average Commission Total	Sum of commission paid for all completed orders for a user.
Average Credit Authorized	Total amount of authorized credit per user. An authorized store credit decrements the amount of credit available.
Average Credit Balance	Total amount of credit issued per user.
Average Credit Invalidated	Total amount of invalidated credit per user.
Average Credit Issued	Total amount of credit issued per user.
Average Credit Used	Total amount of credit used per user.
Average First Order Gross Revenue	Gross revenue generated by the first completed order for a user.
Average First Order Net Revenue	Net revenue generated by the first completed order for a user.
Average Fulfillment Total	Sum paid for fulfillment for all completed orders for a user.
Average Gross Revenue	Sum of gross revenue generated by all completed orders for a user.
Average Included Tax Total	Sum of included taxes paid for all completed orders for a user.
Average Item Total	Sum of items price paid for all completed orders for a user.
Average Last Order Gross Revenue	Gross revenue generated by the last completed order for a user.
Average Last Order Net Revenue	Net revenue generated by the last completed order for a user.
Average Net Revenue	Sum of net revenue generated by all completed orders for a user.
Average Order Gross Revenue	Average gross revenue generated for a completed orders for a user.
Average Order Net Revenue	Average net revenue generated for a completed orders for a user.
Average Order Total Price	Average total price for a completed orders for a user.
Average Purchased Gift Card Total	Sum of gift card amount(s) purchased by a user.
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	Sum of total taxes paid for all completed orders for a user.
Average Total Price	Sum total paid for all completed orders for a user.
Average Transaction Total	Sum paid on all transactions for a user.
Additional Tax Total	Sum of additional taxes paid for all completed orders for a user.
Adjustment Total	Sum of adjustment applied for all completed orders for a user as on the order.
Applied Gift Card Total	Sum of gift card amount(s) applied (used as payment method) by a user.
Commission Total	Sum of commission paid for all completed orders for a user.
Credit Authorized	Total amount of authorized credit per user. An authorized store credit decrements the amount of credit available.
Credit Balance	Total amount of credit issued per user.
Credit Invalidated	Total amount of invalidated credit per user.
Credit Issued	Total amount of credit issued per user.
Credit Used	Total amount of credit used per user.
First Order Gross Revenue	Gross revenue generated by the first completed order for a user.
First Order Net Revenue	Net revenue generated by the first completed order for a user.
Fulfillment Total	Sum paid for fulfillment for all completed orders for a user.
Gross Revenue	Sum of gross revenue generated by all completed orders for a user.
Included Tax Total	Sum of included taxes paid for all completed orders for a user.
Item Total	Sum of items price paid for all completed orders for a user.
Last Order Gross Revenue	Gross revenue generated by the last completed order for a user.
Last Order Net Revenue	Net revenue generated by the last completed order for a user.
Net Revenue	Sum of net revenue generated by all completed orders for a user.
Total Price	Sum total paid for all completed orders for a user.
Purchased Gift Card Total	Sum of gift card amount(s) purchased by a user.
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	Sum of total taxes paid for all completed orders for a user.
Transaction Total	Sum paid on all transactions for a user.

Updated 20 Sep 2024

Did this page help you?

Transactions

Variants