Home
Reports
Unica Open Insights User Guide
Appendix
Appendix: Unica Campaign
Campaign Explore View in Google Looker
The following topics lists the available options in the Explore View for each channel of Campaign. The end user sees the Explore View. The Database Object Name and Model Internal Name are for administrators or developers.

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.
  - 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
    - Appendix: Important References for Unica Open Insights
      The following sections contain important references related to Unica Open Insights for the supported Unica applications.
    - Appendix: Unica Campaign
      - Campaign Explore View in Google Looker
        The following topics lists the available options in the Explore View for each channel of Campaign. The end user sees the Explore View. The Database Object Name and Model Internal Name are for administrators or developers.
      - 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.
      - Campaign Measures and Dimensions - Part 1
        The measures and dimensions for Campaign, Offer, Cell, Contact and Response History, and Response Trend are as follows:
      - Campaign Measures and Dimensions - Part 2
        The measures and dimensions for Response Breakout, Campaign Responders, Offer Responders, Campaign and Offer Responders, and Daily Responders are as follows:
    - Appendix: Unica Deliver
  - 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 Explore View in Google Looker

The following topics lists the available options in the Explore View for each channel of Campaign. The end user sees the Explore View. The Database Object Name and Model Internal Name are for administrators or developers.

Campaign


Explore View	1.Campaign Summary
Database Object Name	`USM_USER` `UARC_CAMPAIGN` `UARC_CELL` `UARC_CAMPAIGN_SUMMARY` `UARC_OFFER`
Model Internal Name	Campaigns Cells Contact and Response History Offers


Explore View	2.Campaign Response Trend
Database Object Name	`UARC_CAMPAIGN` `UARC_OFFER` `UARC_RESPONSES`
Model Internal Name	Campaigns Offers Response Trend


Explore View	3.Campaign Response Breakout
Database Object Name	`UARC_CAMPAIGN` `UARC_OFFER` `UARC_RESPONSE_BREAKOUT`
Model Internal Name	Campaigns Offers Response Breakout

Campaign Responders


Explore View	1.Campaign Responders
Database Object Name	`UARC_CONTACTS_ALL` `UARC_CAMPAIGN_RESPONDERS`
Model Internal Name	Campaign Responders


Explore View	2.Offer Responders
Database Object Name	`UARC_CONTACTS_ALL` `UARC_OFFER_RESPONDERS`
Model Internal Name	Offer Responders


Explore View	3.Campaign and Offer Responders
Database Object Name	`UARC_CONTACTS_ALL` `UARC_CAMPOFFER_RESPONDERS`
Model Internal Name	Campaign Responders


Explore View	4.Daily Responders
Database Object Name	`UARC_DAILY_RESPONDERS`
Model Internal Name	Campaign Responders

Platform


Explore View	1.Platform Users
Database Object Name	`USM_USER`
Model Internal Name	usm_user

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.