Microsoft Power BI Multichannel Marketing Attribution Dashboard Template

Our Multichannel Attribution dashboard provides simple insights about paid and non-paid media performance. You can see top-level data from all your channels

• Google Ads
• Facebook Ads
• LinkedIn Ads
• Bing Ads

and understand their contribution to your marketings goals.

It includes reporting on all channels on a Channel Groupings level to make it easy to understand for everyone (especially for non-technical users).

The guide below will cover the following

1. Connecting your analytics and costs data
2. Installing the Windsor.ai Attribution Power BI plugin
3. Working with the Multitouch Attribution dashboard
4. TL:DR/Summary

1. Connecting your analytics and costs data

   Link your analytics data

   1. Go to https://onboard.windsor.ai/register and fill your details
   2. Click on Grant Google Analytics Access
   3. Grant access to the Google Analytics views
   4. Select the view which has the goals you would like to track.
   5. Select the goals you would like to track and click OK

   Link your costs data

   Google Ads

   1. Click Grant Google Ads Access and authorize access to your Google Ads account
   2. Grant access to the Google Ads accounts
   3. Select the Google Ads account you want to link in the drop-down
      

      

   Facebook

   1. Click onto Facebook Cost Datasource
   2. Go to your partner settings in your Facebook Business Account and click the + Add button below Partner to share assets with
   3. Copy the ID 2035503273130257 into the field Partner Business ID
   4. Assign the ad accounts you wish to have present in the data stream to Windsor.ai. It’s important that you give rights to View performance and also to Manage campaigns
   5. Copy the account id to the clipboard
   6. Paste the account ID and click add

   Complete the setup

   Click the green Finish button at the bottom of the page

   

   Congratulations. Now the data connections are set up!

2. Installing the Windsor.ai Attribution Power BI plugin

   1. Head here and download the latest Power BI dashboard and Attribution plugin template
   2. Install the pluginHead to your Documents folder and in there create a folder Microsoft Power BI and in there you create a folder called Custom Connectors. The path to the file should look like this C:\Users\windsoradmin\Documents\Microsoft Power BI Desktop\Custom Connectors\Analytic_and_Ad_Data.mez
   3. Allow the plugin to runOpen Power BI then click on Options and setting -> Options -> Security. Now allow any extensions to load without validation or warning.
   4. Restart PowerBI

3. Working with the Multitouch Attribution dashboard

   Simply open the Multichannel Attribution Dashboard which you have downloaded in the previous step. Now you will see a sample data set which you easily can replace with your data set. To get your data set visualised 

   1. Check the setup and Configuration Portal, connect your data sources and retrieve your username and token
      

   2. Search for Analytic and Ad Data and click Connect
   3. Enter the API URL https://api.windsor.ai/pied_piper_llc/ (replace pied_piper_llc with your API name (see step above). When being asked for the API key use the API key from step 1

Congratulations: Now you can start visualizing your data and blending your data to your existing data sources.

TL;DR/Summary: The setup requires you to a) connect your analytics and costs data and b) install a Power BI plugin (MEZ file). After setting it up you then have all costs and data-driven conversions in one place (so you can get multitouch attributed CPA and ROAS values). Here you can onboard your data and here you can find the connector and the template.