Smarp data warehouse table groups

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CLICK

clicks__count
Display name Click count
Description Number of times the shared post was clicked. Note that Smarp only counts unique clicks
Field type metric
Data type int.number.value
clicks__created_at
Display name Click created at
Description Date and time when the click was performed
Field type dimension
Data type string.time.datetime
clicks__id
Display name Click ID
Field type dimension
Data type string.text.value
clicks__post_id
Display name Post ID
Description ID of the post
Field type dimension
Data type string.text.value
clicks__posts__campaigns__id
Display name Campaign ID
Field type dimension
Data type string.text.value
clicks__posts__campaigns__name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
clicks__sharer_id
Display name Sharer ID
Description ID of the sharer
Field type dimension
Data type string.text.value
clicks__social_network
Display name Social network
Description Social network where the click was performed
Field type dimension
Data type string.text.value
clicks__users__id
Display name User ID
Field type dimension
Data type string.text.value
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

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__count
Display name Post count
Description Number of posts. Note that posts that were published in private channels are not counted
Field type metric
Data type int.number.value
posts__date
Display name Date
Field type dimension
Data type string.time.date
posts__id
Display name Post ID
Field type dimension
Data type string.text.value
posts__published_at
Display name Post published at
Description Date and time when the post was published
Field type dimension
Data type string.time.datetime
posts__title
Display name Post title
Description Title of the post
Field type dimension
Data type string.text.value
posts__type
Display name Post type
Description Type shows whether the post is e.g. link, article, image or video post
Field type dimension
Data type string.text.value
posts__url
Display name Post url
Description URL of the post
Field type dimension
Data type string.text.url

Table: SHARE

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
shares__comment_count
Display name Share comment count
Description Number of comments the shared post has received. Note that Smarp gathers comments from posts for up to a week since it was shared
Field type metric
Data type int.number.value
shares__count
Display name Share count
Description Number of unique times the post has been shared in social media
Field type metric
Data type int.number.value
shares__id
Display name Share ID
Field type dimension
Data type string.text.value
shares__like_count
Display name Share like count
Description Number of likes the shared post has received. Note that Smarp gathers likes from posts for up to a week since it was shared
Field type metric
Data type int.number.value
shares__post_id
Display name Post ID
Description ID of the post
Field type dimension
Data type string.text.value
shares__posts__campaigns__id
Display name Campaign ID
Field type dimension
Data type string.text.value
shares__posts__campaigns__name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
shares__resharer_count
Display name Resharer count
Description Number of times the shared post was retweeted or otherwise reshared
Field type metric
Data type int.number.value
shares__shared_at
Display name Shared at
Description Date and time when the post was shared, e.g. 2019-08-24T14:15:22Z
Field type dimension
Data type string.time.datetime
shares__sharer_id
Display name Sharer ID
Description ID of the user who shared the post
Field type dimension
Data type string.text.value
shares__social_network
Display name Share social network
Description Name of the social network where the post was shared, e.g. LinkedIn or Facebook
Field type dimension
Data type string.text.value
shares__unique_click_count
Display name Share unique click count
Description Number of unique clicks on the shared post. No clicks are recorded for image posts
Field type metric
Data type int.number.value
shares__users__id
Display name User ID
Field type dimension
Data type string.text.value

Table: CAMPAIGN

campaigns__id
Display name Campaign ID
Field type dimension
Data type string.text.value
campaigns__name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
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

Table: USER

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
users__count
Display name User count
Description Number of Smarp users
Field type metric
Data type int.number.value
users__first_name
Display name User first name
Description First name of the user
Field type dimension
Data type string.text.value
users__group_id
Display name User group ID
Description ID of the group to which the user belongs to
Field type dimension
Data type string.text.value
users__groups__name
Display name Group name
Description Name of the group, e.g. based on geography or departments
Field type dimension
Data type string.text.value
users__id
Display name User ID
Field type dimension
Data type string.text.value
users__last_name
Display name User last name
Description Last name of the user
Field type dimension
Data type string.text.value
users__linkedin_connections
Display name LinkedIn connections
Description The amount of LinkedIn connections user has
Field type metric
Data type int.number.value
users__phone_number
Display name User phone number
Description Phone number of the user
Field type dimension
Data type string.text.value
users__total_connections
Display name Total connections
Description The total amount of connections user has. This includes Twitter and LinkedIn
Field type metric
Data type int.number.value
users__twitter_connections
Display name Twitter connections
Description The amount of Twitter connections user has
Field type metric
Data type int.number.value

Table: TEAM

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
teams__group_id
Display name Team group ID
Description ID of the team
Field type dimension
Data type string.text.value
teams__id
Display name Team ID
Field type dimension
Data type string.text.value
teams__name
Display name Team name
Description Name of the team, e.g. Sales. Teams in Smarp can be used as a way to segment users
Field type dimension
Data type string.text.value