Unica Campaign Reports Specifications
Folder: Affinium Campaign - Object Specific Reports

"What If" Offer Financial Summary
Campaign Detailed Offer Response Breakout
Campaign Financial Summary by Offer (Actual)
Campaign Offer Performance by Month
Campaign Performance Summary by Cell
Campaign Performance Summary by Cell (with Revenue)
Campaign Performance Summary by Offer
Offer Performance by Day
Offer Performance Summary by Campaign


"What If" Offer Financial Summary
Description: 
# Queries:1
Layout:6 crosstabs(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign - Object Specific Reports/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: 
# Queries:1
Layout:1 list(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign - Object Specific Reports/Campaign Detailed Offer Response Breakout.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 33Filters:
[Campaign Offer Detailed Response Breakout].[CampToOffer].[Campaign ID] =?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] 
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] 
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))) 
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 Financial Summary by Offer (Actual)
Description: 
# Queries:1
Layout:1 list(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign - Object Specific Reports/Campaign Financial Summary by Offer (Actual).jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 38Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] = ?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]) 


Campaign Offer Performance by Month
Description: 
# Queries:1
Layout:1 crosstabs(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign - Object Specific Reports/Campaign Offer Performance by Month.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(crosstab)
Total: 11Filters:
[Campaign ID] = ?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 Summary by Cell
Description: 
# 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 - Object Specific Reports/Campaign Performance Summary by Cell.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 23Filters:
[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) 
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) 


Campaign Performance Summary by Cell (with Revenue)
Description: 
# 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 - Object Specific Reports/Campaign Performance Summary by Cell (with Revenue).jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 31Filters:
[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) 


Campaign Performance Summary by Offer
Description: 
# 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 - Object Specific Reports/Campaign Performance Summary by Offer.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 32Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] = ?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) 
Not Applilcable Calc[Campaign Listing].[Campaign].[Not Applilcable Calc] 


Offer Performance by Day
Description: 
# Queries:1
Layout:1 crosstabs(s)
Report Variables:Report Language1 (locale): ReportLocale()
reports/Affinium Campaign - Object Specific Reports/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] =?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 Summary by Campaign
Description: 
# 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 - Object Specific Reports/Offer Performance Summary by Campaign.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
(list)
Total: 32Filters:
[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) 
Not Applilcable Calc[Campaign Listing].[Campaign].[Not Applilcable Calc] 


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.