Description
This statistics report allows you to evaluate transactions affectinglive subscriptions separately according to purchase reasons anddelivery end reasons for a selected period. A maximum of 40 purchasereasons and/or delivery end reasons can be listed. If there are morethan 40, you must enter selection criteria to restrict those thatapply.
The type and content of the list to be displayed can be determined bymeans of entries on the selection screen.
Note: This report should only be run in dialog for small datasets(system load, runtime).

Selection option
The selection screen is divided into 2 areas:

• Data selection: You can specify criteria to restrict the data record to
be evaluated.

• Output control: You can specify criteria on the outline or
summarization levels for the list.

Data selection options:


• Period (required field)

The report evaluates subscriptions in this period.

• Subscription sales document type

You can make restrictions according to certain subscription types; ifyou do not make any entries, all subscription sales document types areevaluated.

• Sales organization/distribution channel/division

You can specify selection criteria relating to the sales organization,distribution channel and division; if you do not specify any criteria,the report processes all subscriptions regardless of these factors.

• Normal delivery country

Here, you can restrict the subscriptions evaluated to those for thecountry normally supplied (for example, if a redirection is made to aforeign country, this is the country from the standard order item); ifyou leave this field blank, the statistics include all subscriptionsirrespective of the country.

• Publication

The publications specified here are included in the evaluation; if youdo not specify any publications, the report evaluates all of them.

• Edition

The editions specified here are included in the evaluation; if you donot specify any editions, the report evaluates all of them.

• Service type

You can make entries to restrict the service types evaluated; if you donot specify any criteria, the report evaluates all service types.

• Item types to be included

Flag the appropriate fields to restrict the dataset to standard items,free items (with or without automatic transformation to chargeable),trial items (with or without automatic transformation to chargeable) orcombinations of the three; you must select at least one item type.

• Include all reversed orders/include if delivered/ignore

These parameters allow you to control how reversed orders (for whichdeliveries may have been made up to reversal) are to be treated.

• Include backdated orders

If you select this parameter, the statistics include backdatedsubscription orders from the initial validity date (even before theregular start of delivery).

• Include orders where delivery is not viable

If you select this parameter, the statistics include subscriptionorders for which delivery was not viable during the analysis period.

• Order number (for test)

For testing purposes, you can restrict data selection to individualorders. If you select individual orders or only a few in this field,the statistics can also be run in dialog processing.

Options for output control


• Include weighted partial subscriptions

This parameter allows you to determine whether partial subscriptions(e.g. Saturday subscribers) are counted according to the partialsubscription weighting from the mix offers for the edition or whetherthe purchase quantities for partial subscriptions are to be counted infull.

• Postal code area evaluation variant

The evaluation includes the postal code areas in the variant youdefine. All other postal codes are grouped under 'Others' and listed.

• Purchase reasons for list

Any purchase reasons you specify here are listed separately in thestatistics; all other purchase reasons are grouped and listed under'Others'. (Note: If there are a large number of purchase reasons, youmust restrict selection here since otherwise the width of the listdisplayed will exceed that allowed.)

• Generate list 'Transactions by purchase reasons in postal code areas'

You can create these statistics by selecting the summarization level'Publication' and/or 'Edition'; if you select both options, the reportdisplays a totals sheet for all editions each time the publication ischanged. Summation and output of subscriptions is performed accordingto the different postal code areas.

• Generate list 'Transactions by purchase reasons for each edition'

If you select the parameter 'Create list', you can have the Systemdisplay these statistics; the subscriptions are totaled for eachedition throughout all postal code areas.

• List delivery end reasons

The delivery end reasons you specify are listed separately in thestatistics; all other existing delivery end reasons are grouped andlisted under 'Others' (as in 'List purchase reasons').

• Generate list 'Transactions by delivery end reasons in postal code
areas'
You can select the summarization level for the publication and/oredition to have these statistics generated; if you select both options,the report displays a totals sheet for all editions each time it moveson to a different publication. Summation and output of subscriptionstakes place according to the different postal code areas.

• Generate list 'Transactions by delivery end reasons for each edition'

You can select this indicator to have these statistics created;summation of subscriptions takes place for each edition throughout allpostal code areas.

