# Churn Reports

***Churn*** is the percentage of subscriber base that must be replaced on an annual basis to maintain the same level of home delivery circulation. The formula for computing churn is the total annual permanent stops divided by the average annual home delivery circulation:\
`stops ÷ circulation`

When studying churn, subscribers can be broken down into *core* (subscribed for at least 12 months consecutively) and *marginal* (subscribed for less than 12 months consecutively). Typically, churn will be greater among marginal subscribers.

Another component of churn has to do with the reason for the stop. Some stops are *controllable*—they result from poor service, price, and other controllable factors. Others are natural, resulting from difficult economic conditions, people moving away from the area, and so on. While the strategies of the newspaper can impact controllable churn, there is little that can be done about natural churn.

{% hint style="info" %}
**Note:** *If a subscription stops permanently but starts again within 30 days, that stop/start will not be included in churn calculations.*
{% endhint %}

Circulation keeps churn history files. These files can be updated on a monthly or weekly basis (as defined in Business Rules) as part of End Publ Run.

#### Three reports help in analyzing churn:

* The Churn Analysis Report lists the percentage of annual churn for core subscribers and marginal subscribers.
* The Churn Summary Report lists natural and controllable churn percentages for both core and marginal subscribers. This report is valuable management tool for implementing appropriate strategies to deal with churn. For example, high controllable core churn may represent poor service, and you might develop ways to deal with that churn, such as customer service training, etc.
* The Controllable Churn report lists controllable churn by permanent stop reason code for both core and marginal subscribers. This report provides a snapshot view of the controllable reasons why subscribers permanently stop the paper.

{% hint style="info" %}
**Notes:**

* Business Rules determine the day of the week on which churn is updated (if at all), and whether churn is updated weekly or monthly.
* Stop reasons are set up as either controllable or natural. See Reason in the Setup Manual for more information
* The End Publ Run option will take approximately 10-15 minutes more to run on days when Churn History updating (as determined by Business Rules) is done.
* Mail subscribers are not included in the churn reporting.
* The churn information in the reports will reflect the churn history as of the latest update.
* Subscription demographics can be updated while generating the churn reports.
  {% endhint %}

#### To produce a churn report:

1. Select the report from the Churn menu.<br>

   ![](/files/wb2WPcgqrHwABYGNvXwS)

2. Click Add and complete the following fields.<br>

   <table><thead><tr><th width="184.48130181209146">Field</th><th width="83">Type</th><th>What to enter</th></tr></thead><tbody><tr><td>PRODUCT</td><td>setup</td><td>Enter the ID of the product for which to calculate churn.</td></tr><tr><td>RUN DATE</td><td>date</td><td>Enter the date for which to process annual churn. For example, enter “03/01/10” to calculate churn for the date range 03/01/09 through 02/28/10.</td></tr><tr><td>REPORT TYPE</td><td>predefined</td><td>Indicate whether the report should be for Print, Digital, or Both.</td></tr><tr><td>Include Mail</td><td>yes/no</td><td>Indicate whether the report should include Mail.</td></tr><tr><td>DELIVERY SCHEDULE</td><td>setup</td><td>Enter the delivery schedule for which to calculate churn (enter “*” to multi-select delivery schedules).</td></tr><tr><td>UPDATE DEMOGRAPHICS</td><td>yes/no</td><td>Subscription demographics can be updated when running the churn reports. In this field, identify whether you want to update subscription demographics.</td></tr><tr><td>DEMOGRAPHIC</td><td>setup</td><td>Select the demographic to be updated.</td></tr><tr><td>CORE ANSWER</td><td>setup</td><td>Select the demographic answer to be created for core subscribers.</td></tr><tr><td>MARGINAL ANSWER</td><td>setup</td><td>Select the demographic answer to be created for marginal subscribers.</td></tr></tbody></table>

3. Click OK and then Continue to produce the report.

#### Example—Churn Analysis Report

![](/files/kxUvgXEJ8BQNJOks92sC)

#### Example—Churn Summary Report

![](/files/mnuX7oLq2DOgFaLAeeZI)

#### Example—Controllable Churn Report

![](/files/vY6BMFHC5TWVwyNiMBWw)


---

# 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://docs.navigaglobal.com/circulation-user-manual/reporting/churn-reports.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.