Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Performance Day | Campaign Contact History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CCH_DY].[ACTUALDATE] |
Number of Offers Given | float64 | fact | total([CampaignDS].[UARC_CCH_DY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) |
Number of Offers Given Control Group | float64 | fact | total([CampaignDS].[UARC_CCH_DY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) |
Unique Recipients | float64 | fact | total([CampaignDS].[UARC_CCH_DY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) |
Unique Recipients Control Group | float64 | fact | total([CampaignDS].[UARC_CCH_DY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) |
Number of Offer Versions | float64 | fact | total([CampaignDS].[UARC_CCH_DY].[NUM_OFF_VERS] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) |
Number of Offer Versions Control Group | float64 | fact | total([CampaignDS].[UARC_CCH_DY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) |
Campaign Offer Contact History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_COCH_DY].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_COCH_DY].[OFFERID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_COCH_DY].[ACTUALDATE] |
Number of Offers Given | float64 | fact | total ([CampaignDS].[UARC_COCH_DY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_COCH_DY].[CAMPAIGNID],[CampaignDS].[UARC_COCH_DY].[OFFERID] ,[CampaignDS].[UARC_COCH_DY].[ACTUALDATE] ) |
Number of Offers Given Control Group | float64 | fact | total ([CampaignDS].[UARC_COCH_DY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_COCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_DY].[OFFERID] ,[CampaignDS].[UARC_COCH_DY].[ACTUALDATE] ) |
Unique Recipients | float64 | fact | total ([CampaignDS].[UARC_COCH_DY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_COCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_DY].[OFFERID] ,[CampaignDS].[UARC_COCH_DY].[ACTUALDATE] ) |
Unique Recipients Control Group | float64 | fact | total ([CampaignDS].[UARC_COCH_DY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_COCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_DY].[OFFERID] ,[CampaignDS].[UARC_COCH_DY].[ACTUALDATE] ) |
Number of Offer Versions | float64 | fact | total ([CampaignDS].[UARC_COCH_DY].[NUM_OFF_VERS] for [CampaignDS].[UARC_COCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_DY].[OFFERID] ,[CampaignDS].[UARC_COCH_DY].[ACTUALDATE] ) |
Number of Offer Versions Control Group | float64 | fact | total ([CampaignDS].[UARC_COCH_DY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_COCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_DY].[OFFERID] ,[CampaignDS].[UARC_COCH_DY].[ACTUALDATE] ) |
Campaign Cell Contact History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCCH_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCCH_DY].[CELLID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CCCH_DY].[ACTUALDATE] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[NUM_OFF_VERS_CG] |
Campaign Response History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CRH_DY].[CAMPAIGNID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CRH_DY].[ACTUALDATE] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CRH_DY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CRH_DY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CRH_DY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CRH_DY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CRH_DY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CRH_DY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CRH_DY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CRH_DY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_DY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CRH_DY].[REV_PER_RESP_CG] is missing)
THEN (0)
ELSE ([CampaignDS].[UARC_CRH_DY].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE ([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE_CG] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE_CG]) |
Campaign Offer Response History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CORH_DY].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_CORH_DY].[OFFERID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CORH_DY].[ACTUALDATE] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CORH_DY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CORH_DY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CORH_DY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CORH_DY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CORH_DY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CORH_DY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CORH_DY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CORH_DY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_DY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CORH_DY].[REV_PER_RESP_CG] IS MISSING)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_DY].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE_CG]) |
Campaign Cell Response History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCRH_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCRH_DY].[CELLID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CCRH_DY].[ACTUALDATE] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CCRH_DY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_DY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CCRH_DY].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_DY].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE_CG] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE_CG]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Performance by Day Star Schema
 | Campaign Contact History by Day | | (shortcut) | | [Model View].[Campaign Contact History by Day] |
