Introduction

Datasources and destinations

Fields listing for Facebook Public Data

Page Id
The ID representing a Facebook Page.
Field IDpage/id
TypeTEXT
Data Typedimension
Page Name
The name of the Page
Field IDpage/name
TypeTEXT
Data Typedimension
Page Username
The alias of the Page. For example, for www.facebook.com/platform the username is 'platform'.
Field IDpage/username
TypeTEXT
Data Typedimension
Page Description
The description of the Page. Can be read with Page Public Content Access or Page Public Metadata Access. Note that this value is mapped to the Additional Information setting in the Edit Page Info user interface.
Field IDpage/description
TypeTEXT
Data Typedimension
Page Display Subtext
Subtext about the Page being viewed.
Field IDpage/display_subtext
TypeTEXT
Data Typedimension
Page Current location
Current location of the Page.
Field IDpage/current_location
TypeTEXT
Data Typedimension
Page Category
The Page's category. e.g. Product/Service, Computers/Technology.
Field IDpage/category
TypeTEXT
Data Typedimension
Page About
Information about the Page. This value maps to the Description setting in the Edit Page Info user interface. Limit of 100 characters.
Field IDpage/about
TypeTEXT
Data Typedimension
Page General Info
General information provided by the Page.
Field IDpage/general_info
TypeTEXT
Data Typedimension
Page Company Overview
The company overview. Applicable to Companies.
Field IDpage/company_overview
TypeTEXT
Data Typedimension
Page Link
The Page's Facebook URL.
Field IDpage/link
TypeTEXT
Data Typedimension
Page Website
The URL of the Page's website.
Field IDpage/website
TypeTEXT
Data Typedimension
Page Phone
Phone number provided by a Page.
Field IDpage/phone
TypeTEXT
Data Typedimension
Page Awards
The awards information of the film. Applicable to Films.
Field IDpage/awards
TypeTEXT
Data Typedimension
Page Founded
When the company was founded. Applicable to Pages in the Company category.
Field IDpage/founded
TypeTEXT
Data Typedimension
Page Products
The products of this company. Applicable to Companies
Field IDpage/products
TypeTEXT
Data Typedimension
Page Mission
The company mission. Applicable to Companies.
Field IDpage/mission
TypeTEXT
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Fan Count
The number of users who like the Page. For Global Pages this is the count for all Pages across the brand. For New Page Experience Pages, this field will return followers_count.
Field IDfan_count
TypeNUMBER
Data Typemetric
Follower Count
Number of page followers.
Field IDfollowers_count
TypeNUMBER
Data Typemetric
Talking About Count
The number of people talking about this Page.
Field IDtalking_about_count
TypeNUMBER
Data Typemetric
Checkins
Number of checkins at a place represented by a Page.
Field IDcheckins
TypeNUMBER
Data Typemetric
Post Id
The ID representing a Facebook Post.
Field IDpost/id
TypeTEXT
Data Typedimension
Post Created At
Date and time the Post was created.
Field IDpost/created_time
TypeYEAR_MONTH_DAY
Data Typedimension
Post Updated At
Date and time the Post was updated.
Field IDpost/updated_time
TypeYEAR_MONTH_DAY
Data Typedimension
Post Status Type
The status type.
Field IDpost/status_type
TypeTEXT
Data Typedimension
Post Permalink Url
Static URl fort the publication.
Field IDpost/permalink_url
TypeTEXT
Data Typedimension
Post Description
Description of the post.
Field IDpost/attachments.description
TypeTEXT
Data Typedimension
Post Title
Title of the post.
Field IDpost/attachments.title
TypeTEXT
Data Typedimension
Post Type
indicate the object type of the post.
Field IDpost/attachments.type
TypeTEXT
Data Typedimension
Post From Id
Id of the user account for the post.
Field IDpost/from.id
TypeTEXT
Data Typedimension
Post From Name
Full name of the user account of the post.
Field IDpost/from.name
TypeTEXT
Data Typedimension
Post Story
Text from stories not generated by users, like a picture publication on the wall by someone else.
Field IDpost/story
TypeTEXT
Data Typedimension
Post Full Picture
Full Picture Link for published picture.
Field IDpost/full_picture
TypeTEXT
Data Typedimension
Post Message
The status message of the post.
Field IDpost/message
TypeTEXT
Data Typedimension
Post Place
Id of the place associate with this post.
Field IDpost/place
TypeTEXT
Data Typedimension
Post Source
URL to flash movie or video file attach to this post.
Field IDpost/attachments.media.source
TypeTEXT
Data Typedimension
Post Link
Link attached to the post.
Field IDpost/attachments.link
TypeTEXT
Data Typedimension
Post Application Name
Name of application used to publish the post.
Field IDpost/application.name
TypeTEXT
Data Typedimension
Post Application Link
Link to the app used to publish the post.
Field IDpost/application.link
TypeTEXT
Data Typedimension
Post Application Category
Category to the app used to publish the post.
Field IDpost/application.category
TypeTEXT
Data Typedimension
Post Story Tags
Story tags of the Post. Sting composed by tags splitted by commas.
Field IDpost/story_tags
TypeTEXT
Data Typedimension
Likes Count
The number of likes for this post.
Field IDlikes_count
TypeNUMBER
Data Typemetric
Reactions Love
The number of love reactions for this post.
Field IDreactions_love
TypeNUMBER
Data Typemetric
Reactions Wow
The number of Wow reactions for this post.
Field IDreactions_wow
TypeNUMBER
Data Typemetric
Reactions Haha
The number of Haha reactions for this post.
Field IDreactions_haha
TypeNUMBER
Data Typemetric
Reactions Sad
The number of Sad reactions for this post.
Field IDreactions_sad
TypeNUMBER
Data Typemetric
Reactions Angry
The number of angry reactions for this post.
Field IDreactions_angry
TypeNUMBER
Data Typemetric
Reactions Thankful
The number of thankful reactions for this post.
Field IDreactions_thankful
TypeNUMBER
Data Typemetric
Reactions Pride
The number of pride reactions for this post.
Field IDreactions_pride
TypeNUMBER
Data Typemetric
Reactions Care
The number of care reactions for this post.
Field IDreactions_care
TypeNUMBER
Data Typemetric
Reactions Fire
The number of fire reactions for this post.
Field IDreactions_fire
TypeNUMBER
Data Typemetric
Reactions Hundred
The number of hundred reactions for this post.
Field IDreactions_hundred
TypeNUMBER
Data Typemetric
Reactions Count
The total count of reactions for this post.
Field IDreactions_count
TypeNUMBER
Data Typemetric
Comments Count
The number of comments for this post.
Field IDcomments_count
TypeNUMBER
Data Typemetric
Shares Count
the number of shares of this post.
Field IDshares_count
TypeNUMBER
Data Typemetric
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension
Post Count
Post Count
Field IDposts
TypeNUMBER
Data Typemetric
Reaction Per Post
Reaction Per Post
Field IDreactions_per_post
TypeNUMBER
Data Typemetric
Likes Per Post
Likes Per Post
Field IDlikes_per_post
TypeNUMBER
Data Typemetric
Comments Per Post
Comments Per Post
Field IDcomments_per_post
TypeNUMBER
Data Typemetric
Shares Per Post
Shares Per Post
Field IDshares_per_post
TypeNUMBER
Data Typemetric