SSIS Components for HubSpot

Build 25.0.9434

SocialMediaChannels

Lists social media channels connected to HubSpot, supporting social media engagement tracking.

Table Specific Information

Social media channels in HubSpot represent any social media accounts you have connected for the purposes of posting marketing messages to. Messages can be posted to your social media channels via SocialMediaMessages.

SELECT

When selecting social media channels, data can only be filtered by the ChannelGUID. For example:

SELECT * FROM SocialMediaChannels WHERE ChannelGUID = '123456789'

Columns

Name Type References Description
ChannelGUID [KEY] String Globally unique identifier (GUID) for the social media channel.
AccountGUID String GUID for the account linked to the social media channel.
AccountSlug String Short, human-readable identifier (slug) for the account associated with the social media channel.
AccountType String Type of account, such as Facebook, Twitter, or LinkedIn.
IsActive Boolean Boolean indicating whether the social media channel is currently active.
AutoPublish Boolean Boolean specifying whether posts should be automatically published to this social media channel.
AvatarUrl String URL pointing to the profile image or avatar associated with the social media account.
ChannelId String The unique ID assigned to the channel by the social media platform.
ChannelKey String HubSpot-specific key linked to the social media channel for internal tracking.
ChannelSlug String Human-readable slug associated with the social media channel.
CreatedAt Datetime Timestamp indicating when the social media channel connection was established.
FollowMe Boolean Boolean determining whether HubSpot should enable a follow link for this social media channel.
IsHidden Boolean Boolean indicating whether the social media channel is hidden from view in the dashboard.
Monitoring Boolean Boolean specifying if activity on this channel should be monitored for engagement analytics.
Reach Boolean Boolean indicating whether follower growth tracking is enabled for this social media account.
ReachType String Specifies how follower reach is measured or categorized for this social media channel.
IsShared Boolean Boolean specifying whether the social media channel is shared across multiple users or teams.
Type String Specifies the type of social media platform (such as Facebook, Instagram, or LinkedIn).
UpdatedAt Datetime Timestamp showing the last time this social media channel's details were updated.
UserName String Username or handle associated with the social media account.
ExtraUrlParameters String Optional input-only property for specifying additional query parameters when retrieving data. Format as name=value pairs separated by commas, for example: 'param1=value1, param2=value2, param3=value3'.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434