Facebook, Google Analytics and Google ads data into Microsoft PowerBI

Post Reply
niklaskolster
Posts: 26
Joined: Mon May 18, 2020 7:33 pm

Facebook, Google Analytics and Google ads data into Microsoft PowerBI

Post by niklaskolster »

If you want to get windsor.ai marketing attribution data, facebook, google analytics or any other marketing data into Microsoft powerBI here is how you can do it.

Prequisites:
  • Windsor account
  • API key from windsor
  • Microsoft powerbi
In powerBI just click get data and use the advanced tab.
facebook_google_ads_data_into_powerbi-700x498.png
facebook_google_ads_data_into_powerbi-700x498.png (71.74 KiB) Viewed 1711 times
for the API URL use: https://api.windsor.ai/%5BCLIENTNAME%5D/%5BCLIENTNAME%5D_attribution/public/%5Btablename%5D?api_key=%5BAPIKEY%5D

Where all [CAPS] are replaced with your data.

API key you get from windsor when you sign up.

Then you can specify the dimensions and metrics you want to query and group by.

This way you can pull all the data you want unsampled.

The full API documentation and queries are here: https://www.windsor.ai/api-documentation/

This way you can visualise all your marketing data easily in powerBI with data driven marketing attribution.
Image
Post Reply