Unica Campaign Cognos Framework Manager Model Specification


Project: CampaignModel
Supported Locale(s): en fr de es 
Package(s): Unica Campaign Package
NameCM DataSource
CampaignDSCampaignDS

Parameter MapKey - Values
EnvironmentRedirect URL: http://localhost:7001/Campaign/redirectToSummary.do?external=true&
Version: 8.1.0.00

model/CampaignModel.jpg
Folder: Business View
Folder: Model View
Folder: Import View


Business View
model/Business View.jpg
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign ListingCampaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Cell (shortcut) [Model View].[Cell]
CampToOffer (shortcut) [Model View].[CampToOffer]
Campaign Custom AttributesCampaign Cust Attributes (shortcut) [Model View].[Campaign Cust Attributes]
Offer Custom Attributes (shortcut) [Model View].[Offer Custom Attributes]
Cell Custom Attributes (shortcut) [Model View].[Cell Custom Attributes]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Cell (shortcut) [Model View].[Cell]
CampToOffer (shortcut) [Model View].[CampToOffer]
Campaign Performance by DayCampaign 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]
Campaign Performance by MonthCampaign 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]
Campaign Performance SummaryCampaign 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 SummaryCampaign Contact History SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] 
Offer IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 SummaryCampaign IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Contact History No Controls].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Contact History No Controls].[Cell ID] 
Number of Offers Givenfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History No Controls].[Number of Offers Given] 
Number of Offers Given Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History Controls].[Number of Offers Given Control Group] 
Unique Recipientsfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History No Controls].[Unique Recipients] 
Unique Recipients Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History Controls].[Unique Recipients Control Group] 
Number of Offer Versionsfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History No Controls].[Number of Offer Versions] 
Number of Offer Versions Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History Controls].[Number of Offer Versions Control Group] 
Campaign Cell RH with Controls SummaryCampaign IDdecimalidentifier[Campaign Performance Summary].[Campgain Cell Response History No Controls].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary].[Campgain Cell Response History No Controls].[Cell ID] 
Response Transactionsfloat64fact[Campaign Performance Summary].[Campgain Cell Response History No Controls].[Response Transactions] 
Response Transactions Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Controls Only].[Response Transactions Control Group] 
Unique Respondersfloat64fact[Campaign Performance Summary].[Campgain Cell Response History No Controls].[Unique Responders] 
Unique Responders Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Controls Only].[Unique Responders Control Group] 
Not Contacted Respondersfloat64fact[Campaign Performance Summary].[Campgain Cell Response History No Controls].[Not Contacted Responders] 
Responses After Expirationfloat64fact[Campaign Performance Summary].[Campgain Cell Response History No Controls].[Responses After Expiration] 
Responses After Expiration Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Controls Only].[Responses After Expiration Control Group] 
Revenue Per Responsefloat64fact[Campaign Performance Summary].[Campgain Cell Response History No Controls].[Revenue Per Response] 
Revenue Per Response Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Controls Only].[Revenue Per Response Control Group] 
Gross Revenuefloat64fact[Campaign Performance Summary].[Campgain Cell Response History No Controls].[Gross Revenue] 
Gross Revenue Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Controls Only].[Gross Revenue Control Group] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell Control CellsCampaign Cell Contact History No ControlsCampaign IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Cell ID] 
Number of Offers Givenfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offers Given] 
Unique Recipientsfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients] 
Number of Offer Versionsfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offer Versions] 
Control Cell IDdecimalattribute[Campaign Performance Summary].[Cell][Model View].[Cell].[Control Cell ID] 
Is Controlint64attribute[Campaign Performance Summary].[Cell][Model View].[Cell].[Is Control] 
Campaign Cell Contact History ControlsCampaign IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Cell ID] 
Number of Offers Given Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offers Given Control Group] 
Unique Recipients Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients Control Group] 
Number of Offer Versions Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offer Versions Control Group] 
Is Controlint64attribute[Campaign Performance Summary].[Cell][Model View].[Cell].[Is Control] 
Control Cell IDdecimalattribute[Campaign Performance Summary].[Cell][Model View].[Cell].[Control Cell ID] 
Campgain Cell Response History No ControlsCampaign IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] 
Response Transactionsfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Response Transactions] 
Unique Respondersfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders] 
Not Contacted Respondersfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Not Contacted Responders] 
Responses After Expirationfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Responses After Expiration] 
Revenue Per Responsefloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Revenue Per Response] 
Gross Revenuefloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue] 
Is Controlint64attribute[Campaign Performance Summary].[Cell][Model View].[Cell].[Is Control] 
Control Cell IDdecimalattribute[Campaign Performance Summary].[Cell][Model View].[Cell].[Control Cell ID] 
Campaign Cell Response History Controls OnlyCampaign IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] 
Unique Responders Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders Control Group] 
Responses After Expiration Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Responses After Expiration Control Group] 
Response Transactions Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Response Transactions Control Group] 
Revenue Per Response Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Revenue Per Response Control Group] 
Gross Revenue Control Groupfloat64fact[Campaign Performance Summary].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue Control Group] 
Is Controlint64attribute[Campaign Performance Summary].[Cell][Model View].[Cell].[Is Control] 
Control Cell IDdecimalattribute[Campaign Performance Summary].[Cell][Model View].[Cell].[Control Cell ID] 
Campaign Offer Detailed Response BreakoutCampaign Response Breakout (shortcut) [Model View].[Campaign Response Breakout]
Campaign Offer Response Breakout (shortcut) [Model View].[Campaign Offer Response Breakout]
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 (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
CampToOffer (shortcut) [Model View].[CampToOffer]
Campaign Offer Detailed Response BreakoutCampaign Contact History SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] 
Offer IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ( [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 Groupfloat64facttotal ([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 Offer Contact Statuses BreakoutCampaign Response History Summary (shortcut) [Model View].[Campaign Response History Summary]
Campaign Offer Response History Summary (shortcut) [Model View].[Campaign Offer Response History Summary]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
CampToOffer (shortcut) [Model View].[CampToOffer]
Campaign Contact Status Breakout (shortcut) [Model View].[Campaign Contact Status Breakout]
Campaign Offer Contact Status Breakout (shortcut) [Model View].[Campaign Offer Contact Status Breakout]
Campaign Offer Contact Statuses BreakoutCampaign Contact History SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] 
Offer IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ( [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 Groupfloat64facttotal ([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] ) 
Offer Performance by DayOffer Contact History by Day (shortcut) [Model View].[Offer Contact History by Day]
Offer Campaign Contact History by Day (shortcut) [Model View].[Offer Campaign Contact History by Day]
Offer Campaign Response History by Day (shortcut) [Model View].[Offer Campaign Response History by Day]
Offer Response History by Day (shortcut) [Model View].[Offer Response History by Day]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Calendar (shortcut) [Model View].[Calendar]
Offer Performance by MonthOffer Contact History by Month (shortcut) [Model View].[Offer Contact History by Month]
Offer Campaign Contact History by Month (shortcut) [Model View].[Offer Campaign Contact History by Month]
Offer Campaign Response History by Month (shortcut) [Model View].[Offer Campaign Response History by Month]
Offer Response History by Month (shortcut) [Model View].[Offer Response History by Month]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Calendar Month (shortcut) [Model View].[Calendar Month]
Offer Performance SummaryOffer Campaign Response History Summary (shortcut) [Model View].[Offer Campaign Response History Summary]
Offer Response History Summary (shortcut) [Model View].[Offer Response History Summary]
Offer Performance Metrics Summary (shortcut) [Model View].[Offer Performance Metrics Summary]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Offer Performance SummaryOffer Campaign Contact History SummaryOffer IDdecimalidentifier[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID] 
Campaign IDdecimalidentifier[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] 
Number of Offers Givenfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Number of Offers Given] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Number of Offers Given Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Number of Offers Given Control Group] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Number of Offer Versionsfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Number of Offer Versions] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Number of Offer Versions Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Number of Offer Versions Control Group] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Unique Recipientsfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Unique Recipients] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Unique Recipients Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Unique Recipients Control Group] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Offer Contact History SummaryOffer IDdecimalidentifier[Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] 
Number of Offers Givenfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Number of Offers Given] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Number of Offers Given Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Number of Offers Given Control Group] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Number of Offer Versionsfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Number of Offer Versions] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Number of Offer Versions Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Number of Offer Versions Control Group] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Unique Recipientsfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Unique Recipients] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Unique Recipients Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Unique Recipients Control Group] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Time DimensionsCalendar (shortcut) [Model View].[Calendar]
Time (shortcut) [Model View].[Time]
Model View
model/Model View.jpg
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign CommonControlCells (shortcut) [Model View].[Cell]
Campaign CommonCampaignCampaign IDdecimalidentifier[CampaignDS].[UARC_CAMPAIGN].[CAMPAIGNID] 
Campaign NamecharacterLength16attribute[CampaignDS].[UARC_CAMPAIGN].[NAME] 
DescriptioncharacterLength16attribute[CampaignDS].[UARC_CAMPAIGN].[DESCRIPTION] 
Campaign CodecharacterLength16attribute[CampaignDS].[UARC_CAMPAIGN].[CAMPAIGNCODE] 
ObjectivescharacterLength16attribute[CampaignDS].[UARC_CAMPAIGN].[OBJECTIVES] 
Last Run DatedateTimeattribute[CampaignDS].[UARC_CAMPAIGN].[LASTRUNDATE] 
InitiativecharacterLength16attributeIF ([CampaignDS].[UARC_CAMPAIGN].[INITIATIVE]=' ' OR [CampaignDS].[UARC_CAMPAIGN].[INITIATIVE] is missing) THEN(' ') ELSE([CampaignDS].[UARC_CAMPAIGN].[INITIATIVE]) 
Create DatedateTimeattribute[CampaignDS].[UARC_CAMPAIGN].[CREATEDATE] 
Update DatedateTimeattribute[CampaignDS].[UARC_CAMPAIGN].[UPDATEDATE] 
Start DatedateTimeattribute[CampaignDS].[UARC_CAMPAIGN].[STARTDATE] 
End DatedateTimeattribute[CampaignDS].[UARC_CAMPAIGN].[ENDDATE] 
CampaignURLcharacterLength16attribute#sq($[Environment]{'Redirect URL'})# + 'type=campaign&id=' + cast(cast([Model View].[Campaign].[Campaign ID] , integer), varchar(10)) 
Not Applilcable Calccharacterattribute'-' 
Create Byint64attribute[CampaignDS].[UARC_CAMPAIGN].[CREATEBY] 
Update Byint64attribute[CampaignDS].[UARC_CAMPAIGN].[UPDATEBY] 
Run Byint64attribute[CampaignDS].[UARC_CAMPAIGN].[RUNBY] 
OfferOffer IDdecimalidentifier[CampaignDS].[UARC_OFFER].[OFFERID] 
Offer NamecharacterLength16attribute[CampaignDS].[UARC_OFFER].[NAME] 
OfferURLcharacterLength16attribute#sq($[Environment]{'Redirect URL'})# + 'type=offer&id=' + cast(cast([Model View].[Offer].[Offer ID] , integer), varchar(10)) 
Offer Code1characterLength16attribute[CampaignDS].[UARC_OFFER].[OFFERCODE1] 
Offer Code2characterLength16attribute[CampaignDS].[UARC_OFFER].[OFFERCODE2] 
Offer Code3characterLength16attribute[CampaignDS].[UARC_OFFER].[OFFERCODE3] 
Offer Code4characterLength16attribute[CampaignDS].[UARC_OFFER].[OFFERCODE4] 
Offer Code5characterLength16attribute[CampaignDS].[UARC_OFFER].[OFFERCODE5] 
Create DatedateTimeattribute[CampaignDS].[UARC_OFFER].[CREATEDATE] 
Create Byint64attribute[CampaignDS].[UARC_OFFER].[CREATEBY] 
Update DatedateTimeattribute[CampaignDS].[UARC_OFFER].[UPDATEDATE] 
Update Byint64attribute[CampaignDS].[UARC_OFFER].[UPDATEBY] 
Retiredint64attribute[CampaignDS].[UARC_OFFER].[RETIRED] 
CellCell IDdecimalidentifier[CampaignDS].[UARC_CELL].[CELLID] 
Cell NamecharacterLength16attribute[CampaignDS].[UARC_CELL].[CELLNAME] 
Cell CodecharacterLength16attribute[CampaignDS].[UARC_CELL].[CELLCODE] 
Control Cell IDdecimalattribute[CampaignDS].[UARC_CELL].[CONTROLCELLID] 
Is Controlint64attribute[CampaignDS].[UARC_CELL].[ISCONTROL] 
Campaign IDdecimalidentifier[CampaignDS].[UARC_CELL].[CAMPAIGNID] 
CampToOfferOffer IDdecimalidentifier[CampaignDS].[UARC_CAMPTOOFFER].[OFFERID] 
Campaign IDdecimalidentifier[CampaignDS].[UARC_CAMPTOOFFER].[CAMPAIGNID] 
CalendarDate IDdecimalidentifier[CampaignDS].[UARC_CALENDAR].[DATEID] 
Yearint64attribute[CampaignDS].[UARC_CALENDAR].[YEAR] 
Fiscal Yearint64attribute[CampaignDS].[UARC_CALENDAR].[FISCALYEAR] 
Quarterint64attribute[CampaignDS].[UARC_CALENDAR].[QUARTER] 
Fiscal Quarterint64attribute[CampaignDS].[UARC_CALENDAR].[FISCALQUARTER] 
Monthint64attribute[CampaignDS].[UARC_CALENDAR].[MONTH] 
Week of Yearint64attribute[CampaignDS].[UARC_CALENDAR].[WEEKOFYEAR] 
Week of Monthint64attribute[CampaignDS].[UARC_CALENDAR].[WEEKOFMONTH] 
Day of Yearint64attribute[CampaignDS].[UARC_CALENDAR].[DAYOFYEAR] 
Day of Monthint64attribute[CampaignDS].[UARC_CALENDAR].[DAYOFMONTH] 
Day of Weekint64attribute[CampaignDS].[UARC_CALENDAR].[DAYOFWEEK] 
Actual DatedateTimeidentifier[CampaignDS].[UARC_CALENDAR].[ACTUALDATE] 
First Day of WeekdateTimeattribute[CampaignDS].[UARC_CALENDAR].[FIRSTDAYOFWEEK] 
Last Day of WeekdateTimeattribute[CampaignDS].[UARC_CALENDAR].[LASTDAYOFWEEK] 
Calendar MonthDate IDint64identifier[Model View].[Calendar].[Date ID] 
Yearint32attribute[Model View].[Calendar].[Year] 
Fiscal Yearint32attribute[Model View].[Calendar].[Fiscal Year] 
Monthint32attribute[Model View].[Calendar].[Month] 
TimeTime IDdecimalidentifier[CampaignDS].[UARC_TIME].[TIMEID] 
Hourint64identifier[CampaignDS].[UARC_TIME].[HOUR] 
Minuteint64identifier[CampaignDS].[UARC_TIME].[MINUTE] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Listing Star Schema
model/Campaign Listing Star Schema.jpg
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Cell (shortcut) [Model View].[Cell]
CampToOffer (shortcut) [Model View].[CampToOffer]
Campaign Custom AttributesCampaign Cust AttributesCampaign IDdecimalidentifier[CampaignDS].[UARC_CAMPEXTATTR].[CAMPAIGNID]  
Offer Custom AttributesOffer IDdecimalidentifier[CampaignDS].[UARC_OFFEREXTATTR].[OFFERID]  
Effective DatedateTimeattribute[CampaignDS].[UARC_OFFEREXTATTR].[EFFECTIVE_DATE] 
Expiration DatedateTimeattribute[CampaignDS].[UARC_OFFEREXTATTR].[EXPIRATION_DATE] 
Expiration Durationfloat64fact[CampaignDS].[UARC_OFFEREXTATTR].[EXPIRATION_DUR]  
ChannelcharacterLength16attribute[CampaignDS].[UARC_OFFEREXTATTR].[CHANNEL] 
Cost Per Contactfloat64factIF([CampaignDS].[UARC_OFFEREXTATTR].[COST_PER_CONTACT] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OFFEREXTATTR].[COST_PER_CONTACT])  
Revenue Per Responsefloat64factIF([CampaignDS].[UARC_OFFEREXTATTR].[REVENUE_PER_RESP] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OFFEREXTATTR].[REVENUE_PER_RESP]) 
Offer Fulfillment Costfloat64factIF([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FULFILL_COST] is missing) THEN (0) ELSE([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FULFILL_COST]) 
Offer Fixed Costfloat64factIF ([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FIXED_COST] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FIXED_COST]) 
Cell Custom AttributesCell IDdecimalidentifier[CampaignDS].[UARC_CELLEXTATTR].[CELLID]  
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Custom Attributes Star Schema
model/Campaign Custom Attributes Star Schema.jpg
Campaign Cust Attributes (shortcut) [Model View].[Campaign Cust Attributes]
Offer Custom Attributes (shortcut) [Model View].[Offer Custom Attributes]
Cell Custom Attributes (shortcut) [Model View].[Cell Custom Attributes]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Cell (shortcut) [Model View].[Cell]
CampToOffer (shortcut) [Model View].[CampToOffer]
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Performance DayCampaign Contact History by DayCampaign IDdecimalidentifier[CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] 
Number of Offers Givenfloat64facttotal([CampaignDS].[UARC_CCH_DY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) 
Number of Offers Given Control Groupfloat64facttotal([CampaignDS].[UARC_CCH_DY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) 
Unique Recipientsfloat64facttotal([CampaignDS].[UARC_CCH_DY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) 
Unique Recipients Control Groupfloat64facttotal([CampaignDS].[UARC_CCH_DY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) 
Number of Offer Versionsfloat64facttotal([CampaignDS].[UARC_CCH_DY].[NUM_OFF_VERS] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) 
Number of Offer Versions Control Groupfloat64facttotal([CampaignDS].[UARC_CCH_DY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_CCH_DY].[ACTUALDATE] ) 
Campaign Offer Contact History by DayCampaign IDdecimalidentifier[CampaignDS].[UARC_COCH_DY].[CAMPAIGNID] 
Offer IDdecimalidentifier[CampaignDS].[UARC_COCH_DY].[OFFERID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_COCH_DY].[ACTUALDATE] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 DayCampaign IDdecimalidentifier[CampaignDS].[UARC_CCCH_DY].[CAMPAIGNID] 
Cell IDdecimalidentifier[CampaignDS].[UARC_CCCH_DY].[CELLID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_CCCH_DY].[ACTUALDATE] 
Number of Offers Givenfloat64fact[CampaignDS].[UARC_CCCH_DY].[NUM_OF_OFFERS]  
Number of Offers Given Control Groupfloat64fact[CampaignDS].[UARC_CCCH_DY].[NUM_OF_OFFERS_CG]  
Unique Recipientsfloat64fact[CampaignDS].[UARC_CCCH_DY].[UNIQUE_RECIPIENTS] 
Unique Recipients Control Groupfloat64fact[CampaignDS].[UARC_CCCH_DY].[UNIQUE_RECIP_CG] 
Number of Offer Versionsfloat64fact[CampaignDS].[UARC_CCCH_DY].[NUM_OFF_VERS]  
Number of Offer Versions Control Groupfloat64fact[CampaignDS].[UARC_CCCH_DY].[NUM_OFF_VERS_CG]  
Campaign Response History by DayCampaign IDdecimalidentifier[CampaignDS].[UARC_CRH_DY].[CAMPAIGNID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_CRH_DY].[ACTUALDATE] 
Response Transactionsfloat64fact[CampaignDS].[UARC_CRH_DY].[RESP_TRANS]  
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_CRH_DY].[RESP_TRANS_CG]  
Unique Respondersfloat64fact[CampaignDS].[UARC_CRH_DY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_CRH_DY].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_CRH_DY].[NOT_CONT_RESP]  
Responses After Expirationfloat64fact[CampaignDS].[UARC_CRH_DY].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_CRH_DY].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64factIF([CampaignDS].[UARC_CRH_DY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_DY].[REVENUE_PER_RESP]) 
Revenue Per Response Control Groupfloat64factIF([CampaignDS].[UARC_CRH_DY].[REV_PER_RESP_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_CRH_DY].[REV_PER_RESP_CG]) 
Gross Revenuefloat64factIF([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE] is missing) THEN(0) ELSE ([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE]) 
Gross Revenue Control Groupfloat64factIF([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE_CG] is missing) THEN (0) ELSE([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE_CG]) 
Campaign Offer Response History by DayCampaign IDdecimalidentifier[CampaignDS].[UARC_CORH_DY].[CAMPAIGNID] 
Offer IDdecimalidentifier[CampaignDS].[UARC_CORH_DY].[OFFERID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_CORH_DY].[ACTUALDATE] 
Response Transactionsfloat64fact[CampaignDS].[UARC_CORH_DY].[RESP_TRANS]  
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_CORH_DY].[RESP_TRANS_CG]  
Unique Respondersfloat64fact[CampaignDS].[UARC_CORH_DY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_CORH_DY].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_CORH_DY].[NOT_CONT_RESP]  
Responses After Expirationfloat64fact[CampaignDS].[UARC_CORH_DY].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_CORH_DY].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64factIF([CampaignDS].[UARC_CORH_DY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_DY].[REVENUE_PER_RESP]) 
Revenue Per Response Control Groupfloat64factIF([CampaignDS].[UARC_CORH_DY].[REV_PER_RESP_CG] IS MISSING) THEN(0) ELSE([CampaignDS].[UARC_CORH_DY].[REV_PER_RESP_CG]) 
Gross Revenuefloat64factIF([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE]) 
Gross Revenue Control Groupfloat64factIF([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE_CG]) 
Campaign Cell Response History by DayCampaign IDdecimalidentifier[CampaignDS].[UARC_CCRH_DY].[CAMPAIGNID] 
Cell IDdecimalidentifier[CampaignDS].[UARC_CCRH_DY].[CELLID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_CCRH_DY].[ACTUALDATE] 
Response Transactionsfloat64fact[CampaignDS].[UARC_CCRH_DY].[RESP_TRANS]  
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_CCRH_DY].[RESP_TRANS_CG]  
Unique Respondersfloat64fact[CampaignDS].[UARC_CCRH_DY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_CCRH_DY].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_CCRH_DY].[NOT_CONT_RESP]  
Responses After Expirationfloat64fact[CampaignDS].[UARC_CCRH_DY].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_CCRH_DY].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64factIF([CampaignDS].[UARC_CCRH_DY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_DY].[REVENUE_PER_RESP]) 
Revenue Per Response Control Groupfloat64factIF([CampaignDS].[UARC_CCRH_DY].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_DY].[REV_PER_RESP_CG]) 
Gross Revenuefloat64factIF([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE]) 
Gross Revenue Control Groupfloat64factIF([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE_CG] is missing) THEN (0) ELSE([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE_CG]) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Performance by Day Star Schema
model/Campaign Performance by Day Star Schema.jpg
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/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Responder Rate Calculations by DayResponder Rate by Cell by DayCell IDdecimalidentifier[Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Cell ID] 
Responder Ratefloat64factIF([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 DayCell IDdecimalidentifier[Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Cell ID] 
Campaign IDdecimalidentifier[Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Campaign ID] 
Responder Rate Control Groupfloat64factIF([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 MonthCampaign Contact History by MonthCampaign IDdecimalidentifier[CampaignDS].[UARC_CCH_MO].[CAMPAIGNID] 
Monthint64attribute[CampaignDS].[UARC_CCH_MO].[MONTH] 
Yearint64attribute[CampaignDS].[UARC_CCH_MO].[YEAR]  
Number of Offers Givenfloat64facttotal([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 MonthCampaign IDdecimalidentifier[CampaignDS].[UARC_COCH_MO].[CAMPAIGNID] 
Offer IDdecimalidentifier[CampaignDS].[UARC_COCH_MO].[OFFERID] 
Monthint64attribute[CampaignDS].[UARC_COCH_MO].[MONTH] 
Yearint64attribute[CampaignDS].[UARC_COCH_MO].[YEAR]  
Number of Offersfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 MonthCampaign IDdecimalidentifier[CampaignDS].[UARC_CCCH_MO].[CAMPAIGNID] 
Cell IDdecimalidentifier[CampaignDS].[UARC_CCCH_MO].[CELLID] 
Monthfloat64attribute[CampaignDS].[UARC_CCCH_MO].[MONTH] 
Yearfloat64attribute[CampaignDS].[UARC_CCCH_MO].[YEAR] 
Number of Offers Givenfloat64fact[CampaignDS].[UARC_CCCH_MO].[NUM_OF_OFFERS]  
Number of Offers Given Control Groupfloat64fact[CampaignDS].[UARC_CCCH_MO].[NUM_OF_OFFERS_CG]  
Unique Recipientsfloat64fact[CampaignDS].[UARC_CCCH_MO].[UNIQUE_RECIPIENTS] 
Unique Recipients Control Groupfloat64fact[CampaignDS].[UARC_CCCH_MO].[UNIQUE_RECIP_CG] 
Number of Offer Versionsfloat64fact[CampaignDS].[UARC_CCCH_MO].[NUM_OFF_VERS] 
Number of Offer Versions Control Groupfloat64fact[CampaignDS].[UARC_CCCH_MO].[NUM_OFF_VERS_CG] 
Campaign Response History by MonthCampaign IDdecimalidentifier[CampaignDS].[UARC_CRH_MO].[CAMPAIGNID] 
Monthdecimalattribute[CampaignDS].[UARC_CRH_MO].[MONTH] 
Yeardecimalattribute[CampaignDS].[UARC_CRH_MO].[YEAR] 
Response Transactionsfloat64fact[CampaignDS].[UARC_CRH_MO].[RESP_TRANS]  
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_CRH_MO].[RESP_TRANS_CG]  
Unique Respondersfloat64fact[CampaignDS].[UARC_CRH_MO].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_CRH_MO].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_CRH_MO].[NOT_CONT_RESP]  
Responses After Expirationfloat64fact[CampaignDS].[UARC_CRH_MO].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_CRH_MO].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64factIF([CampaignDS].[UARC_CRH_MO].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_MO].[REVENUE_PER_RESP]) 
Revenue Per Response Control Groupfloat64factIF([CampaignDS].[UARC_CRH_MO].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_MO].[REV_PER_RESP_CG]) 
Gross Revenuefloat64factIF([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE]) 
Gross Revenue Control Groupfloat64factIF([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE_CG]) 
Campaign Offer Response History by MonthCampaign IDdecimalidentifier[CampaignDS].[UARC_CORH_MO].[CAMPAIGNID] 
Offer IDdecimalidentifier[CampaignDS].[UARC_CORH_MO].[OFFERID] 
Monthdecimalattribute[CampaignDS].[UARC_CORH_MO].[MONTH] 
Yeardecimalattribute[CampaignDS].[UARC_CORH_MO].[YEAR]  
Response Transactionsfloat64fact[CampaignDS].[UARC_CORH_MO].[RESP_TRANS]  
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_CORH_MO].[RESP_TRANS_CG]  
Unique Respondersfloat64fact[CampaignDS].[UARC_CORH_MO].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_CORH_MO].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_CORH_MO].[NOT_CONT_RESP]  
Responses After Expirationfloat64fact[CampaignDS].[UARC_CORH_MO].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_CORH_MO].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64factIF([CampaignDS].[UARC_CORH_MO].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_MO].[REVENUE_PER_RESP]) 
Revenue Per Response Control Groupfloat64factIF([CampaignDS].[UARC_CORH_MO].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_MO].[REV_PER_RESP_CG]) 
Gross Revenuefloat64factIF([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE]) 
Gross Revenue Control Groupfloat64factIF([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE_CG]) 
Campaign Cell Response History by MonthCampaign IDdecimalidentifier[CampaignDS].[UARC_CCRH_MO].[CAMPAIGNID] 
Cell IDdecimalidentifier[CampaignDS].[UARC_CCRH_MO].[CELLID] 
Monthdecimalattribute[CampaignDS].[UARC_CCRH_MO].[MONTH] 
Yeardecimalattribute[CampaignDS].[UARC_CCRH_MO].[YEAR]  
Response Transactionsfloat64fact[CampaignDS].[UARC_CCRH_MO].[RESP_TRANS]  
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_CCRH_MO].[RESP_TRANS_CG]  
Unique Respondersfloat64fact[CampaignDS].[UARC_CCRH_MO].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_CCRH_MO].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_CCRH_MO].[NOT_CONT_RESP]  
Responses After Expirationfloat64fact[CampaignDS].[UARC_CCRH_MO].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_CCRH_MO].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64factIF([CampaignDS].[UARC_CCRH_MO].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_MO].[REVENUE_PER_RESP]) 
Revenue Per Response Control Groupfloat64factIF([CampaignDS].[UARC_CCRH_MO].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_MO].[REV_PER_RESP_CG]) 
Gross Revenuefloat64factIF([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE] is missing) THEN (0) ELSE([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE]) 
Gross Revenue Control Groupfloat64factIF([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE_CG]) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Performance by Month Star Schema
model/Campaign Performance by Month Star Schema.jpg
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/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Responder Rate Calculations by MonthResponder Rate by Cell by MonthCell IDdecimalidentifier[Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Cell ID] 
Responder Rate by Monthfloat64factIF([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 MonthCell IDdecimalidentifier[Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Cell ID] 
Campaign IDdecimalidentifier[Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Campaign ID] 
Responder Rate Control Groupfloat64factIF([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 SummaryCampaign Contact History SummaryCampaign IDdecimalidentifier[CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] 
Number of Offers Givenfloat64facttotal ([CampaignDS].[UARC_CCH_SUMMARY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) 
Number of Offers Given Control Groupfloat64facttotal ([CampaignDS].[UARC_CCH_SUMMARY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) 
Unique Recipientsfloat64facttotal ([CampaignDS].[UARC_CCH_SUMMARY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) 
Unique Recipients Control Groupfloat64facttotal ([CampaignDS].[UARC_CCH_SUMMARY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) 
Number of Offer Versionsfloat64facttotal ([CampaignDS].[UARC_CCH_SUMMARY].[NUM_OFF_VERS] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) 
Number of Offer Versions Control Groupfloat64facttotal ([CampaignDS].[UARC_CCH_SUMMARY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] ) 
Campaign Response History SummaryCampaign IDint64identifier[CampaignDS].[UARC_CRH_SUMMARY].[CAMPAIGNID] 
Response Transactionsint32fact[CampaignDS].[UARC_CRH_SUMMARY].[RESP_TRANS]  
Response Transactions Control Groupint32fact[CampaignDS].[UARC_CRH_SUMMARY].[RESP_TRANS_CG]  
Unique Respondersint32fact[CampaignDS].[UARC_CRH_SUMMARY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupint32fact[CampaignDS].[UARC_CRH_SUMMARY].[UNIQUE_RESP_CG] 
Not Contacted Respondersint32fact[CampaignDS].[UARC_CRH_SUMMARY].[NOT_CONT_RESP]  
Responses After Expirationint32fact[CampaignDS].[UARC_CRH_SUMMARY].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupint32fact[CampaignDS].[UARC_CRH_SUMMARY].[RESP_AFTER_EXP_CG] 
Revenue Per ResponsedecimalfactIF([CampaignDS].[UARC_CRH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_SUMMARY].[REVENUE_PER_RESP]) 
Revenue Per Response Control GroupdecimalfactIF([CampaignDS].[UARC_CRH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_SUMMARY].[REV_PER_RESP_CG]) 
Gross RevenuedecimalfactIF([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE]) 
Gross Revenue Control GroupdecimalfactIF([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE_CG]) 
Campaign Offer Contact History SummaryCampaign IDdecimalidentifier[CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] 
Offer IDdecimalidentifier[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] 
Number of Offers Givenfloat64facttotal ([CampaignDS].[UARC_COCH_SUMMARY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) 
Number of Offers Given Control Groupfloat64facttotal ([CampaignDS].[UARC_COCH_SUMMARY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) 
Unique Recipientsfloat64facttotal ([CampaignDS].[UARC_COCH_SUMMARY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) 
Unique Recipients Control Groupfloat64facttotal ([CampaignDS].[UARC_COCH_SUMMARY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) 
Number of Offer Versionsfloat64facttotal ([CampaignDS].[UARC_COCH_SUMMARY].[NUM_OFF_VERS] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) 
Number of Offer Versions Control Groupfloat64facttotal ([CampaignDS].[UARC_COCH_SUMMARY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] ,[CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] ) 
Campaign Offer Response History SummaryCampaign IDint64identifier[CampaignDS].[UARC_CORH_SUMMARY].[CAMPAIGNID] 
Offer IDint64identifier[CampaignDS].[UARC_CORH_SUMMARY].[OFFERID] 
Response Transactionsint32fact[CampaignDS].[UARC_CORH_SUMMARY].[RESP_TRANS]  
Unique Respondersint32fact[CampaignDS].[UARC_CORH_SUMMARY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupint32fact[CampaignDS].[UARC_CORH_SUMMARY].[UNIQUE_RESP_CG] 
Not Contacted Respondersint32fact[CampaignDS].[UARC_CORH_SUMMARY].[NOT_CONT_RESP]  
Responses After Expirationint32fact[CampaignDS].[UARC_CORH_SUMMARY].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupint32fact[CampaignDS].[UARC_CORH_SUMMARY].[RESP_AFTER_EXP_CG] 
Response Transactions Control Groupint32fact[CampaignDS].[UARC_CORH_SUMMARY].[RESP_TRANS_CG]  
Revenue Per ResponsedecimalfactIF([CampaignDS].[UARC_CORH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_SUMMARY].[REVENUE_PER_RESP]) 
Revenue Per Response Control GroupdecimalfactIF([CampaignDS].[UARC_CORH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_SUMMARY].[REV_PER_RESP_CG]) 
Gross RevenuedecimalfactIF([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE]) 
Gross Revenue Control GroupdecimalfactIF([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE_CG]) 
Campaign Cell Contact History SummaryCampaign IDdecimalidentifier[CampaignDS].[UARC_CCCH_SUMMARY].[CAMPAIGNID] 
Cell IDdecimalidentifier[CampaignDS].[UARC_CCCH_SUMMARY].[CELLID] 
Number of Offers Givenfloat64fact[CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OF_OFFERS]  
Number of Offers Given Control Groupfloat64fact[CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OF_OFFERS_CG]  
Unique Recipientsfloat64fact[CampaignDS].[UARC_CCCH_SUMMARY].[UNIQUE_RECIPIENTS] 
Unique Recipients Control Groupfloat64fact[CampaignDS].[UARC_CCCH_SUMMARY].[UNIQUE_RECIP_CG] 
Number of Offer Versionsfloat64fact[CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OFF_VERS] 
Number of Offer Versions Control Groupfloat64fact[CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OFF_VERS_CG] 
Campaign Cell Response History SummaryCampaign IDint64identifier[CampaignDS].[UARC_CCRH_SUMMARY].[CAMPAIGNID] 
Cell IDint64identifier[CampaignDS].[UARC_CCRH_SUMMARY].[CELLID] 
Response Transactionsint32fact[CampaignDS].[UARC_CCRH_SUMMARY].[RESP_TRANS]  
Unique Respondersint32fact[CampaignDS].[UARC_CCRH_SUMMARY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupint32fact[CampaignDS].[UARC_CCRH_SUMMARY].[UNIQUE_RESP_CG] 
Not Contacted Respondersint32fact[CampaignDS].[UARC_CCRH_SUMMARY].[NOT_CONT_RESP]  
Responses After Expirationint32fact[CampaignDS].[UARC_CCRH_SUMMARY].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupint32fact[CampaignDS].[UARC_CCRH_SUMMARY].[RESP_AFTER_EXP_CG] 
Response Transactions Control Groupint32fact[CampaignDS].[UARC_CCRH_SUMMARY].[RESP_TRANS_CG]  
Revenue Per ResponsedecimalfactIF([CampaignDS].[UARC_CCRH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[REVENUE_PER_RESP]) 
Revenue Per Response Control GroupdecimalfactIF([CampaignDS].[UARC_CCRH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[REV_PER_RESP_CG]) 
Gross RevenuedecimalfactIF([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE] is missing) THEN (0) ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE]) 
Gross Revenue Control GroupdecimalfactIF([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE_CG]) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Performance Summary Star Schema Base
model/Campaign Performance Summary Star Schema Base.jpg
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 BaseCampaign Cell CH with Controls SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Cell ID] 
Number of Offers Givenfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Number of Offers Given] 
Number of Offers Given Control Groupfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Controls].[Number of Offers Given Control Group] 
Unique Recipientsfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Unique Recipients] 
Unique Recipients Control Groupfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Controls].[Unique Recipients Control Group] 
Number of Offer Versionsfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History No Controls].[Number of Offer Versions] 
Number of Offer Versions Control Groupfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Controls].[Number of Offer Versions Control Group] 
Campaign Cell RH with Controls SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Cell ID] 
Response Transactionsfloat64fact[Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Response Transactions] 
Response Transactions Control Groupfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Response Transactions Control Group] 
Unique Respondersfloat64fact[Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Unique Responders] 
Unique Responders Control Groupfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Unique Responders Control Group] 
Not Contacted Respondersfloat64fact[Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Not Contacted Responders] 
Responses After Expirationfloat64fact[Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Responses After Expiration] 
Responses After Expiration Control Groupfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Responses After Expiration Control Group] 
Revenue Per Responsefloat64fact[Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Revenue Per Response] 
Revenue Per Response Control Groupfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Revenue Per Response Control Group] 
Gross Revenuefloat64fact[Campaign Performance Summary Star Schema Base].[Campgain Cell Response History No Controls].[Gross Revenue] 
Gross Revenue Control Groupfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Controls Only].[Gross Revenue Control Group] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell Control CellsCampaign Cell Contact History No ControlsCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Cell ID] 
Number of Offers Givenfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offers Given] 
Unique Recipientsfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients] 
Number of Offer Versionsfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offer Versions] 
Control Cell IDdecimalattribute[Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Control Cell ID] 
Is Controlint64attribute[Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Is Control] 
Campaign Cell Contact History ControlsCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] 
Cell IDdecimalidentifier[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 Groupfloat64fact[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 Groupfloat64fact[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 Groupfloat64fact[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 Controlint64attribute[Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Is Control] 
Control Cell IDdecimalattribute[Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Control Cell ID] 
Campgain Cell Response History No ControlsCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] 
Response Transactionsfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Response Transactions] 
Unique Respondersfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders] 
Not Contacted Respondersfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Not Contacted Responders] 
Responses After Expirationfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Responses After Expiration] 
Revenue Per Responsefloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Revenue Per Response] 
Gross Revenuefloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue] 
Is Controlint64attribute[Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Is Control] 
Control Cell IDdecimalattribute[Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Control Cell ID] 
Campaign Cell Response History Controls OnlyCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] 
Unique Responders Control Groupfloat64fact[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 Groupfloat64fact[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 Groupfloat64fact[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 Groupfloat64fact[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 Groupfloat64fact[Campaign Performance Summary Star Schema Base].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue Control Group] 
Is Controlint64attribute[Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Is Control] 
Control Cell IDdecimalattribute[Campaign Performance Summary Star Schema Base].[Cell][Model View].[Cell].[Control Cell ID] 
Campaign Performance Summary Star Schema
model/Campaign Performance Summary Star Schema.jpg
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 SchemaCampaign Contact History SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] 
Offer IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Cell ID] 
Number of Offers Givenfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Number of Offers Given] 
Number of Offers Given Control Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Controls].[Number of Offers Given Control Group] 
Unique Recipientsfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Unique Recipients] 
Unique Recipients Control Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Controls].[Unique Recipients Control Group] 
Number of Offer Versionsfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History No Controls].[Number of Offer Versions] 
Number of Offer Versions Control Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Controls].[Number of Offer Versions Control Group] 
Campaign Cell RH with Controls SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Cell ID] 
Response Transactionsfloat64fact[Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Response Transactions] 
Response Transactions Control Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Response Transactions Control Group] 
Unique Respondersfloat64fact[Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Unique Responders] 
Unique Responders Control Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Unique Responders Control Group] 
Not Contacted Respondersfloat64fact[Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Not Contacted Responders] 
Responses After Expirationfloat64fact[Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Responses After Expiration] 
Responses After Expiration Control Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Responses After Expiration Control Group] 
Revenue Per Responsefloat64fact[Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Revenue Per Response] 
Revenue Per Response Control Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Revenue Per Response Control Group] 
Gross Revenuefloat64fact[Campaign Performance Summary Star Schema].[Campgain Cell Response History No Controls].[Gross Revenue] 
Gross Revenue Control Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Controls Only].[Gross Revenue Control Group] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Cell Control CellsCampaign Cell Contact History No ControlsCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Cell ID] 
Number of Offers Givenfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offers Given] 
Unique Recipientsfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients] 
Number of Offer Versionsfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offer Versions] 
Control Cell IDdecimalattribute[Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Control Cell ID] 
Is Controlint64attribute[Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Is Control] 
Campaign Cell Contact History ControlsCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Cell ID] 
Number of Offers Given Control Groupfloat64fact[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 Groupfloat64fact[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 Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Number of Offer Versions Control Group] 
Is Controlint64attribute[Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Is Control] 
Control Cell IDdecimalattribute[Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Control Cell ID] 
Campgain Cell Response History No ControlsCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] 
Response Transactionsfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Response Transactions] 
Unique Respondersfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders] 
Not Contacted Respondersfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Not Contacted Responders] 
Responses After Expirationfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Responses After Expiration] 
Revenue Per Responsefloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Revenue Per Response] 
Gross Revenuefloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue] 
Is Controlint64attribute[Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Is Control] 
Control Cell IDdecimalattribute[Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Control Cell ID] 
Campaign Cell Response History Controls OnlyCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Campaign ID] 
Cell IDdecimalidentifier[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Cell ID] 
Unique Responders Control Groupfloat64fact[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 Groupfloat64fact[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 Groupfloat64fact[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 Groupfloat64fact[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 Groupfloat64fact[Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Gross Revenue Control Group] 
Is Controlint64attribute[Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Is Control] 
Control Cell IDdecimalattribute[Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Control Cell ID] 
Campaign Detailed Response BreakoutCampaign Response BreakoutCampaign IDint64identifier[CampaignDS].[UARC_CRBO].[CAMPAIGNID] 
Explore Countint32factIF([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT]) 
Explore Count Control Groupint32factIF([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT_CG]) 
Consider Countint32factIF([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT]) 
Consider Count Control Groupint32factIF([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT_CG]) 
Commit Countint32factIF([CampaignDS].[UARC_CRBO].[COMMIT_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[COMMIT_COUNT]) 
Commit Count Control Groupint32factIF([CampaignDS].[UARC_CRBO].[COMMIT_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[COMMIT_COUNT_CG]) 
Fulfill Countint32factIF([CampaignDS].[UARC_CRBO].[FULFILL_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[FULFILL_COUNT]) 
Fulfill Count Control Groupint32factIF([CampaignDS].[UARC_CRBO].[FULFILL_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[FULFILL_COUNT_CG]) 
Counts As Response (All)int32factIF([CampaignDS].[UARC_CRBO].[ALL_COUNTS_AS_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[ALL_COUNTS_AS_RESP]) 
All Responsesint32factIF([CampaignDS].[UARC_CRBO].[ALL_RESPONSES] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[ALL_RESPONSES]) 
Usage Countint32factIF([CampaignDS].[UARC_CRBO].[USAGE_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[USAGE_COUNT]) 
Usage Count Control Groupint32factIF([CampaignDS].[UARC_CRBO].[USAGE_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CRBO].[USAGE_COUNT_CG]) 
Campaign Offer Response BreakoutCampaign IDint64identifier[CampaignDS].[UARC_CORBO].[CAMPAIGNID] 
Offer IDint64identifier[CampaignDS].[UARC_CORBO].[OFFERID] 
Explore Countint32factIF([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT]) 
Explore Count Control Groupint32factIF([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT_CG]) 
Consider Countint32factIF([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT]) 
Consider Count Control Groupint32factIF([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT_CG]) 
Commit Countint32factIF([CampaignDS].[UARC_CORBO].[COMMIT_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[COMMIT_COUNT]) 
Commit Count Control Groupint32factIF([CampaignDS].[UARC_CORBO].[COMMIT_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[COMMIT_COUNT_CG]) 
Fulfill Countint32factIF([CampaignDS].[UARC_CORBO].[FULFILL_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[FULFILL_COUNT]) 
Fulfill Count Control Groupint32factIF([CampaignDS].[UARC_CORBO].[FULFILL_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[FULFILL_COUNT_CG]) 
Counts As Response (All)int32factIF([CampaignDS].[UARC_CORBO].[ALL_COUNTS_AS_RESP] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[ALL_COUNTS_AS_RESP]) 
All Responsesint32factIF([CampaignDS].[UARC_CORBO].[ALL_RESPONSES] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[ALL_RESPONSES])  
Usage Countint32factIF([CampaignDS].[UARC_CORBO].[USAGE_COUNT] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[USAGE_COUNT]) 
Usage Count Control Groupint32factIF([CampaignDS].[UARC_CORBO].[USAGE_COUNT_CG] is missing) THEN(0) ELSE([CampaignDS].[UARC_CORBO].[USAGE_COUNT_CG]) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer Response Breakout Star Schema
model/Campaign Offer Response Breakout Star Schema.jpg
Campaign Response Breakout (shortcut) [Model View].[Campaign Response Breakout]
Campaign Offer Response Breakout (shortcut) [Model View].[Campaign Offer Response Breakout]
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 (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
CampToOffer (shortcut) [Model View].[CampToOffer]
Campaign Offer Response Breakout Star SchemaCampaign Contact History SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] 
Offer IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ( [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 Groupfloat64facttotal ([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 Contact Statuses BreakoutCampaign Contact Status BreakoutCampaign IDdecimalidentifier[CampaignDS].[UARC_CCSBO].[CAMPAIGNID] 
All Contactsfloat64fact[CampaignDS].[UARC_CCSBO].[ALL_CONTACTS] 
Counts As Contact (All)float64fact[CampaignDS].[UARC_CCSBO].[ALL_COUNTS_AS_CONT] 
Campaign Send Countfloat64fact[CampaignDS].[UARC_CCSBO].[CAMP_SEND_COUNT] 
Delivered Countfloat64fact[CampaignDS].[UARC_CCSBO].[DELIVERED_COUNT] 
Undelivered Countfloat64fact[CampaignDS].[UARC_CCSBO].[UNDELIVERED_COUNT] 
Control Countfloat64fact[CampaignDS].[UARC_CCSBO].[CONTROL_COUNT] 
Campaign Offer Contact Status BreakoutCampaign IDdecimalidentifier[CampaignDS].[UARC_COCSBO].[CAMPAIGNID] 
Offer IDdecimalidentifier[CampaignDS].[UARC_COCSBO].[OFFERID] 
All Contactsfloat64fact[CampaignDS].[UARC_COCSBO].[ALL_CONTACTS] 
Counts As Contact (All)float64fact[CampaignDS].[UARC_COCSBO].[ALL_COUNTS_AS_CONT] 
Campaign Send Countfloat64fact[CampaignDS].[UARC_COCSBO].[CAMP_SEND_COUNT] 
Delivered Countfloat64fact[CampaignDS].[UARC_COCSBO].[DELIVERED_COUNT] 
Undelivered Countfloat64fact[CampaignDS].[UARC_COCSBO].[UNDELIVERED_COUNT] 
Control Countfloat64fact[CampaignDS].[UARC_COCSBO].[CONTROL_COUNT] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign Offer Contact Statuses Breakout Star Schema
model/Campaign Offer Contact Statuses Breakout Star Schema.jpg
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 (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
CampToOffer (shortcut) [Model View].[CampToOffer]
Campaign Contact Status Breakout (shortcut) [Model View].[Campaign Contact Status Breakout]
Campaign Offer Contact Status Breakout (shortcut) [Model View].[Campaign Offer Contact Status Breakout]
Campaign Offer Contact Statuses Breakout Star SchemaCampaign Contact History SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ([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 Groupfloat64facttotal ([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 SummaryCampaign IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] 
Offer IDdecimalidentifier[Campaign Performance Summary Star Schema Base].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] 
Number of Offers Givenfloat64facttotal ([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 Groupfloat64facttotal ([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 Recipientsfloat64facttotal ([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 Groupfloat64facttotal ([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 Versionsfloat64facttotal ( [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 Groupfloat64facttotal ([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] ) 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Offer Performance by DayOffer Contact History by DayOffer IDdecimalidentifier[CampaignDS].[UARC_OCH_DY].[OFFERID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_OCH_DY].[ACTUALDATE] 
Number of Offers Givenfloat64facttotal ([CampaignDS].[UARC_OCH_DY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_OCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCH_DY].[ACTUALDATE] ) 
Number of Offers Given Control Groupfloat64facttotal ([CampaignDS].[UARC_OCH_DY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_OCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCH_DY].[ACTUALDATE] ) 
Number of Offer Versionsfloat64facttotal ([CampaignDS].[UARC_OCH_DY].[NUM_OFF_VERS] for [CampaignDS].[UARC_OCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCH_DY].[ACTUALDATE] ) 
Number of Offer Versions Control Groupfloat64facttotal ([CampaignDS].[UARC_OCH_DY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_OCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCH_DY].[ACTUALDATE] ) 
Unique Recipientsfloat64facttotal ([CampaignDS].[UARC_OCH_DY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_OCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCH_DY].[ACTUALDATE] ) 
Unique Recipients Control Groupfloat64facttotal ([CampaignDS].[UARC_OCH_DY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_OCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCH_DY].[ACTUALDATE] ) 
Offer Campaign Contact History by DayOffer IDdecimalidentifier[CampaignDS].[UARC_OCCH_DY].[OFFERID] 
Campaign IDdecimalidentifier[CampaignDS].[UARC_OCCH_DY].[CAMPAIGNID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_OCCH_DY].[ACTUALDATE] 
Number of Offers Givenfloat64facttotal ([CampaignDS].[UARC_OCCH_DY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_OCCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_DY].[ACTUALDATE] ) 
Number of Offers Given Control Groupfloat64facttotal ([CampaignDS].[UARC_OCCH_DY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_OCCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_DY].[ACTUALDATE] ) 
Number of Offer Versionsfloat64facttotal ([CampaignDS].[UARC_OCCH_DY].[NUM_OFF_VERS] for [CampaignDS].[UARC_OCCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_DY].[ACTUALDATE] ) 
Number of Offer Versions Control Groupfloat64facttotal ([CampaignDS].[UARC_OCCH_DY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_OCCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_DY].[ACTUALDATE] ) 
Unique Recipientsfloat64facttotal ([CampaignDS].[UARC_OCCH_DY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_OCCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_DY].[ACTUALDATE] ) 
Unique Recipients Control Groupfloat64facttotal ([CampaignDS].[UARC_OCCH_DY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_OCCH_DY].[OFFERID] ,[CampaignDS].[UARC_OCCH_DY].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_DY].[ACTUALDATE] ) 
Offer Campaign Response History by DayOffer IDdecimalidentifier[CampaignDS].[UARC_OCRH_DY].[OFFERID] 
Campaign IDdecimalidentifier[CampaignDS].[UARC_OCRH_DY].[CAMPAIGNID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_OCRH_DY].[ACTUALDATE] 
Response Transactionsfloat64fact[CampaignDS].[UARC_OCRH_DY].[RESP_TRANS]  
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_OCRH_DY].[RESP_TRANS_CG] 
Unique Respondersfloat64fact[CampaignDS].[UARC_OCRH_DY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_OCRH_DY].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_OCRH_DY].[NOT_CONT_RESP]  
Responses After Expirationfloat64fact[CampaignDS].[UARC_OCRH_DY].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_OCRH_DY].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64fact[CampaignDS].[UARC_OCRH_DY].[REVENUE_PER_RESP]  
Revenue Per Response Control Groupfloat64fact[CampaignDS].[UARC_OCRH_DY].[REV_PER_RESP_CG] 
Gross Revenuefloat64fact[CampaignDS].[UARC_OCRH_DY].[GROSS_REVENUE] 
Gross Revenue Control Groupfloat64fact[CampaignDS].[UARC_OCRH_DY].[GROSS_REVENUE_CG] 
Offer Response History by DayOffer Iddecimalidentifier[CampaignDS].[UARC_ORH_DY].[OFFERID] 
Actual DatedateTimeattribute[CampaignDS].[UARC_ORH_DY].[ACTUALDATE] 
Response Transactionsfloat64fact[CampaignDS].[UARC_ORH_DY].[RESP_TRANS] 
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_ORH_DY].[RESP_TRANS_CG] 
Unique Respondersfloat64fact[CampaignDS].[UARC_ORH_DY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_ORH_DY].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_ORH_DY].[NOT_CONT_RESP] 
Responses After Expirationfloat64fact[CampaignDS].[UARC_ORH_DY].[RESP_AFTER_EXP] 
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_ORH_DY].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64fact[CampaignDS].[UARC_ORH_DY].[REVENUE_PER_RESP] 
Revenue Per Response Control Groupfloat64fact[CampaignDS].[UARC_ORH_DY].[REV_PER_RESP_CG] 
Gross Revenuefloat64fact[CampaignDS].[UARC_ORH_DY].[GROSS_REVENUE] 
Gross Revenue Control Groupfloat64fact[CampaignDS].[UARC_ORH_DY].[GROSS_REVENUE_CG] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Offer Performance by Day Star Schema
model/Offer Performance by Day Star Schema.jpg
Offer Contact History by Day (shortcut) [Model View].[Offer Contact History by Day]
Offer Campaign Contact History by Day (shortcut) [Model View].[Offer Campaign Contact History by Day]
Offer Campaign Response History by Day (shortcut) [Model View].[Offer Campaign Response History by Day]
Offer Response History by Day (shortcut) [Model View].[Offer Response History by Day]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Calendar (shortcut) [Model View].[Calendar]
Offer Performance by MonthOffer Contact History by MonthOffer IDdecimalidentifier[CampaignDS].[UARC_OCH_MO].[OFFERID] 
Monthint64attribute[CampaignDS].[UARC_OCH_MO].[MONTH] 
Yearint64attribute[CampaignDS].[UARC_OCH_MO].[YEAR] 
Number of Offers Givenfloat64facttotal ([CampaignDS].[UARC_OCH_MO].[NUM_OF_OFFERS] for [CampaignDS].[UARC_OCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCH_MO].[YEAR],[CampaignDS].[UARC_OCH_MO].[MONTH] ) 
Number of Offers Given Control Groupfloat64facttotal ([CampaignDS].[UARC_OCH_MO].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_OCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCH_MO].[YEAR],[CampaignDS].[UARC_OCH_MO].[MONTH] ) 
Number of Offer Versionsfloat64facttotal ([CampaignDS].[UARC_OCH_MO].[NUM_OFF_VERS] for [CampaignDS].[UARC_OCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCH_MO].[YEAR],[CampaignDS].[UARC_OCH_MO].[MONTH] ) 
Number of Offer Versions Control Groupfloat64facttotal ([CampaignDS].[UARC_OCH_MO].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_OCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCH_MO].[YEAR],[CampaignDS].[UARC_OCH_MO].[MONTH] ) 
Unique Recipientsfloat64facttotal ([CampaignDS].[UARC_OCH_MO].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_OCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCH_MO].[YEAR],[CampaignDS].[UARC_OCH_MO].[MONTH] ) 
Unique Recipients Control Groupfloat64facttotal ([CampaignDS].[UARC_OCH_MO].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_OCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCH_MO].[YEAR],[CampaignDS].[UARC_OCH_MO].[MONTH] ) 
Offer Campaign Contact History by MonthOffer IDdecimalidentifier[CampaignDS].[UARC_OCCH_MO].[OFFERID] 
Campaign IDdecimalidentifier[CampaignDS].[UARC_OCCH_MO].[CAMPAIGNID] 
Monthint64attribute[CampaignDS].[UARC_OCCH_MO].[MONTH] 
Yearint64attribute[CampaignDS].[UARC_OCCH_MO].[YEAR] 
Number of Offers Givenfloat64facttotal ([CampaignDS].[UARC_OCCH_MO].[NUM_OF_OFFERS] for [CampaignDS].[UARC_OCCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_MO].[YEAR],[CampaignDS].[UARC_OCCH_MO].[MONTH] ) 
Number of Offers Given Control Groupfloat64facttotal ([CampaignDS].[UARC_OCCH_MO].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_OCCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_MO].[YEAR],[CampaignDS].[UARC_OCCH_MO].[MONTH] ) 
Number of Offer Versionsfloat64facttotal ([CampaignDS].[UARC_OCCH_MO].[NUM_OFF_VERS] for [CampaignDS].[UARC_OCCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_MO].[YEAR],[CampaignDS].[UARC_OCCH_MO].[MONTH] ) 
Number of Offer Versions Control Groupfloat64facttotal ([CampaignDS].[UARC_OCCH_MO].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_OCCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_MO].[YEAR],[CampaignDS].[UARC_OCCH_MO].[MONTH] ) 
Unique Recipientsfloat64facttotal ([CampaignDS].[UARC_OCCH_MO].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_OCCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_MO].[YEAR],[CampaignDS].[UARC_OCCH_MO].[MONTH] ) 
Unique Recipients Control Groupfloat64facttotal ([CampaignDS].[UARC_OCCH_MO].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_OCCH_MO].[OFFERID] ,[CampaignDS].[UARC_OCCH_MO].[CAMPAIGNID] ,[CampaignDS].[UARC_OCCH_MO].[YEAR],[CampaignDS].[UARC_OCCH_MO].[MONTH] ) 
Offer Campaign Response History by MonthOffer IDdecimalidentifier[CampaignDS].[UARC_OCRH_MO].[OFFERID] 
Campaign IDdecimalidentifier[CampaignDS].[UARC_OCRH_MO].[CAMPAIGNID] 
Monthdecimalattribute[CampaignDS].[UARC_OCRH_MO].[MONTH] 
Yeardecimalattribute[CampaignDS].[UARC_OCRH_MO].[YEAR] 
Response Transactionsfloat64fact[CampaignDS].[UARC_OCRH_MO].[RESP_TRANS]  
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_OCRH_MO].[RESP_TRANS_CG] 
Unique Respondersfloat64fact[CampaignDS].[UARC_OCRH_MO].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_OCRH_MO].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_OCRH_MO].[NOT_CONT_RESP]  
Responses After Expirationfloat64fact[CampaignDS].[UARC_OCRH_MO].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_OCRH_MO].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64fact[CampaignDS].[UARC_OCRH_MO].[REVENUE_PER_RESP]  
Revenue Per Response Control Groupfloat64fact[CampaignDS].[UARC_OCRH_MO].[REV_PER_RESP_CG] 
Gross Revenuefloat64fact[CampaignDS].[UARC_OCRH_MO].[GROSS_REVENUE] 
Gross Revenue Control Groupfloat64fact[CampaignDS].[UARC_OCRH_MO].[GROSS_REVENUE_CG] 
Offer Response History by MonthOffer Iddecimalidentifier[CampaignDS].[UARC_ORH_MO].[OFFERID] 
Monthdecimalattribute[CampaignDS].[UARC_ORH_MO].[MONTH] 
Yeardecimalattribute[CampaignDS].[UARC_ORH_MO].[YEAR] 
Response Transactionsfloat64fact[CampaignDS].[UARC_ORH_MO].[RESP_TRANS] 
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_ORH_MO].[RESP_TRANS_CG] 
Unique Respondersfloat64fact[CampaignDS].[UARC_ORH_MO].[UNIQUE_RESPONDERS] 
Unique Respondersroupfloat64fact[CampaignDS].[UARC_ORH_MO].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_ORH_MO].[NOT_CONT_RESP] 
Responses After Expirationfloat64fact[CampaignDS].[UARC_ORH_MO].[RESP_AFTER_EXP] 
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_ORH_MO].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64fact[CampaignDS].[UARC_ORH_MO].[REVENUE_PER_RESP] 
Revenue Per Response Control Groupfloat64fact[CampaignDS].[UARC_ORH_MO].[REV_PER_RESP_CG] 
Gross Revenuefloat64fact[CampaignDS].[UARC_ORH_MO].[GROSS_REVENUE] 
Gross Revenue Control Groupfloat64fact[CampaignDS].[UARC_ORH_MO].[GROSS_REVENUE_CG] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Offer Performance by Month Star Schema
model/Offer Performance by Month Star Schema.jpg
Offer Contact History by Month (shortcut) [Model View].[Offer Contact History by Month]
Offer Campaign Contact History by Month (shortcut) [Model View].[Offer Campaign Contact History by Month]
Offer Campaign Response History by Month (shortcut) [Model View].[Offer Campaign Response History by Month]
Offer Response History by Month (shortcut) [Model View].[Offer Response History by Month]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Calendar Month (shortcut) [Model View].[Calendar Month]
Offer Performance SummaryOffer Contact History SummaryOffer IDdecimalidentifier[CampaignDS].[UARC_OCH_SUMMARY].[OFFERID] 
Number of Offers Givenfloat64facttotal ([CampaignDS].[UARC_OCH_SUMMARY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_OCH_SUMMARY].[OFFERID] ) 
Number of Offers Given Control Groupfloat64facttotal ([CampaignDS].[UARC_OCH_SUMMARY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_OCH_SUMMARY].[OFFERID] ) 
Number of Offer Versionsfloat64facttotal ([CampaignDS].[UARC_OCH_SUMMARY].[NUM_OFF_VERS] for [CampaignDS].[UARC_OCH_SUMMARY].[OFFERID] ) 
Number of Offer Versions Control Groupfloat64facttotal ([CampaignDS].[UARC_OCH_SUMMARY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_OCH_SUMMARY].[OFFERID] ) 
Unique Recipientsfloat64facttotal ([CampaignDS].[UARC_OCH_SUMMARY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_OCH_SUMMARY].[OFFERID] ) 
Unique Recipients Control Groupfloat64facttotal ([CampaignDS].[UARC_OCH_SUMMARY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_OCH_SUMMARY].[OFFERID] ) 
Offer Campaign Contact History SummaryOffer IDdecimalidentifier[CampaignDS].[UARC_OCCH_SUMMARY].[OFFERID] 
Campaign IDdecimalidentifier[CampaignDS].[UARC_OCCH_SUMMARY].[CAMPAIGNID] 
Number of Offers Givenfloat64facttotal ([CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OF_OFFERS] for [CampaignDS].[UARC_OCCH_SUMMARY].[OFFERID] ,[CampaignDS].[UARC_OCCH_SUMMARY].[CAMPAIGNID] ) 
Number of Offers Given Control Groupfloat64facttotal ([CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OF_OFFERS_CG] for [CampaignDS].[UARC_OCCH_SUMMARY].[OFFERID] ,[CampaignDS].[UARC_OCCH_SUMMARY].[CAMPAIGNID] ) 
Number of Offer Versionsfloat64facttotal ([CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OFF_VERS] for [CampaignDS].[UARC_OCCH_SUMMARY].[OFFERID] ,[CampaignDS].[UARC_OCCH_SUMMARY].[CAMPAIGNID] ) 
Number of Offer Versions Control Groupfloat64facttotal ([CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OFF_VERS_CG] for [CampaignDS].[UARC_OCCH_SUMMARY].[OFFERID] ,[CampaignDS].[UARC_OCCH_SUMMARY].[CAMPAIGNID] ) 
Unique Recipientsfloat64facttotal ([CampaignDS].[UARC_OCCH_SUMMARY].[UNIQUE_RECIPIENTS] for [CampaignDS].[UARC_OCCH_SUMMARY].[OFFERID] ,[CampaignDS].[UARC_OCCH_SUMMARY].[CAMPAIGNID] ) 
Unique Recipients Control Groupfloat64facttotal ([CampaignDS].[UARC_OCCH_SUMMARY].[UNIQUE_RECIP_CG] for [CampaignDS].[UARC_OCCH_SUMMARY].[OFFERID] ,[CampaignDS].[UARC_OCCH_SUMMARY].[CAMPAIGNID] ) 
Offer Campaign Response History SummaryOffer IDdecimalidentifier[CampaignDS].[UARC_OCRH_SUMMARY].[OFFERID] 
Campaign IDdecimalidentifier[CampaignDS].[UARC_OCRH_SUMMARY].[CAMPAIGNID] 
Response Transactionsfloat64fact[CampaignDS].[UARC_OCRH_SUMMARY].[RESP_TRANS]  
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_OCRH_SUMMARY].[RESP_TRANS_CG] 
Unique Respondersfloat64fact[CampaignDS].[UARC_OCRH_SUMMARY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_OCRH_SUMMARY].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_OCRH_SUMMARY].[NOT_CONT_RESP]  
Responses After Expirationfloat64fact[CampaignDS].[UARC_OCRH_SUMMARY].[RESP_AFTER_EXP]  
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_OCRH_SUMMARY].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64factIF( [CampaignDS].[UARC_OCRH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OCRH_SUMMARY].[REVENUE_PER_RESP]) 
Revenue Per Response Control Groupfloat64factIF ([CampaignDS].[UARC_OCRH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OCRH_SUMMARY].[REV_PER_RESP_CG]) 
Gross Revenuefloat64factIF ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE]) 
Gross Revenue Control Groupfloat64factIF ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE_CG]) 
Offer Response History SummaryOffer Iddecimalidentifier[CampaignDS].[UARC_ORH_SUMMARY].[OFFERID] 
Response Transactionsfloat64fact[CampaignDS].[UARC_ORH_SUMMARY].[RESP_TRANS] 
Response Transactions Control Groupfloat64fact[CampaignDS].[UARC_ORH_SUMMARY].[RESP_TRANS_CG] 
Unique Respondersfloat64fact[CampaignDS].[UARC_ORH_SUMMARY].[UNIQUE_RESPONDERS] 
Unique Responders Control Groupfloat64fact[CampaignDS].[UARC_ORH_SUMMARY].[UNIQUE_RESP_CG] 
Not Contacted Respondersfloat64fact[CampaignDS].[UARC_ORH_SUMMARY].[NOT_CONT_RESP] 
Responses After Expirationfloat64fact[CampaignDS].[UARC_ORH_SUMMARY].[RESP_AFTER_EXP] 
Responses After Expiration Control Groupfloat64fact[CampaignDS].[UARC_ORH_SUMMARY].[RESP_AFTER_EXP_CG] 
Revenue Per Responsefloat64factIF ([CampaignDS].[UARC_ORH_SUMMARY].[REVENUE_PER_RESP] is missing) THEN (0) ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[REVENUE_PER_RESP]) 
Revenue Per Response Control Groupfloat64factIF ([CampaignDS].[UARC_ORH_SUMMARY].[REV_PER_RESP_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[REV_PER_RESP_CG]) 
Gross Revenuefloat64factIF([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE] is missing) THEN (0) ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE]) 
Gross Revenue Control Groupfloat64factIF ([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE_CG] is missing) THEN (0) ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE_CG]) 
Offer Performance Metrics SummaryOffer IDint64fact[CampaignDS].[UARC_OPM_SUMMARY].[OFFERID] 
Best Matchint32fact[CampaignDS].[UARC_OPM_SUMMARY].[BEST_MATCH] 
Best Match Control Groupint32fact[CampaignDS].[UARC_OPM_SUMMARY].[BEST_MATCH_CG] 
Fractional Matchfloat64fact[CampaignDS].[UARC_OPM_SUMMARY].[FRACTIONAL_MATCH] 
Multiple Matchfloat64fact[CampaignDS].[UARC_OPM_SUMMARY].[MULTIPLE_MATCH] 
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Offer Performance Summary Star Schema Base
model/Offer Performance Summary Star Schema Base.jpg
Offer Contact History Summary (shortcut) [Model View].[Offer Contact History Summary]
Offer Campaign Contact History Summary (shortcut) [Model View].[Offer Campaign Contact History Summary]
Offer Campaign Response History Summary (shortcut) [Model View].[Offer Campaign Response History Summary]
Offer Response History Summary (shortcut) [Model View].[Offer Response History Summary]
Offer Performance Metrics Summary (shortcut) [Model View].[Offer Performance Metrics Summary]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Offer Performance Summary Star Schema
model/Offer Performance Summary Star Schema.jpg
Offer Campaign Response History Summary (shortcut) [Model View].[Offer Campaign Response History Summary]
Offer Response History Summary (shortcut) [Model View].[Offer Response History Summary]
Offer Performance Metrics Summary (shortcut) [Model View].[Offer Performance Metrics Summary]
Campaign (shortcut) [Model View].[Campaign]
Offer (shortcut) [Model View].[Offer]
Offer Performance Summary Star SchemaOffer Campaign Contact History SummaryOffer IDdecimalidentifier[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID] 
Campaign IDdecimalidentifier[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] 
Number of Offers Givenfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Number of Offers Given] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Number of Offers Given Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Number of Offers Given Control Group] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Number of Offer Versionsfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Number of Offer Versions] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Number of Offer Versions Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Number of Offer Versions Control Group] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Unique Recipientsfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Unique Recipients] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Unique Recipients Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Unique Recipients Control Group] for [Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Offer ID],[Offer Performance Summary Star Schema Base].[Offer Campaign Contact History Summary][Model View].[Offer Campaign Contact History Summary].[Campaign ID] ) 
Offer Contact History SummaryOffer IDdecimalidentifier[Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] 
Number of Offers Givenfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Number of Offers Given] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Number of Offers Given Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Number of Offers Given Control Group] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Number of Offer Versionsfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Number of Offer Versions] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Number of Offer Versions Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Number of Offer Versions Control Group] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Unique Recipientsfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Unique Recipients] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Unique Recipients Control Groupfloat64facttotal ([Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Unique Recipients Control Group] for [Offer Performance Summary Star Schema Base].[Offer Contact History Summary][Model View].[Offer Contact History Summary].[Offer ID] ) 
Import View
model/Import View.jpg
Namespace/FolderQuery SubjectQuery ItemTypeUsageRef Obj/Expr.
Campaign CommonUARC_CAMPAIGNCAMPAIGNIDdecimalfact 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
CAMPAIGNCODEcharacterLength16attribute 
OBJECTIVEScharacterLength16attribute 
LASTRUNDATEdateTimeidentifier 
INITIATIVEcharacterLength16attribute 
CREATEDATEdateTimeidentifier 
UPDATEDATEdateTimeidentifier 
STARTDATEdateTimeidentifier 
ENDDATEdateTimeidentifier 
CREATEBYint64fact 
UPDATEBYint64fact 
RUNBYint64fact 
UARC_OFFEROFFERIDdecimalfact 
NAMEcharacterLength16attribute 
DESCRIPTIONcharacterLength16attribute 
OFFERCODE1characterLength16attribute 
OFFERCODE2characterLength16attribute 
OFFERCODE3characterLength16attribute 
OFFERCODE4characterLength16attribute 
OFFERCODE5characterLength16attribute 
CREATEDATEdateTimeidentifier 
CREATEBYint64fact 
UPDATEDATEdateTimeidentifier 
UPDATEBYint64fact 
RETIREDint64fact 
UARC_CELLCELLIDdecimalfact 
CELLNAMEcharacterLength16attribute 
CELLCODEcharacterLength16attribute 
CONTROLCELLIDdecimalfact 
ISCONTROLint64fact 
CAMPAIGNIDdecimalfact 
UARC_CAMPTOOFFEROFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
UARC_CALENDARDATEIDdecimalfact 
YEARint64fact 
FISCALYEARint64fact 
QUARTERint64fact 
FISCALQUARTERint64fact 
MONTHint64fact 
WEEKOFYEARint64fact 
WEEKOFMONTHint64fact 
DAYOFYEARint64fact 
DAYOFMONTHint64fact 
DAYOFWEEKint64fact 
ACTUALDATEdateTimeidentifier 
FIRSTDAYOFWEEKdateTimeidentifier 
LASTDAYOFWEEKdateTimeidentifier 
UARC_TIMETIMEIDdecimalfact 
HOURint64fact 
MINUTEint64fact 
Campaign PerformanceUARC_CCCH_DYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_CCCH_MOCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
MONTHint64fact 
YEARint64fact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_CCH_DYCAMPAIGNIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_CCH_MOCAMPAIGNIDdecimalfact 
MONTHint64fact 
YEARint64fact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_CCRH_DYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
RESP_TRANSfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_TRANS_CGfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CCRH_MOCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
MONTHint64fact 
YEARint64fact 
RESP_TRANSfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_TRANS_CGfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_COCH_DYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_COCH_MOCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
MONTHint64fact 
YEARint64fact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_COCH_SUMMARYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_CORH_DYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
RESP_TRANSfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_TRANS_CGfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CORH_MOCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
MONTHint64fact 
YEARint64fact 
RESP_TRANSfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_TRANS_CGfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CORH_SUMMARYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
RESP_TRANSfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_TRANS_CGfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CRH_DYCAMPAIGNIDdecimalfact 
ACTUALDATEdateTimeidentifier 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CRH_MOCAMPAIGNIDdecimalfact 
MONTHint64fact 
YEARint64fact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CCCH_SUMMARYCAMPAIGNIDint64fact 
CELLIDint64fact 
NUM_OF_OFFERSint32fact 
NUM_OF_OFFERS_CGint32fact 
NUM_OFF_VERSint32fact 
NUM_OFF_VERS_CGint32fact 
UNIQUE_RECIPIENTSint32fact 
UNIQUE_RECIP_CGint32fact 
UARC_CCH_SUMMARYCAMPAIGNIDdecimalfact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_CCRH_SUMMARYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
RESP_TRANSfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_TRANS_CGfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CRH_SUMMARYCAMPAIGNIDdecimalfact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CCOCH_DYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_CCOCH_MOCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
MONTHint64fact 
YEARint64fact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_CCOCH_SUMMARYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_CCORH_DYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CCORH_MOCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
MONTHint64fact 
YEARint64fact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_CCORH_SUMMARYCAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
OFFERIDdecimalfact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_COCCH_DYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_COCCH_MOCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
MONTHint64fact 
YEARint64fact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_COCCH_SUMMARYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_COCRH_DYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_COCRH_MOCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
MONTHint64fact 
YEARint64fact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_COCRH_SUMMARYCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
CELLIDdecimalfact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
Campaign BreakoutUARC_CORBOCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
ALL_COUNTS_AS_RESPfloat64fact 
ALL_RESPONSESfloat64fact 
EXPLORE_COUNTfloat64fact 
EXPLORE_COUNT_CGfloat64fact 
CONSIDER_COUNTfloat64fact 
CONSIDER_COUNT_CGfloat64fact 
COMMIT_COUNTfloat64fact 
COMMIT_COUNT_CGfloat64fact 
FULFILL_COUNTfloat64fact 
FULFILL_COUNT_CGfloat64fact 
USAGE_COUNTfloat64fact 
USAGE_COUNT_CGfloat64fact 
UARC_CRBOCAMPAIGNIDdecimalfact 
ALL_COUNTS_AS_RESPfloat64fact 
ALL_RESPONSESfloat64fact 
EXPLORE_COUNTfloat64fact 
EXPLORE_COUNT_CGfloat64fact 
CONSIDER_COUNTfloat64fact 
CONSIDER_COUNT_CGfloat64fact 
COMMIT_COUNTfloat64fact 
COMMIT_COUNT_CGfloat64fact 
FULFILL_COUNTfloat64fact 
FULFILL_COUNT_CGfloat64fact 
USAGE_COUNTfloat64fact 
USAGE_COUNT_CGfloat64fact 
UARC_CCSBOCAMPAIGNIDdecimalfact 
ALL_CONTACTSfloat64fact 
ALL_COUNTS_AS_CONTfloat64fact 
CAMP_SEND_COUNTfloat64fact 
DELIVERED_COUNTfloat64fact 
UNDELIVERED_COUNTfloat64fact 
CONTROL_COUNTfloat64fact 
UARC_COCSBOCAMPAIGNIDdecimalfact 
OFFERIDdecimalfact 
ALL_CONTACTSfloat64fact 
ALL_COUNTS_AS_CONTfloat64fact 
CAMP_SEND_COUNTfloat64fact 
DELIVERED_COUNTfloat64fact 
UNDELIVERED_COUNTfloat64fact 
CONTROL_COUNTfloat64fact 
Campaign Custom AttributesUARC_CAMPEXTATTRCAMPAIGNIDdecimalfact 
UARC_OFFEREXTATTROFFER_FIXED_COSTfloat64fact 
EFFECTIVE_DATEdateTimeidentifier 
REVENUE_PER_RESPfloat64fact 
OFFER_FULFILL_COSTfloat64fact 
EXPIRATION_DATEdateTimeidentifier 
OFFERIDdecimalfact 
EXPIRATION_DURfloat64fact 
CHANNELcharacterLength16attribute 
COST_PER_CONTACTfloat64fact 
UARC_CELLEXTATTRCELLIDdecimalfact 
Offer PerformanceUARC_OCCH_DYOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_OCCH_MOOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
MONTHint64fact 
YEARint64fact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_OCCH_SUMMARYOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_OCH_DYOFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_OCH_MOOFFERIDdecimalfact 
MONTHint64fact 
YEARint64fact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_OCH_SUMMARYOFFERIDdecimalfact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_OCRH_DYOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
ACTUALDATEdateTimeidentifier 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_OCRH_MOOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
MONTHint64fact 
YEARint64fact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_OCRH_SUMMARYOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_ORH_DYOFFERIDdecimalfact 
ACTUALDATEdateTimeidentifier 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_ORH_MOOFFERIDdecimalfact 
MONTHint64fact 
YEARint64fact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_ORH_SUMMARYOFFERIDdecimalfact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_OPM_SUMMARYOFFERIDint64fact 
BEST_MATCHint32fact 
BEST_MATCH_CGint32fact 
FRACTIONAL_MATCHfloat64fact 
MULTIPLE_MATCHfloat64fact 
REVENUE_PER_RESPint64fact 
REV_PER_RESP_CGint64fact 
GROSS_REVENUEint64fact 
GROSS_REVENUE_CGint64fact 
UARC_OCCCH_DYOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_OCCCH_MOOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
MONTHint64fact 
YEARint64fact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_OCCCH_SUMMARYOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
NUM_OF_OFFERSfloat64fact 
NUM_OF_OFFERS_CGfloat64fact 
NUM_OFF_VERSfloat64fact 
NUM_OFF_VERS_CGfloat64fact 
UNIQUE_RECIPIENTSfloat64fact 
UNIQUE_RECIP_CGfloat64fact 
UARC_OCCRH_DYOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
ACTUALDATEdateTimeidentifier 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_OCCRH_MOOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
MONTHint64fact 
YEARint64fact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
UARC_OCCRH_SUMMARYOFFERIDdecimalfact 
CAMPAIGNIDdecimalfact 
CELLIDdecimalfact 
RESP_TRANSfloat64fact 
RESP_TRANS_CGfloat64fact 
UNIQUE_RESPONDERSfloat64fact 
UNIQUE_RESP_CGfloat64fact 
NOT_CONT_RESPfloat64fact 
RESP_AFTER_EXPfloat64fact 
RESP_AFTER_EXP_CGfloat64fact 
REVENUE_PER_RESPfloat64fact 
REV_PER_RESP_CGfloat64fact 
GROSS_REVENUEfloat64fact 
GROSS_REVENUE_CGfloat64fact 
Copyright

