Users
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. |