> For the complete documentation index, see [llms.txt](https://docs.letsmetrix.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.letsmetrix.com/insights-and-metrics-v2/growth-and-retention.md).

# Growth & Retention

Is the merchant base growing, and do merchants stay? Learn how to read installs, uninstalls, cohorts and churn.

This tab answers one big question: **"Is my merchant base growing, and do merchants stay?"**

Both charts use `SHOPIFY` data. To see them, connect your app with [Connect Shopify API](https://docs.letsmetrix.com/get-started/connect-shopify-api).

| Chart                      | It answers                                                                  |
| -------------------------- | --------------------------------------------------------------------------- |
| Merchant Growth & Earnings | Is the number of active merchants going up? How many install and uninstall? |
| Retention & Churn          | How many merchants keep the app over time? How many leave?                  |

### Merchant Growth & Earnings

> **Active merchants** are stores that have the app installed and are still active.

#### What question does it answer?

* "How many merchants use my app now?"
* "Am I gaining or losing merchants?"
* "How many installs are new, and how many are returning merchants?"

#### What you see

The headline (top right) shows the number of active merchants and the net change in the date range.

<figure><img src="https://3107817457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8KaEyTr3mMTLCU7QQyAU%2Fuploads%2F4Qjlwb73AwNL8z7uLjOV%2Fv2-growth-active-merchants-mrr.png?alt=media&amp;token=80382f7a-9b65-4bd6-bc41-722c573b5829" alt=""><figcaption></figcaption></figure>

| Chart                | Meaning                                                                        |
| -------------------- | ------------------------------------------------------------------------------ |
| **Active merchants** | The number of active merchants per day. The dashed line is the compare period. |
| **MRR (gross)**      | Monthly recurring revenue before Shopify fees, per day.                        |

#### Daily details (deep dive)

The **Active merchants** and **MRR (gross)** charts show the total for each day. The deep dive shows **which shops** made that total go up or down.

**What question does it answer?**

* "Why did my active merchants go up or down on this day?"
* "Which shops installed, uninstalled or closed their store?"
* "Which shops started, upgraded, downgraded or cancelled a paid plan?"

**How to open it**

1. Find the text **Click a day for details** at the top right of the chart.
2. Move your mouse over the chart. A tooltip shows the value of that day and the previous period.
3. Click the day (or click **Click for details** in the tooltip). A details window opens.

<figure><img src="https://3107817457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8KaEyTr3mMTLCU7QQyAU%2Fuploads%2FeMkvpdFaz2rffNkw3R6Z%2Fv2-growth-deepdive-open.png?alt=media&amp;token=df4f47a9-4bc1-4440-8edf-6f80d190c90a" alt=""><figcaption></figcaption></figure>

**Active merchants: details of one day**

<figure><img src="https://3107817457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8KaEyTr3mMTLCU7QQyAU%2Fuploads%2Fh1CAsOLHrEpqXmrBnhxc%2Fv2-growth-deepdive-active-merchants.png?alt=media&amp;token=1a9fe326-2c7a-4ebd-9ee4-0d4df70b66ec" alt=""><figcaption></figcaption></figure>

| Element                 | Meaning                                                                                                                |
| ----------------------- | ---------------------------------------------------------------------------------------------------------------------- |
| **Title and summary**   | The date, the number of active merchants, the net change vs the previous day, and how many shops were gained and lost. |
| **New install**         | Shops that installed the app for the first time on this day.                                                           |
| **Reinstall**           | Shops that came back, including reactivated stores.                                                                    |
| **Uninstalled**         | Shops that removed the app.                                                                                            |
| **Deactivated**         | Shops whose store became inactive (for example, the store closed or paused).                                           |
| **All / Gained / Lost** | Filter the list: all changes, only gains, or only losses.                                                              |
| **Shop**                | The shop name and its myshopify domain. Click the copy icon to copy the domain.                                        |
| **Change**              | The type of change: New install, Reinstall, Reactivated, Uninstalled or Deactivated.                                   |
| **Reason**              | The reason the merchant gave when uninstalling (if any).                                                               |
| **Time**                | The time of the change, in the time zone you chose.                                                                    |

Use **Next** or the page numbers at the bottom to see more shops.

MRR (gross): details of one day

Click a day on the **MRR (gross)** chart. The window shows how your MRR changed on that day, and which shops made it change. All changes are compared with the **previous day**.

<figure><img src="https://3107817457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8KaEyTr3mMTLCU7QQyAU%2Fuploads%2F3iQEaAib3ivisJ5JULO8%2Fmrr-deepdive-changes.png?alt=media&amp;token=446c9114-83ef-4c12-8951-bc01debb8e9c" alt=""><figcaption></figcaption></figure>

**The summary and the 4 cards**

The title shows the date. The line under it shows the MRR of the day, the change vs the previous day, the number of paying shops and the number of shops on a trial. Each card shows the money and the number of shops for one type of change.

| Card            | Meaning                                                                                                       |
| --------------- | ------------------------------------------------------------------------------------------------------------- |
| **New**         | The shop went from $0 to paying. The small text shows how many shops came from a trial or from a free plan.   |
| **Expansion**   | The shop pays more than the day before.                                                                       |
| **Contraction** | The shop pays less than the day before, but still more than $0.                                               |
| **Churned**     | The shop went from paying to $0. The small text shows how many shops stopped paying and how many uninstalled. |

**The Changes tab**

This tab lists only the shops whose MRR changed on this day. Use the filters above the table to see **All**, **Paying**, **Stopped paying** or **Uninstalled** shops. The number on each filter is the number of shops.

| Column      | Meaning                                                                               |
| ----------- | ------------------------------------------------------------------------------------- |
| **Shop**    | The shop name and its myshopify domain.                                               |
| **Change**  | New, Expansion, Contraction or Churned (see the cards above).                         |
| **Plan**    | The name of the plan. For a **Churned** shop, this is the old plan the shop paid for. |
| **Billing** | How the plan is billed, for example Monthly or Annual.                                |
| **Status**  | The plan status of the shop on that day (see the next table).                         |
| **Before**  | The shop's MRR on the previous day.                                                   |
| **MRR**     | The shop's MRR on this day. A dash (**-**) means $0.                                  |

**Status: the plan status on that day**

| Status           | Meaning                                                                               |
| ---------------- | ------------------------------------------------------------------------------------- |
| **Paying**       | The shop pays for a plan.                                                             |
| **Trial**        | The shop uses a free trial.                                                           |
| **Free**         | The shop uses a free plan.                                                            |
| **Usage only**   | The shop pays only for what it uses. Usage charges are not counted in MRR.            |
| **Discounted**   | The shop has a 100% discount, so it pays $0.                                          |
| **Canceled**     | The merchant clicked cancel. The plan still works until the end of the billing cycle. |
| **Frozen**       | The store does not pay its bill to Shopify.                                           |
| **Uninstalled**  | The shop removed the app.                                                             |
| **Store closed** | The store is closed.                                                                  |

**The small line under Canceled: what is true today**

A **Canceled** shop has one more line under its status. This line shows the shop's situation **today**, not on the day you clicked.

<figure><img src="https://3107817457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8KaEyTr3mMTLCU7QQyAU%2Fuploads%2FFsrXn5jrgiQUSZTCvGUU%2Fmrr-deepdive-canceled.png?alt=media&amp;token=21f6cda4-a323-4ff0-a6a8-12c7ff187b5b" alt=""><figcaption></figcaption></figure>

| Line                           | Meaning                                                                         |
| ------------------------------ | ------------------------------------------------------------------------------- |
| **Paid until {date}**          | The shop can still use the paid plan until this date.                           |
| **Now: paying again**          | The shop pays again.                                                            |
| **Now: installed, not paying** | The paid plan has ended. The app is still installed, but the shop does not pay. |
| **Now: frozen**                | The store does not pay its bill to Shopify.                                     |
| **Now: uninstalled {date}**    | The shop removed the app on this date.                                          |
| **Now: store closed {date}**   | The store closed on this date.                                                  |

{% hint style="info" %}
A **Canceled** shop that shows **Paid until** is not lost yet. You still have time to contact the merchant before the plan ends.
{% endhint %}

**The All paying shops tab**

Click **All paying shops** to see every shop that pays on this day, with its plan, billing, status and MRR.

<figure><img src="https://3107817457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8KaEyTr3mMTLCU7QQyAU%2Fuploads%2F9ezf5x6rYnyLcppmp006%2Fmrr-deepdive-all-paying.png?alt=media&amp;token=bbd41889-2a26-4a54-bb6d-1d90a33beed8" alt=""><figcaption></figcaption></figure>

**How to read it**

* **MRR change of the day = New + Expansion − Contraction − Churned.**
* If **Churned** is often bigger than **New**, you lose paying merchants faster than you win them.
* Many **Uninstalled** shops with the same **Reason** point to one clear problem to fix.
* Many **Deactivated** shops are usually closed stores. This is not caused by your app.

**Example**

Imagine your active merchants drop by 20 on one day. You open the deep dive and click **Lost**. You see 12 **Uninstalled** shops, and 8 of them give the same reason: "Setup is too hard". Next, open the **MRR (gross)** deep dive for the same day. **Churned** is −$60, from 4 paying shops. Now you know the problem, how many merchants it affects, and how much money it costs. Fix it first.

{% hint style="warning" %}
**Shop names and domains are private data.** Use them only to support or contact your own merchants. Do not share screenshots of this window outside your team.
{% endhint %}

{% hint style="success" %}
**Tip:** Click the day with the biggest drop or jump on the chart first. This is where the deep dive teaches you the most.
{% endhint %}

#### Installs & uninstalls

<figure><img src="https://3107817457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8KaEyTr3mMTLCU7QQyAU%2Fuploads%2FGS0Hb59qrqyjJojIdWqB%2Fv2-growth-installs-uninstalls.png?alt=media&amp;token=14678e99-13ba-4584-8209-78ab1bf15203" alt=""><figcaption></figcaption></figure>

This bar chart shows daily movement:

| Bar / line               | Meaning                                                                                   |
| ------------------------ | ----------------------------------------------------------------------------------------- |
| **First install**        | A store installs the app for the first time.                                              |
| **Reinstall**            | A store installs the app again after it uninstalled before.                               |
| **Uninstall**            | A store removes the app.                                                                  |
| **Uninstall (Redacted)** | An uninstall where Shopify later removed the store data (often because the store closed). |
| **Net**                  | Installs minus uninstalls for the day.                                                    |

Below the chart, 3 summary boxes show the totals for the period:

* **Installed**: all installs, split into first installs and reinstalls.
* **Uninstalled**: all uninstalls, split into normal and redacted.
* **Net**: installed minus uninstalled, with the **reinstall rate** (reinstalls ÷ installs) and the share of redacted uninstalls.

Use the buttons at the top to filter by plan type:

* **Total**: all installs, including free plans.
* **Monthly**: only merchants on monthly paid plans.
* **Yearly**: only merchants on yearly paid plans.

#### How to read it

* **Net above zero** means your merchant base is growing.
* A **high reinstall rate** is a good sign. Merchants come back because they need the app.
* Many **redacted uninstalls** usually mean stores closed. This is not caused by your app.

#### How to use it

1. Check the **Net** box first. Is it positive or negative?
2. If it is negative, look at the bar chart. Find days with many uninstalls.
3. Switch to **Monthly** or **Yearly** to see if paying merchants also leave, or only free users.
4. Compare the uninstall days with [Change Log Tracking](https://docs.letsmetrix.com/insights-and-metrics-v2/visibility-and-discovery#change-log-tracking) (for example, a price change).

#### Example

Imagine you had 120 installs and 130 uninstalls. Net is -10. But 25 of the uninstalls are redacted (closed stores). Without closed stores, real uninstalls are 105. So 120 - 105 = +15, and you are still growing. Next, switch to **Monthly**. If paying merchants have a positive net, your business is healthy even if the total net is negative.

#### Combine with other metrics

| Combine with          | What you learn                                                 |
| --------------------- | -------------------------------------------------------------- |
| **Conversion Funnel** | Low installs? Check if page views or the install rate dropped. |
| **Retention & Churn** | High uninstalls? Check which cohorts leave and how fast.       |
| **Revenue**           | See if losing merchants also means losing revenue.             |

### Retention & Churn

> **Retention** is the share of merchants who still have the app after some time. **Churn** is the share who left. Retention + churn = 100%.

#### What question does it answer?

* "How many merchants keep my app after 1 week, 2 weeks, 6 weeks?"
* "Do new merchants stay longer than old ones?"
* "When do most merchants leave?"

#### What you see

The headline (top right) shows the share of merchants still installed, and the churn rate.

<figure><img src="https://3107817457-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8KaEyTr3mMTLCU7QQyAU%2Fuploads%2FOXWWYFMCe9CylYpm1tby%2Fv2-growth-cohort-retention.png?alt=media&amp;token=c4a88e79-6411-4f08-8c72-e9da21bee799" alt=""><figcaption></figcaption></figure>

**Cohort retention table**

| Element                      | Meaning                                                                     |
| ---------------------------- | --------------------------------------------------------------------------- |
| **Cohort**                   | A group of merchants who installed in the same period, with the group size. |
| **W0, W1, W2…**              | The % of the cohort still installed after 0, 1, 2… weeks. W0 is always 100. |
| **Avg all cohorts**          | The average for all cohorts. Use it as your baseline.                       |
| **Daily / Weekly / Monthly** | Group cohorts by day, week or month.                                        |

**Churned + deactivated chart**

| Line                | Meaning                                                                          |
| ------------------- | -------------------------------------------------------------------------------- |
| **Churned**         | Merchants who uninstalled the app on that day.                                   |
| **Deactivated**     | Merchants whose store became inactive (for example, the store closed or paused). |
| **Previous period** | The same data for the compare period.                                            |

#### How to read it

* Read each row from left to right. The numbers go down as merchants leave.
* The **biggest drop** is usually between W0 and W1. This shows how good your first experience (onboarding) is.
* If the numbers stop going down after some weeks, merchants who stay that long are likely to stay for a long time.
* Compare a new cohort with **Avg all cohorts**. A higher number means retention is improving.

#### How to use it

1. Choose **Weekly** to start.
2. Look at the **W1** column. This is your first-week retention.
3. Find the cohort with the best or worst W1. Check what was different in that week (a new feature, a bug, a price change).
4. Look at the **Churned + deactivated** chart. Find days with spikes.

#### Example

Imagine your average W1 is 60%. The cohort from 2 weeks ago has W1 at 70%. That week you released a new setup guide. This suggests the guide helps merchants get value faster. Keep it, and check if the next cohorts also stay above 60%.

{% hint style="warning" %}
**Common mistake:** Do not compare a very small cohort (for example, 10 merchants) with a big one. One merchant leaving can change a small cohort by 10%.
{% endhint %}

#### Combine with other metrics

| Combine with                     | What you learn                                                                            |
| -------------------------------- | ----------------------------------------------------------------------------------------- |
| **LTV** (Revenue & Monetization) | Better retention means merchants pay for longer, so LTV goes up.                          |
| **Reviews & Rating**             | A drop in retention and new bad reviews at the same time often point to the same problem. |
