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

# Social Media Posts Table

social_media_posts_table

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  | Use This Join To                                                                              |
> | --------------------------------------------------------------------------------------- | --------- | --------------------------------------------------------------------------------------------- |
> | [Social Media Pages](https://triplewhale.readme.io/docs/social-media-pages-table)       | `page_id` | Compare post performance across social profiles using page audience and reach context.        |
> | [Social Media Comments](https://triplewhale.readme.io/docs/social-media-comments-table) | `post_id` | Measure audience response to each post using comment sentiment, visibility, and risk signals. |
>
> <br />
>
> **When to Use a Different Table**
>
> * Use [Social Media Pages table](https://triplewhale.readme.io/docs/social-media-pages-table) when you need daily engagement and reach metrics for your connected pages. The Social Media Posts table is for post content and publishing activity.
> * Use [Social Media Comments table](https://triplewhale.readme.io/docs/social-media-comments-table) when you need comments on your posts. The Social Media Posts table is for the posts themselves.
> * 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 posts from accounts you do not own. The Social Media Posts table is for posts published on your own connected pages.
>
> *[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 post was published.

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

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

      <td>
        `created_at`
      </td>

      <td>
        timestamp
      </td>

      <td>
        The time the post 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>
        Call-to-Action Type
      </td>

      <td>
        `cta_type`
      </td>

      <td>
        string
      </td>

      <td>
        The type of call-to-action configured for the post.

        Example values: `SHOP_NOW`, `SIGN_UP`, `LEARN_MORE`
      </td>
    </tr>

    <tr>
      <td>
        Call-to-Action URL
      </td>

      <td>
        `cta_url`
      </td>

      <td>
        string
      </td>

      <td>
        The URL linked to the call-to-action button on the post.

        Example value: `https://example.com/products/summer-collection`
      </td>
    </tr>

    <tr>
      <td>
        Event
      </td>

      <td>
        `event`
      </td>

      <td>
        string
      </td>

      <td>
        A platform-generated text string providing extra context about the post, such as page updates or location check-ins.

        Example values: `BlueWave Apparel updated their cover photo.`, `EcoLoom Studio is in Barcelona, Spain.`
      </td>
    </tr>

    <tr>
      <td>
        Is Published
      </td>

      <td>
        `is_published`
      </td>

      <td>
        boolean
      </td>

      <td>
        Indicates whether the post is currently published and visible on the page.

        Possible values: `true`, `false`
      </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: `123456789012345_987654321098765`
      </td>
    </tr>

    <tr>
      <td>
        Post Permalink
      </td>

      <td>
        `post_permalink`
      </td>

      <td>
        string
      </td>

      <td>
        The permanent link to the post on the social platform.

        Example value: `https://www.facebook.com/123456789/posts/987654321`
      </td>
    </tr>

    <tr>
      <td>
        Post Text
      </td>

      <td>
        `post_text`
      </td>

      <td>
        string
      </td>

      <td>
        The text content of the post.

        Example value: `Show your love story on a custom T-shirt!`
      </td>
    </tr>

    <tr>
      <td>
        Publisher ID
      </td>

      <td>
        `publisher_id`
      </td>

      <td>
        string
      </td>

      <td>
        The ID of the user, page, group, or event that published the post.

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

    <tr>
      <td>
        Publisher Name
      </td>

      <td>
        `publisher_name`
      </td>

      <td>
        string
      </td>

      <td>
        The name of the user, page, group, or event that published the post.

        Example values: `BrightThreads`, `Urban Tee Co.`
      </td>
    </tr>

    <tr>
      <td>
        Post Type
      </td>

      <td>
        `type`
      </td>

      <td>
        string
      </td>

      <td>
        The format of the post, indicating what kind of media or action it includes.

        Example values: `added_photos`, `added_video`
      </td>
    </tr>

    <tr>
      <td>
        Updated Date
      </td>

      <td>
        `updated_at`
      </td>

      <td>
        timestamp
      </td>

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

        Example value: `2025-07-20 10:14:05`
      </td>
    </tr>
  </tbody>
</Table>

<br />