Open PDF Version of Online Help

Measuring Campaign Effectiveness >

Generating Delivery Statistics

The Campaign and Response Metrics information can be used to generate a report to show delivery statistics.

To generate a delivery report

  1. Navigate to the Reports tab in Oracle CRM On Demand.
  2. Click the Design Analyses link.
  3. Under the Analytics subject areas select Campaign Response History.
  4. Select a campaign variable to run the report against, such as Campaign Name or Source Code.
  5. Add a Filter based on Campaign Status, where the field value is equal to Completed.
  6. Include the following Response Metrics:
    • # of Recipients
    • # of Hard Bounces
    • # of Soft Bounces
    • # of Open Responses

NOTE:  The # of Open Responses metric only reflects opened messages that included the $(trackMsgOpen) tag. For more information, see Adding Response Links.

From here you can create an additional view to calculate the total number of messages delivered (# of Recipients - [# of Hard Bounces+# of Soft Bounces]) and opened, and the estimated open rate of the specified campaign (a percentage of the total messages sent, # of Open Responses/# of messages delivered).

You can present this information in the form of a numerical value, a percentage, and in the form of a bar graph using the layout capabilities of Oracle CRM On Demand Answers.

Other Delivery reports that you might want to create are:

  • Bounce Detail Analysis. Show the number of messages that failed for each bounce type, as well as a summary of the total number of failed messages.
  • Soft Bounce Detail Analysis. Show the number of messages that were classified as soft bounces and the bounce types.
  • Hard Bounce Detail Analysis. Show the number of messages that were classified as hard bounces and the bounce types.

Published: August 19, 2009