Analytics

Subscription analytics for Shopify: MRR, churn and lifetime value

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.

6
tabs: revenue, subscriptions, products, loyalty, customer value and messages
400 days
is the longest period you can pick, with the period before next to it
24 months
of cohorts, by start month
CSV
export of orders, subscriptions, customers and deliveries
The Analytics page

The figures a subscription business runs on

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.

Revenue

What your subscriptions bring in, next to the period before

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.

  • Revenue, number of orders and average order value
  • First orders and renewals separately, each with the change
  • MRR, churn and revenue per subscriber to date
  • Revenue by source: subscriptions, rewards, referred friends and B2B
  • Orders from before Loyalo too: the first time, Loyalo reads your order history from Shopify
The Revenue tab in Loyalo: revenue from subscriptions, orders and average order value with the change from the period before, and a chart of revenue per day and what is scheduled
Subscriptions

MRR and growth per week

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.

  • Running and paused subscriptions, and net growth
  • Monthly recurring revenue (MRR) and the average value per delivery
  • New and cancelled in the period, with the churn
  • How long a subscription ran when it stopped
Analytics in Loyalo: running subscriptions, revenue per month, new and cancelled subscriptions per week and the MRR over time
Products

Which products carry your subscriptions

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.

  • Revenue per product, after discount and excluding shipping
  • Share of the total and the change from the period before
  • Units, orders and running subscriptions
The Products tab in Loyalo: per product the share, the revenue, the change from the period before, the units, orders and running subscriptions
Cohorts

Cohorts and customer lifetime value

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.

  • Expected customer value (LTV) and expected lifetime
  • Monthly churn over the last ninety days
  • Revenue to date per subscription, by start month
  • Shows whether new customers stay longer than earlier ones
Cohorts in Loyalo: expected customer value, churn per month, expected lifetime and per start month the share of subscriptions still running
Payments and retention

Where your revenue leaks

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.

  • Successful charges and failed attempts
  • Recovered: the share paid after a retry
  • Subscriptions with a payment problem right now
  • By payment method (iDEAL and SEPA Direct Debit, or card) and why payments failed
  • Cancellation reasons, most chosen first
Payments and retention in Loyalo: successful collections, failed attempts, paid after all, accepted offers and the cancellation reasons
Deliveries

What goes out the door in the coming weeks

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.

  • Total deliveries, items and subscriptions
  • Split by product, for your purchasing
  • Export as CSV
Overview of upcoming deliveries in Loyalo: total deliveries and items, split per product
Customer value, in Scale and Scale B2B

RFM analysis and customer lifetime value per customer

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.

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.

Eight segments

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.

Customer lifetime value (CLV)

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.

Who is moving

A 5 by 5 grid (R against F+M) and the customers who moved to another segment in the last 30 days.

A tag in Shopify

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.

Klaviyo and the Customers page

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 eight segments

What each RFM segment means

The names are fixed, so you can build on them in Shopify and Klaviyo. Each segment comes with what usually fits it.

What each RFM segment means
SegmentMeaningWhat usually works
ChampionsRecent, frequent and high spendEarly access, ask for a review or a referral
Loyal customersRegular buyersA higher tier, offer a subscription
Potential loyalistsRecent, not yet frequentEncourage the next order, bonus points
New customersJust placed their first orderA welcome series, explain the points program
Need attentionMiddle of the pack, slippingA reminder with a relevant product
At riskWere good, quiet for a long timeA winback with points or a discount
Can't lose themWere the best, quiet for a very long timeA personal winback
HibernatingFew orders, long agoA 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.

Definitions

How Loyalo calculates your figures

A figure is only useful when you know how it was calculated. These are the definitions the dashboard uses.

How Loyalo calculates your figures
FigureCalculation
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.
RevenueWhat customers paid for subscription orders, including shipping and VAT, after refunds. A first order and every renewal count; cancelled and unpaid orders do not.
ScheduledWhat 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.
ChurnOf the subscriptions running at the start of the period, the share that stopped during the period.
Expected lifetimeOne 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 scoreThree 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.
CohortAll subscriptions that started in the same month. The percentage is the share still running after that many months; paused counts as running.
RecoveredDeliveries 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.

More than subscriptions

Your points, emails and processes in view too

Points and rewards

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 more

Communication

How many emails were sent per type, which were not delivered and which events went to Klaviyo.

Activity

A log of every change to a subscription or a setting: when, what and by whom.

Status page

Tasks that failed, such as an email or a charge, are listed in one place with the error and a retry button.

From figure to action

See what is going on and act on it

Every figure has a setting you change in the same app.

Read more about retention
  • Many cancellations for 'too expensive': set a discount offer for that reason
  • Many failed payments: change the retry days or move retries to just after payday
  • Cohorts dropping off after three months: offer a prepaid plan or a one-time extra
  • Unsure about the widget on your product page: A/B test a new version against the current one
  • Customers moving to At risk: start a winback flow in Klaviyo on the event Loyalo Segment Changed
  • Your most valuable customers want to cancel: give the top 10% by customer value an extra discount in the cancellation offer
  • Segment on the same data in Klaviyo, through the profile properties Loyalo fills in

Frequently asked questions about subscription analytics

What is MRR?

MRR 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.

How do you calculate customer lifetime value for a subscription?

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.

What is an RFM analysis?

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.

How does Loyalo estimate the value of a single customer?

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.

How do you calculate the churn rate?

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.

What is a cohort?

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.

Can I export the data?

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.

Why does the revenue differ from Shopify?

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.

Who can see the figures?

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.

Is analytics included in every plan?

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

Demo

Request a demo or a trial

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.

Know what comes back every month

In a demo we walk through the figures and show which setting goes with which figure.