Social Media Posts Table

social_media_posts_table

The Social Media Posts table catalogs posts published to connected social media pages, including post content, publishing status, CTA details, and platform-provided context. One row per post.

📋
Table Guide
What You Can Answer With This Table

What has been published on my connected social pages recently? — use post_text, publisher_name, created_at, filter by channel or page_id

Which posts are live vs. unpublished? — use is_published, post_text

What CTAs are being used across my posts? — use cta_type, cta_url, group by cta_type

How is post activity split across channels and publishers? — use channel, publisher_name, type, group as needed

Before You Query

This table is not time-series. No event_date filter is needed. Use created_at or updated_at if you want to narrow to a time range.

Key Relationships
Table Join Key What the Join Enables
Social Media Pages page_id Page-level engagement and reach metrics (impressions, views, fan adds) plus page metadata (name, category, permalink).
Social Media Comments post_id Comment content, sentiment, visibility status, and risk assessment on each post.

When to Use a Different Table

For daily engagement and reach metrics on your pages → use Social Media Pages. This table covers post content and publishing activity, not aggregated page performance.

For comments on your posts → use Social Media Comments.

For public mentions of your brand on other accounts' posts → use Social Media Mentions. This table only contains posts you published on your own connected pages.

View the full Triple Whale Data Ontology →

Table	Join Key	What the Join Enables
Social Media Pages	`page_id`	Page-level engagement and reach metrics (impressions, views, fan adds) plus page metadata (name, category, permalink).
Social Media Comments	`post_id`	Comment content, sentiment, visibility status, and risk assessment on each post.

Dimensions

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

Title	ID	Type	Description
Channel	`channel`	string	The channel where the post was published. Example values: `meta-analytics`, `twitter-social`
Created Date	`created_at`	timestamp	The time the post was created. Formatted according to the ISO 8601 international standard. Example value: `2025-07-16 04:32:29`
Call-to-Action Type	`cta_type`	string	The type of call-to-action configured for the post. Example values: `SHOP_NOW`, `SIGN_UP`, `LEARN_MORE`
Call-to-Action URL	`cta_url`	string	The URL linked to the call-to-action button on the post. Example value: `https://example.com/products/summer-collection`
Event	`event`	string	A platform-generated text string providing extra context about the post, such as page updates or location check-ins. Example values: `BlueWave Apparel updated their cover photo.`, `EcoLoom Studio is in Barcelona, Spain.`
Is Published	`is_published`	boolean	Indicates whether the post is currently published and visible on the page. Possible values: `true`, `false`
Page ID	`page_id`	string	The ID of the page. Example value: `123456789012345`
Post ID	`post_id`	string	The ID of the post. Example value: `123456789012345_987654321098765`
Post Permalink	`post_permalink`	string	The permanent link to the post on the social platform. Example value: `https://www.facebook.com/123456789/posts/987654321`
Post Text	`post_text`	string	The text content of the post. Example value: `Show your love story on a custom T-shirt!`
Publisher ID	`publisher_id`	string	The ID of the user, page, group, or event that published the post. Example value: `987654321098735`
Publisher Name	`publisher_name`	string	The name of the user, page, group, or event that published the post. Example values: `BrightThreads`, `Urban Tee Co.`
Post Type	`type`	string	The format of the post, indicating what kind of media or action it includes. Example values: `added_photos`, `added_video`
Updated Date	`updated_at`	timestamp	The time the post was last updated. Formatted according to the ISO 8601 international standard. Example value: `2025-07-20 10:14:05`

Updated about 6 hours ago