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 postgresql connector we support. https://powerbi.microsoft.com/en-us/integrations/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
- Also salesforce or other CRM related data. For example qualified leads and customer journeys.
When setting up the connection between Microsoft PowerBI 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://www.windsor.ai/api-documentation/
It provides a little bit more flexibility but the direct postgresql connector is the easiest in most cases.