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 →

Dimensions

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