Having fresh Facebook Ads in Power BI is very useful. Especially in case you are investing heavily into Facebook and Power BI is your central reporting platform. In this article we’ll explain how to get both platforms connected. The whole process should not take more than 5 minutes and you can choose between >200 different dimensions and metrics from Facebook Ads.
As prerequisite you’ll need a Windsor.ai account which you can get here.
- Connect your Facebook Ads account to Windsor.ai and copy your API key
- Use this URL
https://connectors.windsor.ai/facebook?api_key=[your API key]&date_from=2021-01-18&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
[your API Key]with your API key. The fields which are listed after
&fields=are simply a set of standard fields which you can customise. A full list of metrics and dimensions can be found in our Facebook Ads connector documentation. Customise the URL to your liking. If you want to query a specific date range you can do so by changing
&date_from=to the start date. Additionally you can also add in
&date_to=(at the end of the URL) and specify the end date.
- In Power BI click on Get data -> Web and copy paste the URL into the URL field. This URL now works as a data feed. If you want to add or remove fields, simply adjust the URL as described in step 2. Now a window will open where you click Connect.
- Now your data should appear in Power BI. Click load and configure it.
Important You will need to change the fields to their types (e.g. date, decimals, whole numbers, …) to use them in aggregations (sums, averages, …) or date filters. For users in Europe and other countries where a comma is used for decimals please change the locale of the data to English.