Campaign Database Model Views

The following table lists the database tables and fields that will be used by Open Insights to store the required data for generating reports.


Table Name	Fields	Description
`UARC_CONTACTS`	`CAMPAIGNID` `CELLID` `OFFERID` `OFFERHISTORYID` `PACKAGEID` `TREATMENTINSTID` `TREATMENTCODE` `CONTACTDATE` `OFFERS` `OFFERS_CG` `CTRLTREATFLAG` `CTRLTREATMENTINSTID` `FCRUNID` `FCRUNDATE` `FLOWCHARID` `EFFECTIVEDATE` `EXPDATE` `INSERTDATE`	This table stores the basic Contact Summary data of all the audiences.
`UARC_DTL_CONTACTS`	`CAMPAIGNID` `CELLID` `OFFERID` `OFFERHISTORYID` `PACKAGEID` `TREATMENTINSTID` `TREATMENTCODE` `CONTACTDATE` `OFFERS` `OFFERS_CG` `CTRLTREATFLAG` `CTRLTREATMENTINSTID` `FCRUNID` `FCRUNDATE` `FLOWCHARID` `EFFECTIVEDATE` `EXPDATE` `INSERTDATE`	This table stores the detailed Contact Summary data of all the audiences.
`UARC_RESPONSES`	`CAMPAIGNID` `CELLID` `OFFERID` `OFFERHISTORYID` `TREATMENTINSTID` `RESPONSEPACKID` `RESPONSEDATEDATE,` `RESPONSES` `RESPONSES_CG` `NOT_CONTACTED_RESPONDERS` `RESPONSE_AFTER_EXPIRATION` `RESPONSE_AFTER_EXPIRATION_CG` `REVENUE_PER_RESPONSE` `REVENUE_PER_RESPONSE_CG` `GROSS_REVENUE` `GROSS_REVENUE_CG` `INSERTDATE`	This table stores the Responses Summary data of all the audiences.
`UARC_RESPONSE_BREAKOUT`	`CAMPAIGNID` `OFFERID` `OFFERHISTORYID` `ALL_COUNTS_AS_RESP` `ALL_RESPONSES` `EXPLORE_COUNT` `EXPLORE_COUNT_CG` `CONSIDER_COUNT` `CONSIDER_COUNT_CG` `COMMIT_COUNT` `COMMIT_COUNT_CG` `FULFILL_COUNT` `FULFILL_COUNT_CG` `USAGE_COUNT` `USAGE_COUNT_CG` `LINKCLICK_COUNT` `LINKCLICK_COUNT_CG` `LANDINGPAGE_COUNT` `LANDINGPAGE_COUNT_CG` `SMSREPLYMESSAGE_COUNT` `SMSREPLYMESSAGE_COUNT_CG` `INSERTDATE`	This table stores the Response Types summary data.
`UARC_CAMPAIGN_RESPONDERS`	`CAMPAIGNID` `UNIQUE_RESPONDERS` `UNIQUE_RESPONDERS_CG` `INSERTDATE`	This table stores the summary data of all the Campaign responders.
`UARC_CAMPOFFER_RESPONDERS`	`CAMPAIGNID` `OFFERID` `UNIQUE_RESPONDERS` `UNIQUE_RESPONDERS_CG` `INSERTDATE`	This table stores the summary data of all the Campaign responders and Offer responders.
`UARC_OFFER_RESPONDERS`	`RESPONSEDATE` `UNIQUE_RESPONDERS` `UNIQUE_RESPONDERS_CG` `INSERTDATE`	This table stores the summary data of all the Offer responders.
`UARC_CAMPAIGN_SUMMARY`	`CAMPAIGNID` `CELLID` `OFFERID` `OFFERHISTORYID` `TREATMENTINSTID` `CONTACTDATE` `PACKAGEID` `TREATMENTCODE` `CTRLTREATFLAG` `CTRLTREATMENTINSTID` `FCRUNID` `FCRUNDATE` `FLOWCHARID` `EFFECTIVEDATE` `EXPDATE` `OFFERS` `OFFERS_CG` `RESPONSES` `RESPONSES_CG` `NOT_CONTACTED_RESPONDERS` `RESPONSE_AFTER_EXPIRATION` `RESPONSE_AFTER_EXPIRATION_CG` `AVG_COST_PER_CONTACT` `OFFER_FIXED_COST` `CONTACT_COST` `REVENUE_PER_RESPONSE` `REVENUE_PER_RESPONSE_CG` `GROSS_REVENUE` `GROSS_REVENUE_CG`	Stores the following data for all the Campaigns: Offer and Cells contact Responses summary Financial data