"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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Base Query
(crosstab) | Total: 15 | Filters:
[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 Contact | CASE ?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 Cost | CASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) END | total | |
Revenue Per Response | CASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) END | total | |
Gross Revenue | [Response Transactions]*[Revenue Per Response] | total | |
Contact Cost | ([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] | ||
Cost Per Responder | IF ([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 Response | IF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions]) | total | |
Return On Investment | IF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost]) | total | |
Base Query Plus Increment1
(crosstab) | Total: 15 | Filters:
[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 Contact | CASE ?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 Cost | CASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) END | total | |
Revenue Per Response | CASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) END | total | |
Gross Revenue | [Response Transactions]*[Revenue Per Response] | total | |
Contact Cost | ([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] | ||
Cost Per Responder | IF ([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 Response | IF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions]) | total | |
Return On Investment | IF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost]) | total | |
Base Query Plus Increment2
(crosstab) | Total: 15 | Filters:
[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 Contact | CASE ?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 Cost | CASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) END | total | |
Revenue Per Response | CASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) END | total | |
Gross Revenue | [Response Transactions]*[Revenue Per Response] | total | |
Contact Cost | ([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] | ||
Cost Per Responder | IF ([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 Response | IF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions]) | total | |
Return On Investment | IF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost]) | total | |
Base Query Plus Increment3
(crosstab) | Total: 15 | Filters:
[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 Contact | CASE ?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 Cost | CASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) END | total | |
Revenue Per Response | CASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) END | total | |
Gross Revenue | [Response Transactions]*[Revenue Per Response] | total | |
Contact Cost | ([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] | ||
Cost Per Responder | IF ([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 Response | IF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions]) | total | |
Return On Investment | IF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost]) | total | |
Base Query Plus Increment4
(crosstab) | Total: 15 | Filters:
[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 Contact | CASE ?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 Cost | CASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) END | total | |
Revenue Per Response | CASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) END | total | |
Gross Revenue | [Response Transactions]*[Revenue Per Response] | total | |
Contact Cost | ([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] | ||
Cost Per Responder | IF ([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 Response | IF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions]) | total | |
Return On Investment | IF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost]) | total | |
Base Query Plus Increment5
(crosstab) | Total: 15 | Filters:
[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 Contact | CASE ?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 Cost | CASE ?Offer_Fixed_Cost? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fixed Cost], float) ELSE (cast(cast(?Offer_Fixed_Cost?, int), float)) END | total | |
Revenue Per Response | CASE ?Revenue_Per_Response? WHEN '-' THEN cast([Campaign Custom Attributes].[Offer Custom Attributes].[Revenue Per Response], float) ELSE (cast(cast(?Revenue_Per_Response?, int), float)) END | total | |
Gross Revenue | [Response Transactions]*[Revenue Per Response] | total | |
Contact Cost | ([Cost Per Contact] * [Number of Offers Given])+ [Offer Fixed Cost] | ||
Cost Per Responder | IF ([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 Response | IF ([Net Profit]/[Response Transactions] is missing) THEN (0) ELSE ([Net Profit]/[Response Transactions]) | total | |
Return On Investment | IF ([Net Profit]/[Contact Cost] is missing) THEN (0) ELSE ([Net Profit]/[Contact Cost]) | total | |
Offer Name Query
| Total: 2 | Filters:
[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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 47 | Filters:
[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 Rate | IF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given]* 1.00))) | ||
Response Rate-Campaign | IF(([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-Campaign | IF(([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-Campaign | IF(([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-Campaign | IF(([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-Campaign | IF(([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-Campaign | IF(([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 Rate | IF(([Commit Count]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Commit Count]/([Number of Offers Given]* 1.00))) | ||
Consider Response Rate | IF(([Consider Count]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Consider Count]/([Number of Offers Given]* 1.00))) | ||
Explore Response Rate | IF(([Explore Count]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Explore Count]/([Number of Offers Given]* 1.00))) | ||
Fulfill Response Rate | IF(([Fulfill Count]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Fulfill Count]/([Number of Offers Given]* 1.00))) | ||
Usage Response Rate | IF(([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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 50 | Filters:
[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 Rate | IF([Response Transactions]/([Number of Offers Given] *1.00) is missing) THEN(0) ELSE([Response Transactions]/([Number of Offers Given] * 1.00)) | ||
Response Rate-Campaign | IF([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 Cost | IF ([Cost Per Contact] is missing) THEN ([Offer Fixed Cost]) ELSE(([Cost Per Contact]*[Number of Offers Given]) + [Offer Fixed Cost]) | total | |
Contact Cost - Campaign | total([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 Revenue | IF([Gross Revenue] is missing) THEN(0-[Contact Cost]) ELSE([Gross Revenue]-[Contact Cost]) | ||
Net Revenue-Campaign | IF([Gross Revenue - Campaign] is missing) THEN(0-[Contact Cost - Campaign]) ELSE([Gross Revenue - Campaign]-[Contact Cost - Campaign]) | ||
Net Profit | IF([Response Transactions] is missing) THEN([Net Revenue]) ELSE([Net Revenue]-([Campaign Custom Attributes].[Offer Custom Attributes].[Offer Fulfillment Cost] * [Response Transactions])) | ||
Net Profit-Campaign | if ([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 Response | IF([Net Profit]/[Response Transactions] is missing) THEN(0) ELSE([Net Profit]/[Response Transactions]) | ||
Revenue Margin Per Response - Campaign | IF([Net Profit-Campaign]/[Response Transactions-Campaign] is missing) THEN(0) ELSE([Net Profit-Campaign]/[Response Transactions-Campaign]) | ||
Return on Investment | IF([Net Profit]/[Contact Cost] is missing) THEN(0) ELSE([Net Profit]/[Contact Cost]) | ||
Return On Investment-Campaign | IF([Net Profit-Campaign]/[Contact Cost - Campaign] is missing) THEN(0) ELSE([Net Profit-Campaign]/[Contact Cost - Campaign]) | ||
Gross Revenue Control Group | IF([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 - Campaign | IF([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 - Campaign | total([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) - Campaign | IF([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 ROI | IF ([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 - Campaign | IF ([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 Given | total([Number of Offers Given - Campaign] for report) | ||
Total Response Transactions | IF([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 Response | total([Revenue Per Response- Campaign] for report) | ||
Total Gross Revenue | total([Gross Revenue - Campaign] for report) | ||
Total Net Revenue | IF([Total Gross Revenue] is missing) THEN(0-[Total Contact Cost]) ELSE([Total Gross Revenue]-[Total Contact Cost]) | ||
Total Net Profit | IF(total( [Net Profit] for report) is missing) THEN(0) ELSE(total( [Net Profit] for report)) | ||
Total Contact Cost | total([Contact Cost] for report) | ||
Total Return On Investment | IF([Total Net Profit]/[Total Contact Cost] is missing) THEN(0) ELSE([Total Net Profit]/[Total Contact Cost]) | ||
Total Revenue Margin Per Response | maximum([Total Net Profit]/([Total Response Transactions] *1.00)) | ||
Total Baseline Net Profit (Control) | total([Baseline Net Profit (Control)] for report) | ||
Total Incremental ROI | IF(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: 13 | Filters:
[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 Transactions | IF ([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-Campaign | IF ([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 - Campaign | total([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-Campaign | IF([Gross Revenue - Campaign] is missing) THEN(0-[Contact Cost - Campaign]) ELSE([Gross Revenue - Campaign]-[Contact Cost - Campaign]) | ||
Net Profit-Campaign | if ([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-Campaign | IF([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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(crosstab) | Total: 11 | Filters:
[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 Rate | IF([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 Given | total([Number of Offers] within set [Month]) | ||
Total Response Transactions | total([Response Transactions] within set [Month]) | ||
Total Response Rate | IF ([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 |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 20 | Filters:
[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 Recipients | total([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 Rate | IF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders]/([Unique Recipients] * 1.00))) | ||
Response Rate | IF(([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 | total([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 Group | IF ([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 Group | IF(([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 report | total([Response Transactions] for report)/(total([Number of Offers Given] for report) * 1.00) | ||
Max. Responder Rate | maximum([Responder Rate] for report) | ||
Best Offer Lift Over This | IF (([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 Rate | minimum([Responder Rate] for report) | ||
Lift Over Worst Offer | IF(([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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 17 | Filters:
[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 Rate | IF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders]/([Unique Recipients] * 1.00))) | ||
Response Rate | IF(([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 Group | IF ([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 Group | IF(([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 report | total([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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 30 | Filters:
[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 Rate | IF(([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 Rate | IF(([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 Group | IF ([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 Group | IF(([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 Offers | total([Number of Offers Given] for report) | / automatic | |
Total Response Transactions | total([Response Transactions] for report) | / automatic | |
Total Response Rate | [Total Response Transactions]/[Total Number of Offers] | / automatic | |
Number of Offers Given-Initiative | total ([Number of Offers Given] for [Initiative]) | ||
Response Transactions-Initiative | total ([Response Transactions] for [Initiative]) | ||
Response Rate-Initiative | IF((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-Initiative | total ([Unique Recipients] for [Initiative]) | ||
Unique Responders-Initiative | total ([Unique Responders] for [Initiative]) | ||
Not Contacted Responders-Initiative | total ([Not Contacted Responders] for [Initiative]) | ||
Responses After Expiration-Initiative | total ([Responses After Expiration] for [Initiative]) | ||
Responder Rate-Initiative | IF( (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-Initiative | total ([Unique Recipients Control Group] for [Initiative]) | ||
Unique Responders Control Group-Initiative | total ([Unique Responders Control Group] for [Initiative]) | ||
Responder Rate Control Group-Initiative | IF( (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-Initiative | IF(([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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 27 | Filters:
[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 Rate | IF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given] * 1.00))) | ||
Responder Rate | IF(([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 Group | IF([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 Group | IF(([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 Given | total([Number of Offers Given - Campaign] for report) | ||
Total Response Transactions | total([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-Campaign | IF([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-Campaign | IF(([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: 5 | Filters:
[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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 32 | Filters:
[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 Rate | IF(([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 Rate | IF(([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 Group | maximum([Unique Recipients Control Group] for [Campaign Name]) | maximum | |
Max. Unique Responders Control Group | maximum([Unique Responders Control Group] for [Campaign Name]) | maximum | |
Responder Rate Control Group | IF([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 Group | IF(([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 - Campaign | IF([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 - Campaign | IF(([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 Given | total([Number of Offers Given - Campaign] for report) | automatic/ automatic | |
Total Response Transactions | total([Response Transactions - Campaign] for report) | / automatic | |
Total Response Rate | [Total Response Transactions]/([Total Number of Offers Given] * 1.00) | / automatic | |
Gross Revenue | IF ([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 Revenue | total([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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Main Report Query
(list) | Total: 38 | Filters:
[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 Rate | IF(([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 Rate | IF(([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 Group | IF([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 Group | IF(([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 - Campaign | IF([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 - Campaign | IF((([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 - Initiative | total([Number of Offers Given-Campaign] for [Initiative]) | / automatic | |
Response Transactions - Initiative | total([Response Transactions-Campaign] for [Initiative]) | / automatic | |
Response Rate - Initiative | [Response Transactions - Initiative]/([Number of Offers - Initiative] * 1.00) | / automatic | |
Unique Recipients - Initiative | total([Unique Recipients-Campaign] for [Initiative]) | / automatic | |
Unique Responders - Initiative | total([Unique Responders-Campaign] for [Initiative]) | / automatic | |
Responder Rate - Initiative | [Unique Responders - Initiative]/([Unique Recipients - Initiative] * 1.00) | / automatic | |
Unique Recipients Control Group - Initiative | total([Unique Recipients Control Group-Campaign] for [Initiative]) | / automatic | |
Unique Responders Control Group - Initiative | total([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 Offers | total([Number of Offers - Initiative] for report) | / automatic | |
Total Response Transactions | total([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 |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 37 | Filters:
[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 Rate | IF(([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN(0) ELSE(([Response Transactions]/([Number of Offers Given] * 1.00))) | ||
Responder Rate | IF(([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN(0) ELSE(([Unique Responders]/([Unique Recipients]* 1.00))) | ||
Max. Offer Responder Rate | maximum([Responder Rate] for [Campaign Performance Summary].[Campaign].[Campaign ID]) | ||
Best Offer Lift Over This | IF (([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 Rate | minimum([Responder Rate] for [Campaign ID]) | ||
Lift Over Worst Offer | IF(([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 Group | IF([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 Group | IF(([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 | IF(([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-Campaign | IF(([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 - Campaign | IF ([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-Campaign | IF(([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 report | total([Number Of Offers Given - Campaign] for report) | ||
Total Response Transactions for report | total([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 report | total([Not Contacted Responders - Campaign] for report) | ||
Total Responses After Expiration for report | total([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 |
![]() |
Query Name | Data Item | Expression | Agg/ 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: 41 | Filters:
[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 Rate | IF(([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 Rate | IF(([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 Group | IF([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 Rate | maximum([Responder Rate] for [Campaign ID]) | ||
Best Offer Lift Over This | IF (([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 Rate | minimum([Responder Rate] for [Campaign ID]) | ||
Lift Over Worst Offer | IF(([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 Group | IF(([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 Revenue | IF (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 - Campaign | IF(([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 - Campaign | IF(([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 - Campaign | IF ([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 - Campaign | IF(([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 Offers | total([Number of Offers Given - Campaign] for report) | / automatic | |
Total Response Transactions | total([Response Transactions - Campaign] for report) | / automatic | |
Total Response Rate | [Total Response Transactions]/[Total Number of Offers] | / automatic | |
Total Not Contacted Responders | total([Not Contacted Responders - Campaign] for report) | / automatic | |
Total Responses After Expiration | total([Responses After Expiration - Campaign] for report) | / automatic | |
Total Gross Revenue | total([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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Query1
(list) | Total: 9 | Filters:
[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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 10 | Filters:
[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() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(crosstab) | Total: 8 | Filters:
[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 Date | cast([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 Rate | IF(([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 |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 23 | Filters:
[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 Rate | IF (([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN (0) ELSE (([Response Transactions]/([Number of Offers Given] * 1.00))) | ||
Responder Rate | IF (([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 Group | IF ([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 Group | IF (([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 report | total([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 Rate | maximum([Responder Rate] for report) | ||
Best Offer Lift Over This | IF (([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 Rate | minimum([Responder Rate] for report) | ||
Lift Over Worst Offer | IF (([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() |
![]() |
Query Name | Data Item | Expression | Agg/ 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: 22 | Filters:
[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 Rate | IF (([Best Match]/([Number of Offers Given] * 1.00)) is missing) THEN (0) ELSE (([Best Match]/([Number of Offers Given] * 1.00))) | ||
Fractional Match Response Rate | IF (([Fractional Match]/([Number of Offers Given] * 1.00)) is missing) THEN (0) ELSE (([Fractional Match]/([Number of Offers Given] * 1.00))) | ||
Multiple Match Response Rate | IF (([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 Group | if ( ( ([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 Fractional | IF ( (([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 Multiple | IF ( (([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 Multiple | IF ((([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 Rate | if (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 Rate | if (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 Rate | if (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 Fractional | if (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 Multiple | if (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 Multiple | if (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 Match | IF ([Offer Performance Summary].[Offer Performance Metrics Summary].[Best Match] =0) THEN (0) ELSE ([Offer Performance Summary].[Offer Performance Metrics Summary].[Best Match]) | total | |
Fractional Match | IF ([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 |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 37 | Filters:
[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 Rate | IF (([Response Transactions]/([Number of Offers Given] * 1.00)) is missing) THEN (0) ELSE (([Response Transactions]/([Number of Offers Given]*1.00))) | ||
Responder Rate | IF (([Unique Responders]/([Unique Recipients] * 1.00)) is missing) THEN (0) ELSE (([Unique Responders]/([Unique Recipients]*1.00))) | ||
Max Offer Responder Rate | maximum([Responder Rate] for [Offer ID]) | ||
Best Offer Lift Over This | IF (([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 Rate | minimum([Responder Rate] for [Offer ID]) | ||
Lift Over Worst Offer | IF (([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 Group | IF ([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 Group | IF (([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-Offer | IF (([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 - Offer | IF (([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-Offer | IF ([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-Offer | IF (([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 report | total ([Number of Offers Given-Offer]for report) | ||
Total Response Transactions for report | total ([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 report | total ([Not Contacted Responders-Offer] for report) | ||
Total Responses After Expiration for report | total ([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-1379Examples and DataAll 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 PatentsUnica®, 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.