Smarp fields

11 metrics118 dimensions

Search fields

CAMPAIGN

clicks__posts__campaigns__id

Field label	Campaign ID
Field type	dimension
Data type	string.text.value

clicks__posts__campaigns__name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

posts__campaigns__id

Field label	Campaign ID
Field type	dimension
Data type	string.text.value

posts__campaigns__name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

shares__posts__campaigns__id

Field label	Campaign ID
Field type	dimension
Data type	string.text.value

shares__posts__campaigns__name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

campaigns__id

Field label	Campaign ID
Field type	dimension
Data type	string.text.value

campaigns__name

Field label	Campaign name
Description	Name of the campaign
Field type	dimension
Data type	string.text.value

CLICK

clicks__id

Field label	Click ID
Field type	dimension
Data type	string.text.value

clicks__created_at

Field label	Click created at
Description	Date and time when the click was performed
Field type	dimension
Data type	string.time.datetime

clicks__created_date

Field label	Click created at date
Description	Date when the click was performed
Field type	dimension
Data type	string.time.date

clicks__sharer_id

Field label	Sharer ID
Description	ID of the sharer
Field type	dimension
Data type	string.text.value

clicks__post_id

Field label	Post ID
Description	ID of the post
Field type	dimension
Data type	string.text.value

clicks__social_network

Field label	Social network
Description	Social network where the click was performed
Field type	dimension
Data type	string.text.value

clicks__count

Field label	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

DATASOURCE

dataSourceName

Field label	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
Destinations	API, Data warehouse

system_metadata.data_source_logins

Field label	Data source logins
Description	The data source login accounts that were used to authenticate against the data source
Field type	dimension
Data type	string.text.json

system_metadata.data_source_login_owners

Field label	Data source login owners
Description	The Supermetrics users that created the data source login connections
Field type	dimension
Data type	string.text.json

GROUP

clicks__users__groups__id

Field label	Group ID
Field type	dimension
Data type	string.text.value

clicks__users__groups__name

Field label	Group name
Description	Name of the group, e.g. based on geography or departments
Field type	dimension
Data type	string.text.value

shares__users__groups__id

Field label	Group ID
Field type	dimension
Data type	string.text.value

shares__users__groups__name

Field label	Group name
Description	Name of the group, e.g. based on geography or departments
Field type	dimension
Data type	string.text.value

users__groups__id

Field label	Group ID
Field type	dimension
Data type	string.text.value

users__groups__name

Field label	Group name
Description	Name of the group, e.g. based on geography or departments
Field type	dimension
Data type	string.text.value

groups__id

Field label	Group ID
Field type	dimension
Data type	string.text.value

groups__name

Field label	Group name
Description	Name of the group, e.g. based on geography or departments
Field type	dimension
Data type	string.text.value

POST

clicks__posts__id

Field label	Post ID
Field type	dimension
Data type	string.text.value

clicks__posts__published_at

Field label	Post published at
Description	Date and time when the post was published
Field type	dimension
Data type	string.time.datetime

clicks__posts__published_date

Field label	Post published at date
Description	Date when the post was published
Field type	dimension
Data type	string.time.date

clicks__posts__title

Field label	Post title
Description	Title of the post
Field type	dimension
Data type	string.text.value

clicks__posts__url

Field label	Post url
Description	URL of the post
Field type	dimension
Data type	string.text.url

clicks__posts__type

Field label	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__id

Field label	Post ID
Field type	dimension
Data type	string.text.value

posts__published_at

Field label	Post published at
Description	Date and time when the post was published
Field type	dimension
Data type	string.time.datetime

posts__published_date

Field label	Post published at date
Description	Date when the post was published
Field type	dimension
Data type	string.time.date

posts__title

Field label	Post title
Description	Title of the post
Field type	dimension
Data type	string.text.value

posts__url

Field label	Post url
Description	URL of the post
Field type	dimension
Data type	string.text.url

posts__type

Field label	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

shares__posts__id

