Welcome
Reports
Unica Open Insights
Appendix
Appendix: Unica Campaign
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:

Release Notes
System Requirements
GDPR Guide
The GDPR has been adopted by the European Union (��EU"). It establishes a stronger data protection regulatory framework for processing of personal data of individuals, impacts HCL and HCL's client contracts, policies and procedures when handling personal data.
User Guide
Unica Deliver is a web-based, enterprise scale marketing message solution that you can use to conduct outbound bulk messaging and transactional messaging campaigns. Deliver integrates with Unica Campaign and with secure message composition, transmission, and tracking resources that are hosted by Unica.
Administrator Guides
Domain Name Options for Email
System Tables and Data Dictionary
Licensing Guide
Glossary
Reports
- Unica Insights Reports
- Cognos
- Unica Open Insights
  - 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.
- Superset Reports
PDFs
Notices

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:


Measures and Dimensions	Response Breakout	Campaign Responders	Offer Responders	Campaign and Offer Responders	Daily Responders
All Counts as Responses
All Responses
Avg Cost Per Contact
Avg Revenue Per Response
Avg Revenue Per Response Control
Campaign Code
Campaign ID
Campaign Name
Cell Code
Cell ID
Cell Name
Cell Name
Cell Type
Commit Count
Commit Count Control Group
Consider Count
Consider Count Control Group
Contact Cost
Contacts
Contacts Control Group
Control Cell ID
Create By
Create Date
Description
End Date
Explore Count
Explore Count Control Group
Fulfill Count
Fulfill Count Control Group
Gross Revenue
Gross Revenue Control Group
Initiative
Last Run Date
Net Profit
Not Contacted Responses
Objectives
Offer Code
Offer Code 1
Offer Code 2
Offer Code 3
Offer Code 4
Offer Code 5
Offer Code 6
Offer Fixed Cost
Offer History ID
Offer Name
Offer nID
Percent Unique Responders
Percent Unique Responders Control Group
Recipients
Recipients Control Group
Responses After Expiration
Responses After Expiration Control Group
Response Date
Response Rate
Response Rate Control Group
Responses
Responses Control Group
Retired
Return on Investment
Run By
Start Date
Total Revenue
Unique Responders
Unique Responders Control Group
Update By
Update Date