- 27 Jul 2021
- 1 Minute to read
Facebook Posts Data Dictionary
- Updated on 27 Jul 2021
- 1 Minute to read
These are the resources available for the Facebook Posts data source, along with their table mappings. Depending on the resource, Panoply makes use of one or more tables for importing data. Here they are, grouped by resource:
This table contains posts and their share data.
This table contains posts and the reaction of various users to it.
This table contains post comments and their comment replies.
This table contains the reactions of various users to either post comments or comment replies.
This table contains the insights of your Facebook Page's posts, specifically, video posts. It contains fields that represent the video-related metrics of your video post, like how many times the video was played, the number of people who viewed it, etc. These fields are prefixed with the word
posts in them.
This table contains the insights of your Facebook Page's posts, specifically preferring those metrics that can be aggregated for a lifetime.
Take note that other metrics of a post are aggregated differently, either for days, weeks, or months. Again, this table stores only the ones that can be aggregated for a lifetime.
There are also numerous fields that are flattened by Panoply. Flattened fields are easy to recognize. They're those fields with similar names but are differentiated by a suffix, which can either be a text or number value. The suffix is based on the propertis of the source nested objects.
For example, the
post_video_retention_graph_1 fields are flattened fields based from the
post_video_retention_graph object. The numbers
1, and so on, are the suffixes that represent each property of the object.
Likewise, the fields
post_video_view_time_by_country_id_canada (and a list of other countries) were flattened from the
post_video_view_time_by_country_id object. The respective country names also represent each property of the object.
These are the objects (metrics) from the Page Insights resource that are flattened: