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
    - 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.

Deliver Data Model Dimensions for Date and Time in Google Looker

The following table lists the Date and Time dimensions for trend analysis:


Common Dimension	Data Type	Channel	Description
Contact Date	Date	Email Landing Page Mobile SMS WhatsApp	The date when contact was made by a channel (drill-up is available).
Contact Month	Date	Email Landing Page Mobile SMS WhatsApp	The month when contact was made by a channel (drill-up and drill-down are available).
Contact Quarter	Date	Email Landing Page Mobile SMS WhatsApp	The quarter when contact was made by a channel (drill-up and drill-down are available).
Contact Year	Date	Email Landing Page Mobile SMS WhatsApp	The year when contact was made by a channel (drill-up and drill-down are available).
Contact Time	Time	Mobile SMS WhatsApp	Actual contact time (drill-up is available).


Common Dimension	Data Type	Channel	Description
Response Date	Date	Email Landing Page Mobile SMS WhatsApp	The date when response was received (drill-up is available).
Response Month	Date	Email Landing Page Mobile SMS WhatsApp	The month when response was received (drill-up and drill-down are available).
Response Quarter	Date	Email Landing Page Mobile SMS WhatsApp	The quarter when response was received (drill-up and drill-down are available).
Response Year	Date	Email Landing Page Mobile SMS WhatsApp	The year when response was received (drill-up and drill-down are available).
Response Hour of the Day	Number		The hour when the actual response was received.
Contact Time	Time	Mobile SMS WhatsApp	Actual response time (drill-up is available).

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.