© Copyright Unica Corporation 2003 - 2010. All rights reserved.

Unica Corporation
Reservoir Place North
170 Tracer Lane
Waltham, MA 02451-1379
Examples and Data

All software and related documentation is subject to restrictions on use and disclosure as set forth in the Unica Software License and Services Agreement, with restricted rights for U.S. government users and applicable export regulations.

Companies, names, and data used in examples herein are fictitious unless otherwise noted.

Trademarks and Patents

Unica®, the Unica logo, Affinium®, MarketingCentral®, MarketSoft®, MarketSoft logo, DemandMore®, Leads to Revenue®, NetTracker®, My NetTracker®, and Ask NetTracker® are registered trademarks of Unica Corporation with the U.S. Patent and Trademark Office.

Affinium Campaign™, Affinium Campaign Collaborate™, Affinium Campaign eMessage™, Affinium Campaign Interact™, Affinium Campaign Optimize™, Affinium Detect™, Affinium Leads™, Affinium Leads Referral™, Affinium Leads Contact™, Affinium Model™, Affinium NetInsight™, Affinium Insight™, Affinium Plan™, Affinium Mart™, Universal Dynamic Interconnect™, Interconnect Modules™, Marketic™, Powering Marketing Success™, Drill Anywhere™, Marketing Objects™, Trend Anything™, Customer Value Maximization™, MAP™, One-to-One Optimization™, and Right-time Marketing™ are trademarks of Unica Corporation. All other trademarks are the property of their respective owners.

Portions of the software described in this document are covered by U.S. Patent Numbers: 6,317,752, 6,269,325, 6,542,894, and 6,782,390.

The NetTracker, Affinium Insight, and Affinium NetInsight products are licensed under the following patents and patent publications: US5,675,510, US6,115,680, US6,108,637, US5,796,952, US6,138,155, US6,653,696, US6,763,386, AU0701813, BR9609217, CA2223919, EP0843946, JP03317705, MX193614, NO09705728, AU735285, CA2246746, CN1174316, CN1547123, CN1547124, DK870234, DE69720186, ES2195170, AU727170, BR9808033, CA2284530, CN1251669, IL131871, JP2000514942, KR341110, NZ337756, WO9641495, EP0870234, EP1130526, EP1168196, US20040078292, WO9810349, US20050114511, US20040221033, WO9843380.

Markup functionality in Affinium Plan is enabled through use of third-party software components from AdLib™ eDocument Solutions and Adobe® Acrobat®. "Powered by AdLib™."

NOTICE: This document contains confidential and proprietary information of Unica Corporation ("Unica"). Use, duplication, or disclosure without the express written consent of Unica Corporation is prohibited.