Unica Campaign Reports Specifications
Folder: Affinium Campaign

"What If" Offer Financial Summary
The "What If" Offer Financial Summary calculates hypothetical financial performance of an offer based on your input. You specify the number of offers given, a response rate, response rate increment and gross margin. The report calculates financial performance for six scenarios, incrementing upward based on your specified response rate and response rate increment. For example, if you specify a response rate of 2% and a response rate increment of 0.25%, the report will return performance data for six scenarios with response rates ranging from 2% to 3.25%. You can recalculate the report using optional parameters including cost per contact, offer fulfillment fixed cost, revenue per response, and revenue margin per response.
Campaign Detailed Offer Response Breakout
The Campaign Detailed Offer Response Breakout report provides campaign performance data for different response types. It lists all offers associated with a campaign and the number of responses for each response type.
Campaign Financial Summary by Offer (Actual)
The Campaign Financial Summary by Offer (Actual) report provides financial data for offers within campaigns. It includes data such as contact costs, gross revenue, net profit, and ROI.
Campaign Offer Performance by Month
The Campaign Offer Performance by Month report shows campaign performance for a specified month with performance data grouped by the corresponding offers. It lists the number of offers given, number of response transactions and response rate for the specified month.
Campaign Performance Comparison
The Campaign Performance Comparison report compares the financial performance of campaigns. It includes data such as response transactions and response rate, number of unique responders and responder rate. It also includes optional lift over control group information.
Campaign Performance Comparison (with Revenue)
The Campaign Performance Comparison report compares the financial performance of campaigns. It includes data such as response transactions and response rate, number of unique responders and responder rate. It also includes optional lift over control group information.
Campaign Performance Comparison by Initiative
The Campaign Performance Comparison by Initiative report compares the financial performance of campaigns grouped by the corresponding initiatives. It includes data such as response transactions and response rate, number of unique responders and responder rate. It also includes optional lift over control group information.
Campaign Performance Summary by Cell
The Campaign Performance Summary by Cell report provides performance data for campaigns with cells grouped by the corresponding campaigns. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information.
Campaign Performance Summary by Cell (with Revenue)
The Campaign Performance Summary by Cell (with Revenue) report provides performance data for campaigns with cells grouped by the corresponding campaigns. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders, responder rate and actual revenue. It also includes optional lift over control group information.
Campaign Performance Summary by Cell and Initiative
The Campaign Performance Summary by Cell and Initiative report provides performance data for campaigns with cells grouped by the corresponding campaigns and initiatives. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information.
Campaign Performance Summary by Offer
The Campaign Performance Summary by Offer report provides a summary of campaign and offer performance with offers grouped by the corresponding campaigns. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information.
Campaign Performance Summary by Offer (with Revenue)
The Campaign Performance Summary by Offer (with Revenue) report provides a summary of campaign and offer performance with offers grouped by the corresponding campaigns. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders, responder rate and actual revenue. It also includes optional lift over control group information.
Campaign Summary
The Campaign Summary report provides an overview of all campaigns that have been created. It lists the campaign code, creation date, start and end dates, last run date, initiative and objective of each campaign.
Offer Campaign Listings
The Offer Campaign Listings report lists campaigns grouped by offers. It lists the campaign code, initiative, start and end dates and last run date.
Offer Performance by Day
The Offer Performance by Day report shows offer performance for a specified date or date range. It lists the number of offers given, number of response transactions and the response rate during the specified date or date range.
Offer Performance Comparison
The Offer Performance Comparison report compares the performance of offers. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information.
Offer Performance Metrics
Offer Performance Metrics report compares the performance of offers based on various response attributions, such as Best Match, Fractional Match and Multiple Match. It also includes optional lift over control group information and percentage difference between various attribution rates.
Offer Performance Summary by Campaign
The Offer Performance Summary by Campaign report provides a summary of offer and campaign performance with campaigns grouped by the corresponding offers. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information.


"What If" Offer Financial Summary
Description:The "What If" Offer Financial Summary calculates hypothetical financial performance of an offer based on your input. You specify the number of offers given, a response rate, response rate increment and gross margin. The report calculates financial performance for six scenarios, incrementing upward based on your specified response rate and response rate increment. For example, if you specify a response rate of 2% and a response rate increment of 0.25%, the report will return performance data for six scenarios with response rates ranging from 2% to 3.25%. You can recalculate the report using optional parameters including cost per contact, offer fulfillment fixed cost, revenue per response, and revenue margin per response. 
# Queries:1
Layout:6 crosstabs(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/What If Offer Financial Summary.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Base Query
(crosstab)
Total: 15Filters:
[Offer Performance Summary].[Offer].[Offer ID] = ?OfferId?
 
 
Offer Name[Offer Performance Summary].[Offer].[Offer Name] 
Number of Offers Given?Num_Offers_Given?total 
Response Transactions[Number of Offers Given]*[Response Rate]total 
Response Rate?Response_Rate?/100 
Cost Per ContactCASE ?Cost_per_Contact? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Cost Per Contact], float) ELSE (cast(cast(?Cost_per_Contact?, int), float)) END 
Offer Fixed CostCASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) ENDtotal 
Revenue Per ResponseCASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) ENDtotal 
Gross Revenue[Response Transactions]*[Revenue Per Response]total 
Contact Cost([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] 
Cost Per ResponderIF ([Contact Cost]/[Response Transactions] is missing) THEN (0) ELSE ([Contact Cost]/[Response Transactions])total 
Net Revenue[Gross Revenue]-[Contact Cost]total 
Gross Margin Percentage?Gross_Margin?/100 
Net Profit[Net Revenue]*[Gross Margin Percentage] 
Net Profit Per ResponseIF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions])total 
Return On InvestmentIF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost])total 
Base Query Plus Increment1
(crosstab)
Total: 15Filters:
[Offer Performance Summary].[Offer].[Offer ID] = ?OfferId?
 
 
Offer Name[Offer Performance Summary].[Offer].[Offer Name] 
Number of Offers Given?Num_Offers_Given?total 
Response Transactions[Number of Offers Given]*[Response Rate]total 
Response Rate(?Response_Rate? + (?Response_Rate_Increment? *1))/100 
Cost Per ContactCASE ?Cost_per_Contact? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Cost Per Contact], float) ELSE (cast(cast(?Cost_per_Contact?, int), float)) END 
Offer Fixed CostCASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) ENDtotal 
Revenue Per ResponseCASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) ENDtotal 
Gross Revenue[Response Transactions]*[Revenue Per Response]total 
Contact Cost([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] 
Cost Per ResponderIF ([Contact Cost]/[Response Transactions] is missing) THEN (0) ELSE ([Contact Cost]/[Response Transactions])total 
Net Revenue[Gross Revenue]-[Contact Cost]total 
Gross Margin Percentage?Gross_Margin?/100 
Net Profit[Net Revenue]*[Gross Margin Percentage] 
Net Profit Per ResponseIF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions])total 
Return On InvestmentIF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost])total 
Base Query Plus Increment2
(crosstab)
Total: 15Filters:
[Offer Performance Summary].[Offer].[Offer ID] = ?OfferId?
 
 
Offer Name[Offer Performance Summary].[Offer].[Offer Name] 
Number of Offers Given?Num_Offers_Given?total 
Response Transactions[Number of Offers Given]*[Response Rate]total 
Response Rate(?Response_Rate? + (?Response_Rate_Increment? *2))/100 
Cost Per ContactCASE ?Cost_per_Contact? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Cost Per Contact], float) ELSE (cast(cast(?Cost_per_Contact?, int), float)) END 
Offer Fixed CostCASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) ENDtotal 
Revenue Per ResponseCASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) ENDtotal 
Gross Revenue[Response Transactions]*[Revenue Per Response]total 
Contact Cost([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] 
Cost Per ResponderIF ([Contact Cost]/[Response Transactions] is missing) THEN (0) ELSE ([Contact Cost]/[Response Transactions])total 
Net Revenue[Gross Revenue]-[Contact Cost]total 
Gross Margin Percentage?Gross_Margin?/100 
Net Profit[Net Revenue]*[Gross Margin Percentage] 
Net Profit Per ResponseIF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions])total 
Return On InvestmentIF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost])total 
Base Query Plus Increment3
(crosstab)
Total: 15Filters:
[Offer Performance Summary].[Offer].[Offer ID] = ?OfferId?
 
 
Offer Name[Offer Performance Summary].[Offer].[Offer Name] 
Number of Offers Given?Num_Offers_Given?total 
Response Transactions[Number of Offers Given]*[Response Rate]total 
Response Rate(?Response_Rate? + (?Response_Rate_Increment? *3))/100 
Cost Per ContactCASE ?Cost_per_Contact? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Cost Per Contact], float) ELSE (cast(cast(?Cost_per_Contact?, int), float)) END 
Offer Fixed CostCASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) ENDtotal 
Revenue Per ResponseCASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) ENDtotal 
Gross Revenue[Response Transactions]*[Revenue Per Response]total 
Contact Cost([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] 
Cost Per ResponderIF ([Contact Cost]/[Response Transactions] is missing) THEN (0) ELSE ([Contact Cost]/[Response Transactions])total 
Net Revenue[Gross Revenue]-[Contact Cost]total 
Net Profit[Net Revenue]*[Gross Margin Percentage] 
Gross Margin Percentage?Gross_Margin?/100 
Net Profit Per ResponseIF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions])total 
Return On InvestmentIF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost])total 
Base Query Plus Increment4
(crosstab)
Total: 15Filters:
[Offer Performance Summary].[Offer].[Offer ID] = ?OfferId?
 
 
Offer Name[Offer Performance Summary].[Offer].[Offer Name] 
Number of Offers Given?Num_Offers_Given?total 
Response Transactions[Number of Offers Given]*[Response Rate]total 
Response Rate(?Response_Rate? + (?Response_Rate_Increment? *4))/100 
Cost Per ContactCASE ?Cost_per_Contact? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Cost Per Contact], float) ELSE (cast(cast(?Cost_per_Contact?, int), float)) END 
Offer Fixed CostCASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) ENDtotal 
Revenue Per ResponseCASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) ENDtotal 
Gross Revenue[Response Transactions]*[Revenue Per Response]total 
Contact Cost([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] 
Cost Per ResponderIF ([Contact Cost]/[Response Transactions] is missing) THEN (0) ELSE ([Contact Cost]/[Response Transactions])total 
Net Revenue[Gross Revenue]-[Contact Cost]total 
Gross Margin Percentage?Gross_Margin?/100 
Net Profit[Net Revenue]*[Gross Margin Percentage] 
Net Profit Per ResponseIF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions])total 
Return On InvestmentIF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost])total 
Base Query Plus Increment5
(crosstab)
Total: 15Filters:
[Offer Performance Summary].[Offer].[Offer ID] = ?OfferId?
 
 
Offer Name[Offer Performance Summary].[Offer].[Offer Name] 
Number of Offers Given?Num_Offers_Given?total 
Response Transactions[Number of Offers Given]*[Response Rate]total 
Response Rate(?Response_Rate? + (?Response_Rate_Increment? *5))/100 
Cost Per ContactCASE ?Cost_per_Contact? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Cost Per Contact], float) ELSE (cast(cast(?Cost_per_Contact?, int), float)) END 
Offer Fixed CostCASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) ENDtotal 
Revenue Per ResponseCASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) ENDtotal 
Gross Revenue[Response Transactions]*[Revenue Per Response]total 
Contact Cost([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] 
Cost Per ResponderIF ([Contact Cost]/[Response Transactions] is missing) THEN (0) ELSE ([Contact Cost]/[Response Transactions])total 
Net Revenue[Gross Revenue]-[Contact Cost]total 
Gross Margin Percentage?Gross_Margin?/100 
Net Profit[Net Revenue]*[Gross Margin Percentage] 
Net Profit Per ResponseIF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions])total 
Return On InvestmentIF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost])total 
Offer Name Query
Total: 2Filters:
[Offer Performance Summary].[Offer].[Offer ID] = ?OfferId?
 
 
Offer ID[Offer Performance Summary].[Offer].[Offer ID] 
Offer Name[Offer Performance Summary].[Offer].[Offer Name] 


