Renewal Order Analysis Report

Click here for a sample Renewal Order Analysis report

The 'Renewal order analysis' report gives you a detailed breakdown of the response to each effort in a renewal series. This report differs from the 'Renewal rate' report because it shows the number of renewals for each offer you made in a series, including each price, term, and premium combination. It also shows the total numbers of renewal orders you received rather than renewal percentages. This report helps you decide which offers in a series proved most effective.

• Two-party and group subscriptions

Two-party and group subscriptions that are renewed with a group member change (that is, the renewal and the group member change are entered at the same time via the 'Renewal' transaction) are listed in the 'Renewal order analysis' report as not being associated with any particular renewal series. When the 'Renewal order analysis' report is run for a particular renewal series or channel, such two-party and group subscriptions are not included in the report.

Order date range

Leave the 'Order date' field as it is, and your report will include all orders in your database. You can change the date range by right clicking the 'Order date range' field and selecting the appropriate range. If you wish to use a specific date, select the 'Custom dates' range and enter the dates in the date fields.

Include breakout by service code

Check this box and QuickFill will break out the responses by service code, in addition to price, term and premium.

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:

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