Forum Discussion
Pulling Data from Facebook Ad Campaigns
I've build a custom data connector for Facebook Ads
You can just copy the mez file from https://github.com/Hugoberry/FacebookAds/tree/master/build into your
[My Documents]\Microsoft Power BI Desktop\Custom Connectors directory
and enable custom connectors in Power BI.
The FacebookAds connector now supports two functions. The initial functionality FacebookAds.Campaigns() will return you the insights for your campaigns.
The Second function FacebookAds.API(uri,params) is more of a credentials wrapper for the enitre MarketingAPI. You can tailor your requests as you want with it.
DataSource.Error: Web.Contents failed to get contents from 'https://graph.facebook.com/v2.11/act_71**9815*******/campaigns?access_token=******=name' (400): Bad Request
Details:
DataSourceKind=FacebookAds
DataSourcePath=FacebookAds
Url=https://graph.facebook.com/v2.11/act_71***99****/campaigns?access_token=********=name
Hi All,
You can go to my github page and download the Facebook Campaign Analytics PBI template. Open the template, add some inputs and your are done, you can analyze your Facebook campaigns, ad sets and ads easily through this template.
https://github.com/ranmax123/powerbi/tree/master/facebook%20marketing%20api%20power%20bi%20template
More in my blog post: https://bigintsolutions.com/2018/05/07/the-ultimate-power-bi-template-for-analyzing-your-facebook-campaigns/
If you have any questions, please open up an issue in github.
Thanks,
Ranbeer
