Home
Reports
Unica Open Insights User Guide
Open Insights for Campaign
From version 12.1.2, Unica Open Insights supports Unica Campaign.
Campaign Database Object Details
Campaign and Platform has a list of database objects that define the Campaign data model. Please refer the following table for the database object names and their description:

Reports
- Unica Insights Reports Installation and Configuration Guide
- Unica Open Insights User Guide
  - Unica Open Insights Overview
    Unica Open Insights is an open data model framework that integrates with popular Business Intelligence (BI) tools to help visualize the data and generate reports as per business requirements.
  - Install or Upgrade Unica Open Insights
    If you are a new user, you must install Unica Open Insights. If you are an existing user, you must upgrade Unica Open Insights.
  - Google Looker User Interface Layout
    This chapter, and the topics in this chapter, are specific to the integrated Google Looker application. Google Looker has a simple and intuitive user interface. The Explore menu contains the various exploration views of Unica Open Insights.
  - Open Insights for Campaign
    From version 12.1.2, Unica Open Insights supports Unica Campaign.
    - Creating User Attributes in Google Looker
      Complete the following steps to add user attributes for Platform schema name in Google Looker administration:
    - Campaign Database Object Details
      Campaign and Platform has a list of database objects that define the Campaign data model. Please refer the following table for the database object names and their description:
  - Support for Campaign Custom Attributes
    From version 12.1.3, Unica Open Insights supports Unica Campaign custom attributes. It can be Campaign, Offer, or Cell attributes. If you are already using these attributes, you must configure the attributes for reporting.
  - Open Insights for Deliver
    In release 12.1.1, Open Insights started with support for Unica Deliver
  - Appendix
  - Before you contact HCL technical support
    If you encounter a problem that you cannot resolve by referring the documentation, your company's designated support contact can log a call with HCL technical support. Use these guidelines to ensure that your problem is resolved efficiently and successfully.

Campaign Database Object Details

Campaign and Platform has a list of database objects that define the Campaign data model. Please refer the following table for the database object names and their description:

Table 1. Campaign Database Object Details
Database Object Name	Description
Platform Database Object
`USM_USER`	Lists the Unica users who have created Campaigns.
Campaign Database Objects
`UARC_CAMPAIGN`	Lists all the Campaigns and the fields related to the Campaigns.
`UARC_OFFER`	Lists all the Offers and the fields related to the Offers.
`UARC_CELL`	Lists all the Segments and the fields related to the Segments.
`UARC_CAMPAIGN_SUMMARY`	Lists the Contact and Response History of all Campaigns along with the following measurements: Cost Revenue Return on Investments (ROI)
`UARC_CONTACTS_ALL`	Lists the Contact History data of all the Campaigns.
`UARC_RESPONSES`	Lists the Response History data of all the Campaigns.
`UARC_CAMPAIGN_RESPONDERS`	Lists the Responders of all Campaigns.
`UARC_OFFER_RESPONDERS`	Lists the Responders of all Offers.
`UARC_CAMPOFFER_RESPONDERS`	Lists the Responders of all Campaigns and Offers.
`UARC_DAILY_RESPONDERS`	Lists the Daily Responders across all Campaigns.

Note: For more information on Campaign database objects related to Google Looker, see Campaign Explore View in Google Looker.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.