Forum Discussion

jeroenwmwillems's avatar
jeroenwmwillems
Icon for Advocate I rankAdvocate I
7 years ago

Link PowerBI to Facebook Analytics (the business version).

Hi all,   We're using Facebook Analytics (not the normal Facebook page where people have posted about in this forum) and are trying to link some user data to our backend in PowerBI.  I can't find ...
Need Help
michaelbilling's avatar
michaelbilling
Icon for Helper II rankHelper II
7 years ago

jeroenwmwillems 

 

I've recently investigated your question. Facebook hasn't provided an API yet for the Facebook Analytics data.

When they do, I'll be the first to build the connector for it - so when you hear something from Facebook let me know!

Tracking data is typically a bit heavy on the API if you want to leverage the PBI features so this. Typically discount counts are of good value, and then you need the hit/log-data to accomplish this. Pulling realtime results may work, but for good and free filtering this only gets you a part of the way.

 

If you are interessted in Google Analytics (or know someone who is) take a look a how Scitylana can give you a complete data lake with your hit/log data. When Facebook opens up, Scitylana will provide the same features.

 

Did you know that using aggregated tracking data in PBI may lead to wrong result. The cause is overcounting and in the case of Google Anlaytics also sampling is a BIG issue.