Unica Marketing Operations and Campaign Reports Specifications
Folder: Affinium Plan

Campaign Cell Financial Comparison
A report of budget, revenue, and ROI information for each campaign and each cell within the campaign.
Campaign Offer by Channel Financial Comparison
A report of budget, revenue, and ROI information for each campaign, each channel within the campaign, and each offer within the channel.
Campaign Offer Financial Comparison
A report of budget, revenue, and ROI information for each campaign and each offer within the campaign.


Campaign Cell Financial Comparison
Description:A report of budget, revenue, and ROI information for each campaign and each cell within the campaign. 
# Queries:1
Layout:1 list(s)
Report Variables:Budget Difference (boolean): [Final Report Query].[Budget Difference-Campaign]< 0
Revenue Difference (boolean): [Final Report Query].[Revenue Difference - Campaign]> 0
ROI Difference (boolean): [Final Report Query].[ROI Difference-Campaign] > 0
Total Budget Difference (boolean): [Final Report Query].[Total Budget Difference for report]<0
Total Revenue Difference (boolean): [Final Report Query].[Total Revenue Difference for report]>0
Total ROI Difference (boolean): [Final Report Query].[Total ROI Difference for report]>0
Report Language1 (locale): ReportLocale()
reports/Affinium Plan/Campaign Cell Financial Comparison.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
Total: 22Filters:
[Campaign Project by Cell].[Campaign Financial].[Campaign ID] in (?campaignprojectid?)
 
 
Campaign ID[Campaign Project by Cell].[Campaign Financial].[Campaign ID] 
Campaign Name[Campaign Project by Cell].[Campaign Financial].[Campaign Name]||' ('||[Campaign Project by Cell].[Campaign Financial].[Campaign Code]||')' 
Cell Name[Campaign Project by Cell].[Cell Financial].[Cell Name]||'('||[Campaign Project by Cell].[Cell Financial].[Cell Code]||')' 
Actual CostIF ([Campaign Project by Cell].[Cell Financial].[Actual Cost] is missing) THEN (0) ELSE ([Campaign Project by Cell].[Cell Financial].[Actual Cost])  
Actual Cost - Campaigntotal([Campaign Project by Cell].[Campaign Financial].[Actual Cost] for [Campaign ID] )total 
Committed TotalIF ([Campaign Project by Cell].[Campaign Financial].[Committed Total] is missing) THEN (0) ELSE ([Campaign Project by Cell].[Campaign Financial].[Committed Total])  
Actual Total Cost - CampaignIF ([Actual Cost - Campaign] + [Committed Total] is missing) THEN (0) ELSE ([Actual Cost - Campaign] + [Committed Total])  
Project URL[Campaign Project by Cell].[Campaign Financial].[Project URL] 
Budget TotalIF ([Campaign Project by Cell].[Campaign Financial].[Budget Total] is missing) THEN (0) ELSE ([Campaign Project by Cell].[Campaign Financial].[Budget Total])  
Project Total CostIF ([Campaign Project by Cell].[Campaign Financial].[Project Total Cost] is missing) THEN (0) ELSE ([Campaign Project by Cell].[Campaign Financial].[Project Total Cost])  
Target Budget Costs-Campaign[Budget Total]+[Project Total Cost] 
Gross RevenueIF ([Campaign Project by Cell].[Cell Financial].[Gross Revenue] is missing) THEN (0) ELSE ([Campaign Project by Cell].[Cell Financial].[Gross Revenue]) total 
Total(Gross Revenue)[Gross Revenue]calculated/ total 
Project Total RevenueIF ([Campaign Project by Cell].[Campaign Financial].[Project Total Revenue] is missing) THEN (0) ELSE ([Campaign Project by Cell].[Campaign Financial].[Project Total Revenue])  
Actual ROI-CellIF([Actual Cost] =0) THEN(0) ELSE(([Gross Revenue]-[Actual Cost])/([Actual Cost] * 1.000))  
Actual ROI- CampaignIF([Actual Total Cost - Campaign]=0) THEN(0) ELSE( ([Total(Gross Revenue)]-[Actual Total Cost - Campaign])/([Actual Total Cost - Campaign]*1.000))  
Target ROI - CampaignIF([Target Budget Costs-Campaign]=0) THEN(0) ELSE(([Project Total Revenue]-[Target Budget Costs-Campaign])/([Target Budget Costs-Campaign]*1.000))  
Budget Difference-Campaign[Target Budget Costs-Campaign]-[Actual Total Cost - Campaign] 
Revenue Difference - Campaign[Project Total Revenue]-[Total(Gross Revenue)] 
ROI Difference-CampaignIF ([Target ROI - Campaign]-[Actual ROI- Campaign] is missing) THEN (0) ELSE ([Target ROI - Campaign]-[Actual ROI- Campaign])  
Total Actual Costs for ReportIF (total([Actual Cost - Campaign] for report) is missing) THEN (0) ELSE (total([Actual Cost - Campaign] for report))  
Total Gross Revenue for reportIF (total([Gross Revenue] for report) is missing) THEN (0) ELSE (total([Gross Revenue] for report))  
Campaign Project Select
(prompt)
Total: 2Filters:
[Campaign Project by Cell].[Campaign Financial].[Project ID] is NOT NULL
 
 
Campaign ID[Campaign Project by Cell].[Campaign Financial].[Campaign ID] 
Campaign Name[Campaign Project by Cell].[Campaign Financial].[Campaign Name]||' ('||[Campaign Project by Cell].[Campaign Financial].[Campaign Code]||')' 
Campaign Totals
Total: 6Filters:
[Campaign ID] in (?campaignprojectid?)
 
 
Campaign ID[Campaign Project by Cell].[Campaign Project].[Campaign ID] 
Project ID[Campaign Project by Cell].[Campaign Project].[Project ID] 
Committed TotalIF (total([Campaign Project by Cell].[Campaign Project].[Committed Total] for report) is missing) THEN (0) ELSE (total([Campaign Project by Cell].[Campaign Project].[Committed Total] for report)) total 
Budget TotalIF (total([Campaign Project by Cell].[Campaign Project].[Budget Total] for report) is missing) THEN (0) ELSE (total([Campaign Project by Cell].[Campaign Project].[Budget Total] for report)) total 
Project Total RevenueIF (total([Campaign Project by Cell].[Campaign Project].[Project Total Revenue] for report) is missing) THEN (0) ELSE (total([Campaign Project by Cell].[Campaign Project].[Project Total Revenue] for report)) total 
Project Total CostIF (total([Campaign Project by Cell].[Campaign Project].[Project Total Cost] for report) is missing) THEN (0) ELSE (total([Campaign Project by Cell].[Campaign Project].[Project Total Cost] for report)) total 
Final Report Query
(list)
Total: 30  
Campaign ID[Campaign Totals].[Campaign ID] 
Campaign Name[Report Query].[Campaign Name] 
Cell Name[Report Query].[Cell Name] 
Actual CostIF ([Report Query].[Actual Cost] is missing) THEN (0) ELSE ([Report Query].[Actual Cost])  
Actual Cost - Campaign[Report Query].[Actual Cost - Campaign] 
Committed Total[Report Query].[Committed Total] 
Actual Total Cost - CampaignIF ([Report Query].[Actual Total Cost - Campaign] is missing) THEN (0) ELSE ([Report Query].[Actual Total Cost - Campaign])  
Project URL[Report Query].[Project URL] 
Budget Total[Report Query].[Budget Total] 
Project Total Cost[Report Query].[Project Total Cost] 
Target Budget Costs-CampaignIF ([Report Query].[Target Budget Costs-Campaign] is missing) THEN (0) ELSE ([Report Query].[Target Budget Costs-Campaign])  
Gross RevenueIF ([Report Query].[Gross Revenue] is missing) THEN (0) ELSE ([Report Query].[Gross Revenue])  
Total(Gross Revenue)IF ([Report Query].[Total(Gross Revenue)] is missing) THEN (0) ELSE ([Report Query].[Total(Gross Revenue)])  
Project Total RevenueIF ([Report Query].[Project Total Revenue] is missing) THEN (0) ELSE ([Report Query].[Project Total Revenue])  
Actual ROI-CellIF ([Report Query].[Actual ROI-Cell] is missing) THEN (0) ELSE ([Report Query].[Actual ROI-Cell])  
Actual ROI- CampaignIF ([Report Query].[Actual ROI- Campaign] is missing) THEN (0) ELSE ([Report Query].[Actual ROI- Campaign])  
Target ROI - CampaignIF ([Report Query].[Target ROI - Campaign] is missing) THEN (0) ELSE ([Report Query].[Target ROI - Campaign])  
Budget Difference-CampaignIF ([Report Query].[Budget Difference-Campaign] is missing) THEN (0) ELSE ([Report Query].[Budget Difference-Campaign])  
Revenue Difference - CampaignIF ([Report Query].[Revenue Difference - Campaign] is missing) THEN (0) ELSE ([Report Query].[Revenue Difference - Campaign])  
ROI Difference-CampaignIF ([Report Query].[ROI Difference-Campaign] is missing) THEN (0) ELSE ([Report Query].[ROI Difference-Campaign])  
Total Target Budget Costs for report[Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost] 
Total Actual Costs for Report[Report Query].[Total Actual Costs for Report]+[Campaign Totals].[Committed Total] 
Total Committed for report[Campaign Totals].[Committed Total] 
Total Budget Difference for report([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost])-([Report Query].[Total Actual Costs for Report]+[Campaign Totals].[Committed Total]) 
Total Target Revenue for report[Campaign Totals].[Project Total Revenue] 
Total Revenue Difference for report[Campaign Totals].[Project Total Revenue]-[Report Query].[Total Gross Revenue for report] 
Total Gross Revenue for report[Report Query].[Total Gross Revenue for report] 
Total Target ROI for report([Campaign Totals].[Project Total Revenue]-([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost]))/(([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost])*1.000) 
Total Actual ROI for report([Report Query].[Total Gross Revenue for report]-([Report Query].[Total Actual Costs for Report]+[Campaign Totals].[Committed Total]))/(([Report Query].[Total Actual Costs for Report]+[Campaign Totals].[Committed Total])*1.000) 
Total ROI Difference for report([Report Query].[Total Gross Revenue for report]-([Report Query].[Total Actual Costs for Report]+[Campaign Totals].[Committed Total]))/(([Report Query].[Total Actual Costs for Report]+[Campaign Totals].[Committed Total])*1.000) - ([Campaign Totals].[Project Total Revenue]-([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost]))/(([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost])*1.000) 


