Google Data Studio is taking the analytics and performance marketing industry by storm. Many of our clients have management reporting dashboards set up in Google Data Studio so we decided to support it as well.
While the active optimization components in the Windsor.ai platform such as the campaign and bid optimiser will not be available in Data Studio, visualisation of all the underlying data is fully supported.
Here are the steps on how to connect Windsor.ai to Google Data Studio:
Contact your account manager at Windsor.ai to get your login credentials
Add a new PostgreSQL data-source to Google Data Studio
Fill in the configuration details which were shared with you by your account manager and click Authenticate
Select custom query and enter the command below
select * from [your_username]_attributions_and_costs
Important: [your_username] should be replaced with the same username which you have used in the Database Authentication window (Step 3)
You should now see a list of dimensions and metrics similar to the screenshots below.