Page 1 of 1

Facebook, Google Analytics and Google ads data into Microsoft PowerBI

Posted: Mon May 18, 2020 8:46 am
by niklaskolster
If you want to get marketing attribution data, facebook, google analytics or any other marketing data into Microsoft powerBI here is how you can do it.

  • 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 (71.74 KiB) Viewed 9411 times
for the API URL use:

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:

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