Welcome
Reports
Unica Open Insights
Appendix
Appendix: Unica Deliver
Deliver Dimensions and Measures in Google Looker for WhatsApp Channel
The measures and dimensions for the various options of the WhatsApp channel, in the Explore View, 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
    - Appendix: Unica Deliver
      - Deliver Explore View in Google Looker
        The following topics lists the available options in the Explore View for each channel of Deliver. The end user sees the Explore View. The Database Object Name and Model Internal Name are for administrators or developers.
      - Deliver Data Model Dimensions in Google Looker
        The following table provides information about available dimensions, descriptions, and their data types in the Explore View:
      - Deliver Data Model Dimensions for Detailed Recipients Analysis in Google Looker
        The following table lists dimensions for Email Campaign Recipient Details, SMS Campaign Recipient Details, Mobile Campaign Recipient Details and WhatsApp Campaign Recipient Details:
      - Deliver Data Model Dimensions for Date and Time in Google Looker
        The following table lists the Date and Time dimensions for trend analysis:
      - Common Measures for Deliver in Google Looker
      - Deliver Dimensions and Measures in Google Looker for the Email Channel - Part 1
        The measures and dimensions for the various options of the Email channel, in the Explore View, are as follows:
      - Deliver Dimensions and Measures in Google Looker for the Email Channel - Part 2
        The measures and dimensions for the various options of the Email channel, in the Explore View, are as follows:
      - Deliver Dimensions and Measures in Google Looker for Landing Page Channel
        The measures and dimensions for the various options of the Landing Page channel, in the Explore View, are as follows:
      - Deliver Dimensions and Measures in Google Looker for Mobile Push Channel
        The measures and dimensions for the various options of the Mobile Push channel, in the Explore View, are as follows:
      - Deliver Dimensions and Measures in Google Looker for SMS Channel
        The measures and dimensions for the various options of the SMS channel, in the Explore View, are as follows:
      - Deliver Dimensions and Measures in Google Looker for WhatsApp Channel
        The measures and dimensions for the various options of the WhatsApp channel, in the Explore View, are as follows:
  - 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

Deliver Dimensions and Measures in Google Looker for WhatsApp Channel

The measures and dimensions for the various options of the WhatsApp channel, in the Explore View, are as follows:

Table 1. Dimensions
Dimensions	WhatsApp Campaign Summary	WhatsApp Campaign Summary by Hour	WhatsApp Recipients Summary
Campaign Code
Campaign ID
Campaign Name
Cell Code
Container ID
Container Name
Date Fields
> Contact Date
> Contact Hour of Day
> Contact Month
> Contact Quarter
> Contact Time
> Contact Week
> Contact Year
> Response Date
> Response Hour of Day
> Response Month
> Response Quarter
> Response Time
> Response Week
> Response Year
Mailing Code
Mailing Instance
Masked Mobile No
Mobile No

Table 2. Measures
Dimensions	WhatsApp Campaign Summary	WhatsApp Campaign Summary by Hour	WhatsApp Recipients Summary
Count
Total Delivered
Total Failed
Total Pending
Total Sent
Total Views