Social Media Posts Table (BETA)

social_media_posts_table

The Social Media Posts table stores data about posts published on connected social media pages, including post content, publishing status, call-to-action details, engagement, and metadata. Querying this table lets you analyze post performance, track publishing activity, and measure audience interaction across platforms.

Dimensions

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

Title

ID

Type

Description

Channel

channel

string

The channel where the post was published.

Example value: meta-analytics

Created Date

created_at

timestamp

The time the post was created. Formatted according to the ISO 8601 international standard.

Example value: 2025-07-16 04:32:29

Call-to-Action Type

cta_type

string

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

Example values: SHOP_NOW, SIGN_UP, LEARN_MORE, WHATSAPP_MESSAGE

Call-to-Action URL

cta_url

string

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

Example value: https://example.com/products/summer-collection

Event

event

string

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.

Is Published

is_published

boolean

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

Possible values: true, false

Page ID

page_id

string

The unique identifier assigned to the page by the platform.

Example value: 123456789012345

Post ID

post_id

string

The unique identifier assigned to the post by the platform.

Example value: 123456789012345_987654321098765

Post Permalink

post_permalink

string

The permanent link to the post on the social platform.

Example value: https://www.facebook.com/123456789/posts/987654321

Post Text

post_text

string

The text content of the post.

Example value: Show your love story on a custom T-shirt!

Publisher ID

publisher_id

string

The unique identifier of the user, page, group, or event that published the post.

Example value: 987654321098735

Publisher Name

publisher_name

string

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

Example values: BrightThreads, Urban Tee Co.

Post Type

type

string

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

Example values: added_photos, added_video

Updated At

updated_at

timestamp

The time the post was last updated. Formatted according to the ISO 8601 international standard.

Example value: 2025-07-20 10:14:05