Sprout Social data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: POST

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
posts__customer_profile_id
Display name Sprout profile ID
Description The Sprout-specific ID associated with the social network profile
Field type dimension
Data type string.text.value
posts__customers__customer_profile_groups
Display name Profile group IDs
Description A pipe-separated list of group IDs that the profile belongs to
Field type dimension
Data type string.text.value
posts__customers__customer_profile_link
Display name Profile link
Description A link to the profile in the social network
Field type dimension
Data type string.text.url
posts__customers__customer_profile_name
Display name Profile name
Description The name of the profile in Sprout Social
Field type dimension
Data type string.text.value
posts__customers__customer_profile_native_id
Display name Profile native ID
Description The unique ID of the profile on the social network
Field type dimension
Data type string.text.value
posts__customers__native_customer_profile_name
Display name Native profile name
Description The name of the profile in the social network
Field type dimension
Data type string.text.value
posts__customers__network_type
Display name Profile network type
Description The social network type associated with the profile
Field type dimension
Data type string.text.value
posts__date
Display name Date
Field type dimension
Data type string.time.date
posts__lifetime_impressions
Display name Impressions
Description Impressions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__lifetime_reactions
Display name Reactions
Description Reactions accumulated over the lifetime of the post
Field type metric
Data type int.number.value
posts__post_created_time
Display name Post created datetime
Description Publication date and time of the post, it will be a valid iso8601 timestamp
Field type dimension
Data type string.time.datetime
posts__post_id
Display name Post ID
Description A unique ID associated with the post. Takes the form of "p:[profile_id]_[post_id]"
Field type dimension
Data type string.text.value
posts__post_permalink
Display name Post permalink
Description A permanent link to the post in the source platform
Field type dimension
Data type string.text.url
posts__post_sender_email
Display name Sender email
Description Email address of the team member that sent this post
Field type dimension
Data type string.text.value
posts__post_sender_first_name
Display name Sender first name
Description First name of the team member that sent this post
Field type dimension
Data type string.text.value
posts__post_sender_id
Display name Sender ID
Description ID of the team member that sent this post via Sprout
Field type dimension
Data type string.text.value
posts__post_sender_last_name
Display name Sender last name
Description Last name of the team member that sent this post
Field type dimension
Data type string.text.value
posts__post_tags
Display name Post tags
Description Tags associated with the post. If multiple tags are used for a given post, they'll be separated by a comma
Field type dimension
Data type string.text.value
posts__post_text
Display name Post text
Description Field containing the text of the post
Field type dimension
Data type string.text.value
posts__profile_id
Display name Profile ID
Description The ID of the profile being tracked, prefixed with an Sprout code that represents where the data was collected
Field type dimension
Data type string.text.value

Table: TAG

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
tags__is_active
Display name Is active
Description Whether this tag is active (or archived) in Sprout Social
Field type dimension
Data type bool
tags__is_in_group
Display name Is in group
Description Whether or not this tag is available in any customer group
Field type dimension
Data type bool
tags__tag_id
Display name Tag ID
Description The ID used by Sprout to identify this post tag
Field type dimension
Data type string.text.value
tags__tag_text
Display name Tag text
Description The text of the tag
Field type dimension
Data type string.text.value