Description
This statistics report allows you to evaluate transactions affectinglive subscriptions for a selected period. The type and content of thelist to be displayed can be determined by means of entries on theselection screen.
Note: This report should only be run in dialog for small datasets(system load, runtime).

Selection options
The selection screen is divided into 2 areas:

• Data selection: You can specify criteria to restrict the data records
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 according to thecountry to which deliveries are normally made (e.g. in the case ofredirections to foreign countries, your entry here would be the countryin the "standard order item"); if you leave this field blank, thereport processes all subscriptions regardless 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.

• 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) andtrial items (with or without automatic transformation to chargeable) orcombinations of the three; you must select at least one item type.

• Reversed orders: include all / include if delivered / ignore

These criteria allow you to determine how reversed orders (which mayhave been delivered up to reversal) are to be processed.

• Include backdated orders

If you select this parameter, the report takes account of backdatedsubscription orders from the start date of validity (or more precisely,before the regular start of delivery).

• Include orders where delivery not viable

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

• Order number (for test)

For test purposes, you can restrict selection to individual orders. Ifyou select individual orders or only a few orders here, you can alsorun the statistics program in dialog.

Options for output control


• Include weighted partial subscriptions

This parameter controls whether partial subscriptions (such as Saturdaysubscriptions) are counted according to the partial subscriptionweighting specified in the mix offers for the edition or whether thepurchase quantities for partial subscriptions are to be counted infull.

• Postal code area evaluation variant

To display a number of sublists (see below), you need to specify apostal code area evaluation variant. The subscriptions in the relevantlists are totaled according to the postal code areas defined in theevaluation variant.

• Generate list 'Transactions by sales source'

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 of subscriptions is performed according to thevarious sales sources.

• Generate list 'Transactions by sales promotion and sales source'

Summarization levels
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 of subscriptions is performed according to eachsales promotion and sales source. The summarization level 'Publ./PCodeinterval' generates a list for each publication and postal codeinterval.
Sales promotions for list
If you make an entry in the field 'Sales promotions for list', thereport lists the sales promotions you specified separately in thestatistics; all other sales promotions are grouped and displayed under'Others'.

• Generate list 'Transactions by postal code areas'

You can select the summarization level for the publication and/oredition to have these statistics generated; if you select both options,he report displays a totals sheet for all editions each time it moveson to a different publication.
You need to specify a postal code area evaluation variant for thesesublists.

Precondition
You must maintain the weighting for the partial subscriptions in themix offers for the editions, since totaling is carried out according tothe weighting specified. Mix offers can be maintained when editingeditions.
Missing entries are gathered in an error table and displayed at the endof the list.
For the postal code area statistics, you must maintain the areaevaluation variants, the accompanying postal code areas and theirpostal codes. This information can be maintained in Customizing forSales under 'Reporting'.

Output
1. List: 'Transactions by sales source'
These statistics are displayed per edition (if the summarization levelchosen is 'Edition') or per publication (if the summarization level is'Publication') for the different sales sources. If both summarizationlevels are selected, 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 displays the live subscriptions for each sales sourceon the first day of the analysis period. It then lists the newsubscriptions in the remainder of the analysis period grouped as Total,Reassignment (= relocation or change of address) and Net (differencebetween Total and Reassignment). The same information is displayed forreversals. Finally, the live subscriptions on the last day in theanalysis period are listed.
A total is displayed at the end of each list.
2. List 'Transactions by sales promotion and sales source'
These statistics are displayed per edition (if the summarization levelis 'Edition') or per publication (if the summarization level is'Publication'), per postal code interval and publication (if thesummarization level is 'Publication/postal code interval') and persales promotion for the different sales sources.
If you select both summarization levels, the report displays a totalssheet for all editions each time it moves on to a differentpublication.
As the header of the statistics, the report displays the selectedanalysis period, the publication and the edition (or postal codeinterval) if this was the summarization level chosen as well as theselected item types on each page.
First, the list displays the live subscriptions on the first day in theanalysis period for each sales promotion and sales source. It thenlists the new subscriptions in the remainder of the analysis period, inthe blocks Total, Reassignment (= relocation or change of address) andNet (difference between Total and Reassignment). The same is listed forreversals. Finally, the list contains the live subscriptions on thelast day of the analysis period.
If you made an entry in the field 'Sales promotions for list', thereport only lists these sales promotions. All other existing salespromotions are added up and listed under 'Others'.
At the end of each sales promotion, the report displays a subtotal andat the end of each list, a total.
3. Generate list 'Transactions by postal code areas'
These statistics are displayed per edition (if the summarization levelis 'Edition') or per publication (if the summarization level is is'Publication') for the different postal code evaluation areas in thepostal code area evaluation variant specified on the selection screen.If both summarization levels are selected, the report displays a totalssheet for all editions each time it moves on to a differentpublication.
As the header of the statistics, the report displays the selectedanalysis period, the publication and the edition (or postal codeinterval) if this was the summarization level chosen as well as theselected item types on each page.
First, the list displays the live subscriptions on the first day in theanalysis period for each postal code evaluation area. It then lists thenew subscriptions in the remainder of the analysis period, in the b
locks Total, Reassignment (relocation or change of address) and Net(difference between Total and Reassignment). The same is listed forreversals. Finally, the list displays the live subscriptions on thelast day of the analysis period.
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.Orders where partial subscription weighting was determined incorrectlyare not included in the statistics.
Orders with postal codes that are not in a postal code evaluation areaare grouped and displayed under 'Others'.

Example
You want to list transactions affecting live subscriptions in May 1996for all subscription order types, all sales areas, for publications Ato C, for all editions and for the item types standard and free items.
The list 'Transactions by sales source' is to display the summarizationlevel publication and edition, the list 'Transactions by salespromotion and sales source' is to display the summarization levelpublication without restricting the sales promotions to be displayed,and the list 'Transactions by postal code areas' is to display thesummarization level publication and edition with the postal code areaevaluation variant 'ZZ1'.
To have the report create this list, you make the following entries onthe selection screen:


• Data selection

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

• Output control

Generate list 'Transactions by sales source'
Publication x (selected)
Edition x (selected)
Generate list 'Transactions by sales promotions and sales source'
Publication x (selected)
Edition Not selected
Sales proms.for list No entries
Generate list 'Transactions by postal code areas'
Publication x (selected)
Edition x (selected)
PCode area eval.var. ZZ1