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 breakdown of comments on my posts? — use sentiment, comment_text, group by sentiment
• Which comments are high risk and need review? — use risk, comment_text, visibility_status, filter risk = 'high'
• Which posts or pages get the most comment activity? — use post_id or page_id, comment_id, group by post_id or page_id
• Which comments have been hidden or deleted, and by whom? — use visibility_status, visibility_changed_by, visibility_changed_at

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 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.