Renewal Revenue Report

Click here for a sample Renewal Revenue report (by prior renewal series)

Click here for a sample Renewal Revenue report (by order source and renewal price)

Click here for a sample Renewal Revenue report (by service code and efforts sent)

 

Use this report to determine the number of renewals you have received from various sources and the gross and net revenue received from those renewal orders.  The numbers can be broken down in a wide variety of ways.  If you run the report with its default options you will get the most basic form of the report—a count of the number of renewals received since the inception of the system broken down by publication.  To limit the reporting period you can specify either a range of renewal order dates or a range of expire dates.  For a finer breakdown you can specify that the report be sorted by attributes of the order being renewed or of the renewal order itself.  For example you might want a report that is broken down by the term of the renewal so that you can compare the number of one, two and three year renewals you are getting.  Or you might get a report broken down by the source code of the renewal order, thereby showing you how well each of these sources is performing.  For an even finer breakdown you can specify two sorts, thus allowing you to produce what is sometimes called a "source to source" report.  To do this you would request a primary sort by the source of the prior order and a secondary sort by the source of the renewal order.

If you are primarily interested in a report that is broken down by the attributes of the prior order you would be better off running the Renewal Rates report.  That report has everything the Renewal Revenue report has, plus information about the percentage of orders that have been renewed or allowed to expire.  The Renewal Revenue report on the other hand just counts the number of orders and the money received from the renewals—there is no information regarding renewal percentages.

On the other hand if you are interested in getting the answer to questions such as "how much money did I get from renewals last year, broken down by month", or "how many renewals and how much money have I received in response to that blanket renewal I mailed last month" then you are better off using the Renewal Revenue report.  This is because your question involves selecting renewals based on the attributes of the renewal itself.

Finally, if you want to answer the question "how much money did I get from both new and renewal orders last year, broken down by month" then you should run either the Payment Rates or Revenue report.  Like the Renewal Revenue report the Payment Rate report provides order counts and gross and net revenue figures, but it includes all types of orders, not just renewal orders.  Furthermore it can tell you what percentage of the bill-me orders eventually get paid and how many bills you have to mail to get the payment.

The 'Renewal revenue' report filter contains four tabs ('General', 'Subscriptions',  'Prior Orders' and 'Renewal Orders'). Use the Ctrl-RightArrow and Ctrl-LeftArrow key combinations or your mouse to move from one tab to the other.

General tab:

Primary sort, Secondary sort

In this fields you choose how you want the report broken down.  By default, QuickFill produces a simple breakdown by publication.  Other available breakdowns include:

Prior order source

Choose this to get a report broken down by the source of the order that was renewed.  The source of the prior order might be a tracking code if the prior order was the original order, or it might be a renewal effort code if the prior order was itself a renewal.  As a rule, you'll want to break down your report by order source only when you need to analyze revenue for orders from quite specific sources. If you have a lot of tracking codes and renewal effort codes then choosing this sorting option will produce a very long report and you will usually want to select a particular subset of your codes on the "Cohort" tab of the filter.

Prior order channel

Choose this to get a report broken down by the order channel of the order that was renewed.  For example, you can get a report that shows the renewal revenue for orders you received via direct mail, telephone, or fax.

Prior order term

Choose this option to get a report broken down by the term of the prior order.  Again, you might want to run the Renewal Rates report since that report will also tell you whether your one or two year term subscribers are more likely to renew.

Prior order service

Choose this option to get a report broken down by the service code of the prior order.

Prior renewal series

Choose this to get a report broken down by the renewal series that was used to obtain the renewal.  This would be useful if you wish to compare the performance of your regular renewal series and a new series that you are testing. However you might want to run the Renewal Rates report instead since that report will also tell you the percentage of orders on each series that have renewed or been allowed to expire.

Renewal order source

This sort option provides a report that is broken down by the source of the renewal order.   Renewal order source codes are also known as renewal effort codes.  Use this option to compare the results from different renewal order sources.  This is particularly useful for tracking the revenue generated by renewal methods other than QuickFill's renewal series, such as blanket renewal mailings or telemarketing renewals. To do this, define renewal effort codes (sources) for each off-series method. When you enter renewal orders you use the appropriate renewal effort code. Now you can use the 'Renewal revenue' report sorted by renewal source  to track each renewal method.

Renewal order channel

Choose this to get a report broken down by the order channel of the renewal order.  For example, you can get a report showing the renewal revenue for orders you received via direct mail, telephone, or fax. Or you can use it to show the renewal revenue for orders that a salesperson was responsible for generating.

Renewal order premium

Choose this option to get a report broken down by the premium code associated with the renewal order. This is useful for comparing the amount of money brought in by the use of your premiums.  

Original channel

This version shows you renewal revenue broken down by the channel by which the original subscription was received.  Use it to compare the renewal results from different channels used for new subscriptions.

Marketing Plan

Choose this option to get a report broken down by the marketing plan used to obtain the original subscription. Typically, marketing plans are used to identify promotional campaigns or mailings that you make.  You might use this sorting option to get a report that shows you how much money is being brought in by renewals of the subscriptions you obtained from your various promotions.

List

This is similar to the Marketing Plan option but provides more detail.  In any one promotional campaign you may make mailings to several different lists.  This version of the report will show you how much money is being brought in by renewals of subscriptions obtained by mailings to each of those lists.

Tracking code

This option shows you renewal revenue for orders broken down by the subscription's original tracking code. Use this report to analyze renewal revenue on new orders from very specific sources. For example, new orders you got from the Business Week mailing list using a pink marketing package and a Swiss Army knife premium.  As a rule, you'll want to break down your report by tracking codes only when you need to analyze revenue for orders from quite specific sources, and you will select those sources on the Cohort tab of the report.

