Social Media Pages Table

social_media_pages_table

The Social Media Pages table contains daily engagement and reach metrics for connected social media pages, including impressions (paid, viral, unique), views, and fan adds/removes. One row per page per day.

📋
Table Guide
What You Can Answer With This Table

How is page reach trending? — use impressions, impressions_unique, views_total, group by event_date

How much of my reach is paid vs. viral? — use impressions_paid, impressions_viral, impressions

What's my net follower change over a period? — use fan_adds, fan_removes, group by event_date

How do different pages compare on engagement? — use impressions, video_views, fan_adds, group by page_name or channel

Before You Query

Required field: event_date

Each row is per page per day. To see totals across a date range, aggregate (SUM(impressions), etc.) or group by event_date for daily trends.

Key Relationships
Table Join Key What the Join Enables
Social Media Posts page_id Post content, publishing activity, and CTA details for posts on the page.
Social Media Comments page_id Comments made on the page, including sentiment, risk, and visibility status.

When to Use a Different Table

For individual post content and publishing activity → use Social Media Posts. This table only has page-level metrics, not per-post detail.

For comments on your pages or posts → use Social Media Comments.

For public mentions of your brand on accounts you don't own → use Social Media Mentions.

View the full Triple Whale Data Ontology →

Table	Join Key	What the Join Enables
Social Media Posts	`page_id`	Post content, publishing activity, and CTA details for posts on the page.
Social Media Comments	`page_id`	Comments made on the page, including sentiment, risk, and visibility status.

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 values: `meta-analytics`, `twitter-social`
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 about 6 hours ago