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	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 Brand Mentions. This table only contains posts you 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.