How to fix the Offer Performance Summary by Campaign cross-object report
Use this procedure to fix the old version of the cross-object Offer Performance Summary by Campaign report so it functions with the new data model.
1.
Open the report in IBM® Cognos® Report Studio.
2.
Browse to the Query Explorer and open the Report Query for a list of all the query items in the report.
3.
Configure the aggregation as follows for the following Campaign Level Counts query items.
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
4.
Configure the aggregation as follows for the following Campaign Level Counts query items.
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
5.
Configure the aggregation as follows for the following Offer Level Counts query items.
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
6.
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])

7.
Configure the aggregation as follows for the following Offer Level Counts query items.
Query item
Aggregate Function
Rollup Aggregate Function
Response Transactions - Offer
Total
Automatic
Unique Recipients - Offer
Total
Automatic
Unique Recipients Control Group - Offer
Total
Automatic
8.
Configure the aggregation as follows for the following Offer Level Counts query items.
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
9.
For the Report Total level counts, change the expression for Total Response Transactions to be the following.
total ([Response Transactions-Offer])
10.
Also for Total Response Transactions, confirm that Aggregate Function is set to Automatic and that Rollup Aggregate Function is set to Automatic.
11.
Lock the report.
12.
Do the following in Report Studio for each report.
a.
Go to File > Report Package.
b.
Select Unica Campaign Package and click OK.
c.
Fill in prompts on the report as necessary.
d.
After the report is validated, click Close in the Validation Response window.
13.
Save and run the report.
Copyright IBM Corporation 2012. All Rights Reserved.