Campaign Performance Report (PCPR)

How to print: Complete the Campaign Performance Report Screen.

For more information: See the sample report in PDF format.

Contents:

Selection criteria:

• Date range: The Start date and End date you entered at the Campaign Performance Report Screen.

• Source Category: The Source category you entered at the Campaign Performance Report Screen. If you did not select a category, the report indicates a selection of ALL.

• Drop code: The Drop code you entered at the Campaign Performance Report Screen. If you did not select a drop code, the report indicates a selection of ALL.

• Report: The selection in the Ordered/Shipped field at the Campaign Performance Report Screen.

For each source code included on the report: The following are broken out by source category. The report lists source codes that are not assigned to a category first:

• Source: Source code

• Description: Source code description

• Gross Input: The Proj names (Projected names) specified for the source code

• Net Output: The Gross circ (Gross circulation) specified for the source code

• Net Quantity Mailed (Net quantity mailed): The Net circ (Net circulation) specified for the source code

• Net % Mailed: The source code’s Net circ (Net circulation) divided by the Gross circ (Gross circulation)

• List Cost: The List cost specified for the source code

• Total Orders: The total number of orders placed during the selected date range for this source code. Note:

- Includes orders of any status except Suspended and Error.

- Canceled or completely sold out orders are not subtracted from this total.

- A multi-recipient order is counted once, not separately for each shipping address.

- Returns created by entering a new order with a negative item quantity increase this total.

• Unique Orders: The total number of orders placed by different customers during the selected date range for this source code. Calculated the same way as the Total Orders, except that if the same customer places more than one order during the date range, only the first order for the customer is counted. Incremented only if it is a unique customer placing the order (customer sold to) rather than a unique customer receiving the order.

• Multiple Factor: The Total Orders divided by the Unique Orders.

• Order Response Rate: The Total Orders divided by the Net Quantity Mailed.

• Net Merchandise Plus Charges (Net merchandise plus freight, additional freight, handling, tax, and additional charges): The calculation of this field varies depending on your selection in the Ordered/Shipped field at theCampaign Performance Report Screen:

- Ordered Dollars: The total amount charged for merchandise, freight, taxes, handling, additional charges, and additional freight for orders created during the selected date range for this source code. The total includes the extended price (plus any related tax, freight, and other charges) of all items ordered, and is reduced by returns creating by entering a negative quantity and cancellations flagged to reduce demand; however, this total is not reduced when you sell out an order detail line, use a cancel reason that is not flagged to reduce demand, or process a return in order maintenance or through the return authorizations module. Also, the total includes the value of any exchange items or items added in order maintenance, regardless of the setting of the Update Demand for Order Maintenance Transactions (C72) system control value.

- Shipped Dollars: The total amount billed to date for merchandise, freight, taxes, handling, additional charges, and additional freight for orders created during the selected date range for this source code. This total is net of all returns against these orders, regardless of how you processed the returns.

Note: The total Net Merchandise Plus Charges is negative if you use a special source code for returns you process by entering a new order for a negative quantity.

• Average Order: The Net Merchandise Plus Charges divided by Total Orders. The report lists an average order of 0.00 if the average order value was less thank zero (for example, if you use a special source code for returns you process by entering a new order for a negative quantity).

• Amount Per Book: The Net Merchandise Plus Charges divided by the Net Quantity Mailed. The report lists an Amount Per Book of 0.00 if the actual result was less than zero (for example, if you use a special source code for returns you process by entering a new order for a negative quantity).

• Unique Response Rate (Unique response rate): The Unique Orders divided by the Net Quantity Mailed times 100, or (Unique Orders / Net Qty Mailed) + 100. Presented as a percentage. The report lists a Unique Response Rate of 0.0% if the actual result was less than zero (for example, if you use a special source code for returns you process by entering a new order for a negative quantity).

• Unique Average Order: The Net Merchandise Plus Charges divided by Unique Orders. The report lists a Unique Average Order of 0.00 if the actual result was less than zero (for example, if you use a special source code for returns you process by entering a new order for a negative quantity).

• Catalog Request Total: The total number of catalog requests printed for the source code during the selected date range. Derived from the Catalog Request History file; see Catalog Request History Options for a discussion.

• Cat Request Response: The Catalog Request Total divided by the Net Quantity Mailed times 100, or (Catalog Request Total / Net Quantity Mailed) * 100. Presented as a percentage.

• Combined Request Plus Orders (Catalog request plus orders): The Catalog Request Total plus the Total Orders.

• Combined Response Rate: The Catalog Request Total divided by the Net Quantity Mailed times 100, or (Catalog Request Total/Net Quantity Mailed) * 100. Presented as a percentage.

Totals for Source Category: Each of the above totals, calculated for all source codes within a source category, or a source category of blank for source codes not assigned to a category.

Final Totals: Each of the above totals, calculated for all source codes included in the report.