Campaign Detailed Offer Response Breakout
Description:The Campaign Detailed Offer Response Breakout report provides campaign performance data for different response types. It lists all offers associated with a campaign and the number of responses for each response type. 
# Queries:1
Layout:1 list(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Campaign Detailed Offer Response Breakout.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 47Filters:
[Campaign Offer Detailed Response Breakout].[CampToOffer].[Campaign ID] in (?CampaignIds?)
 
 
Campaign ID[Campaign Offer Detailed Response Breakout].[Campaign].[Campaign ID] 
Campaign Name[Campaign Offer Detailed Response Breakout].[Campaign].[Campaign Name]||' ('||[Campaign Offer Detailed Response Breakout].[Campaign].[Campaign Code]||')' 
Offer Name[Campaign Offer Detailed Response Breakout].[Offer].[Offer Name]||' ('||[Campaign Offer Detailed Response Breakout].[Offer].[Offer Code1]||')' 
Number of Offers Given[Campaign Offer Detailed Response Breakout].[Campaign Offer Contact History Summary].[Number of Offers Given]total 
Unique Recipients[Campaign Offer Detailed Response Breakout].[Campaign Offer Contact History Summary].[Unique Recipients]total 
Response Transactions[Campaign Offer Detailed Response Breakout].[Campaign Offer Response History Summary].[Response Transactions]total 
Unique Responders[Campaign Offer Detailed Response Breakout].[Campaign Offer Response History Summary].[Unique Responders]total 
Explore Count[Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Explore Count]total 
Consider Count[Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Consider Count]total 
Commit Count[Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Commit Count]total 
Fulfill Count[Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Fulfill Count]total 
Usage Count[Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Usage Count]total 
Number of Offers Given-Campaign[Campaign Offer Detailed Response Breakout].[Campaign Contact History Summary].[Number of Offers Given] 
Response Transactions-Campaign[Campaign Offer Detailed Response Breakout].[Campaign Response History Summary].[Response Transactions] 
Not Applilcable Calc[Campaign Listing].[Campaign].[Not Applilcable Calc] 
Explore Count-Campaign[Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Explore Count] 
Consider Count- Campaign[Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Consider Count] 
Commit Count-Campaign[Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Commit Count] 
Fulfill Count-Campaign[Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Fulfill Count] 
Usage Count-Campaign[Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Usage Count] 
Unique Recipients-Campaign[Campaign Offer Detailed Response Breakout].[Campaign Contact History Summary].[Unique Recipients] 
Unique Responders-Campaign[Campaign Offer Detailed Response Breakout].[Campaign Response History Summary].[Unique Responders] 
Total(Number of Offers Given)[Number of Offers Given]calculated/ total 
Total(Response Transactions)[Response Transactions]calculated/ total 
Total(Commit Count)[Commit Count]calculated/ total 
Total(Consider Count)[Consider Count]calculated/ total 
Total(Explore Count)[Explore Count]calculated/ total 
Total(Fulfill Count)[Fulfill Count]calculated/ total 
Total(Usage Count)[Usage Count]calculated/ total 
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given]* 1.00))) 
Response Rate-CampaignIF(([Response Transactions-Campaign]/([Number of Offers Given-Campaign] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions-Campaign]/([Number of Offers Given-Campaign]* 1.00))) 
Commit Response Rate-CampaignIF(([Commit Count-Campaign]/([Number of Offers Given-Campaign] * 1.00)) is missing) THEN(0) ELSE(([Commit Count-Campaign]/([Number of Offers Given-Campaign]* 1.00))) 
Consider Response Rate-CampaignIF(([Consider Count- Campaign]/([Number of Offers Given-Campaign] * 1.00)) is missing) THEN(0) ELSE(([Consider Count- Campaign]/([Number of Offers Given-Campaign]* 1.00))) 
Explore Response Rate-CampaignIF(([Explore Count-Campaign]/([Number of Offers Given-Campaign] * 1.00)) is missing) THEN(0) ELSE(([Explore Count-Campaign]/([Number of Offers Given-Campaign]* 1.00))) 
Fulfill Response Rate-CampaignIF(([Fulfill Count-Campaign]/([Number of Offers Given-Campaign] * 1.00)) is missing) THEN(0) ELSE(([Fulfill Count-Campaign]/([Number of Offers Given-Campaign]* 1.00))) 
Usage Response Rate-CampaignIF(([Usage Count-Campaign]/([Number of Offers Given-Campaign] * 1.00)) is missing) THEN(0) ELSE(([Usage Count-Campaign]/([Number of Offers Given-Campaign]* 1.00))) 
Total Response Rate[Total(Response Transactions)]/([Total(Number of Offers Given)]*1.00) 
Total Commit Response Rate[Total(Commit Count)]/([Total(Number of Offers Given)]*1.00) 
Total Consider Response Rate[Total(Consider Count)]/([Total(Number of Offers Given)]*1.00) 
Total Explore Response Rate[Total(Explore Count)]/([Total(Number of Offers Given)]*1.00) 
Total Fulfill Response Rate[Total(Fulfill Count)]/([Total(Number of Offers Given)]*1.00) 
Total Usage Response Rate[Total(Usage Count)]/([Total(Number of Offers Given)]*1.00) 
Commit Response RateIF(([Commit Count]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Commit Count]/([Number of Offers Given]* 1.00))) 
Consider Response RateIF(([Consider Count]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Consider Count]/([Number of Offers Given]* 1.00))) 
Explore Response RateIF(([Explore Count]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Explore Count]/([Number of Offers Given]* 1.00))) 
Fulfill Response RateIF(([Fulfill Count]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Fulfill Count]/([Number of Offers Given]* 1.00))) 
Usage Response RateIF(([Usage Count]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Usage Count]/([Number of Offers Given]* 1.00))) 
Campaign Select Prompt
(prompt)
Total: 2  
Campaign ID[Campaign Offer Detailed Response Breakout].[Campaign].[Campaign ID] 
Campaign Name[Campaign Offer Detailed Response Breakout].[Campaign].[Campaign Name]||' ('||[Campaign Offer Detailed Response Breakout].[Campaign].[Campaign Code]||')' 


