Social Media Posts Table

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`
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 ID of the page. Example value: `123456789012345`
Post ID	`post_id`	string	The ID of the post. 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 ID 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 Date	`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`

Updated 16 days ago