---
updatedAt: 2026-05-27T07:16:34.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# Social Media Comments Table

social_media_comments_table

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](https://triplewhale.readme.io/docs/social-media-posts-table) | `post_id` | Explain which post creative sparked each comment.                            |
> | [Social Media Pages](https://triplewhale.readme.io/docs/social-media-pages-table) | `page_id` | Roll comment response up by page using page metadata and engagement metrics. |
>
> <br />
>
> **When to Use a Different Table**
>
> * Use [Social Media Posts table](https://triplewhale.readme.io/docs/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](https://triplewhale.readme.io/docs/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 →](https://triplewhale.readme.io/docs/triple-whale-data-ontology)*

# Dimensions

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

<Table align={["left","left","left","left"]}>
  <thead>
    <tr>
      <th>
        Title
      </th>

      <th>
        ID
      </th>

      <th>
        Type
      </th>

      <th>
        Description
      </th>
    </tr>
  </thead>

  <tbody>
    <tr>
      <td>
        Channel
      </td>

      <td>
        `channel`
      </td>

      <td>
        string
      </td>

      <td>
        The channel where the comment was published.

        Example values: `meta-analytics`, `twitter-social`
      </td>
    </tr>

    <tr>
      <td>
        Comment ID
      </td>

      <td>
        `comment_id`
      </td>

      <td>
        string
      </td>

      <td>
        The ID of the comment.

        Example value: `530861436559487_731664866264638`
      </td>
    </tr>

    <tr>
      <td>
        Comment Text
      </td>

      <td>
        `comment_text`
      </td>

      <td>
        string
      </td>

      <td>
        The text content of the comment.

        Example value: `Love this design! Do you ship internationally?`
      </td>
    </tr>

    <tr>
      <td>
        Created Date
      </td>

      <td>
        `created_at`
      </td>

      <td>
        string
      </td>

      <td>
        The time the comment was created. Formatted according to the [ISO 8601](https://www.iso.org/iso-8601-date-and-time-format.html) international standard.

        Example value: `2025-07-16 04:32:29`
      </td>
    </tr>

    <tr>
      <td>
        Page ID
      </td>

      <td>
        `page_id`
      </td>

      <td>
        string
      </td>

      <td>
        The ID of the page.

        Example value: `123456789012345`
      </td>
    </tr>

    <tr>
      <td>
        Post ID
      </td>

      <td>
        `post_id`
      </td>

      <td>
        string
      </td>

      <td>
        The ID of the post.

        Example value: `120347795274735_430061436559488`
      </td>
    </tr>

    <tr>
      <td>

      </td>

      <td>
        `risk`
      </td>

      <td>
        string
      </td>

      <td>
        The risk level assessment of the comment.

        Example values: `low`, `medium`, `high`
      </td>
    </tr>

    <tr>
      <td>

      </td>

      <td>
        `sentiment`
      </td>

      <td>
        string
      </td>

      <td>
        The sentiment analysis result for the comment.

        Example values: `positive`, `negative`, `neutral`
      </td>
    </tr>

    <tr>
      <td>

      </td>

      <td>
        `topic`
      </td>

      <td>
        string
      </td>

      <td>
        The topic or category classification of the comment.

        Example values: `product_inquiry`, `shipping`, `complaint`
      </td>
    </tr>

    <tr>
      <td>
        User ID
      </td>

      <td>
        `user_id`
      </td>

      <td>
        string
      </td>

      <td>
        The ID of the user that made the comment.

        Example value: `24237031855927250`
      </td>
    </tr>

    <tr>
      <td>
        User Name
      </td>

      <td>
        `user_name`
      </td>

      <td>
        string
      </td>

      <td>
        The name of the user that made the comment.

        Example value: `Jane Smith`
      </td>
    </tr>

    <tr>
      <td>

      </td>

      <td>
        `visibility_changed_at`
      </td>

      <td>
        string
      </td>

      <td>
        The timestamp of the last visibility status change.

        Example value: `2025-07-16 04:32:29`
      </td>
    </tr>

    <tr>
      <td>

      </td>

      <td>
        `visibility_changed_by`
      </td>

      <td>
        string
      </td>

      <td>
        Who changed the visibility status of the comment.

        Example values: `user`, `system`
      </td>
    </tr>

    <tr>
      <td>

      </td>

      <td>
        `visibility_status`
      </td>

      <td>
        string
      </td>

      <td>
        The visibility status of the comment.

        Example values: `visible`, `hidden`, `deleted`
      </td>
    </tr>
  </tbody>
</Table>

<br />