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

Reports
- Unica Insights Reports Installation and Configuration Guide
- Unica Open Insights User Guide
  - Unica Open Insights Overview
    In its 12.1.1 release, Unica has introduced Unica Open Insights, an open data model framework that integrates with popular Business Intelligence (BI) tools, to visualize the data and generate reports as per business requirements.
  - Installing Unica Open Insights
    Unica Open Insights installs as a part of the Unica installer. The Unica installer copies the Deliver model files and folders within the \Campaign Home\Reports folder. For example, \Reports\Open Insights\Looker\Deliver\unica_deliver_project.
  - 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.
  - Database View Details
    Campaign database has list of views to define the Deliver data model. Please refer the following table for the view names and their description:
  - Send Time Optimization
    Send time optimization calculates the best time to contact the target customer via various channels based on past interactions.
  - Appendix
    - Google Looker Exploration Views
      The following topics lists the available data exploration options for each channel. The end user sees the Data Exploration 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 all exploration views:
    - Data Model 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:
    - Date and Time Dimensions in Google Looker
      The following table lists the Date and Time dimensions for trend analysis:
    - Common Measures in Google Looker
    - Measures and Dimensions in Google Looker for the Email Channel - Part 1
      The measures and dimensions for the various data exploration views of the email channel are as follows:
    - Measures and Dimensions in Google Looker for the Email Channel - Part 2
      The measures and dimensions for the various data exploration views of the email channel are as follows:
    - Measures and Dimensions in Google Looker for Landing Page Channel
      The measures and dimensions for the various data exploration views of the Landing Page channel are as follows:
    - Measures and Dimensions in Google Looker for Mobile Push Channel
      The measures and dimensions for the various data exploration views of the Mobile Push channel are as follows:
    - Measures and Dimensions in Google Looker for SMS Channel
      The measures and dimensions for the various data exploration views of the SMS channel are as follows:
    - Measures and Dimensions in Google Looker for WhatsApp Channel
      The measures and dimensions for the various data exploration views of the WhatsApp channel 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.

Data Model 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:


Common Dimension	Channel	Description
Email	Email	Email ID of the recipient.
Masked Email	Email	Masked email ID of the recipient.
Mobile Number	Mobile SMS WhatsApp	Mobile number of the recipient.
Masked Mobile Number	Mobile SMS WhatsApp	Masked mobile number of the recipient.

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.