> For the complete documentation index, see [llms.txt](https://docs.chord.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.chord.co/model-your-data/dbt-model-reference/chord-oms/users.md). # Users ### 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. | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.chord.co/model-your-data/dbt-model-reference/chord-oms/users.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.