Facebook Developers
DocumentationSupportBlogAppsLog In
  • Getting Started
  • Core Concepts
  • Advanced Topics
    • Dialogs
    • FQL
    • Internationalization
    • Ads API
    • Credits
    • Chat API
    • Legacy REST API
    • Legacy FBML
    • Legacy FBJS
    • Legacy Javascript SDK
  • SDK Reference
  • Tools
  • Tables
    • album
    • application
    • apprequest
    • checkin
    • comment
    • comments_info
    • connection
    • cookies
    • developer
    • domain
    • domain_admin
    • event
    • event_member
    • family
    • friend
    • friend_request
    • friendlist
    • friendlist_member
    • group
    • group_member
    • insights
    • like
    • link
    • link_stat
    • location_post
    • mailbox_folder
    • message
    • note
    • notification
    • object_url
    • offer
    • page
    • page_admin
    • page_blocked_user
    • page_fan
    • page_milestone
    • permissions
    • permissions_info
    • photo
    • photo_src
    • photo_tag
    • place
    • privacy
    • privacy_setting
    • profile
    • profile_view
    • question
    • question_option
    • question_option_votes
    • review
    • standard_friend_info
    • standard_user_info
    • status
    • stream
    • stream_filter
    • stream_tag
    • subscription
    • thread
    • translation
    • unified_message
    • unified_thread
    • unified_thread_action
    • unified_thread_count
    • url_like
    • user
    • video
    • video_tag

link_stat

Advanced Topics › FQL › link_stat

An FQL table containing counts that show how users on Facebook are interacting with a given link.

Example

Retrieve link stats for facebook.com (Try this query):

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

Columns

IndexableNameTypeDescription
*urlstring

The URL to the Web page users can share with Facebook Share. This is the indexable field in the table, so you must specify it in your query's WHERE clause. To specify more than one URL, you must use the IN operator in the query's WHERE clause.

normalized_urlstring

The normalized URL for the page being shared.

share_countint

The number of times users have shared the page on Facebook.

like_countint

The number of times Facebook users have "Liked" the page, or liked any comments or re-shares of this page.

comment_countint

The number of comments users have made on the shared story.

total_countint

The total number of times the URL has been shared, liked, or commented on.

click_countint

The number of times Facebook users have clicked a link to the page from a share or like.

comments_fbidint

The object_id associated with comments plugin comments for this url. This can be used to query for comments using the comment FQL table.

commentsbox_countint

The number of comments from a comments box on this URL. This only includes top level comments, not replies.


Updated about 6 months ago
Facebook © 2012 · English (US)
AboutCareersPlatform PoliciesPrivacy Policy