Effectiveness of Loyalty Program



Reports on Datawiz BI service

The "Effectiveness of Loyalty Program" report summarizes the key metrics of the loyalty program and shows their % in total chain sales.

It contains two tabs: Report and LP Dynamics.

The "Report" tab contains basic information on chain sales and LP % in them. Its functionality allows to:

  • view the required data for two periods: "Chosen" and "Previous", comparing them with each other;
  • analyze data at different levels, going from the highest (stores) to the lowest (SKU). If the stores are divided into regions, the analysis can be performed in terms of regions, going down to the stores, categories, and products;
  • visually monitor the dynamics of key metrics;
  • evaluate the effectiveness of marketing activities in working with LP clients.

The "LP Dynamics" tab displays a visualization of the dynamics of LP metrics in comparison with similar chain metrics. When building a graph, you can choose:

  • Metrics - the left field above the visualization which allows to choose one of the following metrics from the pop-up list:
Sales Qty
Receipt Qty
Avg Receipt Price
Assortment activity 

To choose the required pair of metrics (LP and chain) it is enough to mark the required metric with a flag.

  • Interval - the right field above the visualization which allows to set one of the proposed intervals:
    • Day/Month/Year
    • Month/Year
    • Year
    • Month
    • Week
    • Day of the Week
    • Hours

Tick the checkbox Show Data Signatures (on the left above the visualization) to display the values of metrics. 

 "Columns" button allows to choose the necessary metrics for generating a report. All metrics are divided into subgroups:



Receipt Qty

Sales Qty

Avg Receipt Price

Assortment activity

Note! Access to viewing metrics according to the user's role is determined by the administrator. Contact your administrator to expand the access.

Metrics highlighted in purple or red are clickable. Clicking on them opens a window with a flow chart of the chosen metric.

"Templates" button - saves the configured report columns as a template.

On the right above the table a context menu is opened where the user can select the following actions:

  • "Lock the total row" - fixes the "Total" row in the top row of the table.
  • "Save XLS" - saves table data to an xls-file.
  • Send XLS" - sends a letter with a table to an xls-file to the entered email address.

To quickly find the necessary dimension (stores, categories, products), enter the first letters/symbols of the unit name in the search field. The search works automatically, leaving all found matches in the table.

To reset the search results, click on the cross in the search field.

The selection of filters makes it possible to carry out the analysis within the specified conditions.

Filters button is placed on the right side above the report. Clicking on it opens a modal window with the following filters:

  • Stores
  • Period
  • Previous period
  • Categories
  • Receipt markers
  • Product markers
  • LP Clients’ filter