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, and is it live? — use post_text, publisher_name, is_published

Which CTAs, channels, or publishers are represented across posts? — use cta_type, channel, publisher_name

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 Use This Join To
Social Media Pages page_id Compare post performance across social profiles using page audience and reach context.
Social Media Comments post_id Measure audience response to each post using comment sentiment, visibility, and risk signals.

When to Use a Different Table

Use Social Media Pages table when you need daily engagement and reach metrics for your connected pages. The Social Media Posts table is for post content and publishing activity.

Use Social Media Comments table when you need comments on your posts. The Social Media Posts table is for the posts themselves.

Use Social Media Brand Mentions table when you need public mentions of your brand on posts from accounts you do not own. The Social Media Posts table is for posts published on your own connected pages.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
Social Media Pages	`page_id`	Compare post performance across social profiles using page audience and reach context.
Social Media Comments	`post_id`	Measure audience response to each post using comment sentiment, visibility, and risk signals.

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 7 days ago