Campaign Financial Summary by Offer (Actual)
Description:The Campaign Financial Summary by Offer (Actual) report provides financial data for offers within campaigns. It includes data such as contact costs, gross revenue, net profit, and ROI. 
# Queries:1
Layout:1 list(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Campaign Financial Summary by Offer (Actual).jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 50Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] in (?CampaignIds?)
 
 
Campaign Name[Campaign Custom Attributes].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Offer Name[Campaign Custom Attributes].[Offer].[Offer Name]||' ('||[Campaign Custom Attributes].[Offer].[Offer Code1]||')' 
Number of Offers Given[Campaign Performance Summary].[Campaign Offer Contact History Summary].[Number of Offers Given]total 
Response Transactions[Campaign Performance Summary].[Campaign Offer Response History Summary].[Response Transactions]total 
Response Transactions-Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions]total 
Response RateIF([Response Transactions]/([Number of Offers Given] *1.00) is missing) THEN(0) ELSE([Response Transactions]/([Number of Offers Given] * 1.00)) 
Response Rate-CampaignIF([Response Transactions-Campaign]/([Number of Offers Given - Campaign] * 1.00) is missing) THEN(0) ELSE([Response Transactions-Campaign]/([Number of Offers Given - Campaign] * 1.00)) 
Offer Fixed Cost[Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost]total 
Total(Offer Fixed Cost)[Offer Fixed Cost]calculated/ total 
Cost Per Contact[Campaign Custom Attributes].[Offer Custom Attributes].[Cost Per Contact]total/ average 
Revenue Per Response[Campaign Performance Summary].[Campaign Offer Response History Summary].[Revenue Per Response]total 
Revenue Per Response- Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Revenue Per Response]total 
Contact CostIF ([Cost Per Contact] is missing) THEN ([Offer Fixed Cost]) ELSE(([Cost Per Contact]*[Number of Offers Given]) + [Offer Fixed Cost])total 
Contact Cost - Campaigntotal([Contact Cost] for [Campaign Name]) 
Gross Revenue[Campaign Performance Summary].[Campaign Offer Response History Summary].[Gross Revenue]total 
Gross Revenue - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Gross Revenue]total 
Number of Offers Given - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given] 
Net RevenueIF([Gross Revenue] is missing) THEN(0-[Contact Cost]) ELSE([Gross Revenue]-[Contact Cost]) 
Net Revenue-CampaignIF([Gross Revenue - Campaign] is missing) THEN(0-[Contact Cost - Campaign]) ELSE([Gross Revenue - Campaign]-[Contact Cost - Campaign]) 
Net ProfitIF([Response Transactions] is missing) THEN([Net Revenue]) ELSE([Net Revenue]-([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fulfillment Cost] * [Response Transactions])) 
Net Profit-Campaignif ([Response Transactions] is missing) then ([Net Revenue-Campaign]) else ([Net Revenue-Campaign]-(total(([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fulfillment Cost] * [Response Transactions])))) 
Revenue Margin per ResponseIF([Net Profit]/[Response Transactions] is missing) THEN(0) ELSE([Net Profit]/[Response Transactions]) 
Revenue Margin Per Response - CampaignIF([Net Profit-Campaign]/[Response Transactions-Campaign] is missing) THEN(0) ELSE([Net Profit-Campaign]/[Response Transactions-Campaign]) 
Return on InvestmentIF([Net Profit]/[Contact Cost] is missing) THEN(0) ELSE([Net Profit]/[Contact Cost]) 
Return On Investment-CampaignIF([Net Profit-Campaign]/[Contact Cost - Campaign] is missing) THEN(0) ELSE([Net Profit-Campaign]/[Contact Cost - Campaign]) 
Gross Revenue Control GroupIF([Campaign Performance Summary].[Campaign Offer Response History Summary].[Gross Revenue Control Group] is missing) THEN (0) ELSE ([Campaign Performance Summary].[Campaign Offer Response History Summary].[Gross Revenue Control Group])total 
Number of Offers Given Control Group[Campaign Performance Summary].[Campaign Offer Contact History Summary].[Number of Offers Given Control Group]total 
Number of Offers Given Control Group-Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given Control Group]total 
Contact Cost Control Group([Cost Per Contact]*[Number of Offers Given Control Group]) + [Offer Fixed Cost] 
Net Revenue Control Group[Gross Revenue Control Group]-[Contact Cost Control Group] 
Response Transactions Control Group[Campaign Performance Summary].[Campaign Offer Response History Summary].[Response Transactions Control Group]total 
Baseline Net Profit (Control)IF([Response Transactions] is missing) THEN(0) ELSE([Net Revenue Control Group]-([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fulfillment Cost] * [Response Transactions Control Group])) 
Gross Revenue Control Group - CampaignIF([Campaign Performance Summary].[Campaign Response History Summary].[Gross Revenue Control Group] is missing) THEN (0) ELSE ([Campaign Performance Summary].[Campaign Response History Summary].[Gross Revenue Control Group])total 
Contact Cost Control Group - Campaigntotal([Contact Cost Control Group] for [Campaign Name]) 
Net Revenue Control Group-Campaign[Gross Revenue Control Group - Campaign]-[Contact Cost Control Group - Campaign] 
Baseline Net Profit (Control) - CampaignIF([Response Transactions-Campaign] is missing) THEN(0) ELSE([Net Revenue Control Group-Campaign]-(total(([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fulfillment Cost]*[Response Transactions Control Group] ) for [Campaign Name]))) 
Incremental ROIIF ([Number of Offers Given Control Group]=0) THEN ([Net Profit]/[Contact Cost]) ELSE(([Net Profit]-([Baseline Net Profit (Control)] * ([Number of Offers Given]/[Number of Offers Given Control Group])))/[Contact Cost]) 
Incremental ROI - CampaignIF ([Number of Offers Given Control Group-Campaign]=0) THEN([Net Profit-Campaign]/[Contact Cost - Campaign]) ELSE (([Net Profit-Campaign]-([Baseline Net Profit (Control) - Campaign] *([Number of Offers Given]/[Number of Offers Given Control Group-Campaign])))/[Contact Cost - Campaign]) 
Total Offers Giventotal([Number of Offers Given - Campaign] for report) 
Total Response TransactionsIF([Response Transactions-Campaign] is missing) THEN(0) ELSE(total([Response Transactions-Campaign] for report)) 
Total Response Rate[Total Response Transactions]/([Total Offers Given] * 1.000) 
Total Revenue Per Responsetotal([Revenue Per Response- Campaign] for report) 
Total Gross Revenuetotal([Gross Revenue - Campaign] for report) 
Total Net RevenueIF([Total Gross Revenue] is missing) THEN(0-[Total Contact Cost]) ELSE([Total Gross Revenue]-[Total Contact Cost]) 
Total Net ProfitIF(total( [Net Profit] for report) is missing) THEN(0) ELSE(total( [Net Profit] for report)) 
Total Contact Costtotal([Contact Cost] for report) 
Total Return On InvestmentIF([Total Net Profit]/[Total Contact Cost] is missing) THEN(0) ELSE([Total Net Profit]/[Total Contact Cost]) 
Total Revenue Margin Per Responsemaximum([Total Net Profit]/([Total Response Transactions] *1.00)) 
Total Baseline Net Profit (Control)total([Baseline Net Profit (Control)] for report) 
Total Incremental ROIIF(total([Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given Control Group] for report) = 0 ) THEN ([Total Net Profit]/[Total Contact Cost]) ELSE(([Total Net Profit]-([Total Baseline Net Profit (Control)] * ([Total Offers Given]/total([Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given Control Group] for report))))/[Total Contact Cost])  
Campaign Select Prompt
(prompt)
Total: 2  
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Graph Query
Total: 13Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] in (?CampaignIds?)
 
 
Campaign Name[Campaign Custom Attributes].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Number of Offers Given[Campaign Performance Summary].[Campaign Offer Contact History Summary].[Number of Offers Given]total 
Response TransactionsIF ([Campaign Performance Summary].[Campaign Offer Response History Summary].[Response Transactions] is missing) THEN (0) ELSE ([Campaign Performance Summary].[Campaign Offer Response History Summary].[Response Transactions])total 
Response Transactions-CampaignIF ([Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions] is missing) THEN (0) ELSE ([Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions])total 
Offer Fixed Cost[Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost]total 
Cost Per Contact[Campaign Custom Attributes].[Offer Custom Attributes].[Cost Per Contact]total/ average 
Contact Cost([Cost Per Contact]*[Number of Offers Given]) + [Offer Fixed Cost]total 
Contact Cost - Campaigntotal([Contact Cost] for [Campaign Name]) 
Gross Revenue - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Gross Revenue]total 
Number of Offers Given - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given] 
Net Revenue-CampaignIF([Gross Revenue - Campaign] is missing) THEN(0-[Contact Cost - Campaign]) ELSE([Gross Revenue - Campaign]-[Contact Cost - Campaign]) 
Net Profit-Campaignif ([Response Transactions] is missing) then ([Net Revenue-Campaign]) else ([Net Revenue-Campaign]-(total(([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fulfillment Cost] * [Response Transactions])))) 
Return On Investment-CampaignIF([Contact Cost - Campaign]=0 or [Contact Cost - Campaign] is missing) THEN(0) ELSE([Net Profit-Campaign]/[Contact Cost - Campaign]) 


