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 |
| string | The channel where the post was published. Example value: |
Created Date |
| timestamp | The time the post was created. Formatted according to the ISO 8601 international standard. Example value: |
Call-to-Action Type |
| string | The type of call-to-action configured for the post. Example values: |
Call-to-Action URL |
| string | The URL linked to the call-to-action button on the post. Example value: |
Event |
| string | A platform-generated text string providing extra context about the post, such as page updates or location check-ins. Example values: |
Is Published |
| boolean | Indicates whether the post is currently published and visible on the page. Possible values: |
Page ID |
| string | The unique identifier assigned to the page by the platform. Example value: |
Post ID |
| string | The unique identifier assigned to the post by the platform. Example value: |
Post Permalink |
| string | The permanent link to the post on the social platform. Example value: |
Post Text |
| string | The text content of the post. Example value: |
Publisher ID |
| string | The unique identifier of the user, page, group, or event that published the post. Example value: |
Publisher Name |
| string | The name of the user, page, group, or event that published the post. Example values: |
Post Type |
| string | The format of the post, indicating what kind of media or action it includes. Example values: |
Updated At |
| timestamp | The time the post was last updated. Formatted according to the ISO 8601 international standard. Example value: |
Updated about 21 hours ago