Precondition
A weighting in the form of a fraction (numerator and denominator) mustbe specified for each entry in the mix offer for the edition, sincetotaling takes place in accordance with the weighting specified. Youcan maintain mix offers in the processing function for editions.
The postal code area evaluation variants and the related postal codeareas and postal codes must be maintained. They can be maintained inCustomizing for sales under 'Reporting'.
You should use the print format 65 lines x 132 columns.

Output
1. List 'Transactions by purchase reasons in postal code areas'
These statistics are displayed per edition (if the summarization levelis 'Edition') or per publication (if the summarization level is'Publication') for the different postal code areas. If you select bothsummarization levels, the report displays a totals sheet for alleditions each time it moves on to a different publication.
As the header of the statistics, the report displays the selectedanalysis period, the publication and the edition if this was thesummarization level chosen as well as the selected item type on eachpage.
First, the list contains the total of all transactions determined bypurchase reasons for each postal code area. If specified on theselection screen, the list then displays the purchase reasons notspecified and therefore not included in this total under 'Others', thenumber of reassignments (reassignment = relocation or change ofaddress), followed by the quantities determined sorted by purchasereasons.
A total is displayed at the end of each list.
2. List 'Transactions by purchase reasons for each edition'
These statistics are displayed for each publication for the differenteditions.
As the header of the statistics, the report displays the selectedanalysis period, publication and selected item type on each page.
First, the list displays the total of all transactions determined bypurchase reasons for each edition. If specified on the selectionscreen, the list then displays the purchase reasons not specified andtherefore not totaled under 'Others', the number of reassignments(reassignment = relocation or change of address), followed by thequantities determined by individual purchase reasons.
A total is displayed at the end of each list.
3. List 'Transactions by delivery end reasons in postal code areas'
These statistics are displayed for each edition (if the summarizationlevel chosen was 'Edition') or for each publication (if thesummarization level chosen was 'Publication') for the different postalcode areas. If you selected both summarization levels, the reportdisplays a totals sheet for all editions each time it moves on to adifferent publication.
As the header of the statistics, the report displays the selectedanalysis period, publication, edition if the summarization level'Edition' was selected as well as the selected item type on each page.
First, the list displays the total of all transactions determined bydelivery end reasons for each postal code area. If specified on theselection screen, the list then displays the delivery end reasons notspecified and therefore not totaled under 'Others', the number ofreassignments (reassignment = relocation or change of address),followed by the quantities determined by individual delivery endreasons.
A total is displayed at the end of each list.
4. List 'Transactions by delivery end reasons for each edition'
These statistics are displayed for each publication for the differenteditions.
As the header of the statistics, the report displays the selectedanalysis period, publication and selected item type on each page.
First, the list displays the total of all transactions determined bydelivery end reasons for each edition. If specified on the selectionscreen, the list then displays the delivery end reasons not specifiedand therefore not totaled under 'Others', the number of reassignments(reassignment = relocation or change of address), followed by thequantities determined by individual delivery end reasons.
A total is displayed at the end of each list.
If incorrect or missing entries were determined for partialsubscription weighting, these are listed at the end in an error table.Records containing errors in partial subscription weighting are notincluded in the statistics. Records with postal codes that are not inthe postal code evaluation area are grouped and displayed under'Others'.

Example
You want to create statistics for all subscription sales documenttypes, all sales areas, for publications A to C, for all editions,service type 'Full subscription' and the item types standard and freeitems. The evaluation is to be performed for the postal code areaevaluation variant PL1. The purchase reasons 101 to 110 and deliveryend reasons 105 to 109 are to be displayed in the list.
You want to display the list 'Transactions by purchase reasons inpostal code areas' with the summarization levels Publication andEdition as well as the list 'Transactions by delivery end reasons foreach edition'.
To do this, you make the following entries on the selection screen:


• Data selection

Period 01.05.1996 31.05.1996
Subscription SDoc. type No entries
SOrg./DChann./Division No entries
Publication A C
Edition No entries
Service type VA
Standard items x (selected)
Free items x (selected)
Trial items Not selected

• Output control

PCode area eval.variant PL1
Purch.reasons for list 101 110
Del.end reasons for list 105 109
Generate list 'Transactions by purchase reasons in postal code areas'
Publication x (selected)
Edition x (selected)
Generate list 'Transactions by delivery end reasons for each edition'
x (selected)