Campaign Offer Contact History by Day | | (shortcut) | | [Model View].[Campaign Offer Contact History by Day] |
Campaign Cell Contact History by Day | | (shortcut) | | [Model View].[Campaign Cell Contact History by Day] |
Campaign Response History by Day | | (shortcut) | | [Model View].[Campaign Response History by Day] |
Campaign Offer Response History by Day | | (shortcut) | | [Model View].[Campaign Offer Response History by Day] |
Campaign Cell Response History by Day | | (shortcut) | | [Model View].[Campaign Cell Response History by Day] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Cell | | (shortcut) | | [Model View].[Cell] |
ControlCells | | (shortcut) | | [Model View].[Cell] |
Responder Rate Control Group by Cell by Day | | (shortcut) | | [Model View].[Responder Rate Control Group by Cell by Day] |
Calendar | | (shortcut) | | [Model View].[Calendar] |
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Responder Rate Calculations by Day | Responder Rate by Cell by Day | Cell ID | decimal | identifier | [Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Responder Rate | float64 | fact | IF([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients] is missing)
THEN(0)
ELSE([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients]) |
Responder Rate Control Group by Cell by Day | Cell ID | decimal | identifier | [Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Campaign ID | decimal | identifier | [Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Campaign ID] |
Responder Rate Control Group | float64 | fact | IF([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders Control Group] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients Control Group] is missing)
THEN(0)
ELSE([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders Control Group] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients Control Group]) |
|
Campaign Performance by Month | Campaign Contact History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCH_MO].[CAMPAIGNID] |
Month | int64 | attribute | [CampaignDS].[UARC_CCH_MO].[MONTH] |
Year | int64 | attribute | [CampaignDS].[UARC_CCH_MO].[YEAR] |
Number of Offers Given | float64 | fact | total([CampaignDS].[UARC_CCH_MO].[NUM_OF_OFFERS] for [CampaignDS].[UARC_CCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_MO].[YEAR],[CampaignDS].[UARC_CCH_MO].[MONTH] ) |
Number of Offers Given Control Group | float64 | fact | total ([CampaignDS].[UARC_CCH_MO].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_CCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_MO].[YEAR],[CampaignDS].[UARC_CCH_MO].[MONTH] ) |
Unique Recipients | float64 | fact | total ([CampaignDS].[UARC_CCH_MO].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_CCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_MO].[YEAR],[CampaignDS].[UARC_CCH_MO].[MONTH] ) |
Unique Recipients Control Group | float64 | fact | total ([CampaignDS].[UARC_CCH_MO].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_CCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_MO].[YEAR],[CampaignDS].[UARC_CCH_MO].[MONTH] ) |
Number of Offer Versions | float64 | fact | total ([CampaignDS].[UARC_CCH_MO].[NUM_OFF_VERS] for [CampaignDS].[UARC_CCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_MO].[YEAR],[CampaignDS].[UARC_CCH_MO].[MONTH] ) |
Number of Offer Versions Control Group | float64 | fact | total ([CampaignDS].[UARC_CCH_MO].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_CCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_MO].[YEAR],[CampaignDS].[UARC_CCH_MO].[MONTH] ) |
Campaign Offer Contact History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_COCH_MO].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_COCH_MO].[OFFERID] |
Month | int64 | attribute | [CampaignDS].[UARC_COCH_MO].[MONTH] |
Year | int64 | attribute | [CampaignDS].[UARC_COCH_MO].[YEAR] |
Number of Offers | float64 | fact | total ([CampaignDS].[UARC_COCH_MO].[NUM_OF_OFFERS] for [CampaignDS].[UARC_COCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_MO].[OFFERID] ,[CampaignDS].[UARC_COCH_MO].[YEAR],[CampaignDS].[UARC_COCH_MO].[MONTH] ) |
Number of Offers Control Group | float64 | fact | total ([CampaignDS].[UARC_COCH_MO].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_COCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_MO].[OFFERID] ,[CampaignDS].[UARC_COCH_MO].[YEAR],[CampaignDS].[UARC_COCH_MO].[MONTH] ) |
Unique Recipients | float64 | fact | total ([CampaignDS].[UARC_COCH_MO].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_COCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_MO].[OFFERID] ,[CampaignDS].[UARC_COCH_MO].[YEAR],[CampaignDS].[UARC_COCH_MO].[MONTH] ) |
Unique Recipients Control Group | float64 | fact | total ([CampaignDS].[UARC_COCH_MO].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_COCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_MO].[OFFERID] ,[CampaignDS].[UARC_COCH_MO].[YEAR],[CampaignDS].[UARC_COCH_MO].[MONTH] ) |
Number of Offer Versions | float64 | fact | total ([CampaignDS].[UARC_COCH_MO].[NUM_OFF_VERS] for [CampaignDS].[UARC_COCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_MO].[OFFERID] ,[CampaignDS].[UARC_COCH_MO].[YEAR],[CampaignDS].[UARC_COCH_MO].[MONTH] ) |
Number of Offer Versions Control Group | float64 | fact | total ([CampaignDS].[UARC_COCH_MO].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_COCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_MO].[OFFERID] ,[CampaignDS].[UARC_COCH_MO].[YEAR],[CampaignDS].[UARC_COCH_MO].[MONTH] ) |
Campaign Cell Contact History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCCH_MO].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCCH_MO].[CELLID] |
Month | float64 | attribute | [CampaignDS].[UARC_CCCH_MO].[MONTH] |
Year | float64 | attribute | [CampaignDS].[UARC_CCCH_MO].[YEAR] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[NUM_OFF_VERS_CG] |
Campaign Response History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CRH_MO].[CAMPAIGNID] |
Month | decimal | attribute | [CampaignDS].[UARC_CRH_MO].[MONTH] |
Year | decimal | attribute | [CampaignDS].[UARC_CRH_MO].[YEAR] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CRH_MO].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CRH_MO].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CRH_MO].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CRH_MO].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CRH_MO].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CRH_MO].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CRH_MO].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CRH_MO].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_MO].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CRH_MO].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_MO].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE_CG]) |
Campaign Offer Response History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CORH_MO].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_CORH_MO].[OFFERID] |
Month | decimal | attribute | [CampaignDS].[UARC_CORH_MO].[MONTH] |
Year | decimal | attribute | [CampaignDS].[UARC_CORH_MO].[YEAR] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CORH_MO].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CORH_MO].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CORH_MO].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CORH_MO].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CORH_MO].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CORH_MO].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CORH_MO].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CORH_MO].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_MO].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CORH_MO].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_MO].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE_CG]) |
Campaign Cell Response History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCRH_MO].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCRH_MO].[CELLID] |
Month | decimal | attribute | [CampaignDS].[UARC_CCRH_MO].[MONTH] |
Year | decimal | attribute | [CampaignDS].[UARC_CCRH_MO].[YEAR] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CCRH_MO].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_MO].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CCRH_MO].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_MO].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE_CG]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Performance by Month Star Schema
 | Campaign Contact History by Month | | (shortcut) | | [Model View].[Campaign Contact History by Month] |
