Trying to connect to Facebook ad data

[mpalha04]

Hey everyone,

I'm trying to get data from Facebook Ads Manager loaded into PBI Desktop. I've tried using the built-in Facebook connector, but it's limited to Likes, Comments, Posts, etc. I need data about specfic Facebook Ad campaigns. Also, if there is a solution, can it be set to auto-refresh?

Thanks

[Adel]

Hey, yes you could connect facebook ads to power bi using windsor.ai which will allow you to view data in real time.
Here the how to.
https://windsor.ai/how-to-connect-facebook-ads-to-power-bi/

[Djordje_M]

Hi, 

For pulling my data from Facebook Ads and visualize then in Power BI, I use the connector from Windsor.ai. There are templates, but also, you can customize it and put any fields (metrics and conversions data) you need from the list of the Facebook Ads data like:

Dimensions

• • Campaigns
  • Ad set

Breakdowns

• • Country
  • Age
  • Gender
  • Objective
  • Device
  • Publisher (Facebook, Instagram, Audience Network, …)

Metrics

• • Cost
  • CPM
  • Impressions
  • Clicks (all)
  • CTR
  • CPC
  • Website Conversions
  • Website Purchases
  • Website Purchase Revenue
  • Cost per Website Conversion
  • Actions (overall)
  • Cost per Website Purchase
  • Cost

I mostly use Desktop, but there is also an App source app.

[michaelbilling]

Hi  @mpalha04 and others,

Take a look at my open sourced Power BI connectors

You can choose from 

- Facebook Ads insights connector

- Instagram Page insights connector

- LinkedIn Insights connector

- Facebook Page Insight connector

- Stripe connector (it's working, compared to the one built-in)

If you are not the do-it-yourself type - you can download fully functionable Power BI connectors on my company page.

They are 100% free to use.

If you want to return the favor, either add features to the existing Power BI connectors or add a new connector to the repository.

You can also check out my premium products - Especially the Google Analytics Free hit-level data connector.

Cheers,

Michael

[Anonymous]

Hi @michaelbilling -

Thanks so much for this. I'm using your FB Ads Insights connector, and I'm trying to find a way to make it 'trusted' data connector so I don't have to keep changing the security settings when I open the dashboard. Per my research, it looks like this can be done with a thumbprint ID associated with the connector. (See here: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-trusted-third-party-connectors) If one exists, would you be able to send it to me? If not, I'm going to try and create one.

Thanks so much!

Mickey

[Anonymous]

Hi Michael

I used you Facebook Ads connector and it works perfectly. Thanks a lot. 

Is there a way that I can pull data by age and gender? The connector doesn't seem to be giving me this

[aistebuivyte]

Hi,

I'm also wondering how to connect facebook ads with Power BI. Does anyone have a solution?

[mpalha04]

Does anyone have a solution to connect Facebook Ad data to PBI?