Field label	Post ID
Field type	dimension
Data type	string.text.value

shares__posts__published_at

Field label	Post published at
Description	Date and time when the post was published
Field type	dimension
Data type	string.time.datetime

shares__posts__published_date

Field label	Post published at date
Description	Date when the post was published
Field type	dimension
Data type	string.time.date

shares__posts__title

Field label	Post title
Description	Title of the post
Field type	dimension
Data type	string.text.value

shares__posts__url

Field label	Post url
Description	URL of the post
Field type	dimension
Data type	string.text.url

shares__posts__type

Field label	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__count

Field label	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

QUERY

system_metadata.query_date_range_start

Field label	Start date
Description	The start date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_date_range_end

Field label	End date
Description	The end date of the requested query
Field type	dimension
Data type	string.time.date

system_metadata.query_timezone

Field label	Timezone
Description	The timezone that is supplied to the query
Field type	dimension
Data type	string.time.timezone

system_metadata.query_filters

Field label	Filters
Description	All filters used in the query
Field type	dimension
Data type	string.text.json

system_metadata.query_date_start

Field label	Start
Description	When the query was started
Field type	dimension
Data type	string.time.datetime

system_metadata.query_date_end

Field label	End
Description	When the query completed
Field type	dimension
Data type	string.time.datetime

system_metadata.query_duration

Field label	Duration
Description	The duration in seconds of the query
Field type	dimension
Data type	int.duration.seconds

system_metadata.query_accounts

Field label	Accounts
Description	A list of accounts of which the data was pulled from
Field type	dimension
Data type	string.text.json

shares__id

Field label	Share ID
Field type	dimension
Data type	string.text.value

shares__shared_at

Field label	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__shared_date

Field label	Shared at date
Description	Date when post was shared, e.g. 2019-08-24
Field type	dimension
Data type	string.time.date

shares__sharer_id

Field label	Sharer ID
Description	ID of the user who shared the post
Field type	dimension
Data type	string.text.value

shares__post_id

Field label	Post ID
Description	ID of the post
Field type	dimension
Data type	string.text.value

shares__social_network

Field label	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__count

Field label	Share count
Description	Number of unique times the post has been shared in social media
Field type	metric
Data type	int.number.value

shares__unique_click_count

Field label	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__like_count

Field label	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__comment_count

Field label	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__resharer_count

Field label	Resharer count
Description	Number of times the shared post was retweeted or otherwise reshared
Field type	metric
Data type	int.number.value

TEAM

teams__id

Field label	Team ID
Field type	dimension
Data type	string.text.value

teams__name

Field label	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

teams__group_id

Field label	Team group ID
Description	ID of the team
Field type	dimension
Data type	string.text.value

TIME

today

Field label	Today
Description	Today's date, e.g. 2017-01-31
Field type	dimension
Data type	string.time.date
Destinations	API, Data warehouse

clicks__posts__year

Field label	Year
Field type	dimension
Data type	string.time.year

clicks__posts__year_of_week

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

clicks__posts__year_of_week_iso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

clicks__posts__year_month

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

clicks__posts__month

Field label	Month
Field type	dimension
Data type	string.time.month

clicks__posts__year_week

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

clicks__posts__year_week_iso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

clicks__posts__week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

clicks__posts__week_iso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

clicks__posts__day_of_month

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

clicks__posts__day_of_week_name

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

clicks__posts__day_of_week_name_iso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

clicks__posts__date

Field label	Date
Field type	dimension
Data type	string.time.date

clicks__posts__atom

Field label	Datetime
Field type	dimension
Data type	string.time.datetime

posts__year

Field label	Year
Field type	dimension
Data type	string.time.year

posts__year_of_week

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

posts__year_of_week_iso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

posts__year_month

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

posts__month

Field label	Month
Field type	dimension
Data type	string.time.month

posts__year_week

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

posts__year_week_iso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

posts__week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

posts__week_iso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

posts__day_of_month

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

posts__day_of_week_name

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

