Microsoft Power BI Web Multichannel Marketing Attribution Dashboard Template

multichannel dashboard web power bi

This Web Multichannel Attribution dashboard helps you to integrate all your performance marketing data into one place. By default, it connects to your analytics data set (Google Analytics) and connects them with your media data from:

Connect your data for free trial >>

Once it’s all connected you can then get an understanding of the ROI of each touchpoint in your customer journeys. To make it simple to understand for the purpose of client and management reporting it is kept at a high level. Metrics are provided on a Channel and Channel Grouping level but this can of course be customized as the underlying data set is much more granular.

4 rules to create the optimal dashboard for marketing reporting

87% of managers believe that data are the least exploited asset in the marketing industry, according to a recent survey. By organizing and showing the data in a marketing dashboard, marketers may see at a glance what marketing measures have been and what is not successful.

These insights enable marketing professionals to make sound decisions based on the facts they learned from their information to inform their marketing strategies and operations.

 

  1. Center your dashboard for marketing reports on one subject

Too many KPIs on a single dashboard is a common mistake made by marketers. These can be confused quickly. Particularly when you report to your customer or manager. They may distract themselves by stats that don’t help you make up that point.

“What are my targets for marketing? What I am  going to accomplish? And what KPIs follow me to achieve this particular goal?”

Once you set your goals to achieve a better marketing objective, ensure that you develop different dashboards for each criterion. It is good to practice KPIs that are matched with the marketing objectives.

 

  1. Use the proper diagram to view your information

How do you picture this once you have selected what you will measure?  But the first step is perhaps the toughest: “What graph type should I use?”

Just like a good story takes a good picture, your data needs the correct picture. When you select the wrong graph, your dashboard visitors may get confused or even misleading.

Both dashboards demonstrate the performance of your emails compared to industry standards.

 

  1. Compare and visualize developments

Line charts are the best technique to represent a change in time. Both dashboards do, but the first one does a better job if we compare the development of two metrics. If you need to explore further potential links, you will see more quickly.

  1. How bar charts versus bubble charts can be used

In the first example, you can compare values on a single category visually in the bar chart. For e.g. how do the open rates change every day? The difference in bar size shows you how differently they differ.

How geographic data can be displayed

You can see your global presence visibly in terms of email subscribers in the first example. You can see clearly which countries are well represented or under-represented. The second example illustrates but does not categorize the bar charts. It shows a ranking of nations about the number of subscribers, or a concept of geographical distribution

Connect business impact marketing KPIs

You have configured your KPIs and you can graphically see them. What else do you need to create a dashboard for great marketing?

The answer is background.

Imagine running a brilliant marketing campaign, which has produced a lot of new ideas. Your manager will come to you the last thing you want: “That’s terrific, but in the end, nobody bought our stuff.”

You can have an even influence if you illustrate how your marketing activities relate to the business context. In the previous scenario, you would like to identify where in the sales funnel the leads are blocked. Marketing data is always a risk when you look at them in isolation. You will avoid working in silos by integrating marketing & selling data together.

 

  1. Make your dashboards operative

You may construct very solid marketing dashboards with the recommendations above, which display the major marketing statistics in one glance. But if nobody act on them subsequently, what use is there to have all these insights?

Conclusion

These four thumb rules provide a solid structure for your marketing dashboards. It helps to improve or start with the examples that serve as an inspiration for creating your handy dashboards. Allow your creativity to design dashboards for your marketing and management team.

 

 

Here is a simple four-step method if you are interested in developing comparable dashboards for your firm.

  1. Collect all your marketing information on Google sheets with Windsor
  2. Connect Google Sheets to a data display platform.
  3. Construct a dashboard with up-to-date data at all times
  4. Regularly use your dashboards and alter them as your objectives change over time.

 

To get started

  1. Connect your marketing data to Windsor.ai here Register or login if you already have an account.

Register windsor ai

 

2. Important: For this dashboard to work, please make sure that you also connect a Google Analytics data set and select the goals you want to track. In case you are an e-commerce store, select e-commerce transactions. Select at least one Google Analytics account from the dropdown and remember to grant access. Copy your API Key from the top right corner.

options for power bi dashboard

 

 3. Install the Power BI Web App here

4. Click on the Appmulti channel web dashboard 1

5. Click on Connect in the Connect your data sectionmulti channel web dashboard 2

6. Enter your Username and API key which you got in Step 1enter api key multi channel dashboard power bi

7. Click on Sign Insign in multi channel attribution power bi

  1. Now your data will start loading and you’ll be able to explore your data and make changes to the dashboard with your data. Note: Depending on the data size it may take up to a few minutes for your data to load. This is normal and only happens the first time you use the dashboard.

Alternative: Power BI Desktop

If you would like to explore how we build the template on the Power BI desktop you can also download the latest version of the dashboard template in .PBIX format in this post. Please note that the source data are in US regional settings format (1234.56 and 2020-12-16), and if you are using the different locale settings, you might need to transform numerical and date data. This will allow you to change the visuals and join the data with other data sets you might already have in your data setup.

You might also be interested in…