Fixing the Offer Performance Summary by Campaign cross-object report
To manually upgrade your reports version 7.5.1, you must manually upgrade and fix the Offer Performance Summary by Campaign cross-object 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 follows for the following
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 follows for the following
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 follows for the following
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 follows for the following
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 follows for the following
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 - For the Report Total level counts, change the expression
for Total Response Transactions to be the following.
total ([Response Transactions-Offer])
- Also, for Total Response Transactions, confirm that Aggregate Function is set to Automatic and that Rollup Aggregate Function is set to Automatic.
- Lock the report.
- Complete the following steps 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.