Customer RFM by acquisition cohort — new customers / sign-ups per day
Customer RFM aggregated by acquisition cohort — how many customers were acquired in each month (or at each store), and what they are worth over their lifetime — in a single call. It is the RFM base, grouped: instead of paging ~hundreds of thousands of per-customer rows and grouping client-side, this returns the cohort rollup at once.
A cohort is cut by the first-purchase date (firstPurchaseDate). Group by
month (acquisition month), firstStore (acquisition store), or both. Per
cohort you get clients, lifetimeValue and avgValue (spend), avgOrders
(frequency), avgCadenceDays (repeat interval, only over customers with 2+
orders) and avgDaysWithoutPurchase (recency today).
Values are in cents. The month is cut in the organization timezone, so
cohorts line up with the sales report by (month, store). total reconciles
with the sum of the rows by construction.
Read the semantics carefully: store is the acquisition store and
lifetimeValue is the customer's org-wide lifetime spend (across every
store), not the store's sales — "customers acquired at store X and what they
spent everywhere". For store sales use order.report.sales; do not mix them.
Try-it values populated from environment ACME (Demo)
Authentication
Token
Send your user token in the x-guper-authorization header.