Package

This option shows you renewal revenue broken down by the marketing package associated with the original subscription order. Use it to compare the effectiveness of different marketing packages.

Agency

This option shows you renewal revenue broken down by subscription agency.  Use it to compare the results from different agencies.

Expire issue, expire month, expire quarter or expire year

These four options produce a report sorted by the expiration date of the prior order. Since QuickFill allows issue dates to take a wide variety of formats, such as "Winter 2015" or "June/July 2015" it is necessary to associate each issue with a particular date on the calendar.  This association is provided by the 'Calendar date' field on the definition screen for Issues.  When you define your issue table QuickFill will automatically provide a value for the calendar date field, but you should double check it to make sure that it matches your intention.  This is especially important for bimonthly and quarterly publications.

Renewal efforts sent

Choose this option to get a report broken down by the number of renewal notices that were mailed before the renewal order was received.  Using this you can determine just how much money is being brought in by the tail end of your renewal series.  Although it may seem like those last renewal efforts are not cost effective on the basis of dollars spent versus dollars received they are never the less an important part of maintaining your circulation.  It is usually much more expensive to keep up your circulation by beating the bushes for new subscribers than it is to convince your existing subscribers to renew, even if you have to mail eight, ten or twelve renewal notices.

Effort responded to

This is similar to the 'Renewal efforts sent' sort order.  The difference is that the report is broken down by the effort number the subscriber finally responded to, rather than the last effort mailed.  The numbers can be different, especially if your subscribers are prone to stuffing the renewal notices in a desk drawer and pulling them out and mailing them a couple of  months later.

Renewal order term

Choose this option to get a report broken down by the term of the renewal order.  If both the primary and secondary sorts are by term then you will get a two-way breakdown that shows you whether your one year term subscribers are more likely to renew for one or two year terms, and vice versa.

Renewal order service

Choose this to get a report broken down by the service code of the renewal order. If you choose this option in combination with a primary sort by the service code of the prior order you can get a report that shows the transitions from one service code to another.  This would be especially useful if you offer print and email delivery since it will tell you how many print subscribers are moving to email delivery or vice versa.

Renewal order price

Choose this option to get a report broken down by the price of the renewal order, thereby telling you the proportion of orders received at each price level.

Renewal month, quarter and year

These three options provide a calendar related breakdown that is based on when the renewal order was received.  This is useful in answering questions such as "How much money did I get from renewal orders last month (or last year)".

Subscriptions, Copies

Select 'Copies' if you have group or bulk subscriptions for large numbers of copies so that you will get a more accurate picture of your renewals. Otherwise, select 'Subscriptions'.

Nonzero price, Zero price

Since this is a "revenue" report you would think that only orders with a nonzero price would be included, but if your publication has controlled nonpaid circulation and you want to include the nonpaid renewals (requalification orders) in the report you can do so by selecting the 'Zero price' checkbox.  Conversely, if all you want to see is the figures for requalifications you should clear the 'nonzero price' checkbox.

Include orders expiring between ___ and ___

In these two fields, you select a range of expiration dates for orders you want included in your report. The beginning and end of the range are expressed relative to the current date. Say It is now July and you are working with a monthly publication. To see renewal revenue for subscriptions that expired between February and July you would select "beginning of six months prior" for the start of the range and "end of this month" for the end of the range. If you save the report filter on a job list and then run it again in November, the date ranges will automatically advance by four months so that the report will include subscriptions that expired between June and November.

But note that your renewals series will almost certainly begin well before the subscription is due to expire so you have probably received renewals from subscriptions that are due to expire after the current month.  If your renewal series begins four months before expiration then you might add an extra four months to your range, as in "Include orders expiring between six months prior and end of four months after this".

Report data file

Enter a file name in this field and QuickFill will create your report and will also generate a data file that contains all of the data that was used to produce that report. This feature is useful if you want to examine the data underlying the report more closely or if you want to present it in formats other than the built-in QuickFill report format. The report data file can be in dBASE (DBF), comma delimited (CSV) or tab delimited (TXT) format. The file name extension that you enter determines the format of the file. The fields in the file are as follows:

ORDERNUM

Order number

PRIORNUM

Order number of prior order

PUB

Publication code

PRICE

Price, not including tax

PAID

Amount paid, not including tax

ISPAID

True if order has been paid

QUANTITY

Number of copies ordered

EXPISSNUM

Expire issue number

EXPISSDATE

Expire issue date

EXPISSDESC

Expire issue description

RENSERIES

Renewal series

EFFSENT

Number of renewal efforts sent

EFFRESP

Renewal effort they responded to

PRIORTYPE

Type of prior order
0 = New, 1 = 1st renewal, 2 = subsequent

PRIORSRC

Prior order source code

PRIORCHAN

Prior order channel code

PRSALPER

Prior order salesperson code

PRIORTERM

Prior order term (number of issues)

PRIORSVC

Prior order service code

RENSRC

Renewal order source code

RENCHAN

Renewal channel code

RENTERM

Renewal order term (number of issues)

RENSVC

Renewal order service code

RENPREM

Renewal order premium code

ORIGCHAN

Original channel code

ORIGSALPER

Original salesperson code

PLAN

Marketing plan code

LIST

List code

TRACK

Tracking code

PACKAGE

Package code

AGENCY

Agency code

 

Click here for information on the 'Subscriptions' tab,  the 'Prior Orders' tab or the 'Renewal Orders' tab.

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