Unica Centralized Offer Management Configuration and Reporting Schema

Datasource Configuration

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

Verify the Setup

  1. Navigate to Dashboards.
  2. Filter Offer_Analytics.
  3. Run each dashboard. The Dashboard must run without any error.

Reports

Report Name Description
Offer performance by day The Offer performance by day report shows offer performance for a specified date or date range. It lists the number of offers given, number of response transactions and the response rate during the specified date or date range. User can filter report by the offer date.
Offer performance summary by campaign The Offer performance summary by campaign report provides a summary of offer and campaign performance with campaigns grouped by the corresponding offers. It includes data such as number of offers given, number of response transactions, response rate, number of unique responders and responder rate. It also includes optional lift over control group information. User can filter report by the campaign name.

Customize your Reports

You can customize or create new Unica Centralized Offer Management reports using out of the box datasets. These datasets consist of database SQLs. We recommend that you do not modify existing datasets in case you want to create a new field in the same. Instead, you can make a copy of it to modify SQL of datasets.

For more information, see https://superset.apache.org/docs/intro documentation.

Database Configurations for Superset

If you want to configure Superset on On Premises version of Unica, you must run a few SQL functions to activate Superset for use on On Premises setup.

  1. Access the home directory of Centralized Offer Management.
  2. Navigate to Report\superset\ddl.
  3. Depending on the database of your setup, select one of the following folders:
    • If your setup has DB2 database, open the db2 folder.
    • If your setup has MariaDB database, open the mariadb folder.
    • If your setup as Oracle database, open the oracle folder.
    • If your setup has Microsoft SQL Server database, open the sql folder.
    • If your setup has PostgreSQL database, open the postgresql folder.
  4. Open the superset_report_functions.sql file.
  5. Manually run all the functions in that file.