Purge expired subscriptions update

Use the expired subscription purge to delete the customer records, subscription records, order records, and subscription history records associated with expired or canceled subscriptions.

You must specify the publication whose subscriptions are to be purged and a range of expiration dates.

Normally both expired and canceled subscriptions are purged, but you have the option of not purging any of the four types of canceled subscriptions.

Normally the customer records associated with the purged subscriptions are deleted, but you have the option of converting them to prospects and linking them to a list code.

We recommend that you purge one year's worth of expired subscriptions at a time and link each group to a unique list code that identifies the publication and the year of expiration. That way you can be more selective when you do promotional mailings to your expires.

To run the expired subscription purge, select 'Purge...' under the 'Updates' menu and then select 'Expired subs'.

Purge subs to publication

Enter the code for the publication that the subscriptions you want to purge belong to.

that expired between issue __ and __

Enter the range of expire issues for the subscriptions that you wish to purge. You can enter the issue number directly, or press the F2 key to select from a list of issues.

Tracking codes

If you wish to restrict the purge to subscriptions linked to a set of specific tracking codes, enter those tracking codes here, otherwise leave these fields blank.

Start date

Specify a date range, and only subscriptions whose first order was entered within that range will be purged. Specifying a date range is useful for publications that are for single products, not subscriptions. Orders for such products all start and end with a single "issue", therefore it is necessary to specify a date range to avoid purging recent orders .

Include subscriptions...

These fields let you decide whether you want to purge any of the four types of canceled subscriptions. This is of particular significance when you are placing the purged customers on a prospect list. You probably don't want to waste money making promotional mailings to someone who was canceled for nonpayment. To exclude any of these types of canceled subscriptions from the purge, click on the check boxes to deselect the appropriate ones.

Convert shiptos, Convert billtos

Check either or both of these boxes if you want to place the purged customers on a prospect list. You will almost always want to include the ship-tos on the prospect list. If you have a consumer publication with lots of gift subscriptions, then you will probably also want to include the bill-to names. If you do not want to convert ship-tos or bill-tos, leave these field blank.

Link converted customers to list code

Enter the list code that you are going to use to identify the converted customers. You must have defined the code previously using the 'Lists' definition screen—click here for details on defining marketing lists.

Date for prospect record

Enter the date to be stored in the prospect record. QuickFill will assume today's date, unless you specify otherwise.

Retain qualification data (audit system field)

QuickFill retains the qualification data for subscribers that are converted to prospects by default. If you do not want this data to be included in the prospect records that are created, click in this field to deselect it.

 

Click here for more information on Filter screens.

 

After you are done filling in the filter, click on "OK" and a message box will appear with the following options:

Run it now exclusively, only lookup allowed
Run it with tonight's jobs
Save to an existing job list
Create a new job list

 

Click here for details on options for running purge updates.

 

See Also