Campaign Offer Contact History by Month | | (shortcut) | | [Model View].[Campaign Offer Contact History by Month] |
Campaign Cell Contact History by Month | | (shortcut) | | [Model View].[Campaign Cell Contact History by Month] |
Campaign Response History by Month | | (shortcut) | | [Model View].[Campaign Response History by Month] |
Campaign Offer Response History by Month | | (shortcut) | | [Model View].[Campaign Offer Response History by Month] |
Campaign Cell Response History by Month | | (shortcut) | | [Model View].[Campaign Cell Response History by Month] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Cell | | (shortcut) | | [Model View].[Cell] |
ControlCells | | (shortcut) | | [Model View].[Cell] |
Responder Rate Control Group by Cell by Month | | (shortcut) | | [Model View].[Responder Rate Control Group by Cell by Month] |
Calendar Month | | (shortcut) | | [Model View].[Calendar Month] |
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Responder Rate Calculations by Month | Responder Rate by Cell by Month | Cell ID | decimal | identifier | [Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Responder Rate by Month | float64 | fact | IF([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients] is missing)
THEN(0)
ELSE([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients]) |
Responder Rate Control Group by Cell by Month | Cell ID | decimal | identifier | [Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Campaign ID | decimal | identifier | [Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Campaign ID] |
Responder Rate Control Group | float64 | fact | IF([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders Control Group] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients Control Group] is missing)
THEN(0)
ELSE([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders Control Group] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients Control Group]) |
|
Campaign Performance Summary | Campaign Contact History Summary | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] |
Number of Offers Given | float64 | fact | total ([CampaignDS].[UARC_CCH_SUMMARY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) |
Number of Offers Given Control Group | float64 | fact | total ([CampaignDS].[UARC_CCH_SUMMARY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) |
Unique Recipients | float64 | fact | total ([CampaignDS].[UARC_CCH_SUMMARY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) |
Unique Recipients Control Group | float64 | fact | total ([CampaignDS].[UARC_CCH_SUMMARY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) |
Number of Offer Versions | float64 | fact | total ([CampaignDS].[UARC_CCH_SUMMARY].[NUM_OFF_VERS] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) |
Number of Offer Versions Control Group | float64 | fact | total ([CampaignDS].[UARC_CCH_SUMMARY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) |
Campaign Response History Summary | Campaign ID | int64 | identifier | [CampaignDS].[UARC_CRH_SUMMARY].[CAMPAIGNID] |
Response Transactions | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[RESP_TRANS] |
Response Transactions Control Group | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[RESP_TRANS_CG] |
Unique Responders | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[UNIQUE_RESP_CG] |
Not Contacted Responders | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[NOT_CONT_RESP] |
Responses After Expiration | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | decimal | fact | IF([CampaignDS].[UARC_CRH_SUMMARY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_SUMMARY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | decimal | fact | IF([CampaignDS].[UARC_CRH_SUMMARY].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_SUMMARY].[REV_PER_RESP_CG]) |
Gross Revenue | decimal | fact | IF([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE]) |
Gross Revenue Control Group | decimal | fact | IF([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE_CG]) |
Campaign Offer Contact History Summary | Campaign ID | decimal | identifier | [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] |
Number of Offers Given | float64 | fact | total ([CampaignDS].[UARC_COCH_SUMMARY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) |
Number of Offers Given Control Group | float64 | fact | total ([CampaignDS].[UARC_COCH_SUMMARY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) |
Unique Recipients | float64 | fact | total ([CampaignDS].[UARC_COCH_SUMMARY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) |
Unique Recipients Control Group | float64 | fact | total ([CampaignDS].[UARC_COCH_SUMMARY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) |
Number of Offer Versions | float64 | fact | total ([CampaignDS].[UARC_COCH_SUMMARY].[NUM_OFF_VERS] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) |
Number of Offer Versions Control Group | float64 | fact | total ([CampaignDS].[UARC_COCH_SUMMARY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) |
Campaign Offer Response History Summary | Campaign ID | int64 | identifier | [CampaignDS].[UARC_CORH_SUMMARY].[CAMPAIGNID] |
Offer ID | int64 | identifier | [CampaignDS].[UARC_CORH_SUMMARY].[OFFERID] |
Response Transactions | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[RESP_TRANS] |
Unique Responders | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[UNIQUE_RESP_CG] |
Not Contacted Responders | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[NOT_CONT_RESP] |
Responses After Expiration | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[RESP_AFTER_EXP_CG] |
Response Transactions Control Group | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[RESP_TRANS_CG] |
Revenue Per Response | decimal | fact | IF([CampaignDS].[UARC_CORH_SUMMARY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_SUMMARY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | decimal | fact | IF([CampaignDS].[UARC_CORH_SUMMARY].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_SUMMARY].[REV_PER_RESP_CG]) |
Gross Revenue | decimal | fact | IF([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE]) |
Gross Revenue Control Group | decimal | fact | IF([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE_CG]) |
Campaign Cell Contact History Summary | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCCH_SUMMARY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCCH_SUMMARY].[CELLID] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OFF_VERS_CG] |
Campaign Cell Response History Summary | Campaign ID | int64 | identifier | [CampaignDS].[UARC_CCRH_SUMMARY].[CAMPAIGNID] |
Cell ID | int64 | identifier | [CampaignDS].[UARC_CCRH_SUMMARY].[CELLID] |
Response Transactions | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_TRANS] |
Unique Responders | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[UNIQUE_RESP_CG] |
Not Contacted Responders | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[NOT_CONT_RESP] |
Responses After Expiration | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_AFTER_EXP_CG] |
Response Transactions Control Group | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_TRANS_CG] |
Revenue Per Response | decimal | fact | IF([CampaignDS].[UARC_CCRH_SUMMARY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | decimal | fact | IF([CampaignDS].[UARC_CCRH_SUMMARY].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[REV_PER_RESP_CG]) |
Gross Revenue | decimal | fact | IF([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE]) |
Gross Revenue Control Group | decimal | fact | IF([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE_CG]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Performance Summary Star Schema Base
 | Campaign Contact History Summary | | (shortcut) | | [Model View].[Campaign Contact History Summary] |
Campaign Response History Summary | | (shortcut) | | [Model View].[Campaign Response History Summary] |
Campaign Offer Contact History Summary | | (shortcut) | | [Model View].[Campaign Offer Contact History Summary] |
Campaign Offer Response History Summary | | (shortcut) | | [Model View].[Campaign Offer Response History Summary] |
Campaign Cell Contact History Summary | | (shortcut) | | [Model View].[Campaign Cell Contact History Summary] |
Campaign Cell Response History Summary | | (shortcut) | | [Model View].[Campaign Cell Response History Summary] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Cell | | (shortcut) | | [Model View].[Cell] |
Campaign Performance Summary Star Schema Base | Campaign Cell CH with Controls Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Cell ID] |
Number of Offers Given | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Number of Offers Given] |
Number of Offers Given Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Controls].[Number of Offers Given Control Group] |
Unique Recipients | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Unique Recipients] |
Unique Recipients Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Controls].[Unique Recipients Control Group] |
Number of Offer Versions | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Number of Offer Versions] |
Number of Offer Versions Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Controls].[Number of Offer Versions Control Group] |
Campaign Cell RH with Controls Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Cell ID] |
Response Transactions | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Response Transactions] |
Response Transactions Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Response Transactions Control Group] |
Unique Responders | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Unique Responders] |
Unique Responders Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Unique Responders Control Group] |
Not Contacted Responders | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Not Contacted Responders] |
Responses After Expiration | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Responses After Expiration] |
Responses After Expiration Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Responses After Expiration Control Group] |
Revenue Per Response | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Revenue Per Response] |
Revenue Per Response Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Revenue Per Response Control Group] |
Gross Revenue | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Gross Revenue] |
Gross Revenue Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Gross Revenue Control Group] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell Control Cells | Campaign Cell Contact History No Controls | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Cell ID] |
Number of Offers Given | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offers Given] |
Unique Recipients | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients] |
Number of Offer Versions | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offer Versions] |
Control Cell ID | decimal | attribute | [Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Control Cell ID] |
Is Control | int64 | attribute | [Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Is Control] |
Campaign Cell Contact History Controls | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Cell ID] |
Number of Offers Given Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offers Given Control Group] |
Unique Recipients Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients Control Group] |
Number of Offer Versions Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offer Versions Control Group] |
Is Control | int64 | attribute | [Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Is Control] |
Control Cell ID | decimal | attribute | [Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Control Cell ID] |
Campgain Cell Response History No Controls | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] |
Response Transactions | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Response Transactions] |
Unique Responders | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders] |
Not Contacted Responders | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Not Contacted Responders] |
Responses After Expiration | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Responses After Expiration] |
Revenue Per Response | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Revenue Per Response] |
Gross Revenue | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue] |
Is Control | int64 | attribute | [Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Is Control] |
Control Cell ID | decimal | attribute | [Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Control Cell ID] |
Campaign Cell Response History Controls Only | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] |
Unique Responders Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders Control Group] |
Responses After Expiration Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Responses After Expiration Control Group] |
Response Transactions Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Response Transactions Control Group] |
Revenue Per Response Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Revenue Per Response Control Group] |
Gross Revenue Control Group | float64 | fact | [Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue Control Group] |
Is Control | int64 | attribute | [Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Is Control] |
Control Cell ID | decimal | attribute | [Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Control Cell ID] |
|
Campaign Performance Summary Star Schema
 | Campaign Response History Summary | | (shortcut) | | [Model View].[Campaign Response History Summary] |
