cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpalha04 Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

Hi,

 

I've tried this but this is all the data I get. If i click into data->list, I get total data for my facebook ads -  there is no day-wise data. Is there any way to resolve this to have into load into power bi as a table and day-wise.

 

Capture.JPG

 

Capture.JPG

 

Thanks

MarianneElver Regular Visitor
Regular Visitor

nnRe: how to get facebook business manager data into power bi desktop

Hi. Are you getting this by using the connector from Scitylana? If not, you can try it here: https://new.scitylana.com/connectors. It works fine for me now on several clients.

mpalha04 Regular Visitor
Regular Visitor

Re: nnRe: how to get facebook business manager data into power bi desktop

Thanks for your reply. That was from creating a Facebook app and generating a client token. 

 

I just tried using the Scitylana custom connector and all i get is null data from my facebook ad insights.

 

Capture.JPG

mpalha04 Regular Visitor
Regular Visitor

Re: nnRe: how to get facebook business manager data into power bi desktop

Please disregard the above. I've tried again and the connector works! Only issue I believe is that the connector doesn't have Website Purchases?

MarianneElver Regular Visitor
Regular Visitor

Re: nnRe: how to get facebook business manager data into power bi desktop

Hi, 

Glad to hear that it also works for you. I've requeste website purchases on Github.

What I do to calculate ROAS, is to find the revenue on the matching campaign in my raw data. This ROAS is far lower than the ROAS that you can calculate on Facebook data alone. Cost per user is also a good benchmark to cost per click when monitoring campaigns.

Best,

Marianne

mpalha04 Regular Visitor
Regular Visitor

Re: nnRe: how to get facebook business manager data into power bi desktop

Thanks Marianne! I'll look into the raw data. Please let us know when transaction data is available.

george_p Frequent Visitor
Frequent Visitor

Re: nnRe: how to get facebook business manager data into power bi desktop

Hey @mpalha04, could you please share how did you fix this issue with the null data, I have the same problem. Thanks 🙂

mpalha04 Regular Visitor
Regular Visitor

Re: nnRe: how to get facebook business manager data into power bi desktop

Hi @george_p, I really just tried again and it worked haha... I would look to see if all your credentials are correct.

mpalha04 Regular Visitor
Regular Visitor

Re: nnRe: how to get facebook business manager data into power bi desktop

Is there a way to publish a report using this connector to PBI web service and set up automatic refresh?

mpalha04 Regular Visitor
Regular Visitor

Re: nnRe: how to get facebook business manager data into power bi desktop

Hello,

 

Is the Facebook connector working properly? No data shows when I refresh the connector from my last save.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)