Are you social marketeer and you want to get deep insights of your competitor or page related to your niche? But the problem is you’re no programmer! Well, we got you covered and I’m here to help you extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API without programming and yes, it’s free!

You can insights to and Data you can extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API without programming are:

  • The number of likes,shares, and comments for each post
  • The number of Facebook reactions (Like,Love,Haha,Wow,Sad,Angry) for each post
  • The message of each post (Facebook status messages)
  • Facebook IDs for the users who have liked, commented on or shared a post
  • Facebook post comments for each post

So what are we waiting for? Let’s get going!

Step-by-Step process to extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API without programing

Step 1: Get an access token from Facebook Graph API Explorer

This is a must step before you initiate scraping. You need to:

  • Login to your personal Facebook Account
  • Go to Facebook Developers Tools
  • And then you’ll get an access token as shown belowextract/scrape ANY public Facebook Page Posts Data

This token expires after 2 hours and if you are in search of never expiring access token, you need to setup your own Facebook Developers Account (don’t worry, I repeat, you need no coding knowledge )

To get an Access token that never expires:

  • Go to Facebook Apps
  • Click Add a New appextract/scrape ANY public Facebook Page Posts Data
  • You will be asked to fill up the details (words like Facebook, FB are prohibited in an App name)
  • Go to Settings → Basicextract/scrape ANY public Facebook Page Posts Data
  • There you get App ID and App Secret

This is it, put in this format App ID|App Secret and it is your never expiring access token.

Step 2: Get the Page ID of the Facebook page you’re trying to get insights of.

Note: You must enter your own access token, above is just an example and you get Page ID like shown in the screenshot.extract/scrape ANY public Facebook Page Posts Data

Step 3: Extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API

  • Go to
https://graph.facebook.com/v2.6/{pageID}/posts/?fields=message,link,permalink_url,created_time,type,name,id,comments.limit(0).summary
(true),shares,likes.limit(0).summary(true),reactions.limit(0).summary(true)&limit=100&access_token={your-access-token}

Note: You can get 1st 100 posts insights in every page in chronical order

I put like

https://graph.facebook.com/v2.6/352364611609411/posts/?fields=message,link,permalink_url,created_time,type,name,id,comments.limit(0).summary

(true),shares,likes.limit(0).summary(true),reactions.limit(0).summary(true)&limit=100&access_token=EAACE (truncated)

Scroll to the bottom of the page, you’ll see paginationextract/scrape ANY public Facebook Page Posts Data

Scraping between Specific Dates:

https://graph.facebook.com/v2.6/YourPagaNameOrID/posts/?fields=message,link,permalink_url,created_time,type,name,id,comments.limit(0).summary

(true),shares,likes.limit(0).summary(true),reactions.limit(0).summary(true)&until=2017-02-17&since=2017-01-01&limit=100&access_token=

 

The data you obtain via above link needs to be converted so for that follow next step:

 Step 4: Converting JSON file to CSV/Excel Sheet

If you still want to extract more data, scroll to the bottom of the JSON response and copy like below URLextract/scrape ANY public Facebook Page Posts Data

https://graph.facebook.com/v2.6/352364611609411/posts?fields=message,link,permalink_url,created_time,type,name,id,comments.limit\u0025280\u002529.summary\

u002528true\u002529,shares,likes.limit\u0025280\u002529.summary\u002528true\u002529,reactions.limit\u0025280\

u002529.summary\u002528true\u002529&limit=100&access_token=EAACE(truncated)

Unfortunately,if you enter this URL into your browser as it is,it will bring an error.Reason being it has these values(\u002528,\u002529) which can’t be interpreted by the browser.Actually,these values represent the ( and ) respectively.

So we need to clean the URL before entering into the browser.Copy and paste the URL into Notepad text editor for Windows.Then use the find and replace all feature.Find ‘\u002528’ and replace all with ‘(‘ then find ‘\u002529’ and replace all with ‘)’.(everything without quotes)extract/scrape ANY public Facebook Page Posts Dataextract/scrape ANY public Facebook Page Posts Data

And we final URL like

https://graph.facebook.com/v2.6/352364611609411/posts?fields=message,link,permalink_url,created_time,type,name,id,comments.limit(0).summary(true),

shares,likes.limit(0).summary(true),reactions.limit(0).summary(true)&limit=100&access_token=EAACE(truncated)

Paste it in URL box and you’ll get next 100 JSON data and go through Step 4 again to get CSV file.

 Step 5: Analysis

As you have received CSV file, now you can sort which posts received the most likes in descending orderextract/scrape ANY public Facebook Page Posts Data

Same procedure can be repeated for the Comments and Shares.

 Step 6: Extracting the Facebook ID of Users who commented, liked or shared:

You need to get the post ID of which you are trying to extract data:extract/scrape ANY public Facebook Page Posts Data

Step 6a: Extracting the Facebook ID of users who liked:

  • Go to https://graph.facebook.com/post-id/likes?limit=2000&access_token=EAACEdE (Truncated)
  • Copy the JSON data and follow Step 4

Step 6b: Extracting the Facebook ID of users who commented:

  • Go to https://graph.facebook.com/post-id/comments?limit=900&access_token=EACEdE (Truncated)
  • Copy JSON data and follow Step 4

Step 6c: Extracting the Facebook ID of users who shared:

  • Go to https://graph.facebook.com/post-id/sharedposts?limit=2000&access_token=EAACEdE (Truncated)
  • Copy JSON data and follow Step 4

Step 7: Extracting the Reactions for every post

extract/scrape ANY public Facebook Page Posts Data

Note: A free trial account will enable you to try all the packages for 14 days without putting in a credit card. You will be able to export data into Excel/PowerPoint format, or alternatively, you can sign up for a totally free account which allows you to analyze a maximum of 3 Facebook profiles and 1 month of data. However, the free account does not enable you to export data into Excel or PPT format – you can only export data from your free account into PDF/PNG/JPG format.

  • Sign up and Add profileextract/scrape ANY public Facebook Page Posts Data

 

 

  • Analyse the Reactions dataextract/scrape ANY public Facebook Page Posts Data

 

Verdict:

With all this above knowledge, you are about to get very deep insights of your competitor and this might help you in your marketing. So, what do you think of this SUPER-POWER being able to extract/scrape ANY public Facebook Page Posts Data to Excel using Facebook Graph API.

LEAVE A REPLY