Campaign Offer Performance by Month
Description:The Campaign Offer Performance by Month report shows campaign performance for a specified month with performance data grouped by the corresponding offers. It lists the number of offers given, number of response transactions and response rate for the specified month. 
# Queries:1
Layout:1 crosstabs(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Campaign Offer Performance by Month.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(crosstab)
Total: 11Filters:
[Campaign ID] in (?CampaignIds?)
[Month]>=?BeginDate?
[Month]<=?EndDate?
 
 
Month_make_timestamp([Campaign Performance by Month].[Calendar Month].[Year],[Campaign Performance by Month].[Calendar Month].[Month],01) 
Number of Offers[Campaign Performance by Month].[Campaign Offer Contact History by Month].[Number of Offers]total 
Response Transactions[Campaign Performance by Month].[Campaign Offer Response History by Month].[Response Transactions]total 
Campaign Name[Campaign Performance by Month].[Campaign].[Campaign Name]||' ('||[Campaign Performance by Month].[Campaign].[Campaign Code]||')' 
Campaign ID[Campaign Performance by Month].[Campaign].[Campaign ID] 
Offer Name[Campaign Performance by Month].[Offer].[Offer Name]||' ('||[Campaign Performance by Month].[Offer].[Offer Code1]||')' 
Response RateIF([Response Transactions]/([Number of Offers] * 1.00) is missing) THEN(0) ELSE([Response Transactions]/([Number of Offers] * 1.00)) 
Total(Month)total(currentMeasure within detail [Month]) 
Total Offers Giventotal([Number of Offers] within set [Month]) 
Total Response Transactionstotal([Response Transactions] within set [Month]) 
Total Response RateIF ([Total Response Transactions]/([Total Offers Given] * 1.00) is missing) THEN (0) ELSE ([Total Response Transactions]/([Total Offers Given] * 1.00)) 
Begin Date
(prompt)
Total: 1  
Begin Date_make_timestamp([Campaign Performance by Month].[Campaign Offer Response History by Month].[Year],[Campaign Performance by Month].[Campaign Offer Response History by Month].[Month],01) 
End Date
(prompt)
Total: 1  
End Date_make_timestamp([Campaign Performance by Month].[Campaign Offer Response History by Month].[Year],[Campaign Performance by Month].[Campaign Offer Response History by Month].[Month],01) 


Campaign Performance Comparison
Description:The Campaign Performance Comparison report compares the financial performance of campaigns. It includes data such as response transactions and response rate, number of unique responders and responder rate. It also includes optional lift over control group information. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift (boolean): (IF ((ParamValue("Hide_Show_Lift") IS MISSING) OR (ParamValue("Hide_Show_Lift") IS NULL)) THEN '' ELSE ParamValue("Hide_Show_Lift")) = 'Hide'
Report Language1 (locale): ReportLocale()
zero_ResponderRate (string): CASE WHEN ([Report Query].[Responder Rate] is missing OR [Report Query].[Responder Rate] =0) THEN ('ZERO_BEST_LIFT') END
zero_MinResponderRate (string): CASE WHEN ([Report Query].[Min. Responder Rate] is missing OR [Report Query].[Min. Responder Rate] =0) THEN ('ZERO_WORST_LIFT') END
reports/Affinium Campaign/Campaign Performance Comparison.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 20Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] in (?CampaignIds?)
 
 
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||'(' ||[Campaign Performance Summary].[Campaign].[Campaign Code]||')'  
Number of Offers Given[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given]total 
Response Transactions[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions]total 
Unique Responders[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders]total 
Unique Recipientstotal([Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients]for [Campaign ID])total 
Not Contacted Responders[Campaign Performance Summary].[Campaign Response History Summary].[Not Contacted Responders]total 
Responses After Expiration[Campaign Performance Summary].[Campaign Response History Summary].[Responses After Expiration]total 
Not Applilcable Calc[Campaign Performance Summary].[Campaign].[Not Applilcable Calc] 
Responder RateIF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders]/([Unique Recipients] * 1.00)))  
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given]* 1.00)))  
Unique Recipients Control Grouptotal([Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients Control Group] for [Campaign ID]) total 
Unique Responders Control Group[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders Control Group]total 
Responder Rate Control GroupIF ([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00) is missing) THEN (0) ELSE ([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00))  
Lift Over Control GroupIF(([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN(0) ELSE(((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000)  
Response Rate Total for reporttotal([Response Transactions] for report)/(total([Number of Offers Given] for report) * 1.00) 
Max. Responder Ratemaximum([Responder Rate] for report) 
Best Offer Lift Over ThisIF (([Max. Responder Rate]-[Responder Rate])/[Responder Rate] is missing) THEN (0) ELSE (((([Max. Responder Rate]-[Responder Rate]) * 1.000)/[Responder Rate]) * 1.000)  
Min. Responder Rateminimum([Responder Rate] for report) 
Lift Over Worst OfferIF(([Responder Rate]-[Min. Responder Rate])/[Min. Responder Rate] is missing) THEN(0) ELSE(((([Responder Rate]-[Min. Responder Rate])*1.000)/[Min. Responder Rate])*1.000)  
Campaigns Select
(prompt)
Total: 2  
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||'(' ||[Campaign Performance Summary].[Campaign].[Campaign Code]||')'  


Campaign Performance Comparison (with Revenue)
Description:The Campaign Performance Comparison report compares the financial performance of campaigns. It includes data such as response transactions and response rate, number of unique responders and responder rate. It also includes optional lift over control group information. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift (boolean): (IF ((ParamValue("Hide_Show_Lift") IS MISSING) OR (ParamValue("Hide_Show_Lift") IS NULL)) THEN '' ELSE ParamValue("Hide_Show_Lift")) = 'Hide'
Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Campaign Performance Comparison (with Revenue).jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 17Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] in (?CampaignIds?)
 
 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||'(' ||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Number of Offers Given[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given]total 
Response Transactions[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions]total 
Unique Responders[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders]total 
Unique Recipients[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients]total 
Not Contacted Responders[Campaign Performance Summary].[Campaign Response History Summary].[Not Contacted Responders]total 
Responses After Expiration[Campaign Performance Summary].[Campaign Response History Summary].[Responses After Expiration]total 
Not Applilcable Calc[Campaign Performance Summary].[Campaign].[Not Applilcable Calc] 
Responder RateIF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders]/([Unique Recipients] * 1.00))) 
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given]* 1.00))) 
Unique Recipients Control Group[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients Control Group]total 
Unique Responders Control Group[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders Control Group]total 
Responder Rate Control GroupIF ([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00) is missing) THEN (0) ELSE ([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00)) 
Lift Over Control GroupIF(([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN(0) ELSE(((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000) 
Response Rate Total for reporttotal([Response Transactions] for report)/(total([Number of Offers Given] for report) * 1.00) 
Gross Revenue[Campaign Performance Summary].[Campaign Response History Summary].[Gross Revenue]total 
Total(Gross Revenue)[Gross Revenue]calculated/ total 
Campaigns Select
(prompt)
Total: 2  
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||'(' ||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 


Campaign Performance Comparison by Initiative
Description:The Campaign Performance Comparison by Initiative report compares the financial performance of campaigns grouped by the corresponding initiatives. It includes data such as response transactions and response rate, number of unique responders and responder rate. It also includes optional lift over control group information.  
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift_Columns (boolean): (IF ((ParamValue("Hide_Show_Lift_Prompt") IS MISSING) OR (ParamValue("Hide_Show_Lift_Prompt") IS NULL)) THEN '' ELSE ParamValue("Hide_Show_Lift_Prompt")) = 'Hide'
Intiative_is_blank (boolean): [Report Query].[Initiative] is missing
Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Campaign Performance Comparison by Initiative.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 30Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID]in(?CampaignIds?)
 
 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' '||'('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Initiative[Campaign Performance Summary].[Campaign].[Initiative] 
Number of Offers Given[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given]total/ total 
Response Transactions[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions]total/ total 
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given] * 1.00)))  
Unique Recipients[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients]total/ total 
Unique Responders[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders]total/ total 
Responder RateIF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN (0) ELSE(([Unique Responders]/([Unique Recipients]* 1.00))) calculated/ calculated 
Not Contacted Responders[Campaign Performance Summary].[Campaign Response History Summary].[Not Contacted Responders]total/ total 
Responses After Expiration[Campaign Performance Summary].[Campaign Response History Summary].[Responses After Expiration]total/ total 
Unique Recipients Control Group[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients Control Group]total/ total 
Unique Responders Control Group[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders Control Group]total/ total 
Responder Rate Control GroupIF ([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00) is missing) THEN (0) ELSE ([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00)) calculated/ calculated 
Lift Over Control GroupIF(([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN(0) ELSE(((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000) / calculated 
Total Number of Offerstotal([Number of Offers Given] for report)/ automatic 
Total Response Transactionstotal([Response Transactions] for report)/ automatic 
Total Response Rate[Total Response Transactions]/[Total Number of Offers]/ automatic 
Number of Offers Given-Initiativetotal ([Number of Offers Given] for [Initiative]) 
Response Transactions-Initiativetotal ([Response Transactions] for [Initiative]) 
Response Rate-InitiativeIF((total([Number of Offers Given] for [Initiative]) *1.00) is missing) THEN (0) ELSE (total ([Response Transactions] for [Initiative]) / (total ([Number of Offers Given] for [Initiative]) *1.00) )  
Unique Recipients-Initiativetotal ([Unique Recipients] for [Initiative]) 
Unique Responders-Initiativetotal ([Unique Responders] for [Initiative]) 
Not Contacted Responders-Initiativetotal ([Not Contacted Responders] for [Initiative]) 
Responses After Expiration-Initiativetotal ([Responses After Expiration] for [Initiative]) 
Responder Rate-InitiativeIF( (total ([Unique Recipients] for [Initiative]) *1.00) is missing) THEN (0) ELSE (total ([Unique Responders] for [Initiative]) / (total ([Unique Recipients] for [Initiative]) *1.00) )  
Unique Recipients Control Group-Initiativetotal ([Unique Recipients Control Group] for [Initiative]) 
Unique Responders Control Group-Initiativetotal ([Unique Responders Control Group] for [Initiative]) 
Responder Rate Control Group-InitiativeIF( (total ([Unique Recipients Control Group] for [Initiative]) *1.00) is missing) THEN (0) ELSE (total ([Unique Responders Control Group] for [Initiative]) / (total ([Unique Recipients Control Group] for [Initiative]) *1.00) )  
Lift Over Control Group-InitiativeIF(([Responder Rate-Initiative]-[Responder Rate Control Group-Initiative])/[Responder Rate Control Group-Initiative] is missing) THEN(0) ELSE(((([Responder Rate-Initiative]-[Responder Rate Control Group-Initiative])*1.000)/[Responder Rate Control Group-Initiative])*1.000)  
Not Applilcable Calc[Campaign Listing].[Campaign].[Not Applilcable Calc] 
Campaign_Prompt_Query
(prompt)
Total: 2  
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name (Code)[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')'  


Campaign Performance Summary by Cell
Description:The Campaign Performance Summary by Cell report provides performance data for campaigns with cells grouped by the corresponding campaigns. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift (boolean): (IF ((ParamValue("Hide_Show_Lift") IS MISSING) OR (ParamValue("Hide_Show_Lift") IS NULL)) THEN '' ELSE ParamValue("Hide_Show_Lift")) = 'Hide'
Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Campaign Performance Summary by Cell.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 27Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] in(?CampaignIds?)
 
 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')'  
Cell Name[Campaign Performance Summary].[Cell].[Cell Name]||' ('||[Campaign Performance Summary].[Cell].[Cell Code]||')' 
Number of Offers Given[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Number of Offers Given]total 
Response Transactions[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Response Transactions]total 
Unique Recipients[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Unique Recipients]total 
Unique Responders[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Unique Responders]total 
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given] * 1.00)))  
Responder RateIF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN (0) ELSE(([Unique Responders]/([Unique Recipients]* 1.00)))  
Unique Recipients Control Group[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Unique Recipients Control Group]total 
Unique Responders Control Group[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Unique Responders Control Group]total 
Responder Rate Control GroupIF([Unique Responders Control Group]/([Unique Recipients Control Group] * 1.000) is missing) THEN(0) ELSE([Unique Responders Control Group]/([Unique Recipients Control Group] * 1.000))  
Lift Over Control GroupIF(([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN(0) ELSE(((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000)  
Total Number of Offers Giventotal([Number of Offers Given - Campaign] for report) 
Total Response Transactionstotal([Response Transactions-Campaign] for report) 
Total Response Rate[Total Response Transactions]/([Total Number of Offers Given] * 1.00) 
Number of Offers Given - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given] 
Response Transactions-Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions] 
Response Rate-Campaign[Response Transactions-Campaign]/([Number of Offers Given - Campaign] * 1.00) 
Campaign Response Rate Control Group[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions Control Group]/[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given Control Group]  
Unique Recipients - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients] 
Unique Responders-Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders] 
Responder Rate-Campaign[Unique Responders-Campaign]/([Unique Recipients - Campaign] * 1.00) 
Unique Recipients Control Group-Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients Control Group] 
Unique Responders Control Group - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders Control Group] 
Responder Rate Control Group-CampaignIF([Unique Responders Control Group - Campaign]/([Unique Recipients Control Group-Campaign]*1.00) is missing) THEN(0) ELSE([Unique Responders Control Group - Campaign]/([Unique Recipients Control Group-Campaign]*1.00))  
Lift Over Control Group-CampaignIF(([Responder Rate-Campaign]-[Responder Rate Control Group-Campaign])/[Responder Rate Control Group-Campaign] is missing) THEN(0) ELSE(((([Responder Rate-Campaign]-[Responder Rate Control Group-Campaign])*1.000)/[Responder Rate Control Group-Campaign])*1.000)  
Not Applilcable Calc[Campaign Listing].[Campaign].[Not Applilcable Calc] 
Campaign Select Prompt
(prompt)
Total: 2  
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')'  
Graph Query
Total: 5Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] in(?CampaignIds?)
[Is Control]<>1
 
 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')'  
Cell Name[Campaign Performance Summary].[Cell].[Cell Name]||' ('||[Campaign Performance Summary].[Cell].[Cell Code]||')' 
Number of Offers Given[Campaign Performance Summary].[Campaign Cell Contact History Summary].[Number of Offers Given]total/ total 
Response Transactions[Campaign Performance Summary].[Campaign Cell Response History Summary].[Response Transactions]total/ total 
Is Control[Campaign Performance Summary].[Cell].[Is Control] 


