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	Use This Join To
Social Media Posts	post_id	Explain which post creative sparked each comment.
Social Media Pages	page_id	Roll comment response up by page using page metadata and engagement metrics.

When to Use a Different Table

• Use Social Media Posts table when you need post content or publishing activity. The Social Media Comments table is for comments on your own connected pages and posts.
• Use Social Media Brand Mentions table when you need public mentions of your brand on accounts you do not own. The Social Media Comments table is for 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.