Analytics dashboard

Track recurring revenue, churn, customer lifetime value and your plugin's install base, and export the figures to CSV. This needs TierMint Pro.

Open the dashboard

Open TierMint → Analytics. You need the view_tiermint_reports capability. Administrators have it, and you can give it to a bookkeeper who should read the figures without changing anything in the store.

The dashboard is read-only. It never changes an order, a subscription or a license. A background job builds its figures once a day into stored snapshots, so opening the screen never runs a heavy query over your orders.

TierMint Pro also adds a Current monthly recurring revenue card to the TierMint Dashboard for users with the same capability. Pro also adds a View analytics link to the heading of the store overview there, which opens the Analytics screen.

The tabs

Tab	What it shows
Overview	Sales for the last 30 days, and the current recurring revenue figures with their trends.
Revenue	Monthly gross, refund and net revenue, and new customers, over a range you pick.
Subscriptions	Recurring revenue and active subscriptions over time, new and churned subscriptions, churn rates and the plan mix.
Activations	How many sites run your plugins, and the PHP, WordPress and plugin versions, domains and billing countries behind them.
LTV	What each month's group of new customers has been worth since.

The Overview keeps two sections apart. Sales, last 30 days comes live from your orders: Gross revenue, Refunds, Net revenue and Orders, with a chart of each day, and a View full sales report link to the Sales reports screen. Recurring revenue comes from the latest daily snapshot. TierMint never adds the two together, because 30 days of sales and a monthly run rate measure different things.

How each figure is calculated

Monthly recurring revenue (MRR)

MRR adds up every subscription that is active or past due, with each amount converted to a monthly figure. Past-due subscriptions count because they are still live while the payment gateway retries the payment.

A year is 12 months, so an annual plan at 1,200.00 adds 100.00 to MRR. Weekly and daily plans use 365 days a year. Each subscription is rounded to the smallest currency unit before the sum.

Trial MRR (pipeline) is the same figure for subscriptions still in a trial. It is never added into MRR, because a trial can cancel. Scheduled to cancel is the MRR of subscriptions set to end with their current period. They still bill this period, so they are still in MRR.

Churn

Churn for a month counts the subscriptions that left during it. A cancellation is dated by when it was cancelled. An expiry is dated by the end of the subscription's last paid period, so the figure is an estimate, and the tab says so.

The count includes every subscription cancelled in the month, such as a cancelled trial, while the start-of-month figure counts only active and past-due subscriptions. A store with many cancelled trials can show a high churn rate.

Churn rate is that count divided by the active subscriptions at the start of the month. Revenue churn is the churned subscriptions' MRR divided by the MRR at the start of the month. With no earlier month to divide by, both read n/a.

New customers and lifetime value (LTV)

A customer's cohort is the month of their first completed purchase. New customers for a month is the size of that month's cohort. TierMint does not count customer records here, because a record is created when someone starts a checkout, before they pay.

The LTV tab shows, for each cohort, the average revenue each customer has brought in since, and the cohort's cumulative revenue. A renewal today adds to the cohort the customer joined, however long ago that was. LTV per customer is shown without tax. The cumulative revenue includes tax, like the other revenue figures.

Plan mix

The plan mix on the Subscriptions tab groups live subscriptions by product and tier, in each currency, with a count and the MRR. Each row uses the current product and tier names. When a product or tier was deleted, the row shows its number instead, such as "Product #12", so the figure stays.

A month with no reading shows n/a, not zero, so a snapshot that has not caught up with a new sale never reads as "no revenue".

Why some history starts at install

Revenue, new customers and LTV reach back to your first sale. TierMint works them out from your orders, which keep their history. When you first activate Pro, a background job fills in past months, newest first, so your recent history shows before the older months.

Recurring revenue, active subscriptions and the plan mix start the month TierMint Pro was installed. A subscription record holds only its current state, so TierMint cannot know what it looked like six months ago. Instead it freezes these figures in a snapshot each month from then on.

Churn rate starts one month later. The churned count is filled in for past months, but the rate needs the frozen active count from the month before.

A month with no snapshot at all, for example while the site or Pro was switched off, shows as a gap in a chart, not as zero.

Currencies and tax

TierMint never adds money across currencies. When your store has taken more than one currency, the Overview, Revenue, Subscriptions and LTV tabs show a Currency selector and say how many other currencies are present. Every figure on the tab is in the currency you pick. There is no combined total.

On the Overview the selector changes only the Recurring revenue section. Sales, last 30 days is always in the store currency, and sales taken in another currency are left out of it. The Activations tab has no selector.

Revenue figures include tax, the same as the free sales report. The one exception is LTV per customer, which is without tax.

The Activations tab

The Activations tab counts your install base: sites that are active, are not local development sites and were seen in the last 30 days. It shows counts only, never a single site.

A site reports its PHP, WordPress and plugin versions when it activates. TierMint does not refresh them later, so a site that upgraded without activating again shows its old versions.

TierMint does not know where a site is. Site domains groups sites by top-level domain only, which is a weak hint. Billing countries counts orders by the country buyers entered at checkout, which is where they pay from, not where a site runs.

Pick a date range

The Revenue and Subscriptions tabs have From month and To month fields and an Apply button. The tab reads the new range only when you click Apply, so you can set both ends first. Months are in UTC, and a range can span up to 36 months.

The Overview always shows the last 30 days and the last 12 months. The Activations and LTV tabs show the current state, so they have no range.

Export to CSV

Click Export CSV in the Analytics header and pick a file:

Export	What it holds
Daily sales (last 30 days)	The same day-by-day series as the Sales reports screen.
Orders (last 30 days)	One row per order, with the buyer, the products, the total and the gateway. It holds customer email addresses, so only users with the manage_tiermint capability get it.
Monthly sales history (36 months)	The monthly revenue snapshots, in the currency the recurring section shows.
Recurring metrics (36 months)	The monthly recurring revenue snapshots, in the same currency.

The free Sales reports screen has the same button, with the daily sales and orders files for the range it shows.

The two history files hold the figures behind the charts. The recurring file has one row per month and currency, with mrr, active_subscriptions, churned_count, churn_rate and has_point_in_time. The churn rate is a ratio with four decimals, such as 0.0250. Money is a plain decimal in the currency's main unit, with a currency column, so a spreadsheet can add it up.

The daily sales and orders files do not match row for row. Daily sales counts an order on the day it completed. The orders file lists every order, refunds included, on the day it was created.

The orders file stops at 10,000 orders. A range with more is refused with a message asking you to narrow the dates.

The dashboard sends no email summaries. Use the CSV exports to keep a copy.

When the dashboard is still being prepared

On a new install, before the daily job has run once, the Overview, Revenue, Subscriptions and LTV tabs show "Analytics are being prepared" instead of empty charts. On the Overview this replaces only the Recurring revenue section. The Activations tab shows "No activation data yet" until the job has run and a site has activated. The job runs in the background and usually finishes within a day. A large store with years of history can take longer, and its recent months show first.

To build the snapshots straight away, an administrator can run this WP-CLI command:

wp tiermint analytics rebuild

It runs the same work as the daily job and fills every snapshot. You can run it at any time.

If the background build stopped part way, the Overview says the history is being rebuilt and shows the figures it has. The job retries on its own, and the same command finishes it at once.