Sprinklr fields

Early Access26 metrics41 dimensions

Search fields

ACCOUNT

account_name

Field label	Account name
Description	Bifurcate data by the name of the social network account
Field type	dimension
Data type	string.text.value

account_id

Field label	Account ID
Description	The internal Sprinklr ID number associated to the Account. Only available if IS_DELETED = false
Field type	dimension
Data type	string.text.value

social_network

Field label	Social network
Description	This dimension can be used to segment a common metric across multiple social network (e.g.: Total engagements) or can be used as a filter to display only one type of social network. For case reporting, this will list the social network of the first message associated to the case
Field type	dimension
Data type	string.text.value

CAMPAIGN

campaign

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

campaign_id

Field label	Campaign ID
Description	ID of the Campaign
Field type	dimension
Data type	string.text.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

ENGAGEMENT

volume_of_published_messages

Field label	Volume of published messages
Description	The number of outbound messages that have been published
Field type	metric
Data type	int.number.value

total_engagements

Field label	Total engagements
Description	It is a Sprinklr common metric that totals the number of likes including reactions, comments and shares across social networks
Field type	metric
Data type	int.number.value

post_likes_and_reactions

Field label	Post likes and reactions
Description	This is a Sprinklr common metric that totals the types of 'likes' across various social networks
Field type	metric
Data type	int.number.value

post_comments

Field label	Post comments
Description	It is a Sprinklr common metric that totals the various types of 'comments' across social networks
Field type	metric
Data type	int.number.value

post_shares

Field label	Post shares
Description	It is a Sprinklr common metric that totals the various types of 'shares' across social networks
Field type	metric
Data type	int.number.value

post_reach

Field label	Post reach
Description	It is a Sprinklr common metric that totals a number of metric across social networks to estimate the number of people you might have reached with your messages
Field type	metric
Data type	int.number.value

estimated_clicks

Field label	Estimated clicks
Description	This metric provides an estimated number of clicks on your posts
Field type	metric
Data type	int.number.value

FACEBOOK

fb_post_views

Field label	Facebook post views
Description	The number of times your page post has been seen across Facebook
Field type	metric
Data type	int.number.value

fb_total_video_impressions

Field label	Facebook total video impressions
Description	The number of impressions of the video
Field type	metric
Data type	int.number.value

fb_total_video_auto_played_views_3s

Field label	Facebook total video auto-played views (3s or more)
Description	The number of times your video started automatically playing and people viewed it for 3 seconds or viewed it to the end, whichever happened first
Field type	metric
Data type	int.number.value

fb_total_video_auto_played_views_10s

Field label	Facebook total video auto-played views (10s or more)
Description	The number of times your video started automatically playing and people viewed it for 10 seconds or viewed it to the end, whichever happened first
Field type	metric
Data type	int.number.value

fb_total_video_auto_played_views_30s

Field label	Facebook total video auto-played views (30s or more)
Description	The number of times your video started automatically playing and people viewed it for 30 seconds or viewed it to the end, whichever happened first
Field type	metric
Data type	int.number.value

fb_total_video_auto_played_views_95

Field label	Facebook total video auto-played views (95% or complete)
Description	The number of times your video started automatically playing and people watched 95% or complete
Field type	metric
Data type	int.number.value

fb_total_video_clicked_to_play_views_3s

Field label	Facebook total video clicked-to-play views (3s or more)
Description	The number of times people clicked to play your video and viewed it for 3 seconds or viewed it to the end, whichever happened first
Field type	metric
Data type	int.number.value

fb_total_video_clicked_to_play_views_10s

Field label	Facebook total video clicked-to-play views (10s or more)
Description	The number of times people clicked to play your video and viewed it for 10 seconds or viewed it to the end, whichever happened first
Field type	metric
Data type	int.number.value

fb_total_video_clicked_to_play_views_30s

Field label	Facebook total video clicked-to-play views (30s or more)
Description	The number of times people clicked to play your video and viewed it for 30 seconds or viewed it to the end, whichever happened first
Field type	metric
Data type	int.number.value

fb_total_video_clicked_to_play_views_95

Field label	Facebook total video clicked-to-play views (95% or complete)
Description	The number of times people clicked to play your video and people watched 95% or complete
Field type	metric
Data type	int.number.value

INSTAGRAM

ig_post_likes

Field label	Instagram post likes
Description	The number of likes that your Instagram post has received. Note: It is available on image, video, & IG Media published as a post. Album carousels, reels and IGTV are not supported
Field type	metric
Data type	int.number.value

ig_post_comments

Field label	Instagram post comments
Description	The number of comments that your Instagram post has received
Field type	metric
Data type	int.number.value

ig_business_post_views

Field label	Instagram business post views
Description	Total number of times the IG media has been seen
Field type	metric
Data type	int.number.value

ig_business_post_engagement

Field label	Instagram business post engagement
Description	Total number of likes, comments and saves on the media object (Applicable only for business profiles)
Field type	metric
Data type	int.number.value

ig_business_post_shares

Field label	Instagram business post shares
Description	The number of times your post or story was shared
Field type	metric
Data type	int.number.value

li_company_post_impressions

Field label	LinkedIn company post impressions
Description	This metric is provided from the LinkedIn API. It is the number of times each update was shown to LinkedIn members
Field type	metric
Data type	int.number.value

li_video_views

Field label	LinkedIn video views
Description	Video views with play-pause cycles for at least 3 seconds
Field type	metric
Data type	int.number.value

POST

post_id

Field label	Post ID
Description	The ID number associated with a outbound post. Only available if IS_DELETED = false
Field type	dimension
Data type	string.text.value

outbound_post

Field label	Outbound post
Description	Displays the text of an outbound message sent from an account. Only available if IS_DELETED = false
Field type	dimension
Data type	string.text.value

channel_type

Field label	Channel type
Description	Type of the channel. Only available if IS_DELETED = false
Field type	dimension
Data type	string.text.value

media_type

Field label	Media type
Description	Sprinklr automatically interprets the contents of your message according to the following types PHOTO, VIDEO, LINK, ALBUM, PDF, DOCUMENT, PRESENTATION, MIXED, AUDIO, GRAFFITI, OFFER, EVENT, TEXT
Field type	dimension
Data type	string.text.value

link

Field label	Link
Description	Full link as published
Field type	dimension
Data type	string.text.url

is_deleted

Field label	Is deleted
Description	Indicates whether a message has been deleted from the social network
Field type	dimension
Data type	bool

created_date

Field label	Created date
Description	Date when post was created. Only available if IS_DELETED = false
Field type	dimension
Data type	string.time.date

created_datetime

Field label	Created datetime
Description	Datetime when post was created. Only available if IS_DELETED = false
Field type	dimension
Data type	string.time.datetime

published_date

Field label	Published date
Description	The exact date on which the post was published
Field type	dimension
Data type	string.time.date

published_datetime

Field label	Published datetime
Description	The exact datetime on which the post was published
Field type	dimension
Data type	string.time.datetime

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

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

year

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

year_of_week

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

year_of_week_iso

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

year_month

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

month

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

year_week

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

year_week_iso

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

week

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

week_iso

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

day_of_month

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

day_of_week_name

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

day_of_week_name_iso

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

date

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

atom

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

X

x_impressions

Field label	X impressions
Description	The number of times the post has been seen
Field type	metric
Data type	int.number.value

x_video_views

Field label	X video views
Description	The number of times a video in the Post has been viewed
Field type	metric
Data type	int.number.value