Campaign Offer by Channel Financial Comparison
Description:A report of budget, revenue, and ROI information for each campaign, each channel within the campaign, and each offer within the channel. 
# Queries:1
Layout:1 list(s)
Report Variables:Budget Difference (boolean): [Final Report Query].[Budget Difference]<0
Revenue Difference (boolean): [Final Report Query].[Revenue Difference]>0
ROI Difference (boolean): [Final Report Query].[ROI Difference]>0
Total Budget Difference (boolean): [Final Report Query].[Total Budget Difference for report] < 0
Total Revenue Difference (boolean): [Final Report Query].[Total Revenue Difference for report] > 0
Total ROI Difference (boolean): [Final Report Query].[Total ROI Difference for report] > 0
No Channel Assigned (boolean): [Final Report Query].[Channel1] is missing
Report Language1 (locale): ReportLocale()
reports/Affinium Plan/Campaign Offer by Channel Financial Comparison.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
Total: 27Filters:
[Campaign Project by Offer].[Campaign Project by Offer].[Campaign ID] in ( ?campaignprojectid?)
 
 
Campaign ID[Campaign Project by Offer].[Campaign Project by Offer].[Campaign ID] 
Project URL[Campaign Project by Offer].[Campaign Project by Offer].[Project URL] 
Offer ID[Campaign Project by Offer].[Campaign Project by Offer].[Offer ID] 
OfferURL[Campaign Project by Offer].[Campaign Project by Offer].[OfferURL] 
Campaign Name[Campaign Project by Offer].[Campaign Project by Offer].[Campaign Name]||' ('||[Campaign Project by Offer].[Campaign Project by Offer].[Campaign Code]||')' 
Offer Name[Campaign Project by Offer].[Campaign Project by Offer].[Offer Name]||' ('||[Campaign Project by Offer].[Campaign Project by Offer].[Offer Code1]||')' 
Gross RevenueIF ([Campaign Project by Offer].[Campaign Project by Offer].[Gross Revenue] is missing) THEN (0) ELSE ([Campaign Project by Offer].[Campaign Project by Offer].[Gross Revenue]) total 
Offer Fulfillment Cost[Campaign Project by Offer].[Campaign Project by Offer].[Offer Fulfillment Cost]total 
Committed Total[Campaign Project by Offer].[Campaign Project by Offer].[Committed Total] + (Total([Offer Fulfillment Cost] for [Campaign ID]))total 
Budget Total[Campaign Project by Offer].[Campaign Project by Offer].[Budget Total] 
Target Revenue[Campaign Project by Offer].[Campaign Project by Offer].[Project Total Revenue] 
Project Variable Total Cost[Campaign Project by Offer].[Campaign Project by Offer].[Project Total Cost] 
Target Budget Costs[Budget Total] + [Project Variable Total Cost]calculated 
Total Offer Fulfillment CostTotal([Offer Fulfillment Cost] for [Campaign ID])calculated/ total 
Gross Revenue-CampaignIF (Total([Gross Revenue] for [Campaign ID]) is missing) THEN (0) ELSE (Total([Gross Revenue] for [Campaign ID])) calculated/ total 
Budget Difference[Target Budget Costs]-[Committed Total]calculated 
Revenue Difference[Target Revenue]-[Gross Revenue-Campaign]calculated 
Actual ROI-OfferIF([Offer Fulfillment Cost]=0) THEN(0) ELSE(([Gross Revenue]-[Offer Fulfillment Cost])/([Offer Fulfillment Cost]))  
Actual ROI-CampaignIF([Committed Total]=0) THEN(0) ELSE(([Gross Revenue-Campaign]-[Committed Total])/([Committed Total]* 1.000)) calculated 
Target ROIIF ([Target Budget Costs]=0) THEN(0) ELSE(([Target Revenue]-[Target Budget Costs])/([Target Budget Costs] * 1.000)) calculated 
ROI Difference[Target ROI]-[Actual ROI-Campaign]calculated 
Channel1[Campaign Project by Offer].[Campaign Project by Offer].[Channel] 
Actual Costs-ChannelIF(total([Offer Fulfillment Cost] for [Channel1],[Campaign ID]) is missing) THEN (0) ELSE ( total([Offer Fulfillment Cost] for [Channel1],[Campaign ID]))  
Actual Revenue-ChannelIF (total([Gross Revenue] for [Channel1],[Campaign ID]) is missing) THEN (0) ELSE (total([Gross Revenue] for [Channel1],[Campaign ID]))  
Actual ROI-ChannelIF ([Actual Costs-Channel] is missing) THEN ([Actual Revenue-Channel]) ELSE ([Actual Revenue-Channel]-[Actual Costs-Channel])/([Actual Costs-Channel] * 1.000)  
Total Offer Fulfillment Cost for reportIF (total([Offer Fulfillment Cost] for report) is missing) THEN (0) ELSE (total([Offer Fulfillment Cost] for report)) total 
Total Gross Revenue for reportIF (total([Gross Revenue] for report) is missing) THEN (0) ELSE (total([Gross Revenue] for report))  
Campaign Project Select
(prompt)
Total: 2Filters:
[Campaign Custom Attributes].[Campaign].[Project ID] is NOT NULL
 
 
Campaign ID[Campaign Listing].[Campaign].[Campaign ID] 
Campaign Name[Campaign Listing].[Campaign].[Campaign Name]||' ('||[Campaign Listing].[Campaign].[Campaign Code]||')' 
Campaign Totals
Total: 6Filters:
[Campaign ID] in(?campaignprojectid?)
 
 
Campaign ID[Campaign Project by Offer].[Campaign Project].[Campaign ID] 
Project ID[Campaign Project by Offer].[Campaign Project].[Project ID] 
Project Total CostIF (total([Campaign Project by Offer].[Campaign Project].[Project Total Cost] for report) is missing) THEN (0) ELSE (total([Campaign Project by Offer].[Campaign Project].[Project Total Cost] for report)) total 
Project Total RevenueIF (total([Campaign Project by Offer].[Campaign Project].[Project Total Revenue] for report) is missing) THEN (0) ELSE (total([Campaign Project by Offer].[Campaign Project].[Project Total Revenue] for report)) total 
Budget TotalIF (total([Campaign Project by Offer].[Campaign Project].[Budget Total] for report) is missing) THEN (0) ELSE (total([Campaign Project by Offer].[Campaign Project].[Budget Total] for report)) total 
Committed TotalIF (total([Campaign Project by Offer].[Campaign Project].[Committed Total] for report) is missing) THEN (0) ELSE (total([Campaign Project by Offer].[Campaign Project].[Committed Total] for report)) total 
Final Report Query
(list)
Total: 35  
Campaign ID[Campaign Totals].[Campaign ID] 
Project URL[Report Query].[Project URL] 
Offer ID[Report Query].[Offer ID] 
OfferURL[Report Query].[OfferURL] 
Campaign Name[Report Query].[Campaign Name] 
Offer Name[Report Query].[Offer Name] 
Gross RevenueIF ([Report Query].[Gross Revenue] is missing) THEN (0) ELSE ([Report Query].[Gross Revenue])  
Offer Fulfillment CostIF ([Report Query].[Offer Fulfillment Cost] is missing) THEN (0) ELSE ([Report Query].[Offer Fulfillment Cost])  
Committed TotalIF ([Report Query].[Committed Total] =0) THEN (0) ELSE ([Report Query].[Committed Total])  
Budget Total[Report Query].[Budget Total] 
Target RevenueIF ([Report Query].[Target Revenue] is missing) THEN (0) ELSE ([Report Query].[Target Revenue])  
Project Variable Total Cost[Report Query].[Project Variable Total Cost] 
Target Budget CostsIF ([Report Query].[Target Budget Costs] is missing) THEN (0) ELSE ([Report Query].[Target Budget Costs])  
Total Offer Fulfillment Cost[Report Query].[Total Offer Fulfillment Cost] 
Gross Revenue-CampaignIF ([Report Query].[Gross Revenue-Campaign] is missing) THEN (0) ELSE ([Report Query].[Gross Revenue-Campaign])  
Budget DifferenceIF ([Report Query].[Budget Difference] is missing) THEN (0) ELSE ([Report Query].[Budget Difference])  
Revenue DifferenceIF ([Report Query].[Revenue Difference] is missing) THEN (0) ELSE ([Report Query].[Revenue Difference])  
Actual ROI-OfferIF ([Report Query].[Actual ROI-Offer] is missing) THEN (0) ELSE ([Report Query].[Actual ROI-Offer])  
Actual ROI-CampaignIF ([Report Query].[Actual ROI-Campaign] is missing) THEN (0) ELSE ([Report Query].[Actual ROI-Campaign])  
Target ROIIF ([Report Query].[Target ROI] is missing) THEN (0) ELSE ([Report Query].[Target ROI])  
ROI DifferenceIF ([Report Query].[ROI Difference] is missing) THEN (0) ELSE ([Report Query].[ROI Difference])  
Channel1[Report Query].[Channel1] 
Actual Costs-ChannelIF ([Report Query].[Actual Costs-Channel] is missing) THEN (0) ELSE ([Report Query].[Actual Costs-Channel])  
Actual Revenue-ChannelIF ([Report Query].[Actual Revenue-Channel] is missing) THEN (0) ELSE ([Report Query].[Actual Revenue-Channel])  
Actual ROI-ChannelIF ([Report Query].[Actual ROI-Channel] is missing) THEN (0) ELSE ([Report Query].[Actual ROI-Channel])  
Project Total Cost[Campaign Totals].[Project Total Cost] 
Total Budget for report[Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost] 
Total Committed for report[Campaign Totals].[Committed Total]+[Report Query].[Total Offer Fulfillment Cost for report] 
Total Budget Difference for report[Total Budget for report]-[Total Committed for report] 
Total Project Revenue for reportIF ([Campaign Totals].[Project Total Revenue] is missing) THEN (0) ELSE ([Campaign Totals].[Project Total Revenue])  
Total Gross Revenue for reportIF ([Report Query].[Total Gross Revenue for report] is missing) THEN (0) ELSE ([Report Query].[Total Gross Revenue for report])  
Total Revenue Difference for report[Total Project Revenue for report]-[Total Gross Revenue for report] 
Total Target ROI for reportIF (([Campaign Totals].[Project Total Revenue]-([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost]))/(([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost])*1.000) is missing) THEN(0) ELSE (([Campaign Totals].[Project Total Revenue]-([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost]))/(([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost])*1.000))  
Total Actual ROI for reportIF (([Report Query].[Total Gross Revenue for report]-([Campaign Totals].[Committed Total]+[Report Query].[Total Offer Fulfillment Cost for report]))/(([Campaign Totals].[Committed Total]+[Report Query].[Total Offer Fulfillment Cost for report])*1.000) is missing) THEN (0) ELSE (([Report Query].[Total Gross Revenue for report]-([Campaign Totals].[Committed Total]+[Report Query].[Total Offer Fulfillment Cost for report]))/(([Campaign Totals].[Committed Total]+[Report Query].[Total Offer Fulfillment Cost for report])*1.000))  
Total ROI Difference for reportIF (([Report Query].[Total Gross Revenue for report]-([Campaign Totals].[Committed Total]+[Report Query].[Total Offer Fulfillment Cost for report]))/(([Campaign Totals].[Committed Total]+[Report Query].[Total Offer Fulfillment Cost for report])*1.000) - ([Campaign Totals].[Project Total Revenue]-([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost]))/(([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost])*1.000) is missing) THEN (0) ELSE (([Report Query].[Total Gross Revenue for report]-([Campaign Totals].[Committed Total]+[Report Query].[Total Offer Fulfillment Cost for report]))/(([Campaign Totals].[Committed Total]+[Report Query].[Total Offer Fulfillment Cost for report])*1.000) - ([Campaign Totals].[Project Total Revenue]-([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost]))/(([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost])*1.000))  


