# Recurly: Churn Analysis

## Description

* Each record represents a subscription and their churn status and details.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/recurly/resources/recurly.svg" alt="" data-size="line"> Recurly

## Columns

| Type     | Name                         | Description                                                                                                                                                   |
| -------- | ---------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING   | subscription\_id             | Unique identifier for the subscription.                                                                                                                       |
| DATETIME | activated\_at                | When the subscription was activated.                                                                                                                          |
| STRING   | account\_id                  | The account this subscription belongs to.                                                                                                                     |
| STRING   | account\_state               | Current state of the account.                                                                                                                                 |
| DATETIME | canceled\_at                 | When the subscription was canceled. Can take future dates.                                                                                                    |
| DATETIME | current\_period\_ended\_at   | Current billing period ends at.                                                                                                                               |
| DATETIME | current\_period\_started\_at | Current billing period started at.                                                                                                                            |
| DATETIME | expires\_at                  | When the subscription has expired. Can take future dates.                                                                                                     |
| STRING   | expiration\_reason           | Reason for subscription expiration.                                                                                                                           |
| BOOLEAN  | has\_auto\_renew             | Whether the subscription renews at the end of its term. Default: true                                                                                         |
| STRING   | plan\_name                   | This name describes your plan and will appear on the Hosted Payment Page and the subscriber's invoice.                                                        |
| STRING   | plan\_state                  | The current state of the plan. Enum: "active", "inactive"                                                                                                     |
| DATETIME | subscription\_end\_date      | When the subscription actually ends, factors in cancellations earlier than the expected end date.                                                             |
| INTEGER  | subscription\_interval\_days | Subscription interval by number of days, accounting for cancelled/expired periods.                                                                            |
| INTEGER  | subscription\_period         | The nth subscription defined by the time period set. Subscriptions start with month 0.                                                                        |
| STRING   | subscription\_state          | The current state of the subscription. Enum: "active", "canceled", "expired", "failed", "future", "paused"                                                    |
| DECIMAL  | subtotal                     | Estimated total, before tax.                                                                                                                                  |
| DECIMAL  | unit\_amount                 | Subscription unit price.                                                                                                                                      |
| STRING   | churn\_reason                | Reason for churn. null if subscription has no expiration date. Enum: "account closed", "canceled", "gift ended", "non-payment", "non-renewing", "trial ended" |
| STRING   | churn\_reason\_type          | Type of churn, null if subscription has no expiration date. Enum: "involuntary", "voluntary"                                                                  |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/recurly-churn-analysis.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.