SocialMediaMessages
Enables creation and management of social media messages directly from HubSpot's platform.
Table Specific Information
Social media messages can be submitted to your social media channels to make announcements about your products or company.
SELECT
When selecting social media messages, data can be filtered by the MessageGUID or by a combination of Status, ChannelGUID, and TriggerAt. For example:
SELECT * FROM SocialMediaMessages WHERE MessageGUID = '123456789' SELECT * FROM SocialMediaMessages WHERE Status = 'WAITING' AND ChannelGUID = '123456789' AND TriggerAt > '1/30/2015'
Note that TriggerAt can only be used with the > or >= comparison.
Columns
| Name | Type | ReadOnly | References | Description |
| MessageGUID [KEY] | String | True |
Unique identifier (GUID) for the social media message. | |
| ContentBody | String | False |
The main text content of the social media message. | |
| ContentOriginalBody | String | False |
Original unaltered text content of the message, before any modifications. | |
| ContentPhotoUrl | String | False |
URL pointing to the photo or image associated with the social media message. | |
| ContentUncompressedLinks | String | False |
List of any unshortened (uncompressed) links included in the message content. | |
| TriggerAt | Datetime | False |
The scheduled date and time when the social media message is set to be published. | |
| Channel | String | True |
The name of the social media channel (such as Facebook or LinkedIn) where the message will be posted. | |
| ChannelGUID | String | False |
GUID for the social media channel associated with the message. | |
| CampaignGUID | String | True |
GUID referencing the marketing campaign linked to the social media message. | |
| CampaignName | String | True |
Name of the marketing campaign associated with the social media message. | |
| Clicks | Long | True |
The total number of clicks recorded by HubSpot for links included in the social media message. | |
| ClientTag | String | True |
Tags or labels assigned by the client for categorizing or identifying the message. | |
| CreatedAt | Datetime | True |
Timestamp showing when the social media message was created. | |
| CreatedBy | Long | True |
ID of the user who created the social media message. | |
| FinishedAt | Datetime | True |
Timestamp indicating when the social media message finished posting. | |
| ForeignId | String | True |
Optional foreign identifier used to reference the message externally. | |
| GroupGUID | String | True |
GUID referencing the group associated with the social media message. | |
| IsFailed | Boolean | True |
Boolean indicating whether the social media message failed to post. | |
| IsPending | Boolean | True |
Boolean indicating whether the message is still pending and awaiting publication. | |
| IsPublished | Boolean | True |
Boolean indicating whether the message has been successfully published. | |
| IsRetry | Boolean | True |
Boolean indicating whether the message is currently being retried after a failure. | |
| Message | String | True |
Message returned by the social media platform, which can contain confirmation or error details. | |
| MessageUrl | String | True |
URL returned by the social media platform, typically pointing to the published post or error message. | |
| RemoteContentId | String | True |
ID referencing the remote content linked to the social media message, if applicable. | |
| RemoteContentType | String | True |
Type of remote content (such as image or video) associated with the message, if any. | |
| Status | String | True |
Current status of the social media message (such as SUCCESS, ERROR, or PENDING). The allowed values are SUCCESS, WAITING, CANCELED, ERROR_FATAL. | |
| UpdatedBy | Long | True |
ID of the user who last modified or updated the social media message. | |
| ExtraUrlParameters | String | True |
Optional input-only property for specifying additional query parameters. Format parameters as name=value pairs separated by commas (for example: 'param1=value1, param2=value2, param3=value3'). |