Quite many of our users are asking how they can visualise data driven attribution data in Power BI. The need is usually to get Google Analytics unsampled, Google Ads, Facebook and Windsor.ai attribution data into a tool the company is already using for dashboards internally.
Sometimes also visualising TV-attribution performance data is needed.
This is very easy. Microsoft PowerBI has a PostgresSQL connector we support: https://learn.microsoft.com/en-us/power-query/connectors/postgresql
When you sign up for windsor.ai mention that you want to use PowerBI for visualisation and we will provide you with credentials to connect with.
The three steps to visualise data from Windsor.ai are:
- Get credentials from windsor.ai
- Enter them in the powerBI postgres connector
- Pull the data and add it to a dashboard
Ideally use the caching functionality in Power BI to speed up dashboard loading times.
This way you will be able to create dashboards with:
- Data driven attribution and cross-channel marketing performance
- Data driven ROAS down to keyword level
- Raw Google Analytics data
- Facebook Ads data
- TV-attribution
- Also Salesforce or other CRM related data. For example qualified leads and customer journeys.
Here is one example of how it can look.
When setting up the connection between Microsoft Power BI and Windsor.ai it is important to use the caching functions in Power BI so it refreshes the data every 4 or 6 hours. This way the dashboard response times are fast and it provides a nice user experience.
No client has yet implemented the Budget Optimiser in Power BI but that is easy to use from our dashboards also and can be embedded on a company intranet if needed.
There is also the option to connect with the REST API https://windsor.ai/api-documentation/
It provides a little bit more flexibility but the direct PostgreSQL connector is the easiest in most cases.
You May Be Also Interested in:
Free Power BI Templates in 2023
Guide to Power BI for Marketing Analytics
Key Differences between Power BI and Google Data Studio
Power BI BigQuery Connection in 2023
Tableau vs Power BI: Key Differences and Comparisons
Power BI GA4 integration: How to Connect Them
Load data from Facebook Ads to Power BI