Facebook Pages Data Dictionary - Metadata

There are two types of tables collected from the Facebook Pages data source. This page will define the data dictionary for the Metadata tables.

Metadata tables

Metadata tables store information regarding your selected Facebook Page (s), such as the category and description of the page, email and operating hours that are listed in its About section (if the page is for a business) , the year and month when the page was first created and more.

These tables are always created for a Facebook Pages data source. They're based on the Page or Pages you've selected when configuring the data source, and not on the metric categories (more on this on the next section).

The main metadata table is named facebook\_pages\_metadata while the rest have the facebook_pages_metadata prefix in their table names. They are:

facebook_pages_metadata

The primary or parent table of all metadata-related tables. In this case, metadata is information about the page itself, as opposed to the insights tables which contain information about page interaction. These tables store data regarding the Facebook Page or Pages you've selected on the configuration page of your Facebook Pages data source. Most of this data is listed in the About section of your Page or Pages.

Facebook Pages Metadata Data Dictionary

The Page object of Facebook's Graph API is your primary reference for understanding all of the metadata tables. If there are additional references specific to each table, we'll list them within the description of the table.

facebook_pages_metadata_category_list

This table stores the category names that describe or classify the Page. Each category defined for your Page is saved as one record inside this table.

Category List Data Dictionary

facebook_pages_metadata_connected_instagram_account

A table to store the Instagram account connected to a Page via page settings.

Connected Instagram Account Data Dictionary

facebook_pages_metadata_emails

A table to store the emails listed in the About section of your Page.

facebook_pages_metadata_hours

A table to store your Page's range of opening hours for a day.

The opening hours for a day can have 2 different hour ranges. The fields that represent the range of opening hours for a day are in the form of {day}_{number}_{status}.

{day} is the first three characters of the day of the week, {number} should be either 1 or 2 to allow for the two different hours ranges per day. {status} should be either "open" or "close" to delineate the start or end of a time range.

An example would be “mon_1_open” with value 17:00 and “mon_1_close” with value 21:15, which would represent a single opening range of 5 pm to 9:15 pm on Mondays. If one specific day is open 24 hours, the range should be specified as 00:00 to 24:00.

facebook_pages_metadata_instagram_business_account

A table to store the Instagram account linked to a Page during an Instagram business conversion flow.

facebook_pages_metadata_location

A table to store the location information of your Page. They consist of country, state, city, and ZIP.

facebook_pages_metadata_messenger_ads_default_icebreakers

A table to store the default Ice Breakers of your Page.

Ice breakers provide a way for users to start a conversation with your Page with a list of frequently asked questions.

facebook_pages_metadata_page_about_story

A table to store the Page About Story of your Page.

A Page About Story is a document located in your Page's About section. It tells your Page's story with rich text and images and can be updated as your story evolves.

Page About Story

facebook_pages_metadata_start_info

A table to store the information of when the entity represented by the Page was started or founded.

Start Info

facebook_pages_metadata_voip_info

A table to store a Page's VOIP (Voice over Internet Protocol) information, whether or not the Page can be reached or called via apps or services that use VOIP technology.

Additional reference:

• VOIP Info

VOIP Info