--- title: "Sprout Social data warehouse table groups" slug: "sprout-social-data-warehouse-table-groups" description: "Explore the complete Supermetrics data warehouse table groups for Sprout Social. See all the tables and the fields included in them." updated: 2026-03-05T14:09:10Z published: 2026-03-05T14:09:10Z canonical: "docs.supermetrics.com/sprout-social-data-warehouse-table-groups" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # Sprout Social data warehouse table groups Search fields ### 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| | | --- | | 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Sprout profile ID \| \| Description \| The Sprout-specific ID associated with the social network profile \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Sprout profile ID | | Description | The Sprout-specific ID associated with the social network profile | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Profile link \| \| Description \| A link to the profile in the social network \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Profile link | | Description | A link to the profile in the social network | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Profile name \| \| Description \| The name of the profile in Sprout Social \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Profile name | | Description | The name of the profile in Sprout Social | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Profile native ID \| \| Description \| The unique ID of the profile on the social network \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Profile native ID | | Description | The unique ID of the profile on the social network | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Native profile name \| \| Description \| The name of the profile in the social network \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Native profile name | | Description | The name of the profile in the social network | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Profile network type \| \| Description \| The social network type associated with the profile \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Profile network type | | Description | The social network type associated with the profile | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| posts__date \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | posts__date | | \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Display name | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| posts__lifetime_impressions \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Description \\| Impressions accumulated over the lifetime of the post \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Description \| Impressions accumulated over the lifetime of the post \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | posts__lifetime_impressions | | \| Display name \| Impressions \| \| --- \| --- \| \| Description \| Impressions accumulated over the lifetime of the post \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Impressions | | Description | Impressions accumulated over the lifetime of the post | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| posts__lifetime_reactions \| \| --- \| \| \\| Display name \\| Reactions \\| \\| --- \\| --- \\| \\| Description \\| Reactions accumulated over the lifetime of the post \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Reactions \| \| Description \| Reactions accumulated over the lifetime of the post \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | posts__lifetime_reactions | | \| Display name \| Reactions \| \| --- \| --- \| \| Description \| Reactions accumulated over the lifetime of the post \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Display name | Reactions | | Description | Reactions accumulated over the lifetime of the post | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| 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](/apidocs/field-data-types#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](/apidocs/field-data-types#time) \| | | 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](/apidocs/field-data-types#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](/apidocs/field-data-types#time) | | \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Post permalink \| \| Description \| A permanent link to the post in the source platform \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Post permalink | | Description | A permanent link to the post in the source platform | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Sender email \| \| Description \| Email address of the team member that sent this post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Sender email | | Description | Email address of the team member that sent this post | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Sender first name \| \| Description \| First name of the team member that sent this post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Sender first name | | Description | First name of the team member that sent this post | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Sender ID \| \| Description \| ID of the team member that sent this post via Sprout \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Sender ID | | Description | ID of the team member that sent this post via Sprout | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Sender last name \| \| Description \| Last name of the team member that sent this post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Sender last name | | Description | Last name of the team member that sent this post | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) | | \| posts__post_text \| \| --- \| \| \\| Display name \\| Post text \\| \\| --- \\| --- \\| \\| Description \\| Field containing the text of the post \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Post text \| \| Description \| Field containing the text of the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | posts__post_text | | \| Display name \| Post text \| \| --- \| --- \| \| Description \| Field containing the text of the post \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Post text | | Description | Field containing the text of the post | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) | ### 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| | | --- | | 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](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) | | \| tags__is_active \| \| --- \| \| \\| Display name \\| Is active \\| \\| --- \\| --- \\| \\| Description \\| Whether this tag is active (or archived) in Sprout Social \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is active \| \| Description \| Whether this tag is active (or archived) in Sprout Social \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | tags__is_active | | \| Display name \| Is active \| \| --- \| --- \| \| Description \| Whether this tag is active (or archived) in Sprout Social \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | Display name | Is active | | Description | Whether this tag is active (or archived) in Sprout Social | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| 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](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is in group \| \| Description \| Whether or not this tag is available in any customer group \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| | | 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](/apidocs/field-data-types#primitive) \| | | Display name | Is in group | | Description | Whether or not this tag is available in any customer group | | Field type | dimension | | Data type | [bool](/apidocs/field-data-types#primitive) | | \| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Tag ID \| \| Description \| The ID used by Sprout to identify this post tag \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | 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](/apidocs/field-data-types#text) \| | | Display name | Tag ID | | Description | The ID used by Sprout to identify this post tag | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| tags__tag_text \| \| --- \| \| \\| Display name \\| Tag text \\| \\| --- \\| --- \\| \\| Description \\| The text of the tag \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Tag text \| \| Description \| The text of the tag \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | tags__tag_text | | \| Display name \| Tag text \| \| --- \| --- \| \| Description \| The text of the tag \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Display name | Tag text | | Description | The text of the tag | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) |