Campaign Performance Summary by Cell (with Revenue)
Description:The Campaign Performance Summary by Cell (with Revenue) report provides performance data for campaigns with cells grouped by the corresponding campaigns. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders, responder rate and actual revenue. It also includes optional lift over control group information. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift_Columns (boolean): (IF ((ParamValue("Hide_Show_Lift_Columns") IS MISSING) OR (ParamValue("Hide_Show_Lift_Columns") IS NULL)) THEN '' ELSE ParamValue("Hide_Show_Lift_Columns")) = 'Hide'
Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Campaign Performance Summary by Cell (with Revenue).jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 32Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] in (?CampaignIds?)
 
 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Cell ID[Campaign Performance Summary].[Cell].[Cell ID] 
Cell Name[Campaign Performance Summary].[Cell].[Cell Name]||' ('||[Campaign Performance Summary].[Cell].[Cell Code]||')' 
Number of Offers Given[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Number of Offers Given]total 
Response Transactions[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Response Transactions]total 
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given]* 1.00))) 
Unique Recipients[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Unique Recipients]total 
Unique Responders[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Unique Responders]total 
Responder RateIF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders]/([Unique Recipients] * 1.00))) 
Unique Recipients Control Group[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Unique Recipients Control Group]total 
Unique Responders Control Group[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Unique Responders Control Group]total 
Max. Unique Recipients Control Groupmaximum([Unique Recipients Control Group] for [Campaign Name])maximum 
Max. Unique Responders Control Groupmaximum([Unique Responders Control Group] for [Campaign Name])maximum 
Responder Rate Control GroupIF([Unique Responders Control Group]/([Unique Recipients Control Group] * 1.00) is missing) THEN(0) ELSE([Unique Responders Control Group]/([Unique Recipients Control Group] * 1.00)) 
Lift Over Control GroupIF(([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN(0) ELSE(((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000) 
Number of Offers Given - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given]automatic/ automatic 
Response Transactions - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions]automatic/ automatic 
Unique Recipients - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients]automatic/ automatic 
Unique Recipients Control Group - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients Control Group]automatic/ automatic 
Unique Responders - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders] 
Unique Responders Control Group - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders Control Group]automatic/ automatic 
Responder Rate - Campaign[Unique Responders - Campaign]/ ([Unique Recipients - Campaign] * 1.00)automatic/ automatic 
Responder Rate Control Group - CampaignIF([Unique Responders Control Group - Campaign]/([Unique Recipients Control Group - Campaign] * 1.00) is missing) THEN(0) ELSE([Unique Responders Control Group - Campaign]/([Unique Recipients Control Group - Campaign] * 1.00))automatic/ automatic 
Lift Over Control Group - CampaignIF(([Responder Rate - Campaign]-[Responder Rate Control Group - Campaign])/([Responder Rate Control Group - Campaign]*1.000) is missing) THEN(0) ELSE((([Responder Rate - Campaign]-[Responder Rate Control Group - Campaign])*1.000)/([Responder Rate Control Group - Campaign]*1.000))automatic/ automatic 
Response Rate - Campaign[Response Transactions - Campaign]/([Number of Offers Given - Campaign] * 1.00)automatic/ automatic 
Total Number of Offers Giventotal([Number of Offers Given - Campaign] for report)automatic/ automatic 
Total Response Transactionstotal([Response Transactions - Campaign] for report)/ automatic 
Total Response Rate[Total Response Transactions]/([Total Number of Offers Given] * 1.00)/ automatic 
Gross RevenueIF ([Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Gross Revenue] is missing) THEN (0) ELSE ([Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Gross Revenue])total 
Gross Revenue - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Gross Revenue] 
Total Gross Revenuetotal([Gross Revenue - Campaign] for report) 
Not Applilcable Calc[Campaign Listing].[Campaign].[Not Applilcable Calc] 
Campaign Select
(prompt)
Total: 2  
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||'('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 


Campaign Performance Summary by Cell and Initiative
Description:The Campaign Performance Summary by Cell and Initiative report provides performance data for campaigns with cells grouped by the corresponding campaigns and initiatives. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift_Columns (boolean): (IF ((ParamValue("Hide_Show_Lift_Columns") IS MISSING) OR (ParamValue("Hide_Show_Lift_Columns") IS NULL)) THEN '' ELSE ParamValue("Hide_Show_Lift_Columns")) = 'Hide'
Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Campaign Performance Summary by Cell and Initiative.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Main Report Query
(list)
Total: 38Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID]in(?CampaignIds?)
 
 
Cell ID[Campaign Performance Summary].[Cell].[Cell ID] 
Cell Name[Campaign Performance Summary].[Cell].[Cell Name]||' ('||[Campaign Performance Summary].[Cell].[Cell Code]||')' 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Initiative[Campaign Performance Summary].[Campaign].[Initiative] 
Number of Offers Given[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Number of Offers Given]total 
Response Transactions[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Response Transactions]total 
Number of Offers Given-Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given] 
Response Transactions-Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions] 
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given] * 1.00))) 
Unique Recipients[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Unique Recipients]total 
Unique Responders[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Unique Responders]total 
Responder RateIF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN (0) ELSE(([Unique Responders]/([Unique Recipients]* 1.00)))  
Unique Recipients Control Group[Campaign Performance Summary].[Campaign Cell CH with Controls Summary].[Unique Recipients Control Group]total 
Unique Responders Control Group[Campaign Performance Summary].[Campaign Cell RH with Controls Summary].[Unique Responders Control Group]total 
Responder Rate Control GroupIF([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00) is missing) THEN(0) ELSE([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00)) 
Lift Over Control GroupIF(([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN(0) ELSE(((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000) 
Response Rate - Campaign[Response Transactions-Campaign]/([Number of Offers Given-Campaign] * 1.00) 
Unique Recipients-Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients] 
Unique Responders-Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders] 
Responder Rate - Campaign[Unique Responders-Campaign]/([Unique Recipients-Campaign] * 1.00) 
Unique Recipients Control Group-Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients Control Group] 
Unique Responders Control Group-Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders Control Group] 
Responder Rate Control Group - CampaignIF([Unique Responders Control Group-Campaign]/([Unique Recipients Control Group-Campaign]*1.00) is missing) THEN(0) ELSE([Unique Responders Control Group-Campaign]/([Unique Recipients Control Group-Campaign]*1.00)) 
Lift Over Control Group - CampaignIF((([Responder Rate - Campaign]-[Responder Rate Control Group - Campaign])*1.000)/([Responder Rate Control Group - Campaign]*1.000) is missing) THEN(0) ELSE((([Responder Rate - Campaign]-[Responder Rate Control Group - Campaign])*1.000)/([Responder Rate Control Group - Campaign]*1.000)) 
Number of Offers - Initiativetotal([Number of Offers Given-Campaign] for [Initiative])/ automatic 
Response Transactions - Initiativetotal([Response Transactions-Campaign] for [Initiative])/ automatic 
Response Rate - Initiative[Response Transactions - Initiative]/([Number of Offers - Initiative] * 1.00)/ automatic 
Unique Recipients - Initiativetotal([Unique Recipients-Campaign] for [Initiative])/ automatic 
Unique Responders - Initiativetotal([Unique Responders-Campaign] for [Initiative])/ automatic 
Responder Rate - Initiative[Unique Responders - Initiative]/([Unique Recipients - Initiative] * 1.00)/ automatic 
Unique Recipients Control Group - Initiativetotal([Unique Recipients Control Group-Campaign] for [Initiative])/ automatic 
Unique Responders Control Group - Initiativetotal([Unique Responders Control Group-Campaign] for [Initiative])/ automatic 
Responder Rate Control Group - Initiative[Unique Responders Control Group - Initiative]/([Unique Recipients Control Group - Initiative] * 1.00)/ automatic 
Lift Over Control Group - Initiative(([Responder Rate - Initiative]-[Responder Rate Control Group - Initiative])*1.000)/([Responder Rate Control Group - Initiative]*1.000)/ automatic 
Total Number of Offerstotal([Number of Offers - Initiative] for report)/ automatic 
Total Response Transactionstotal([Response Transactions - Initiative] for report)/ automatic 
Total Response Rate[Total Response Transactions]/[Total Number of Offers]/ automatic 
Not Applilcable Calc[Campaign Performance Summary].[Campaign].[Not Applilcable Calc] 
Campaign Prompt Query
(prompt)
Total: 2  
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name (Code)[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 


Campaign Performance Summary by Offer
Description:The Campaign Performance Summary by Offer report provides a summary of campaign and offer performance with offers grouped by the corresponding campaigns. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift (boolean): (IF ((ParamValue('Hide_Show_Lift') IS MISSING) OR (ParamValue('Hide_Show_Lift') IS NULL)) THEN '' ELSE ParamValue('Hide_Show_Lift')) = 'Hide'
Report Language1 (locale): ReportLocale()
zero_ResponderRate (string): CASE WHEN ([Report Query].[Responder Rate] is missing OR [Report Query].[Responder Rate] =0) THEN ('ZERO_BEST_LIFT') END
zero_MinResponderRate (string): CASE WHEN ([Report Query].[Min. Offer Responder Rate] is missing OR [Report Query].[Min. Offer Responder Rate] =0) THEN ('ZERO_WORST_LIFT') END
reports/Affinium Campaign/Campaign Performance Summary by Offer.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 37Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] in (?CampaignIds?)
 
 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Offer Name[Campaign Performance Summary].[Offer].[Offer Name]||' ('||[Campaign Performance Summary].[Offer].[Offer Code1]||')' 
Number of Offers Given[Campaign Performance Summary].[Campaign Offer Contact History Summary].[Number of Offers Given]total/ total 
Unique Recipients[Campaign Performance Summary].[Campaign Offer Contact History Summary].[Unique Recipients]total 
Response Transactions[Campaign Performance Summary].[Campaign Offer Response History Summary].[Response Transactions]total 
Unique Responders[Campaign Performance Summary].[Campaign Offer Response History Summary].[Unique Responders]total 
Not Contacted Responders[Campaign Performance Summary].[Campaign Offer Response History Summary].[Not Contacted Responders]total 
Responses After Expiration[Campaign Performance Summary].[Campaign Offer Response History Summary].[Responses After Expiration]total 
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given] * 1.00))) 
Responder RateIF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders]/([Unique Recipients]* 1.00))) 
Max. Offer Responder Ratemaximum([Responder Rate] for [Campaign Performance Summary].[Campaign].[Campaign ID]) 
Best Offer Lift Over ThisIF (([Max. Offer Responder Rate]-[Responder Rate])/[Responder Rate] is missing) THEN (0) ELSE (((([Max. Offer Responder Rate]-[Responder Rate]) * 1.000)/[Responder Rate]) * 1.000)  
Min. Offer Responder Rateminimum([Responder Rate] for [Campaign ID]) 
Lift Over Worst OfferIF(([Responder Rate]-[Min. Offer Responder Rate])/[Min. Offer Responder Rate] is missing) THEN(0) ELSE(((([Responder Rate]-[Min. Offer Responder Rate])*1.000)/[Min. Offer Responder Rate])*1.000) 
Unique Responders Control Group[Campaign Performance Summary].[Campaign Offer Response History Summary].[Unique Responders Control Group]total 
Unique Recipients Control Group[Campaign Performance Summary].[Campaign Offer Contact History Summary].[Unique Recipients Control Group]total 
Responder Rate Control GroupIF([Unique Responders Control Group]/([Unique Recipients Control Group] * 1.00) is missing) THEN(0) ELSE([Unique Responders Control Group]/([Unique Recipients Control Group] * 1.00)) 
Lift Over Control GroupIF(([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN(0) ELSE(((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000) 
Number Of Offers Given - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given] 
Response Transactions-Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions] 
Response Rate - CampaignIF(([Response Transactions-Campaign]/([Number Of Offers Given - Campaign] * 1.00)) is missing) THEN (0) ELSE(([Response Transactions-Campaign]/([Number Of Offers Given - Campaign] * 1.00))) 
Unique Recipients-Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients] 
Unique Responders-Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders] 
Responder Rate-CampaignIF(([Unique Responders-Campaign]/([Unique Recipients-Campaign] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders-Campaign]/([Unique Recipients-Campaign] * 1.00))) 
Not Contacted Responders - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Not Contacted Responders] 
Responses After Expiration - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Responses After Expiration] 
Unique Recipients Control Group - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients Control Group] 
Unique Responders Control Group - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders Control Group] 
Responder Rate Control Group - CampaignIF ([Unique Responders Control Group - Campaign]/([Unique Recipients Control Group - Campaign]*1.00) is missing) THEN (0) ELSE ([Unique Responders Control Group - Campaign]/([Unique Recipients Control Group - Campaign]*1.00)) 
Lift Over Control Group-CampaignIF(([Responder Rate-Campaign]-[Responder Rate Control Group - Campaign])/[Responder Rate Control Group - Campaign] is missing) THEN(0) ELSE( (( ( [Responder Rate-Campaign]-[Responder Rate Control Group - Campaign])*1.000)/[Responder Rate Control Group - Campaign])*1.000) 
Total Number of Offers Given for reporttotal([Number Of Offers Given - Campaign] for report) 
Total Response Transactions for reporttotal([Response Transactions-Campaign] for report) 
Total Response Rate for report[Total Response Transactions for report]/([Total Number of Offers Given for report] * 1.00) 
Total Not Contacted Responders for reporttotal([Not Contacted Responders - Campaign] for report) 
Total Responses After Expiration for reporttotal([Responses After Expiration - Campaign] for report) 
Not Applilcable Calc[Campaign Listing].[Campaign].[Not Applilcable Calc] 
Campaign Select Prompt
(prompt)
Total: 2  
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 