Campaign Offer Financial Comparison
Description:A report of budget, revenue, and ROI information for each campaign and each offer within the campaign. 
# Queries:1
Layout:1 list(s)
Report Variables:Budget Difference (boolean): [Final Report Query].[Budget Difference] < 0
Revenue Difference (boolean): [Final Report Query].[Revenue Difference]>0
ROI Difference (boolean): [Final Report Query].[ROI Difference] > 0
Total Budget Difference (boolean): [Final Report Query].[Total Budget Difference for report]<0
Total Revenue Difference (boolean): [Final Report Query].[Total Revenue Difference for report]>0
Total ROI Difference (boolean): [Final Report Query].[Total ROI Difference for Report]>0
Report Language1 (locale): ReportLocale()
reports/Affinium Plan/Campaign Offer Financial Comparison.jpg
Query NameData ItemExpressionAgg/
Rollup Agg
Report Query
Total: 22Filters:
[Campaign Listing].[Campaign].[Campaign ID] in (?campaignprojectid?)
 
 
Campaign ID[Campaign Project by Offer].[Campaign Project by Offer].[Campaign ID] 
Offer ID[Campaign Project by Offer].[Campaign Project by Offer].[Offer ID] 
Project URL[Campaign Project by Offer].[Campaign Project by Offer].[Project URL] 
Campaign Name[Campaign Project by Offer].[Campaign Project by Offer].[Campaign Name]||' ('||[Campaign Project by Offer].[Campaign Project by Offer].[Campaign Code]||')' 
Offer Name[Campaign Project by Offer].[Campaign Project by Offer].[Offer Name]||' ('||[Campaign Project by Offer].[Campaign Project by Offer].[Offer Code1]||')' 
OfferURL[Campaign Project by Offer].[Campaign Project by Offer].[OfferURL] 
Gross RevenueIF ([Campaign Project by Offer].[Campaign Project by Offer].[Gross Revenue] is missing) THEN (0) ELSE ([Campaign Project by Offer].[Campaign Project by Offer].[Gross Revenue]) total 
Offer Fulfillment CostIF ([Campaign Project by Offer].[Campaign Project by Offer].[Offer Fulfillment Cost] is missing) THEN (0) ELSE ([Campaign Project by Offer].[Campaign Project by Offer].[Offer Fulfillment Cost]) total 
Committed TotalIF ([Campaign Project by Offer].[Campaign Project by Offer].[Committed Total] + (Total([Offer Fulfillment Cost] for [Campaign ID])) is missing) THEN (0) ELSE ([Campaign Project by Offer].[Campaign Project by Offer].[Committed Total] + (Total([Offer Fulfillment Cost] for [Campaign ID]))) total 
Budget TotalIF ([Campaign Project by Offer].[Campaign Project by Offer].[Budget Total] is missing)THEN (0) ELSE ([Campaign Project by Offer].[Campaign Project by Offer].[Budget Total])  
Target Revenue[Campaign Project by Offer].[Campaign Project by Offer].[Project Total Revenue] 
Project Variable Total Cost[Campaign Project by Offer].[Campaign Project by Offer].[Project Total Cost] 
Target Budget Costs[Budget Total] + [Project Variable Total Cost]calculated 
Gross Revenue-CampaignIF (Total([Gross Revenue] for [Campaign ID]) is missing) THEN (0) ELSE (Total([Gross Revenue] for [Campaign ID])) calculated/ total 
Budget Difference[Target Budget Costs]-[Committed Total]calculated 
Revenue Difference[Target Revenue]-[Gross Revenue-Campaign]calculated 
Actual ROI-OfferIF([Offer Fulfillment Cost]=0) THEN(0) ELSE(([Gross Revenue]-[Offer Fulfillment Cost])/([Offer Fulfillment Cost] * 1.000))  
Actual ROI-CampaignIF([Committed Total]=0) THEN(0) ELSE(([Gross Revenue-Campaign]-[Committed Total])/([Committed Total] * 1.000)) calculated 
Target ROIIF([Target Budget Costs] = 0) THEN(0) ELSE(([Target Revenue]-[Target Budget Costs])/([Target Budget Costs] *1.000)) calculated 
ROI Difference[Target ROI]-[Actual ROI-Campaign]calculated 
Offer Fulfillment for ReportIF (total([Offer Fulfillment Cost] for report) is missing) THEN (0) ELSE (total([Offer Fulfillment Cost] for report))  
Total Gross Revenue for Reporttotal([Gross Revenue] for report) 
Campaign Totals
Total: 7Filters:
[Campaign ID] in (?campaignprojectid?)
 
 
Committed TotalIF (total([Campaign Project by Offer].[Campaign Project].[Committed Total] for report) is missing) THEN (0) ELSE (total([Campaign Project by Offer].[Campaign Project].[Committed Total] for report)) total 
Budget TotalIF (total([Campaign Project by Offer].[Campaign Project].[Budget Total] for report) is missing) THEN (0) ELSE (total([Campaign Project by Offer].[Campaign Project].[Budget Total] for report)) total 
Project Total RevenueIF (total([Campaign Project by Offer].[Campaign Project].[Project Total Revenue] for report) is missing) THEN (0) ELSE (total([Campaign Project by Offer].[Campaign Project].[Project Total Revenue] for report)) total 
Project Total CostIF (total([Campaign Project by Offer].[Campaign Project].[Project Total Cost] for report) is missing) THEN (0) ELSE (total([Campaign Project by Offer].[Campaign Project].[Project Total Cost] for report)) total 
Project ID[Campaign Project by Offer].[Campaign Project].[Project ID] 
Campaign ID[Campaign Project by Offer].[Campaign Project].[Campaign ID] 
Total Budget Difference for reportIF (total([Campaign Project by Offer].[Campaign Project].[Committed Total] for report) is missing) THEN (0) ELSE (total([Campaign Project by Offer].[Campaign Project].[Committed Total] for report))  
Campaign Project Select
(prompt)
Total: 2Filters:
[Campaign Listing].[Campaign].[Project ID] is NOT NULL
 
 
Campaign ID[Campaign Listing].[Campaign].[Campaign ID] 
Campaign Name[Campaign Listing].[Campaign].[Campaign Name]||' ('||[Campaign Listing].[Campaign].[Campaign Code]||')' 
Final Report Query
(list)
Total: 28  
Campaign ID[Campaign Totals].[Campaign ID] 
Campaign Name[Report Query].[Campaign Name] 
Project URL[Report Query].[Project URL] 
Offer ID[Report Query].[Offer ID] 
Offer Name[Report Query].[Offer Name] 
OfferURL[Report Query].[OfferURL] 
Offer Fulfillment CostIF ([Report Query].[Offer Fulfillment Cost] is missing) THEN (0) ELSE ([Report Query].[Offer Fulfillment Cost])  
Committed TotalIF ([Report Query].[Committed Total] is missing) THEN (0) ELSE ([Report Query].[Committed Total])  
Target Budget CostsIF ([Report Query].[Target Budget Costs] is missing) THEN (0) ELSE ([Report Query].[Target Budget Costs])  
Budget DifferenceIF ([Report Query].[Budget Difference] is missing) THEN (0) ELSE ([Report Query].[Budget Difference])  
Gross RevenueIF ([Report Query].[Gross Revenue] is missing) THEN (0) ELSE ([Report Query].[Gross Revenue])  
Gross Revenue-CampaignIF ([Report Query].[Gross Revenue-Campaign] is missing) THEN (0) ELSE ([Report Query].[Gross Revenue-Campaign])  
Target RevenueIF ([Report Query].[Target Revenue] is missing) THEN (0) ELSE ([Report Query].[Target Revenue])  
Revenue DifferenceIF ([Report Query].[Revenue Difference] is missing) THEN (0) ELSE ([Report Query].[Revenue Difference])  
Target ROIIF ([Report Query].[Target ROI] is missing) THEN (0) ELSE ([Report Query].[Target ROI])  
Actual ROI-OfferIF ([Report Query].[Actual ROI-Offer] is missing) THEN (0) ELSE ([Report Query].[Actual ROI-Offer])  
Actual ROI-CampaignIF ([Report Query].[Actual ROI-Campaign] is missing) THEN (0) ELSE ([Report Query].[Actual ROI-Campaign])  
ROI DifferenceIF ([Report Query].[ROI Difference] is missing) THEN (0) ELSE ([Report Query].[ROI Difference])  
Budget Total for Report[Campaign Totals].[Budget Total] 
Total Actual Budget for Report[Campaign Totals].[Committed Total] + [Report Query].[Offer Fulfillment for Report] 
Total Target Budget for report[Campaign Totals].[Project Total Cost] + [Campaign Totals].[Budget Total] 
Total Target Revenue for Report[Campaign Totals].[Project Total Revenue] 
Total Budget Difference for report([Campaign Totals].[Budget Total] + [Campaign Totals].[Project Total Cost])-([Campaign Totals].[Total Budget Difference for report] + [Report Query].[Offer Fulfillment for Report]) 
Total Gross Revenue for Report[Report Query].[Total Gross Revenue for Report] 
Total Revenue Difference for report[Campaign Totals].[Project Total Revenue]-[Report Query].[Total Gross Revenue for Report] 
Total Target ROI for report([Campaign Totals].[Project Total Revenue]-([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost]))/(([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost])*1.000) 
Total Actual ROI for report([Report Query].[Total Gross Revenue for Report]-([Report Query].[Offer Fulfillment for Report]+[Campaign Totals].[Committed Total]))/([Report Query].[Offer Fulfillment for Report]+[Campaign Totals].[Committed Total]) 
Total ROI Difference for Report([Report Query].[Total Gross Revenue for Report]-([Report Query].[Offer Fulfillment for Report]+[Campaign Totals].[Committed Total]))/(([Report Query].[Offer Fulfillment for Report]+[Campaign Totals].[Committed Total])*1.000) - ([Campaign Totals].[Project Total Revenue]-([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost]))/(([Campaign Totals].[Budget Total]+[Campaign Totals].[Project Total Cost])*1.000) 


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.