Fixing the single object Offer Performance Summary by Campaign report
To manually upgrade your reports version 7.5.1, you must manually upgrade and fix the single object Offer Performance Summary by Campaign report, so the report can function with the new data model.
Procedure
- Open the report in IBM® Cognos® Report Studio.
- Browse to the Query Explorer and open the Report Query for a list of all the query items in the report.
- Configure the aggregation as given in the following table
for the Campaign Level Counts query items:
Table 1. Aggregate functions for Campaign Level Counts query items This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
Query item Aggregate Function Rollup Aggregate Function Number of Offers Given None Automatic Response Transactions None Automatic Unique Recipients None Automatic Unique Responders None Automatic Not Contacted Responders None Automatic Responses after Expiration None Automatic Unique Recipients Control Group None Automatic Unique Responders Control Group None Automatic - Configure the aggregation as given in the following table
for Campaign Level Counts query items.
Table 2. Aggregate functions for Campaign Level Counts query items This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
Query item Aggregate Function Rollup Aggregate Function Response Rate Automatic Automatic Responder Rate Automatic Automatic Responder Rate Control Group Automatic Automatic Best Offer Lift Over This Automatic Automatic Lift Over Worst Offer Automatic Automatic Lift Over Control Group Automatic Automatic - Configure the aggregation as given in the following table
for Offer Level Counts query items.
Table 3. Aggregate functions for Offer Level Counts query items This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
Query item Aggregate Function Rollup Aggregate Function Number of Offers Given-Offer None Automatic Unique Responders-Offer None Automatic Not Contacted Responders-Offer None Automatic Responses after Expiration-Offer None Automatic Unique Responders Control Group-Offer None Automatic - Change the expression for the Response Transactions-Offer query
item to be the following.
[Offer Performance Summary].[Offer Response History Summary]. [Response Transactions] / count([Campaign Name] for [Offer ID])
- Configure the aggregation as given in the following table
for Offer Level Counts query items.
Table 4. Aggregate functions for Offer Level Counts query items This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
Query item Aggregate Function Rollup Aggregate Function Response Transactions - Offer Total Automatic Unique Recipients - Offer Total Automatic Unique Recipients Control Group - Offer Total Automatic - Configure the aggregation as given in the following table
for Offer Level Counts query items.
Table 5. Aggregate functions for Offer Level Counts query items This three-columned table provides the query items in one column, the aggregate functions in the second column, and the rollup aggregate functions in the third column.
Query item Aggregate Function Rollup Aggregate Function Response Rate - Offer Automatic Automatic Responder Rate - Offer Automatic Automatic Responder Rate Control Group - Offer Automatic Automatic Lift Over Control Group - Offer Automatic Automatic - Lock the report.
- Complete the following tasks in Report Studio for each
report.
- Go to File > Report Package.
- Select Unica Campaign Package and click OK.
- Complete prompts on the report as necessary.
- After the report is validated, click Close in the Validation Response window.
- Save and run the report.