Unica Deliver Configuration and Reporting Schema

Datasource Configuration

  1. Login to the Superset environment.
  2. Navigate Settings > Database Connections.
  3. Edit CampaignDS.
  4. Provide password for the database user.
  5. Test the connection.

Verifying Setup

  1. Navigate to Charts.
  2. Navigate to Dashboards .
  3. Filter Deliver_Analytics.
  4. Filter Deliver_Dashboard.
  5. Run each dashboard. The Dashboard must run without any error.

Dashboards

Landing Page Reports
  • Sent Time Analytics Heatmap (Engagement)
  • Detailed Bounce Report
  • Unique Click by Email Link
  • Unique Click by Landing Page
  • Unique Click Rate by Campaign
  • WhatsApp Channel Performance Summary
  • SMS Channel Performance by Campaign
  • Mobile Push Channel Performance by Campaign
  • Email Unique Click Rate Summary
  • Email Channel Performance by Campaign
  • WhatsApp Channel Performance by Campaign
  • SMS Channel Performance Summary
  • Email Channel Performance Summary
  • A/B Email Mailing Summary
  • Mobile Push Channel Performance Summary
Table 1. Deliver Analytics
Report Name Description
Message Overview This report provides a summary of the overall effectiveness of your email marketing campaign. User can able to apply filter on the basis of time range,Based on campaign Name and based on mailing Instances.
Detailed Link Report This report provides a summary of link click data at the mailing level. User can able to apply filter on the basis of time range. Based on campaign Name and based on mailing Instances.
Detailed Link Report LP This report provides a summary of Landing Page Link click data at the mailing level. User can able to apply filter on the basis of time range. Based on campaign Name and based on mailing Instances.
Detailed Link by Cell Report This report provides a summary of link click data for each cell used by a mailing. User can able to apply filter on the basis of time range,Based on campaign Name. Based on CellCode and based on mailing Instances.
Detailed Link by Cell Report LP This report provides a summary of LP Link click data for each cell used by a mailing. User can able to apply filter on the basis of time range. Based on campaign Name,Based on CellCode and based on mailing Instances
A/B Testing Performance Report This report provides a summary of detailed mailing and response data that are generated by a single A/B test. User can able to apply filter on the basis of time range. Based on campaign Name and based on mailing Instances.
Detailed Bounce Report This report provides a summary of the breakdown of the deliver failures by category. User can able to apply filter on the basis of time range. Based on campaign Name and based on mailing Instances.
Deliver reports processing overview This report monitors the reports data processing and to determine whether data is available for use in Deliver reports. User can able filter reports data based on RunID.
SMS Message Summary Report This reports provides a summary of the overall effectiveness of your SMS marketing campaign. User can able to apply filter on the basis of time range. Based on campaign Name and based on mailing Instances.
WhatsApp Message Summary Report This reports provides a summary of the overall effectiveness of your WhatsApp marketing campaign. User can able to apply filter on the basis of time range. Based on campaign Name and based on mailing Instances.
Mobile Push Message Summary Report This report provides a summary of the overall effectiveness of your Push marketing campaign. User can able to apply filter on the basis of time range. Based on campaign Name and based on mailing Instances.
Email Engagement by Device Report This report shows user actions on device type by tracking email opened on different device types.
Bot Click Detection Report This report distinguishes genuine user clicks and automated bot clicks to ensure accurate tracking of email engagement.
Table 2. Deliver Dashboard
Report Name Description
Email Communication Report This Report Provides the data related to Email Channel Mailing according to their mailing instances in the bargraph chart format.
SMS Communication Report This Report Provides the data related to SMS Channel Mailing according to their Message instances in the bargraph chart format.
WhatsApp Communication Report This Report Provides the data related to WhatsApp Channel Mailing according to their Message instances in the bargraph chart format.
Push Communication Report This Report Provides the data related to Push Channel Mailing according to their Message instances in the bargraph chart format.
Communication Delivery by Channel Type This Report Provides Delivery Data for all The channel Types in The bargraph chart format
Sent Time Analytics Heatmap (Engagement) This Reports give details about Response count With respect to time in Heatmap Chart format.
Recent email bounce responses This Report Provides you the recent email bounce responses details in table chart format.
Recent email campaigns sent This Report Provides you the recent Campaign Sent details in table chart format.