Facebook Public Data fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Facebook Public Data data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

24 metrics78 dimensions

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEPRECATED

checkins
Field label Checkins
Description Number of checkins at a place represented by a page.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2024-09-16

LOCATION

location_name
Field label Location
Description Location name
Field type dimension
Data type string.text.value
location_country
Field label Country
Description Country
Field type dimension
Data type string.geo.country
location_country_code
Field label Country code
Description Country code
Field type dimension
Data type string.geo.country.twolettercode
location_city
Field label City
Description City
Field type dimension
Data type string.geo.city
location_city_id
Field label City ID
Description City ID
Field type dimension
Data type int.number.value
location_state
Field label State
Description State
Field type dimension
Data type string.geo.metro
location_region
Field label Region
Description Region
Field type dimension
Data type string.geo.region
location_region_id
Field label Region ID
Description Region ID. Specifies a geographic region, such as California
Field type dimension
Data type int.number.value
location_street
Field label Street address
Description Street address
Field type dimension
Data type string.text.value
location_zip
Field label Zip code
Description Zip code
Field type dimension
Data type string.geo.zip
location_located_in
Field label Located in (ID)
Description The parent location if the location is located within another location
Field type dimension
Data type int.number.value
location_latitude
Field label Latitude
Description Latitude
Field type dimension
Data type string.geo.latitude
location_longitude
Field label Longitude
Description Longitude
Field type dimension
Data type string.geo.longitude
location_coordinates
Field label Coordinates
Description Geographic coordinates (latitude & longitude)
Field type dimension
Data type string.geo.coordinates

MISCELLANEOUS

cover_source
Field label Cover link
Description Direct URL for the page's cover photo image
Field type dimension
Data type string.text.url
is_community_page
Field label Is community page
Description Indicates whether the page is a community page
Field type dimension
Data type bool
can_post
Field label Users can post
Description Whether the current session user can post on the page
Field type dimension
Data type bool
has_added_app
Field label Has added app
Description Indicates whether the page has added the app making the query in a page tab
Field type dimension
Data type bool
is_published
Field label Is the page published
Description Indicates whether the page is published and visible to non-admins
Field type dimension
Data type bool
is_verified
Field label Is the page verified
Description Indicates whether the page is verified
Field type dimension
Data type bool
name_with_location_descriptor
Field label Name with location descriptor
Description The name of the page with its location and/or global brand descriptor. Only visible to a page admin
Field type dimension
Data type string.text.value

PAGE

username
Field label Username
Description The alias of the page. e.g. for www.facebook.com/platform the username is 'platform'
Field type dimension
Data type string.text.value
name
Field label Name (Profile)
Description Name of the page
Field type dimension
Data type string.text.value
category
Field label Category
Description The page's category. e.g. Product/Service, Computers/Technology
Field type dimension
Data type string.text.value
description
Field label Description
Description The description of the page
Field type dimension
Data type string.text.value
description_translated
Field label Description (translated)
Description The description of the page
Field type dimension
Data type string.text.value
general_info
Field label General info
Description General information provided by the page
Field type dimension
Data type string.text.value
about
Field label About
Description Information about the page
Field type dimension
Data type string.text.value
company_overview
Field label Company overview
Description The company overview. Applicable to company pages
Field type dimension
Data type string.text.value
company_overview_translated
Field label Company overview (translated)
Description The company overview. Applicable to company pages
Field type dimension
Data type string.text.value
link
Field label Link to page
Description The page's Facebook URL
Field type dimension
Data type string.text.url
website
Field label Website
Description The URL of the page's website
Field type dimension
Data type string.text.value
phone
Field label Phone
Description Phone number
Field type dimension
Data type string.text.value
page_id
Field label Page ID
Description Page ID
Field type dimension
Data type int.number.value
awards
Field label Awards
Description The awards information of the film. Applicable to films pages
Field type dimension
Data type string.text.value
founded
Field label Year founded
Description When the company was founded. Applicable to pages in the company category
Field type dimension
Data type string.time.year
products
Field label Products
Description Product list of the company. Applicable to company pages
Field type dimension
Data type string.text.value
mission
Field label Mission
Description Page mission
Field type dimension
Data type string.text.value
fan_count
Field label Likes
Description Number of users who like the page. For global pages this is the count for all pages across the brand
Field type metric
Data type int.number.value
followers_count
Field label Page followers
Description Number of page followers
Field type metric
Data type int.number.value
talking_about_count
Field label Talking about
Description Number of people talking about the page
Field type metric
Data type int.number.value

POST

