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
- Navigate to the Reports tab in Oracle CRM On Demand.
- Click the Design Analyses link.
- Under the Analytics subject area select Campaign Response History.
- Select a campaign variable to run the report against, such as Campaign Name or Source Code.
- Add a Filter based on Campaign Status, where the field value is equal to Completed.
- Include the following Response Metrics:
- number (#) of Recipients
- number (#) of Hard Bounces
- number (#) of Soft Bounces
- number (#) of Open Responses
NOTE: The number (#) of Open Responses metric only reflects opened messages that included the $(trackMsgOpen) tag. For more information, see Adding Response Links.
You can create an additional view to calculate the total number of messages delivered (number of Recipients minus [number of Hard Bounces plus number of Soft Bounces]) and opened, and the estimated open rate of the specified campaign (a percentage of the total messages sent, number of Open Responses divided by the number 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.
|