Forum Discussion
Getting Facebook likes, comments and shares count
Hi rc225225,
I was actually analysing facebook data from our company site when I read your post :)
1. Within PowerBI Desktop, click on Get Data
2. Scroll down and select 'Facebook'
3. A message will pop up warning you that you will access a 3rd party site. Just click on 'continue'
4. For the username, enter the name of the Facebook Page. For instance, Microsoft's Facebook page is 'www.facebook.com/Microsoft'. The name in this instance is 'Microsoft'
5. Under connection, select 'Posts'.
6. You will be asked to enter your credentials, which is your actual Facebook login details.
I was analysing comments and posts. I'm not sure if Likes are available.
Cheers,
Daniel
Thanks for your help - what I was looking for is not necessarily the posts, but just the data.
eg. Post 1 may have 100 likes, 25 shares and 56 comments.
I would then take the total of these and divide it by a certain percentage of the fanbase to get an overall feel for how competitor content performs.
- itchyeyeballs10 years agoImpactful Individual
Following the tutorial here - https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-facebook-analytics/
I can only figure out how to pick up likes or comments from a single specified entity (all comments made by one user for example), there doesn't seem to be a way to pick up all likes on specific pages or posts.
I've probably missed something but It looks like you will have to manually utilise the insights element of the graph API - https://developers.facebook.com/docs/graph-api/reference/v2.5/insights or purchase a third party solution