Home
Reports
Unica Open Insights User Guide
Appendix
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.

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 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 All Channels


Explore View	Channels Comparison
Database Object Name	`UARE_CHANNELS_PERFORMANCE`
Model Internal Name	`all_channels_performance`

Deliver Email


Explore View	1.Email Campaign Summary
Database Object Name	`UARE_EMAIL_OVERVIEW`
Model Internal Name	`uare_email_overview`


Explore View	2.Email Campaign Summary by day
Database Object Name	`UARE_EMAIL_DAY`
Model Internal Name	`uare_email_day`


Explore View	3.Email Campaign Response Analysis by Hour
Database Object Name	`UARE_EMAIL_HOUR`
Model Internal Name	`uare_email_hour`


Explore View	4.Email Campaign Recipient Details
Database Object Name	`UARE_EMAIL_RECIPIENT_CLICK`
Model Internal Name	`uare_email_recipient_click`


Explore View	5.Email Campaign Unsubscribe Summary
Database Object Name	`UARE_UNSUBSCRIBE_EMAIL`
Model Internal Name	`uare_unsubscribe_email`


Explore View	6.Email Campaign Link Summary
Database Object Name	`UARE_EMAIL_OVERVIEW`
Model Internal Name	`uare_email_link_overview`


Explore View	7.Email Campaign Link Summary by Day
Database Object Name	`UARE_EMAIL_DAY`
Model Internal Name	`uare_email_link_day`


Explore View	8.Email A/B test Campaign Overview
Database Object Name	`UARE_ABEMAIL_OVERVIEW`
Model Internal Name	`uare_abemail_overview`

Deliver Landing Page


Explore View	1.Landing Page Summary
Database Object Name	`UARE_LP_OVERVIEW`
Model Internal Name	`uare_lp_overview`


Explore View	2.Landing Page Summary by Day
Database Object Name	`UARE_LP_DAY`
Model Internal Name	`uare_lp_day`


Explore View	3.Landing Page Link Overview
Database Object Name	`UARE_LP_OVERVIEW`
Model Internal Name	`uare_lp_link_overview`


Explore View	4.Landing Page Link Summary by Day
Database Object Name	`UARE_LP_DAY`
Model Internal Name	`uare_lp_day`

Deliver Mobile


Explore View	1.Mobile Push Summary by Hour
Database Object Name	`UARE_MOBILE_OVERVIEW`
Model Internal Name	`uare_mobile_overview`


Explore View	2.Mobile Push Recipients Summary
Database Object Name	`UARE_MOBILE_RECIPIENT_CLICK`
Model Internal Name	`uare_mobile_recipient_click`

Deliver SMS


Explore View	1.SMS Campaign Summary
Database Object Name	`UARE_SMS_OVERVIEW`
Model Internal Name	`uare_sms_overview`


Explore View	2.SMS Campaign Summary by Hour
Database Object Name	`UARE_SMS_DAY`
Model Internal Name	`uare_sms_day`


Explore View	3.SMS Campaign Link Summary by Hour
Database Object Name	`UARE_SMS_DAY`
Model Internal Name	`uare_sms_link_day`


Explore View	4.SMS Recipients Summary
Database Object Name	`UARE_SMS_RECIPIENT_CLICK`
Model Internal Name	`uare_sms_recipient_click`

Deliver WhatsApp


Explore View	1.WhatsApp Campaign Summary
Database Object Name	`UARE_WHATSAPP_OVERVIEW`
Model Internal Name	`uare_whatsapp_overview`


Explore View	2.WhatsApp Campaign Summary by Hour
Database Object Name	`UARE_WHATSAPP_DAY`
Model Internal Name	`uare_whatsapp_day`


Explore View	3.WhatsApp Recipients Summary
Database Object Name	`UARE_WHATSAPP_RECIPIENT_CLICK`
Model Internal Name	`uare_whatsapp_recipient_click`

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.