Campaign Performance Summary by Offer (with Revenue)
Description:The Campaign Performance Summary by Offer (with Revenue) report provides a summary of campaign and offer performance with offers grouped by the corresponding campaigns. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders, responder rate and actual revenue. It also includes optional lift over control group information. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift (boolean): (IF ((ParamValue('Hide_Show_Lift_Columns') IS MISSING) OR (ParamValue('Hide_Show_Lift_Columns') IS NULL)) THEN '' ELSE ParamValue('Hide_Show_Lift_Columns')) = 'Hide'
Report Language1 (locale): ReportLocale()
zero_MinResponderRate (string): CASE WHEN ([Main Report Query].[Min. Responder Rate] is missing OR [Main Report Query].[Min. Responder Rate] =0) THEN ('ZERO_WORST_LIFT') END
zero_ResponderRate (string): CASE WHEN ([Main Report Query].[Responder Rate] is missing OR [Main Report Query].[Responder Rate] =0) THEN ('ZERO_BEST_LIFT') END
reports/Affinium Campaign/Campaign Performance Summary by Offer (with Revenue).jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Campaign Prompt Query
(prompt)
Total: 2  
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Main Report Query
(list)
Total: 41Filters:
[Campaign ID]in(?CampaignIds?)
 
 
Offer ID[Campaign Performance Summary].[Offer].[Offer ID] 
Offer Name[Campaign Performance Summary].[Offer].[Offer Name]||'( '||[Campaign Performance Summary].[Offer].[Offer Code1]||')' 
Campaign ID[Campaign Performance Summary].[Campaign].[Campaign ID] 
Campaign Name[Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' 
Number of Offers Given[Campaign Performance Summary].[Campaign Offer Contact History Summary].[Number of Offers Given]total 
Response Transactions[Campaign Performance Summary].[Campaign Offer Response History Summary].[Response Transactions]total 
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given] * 1.00))) 
Unique Recipients[Campaign Performance Summary].[Campaign Offer Contact History Summary].[Unique Recipients]total 
Unique Responders[Campaign Performance Summary].[Campaign Offer Response History Summary].[Unique Responders]total 
Responder RateIF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders]/([Unique Recipients]* 1.00)))automatic 
Not Contacted Responders[Campaign Performance Summary].[Campaign Offer Response History Summary].[Not Contacted Responders]total 
Responses After Expiration[Campaign Performance Summary].[Campaign Offer Response History Summary].[Responses After Expiration]total 
Unique Recipients Control Group[Campaign Performance Summary].[Campaign Offer Contact History Summary].[Unique Recipients Control Group]total 
Unique Responders Control Group[Campaign Performance Summary].[Campaign Offer Response History Summary].[Unique Responders Control Group]total 
Responder Rate Control GroupIF([Unique Responders Control Group]/([Unique Recipients Control Group] * 1.00) is missing) THEN(0) ELSE([Unique Responders Control Group]/([Unique Recipients Control Group] * 1.00)) 
Max. Responder Ratemaximum([Responder Rate] for [Campaign ID]) 
Best Offer Lift Over ThisIF (([Max. Responder Rate]-[Responder Rate])/[Responder Rate] is missing) THEN (0) ELSE (((([Max. Responder Rate]-[Responder Rate]) * 1.000)/[Responder Rate]) * 1.000) 
Min. Responder Rateminimum([Responder Rate] for [Campaign ID]) 
Lift Over Worst OfferIF(([Responder Rate]-[Min. Responder Rate])/[Min. Responder Rate] is missing) THEN(0) ELSE(((([Responder Rate]-[Min. Responder Rate])*1.000)/[Min. Responder Rate])*1.000) 
Lift Over Control GroupIF(([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN(0) ELSE(((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000) 
Gross RevenueIF (cast([Campaign Performance Summary].[Campaign Offer Response History Summary].[Gross Revenue], int) is null) THEN (0) ELSE ([Campaign Performance Summary].[Campaign Offer Response History Summary].[Gross Revenue])total 
Number of Offers Given - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Number of Offers Given]total 
Response Transactions - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions]total 
Response Rate - CampaignIF(([Response Transactions - Campaign]/([Number of Offers Given - Campaign] * 1.00)) is missing) THEN (0) ELSE(([Response Transactions - Campaign]/([Number of Offers Given - Campaign] * 1.00)))automatic 
Unique Recipients - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients]total/ total 
Unique Responders - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders]total 
Responder Rate - CampaignIF(([Unique Responders - Campaign]/([Unique Recipients - Campaign] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders - Campaign]/([Unique Recipients - Campaign] * 1.00)))automatic 
Not Contacted Responders - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Not Contacted Responders]total 
Responses After Expiration - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Responses After Expiration]total 
Unique Recipients Control Group - Campaign[Campaign Performance Summary].[Campaign Contact History Summary].[Unique Recipients Control Group]total 
Unique Responders Control Group - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Unique Responders Control Group]total 
Responder Rate Control Group - CampaignIF ([Unique Responders Control Group - Campaign]/([Unique Recipients Control Group - Campaign]*1.00) is missing) THEN (0) ELSE ([Unique Responders Control Group - Campaign]/([Unique Recipients Control Group - Campaign]*1.00))automatic 
Lift Over Control Group - CampaignIF(([Responder Rate - Campaign]-[Responder Rate Control Group - Campaign])/[Responder Rate Control Group - Campaign] is missing) THEN(0) ELSE( (( ( [Responder Rate - Campaign]-[Responder Rate Control Group - Campaign])*1.000)/[Responder Rate Control Group - Campaign])*1.000)automatic 
Gross Revenue - Campaign[Campaign Performance Summary].[Campaign Response History Summary].[Gross Revenue]total 
Total Number of Offerstotal([Number of Offers Given - Campaign] for report)/ automatic 
Total Response Transactionstotal([Response Transactions - Campaign] for report)/ automatic 
Total Response Rate[Total Response Transactions]/[Total Number of Offers]/ automatic 
Total Not Contacted Responderstotal([Not Contacted Responders - Campaign] for report)/ automatic 
Total Responses After Expirationtotal([Responses After Expiration - Campaign] for report)/ automatic 
Total Gross Revenuetotal([Gross Revenue - Campaign] for report) 
Not Applilcable Calc[Campaign Performance Summary].[Campaign].[Not Applilcable Calc] 


