--- title: Users slug: chord-data-definitionschord-oms/raTN-users docTags: createdAt: 2024-08-23T18:43:43.941Z --- ### 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. |