Dynamics 365 Marketing - Analytic reporting with Power BI

Find here your marketing analytic reporting for Dynamics 365 Marketing using Power BI

Leaderboard report for customer journey automation and email marketing

Customer journey automation leaderboard

With the leaderboard report for customer journey automation and email marketing you identify your most effective customer journey automation and email marketing messages.

You can download both a template to run the report on your organization as well as a sample report filled with some data here.

Download the templateTemplate
Sample reportSample report
Find more downloads here

The leaderboard report for customer journey automation and email marketing consist of the following report pages:


Common Pages

Every report features a set of standard pages provide inside in the data generated by your organization.

Learn more about the common pages you find in every analytical reporting template in this article about the marketing analytical reporting framework.


The Email marketing leaderboard report

The detailed email marketing leaderboard lets you compare and rank your marketing messages based on the KPIs:

  • Total emails delivered
  • Total emails opened, unique opens and open rate
  • Total links clicks, unique clicks and click rate
  • Total form submissions, unique submissions and submission rate
  • Total subscriptions, unique subscriptions and submission rate

The marketing messages that shall be considered for this report can be filtered by data range, message status and journey status. And interactions can be filtered by a date recency filter as well.
The leaderboard chart control can be configured by the user who looks at the report, by rearranging columns and sorting by rank for select KPI.
email marketing leaderboard


The Customer journey automation leaderboard report

The customer journey leaderboard report compares and ranks your journeys based on the KPIs below. The email marketing related KPIs aggregate across all marketing messages that are part of the journey.

  • Number of contacts dispatched into the Journey
  • Total emails delivered
  • Total emails opened, unique opens and open rate
  • Total links clicks, unique clicks and click rate
  • Total form submissions, unique submissions and submission rate
  • Total subscriptions, unique subscriptions and submission rate

Use the data range and status slicers to filter the journeys. The interactions can be filtered by a date recency filter as well.
The leaderboard chart control can be configured by the user, columns can be rearranged or the sorting controlled to rank by a chosen KPI.

Customer journey automation leaderboard


Leaderboard KPIs and timeline

This reports lists for all KPIs for all marketing messages and journeys which the slicers in this report select. On top of that you can look at the individual interaction timelines that reflect behind the KPIs. Try selecting journeys and messages to filtering, slicing and dicing to compare your marketing activities by different criteria.
KPI breakdown and timeline