Campaign Summary
Description:The Campaign Summary report provides an overview of all campaigns that have been created. It lists the campaign code, creation date, start and end dates, last run date, initiative and objective of each campaign. 
# Queries:1
Layout:1 list(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Campaign Summary.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Query1
(list)
Total: 9Filters:
[Campaign Listing].[Campaign].[Campaign ID] in (?CampaignIds?)
 
 
Campaign Name[Campaign Listing].[Campaign].[Campaign Name] 
Campaign Code[Campaign Listing].[Campaign].[Campaign Code] 
Objectives[Campaign Listing].[Campaign].[Objectives] 
Last Run Date[Campaign Listing].[Campaign].[Last Run Date] 
Initiative[Campaign Listing].[Campaign].[Initiative] 
Create Date[Campaign Listing].[Campaign].[Create Date] 
CampaignURL[Campaign Listing].[Campaign].[CampaignURL] 
Start Date[Campaign Listing].[Campaign].[Start Date] 
End Date[Campaign Listing].[Campaign].[End Date] 
Campaign Select
(prompt)
Total: 2  
Campaign ID[Campaign Listing].[Campaign].[Campaign ID] 
Campaign Name[Campaign Listing].[Campaign].[Campaign Name]||' ('||[Campaign Listing].[Campaign].[Campaign Code]||')' 


Offer Campaign Listings
Description:The Offer Campaign Listings report lists campaigns grouped by offers. It lists the campaign code, initiative, start and end dates and last run date. 
# Queries:1
Layout:1 list(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Offer Campaign Listings.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 10Filters:
[Campaign Listing].[Offer].[Offer ID] in (?OfferIds?)
 
 
Campaign Name[Campaign Listing].[Campaign].[Campaign Name] 
Campaign Code[Campaign Listing].[Campaign].[Campaign Code] 
Offer Name[Campaign Listing].[Offer].[Offer Name] 
Initiative[Campaign Listing].[Campaign].[Initiative] 
Start Date[Campaign Listing].[Campaign].[Start Date] 
End Date[Campaign Listing].[Campaign].[End Date] 
Last Run Date[Campaign Listing].[Campaign].[Last Run Date] 
CampaignURL[Campaign Listing].[Campaign].[CampaignURL] 
OfferURL[Campaign Listing].[Offer].[OfferURL] 
Offer Code1[Campaign Listing].[Offer].[Offer Code1] 
Offer Select Prompt
(prompt)
Total: 2  
Offer ID[Campaign Listing].[Offer].[Offer ID] 
Offer Name[Campaign Listing].[Offer].[Offer Name]||' ('||[Campaign Listing].[Offer].[Offer Code1]||')' 


Offer Performance by Day
Description:The Offer Performance by Day report shows offer performance for a specified date or date range. It lists the number of offers given, number of response transactions and the response rate during the specified date or date range. 
# Queries:1
Layout:1 crosstabs(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Offer Performance by Day.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(crosstab)
Total: 8Filters:
[Offer Performance by Day].[Calendar].[Actual Date] >= ?BeginDate?
[Offer Performance by Day].[Calendar].[Actual Date] <= ?EndDate?
[Offer Performance by Day].[Offer].[Offer ID] in (?OfferIds?)
 
 
Actual Datecast([Offer Performance by Day].[Calendar].[Actual Date], DATE) 
Number of Offers Given[Offer Performance by Day].[Offer Contact History by Day].[Number of Offers Given]total 
Response Transactions[Offer Performance by Day].[Offer Response History by Day].[Response Transactions]total 
Offer Name[Offer Performance by Day].[Offer].[Offer Name]||' ('||[Offer Performance by Day].[Offer].[Offer Code1]||')' 
Response RateIF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given] * 1.00))) 
Total(Number of Offers Given)total([Number of Offers Given] within set [Actual Date]) 
Total(Response Transactions)total([Response Transactions] within set [Actual Date]) 
Total(Response Rate)IF ([Total(Response Transactions)]/([Total(Number of Offers Given)] * 1.00) is missing) THEN (0) ELSE ([Total(Response Transactions)]/([Total(Number of Offers Given)] * 1.00)) 


