Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (2024)

  • Article

Note

On September 1, 2023, Dynamics 365 Marketing and Dynamics 365 Customer Insights began to be sold together under a single product SKU called Dynamics 365 Customer Insights. The individual applications have been renamed Dynamics 365 Customer Insights - Journeys and Dynamics 365 Customer Insights - Data, respectively. For more information, see Dynamics 365 Customer Insights FAQs

Starting on September 1, 2023, new Customer Insights - Journeys customers receive real-time journeys features only. For more information, see Default real-time journeys installation. Many documentation pages currently refer to outbound features that may not be available or may work differently in real-time journeys. The documentation content is being updated to note whether it applies to real-time journeys or outbound marketing.

Important

This article only applies to outbound marketing.

This article provides a gallery with links to downloads and details for each Microsoft Power BI template and sample report that's currently available for Dynamics 365 Customer Insights - Journeys. It also explains how to connect a downloaded template to your Dynamics 365 Customer Insights - Journeys instance. These resources help you produce custom analytics reports with Power BI for your Dynamics 365 Customer Insights - Journeys organization.

Gallery: Download Power BI reports and templates

Tip

Download your analytics reports and templates directly from our gallery—ready to use with Dynamics 365 Customer Insights - Journeys!

Choose from a growing number of marketing reports for easy download, and find the information to help you select the reports that fit your needs. Each template and report provides useful views, charts, and analytics. You can use the standard features of the Power BI Desktop to explore the data sources and analytical displays, and customize them to meet your own organization's requirements.

NameDescriptionTemplateReport
Generic template (framework and tools)This report provides generic parameters, data sources, and query code you can use to query for any marketing data from Microsoft Dataverse and the interaction store.Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (1)Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (2)
Basic leaderboard report (journeys and email marketing)Identify your most effective journeys and marketing messages.Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (3)Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (4)
Email marketing reportDeep-dive into your email marketing plans, activities, and interactions.Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (5)Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (6)
Segmentation reportAnalyze how segments are used in your marketing activities.Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (7)Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (8)
Marketing program effectivenessAnalyze the end-to-end effectiveness of your marketing programs, including automation, journeys, channels, lead generation, conversion, and revenue generation.Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (9)Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (10)
Marketing reach analysisIdentify contacts and how you're reaching out to them. See all audiences reached in selected journeys, together with their related interactions.Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (11)Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (12)
Marketing form submission reportGet an overview of the submission stream across all your marketing forms.Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (13)Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (14)

The source code for all of these reports is available publicly on GitHub.

Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (15)

Connect a Power BI template to your Dynamics 365 Customer Insights - Journeys instance

After your Azure Blob storage is set up and connected to Dynamics 365 Customer Insights - Journeys, you're ready to start working in Power BI to connect to your data sources and design your analytics.

  1. If you haven't done so already, download the templates you need from the gallery.

  2. Select a template and open it in Power BI Desktop. If you don't already have Power BI Desktop, you can download it for free from https://powerbi.microsoft.com/desktop/.

  3. The first time you open a Power BI template, you'll be asked to specify connection strings and credentials to connect to both Azure Blob storage and to Dynamics 365 Customer Insights - Journeys.

    Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (16)

    • To connect to the Dynamics 365 database, use the same user credentials that you use to sign in to Customer Insights - Journeys.
    • You can find connection details for your Azure Blob storage by using Azure Storage Explorer.
    • Specify how many days of interaction data that you want to load (counting back from today).
  4. Select Load to load the template into Power BI.

    Note

    If you see loading errors the first time you open a template, open the query editor, select a query that has been highlighted with a warning icon, and then select Retry on the notification message bar. Repeat for each query that shows a warning. After all queries have loaded, select Close & Apply.

    Important

    There is a two hour limit for Power BI report refresh. To prevent a timeout, we recommend keeping the data in your blob storage under these limits:

    • 50,000 blobs in total
    • 5GB of data in total
Download and use marketing analytics templates and sample reports for Power BI - Dynamics 365 Customer Insights (2024)

FAQs

Can you download Power BI templates? ›

If you haven't done so already, download the templates you need from the gallery. Select a template and open it in Power BI Desktop. If you don't already have Power BI Desktop, you can download it for free from https://powerbi.microsoft.com/desktop/.

How do I add a Power BI report to my CRM dashboard? ›

Integrate Power BI Dashboard in Dynamics CRM
  1. Integrate the Connector App. Navigate to the bottom left corner of the screen and click on button “Get Data”. Under tab “Services”, click on Get. ...
  2. Embed the Power BI report in Dynamics 365 CRM. In the above steps, we have created the Power BI analytical report.

How do you build reports in dynamics? ›

Edit a report
  1. Go to Reports.
  2. To add a new report, select New.
  3. In the Report: New Report dialog box, in the Report Type list, select Report Wizard Report, and then select Report Wizard. ...
  4. Select the starting point for your report. ...
  5. Enter the name of the report, and specify which record types the report will use.
Oct 4, 2022

How do I create a CRM Analytics dashboard? ›

How Do I Create a Dashboard in Tableau CRM?
  1. Create a Dashboard Widget. ...
  2. Edit the Pipeline Widget. ...
  3. Add a Text Widget. ...
  4. Add Charts and Metrics to Support the “Hero Chart” ...
  5. Add a Highlights Panel. ...
  6. Add Global Filters and Toggle. ...
  7. Add Image, Date, List and Range Widget.
Jan 6, 2022

How do I add a dashboard to Dynamics CRM? ›

Create a new dashboard

Open solution explorer, and then select Components > Dashboards. Select New, choose a layout, and then select Create.

Top Articles
Latest Posts
Article information

Author: Kareem Mueller DO

Last Updated:

Views: 6276

Rating: 4.6 / 5 (46 voted)

Reviews: 85% of readers found this page helpful

Author information

Name: Kareem Mueller DO

Birthday: 1997-01-04

Address: Apt. 156 12935 Runolfsdottir Mission, Greenfort, MN 74384-6749

Phone: +16704982844747

Job: Corporate Administration Planner

Hobby: Mountain biking, Jewelry making, Stone skipping, Lacemaking, Knife making, Scrapbooking, Letterboxing

Introduction: My name is Kareem Mueller DO, I am a vivacious, super, thoughtful, excited, handsome, beautiful, combative person who loves writing and wants to share my knowledge and understanding with you.