"What If" Offer Financial Summary | |
---|---|
Description: | |
# 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: | |
# Queries: | 1 |
Layout: | 1 list(s) |
Report Variables: | Report Language1
(locale):
ReportLocale() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 33 | Filters:
[Campaign Offer Detailed Response Breakout].[CampToOffer].[Campaign ID] =?CampaignIds? | |
Campaign ID | [Campaign Offer Detailed Response Breakout].[Campaign].[Campaign ID] | ||
Campaign Name | [Campaign Offer Detailed Response Breakout].[Campaign].[Campaign Name]||' ('||[Campaign Offer Detailed Response Breakout].[Campaign].[Campaign Code]||')' | ||
Offer Name | [Campaign Offer Detailed Response Breakout].[Offer].[Offer Name]||' ('||[Campaign Offer Detailed Response Breakout].[Offer].[Offer Code1]||')' | ||
Number of Offers Given | [Campaign Offer Detailed Response Breakout].[Campaign Offer Contact History Summary].[Number of Offers Given] | total | |
Unique Recipients | [Campaign Offer Detailed Response Breakout].[Campaign Offer Contact History Summary].[Unique Recipients] | total | |
Response Transactions | [Campaign Offer Detailed Response Breakout].[Campaign Offer Response History Summary].[Response Transactions] | total | |
Unique Responders | [Campaign Offer Detailed Response Breakout].[Campaign Offer Response History Summary].[Unique Responders] | total | |
Explore Count | [Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Explore Count] | total | |
Consider Count | [Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Consider Count] | total | |
Commit Count | [Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Commit Count] | total | |
Fulfill Count | [Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Fulfill Count] | total | |
Usage Count | [Campaign Offer Detailed Response Breakout].[Campaign Offer Response Breakout].[Usage Count] | total | |
Number of Offers Given-Campaign | [Campaign Offer Detailed Response Breakout].[Campaign Contact History Summary].[Number of Offers Given] | ||
Response Transactions-Campaign | [Campaign Offer Detailed Response Breakout].[Campaign Response History Summary].[Response Transactions] | ||
Explore Count-Campaign | [Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Explore Count] | ||
Consider Count- Campaign | [Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Consider Count] | ||
Commit Count-Campaign | [Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Commit Count] | ||
Fulfill Count-Campaign | [Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Fulfill Count] | ||
Usage Count-Campaign | [Campaign Offer Detailed Response Breakout].[Campaign Response Breakout].[Usage Count] | ||
Unique Recipients-Campaign | [Campaign Offer Detailed Response Breakout].[Campaign Contact History Summary].[Unique Recipients] | ||
Unique Responders-Campaign | [Campaign Offer Detailed Response Breakout].[Campaign Response History Summary].[Unique Responders] | ||
Response 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))) | ||
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 Financial Summary by Offer (Actual) | |
---|---|
Description: | |
# Queries: | 1 |
Layout: | 1 list(s) |
Report Variables: | Report Language1
(locale):
ReportLocale() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 38 | Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] = ?CampaignIds? | |
Campaign Name | [Campaign Custom Attributes].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' | ||
Offer Name | [Campaign Custom Attributes].[Offer].[Offer Name]||' ('||[Campaign Custom Attributes].[Offer].[Offer Code1]||')' | ||
Number of Offers Given | [Campaign Performance Summary].[Campaign Offer Contact History Summary].[Number of Offers Given] | total | |
Response Transactions | [Campaign Performance Summary].[Campaign Offer Response History Summary].[Response Transactions] | total | |
Response Transactions-Campaign | [Campaign Performance Summary].[Campaign Response History Summary].[Response Transactions] | total | |
Response 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]) |
Campaign Offer Performance by Month | |
---|---|
Description: | |
# 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] = ?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 Summary by Cell | |
---|---|
Description: | |
# Queries: | 1 |
Layout: | 1 list(s) |
Report Variables: | Hide_Show_Lift
(boolean):
(IF ((ParamValue("Hide_Show_Lift") IS MISSING) OR (ParamValue("Hide_Show_Lift") IS NULL)) THEN '' ELSE ParamValue("Hide_Show_Lift")) = 'Hide' Report Language1 (locale): ReportLocale() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 23 | 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) | ||
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) |
Campaign Performance Summary by Cell (with Revenue) | |
---|---|
Description: | |
# Queries: | 1 |
Layout: | 1 list(s) |
Report Variables: | Hide_Show_Lift_Columns
(boolean):
(IF ((ParamValue("Hide_Show_Lift_Columns") IS MISSING) OR (ParamValue("Hide_Show_Lift_Columns") IS NULL)) THEN '' ELSE ParamValue("Hide_Show_Lift_Columns")) = 'Hide' Report Language1 (locale): ReportLocale() |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 31 | 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) |
Campaign Performance Summary by Offer | |
---|---|
Description: | |
# Queries: | 1 |
Layout: | 1 list(s) |
Report Variables: | Hide_Show_Lift
(boolean):
(IF ((ParamValue('Hide_Show_Lift') IS MISSING) OR (ParamValue('Hide_Show_Lift') IS NULL)) THEN '' ELSE ParamValue('Hide_Show_Lift')) = 'Hide' Report Language1 (locale): ReportLocale() zero_ResponderRate (string): CASE WHEN ([Report Query].[Responder Rate] is missing OR [Report Query].[Responder Rate] =0) THEN ('ZERO_BEST_LIFT') END zero_MinResponderRate (string): CASE WHEN ([Report Query].[Min. Offer Responder Rate] is missing OR [Report Query].[Min. Offer Responder Rate] =0) THEN ('ZERO_WORST_LIFT') END |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 32 | Filters:
[Campaign Performance Summary].[Campaign].[Campaign ID] = ?CampaignIds? | |
Campaign Name | [Campaign Performance Summary].[Campaign].[Campaign Name]||' ('||[Campaign Performance Summary].[Campaign].[Campaign Code]||')' | ||
Campaign ID | [Campaign Performance Summary].[Campaign].[Campaign ID] | ||
Offer Name | [Campaign Performance Summary].[Offer].[Offer Name]||' ('||[Campaign Performance Summary].[Offer].[Offer Code1]||')' | ||
Number of Offers Given | [Campaign Performance Summary].[Campaign Offer Contact History Summary].[Number of Offers Given] | total/ total | |
Unique Recipients | [Campaign Performance Summary].[Campaign Offer Contact History Summary].[Unique Recipients] | total | |
Response Transactions | [Campaign Performance Summary].[Campaign Offer Response History Summary].[Response Transactions] | total | |
Unique Responders | [Campaign Performance Summary].[Campaign Offer Response History Summary].[Unique Responders] | total | |
Not Contacted Responders | [Campaign Performance Summary].[Campaign Offer Response History Summary].[Not Contacted Responders] | total | |
Responses After Expiration | [Campaign Performance Summary].[Campaign Offer Response History Summary].[Responses After Expiration] | total | |
Response 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) | ||
Not Applilcable Calc | [Campaign Listing].[Campaign].[Not Applilcable Calc] |
Offer Performance by Day | |
---|---|
Description: | |
# Queries: | 1 |
Layout: | 1 crosstabs(s) |
Report Variables: | Report Language1
(locale):
ReportLocale() |
![]() |
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] =?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 Summary by Campaign | |
---|---|
Description: | |
# Queries: | 1 |
Layout: | 1 list(s) |
Report Variables: | Hide_Show_Lift
(boolean):
(IF ((ParamValue('Hide_Show_Lift') IS MISSING) OR (ParamValue('Hide_Show_Lift') IS NULL)) THEN '' ELSE ParamValue('Hide_Show_Lift')) = 'Hide' Report Language1 (locale): ReportLocale() zero_ResponderRate (string): CASE WHEN ([Report Query].[Responder Rate] is missing or [Report Query].[Responder Rate]=0) THEN ('ZERO_BEST_LIFT') END zero_MinResponderRate (string): CASE WHEN ([Report Query].[Min Offer Responder Rate] is missing OR [Report Query].[Min Offer Responder Rate]=0) THEN ('ZERO_WORST_LIFT') END |
![]() |
Query Name | Data Item | Expression | Agg/ Rollup Agg |
---|---|---|---|
Report Query
(list) | Total: 32 | 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) | ||
Not Applilcable Calc | [Campaign Listing].[Campaign].[Not Applilcable Calc] |
Copyright© Copyright Unica Corporation 2003 - 2010. All rights reserved.
Unica Corporation
Reservoir Place North
170 Tracer Lane
Waltham, MA 02451-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.