Offer Performance Comparison
Description:The Offer Performance Comparison report compares the performance of offers. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift (boolean): (IF ((ParamValue('Hide_Show_Lift') IS MISSING) OR (ParamValue('Hide_Show_Lift') IS NULL)) THEN '' ELSE ParamValue('Hide_Show_Lift')) = 'Hide'
Report Language1 (locale): ReportLocale()
zero_ResponderRate (string): CASE WHEN ([Report Query].[Responder Rate] is missing OR [Report Query].[Responder Rate]=0) THEN ('ZERO_BEST_LIFT') END
zero_MinResponderRate (string): CASE WHEN ([Report Query].[Min Offer Responder Rate] is missing OR [Report Query].[Min Offer Responder Rate]=0) THEN ('ZERO_WORST_LIFT') END
reports/Affinium Campaign/Offer Performance Comparison.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 23Filters:
[Offer Performance Summary].[Offer].[Offer ID] in (?OfferIds?)
 
 
Offer ID[Offer Performance Summary].[Offer].[Offer ID] 
Offer Name[Offer Performance Summary].[Offer].[Offer Name]||' ('||[Offer Performance Summary].[Offer].[Offer Code1]||')' 
Number of Offers Given[Offer Performance Summary].[Offer Contact History Summary].[Number of Offers Given]total 
Response Transactions[Offer Performance Summary].[Offer Response History Summary].[Response Transactions]total 
Unique Responders[Offer Performance Summary].[Offer Response History Summary].[Unique Responders]total 
Not Contacted Responders[Offer Performance Summary].[Offer Response History Summary].[Not Contacted Responders]total 
Responses After Expiration[Offer Performance Summary].[Offer Response History Summary].[Responses After Expiration]total 
Unique Recipients[Offer Performance Summary].[Offer Contact History Summary].[Unique Recipients]total 
Response RateIF (([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN (0) ELSE (([Response Transactions]/([Number of Offers Given] * 1.00)))  
Responder RateIF (([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN (0) ELSE (([Unique Responders]/([Unique Recipients] * 1.00)))  
Unique Responders Control Group[Offer Performance Summary].[Offer Response History Summary].[Unique Responders Control Group]total 
Unique Recipients Control Group[Offer Performance Summary].[Offer Contact History Summary].[Unique Recipients Control Group]total 
Responder Rate Control GroupIF ([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00) is missing) THEN (0) ELSE ([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00))  
Lift Over Control GroupIF (([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN (0) ELSE (((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000)  
Response Rate total for reporttotal([Response Transactions] for report)/(total([Number of Offers Given] for report)*1.00)calculated/ calculated 
Total(Number of Offers Given)[Number of Offers Given]calculated/ total 
Total(Response Transactions)[Response Transactions]calculated/ total 
Total(Not Contacted Responders)[Not Contacted Responders]calculated/ total 
Total(Responses After Expiration)[Responses After Expiration]calculated/ total 
Max Offer Responder Ratemaximum([Responder Rate] for report) 
Best Offer Lift Over ThisIF (([Max Offer Responder Rate]-[Responder Rate])/[Responder Rate] is missing) THEN (0) ELSE (((([Max Offer Responder Rate]-[Responder Rate]) * 1.000)/[Responder Rate]) * 1.000)  
Min Offer Responder Rateminimum([Responder Rate] for report) 
Lift Over Worst OfferIF (([Responder Rate]-[Min Offer Responder Rate])/[Min Offer Responder Rate] is missing) THEN (0) ELSE (((([Responder Rate]-[Min Offer Responder Rate]) * 1.000)/[Min Offer Responder Rate]) * 1.000)  
Offer Select
(prompt)
Total: 2  
Offer ID[Offer Performance Summary].[Offer].[Offer ID] 
Offer Name[Offer Performance Summary].[Offer].[Offer Name]||' ('||[Offer Performance Summary].[Offer].[Offer Code1]||')' 


Offer Performance Metrics
Description:Offer Performance Metrics report compares the performance of offers based on various response attributions, such as Best Match, Fractional Match and Multiple Match. It also includes optional lift over control group information and percentage difference between various attribution rates. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Percent_Differences (boolean): (IF ((ParamValue("Hide_Show_Percent_Differences") IS MISSING) OR (ParamValue("Hide_Show_Percent_Differences") IS NULL)) THEN '' ELSE ParamValue("Hide_Show_Percent_Differences")) = 'Hide'
Report Language1 (locale): ReportLocale()
reports/Affinium Campaign/Offer Performance Metrics.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Offer Select Prompt Query
(prompt)
Total: 2  
Offer ID[Offer Performance Summary].[Offer].[Offer ID] 
Offer Name (Code)[Offer Performance Summary].[Offer].[Offer Name] + ' (' + [Offer Performance Summary].[Offer].[Offer Code1] + ')' 
Report Query
(list)
Total: 22Filters:
[Offer ID] in (?OfferIds?)
 
 
Offer ID[Offer Performance Summary].[Offer].[Offer ID] 
Offer Name[Offer Performance Summary].[Offer].[Offer Name]||' ('||[Offer Performance Summary].[Offer].[Offer Code1]||')' 
Number of Offers Given[Offer Performance Summary].[Offer Contact History Summary].[Number of Offers Given]total 
Best Match Response RateIF (([Best Match]/([Number of Offers Given] * 1.00)) is missing) THEN (0) ELSE (([Best Match]/([Number of Offers Given] * 1.00)))  
Fractional Match Response RateIF (([Fractional Match]/([Number of Offers Given] * 1.00)) is missing) THEN (0) ELSE (([Fractional Match]/([Number of Offers Given] * 1.00)))  
Multiple Match Response RateIF (([Multiple Match]/([Number of Offers Given] * 1.00)) is missing) THEN (0) ELSE (([Multiple Match]/([Number of Offers Given] * 1.00)))  
Best Match Response Rate Control Group[Offer Performance Summary].[Offer Performance Metrics Summary].[Best Match Control Group]/([Offer Performance Summary].[Offer Contact History Summary].[Number of Offers Given Control Group]*1.000)calculated 
Lift Over Control Groupif ( ( ([Best Match Response Rate]-[Best Match Response Rate Control Group])*1.000)/([Best Match Response Rate Control Group]*1.000) is missing) then (0) else ( ( ([Best Match Response Rate]-[Best Match Response Rate Control Group])*1.000)/([Best Match Response Rate Control Group]*1.000)) 
Difference Best to FractionalIF ( (([Best Match]-[Fractional Match])*1.000)/([Best Match]*1.000) is missing) THEN (0) ELSE ( (([Best Match]-[Fractional Match])*1.000)/([Best Match]*1.000)) 
Difference Best to MultipleIF ( (([Best Match]-[Multiple Match])*1.000)/([Best Match]*1.000) is missing) THEN (0) ELSE ( (([Best Match]-[Multiple Match])*1.000)/([Best Match]*1.000)) 
Difference Fractional to MultipleIF ((([Fractional Match]-[Multiple Match])*1.000)/([Fractional Match]*1.000) is missing) THEN (0) ELSE ((([Fractional Match]-[Multiple Match])*1.000)/([Fractional Match]*1.000)) 
Total(Number of Offers Given)[Number of Offers Given]calculated/ total 
Total Best Match Response Rateif (total([Number of Offers Given] for Report) = 0) then (0) else (total([Best Match] for Report)/(total([Number of Offers Given] for Report)*1.00)) 
Total Fractional Match Response Rateif (total([Number of Offers Given] for Report) = 0) then (0) else (total([Fractional Match] for Report)/(total([Number of Offers Given] for Report)*1.00)) 
Total Multiple Match Response Rateif (total([Number of Offers Given] for Report) = 0) then (0) else (total([Multiple Match] for Report)/(total([Number of Offers Given] for Report)*1.00)) 
Total % Difference Best to Fractionalif (total([Fractional Match] for Report) is missing) then (0) else (((total([Best Match] for report)-total([Fractional Match] for report))*1.000)/(total([Best Match] for report)*1.000)) 
Total % Difference Best to Multipleif (total([Multiple Match] for Report) = 0) then (0) else (((total([Best Match] for report)-total([Multiple Match] for report))*1.000)/(total([Best Match] for report)*1.000)) 
Total % Difference Fractional to Multipleif (total([Multiple Match] for Report) = 0) then (0) else (((total([Fractional Match] for report)-total([Multiple Match] for report))*1.000)/(total([Fractional Match] for report)*1.000)) 
Not Applilcable Calc[Offer Performance Summary].[Campaign].[Not Applilcable Calc] 
Best MatchIF ([Offer Performance Summary].[Offer Performance Metrics Summary].[Best Match] =0) THEN (0) ELSE ([Offer Performance Summary].[Offer Performance Metrics Summary].[Best Match])total 
Fractional MatchIF ([Offer Performance Summary].[Offer Performance Metrics Summary].[Fractional Match] =0) THEN (0) ELSE ([Offer Performance Summary].[Offer Performance Metrics Summary].[Fractional Match])total 
Multiple Match[Offer Performance Summary].[Offer Performance Metrics Summary].[Multiple Match]total 


Offer Performance Summary by Campaign
Description:The Offer Performance Summary by Campaign report provides a summary of offer and campaign performance with campaigns grouped by the corresponding offers. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information. 
# Queries:1
Layout:1 list(s)
Report Variables:Hide_Show_Lift (boolean): (IF ((ParamValue('Hide_Show_Lift') IS MISSING) OR (ParamValue('Hide_Show_Lift') IS NULL)) THEN '' ELSE ParamValue('Hide_Show_Lift')) = 'Hide'
Report Language1 (locale): ReportLocale()
zero_ResponderRate (string): CASE WHEN ([Report Query].[Responder Rate] is missing or [Report Query].[Responder Rate]=0) THEN ('ZERO_BEST_LIFT') END
zero_MinResponderRate (string): CASE WHEN ([Report Query].[Min Offer Responder Rate] is missing OR [Report Query].[Min Offer Responder Rate]=0) THEN ('ZERO_WORST_LIFT') END
reports/Affinium Campaign/Offer Performance Summary by Campaign.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 37Filters:
[Offer Performance Summary].[Offer].[Offer ID] in (?OfferIds?)
 
 
Campaign Name[Offer Performance Summary].[Campaign].[Campaign Name]||' ('||[Offer Performance Summary].[Campaign].[Campaign Code]||')' 
Offer Name[Offer Performance Summary].[Offer].[Offer Name]||' ('||[Offer Performance Summary].[Offer].[Offer Code1]||')' 
Offer ID[Offer Performance Summary].[Offer].[Offer ID] 
Number of Offers Given[Offer Performance Summary].[Offer Campaign Contact History Summary].[Number of Offers Given] 
Response Transactions[Offer Performance Summary].[Offer Campaign Response History Summary].[Response Transactions] 
Unique Recipients[Offer Performance Summary].[Offer Campaign Contact History Summary].[Unique Recipients] 
Unique Responders[Offer Performance Summary].[Offer Campaign Response History Summary].[Unique Responders] 
Not Contacted Responders[Offer Performance Summary].[Offer Campaign Response History Summary].[Not Contacted Responders] 
Responses After Expiration[Offer Performance Summary].[Offer Campaign Response History Summary].[Responses After Expiration] 
Response RateIF (([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN (0) ELSE (([Response Transactions]/([Number of Offers Given]*1.00))) 
Responder RateIF (([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN (0) ELSE (([Unique Responders]/([Unique Recipients]*1.00))) 
Max Offer Responder Ratemaximum([Responder Rate] for [Offer ID]) 
Best Offer Lift Over ThisIF (([Max Offer Responder Rate]-[Responder Rate])/[Responder Rate] is missing) THEN (0) ELSE (((([Max Offer Responder Rate]-[Responder Rate]) * 1.000)/[Responder Rate]) * 1.000) 
Min Offer Responder Rateminimum([Responder Rate] for [Offer ID]) 
Lift Over Worst OfferIF (([Responder Rate]-[Min Offer Responder Rate])/[Min Offer Responder Rate] is missing) THEN (0) ELSE (((([Responder Rate]-[Min Offer Responder Rate]) * 1.000)/[Min Offer Responder Rate]) * 1.000) 
Unique Recipients Control Group[Offer Performance Summary].[Offer Campaign Contact History Summary].[Unique Recipients Control Group] 
Unique Responders Control Group[Offer Performance Summary].[Offer Campaign Response History Summary].[Unique Responders Control Group] 
Responder Rate Control GroupIF ([Unique Responders Control Group]/[Unique Recipients Control Group] is missing) THEN (0) ELSE ([Unique Responders Control Group]/([Unique Recipients Control Group]*1.00)) 
Lift Over Control GroupIF (([Responder Rate]-[Responder Rate Control Group])/[Responder Rate Control Group] is missing) THEN (0) ELSE (((([Responder Rate]-[Responder Rate Control Group])*1.000)/[Responder Rate Control Group])*1.000) 
Number of Offers Given-Offer[Offer Performance Summary].[Offer Contact History Summary].[Number of Offers Given] 
Response Transactions-Offer[Offer Performance Summary].[Offer Response History Summary].[Response Transactions] / count([Campaign Name] for [Offer ID])total 
Response Rate-OfferIF (([Response Transactions-Offer]/([Number of Offers Given-Offer] * 1.00)) is missing) THEN (0) ELSE (([Response Transactions-Offer]/([Number of Offers Given-Offer]*1.00))) 
Unique Recipients - Offer[Offer Performance Summary].[Offer Contact History Summary].[Unique Recipients]total 
Unique Responders-Offer[Offer Performance Summary].[Offer Response History Summary].[Unique Responders] 
Responder Rate - OfferIF (([Unique Responders-Offer]/([Unique Recipients - Offer] * 1.00)) is missing ) THEN (0) ELSE (([Unique Responders-Offer]/([Unique Recipients - Offer]*1.00))) 
Not Contacted Responders-Offer[Offer Performance Summary].[Offer Response History Summary].[Not Contacted Responders] 
Responses After Expiration-Offer[Offer Performance Summary].[Offer Response History Summary].[Responses After Expiration] 
Unique Recipients Control Group-Offer[Offer Performance Summary].[Offer Contact History Summary].[Unique Recipients Control Group]total 
Unique Responders Control Group-Offer[Offer Performance Summary].[Offer Response History Summary].[Unique Responders Control Group] 
Responder Rate Control Group-OfferIF ([Unique Responders Control Group-Offer]/[Unique Recipients Control Group-Offer] is missing) THEN (0) ELSE ([Unique Responders Control Group-Offer]/([Unique Recipients Control Group-Offer]*1.00)) 
Lift Over Control Group-OfferIF (([Responder Rate - Offer]-[Responder Rate Control Group-Offer])/[Responder Rate Control Group-Offer] is missing) THEN (0) ELSE (((([Responder Rate - Offer]-[Responder Rate Control Group-Offer]) * 1.000)/[Responder Rate Control Group-Offer]) * 1.000) 
Total Number of Offers Given for reporttotal ([Number of Offers Given-Offer]for report) 
Total Response Transactions for reporttotal ([Response Transactions-Offer]) 
Total Response Rate for report[Total Response Transactions for report]/([Total Number of Offers Given for report]*1.00)calculated/ calculated 
Total Not Contacted Responders for reporttotal ([Not Contacted Responders-Offer] for report) 
Total Responses After Expiration for reporttotal ([Responses After Expiration-Offer] for report) 
Not Applilcable Calc[Campaign Listing].[Campaign].[Not Applilcable Calc] 
Offer Select Prompt
(prompt)
Total: 2  
Offer ID[Offer Performance Summary].[Offer].[Offer ID] 
Offer Name[Offer Performance Summary].[Offer].[Offer Name]||' ('||[Offer Performance Summary].[Offer].[Offer Code1]||')'  


Copyright

© Copyright Unica Corporation 2003 - 2010. All rights reserved.

Unica Corporation
Reservoir Place North
170 Tracer Lane
Waltham, MA 02451-1379
Examples and Data

All software and related documentation is subject to restrictions on use and disclosure as set forth in the Unica Software License and Services Agreement, with restricted rights for U.S. government users and applicable export regulations.

Companies, names, and data used in examples herein are fictitious unless otherwise noted.

Trademarks and Patents

Unica®, the Unica logo, Affinium®, MarketingCentral®, MarketSoft®, MarketSoft logo, DemandMore®, Leads to Revenue®, NetTracker®, My NetTracker®, and Ask NetTracker® are registered trademarks of Unica Corporation with the U.S. Patent and Trademark Office.

Affinium Campaign™, Affinium Campaign Collaborate™, Affinium Campaign eMessage™, Affinium Campaign Interact™, Affinium Campaign Optimize™, Affinium Detect™, Affinium Leads™, Affinium Leads Referral™, Affinium Leads Contact™, Affinium Model™, Affinium NetInsight™, Affinium Insight™, Affinium Plan™, Affinium Mart™, Universal Dynamic Interconnect™, Interconnect Modules™, Marketic™, Powering Marketing Success™, Drill Anywhere™, Marketing Objects™, Trend Anything™, Customer Value Maximization™, MAP™, One-to-One Optimization™, and Right-time Marketing™ are trademarks of Unica Corporation. All other trademarks are the property of their respective owners.

Portions of the software described in this document are covered by U.S. Patent Numbers: 6,317,752, 6,269,325, 6,542,894, and 6,782,390.

The NetTracker, Affinium Insight, and Affinium NetInsight products are licensed under the following patents and patent publications: US5,675,510, US6,115,680, US6,108,637, US5,796,952, US6,138,155, US6,653,696, US6,763,386, AU0701813, BR9609217, CA2223919, EP0843946, JP03317705, MX193614, NO09705728, AU735285, CA2246746, CN1174316, CN1547123, CN1547124, DK870234, DE69720186, ES2195170, AU727170, BR9808033, CA2284530, CN1251669, IL131871, JP2000514942, KR341110, NZ337756, WO9641495, EP0870234, EP1130526, EP1168196, US20040078292, WO9810349, US20050114511, US20040221033, WO9843380.

Markup functionality in Affinium Plan is enabled through use of third-party software components from AdLib™ eDocument Solutions and Adobe® Acrobat®. "Powered by AdLib™."

NOTICE: This document contains confidential and proprietary information of Unica Corporation ("Unica"). Use, duplication, or disclosure without the express written consent of Unica Corporation is prohibited.