posts__day_of_week_name_iso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

posts__date

Field label	Date
Field type	dimension
Data type	string.time.date

posts__atom

Field label	Datetime
Field type	dimension
Data type	string.time.datetime

shares__posts__year

Field label	Year
Field type	dimension
Data type	string.time.year

shares__posts__year_of_week

Field label	Year of week (Sun-Sat)
Field type	dimension
Data type	string.time.year

shares__posts__year_of_week_iso

Field label	Year of week (Mon-Sun)
Field type	dimension
Data type	string.time.year

shares__posts__year_month

Field label	Year & month
Field type	dimension
Data type	string.time.yearmonth

shares__posts__month

Field label	Month
Field type	dimension
Data type	string.time.month

shares__posts__year_week

Field label	Year & week (Sun-Sat)
Field type	dimension
Data type	string.time.yearweek

shares__posts__year_week_iso

Field label	Year & week (Mon-Sun)
Field type	dimension
Data type	string.time.yearweekiso

shares__posts__week

Field label	Week (Sun-Sat)
Field type	dimension
Data type	string.time.week

shares__posts__week_iso

Field label	Week (Mon-Sun)
Field type	dimension
Data type	string.time.weekiso

shares__posts__day_of_month

Field label	Day of month
Field type	dimension
Data type	string.time.dayofmonth

shares__posts__day_of_week_name

Field label	Day of week (Sun-Sat)
Field type	dimension
Data type	string.time.dayofweek

shares__posts__day_of_week_name_iso

Field label	Day of week (Mon-Sun)
Field type	dimension
Data type	string.time.dayofweekiso

shares__posts__date

Field label	Date
Field type	dimension
Data type	string.time.date

shares__posts__atom

Field label	Datetime
Field type	dimension
Data type	string.time.datetime

USER

clicks__users__id

Field label	User ID
Field type	dimension
Data type	string.text.value

clicks__users__first_name

Field label	User first name
Description	First name of the user
Field type	dimension
Data type	string.text.value

clicks__users__last_name

Field label	User last name
Description	Last name of the user
Field type	dimension
Data type	string.text.value

clicks__users__phone_number

Field label	User phone number
Description	Phone number of the user
Field type	dimension
Data type	string.text.value

clicks__users__group_id

Field label	User group ID
Description	ID of the group to which the user belongs to
Field type	dimension
Data type	string.text.value

shares__users__id

Field label	User ID
Field type	dimension
Data type	string.text.value

shares__users__first_name

Field label	User first name
Description	First name of the user
Field type	dimension
Data type	string.text.value

shares__users__last_name

Field label	User last name
Description	Last name of the user
Field type	dimension
Data type	string.text.value

shares__users__phone_number

Field label	User phone number
Description	Phone number of the user
Field type	dimension
Data type	string.text.value

shares__users__group_id

Field label	User group ID
Description	ID of the group to which the user belongs to
Field type	dimension
Data type	string.text.value

users__id

Field label	User ID
Field type	dimension
Data type	string.text.value

users__first_name

Field label	User first name
Description	First name of the user
Field type	dimension
Data type	string.text.value

users__last_name

Field label	User last name
Description	Last name of the user
Field type	dimension
Data type	string.text.value

users__phone_number

Field label	User phone number
Description	Phone number of the user
Field type	dimension
Data type	string.text.value

users__group_id

Field label	User group ID
Description	ID of the group to which the user belongs to
Field type	dimension
Data type	string.text.value

users__count

Field label	User count
Description	Number of Smarp users
Field type	metric
Data type	int.number.value

users__linkedin_connections

Field label	LinkedIn connections
Description	The amount of LinkedIn connections user has
Field type	metric
Data type	int.number.value

users__twitter_connections

Field label	Twitter connections
Description	The amount of Twitter connections user has
Field type	metric
Data type	int.number.value

users__total_connections

Field label	Total connections
Description	The total amount of connections user has. This includes Twitter and LinkedIn
Field type	metric
Data type	int.number.value