Subscription Statistics Report

The columns of this report correspond to each of the possible subscription statuses.

If you run the report in its default configuration, the rows of the report correspond to the publications in your database. There are several other variations which you can select in the "Sorted by" field. These variations include breakdowns by:

Publication only
Tracking code
List
Marketing plan
Package
Channel
Service code
Subscription agency
Original term
Renewal series
Zip code (as shown in the sample above)
Request type (audit system only)
Subscription classification (audit system only)

The filter for the subscription export has several tabs. The tabs, except for the first, are the similar to those for the Subscription export. You can filter on a wide variety of characteristics of the customer records, subscription records and order records.

Single subscriptions, two-party subscriptions, group subscriptions

Normally the report will include all three types of subscriptions. By un-checking one or more boxes you can narrow your selection to a particular type of subscription. This might be useful if you want to verify that all of your two-party and group subscriptions are assigned to a special renewal series that you have set up for gift subscriptions. This is easily accomplished by choosing to sort the report by renewal series and checking just the two-party and group subscriptions boxes.

Count

Use these radio buttons to indicate whether your report should count subscriptions, customers, or copies. The following table shows how single, two-party and group subscriptions are counted.

	Counting subscriptions	Counting customers	Counting copies
Single subscription	Counts as 1	Counts as 1	Counts the order quantity
Two-party subscription	Counts as 1	Counts as 1	Counts the order quantity
Group subscription	Counts as 1	Counts 1 for each group member	Counts the shipping quantity for each group member

If your filter criteria includes any customer fields then it is important to understand how those filter criteria are applied to two-party and group subscriptions. The rules are as follows:

For single subscriptions there is only one customer record, so the customer filter criteria are applied to that record.
For two-party subscriptions the customer filter criteria are applied to the ship-to customer.
For group subscriptions the customer filter criteria are applied to the group members, but exactly what gets counted depends on whether you chose to count subscriptions, customers or copies. If you are counting subscriptions then the subscription will get counted if any group member matches the customer filter criteria. If you are counting customers, then only those group members that match the customer filter criteria will be counted. If you are counting copies then the number of copies being sent to each group member will be counted if that member matches the customer filter criteria.

Include detailed breakdown of cancels by cancellation reason

Use this check box to indicate whether your report should include a breakdown of cancels by cancellation reason.

Click here for more information about Filter screens and Options for running reports.