The Social Media Comments table captures user comments made on your connected social media pages and posts, including visibility status, topic, sentiment, and risk assessment. One row per comment.

📋

Table Guide

What You Can Answer With This Table

• What's the sentiment and risk breakdown of comments on my posts? — use sentiment, risk, comment_text
• Which posts or pages get the most comment activity or moderation actions? — use post_id, comment_id, visibility_status

Before You Query

• This table is not time-series. No event_date filter is needed. Use created_at if you want to narrow to when comments were posted.

Key Relationships

Table	Join Key	What the Join Enables
Social Media Posts	post_id	Post content, CTA details, and publisher info for the commented post.
Social Media Pages	page_id	Page metadata and daily engagement metrics (impressions, reach, fans) for the page the comment is on.

When to Use a Different Table

• For post content or publishing activity (not comments) → use Social Media Posts.
• For page-level engagement (impressions, reach, follower changes) → use Social Media Pages.
• For public mentions of your brand on accounts you don't own → use Social Media Brand Mentions. This table is limited to comments on your own connected pages and posts.

View the full Triple Whale Data Ontology →

Dimensions

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