An RFM score per customer
R counts the days since the last paid order, F the paid orders in the last 12 months and M the revenue of those orders. Loyalo compares with your own customers, and B2B customers only with each other.
Loyalo works out what your subscriptions bring in each month, how many subscribers stop and what a customer is worth on average. The figures come from the subscriptions and orders in your own store, so there is nothing to export or rebuild in a spreadsheet. Every figure sits next to the period before.
With subscriptions, what matters is what comes back every month, how long customers stay and where things go wrong. Those figures are on one page, for the period you pick at the top right.
The first tab counts the revenue from subscription orders, with first orders and renewals shown separately. Every figure shows the change from the period before. The chart shows revenue per day, week or month, and on the right what is scheduled next.
At the top you see how many subscriptions are running, how many were added and how many stopped. The chart puts new subscriptions next to cancellations per week, and the line below shows MRR over time.
For each product you see what it brought in through subscription orders, its share of the total and whether it is growing. Next to it is the number of running subscriptions that include the product now.
For each start month you see what share of the subscriptions is still running after 1, 2, 3, 6, 9, 12 and 18 months. Above it is the expected customer value: the average monthly value of a running subscription times the expected lifetime.
A subscriber who stops because a payment fails usually did not mean to stop. Here you see how many attempts failed, how many deliveries were paid after all and how often an offer at cancellation kept a subscriber.
Your warehouse wants to know what is coming. The Deliveries page counts the deliveries and the number of items per product for the period you choose.
Every night Loyalo gives every customer with a paid order or a subscription a score from 1 to 5 for recency (R), frequency (F) and monetary value (M). That places the customer in one of eight fixed segments, with their value to date and an estimate for the next 12 months. You find it under Analytics › Customer value.
R counts the days since the last paid order, F the paid orders in the last 12 months and M the revenue of those orders. Loyalo compares with your own customers, and B2B customers only with each other.
From Champions to Hibernating. For each segment you see customers, subscribers, revenue over the last 12 months, average customer value and what usually works, with a link to the customers.
What the customer has brought in so far and what Loyalo expects over the next 12 months: for a subscription based on your churn, for one-off buyers based on their own order rhythm. Every customer also falls in the top 10%, the top 25% or the rest.
A 5 by 5 grid (R against F+M) and the customers who moved to another segment in the last 30 days.
Every customer gets a tag such as loyalo-rfm-at-risk. Use it for Shopify customer segments, discounts per segment or a workflow in Shopify Flow. One switch turns the tags off.
Segment, RFM score and customer value are on the Klaviyo profile, and a change of segment is sent to Klaviyo as an event. On Customers you filter by segment and sort by customer value.
The names are fixed, so you can build on them in Shopify and Klaviyo. Each segment comes with what usually fits it.
| Segment | Meaning | What usually works |
|---|---|---|
| Champions | Recent, frequent and high spend | Early access, ask for a review or a referral |
| Loyal customers | Regular buyers | A higher tier, offer a subscription |
| Potential loyalists | Recent, not yet frequent | Encourage the next order, bonus points |
| New customers | Just placed their first order | A welcome series, explain the points program |
| Need attention | Middle of the pack, slipping | A reminder with a relevant product |
| At risk | Were good, quiet for a long time | A winback with points or a discount |
| Can't lose them | Were the best, quiet for a very long time | A personal winback |
| Hibernating | Few orders, long ago | A last attempt, then email less often |
The expected customer value is an estimate. Loyalo shows it once your store has 90 days of order history.
A figure is only useful when you know how it was calculated. These are the definitions the dashboard uses.
| Figure | Calculation |
|---|---|
| MRR (monthly recurring revenue) | The value of every running subscription, converted to a month and added up. A delivery of € 20 every two weeks counts for a little over € 43. Paused subscriptions and one-time extras do not count. |
| Revenue | What customers paid for subscription orders, including shipping and VAT, after refunds. A first order and every renewal count; cancelled and unpaid orders do not. |
| Scheduled | What the running subscriptions bring in on their next charge dates. A planned cancellation and a pause with an end date are taken into account; future cancellations and failed payments are not. |
| Churn | Of the subscriptions running at the start of the period, the share that stopped during the period. |
| Expected lifetime | One divided by the monthly churn, capped at 60 months. |
| Customer value per subscription (LTV) | The average monthly value of a running subscription times the expected lifetime. |
| RFM score | Three scores from 1 to 5. R: days since the last paid order. F: paid orders in the last 12 months (1, 2, 3, 4 to 5, 6 or more). M: the revenue of those orders, after discounts and refunds and excluding shipping. R and M are compared with your own customers. |
| Customer value per customer (CLV) | To date: what the customer has spent in your store. Expected: an estimate for the next 12 months, from the subscription and your churn or from the customer's own order rhythm. |
| Cohort | All subscriptions that started in the same month. The percentage is the share still running after that many months; paused counts as running. |
| Recovered | Deliveries paid after a failed attempt, as a share of the deliveries where a payment failed. |
An expected customer value is an estimate based on your current figures, not a guarantee.
Customers with points, points earned and redeemed, where points come from, the most chosen rewards, revenue through rewards and the value of points still outstanding.
Read moreHow many emails were sent per type, which were not delivered and which events went to Klaviyo.
A log of every change to a subscription or a setting: when, what and by whom.
Tasks that failed, such as an email or a charge, are listed in one place with the error and a retry button.
Every figure has a setting you change in the same app.
Read more about retentionMRR stands for monthly recurring revenue. Loyalo converts the value of every running subscription to a monthly amount and adds them up. A subscription of € 30 per month counts for € 30, a delivery of € 20 every two weeks for a little over € 43.
You multiply the average monthly value of a running subscription by the expected lifetime. Loyalo calculates that lifetime as one divided by the monthly churn, capped at 60 months. At € 24 per month and 3% churn that is about 33 months, so around € 800.
An RFM analysis groups customers by how recently (recency), how often (frequency) and how much (monetary) they bought. Loyalo does this every night for your Shopify customers, with a score from 1 to 5 per letter, and places each customer in one of eight segments, such as Champions or At risk. You see it under Analytics › Customer value, on the Customers page, as a tag in Shopify and in Klaviyo.
It depends on the kind of customer. For a running subscription it is the monthly value times the months you can expect at your churn; for a paused one the same, times the share of pauses that resume in your store. For one-off buyers Loyalo looks at their own order rhythm and how long they have been quiet, and for customers with one order so far at how often customers in your store order again. Until your store has 90 days of order history, Loyalo shows no expected value.
Take the subscriptions running at the start of the period and see what share of them stopped during it. You choose the period: the last 7, 30 or 90 days or 12 months, a week, month, quarter or year, or your own dates. The churn of the period before is shown next to it.
A cohort is a group of subscriptions that started in the same month. Looking at what share of each start month is still running after a few months shows whether your retention is improving or getting worse, regardless of how many new customers you bring in.
Yes. On Analytics you export the subscription orders of the chosen period as CSV, one line per order. Subscriptions, customers and upcoming deliveries can be exported as CSV too. For your own reporting you can also fetch the data through the API.
Because Analytics only counts subscription orders: the first order of a subscription and every renewal, including shipping and VAT and after refunds. One-off orders are left out. Shopify counts all orders and has several revenue figures, such as gross, net and total sales.
Everyone in your team with access to Loyalo, including the Viewer role. Only owners and admins can export, because an export contains personal data or revenue per order.
Yes, with one exception. Analytics, cohorts and the Deliveries page are included in Growth, Scale and Scale B2B. Customer value, with the RFM segments and the value per customer, is included in Scale and Scale B2B. The 14-day trial lets you try everything. The figures about points and rewards appear when you use the Customer Loyalty add-on.
Read on: Analytics and reportingBlog: the KPIs of a subscriptionBlog: how to calculate churn rateBlog: how to calculate customer lifetime valueBlog: segmenting customers with the RFM modelAPI for your own reporting
In half an hour we show you how Loyalo works in your store, or we send you an install link right away. The trial runs for 14 days and needs no credit card.
In a demo we walk through the figures and show which setting goes with which figure.