---
updatedAt: 2025-11-05T09:25:14.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# Churned Subscribers

total_churned_subscribers

# Overview

Churned Subscribers refers to the number of customers who have canceled a subscription in the specified time range.

> 📘 Churned Subscribers = Customers who Canceled their Subscription

The calculation is based on data from the [Subscription Metrics](https://triplewhale.readme.io/docs/subscription-metrics-table#/) table.

### Detailed Breakdown

The formula above is derived from the following components:

* Churned Subscribers = `sum(total_churned_subscribers)` --> [Subscription Metrics](https://triplewhale.readme.io/docs/subscription-metrics-table#/) table

# Insights and Actions

Churned Subscribers helps you assess overall retention performance and identify where customers are disengaging from your subscription offering:

* **Monitor Retention Trends**: Track churn rates over time to detect changes in customer behavior or the impact of pricing, product, or service updates.
* **Identify Root Causes**: Analyze churned subscribers by subscription platform, product category, or billing cycle to uncover patterns driving cancellations.
* **Balance Churn and Acquisition**: Compare Churned Subscribers with New and Reactivated Subscribers to measure whether your overall subscription base is expanding or contracting.

### Related Metrics

* **Total Cancelled Subscriptions** – Indicates how many subscriptions ended, complementing churn data at the subscription level.
* **Active Subscribers** – Shows the total number of current subscribers, helping you calculate churn as a percentage of your active base.
* **Reactivated Subscribers** – Reflects how many churned customers returned, providing insight into recovery of lost subscribers.

# Example Use

### Prompt

> How many subscribers churned yesterday?

### Response

<Image border={false} src="https://files.readme.io/1790f8b5bfcd60a691d9c1b99ad6ff2acf01934f065016bfc91d624fb7c7b245-image.png" />

### Query

```sql
SELECT
  SUM(smt.total_churned_subscribers) AS total_churned_subscribers
FROM
  subscription_metrics_table AS smt
WHERE
  smt.event_date = CURRENT_DATE() - 1

```

<br />