Skip to content

Instantly share code, notes, and snippets.

@gustavorps
Last active September 15, 2015 21:47
Show Gist options
  • Save gustavorps/6513c41e6e854b05b265 to your computer and use it in GitHub Desktop.
Save gustavorps/6513c41e6e854b05b265 to your computer and use it in GitHub Desktop.
Facebook API Tips & Ticks

URLs & Post with URL embed

Using link_stat of FQL Query to count shares, likes, comments and clicks

SELECT comments_fbid, url, normalized_url, share_count, like_count, comment_count, total_count, commentsbox_count, click_count 
FROM link_stat 
WHERE url = "URL_AT_FACEBOOK"

Output exemple

{
  "data": [
    {
      "comments_fbid": "1010101010110",
      "url": "https://someurl.com/",
      "normalized_url": "https://someurl.com/",
      "share_count": 202,
      "like_count": 859,
      "comment_count": 81,
      "total_count": 1142,
      "commentsbox_count": 0,
      "click_count": 0
    }
  ],
}

Using link of FQL Query to count shares and comments clicks

SELECT link_id, comment_info, created_time, caption, image_urls, like_info, picture, title, url
FROM link
WHERE link_id = 1047851535266931

Output exemple

{
  "data": [
    {
      "link_id": "1047851535266931",
      "comment_info": {
        "can_comment": true,
        "comment_count": 1720,
        "comment_order": "ranked"
      },
      "created_time": 1442346218,
      "caption": "",
      "image_urls": [
        "https://fbexternal-a.akamaihd.net/safe_image.php?d=AQBpLYK4aR5RgjBB&w=158&h=158&url=https%3A%2F%2Ffbcdn-sphotos-g-a.akamaihd.net%2Fhphotos-ak-xat1%2Fv%2Ft1.0-9%2F11995964_1047851475266937_5078298569781195663_n.jpg%3Foh%3De3151cbbb34fb60f2374c4aa1b1a4cef%26oe%3D569A2F2F%26__gda__%3D1449192743_d9f03f1825a0a79bfb7e9de9aa07c289"
      ],
      "like_info": {
        "can_like": true,
        "like_count": 29875,
        "user_likes": false
      },
      "picture": "https://fbexternal-a.akamaihd.net/safe_image.php?d=AQBpLYK4aR5RgjBB&w=158&h=158&url=https%3A%2F%2Ffbcdn-sphotos-g-a.akamaihd.net%2Fhphotos-ak-xat1%2Fv%2Ft1.0-9%2F11995964_1047851475266937_5078298569781195663_n.jpg%3Foh%3De3151cbbb34fb60f2374c4aa1b1a4cef%26oe%3D569A2F2F%26__gda__%3D1449192743_d9f03f1825a0a79bfb7e9de9aa07c289",
      "title": "Facebook terá botão 'não curti', afirma Mark Zuckerberg",
      "url": "http://g1.globo.com/tecnologia/noticia/2015/09/facebook-tera-botao-nao-curti-afirma-mark-zuckerberg.html"
    }
  ],
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment