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 |
|
This table stores the basic Contact Summary data of all the audiences. |
UARC_DTL_CONTACTS |
|
This table stores the detailed Contact Summary data of all the audiences. |
UARC_RESPONSES |
|
This table stores the Responses Summary data of all the audiences. |
UARC_RESPONSE_BREAKOUT |
|
This table stores the Response Types summary data. |
UARC_CAMPAIGN_RESPONDERS |
|
This table stores the summary data of all the Campaign responders. |
UARC_CAMPOFFER_RESPONDERS |
|
This table stores the summary data of all the Campaign responders and Offer responders. |
UARC_OFFER_RESPONDERS |
|
This table stores the summary data of all the Offer responders. |
UARC_CAMPAIGN_SUMMARY |
|
Stores the following data for all the Campaigns:
|