Email Performance Dashboard

This guide will help you understand:

What this Use Case does and why we developed it

Problem

With collected data scattered all over, locating potential issues and adjusting email campaign strategy is unattainable in real-time, hindering the performance of a set campaign. Afterward, it is challenging for marketers to evaluate an email campaign without united data.

Solution

An effective way of overcoming this challenge is to store real-time collected email campaigns’ data in one place. This would help marketers optimize email campaigns using real-time insights and allow them to cross-compare campaigns instead of evaluating each campaign on its own.

This use case

To help marketers better understand and improve their email campaigns, we developed the Email Performance Dashboard use case, as a ready-to-use solution. The dashboard provides a collection of reports, including the standard email deliverability report, revenue reports, and ‘negative’ metrics reports. A unified data platform allows marketers to analyze the success of their campaigns in real-time.

What is included in this use case:

  • A custom prebuilt evaluation dashboard including all important emailing metrics

1. Set up the Use Case

(1) Check the requirements

Prerequisites

The following event tracking is required:

  • 'purchase'
    • purchase_status: success
    • total_price
  • 'consent'
    • action=reject
    • category

Address any discrepancies if needed.

(2) Adjust the created assets and scenarios

1. Customizing the evaluated campaigns

Define which campaigns should be included in the evaluation reports and which ones should be excluded (e.g. test, template, etc.) using the event segmentation:

  • Campaign target definition where you name ‘exclude’ all the segments that should not be part of the evaluation and ‘campaign target’ all the segments that should be part of the evaluation.

📘

Do not change the name of segments. Otherwise, new segments need to be chosen in the reports in this dashboard.

2. Customizing the attribution window and purchase definition

The Attribution window is by default 48h after the open/click for email communication. The attribution window is linked to the purchase event. If you need to adjust the attribution window and/or refine the definition of completed purchase (e.g. status ‘successful’), make the changes in this event segmentation:

  • Purchase target definition (event segmentation) - adjust the status and attribution window in hours.
  • Conversions according to last click - comparison of emailing with other channels [last 60 days] (report) - adjust the status of purchase event, no attribution window in hours applies here because we use ‘last click’ attribution.

📘

If the main purchase event is defined differently than ‘purchase’, the segmentation above needs to be created anew together with all of the following expressions:

  • The time between campaign o/c and purchase (hours)

This event segmentation is used within the following assets where it needs to be replaced with new event segmentation, and all purchase events need to be replaced by specific purchase events for the project (e.g. purchase_sap).

Reports

  • Campaign Group results (attribution 48 hours to opened/clicked emails) [last 30 days]
  • Campaign Results (attribution 48 hours to opened/clicked emails) [last 30 days]
  • Conversions according to last click - comparison of emailing with other channels [last 60 days]

3. Segmenting campaign events

Evaluation per campaign group is accessible within the Email Performance Dashboard. The report focuses on drilling down the revenue and emailing metrics by campaign groups that are defined by clients (e.g. newsletters, automated campaigns, etc.). Therefore we need to arrange campaign events into categories:

  • Campaign groups to adjust the existing segments or create new ones based on the ‘campaign_name’ in your project.

📘

It is highly recommended to agree on campaign naming principles, e.g. all newsletter campaigns should contain ‘NL’ in the campaign_name, all automated campaigns should contain ‘AE’ in the ‘campaign_name’ etc.

4. Adjusting the time frames for different reports

Some reports would be restricted to a specific timeframe, e.g. ‘[last 90 days]’. If you wish to change the period, go to Edit mode of concerned reports and make the following changes:

  • Set the time filter on the top right corner to your desired value
  • Go to ‘Event Filter’ at the bottom of the report and adjust the campaign - sent_timestamp - matches the range to your desired value.
  • If the row consists of an aggregate, adjust the time frame of this aggregate to match the above, e.g. Campaign Group results (attribution 48 hours to opened/clicked emails) [last 30 days] report.

📘

Both filters should match the same time frame. The time frame used depends on the expiration of the campaign events in your project.

5. Defining the consent

Unsubscription metrics are defined by the ‘consent’ event with the action ‘reject’. Go to the following reports and select the correct consent category for emailing communication:

  • Unsubscriptions [last 90 days] - select ‘category’ in the ‘Event Filter’ at the bottom of the report
  • Unsubscriptions by campaign [last 30 days] - select ‘category’ in the ‘Event Filter’ at the bottom of the report

(3) Evaluate on a regular basis

After successfully setting up all the necessary metrics within your project, the dashboard will serve as an out-of-box evaluating tool. The most important metrics are highlighted in colors, and their definitions are explained in the dashboard notes or this document. There are no further adjustments necessary. Check the evaluation dashboard regularly to spot any need for improvements as soon as possible.

To better understand the metrics and reports included in the dashboard or avoid misinterpretation of the data, please refer to the next section.

2. Suggestions for custom modifications

The Dashboard is ready for any more customization based on what you are tracking and what you deem important in any given moment.

3. Evaluate

Key metrics calculations
The attribution model used for revenue attribution takes into consideration all the purchases made within 48 hours since email open/click. This time frame is called the attribution window.

Go to our Evaluation Dictionary article to understand different metrics in your evaluation dashboard! The article covers Benefit/Revenue calculations, Campaign metrics and Ecommerce benchmarks for emailing metrics relevant for this Use Case.

For more information, consult different campaign statuses and their meaning and our Emailing metrics guide.