Social Media Pages Table

social_media_pages_table

The Social Media Pages table stores daily performance and engagement metrics for connected social media pages, including impressions, likes, views, and page-level metadata. Querying this table lets you analyze page reach, paid vs. organic performance, audience engagement, and visibility trends over time.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Event Date	`event_date`	date	The date the event occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day	`event_date.day`	date	The day the event occurred. Derived from `event_date`.
Event Week	`event_date.week`	date	The Sunday of the week during which the event occurred. Derived from `event_date`.
Event Month	`event_date.month`	date	The month during which the event occurred. Derived from `event_date`.
Event Quarter	`event_date.quarter`	date	The first month of the quarter during which the event occurred. Derived from `event_date`.
Event Year	`event_date.year`	date	The year during which the event occurred. Derived from `event_date`.
About	`about`	string	A short description of the page, often provided by the business or creator. Example value: `Custom apparel designed to stand out`
Category	`category`	string	The business category assigned to the page. Example values: `Marketing Agency`, `Business service`
Channel	`channel`	string	The channel where the page was published. Example value: `meta-analytics`
Cover URL	`cover_url`	string	The URL of the page's cover image. Example value: `https://scontent-example.fbcdn.net/v/t39.30808-6/cover_image.jpg`
Image URL	`image_url`	string	The URL of the page's profile image. Example value: `https://scontent-example.fbcdn.net/v/t39.30808-1/profile_image.jpg`
Page ID	`page_id`	string	The ID of the page. Example value: `123456789012345`
Page Name	`page_name`	string	The name of the social media page. Example values: `Acme Apparel`, `Horizon Handcrafted Soaps`
Page Permalink	`page_permalink`	string	The permanent link to the page. Example value: `https://www.facebook.com/123456789`
Website	`website`	string	The website URL associated with the page. Example values: `https://example.com/products/sample-product`, `https://www.example.com/`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Fan Adds	`fan_adds`	numeric	The number of new fans (followers) who followed the page during the selected period.
Fan Removes	`fan_removes`	numeric	The number of fans (followers) who unfollowed the page during the selected period.
Impressions	`impressions`	numeric	The total number of times any content from or about the page was shown on a user's screen, including posts, ads, stories, mentions, and shares. Includes repeat exposures.
Paid Impressions	`impressions_paid`	numeric	The total number of times paid content from the page, such as ads or boosted posts, was shown on a user's screen. Includes repeat exposures.
Unique Impressions	`impressions_unique`	numeric	The number of unique users who saw any content from or about the page during the selected period.
Viral Impressions	`impressions_viral`	numeric	The number of times content from the page was displayed to users through social interactions, such as shares, mentions, or recommendations.
Video Views	`video_views`	numeric	The number of times videos were viewed on the page during the selected period.
Total Views	`views_total`	numeric	The total number of times users visited the page itself during the selected period, including repeat visits.

Updated 15 days ago