post_id
Field label Post ID
Description Post ID
Field type dimension
Data type string.text.value
status_type
Field label Post type
Description Post type
Field type dimension
Data type string.text.value
permalink_url
Field label Link to post
Description URL to the permalink page of the post
Field type dimension
Data type string.text.url
type
Field label Content type
Description Indicates the object type of the post
Field type dimension
Data type string.text.value
from_id
Field label From user ID
Description The ID of the user account for the post
Field type dimension
Data type int.number.value
from_name
Field label From user
Description The full name of the user account for the post
Field type dimension
Data type string.text.value
story
Field label Story
Description Text from stories not intentionally generated by users, e.g. when someone else posts on the person's wall
Field type dimension
Data type string.text.value
picture
Field label Picture URL
Description The picture scraped from any link included with the post
Field type dimension
Data type string.text.url
full_picture
Field label Picture URL (full)
Description URL to a higher-quality image used in the post, up to 720x720 in size
Field type dimension
Data type string.text.url
caption
Field label Caption
Description Link caption in post that appears below name
Field type dimension
Data type string.text.value
message
Field label Message
Description The status message in the post
Field type dimension
Data type string.text.value
place
Field label Place
Description Any location information attached to the post
Field type dimension
Data type string.text.value
source
Field label Content source
Description URL to any Flash movie or video file attached to the post
Field type dimension
Data type string.text.value
post_link
Field label Post link
Description The link attached to the post
Field type dimension
Data type string.text.url
application_name
Field label Application used to post
Description The app name the post was published by
Field type dimension
Data type string.text.value
application_link
Field label Application link
Description Link to the app the post was published by
Field type dimension
Data type string.text.url
application_category
Field label Application category
Description Category of the app the post was published by
Field type dimension
Data type string.text.value
story_tags
Field label Story tags
Description List of profiles tagged in the message/story text
Field type dimension
Data type string.text.value

POST METRICS

posts
Field label Posts
Description Posts
Field type metric
Data type int.number.value
likes_count
Field label Likes
Description Total count post likes
Field type metric
Data type int.number.value
reactions_love
Field label Reactions: Love
Description Total "Love" reactions
Field type metric
Data type int.number.value
reactions_wow
Field label Reactions: Wow
Description Total "Wow" reactions
Field type metric
Data type int.number.value
reactions_haha
Field label Reactions: Haha
Description Total "Haha" reactions
Field type metric
Data type int.number.value
reactions_sad
Field label Reactions: Sad
Description Total "Sad" reactions
Field type metric
Data type int.number.value
reactions_angry
Field label Reactions: Angry
Description Total "Angry" reactions
Field type metric
Data type int.number.value
reactions_thankful
Field label Reactions: Thankful
Description Total "Thankful" reactions
Field type metric
Data type int.number.value
reactions_pride
Field label Reactions: Pride
Description Total "Pride" reactions
Field type metric
Data type int.number.value
reactions_count
Field label Reactions
Description Total count of reactions to the post
Field type metric
Data type int.number.value
comments_count
Field label Comments
Description Total count of comments on the post
Field type metric
Data type int.number.value
shares_count
Field label Post shares
Description Count of post shares
Field type metric
Data type int.number.value
likesPerPost
Field label Likes per post
Description Count of likes per post
Field type metric
Data type float.number.value
reactionsPerPost
Field label Reactions per post
Description Count of reactions per post
Field type metric
Data type float.number.value
commentsPerPost
Field label Comments per post
Description Count of comments per post
Field type metric
Data type float.number.value
sharesPerPost
Field label Shares per post
Description Count of shares per post
Field type metric
Data type float.number.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
og_object_updated_time
Field label Updated time
Description URL updated time
Field type dimension
Data type string.time.datetime
created_time
Field label Created time
Description The time the post was initially published. For a post about a life event, it will be the date & time of the life event
Field type dimension
Data type string.time.datetime
created_date
Field label Created date
Description The date the post was initially published
Field type dimension
Data type string.time.date
updated_time
Field label Updated time
Description Time when the post was created, edited, or commented upon
Field type dimension
Data type string.time.datetime
updated_date
Field label Updated date
Description Date when the post was created, edited, or commented upon
Field type dimension
Data type string.time.date

URL

url
Field label URL
Description URL
Field type dimension
Data type string.text.url
og_object_id
Field label URL ID
Description URL ID
Field type dimension
Data type int.number.value
og_object_title
Field label Title
Description URL title
Field type dimension
Data type string.text.value
og_object_type
Field label Type
Description URL type
Field type dimension
Data type string.text.value
og_object_description
Field label Description
Description URL description
Field type dimension
Data type string.text.value

URL METRICS

comment_count
Field label Comments
Description URL comment counts
Field type metric
Data type int.number.value
share_count
Field label Shares
Description URL share counts
Field type metric
Data type int.number.value
reaction_count
Field label Reactions
Description URL reaction counts
Field type metric
Data type int.number.value
comment_plugin_count
Field label Comment plugins
Description URL comment plugins counts
Field type metric
Data type int.number.value