Campaign Offer Response History Summary | | (shortcut) | | [Model View].[Campaign Offer Response History Summary] |
Campaign Cell Contact History Summary | | (shortcut) | | [Model View].[Campaign Cell Contact History Summary] |
Campaign Cell Response History Summary | | (shortcut) | | [Model View].[Campaign Cell Response History Summary] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Cell | | (shortcut) | | [Model View].[Cell] |
Campaign Performance Summary Star Schema | Campaign Contact History Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] |
Number of Offers Given | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Number of Offers Given Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Unique Recipients | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Unique Recipients Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Number of Offer Versions | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Number of Offer Versions Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Campaign Offer Contact History Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] |
Offer ID | decimal | identifier | [Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] |
Number of Offers Given | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Number of Offers Given Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Unique Recipients | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Unique Recipients Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Number of Offer Versions | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Number of Offer Versions Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Campaign Cell CH with Controls Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Cell ID] |
Number of Offers Given | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Number of Offers Given] |
Number of Offers Given Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Controls].[Number of Offers Given Control Group] |
Unique Recipients | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Unique Recipients] |
Unique Recipients Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Controls].[Unique Recipients Control Group] |
Number of Offer Versions | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Number of Offer Versions] |
Number of Offer Versions Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Controls].[Number of Offer Versions Control Group] |
Campaign Cell RH with Controls Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Cell ID] |
Response Transactions | float64 | fact | [Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Response Transactions] |
Response Transactions Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Response Transactions Control Group] |
Unique Responders | float64 | fact | [Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Unique Responders] |
Unique Responders Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Unique Responders Control Group] |
Not Contacted Responders | float64 | fact | [Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Not Contacted Responders] |
Responses After Expiration | float64 | fact | [Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Responses After Expiration] |
Responses After Expiration Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Responses After Expiration Control Group] |
Revenue Per Response | float64 | fact | [Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Revenue Per Response] |
Revenue Per Response Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Revenue Per Response Control Group] |
Gross Revenue | float64 | fact | [Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Gross Revenue] |
Gross Revenue Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Gross Revenue Control Group] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell Control Cells | Campaign Cell Contact History No Controls | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Cell ID] |
Number of Offers Given | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offers Given] |
Unique Recipients | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients] |
Number of Offer Versions | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offer Versions] |
Control Cell ID | decimal | attribute | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Control Cell ID] |
Is Control | int64 | attribute | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Is Control] |
Campaign Cell Contact History Controls | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Cell ID] |
Number of Offers Given Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offers Given Control Group] |
Unique Recipients Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients Control Group] |
Number of Offer Versions Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offer Versions Control Group] |
Is Control | int64 | attribute | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Is Control] |
Control Cell ID | decimal | attribute | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Control Cell ID] |
Campgain Cell Response History No Controls | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] |
Response Transactions | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Response Transactions] |
Unique Responders | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders] |
Not Contacted Responders | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Not Contacted Responders] |
Responses After Expiration | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Responses After Expiration] |
Revenue Per Response | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Revenue Per Response] |
Gross Revenue | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue] |
Is Control | int64 | attribute | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Is Control] |
Control Cell ID | decimal | attribute | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Control Cell ID] |
Campaign Cell Response History Controls Only | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] |
Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] |
Unique Responders Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders Control Group] |
Responses After Expiration Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Responses After Expiration Control Group] |
Response Transactions Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Response Transactions Control Group] |
Revenue Per Response Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Revenue Per Response Control Group] |
Gross Revenue Control Group | float64 | fact | [Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue Control Group] |
Is Control | int64 | attribute | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Is Control] |
Control Cell ID | decimal | attribute | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Control Cell ID] |
|
|