- Healthy
- Last order 0 to 30 days before the as-of date.
- Healthy slow
- Last order 31 to 60 days before the as-of date.
- At risk
- Last order 61 to 90 days before the as-of date.
- Churned
- Last order more than 90 days before the as-of date, inside the 12 month lookback. Churned accounts stay listed on purpose.
- Last order
- The latest valid QBO invoice with at least one Claybourne or Fleetwood house line, any size, including invoices dated after the as-of date (Distru dates the invoice to the delivery day; Power BI counts them too) (rulings of 2026-11-07 and 2026-11-11). Private label, bulk and white-label-only invoices do not count, nor do voided, deleted or $0 invoices. An asterisk (*) on the date means that invoice was $500 or less. Source: QUICKBOOKS_INVOICES headers, kept when MART_SALES_CUST_LINES has a branded line for the account on that date AND the invoice itself carries a positive product line that is not private label or bulk (QUICKBOOKS_INVOICE_LINES).
- State
- 'NV -' name prefix = Nevada, else ship state (not loaded into Snowflake's QBO tables), else the QBO bill state, else the name. Blank = California (Nick 7/13). Any other state shows as Other, listed under its own State button and left out of All. Eaze Florida LLC - Green Dragon is a Florida customer whose QBO bill state (CO) is wrong; it belongs under Other.
- Deleted documents
- An invoice or credit memo that the latest full QBO load did not touch again is treated as deleted in QBO and left out (same rule as Sales by Customer). Last order and the $500 count drop it by invoice id. Pace drops that account's sales lines for the day when every document that day is such a document.
- Left out
- Bulk, collections, inactive, white label and private label accounts, Vireo NY, Tweed, and house or non-retail accounts.
- $500 rule
- Counts include an account only if it has at least one branded QBO invoice of $500 or more in the 12 month lookback (Nick 7/23, ruling C7). The rule changes counts only. It does not change a date, a cadence or a dollar.
- Pace
- Trailing 6 month net revenue to yesterday divided by 6: Claybourne and Fleetwood house lines minus credit memo and discount lines, per month (MART_SALES_CUST_LINES NetRevenue). A positive 'Discounts' line is not a discount (for example white-label product booked there) and is left out. Gross = the same lines before the Discounts product line (invoice discounts and credit memos), / 6. It is shown in the Pace i for comparison only (ruling of 2026-11-07: quantify net and gross before deciding).
- As-of date
- Today, Pacific: the day of the refresh, the same day Power BI measures to (V_PBI_ACCOUNT_CHURN uses CURRENT_DATE). Days since last order = as-of date minus last order date, 0 when the last order is dated later. Counts are read live at each page build (no frozen snapshot for this day); the build time is in the status strip. Pace uses the 6 months to yesterday.
- Rep
- The person assigned to the account on the as-of date, from the dated rep map (V_PBI_ACCOUNT_REP_DATED); for a key account with no person there, SEED_ACCOUNT_REP KEY row, then the current SEED_REP_BOOK row (same rule as AR Aging). A rep is always a person.
- Key account
- A pill, not a rep (ruling of 2026-11-07). A key account sits under its responsible person: the dated rep map names one, or SEED_ACCOUNT_REP has a KEY row with a person, or the current SEED_REP_BOOK row names one (same rule as AR Aging). With no named person it sits in the row 'Not assigned to a rep' with its pill.
- Calls due
- Counted accounts whose Why Call is anything other than On track.
Counts are as of today (Pacific), the day Power BI measures to. The team table counts only accounts with one invoice of $500 or more in the last 12 months. Last order is the last invoice of any size, starred when that invoice was $500 or less. Pace is net revenue, trailing 6 months divided by 6; a positive Discounts line (misbooked white label) is excluded. Net against gross pace is quantified in the Pace i (ruling of 2026-11-07: quantify both before deciding).