Sprinklr: Most-used fields#
The table below gives information about most-used fields that you can import from Sprinklr. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
API name |
Adverity UI name |
Description |
Use in Adverity |
|---|---|---|---|
ACCOUNT_ID_{NUM} |
ACCOUNT_ID_{NUM} |
The unique identifier for an account. |
dimension |
ACTUAL_LINK_{NUM} |
ACTUAL_LINK_{NUM} |
The original or actual URL link associated with a post or content. |
dimension |
Age |
Age |
The age demographic of the audience interacting with content or ads. |
dimension |
CAMPAIGN_ID_DIMENSION |
CAMPAIGN_ID_DIMENSION |
A dimension representing the unique identifier for a marketing campaign. |
dimension |
CAMPAIGN_ID_{NUM} |
CAMPAIGN_ID_{NUM} |
A unique identifier for a marketing or advertising campaign. |
dimension |
D_ACCOUNTUSERID_{NUM} |
D_ACCOUNTUSERID_{NUM} |
A unique identifier for a user associated with a social media account managed within Sprinklr. This is a dimension used for categorization. |
dimension |
D_PIENDDATE_{NUM} |
D_PIENDDATE_{NUM} |
The end date of the requested query for a paid initiative or post insight. |
dimension |
D_PISTARTDATE_{NUM} |
D_PISTARTDATE_{NUM} |
The start date of the requested query for a paid initiative or post insight. |
dimension |
Facebook Region |
Facebook Region |
The geographic region associated with Facebook activity or ad targeting. |
dimension |
GATING_ENABLED |
GATING_ENABLED |
Indicates whether content or access is restricted or ‘gated’ based on specific criteria. |
dimension |
Gender |
Gender |
The gender demographic of the audience interacting with content or ads. |
dimension |
IS_COLLABORATION_POST_{NUM} |
IS_COLLABORATION_POST_{NUM} |
dimension |
|
IS_DARK_POST |
IS_DARK_POST |
Indicates whether a post is a ‘dark post’ (an unpublished ad targeting specific audiences). |
dimension |
IS_DARK_POST_{NUM} |
IS_DARK_POST_{NUM} |
Indicates whether a post is a ‘dark post’, meaning it is surfaced as an ad to a targeted audience without being published to a public page. Dark posts are imported into Sprinklr if a comment is made on them. |
dimension |
IS_DELETED |
IS_DELETED |
Indicates whether a message or post has been deleted from the social network. |
dimension |
IS_DELETED_{NUM} |
IS_DELETED_{NUM} |
Indicates whether a message has been deleted from the social network. |
dimension |
IS_GIF |
IS_GIF |
Indicates whether the content of a post is a GIF. |
dimension |
IS_IGTV_POST |
IS_IGTV_POST |
Indicates whether the content is an IGTV post on Instagram. |
dimension |
IS_IG_REEL_POST |
IS_IG_REEL_POST |
Indicates if an Instagram post is a Reel. |
dimension |
IS_LIVE_VIDEO |
IS_LIVE_VIDEO |
Indicates whether the content is a live video broadcast. |
dimension |
IS_SPONSORED |
IS_SPONSORED |
Indicates whether the content is sponsored (i.e., paid promotion). |
dimension |
IS_SPONSORED_{NUM} |
IS_SPONSORED_{NUM} |
A boolean indicator specifying whether the content is a sponsored post or advertisement. |
dimension |
Lifetime_Budget |
Lifetime_Budget |
The total budget allocated for an ad campaign over its entire duration. |
metric |
MEDIA_TYPE |
MEDIA_TYPE |
The type of media included in the post, such as Photo, Video, Link, Album, or Text. |
dimension |
MEDIA_TYPE_{NUM} |
MEDIA_TYPE_{NUM} |
The type of media associated with a post, such as image, video, or GIF. |
dimension |
M_ACCOUNT_INSIGHTS_FOLLOWERS_COUNT_{NUM} |
M_ACCOUNT_INSIGHTS_FOLLOWERS_COUNT_{NUM} |
The total number of followers across all social networks for a given account. |
metric |
M_ACCOUNT_INSIGHTS_PINTEREST_USER_FOLLOWERS_{NUM} |
M_ACCOUNT_INSIGHTS_PINTEREST_USER_FOLLOWERS_{NUM} |
The total number of followers for a user account on Pinterest. |
metric |
M_ACCOUNT_INSIGHTS_PINTEREST_USER_PIN_COUNT_{NUM} |
M_ACCOUNT_INSIGHTS_PINTEREST_USER_PIN_COUNT_{NUM} |
The total number of pins created by a user on Pinterest. |
metric |
M_AGENT_STATUS_REPORT_POST_SHARE_COUNT_{NUM} |
M_AGENT_STATUS_REPORT_POST_SHARE_COUNT_{NUM} |
The total number of times a post was shared. |
metric |
M_DAILY_AD_REPORT_STAT_ACTIONSREPORTABLE_ACTIONTYPEVALUEMAP_LINK_CLICK_{NUM} |
M_DAILY_AD_REPORT_STAT_ACTIONSREPORTABLE_ACTIONTYPEVALUEMAP_LINK_CLICK_{NUM} |
The number of link clicks for ads in a daily ad report. |
metric |
M_DAILY_AD_REPORT_STAT_ACTIONSREPORTABLE_ACTIONTYPEVALUEMAP_MOBILE_APP_INSTALL_{NUM} |
M_DAILY_AD_REPORT_STAT_ACTIONSREPORTABLE_ACTIONTYPEVALUEMAP_MOBILE_APP_INSTALL_{NUM} |
The number of mobile app installs attributed to ads in a daily ad report. |
metric |
M_DAILY_AD_REPORT_STAT_IMPRESSIONS_{NUM} |
M_DAILY_AD_REPORT_STAT_IMPRESSIONS_{NUM} |
The total number of times an ad was shown in a daily ad report. |
metric |
M_DAILY_AD_REPORT_STAT_SPENT_{NUM} |
M_DAILY_AD_REPORT_STAT_SPENT_{NUM} |
The total amount of money spent on ads in a daily ad report. |
metric |
M_DAILY_AD_STAT_ACM_GLOBAL_VIDEO_VIEWS_{NUM}_{NUM} |
M_DAILY_AD_STAT_ACM_GLOBAL_VIDEO_VIEWS_{NUM}_{NUM} |
The aggregated number of video views from advertisements across global regions. |
metric |
M_DAILY_AD_STAT_ACTIONSREPORTABLE_ACTIONTYPEVALUEMAP_MOBILE_APP_INSTALL_{NUM} |
M_DAILY_AD_STAT_ACTIONSREPORTABLE_ACTIONTYPEVALUEMAP_MOBILE_APP_INSTALL_{NUM} |
The number of mobile app installs attributed to ads. |
metric |
M_DAILY_AD_STAT_BY_DMA_CLICKS_{NUM} |
M_DAILY_AD_STAT_BY_DMA_CLICKS_{NUM} |
The number of clicks on ads, broken down by Designated Market Area (DMA). |
metric |
M_DAILY_AD_STAT_BY_DMA_IMPRESSIONS_{NUM} |
M_DAILY_AD_STAT_BY_DMA_IMPRESSIONS_{NUM} |
The number of ad impressions, broken down by Designated Market Area (DMA). |
metric |
M_DAILY_AD_STAT_BY_DMA_SPENTINUSD_{NUM} |
M_DAILY_AD_STAT_BY_DMA_SPENTINUSD_{NUM} |
The amount spent on ads in USD, broken down by Designated Market Area (DMA). |
metric |
M_DAILY_AD_STAT_BY_DMA_SPENT_{NUM} |
M_DAILY_AD_STAT_BY_DMA_SPENT_{NUM} |
The total amount spent on ads, broken down by Designated Market Area (DMA). |
metric |
M_DAILY_AD_STAT_BY_REGION_CLICKS_{NUM} |
M_DAILY_AD_STAT_BY_REGION_CLICKS_{NUM} |
The number of clicks on ads, broken down by geographical region. |
metric |
M_DAILY_AD_STAT_BY_REGION_IMPRESSIONS_{NUM} |
M_DAILY_AD_STAT_BY_REGION_IMPRESSIONS_{NUM} |
The number of ad impressions, broken down by geographical region. |
metric |
M_DAILY_AD_STAT_BY_REGION_SPENT_{NUM} |
M_DAILY_AD_STAT_BY_REGION_SPENT_{NUM} |
The total amount spent on ads, broken down by geographical region. |
metric |
M_DAILY_AD_STAT_CLICKS_{NUM} |
M_DAILY_AD_STAT_CLICKS_{NUM} |
The number of link clicks for ads in a daily ad report. |
metric |
M_DAILY_AD_STAT_ENGAGEMENTS_{NUM} |
M_DAILY_AD_STAT_ENGAGEMENTS_{NUM} |
The total number of engagements for daily ad statistics, including likes, reactions, comments, and shares across social networks. |
metric |
M_DAILY_AD_STAT_IMPRESSIONS_{NUM} |
M_DAILY_AD_STAT_IMPRESSIONS_{NUM} |
The total number of times an ad was displayed for daily ad statistics. |
metric |
M_DAILY_AD_STAT_SPENT_{NUM} |
M_DAILY_AD_STAT_SPENT_{NUM} |
The total amount of money spent on ads. |
metric |
M_DAILY_AD_STAT_TARGETACTIONS_{NUM} |
M_DAILY_AD_STAT_TARGETACTIONS_{NUM} |
Daily count of target actions achieved by an advertisement. |
metric |
M_DAILY_AD_STAT_UNIQUEIMPRESSIONS_{NUM} |
M_DAILY_AD_STAT_UNIQUEIMPRESSIONS_{NUM} |
The number of unique users who saw an ad for daily ad statistics. |
metric |
M_INBOUND_CASE_CASE_COUNT_{NUM} |
M_INBOUND_CASE_CASE_COUNT_{NUM} |
The total number of inbound cases. |
metric |
M_POST_INSIGHTS_BRAND_POSTS_{NUM}_{NUM} |
M_POST_INSIGHTS_BRAND_POSTS_{NUM}_{NUM} |
Insights and metrics related to posts published by a specific brand. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_ENGAGEMENT_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_ENGAGEMENT_{NUM} |
The total engagement for an Instagram business post, including likes, comments, and saves. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REACH_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REACH_{NUM} |
The number of unique accounts that saw an Instagram business post. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REEL_AVERAGE_WATCH_TIME_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REEL_AVERAGE_WATCH_TIME_{NUM} |
The average watch time for an Instagram Business Reel post. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REEL_TOTAL_WATCH_TIME_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REEL_TOTAL_WATCH_TIME_{NUM} |
The total watch time for an Instagram Business Reel post. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_SAVED_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_SAVED_{NUM} |
The total number of times an Instagram Business post was saved by users. ‘Saves’ is a common metric across social networks. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_SHARES_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_SHARES_{NUM} |
The number of times an Instagram business post or story was shared. |
metric |
M_POST_INSIGHTS_INSTAGRAM_POST_COMMENTS_COUNT_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_POST_COMMENTS_COUNT_{NUM} |
The total number of comments received on an Instagram post. |
metric |
M_POST_INSIGHTS_INSTAGRAM_POST_FOLLOWS_COUNT_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_POST_FOLLOWS_COUNT_{NUM} |
The number of new followers gained from an Instagram post. This is a common metric that totals various types of ‘followers’ across social networks, pinpointing the number of followers at the time of the post. |
metric |
M_POST_INSIGHTS_INSTAGRAM_POST_LIKES_COUNT_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_POST_LIKES_COUNT_{NUM} |
The number of likes an Instagram post has received. |
metric |
M_POST_INSIGHTS_INSTAGRAM_POST_VIEWS_COUNT_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_POST_VIEWS_COUNT_{NUM} |
The total number of times an Instagram media post has been seen. |
metric |
M_POST_INSIGHTS_PIN_CLICK_QUARTERLY_{NUM} |
M_POST_INSIGHTS_PIN_CLICK_QUARTERLY_{NUM} |
The total number of clicks on Pinterest pins for a quarterly period. |
metric |
M_POST_INSIGHTS_PIN_COMMENTS_{NUM} |
M_POST_INSIGHTS_PIN_COMMENTS_{NUM} |
The total number of comments received on Pinterest pins. |
metric |
M_POST_INSIGHTS_PIN_IMPRESSIONS_QUARTERLY_{NUM} |
M_POST_INSIGHTS_PIN_IMPRESSIONS_QUARTERLY_{NUM} |
The total number of times Pinterest pins were displayed for a quarterly period. |
metric |
M_POST_INSIGHTS_PIN_LAST_{NUM}_DAYS_ENGAGEMENT_{NUM} |
M_POST_INSIGHTS_PIN_LAST_{NUM}_DAYS_ENGAGEMENT_{NUM} |
The total engagement (likes, reactions, comments, shares) received on Pinterest pins over a specified number of recent days. |
metric |
M_POST_INSIGHTS_PIN_LIKES_{NUM} |
M_POST_INSIGHTS_PIN_LIKES_{NUM} |
The total number of likes received on Pinterest pins. |
metric |
M_POST_INSIGHTS_PIN_OUTBOUND_CLICKS_QUARTERLY_{NUM} |
M_POST_INSIGHTS_PIN_OUTBOUND_CLICKS_QUARTERLY_{NUM} |
The total number of outbound clicks on a Pinterest Pin during a quarterly period. Clicks are a common metric across social networks. |
metric |
M_POST_INSIGHTS_PIN_QUARTILE_{NUM}_PERCENT_VIEW_{NUM} |
M_POST_INSIGHTS_PIN_QUARTILE_{NUM}_PERCENT_VIEW_{NUM} |
The percentage of a Pinterest Pin video viewed up to a specific quartile (e.g., 25%, 50%, 75%, 100%). |
metric |
M_POST_INSIGHTS_PIN_SAVES_{NUM} |
M_POST_INSIGHTS_PIN_SAVES_{NUM} |
The total number of times Pinterest pins were saved. |
metric |
M_POST_INSIGHTS_PIN_USER_FOLLOW_{NUM} |
M_POST_INSIGHTS_PIN_USER_FOLLOW_{NUM} |
The total number of followers for a user account on Pinterest. |
metric |
M_POST_INSIGHTS_PIN_VIDEO_AVG_WATCH_TIME_{NUM} |
M_POST_INSIGHTS_PIN_VIDEO_AVG_WATCH_TIME_{NUM} |
The average watch time for a video on Pinterest. |
metric |
M_POST_INSIGHTS_PIN_VIDEO_V50_WATCH_TIME_{NUM} |
M_POST_INSIGHTS_PIN_VIDEO_V50_WATCH_TIME_{NUM} |
The total watch time for a Pinterest Pin video where at least 50% of the video was viewed. |
metric |
M_POST_INSIGHTS_PIN_VIDEO_VIEWS_QUARTERLY_{NUM} |
M_POST_INSIGHTS_PIN_VIDEO_VIEWS_QUARTERLY_{NUM} |
The total number of video views on Pinterest Pins during a quarterly period. |
metric |
M_POST_INSIGHTS_POST_COMMENT_COUNT_{NUM} |
M_POST_INSIGHTS_POST_COMMENT_COUNT_{NUM} |
The total number of comments received on a social media post. |
metric |
M_POST_INSIGHTS_POST_FB_IMPRESSIONS_ORGANIC_{NUM} |
M_POST_INSIGHTS_POST_FB_IMPRESSIONS_ORGANIC_{NUM} |
The number of organic impressions (times a post was seen) for a Facebook post. |
metric |
M_POST_INSIGHTS_POST_FB_IMPRESSIONS_UNIQUE_{NUM} |
M_POST_INSIGHTS_POST_FB_IMPRESSIONS_UNIQUE_{NUM} |
The number of unique organic impressions for a Facebook post, meaning the number of unique users who saw the post. |
metric |
M_POST_INSIGHTS_POST_FB_MEDIA_VIEW_ORGANIC_{NUM} |
M_POST_INSIGHTS_POST_FB_MEDIA_VIEW_ORGANIC_{NUM} |
The number of organic views for a Facebook post’s media content. |
metric |
M_POST_INSIGHTS_POST_FB_NATIVE_ENGAGEMENT_{NUM} |
M_POST_INSIGHTS_POST_FB_NATIVE_ENGAGEMENT_{NUM} |
The total engagement received on a Facebook native post, representing user interactions like likes, comments, shares, and clicks. |
metric |
M_POST_INSIGHTS_POST_FB_STREAM_COMMENT_COUNT_{NUM} |
M_POST_INSIGHTS_POST_FB_STREAM_COMMENT_COUNT_{NUM} |
The total number of comments on a Facebook post in a stream. |
metric |
M_POST_INSIGHTS_POST_FB_STREAM_SHARE_COUNT_{NUM} |
M_POST_INSIGHTS_POST_FB_STREAM_SHARE_COUNT_{NUM} |
The total number of shares for a Facebook post in a stream. |
metric |
M_POST_INSIGHTS_POST_FB_VIDEO_AVG_TIME_WATCHED_{NUM} |
M_POST_INSIGHTS_POST_FB_VIDEO_AVG_TIME_WATCHED_{NUM} |
The average time people spent watching a Facebook video post. |
metric |
M_POST_INSIGHTS_POST_FB_VIDEO_COMPLETE_VIEWS_30S_{NUM} |
M_POST_INSIGHTS_POST_FB_VIDEO_COMPLETE_VIEWS_30S_{NUM} |
The number of times a Facebook video was viewed for at least 30 seconds, or to completion if shorter. |
metric |
M_POST_INSIGHTS_POST_FB_VIDEO_VIEWS_{NUM} |
M_POST_INSIGHTS_POST_FB_VIDEO_VIEWS_{NUM} |
The total number of times a Facebook video post has been seen. |
metric |
M_POST_INSIGHTS_POST_FB_VIDEO_VIEW_TIME_{NUM} |
M_POST_INSIGHTS_POST_FB_VIDEO_VIEW_TIME_{NUM} |
The total accumulated watch time for a Facebook video post. |
metric |
M_POST_INSIGHTS_POST_LIKE_COUNT_{NUM} |
M_POST_INSIGHTS_POST_LIKE_COUNT_{NUM} |
The total number of likes or positive reactions received on a social media post. |
metric |
M_POST_INSIGHTS_POST_REACH_COUNT_{NUM} |
M_POST_INSIGHTS_POST_REACH_COUNT_{NUM} |
The total number of unique accounts that have seen the post. |
metric |
M_POST_INSIGHTS_POST_SHARE_COUNT_{NUM} |
M_POST_INSIGHTS_POST_SHARE_COUNT_{NUM} |
The total number of times a social media post has been shared or reposted. |
metric |
M_POST_INSIGHTS_POST_TOTAL_REACTION_COUNT_{NUM} |
M_POST_INSIGHTS_POST_TOTAL_REACTION_COUNT_{NUM} |
The total number of reactions (likes, comments, shares, etc.) received across all social networks for a post. |
metric |
M_POST_INSIGHTS_POST_TWITTER_FAVORITES_COUNT_{NUM} |
M_POST_INSIGHTS_POST_TWITTER_FAVORITES_COUNT_{NUM} |
The number of times a Twitter post was favorited. |
metric |
M_POST_INSIGHTS_POST_TWITTER_REACH_COUNT_{NUM} |
M_POST_INSIGHTS_POST_TWITTER_REACH_COUNT_{NUM} |
The estimated number of unique users who saw a Twitter post. |
metric |
M_POST_INSIGHTS_POST_TWITTER_REPLIES_COUNT_{NUM} |
M_POST_INSIGHTS_POST_TWITTER_REPLIES_COUNT_{NUM} |
The number of replies received on a Twitter post. |
metric |
M_POST_INSIGHTS_POST_TWITTER_RETWEETS_COUNT_{NUM} |
M_POST_INSIGHTS_POST_TWITTER_RETWEETS_COUNT_{NUM} |
The number of times a Twitter post was retweeted. |
metric |
M_POST_INSIGHTS_POST_VIDEO_DURATION_{NUM} |
M_POST_INSIGHTS_POST_VIDEO_DURATION_{NUM} |
The total duration of a video post. |
metric |
M_POST_INSIGHTS_THREADS_LIKES_{NUM} |
M_POST_INSIGHTS_THREADS_LIKES_{NUM} |
The total number of likes received on a Threads post. ‘Likes’ is a common metric across social networks. |
metric |
M_POST_INSIGHTS_THREADS_QUOTES_{NUM} |
M_POST_INSIGHTS_THREADS_QUOTES_{NUM} |
The total number of quotes received on a Threads post. |
metric |
M_POST_INSIGHTS_THREADS_REPLIES_{NUM} |
M_POST_INSIGHTS_THREADS_REPLIES_{NUM} |
The total number of replies received on a Threads post. ‘Comments’ is a common metric across social networks. |
metric |
M_POST_INSIGHTS_THREADS_REPOSTS_{NUM} |
M_POST_INSIGHTS_THREADS_REPOSTS_{NUM} |
The total number of reposts received on a Threads post. |
metric |
M_POST_INSIGHTS_THREADS_SHARES_{NUM} |
M_POST_INSIGHTS_THREADS_SHARES_{NUM} |
The total number of shares received on a Threads post. ‘Shares’ is a common metric across social networks. |
metric |
M_POST_INSIGHTS_THREADS_VIEWS_{NUM} |
M_POST_INSIGHTS_THREADS_VIEWS_{NUM} |
The total number of times a post on the Threads platform was viewed. |
metric |
M_POST_INSIGHTS_TIKTOK_FULL_VIDEO_WATCHED_RATE_{NUM} |
M_POST_INSIGHTS_TIKTOK_FULL_VIDEO_WATCHED_RATE_{NUM} |
The rate at which a TikTok video was watched to its full duration. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_AVERAGE_TIME_WATCHED_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_AVERAGE_TIME_WATCHED_{NUM} |
The average time people spent watching a TikTok video. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_COMMENTS_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_COMMENTS_{NUM} |
The total number of comments received on TikTok videos. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_DURATION_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_DURATION_{NUM} |
The total duration of a TikTok video. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_LIKES_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_LIKES_{NUM} |
The total number of likes received on TikTok videos. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_REACH_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_REACH_{NUM} |
The number of unique users who saw a TikTok video. ‘Reach’ is a common metric across social networks. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_SAVES_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_SAVES_{NUM} |
The total number of times a TikTok video was saved by users. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_SHARES_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_SHARES_{NUM} |
The total number of times TikTok videos were shared. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_TOTAL_TIME_WATCHED_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_TOTAL_TIME_WATCHED_{NUM} |
The cumulative total time users spent watching TikTok videos. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_VIEWS_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_VIEWS_{NUM} |
The total number of views for TikTok videos. |
metric |
M_POST_INSIGHTS_TOTAL_ENGAGEMENT_{NUM} |
M_POST_INSIGHTS_TOTAL_ENGAGEMENT_{NUM} |
The combined count of all likes (including reactions), comments, and shares received on posts across all social media channels. |
metric |
M_POST_INSIGHTS_TOTAL_IMPRESSIONS_{NUM}_{NUM} |
M_POST_INSIGHTS_TOTAL_IMPRESSIONS_{NUM}_{NUM} |
The total number of times a post was displayed. |
metric |
M_POST_INSIGHTS_TOTAL_VIDEO_AVG_TIME_WATCHED_{NUM} |
M_POST_INSIGHTS_TOTAL_VIDEO_AVG_TIME_WATCHED_{NUM} |
The aggregated average watch time for all video posts across various platforms. |
metric |
M_POST_INSIGHTS_TREND_PIN_IMPRESSIONS_QUARTERLY_{NUM} |
M_POST_INSIGHTS_TREND_PIN_IMPRESSIONS_QUARTERLY_{NUM} |
The trend data for the number of times Pinterest pins were displayed over a quarterly period. |
metric |
M_POST_INSIGHTS_TWITTER_BOOKMARKS_{NUM} |
M_POST_INSIGHTS_TWITTER_BOOKMARKS_{NUM} |
The total number of times a Twitter (X) post was bookmarked by users. |
metric |
M_POST_INSIGHTS_TWITTER_DETAIL_EXPANDS_{NUM} |
M_POST_INSIGHTS_TWITTER_DETAIL_EXPANDS_{NUM} |
The number of times users expanded a Twitter (X) post to view its details. |
metric |
M_POST_INSIGHTS_TWITTER_HASHTAG_CLICKS_{NUM} |
M_POST_INSIGHTS_TWITTER_HASHTAG_CLICKS_{NUM} |
The total number of clicks on hashtags within a Twitter (X) post. |
metric |
M_POST_INSIGHTS_TWITTER_IMPRESSIONS_{NUM} |
M_POST_INSIGHTS_TWITTER_IMPRESSIONS_{NUM} |
The number of times a Twitter post has been seen. |
metric |
M_POST_INSIGHTS_TWITTER_PROFILE_CLICKS_{NUM} |
M_POST_INSIGHTS_TWITTER_PROFILE_CLICKS_{NUM} |
The total number of clicks on the profile associated with a Twitter (X) post. |
metric |
M_POST_INSIGHTS_TWITTER_QUOTE_TWEETS_{NUM} |
M_POST_INSIGHTS_TWITTER_QUOTE_TWEETS_{NUM} |
The total number of Quote Tweets (reposts with comments) for a Twitter (X) post. |
metric |
M_POST_INSIGHTS_TWITTER_TOTAL_ENGAGEMENTS_{NUM} |
M_POST_INSIGHTS_TWITTER_TOTAL_ENGAGEMENTS_{NUM} |
The total number of engagements (likes, comments, shares) for a Twitter post. |
metric |
M_POST_INSIGHTS_TWITTER_TWEET_SHARES_{NUM} |
M_POST_INSIGHTS_TWITTER_TWEET_SHARES_{NUM} |
The number of times a Twitter post was shared. |
metric |
M_POST_INSIGHTS_TWITTER_UNFOLLOWERS_COUNT_{NUM} |
M_POST_INSIGHTS_TWITTER_UNFOLLOWERS_COUNT_{NUM} |
The number of users who unfollowed the account after interacting with a Twitter (X) post. |
metric |
M_POST_INSIGHTS_TWITTER_USER_FOLLOWS_{NUM} |
M_POST_INSIGHTS_TWITTER_USER_FOLLOWS_{NUM} |
The number of new followers gained from a Twitter (X) post. |
metric |
M_POST_INSIGHTS_TWITTER_VIDEO_PLAYS_FROM_TAP_{NUM} |
M_POST_INSIGHTS_TWITTER_VIDEO_PLAYS_FROM_TAP_{NUM} |
The number of times a Twitter (X) video was played by tapping on it. |
metric |
M_POST_INSIGHTS_TWITTER_VIDEO_STARTS_{NUM} |
M_POST_INSIGHTS_TWITTER_VIDEO_STARTS_{NUM} |
The number of times a Twitter (X) video began playing. |
metric |
M_POST_INSIGHTS_TWITTER_VIDEO_VIEWED_{NUM}_{NUM} |
M_POST_INSIGHTS_TWITTER_VIDEO_VIEWED_{NUM}_{NUM} |
The number of times a Twitter (X) video was viewed for a specific percentage of its duration (e.e.g. 25%, 50%, 75%). |
metric |
M_POST_INSIGHTS_TWITTER_VIDEO_WATCH_TIME_{NUM} |
M_POST_INSIGHTS_TWITTER_VIDEO_WATCH_TIME_{NUM} |
The total accumulated watch time for a Twitter (X) video. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_AVERAGE_VIEW_PERCENTAGE_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_AVERAGE_VIEW_PERCENTAGE_{NUM} |
The average percentage of a YouTube video that was viewed. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_COMMENTS_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_COMMENTS_{NUM} |
The total number of comments received on a YouTube video. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_DISLIKES_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_DISLIKES_{NUM} |
The total number of dislikes received on a YouTube video. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_LIKES_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_LIKES_{NUM} |
The total number of likes received on a YouTube video. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SHARES_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SHARES_{NUM} |
The total number of shares for a YouTube video. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SUBSCRIBERS_GAINED_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SUBSCRIBERS_GAINED_{NUM} |
The number of new subscribers gained from a YouTube video. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SUBSCRIBERS_LOST_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SUBSCRIBERS_LOST_{NUM} |
The number of subscribers lost due to a YouTube video. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_VIEWS_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_VIEWS_{NUM} |
The total number of views for a YouTube video. |
metric |
M_SPRINKSIGHTS_MENTIONS_COUNT_{NUM} |
M_SPRINKSIGHTS_MENTIONS_COUNT_{NUM} |
The total count of mentions of a brand or keyword on social media and other channels. |
metric |
POST_FB_CONSUMPTIONS_BY_TYPE_LINK_CLICKS |
POST_FB_CONSUMPTIONS_BY_TYPE_LINK_CLICKS |
The total number of link clicks on a Facebook post, categorized by consumption type. |
metric |
POST_FB_IMPRESSIONS |
POST_FB_IMPRESSIONS |
The total number of times a Facebook post was displayed to users. |
metric |
POST_FB_IMPRESSIONS_ORGANIC |
POST_FB_IMPRESSIONS_ORGANIC |
The number of times a Facebook post was displayed to users through organic reach. |
metric |
POST_FB_IMPRESSIONS_PAID |
POST_FB_IMPRESSIONS_PAID |
The number of times a Facebook post was displayed to users through paid advertising. |
metric |
POST_FB_IMPRESSIONS_UNIQUE |
POST_FB_IMPRESSIONS_UNIQUE |
The number of unique people who were shown a Facebook post. |
metric |
POST_FB_STORIES_BY_ACTION_TYPE_COMMENT |
POST_FB_STORIES_BY_ACTION_TYPE_COMMENT |
The number of comments on Facebook stories. |
metric |
POST_FB_STORIES_BY_ACTION_TYPE_LIKE |
POST_FB_STORIES_BY_ACTION_TYPE_LIKE |
The number of likes on Facebook stories. |
metric |
POST_FB_STORIES_BY_ACTION_TYPE_SHARE |
POST_FB_STORIES_BY_ACTION_TYPE_SHARE |
The number of shares of Facebook stories. |
metric |
POST_FB_VIDEO_AVG_TIME_WATCHED |
POST_FB_VIDEO_AVG_TIME_WATCHED |
The average time users spent watching a Facebook video. |
metric |
POST_FB_VIDEO_COMPLETE_VIEWS_30S |
POST_FB_VIDEO_COMPLETE_VIEWS_30S |
The number of times a Facebook video was viewed for at least 30 seconds (considered a complete view). |
metric |
POST_FB_VIDEO_COMPLETE_VIEWS_30S_ORGANIC |
POST_FB_VIDEO_COMPLETE_VIEWS_30S_ORGANIC |
The number of times an organic Facebook video was viewed for at least 30 seconds. |
metric |
POST_FB_VIDEO_COMPLETE_VIEWS_30S_PAID |
POST_FB_VIDEO_COMPLETE_VIEWS_30S_PAID |
The number of times a paid (promoted) Facebook video was viewed for at least 30 seconds. |
metric |
POST_FB_VIDEO_LENGTH |
POST_FB_VIDEO_LENGTH |
The categorized duration of a Facebook video post. |
metric |
POST_FB_VIDEO_VIEWS |
POST_FB_VIDEO_VIEWS |
The total number of times a Facebook video post was viewed. |
metric |
POST_FB_VIDEO_VIEWS_10S |
POST_FB_VIDEO_VIEWS_10S |
The number of times a Facebook video was viewed for at least 10 seconds. |
metric |
POST_FB_VIDEO_VIEWS_10S_ORGANIC |
POST_FB_VIDEO_VIEWS_10S_ORGANIC |
The number of times an organic Facebook video was viewed for at least 10 seconds. |
metric |
POST_FB_VIDEO_VIEWS_10S_PAID |
POST_FB_VIDEO_VIEWS_10S_PAID |
The number of times a paid (promoted) Facebook video was viewed for at least 10 seconds. |
metric |
POST_FB_VIDEO_VIEWS_ORGANIC |
POST_FB_VIDEO_VIEWS_ORGANIC |
The total number of organic views for a Facebook video. |
metric |
POST_FB_VIDEO_VIEWS_PAID |
POST_FB_VIDEO_VIEWS_PAID |
The total number of paid (promoted) views for a Facebook video. |
metric |
POST_FB_VIDEO_VIEW_TIME |
POST_FB_VIDEO_VIEW_TIME |
The total accumulated time users spent watching a Facebook video. |
metric |
POST_FB_VIDEO_VIEW_TIME_ORGANIC |
POST_FB_VIDEO_VIEW_TIME_ORGANIC |
The total accumulated time users spent watching an organic Facebook video. |
metric |
POST_FB_VIDEO_VIEW_TIME_PAID |
POST_FB_VIDEO_VIEW_TIME_PAID |
The total accumulated time users spent watching a paid (promoted) Facebook video. |
metric |
POST_ID |
POST_ID |
The unique identifier for a post. |
dimension |
POST_ID_{NUM} |
POST_ID_{NUM} |
The unique identifier for the social media post. |
dimension |
POST_PART_OF_MULTI_PHOTO |
POST_PART_OF_MULTI_PHOTO |
Indicates whether a post is part of a multi-photo (carousel) album. |
dimension |
POST_PUBLISHED_DATE |
POST_PUBLISHED_DATE |
The exact date when the post was published. |
dimension |
POST_PUBLISHED_DATE_{NUM} |
POST_PUBLISHED_DATE_{NUM} |
The date when a post was published. |
metric |
POST_VIDEO_DURATION |
POST_VIDEO_DURATION |
The duration of the video attached to a post. |
metric |
REPORT_DATE_MM_DD_YYYY_{NUM} |
REPORT_DATE_MM_DD_YYYY_{NUM} |
The specific date (MM/DD/YYYY) for which the report data is generated. |
dimension |
Region |
Region |
A geographic region associated with the data. |
dimension |
SEM_SENTIMENT_{NUM} |
SEM_SENTIMENT_{NUM} |
The sentiment score of content (e.g., positive, negative, neutral) as determined by Sprinklr’s AI. |
dimension |
SN_CREATED_TIME_{NUM} |
SN_CREATED_TIME_{NUM} |
The timestamp indicating when a social network post or content was created. |
metric |
SN_MESSAGE_TYPE |
SN_MESSAGE_TYPE |
The type of message posted on a social network, such as text, image, video, or link. |
dimension |
SN_TYPE |
SN_TYPE |
The type of social network where the post originated (e.g., Facebook, Instagram, Twitter). |
dimension |
SN_TYPE_{NUM} |
SN_TYPE_{NUM} |
The type of social network platform where the activity occurred (e.g., Facebook, Twitter, LinkedIn). |
dimension |
accountIds_{NUM} |
accountIds_{NUM} |
Sprinklr’s internal ID numbers associated with social media accounts. The {NUM} suffix indicates a potential for multiple account IDs or time-series data. |
dimension |
accountSprinklrIds_{NUM} |
accountSprinklrIds_{NUM} |
Sprinklr’s internal ID numbers associated with social media accounts. The {NUM} suffix indicates a potential for multiple account IDs or time-series data. |
metric |
account_id |
account_id |
The internal Sprinklr ID number associated with the Account. |
dimension |
account_id_sprinklr |
account_id_sprinklr |
The internal Sprinklr ID number associated with the Account. |
dimension |
account_name |
account_name |
The name of the social network account. |
dimension |
actionscomment |
actionscomment |
A metric representing the total number of comments received on posts or content across social networks. |
metric |
actionslanding_page_view |
actionslanding_page_view |
The number of times a landing page was viewed as a result of an action. |
metric |
actionslike |
actionslike |
A metric representing the total number of likes and reactions received on posts or content across social networks. |
metric |
actionspost |
actionspost |
Aggregate of actions performed on a post, such as likes, comments, and shares. |
metric |
actionspost_engagement |
actionspost_engagement |
A metric representing the total engagement received on posts, including likes, comments, and shares. |
metric |
actionsvideo_view |
actionsvideo_view |
A metric representing the total number of video views. |
metric |
adBuyId_{NUM} |
adBuyId_{NUM} |
A unique identifier for a specific ad buy within the advertising campaign. |
dimension |
adBuyingType_{NUM} |
adBuyingType_{NUM} |
The type of ad buying strategy used for an advertisement (e.g., auction, reservation). |
dimension |
adChannelId_{NUM} |
adChannelId_{NUM} |
The unique identifier for the advertising channel. |
metric |
adChannel_{NUM} |
adChannel_{NUM} |
The advertising channel where an ad was published (e.g., Facebook, Instagram, LinkedIn). |
dimension |
adName_{NUM} |
adName_{NUM} |
The name of a specific advertisement. This field categorizes data by individual ad campaigns or creatives. |
dimension |
adSetId |
adSetId |
The identifier for an ad set, which is a group of ads that share settings for targeting, scheduling, and bidding. |
dimension |
adSetId_{NUM} |
adSetId_{NUM} |
The identifier for an ad set, which is a group of ads that share settings for targeting, scheduling, and bidding. The {NUM} suffix indicates a potential for multiple ad set IDs or time-series data. |
dimension |
adSetSprinklrId_{NUM} |
adSetSprinklrId_{NUM} |
Sprinklr’s internal identifier for an ad set, which is a group of ads that share settings for targeting, scheduling, and bidding. The {NUM} suffix indicates a potential for multiple ad set IDs or time-series data. |
dimension |
adVariantSprinklrId_{NUM} |
adVariantSprinklrId_{NUM} |
The unique Sprinklr identifier for a specific ad variant. |
dimension |
ad_id |
ad_id |
The unique identifier for an advertisement. |
dimension |
ad_name |
ad_name |
The name given to an advertisement. |
dimension |
adset_id |
adset_id |
The identifier for an ad set, which is a group of ads that share settings for targeting, scheduling, and bidding. |
dimension |
adset_name |
adset_name |
The name of an ad set, which is a group of ads with similar targeting, budget, and schedule. |
dimension |
age_{NUM} |
age_{NUM} |
The age demographic of the audience interacting with content or ads. |
dimension |
campaign_id |
campaign_id |
The unique identifier for a marketing campaign. |
dimension |
campaign_name |
campaign_name |
The name of the marketing campaign. |
dimension |
channelCampaignId |
channelCampaignId |
The identifier for a campaign within a specific social or advertising channel. |
dimension |
channelCampaignId_{NUM} |
channelCampaignId_{NUM} |
The unique identifier for a campaign within a specific advertising channel. |
dimension |
city |
city |
The city from which an interaction or event originated. |
dimension |
clicks |
clicks |
The total number of clicks on an ad or content. This metric provides an estimated number of clicks on posts. |
metric |
The total number of clicks across all social media channels. |
metric |
||
The total number of comments received on posts or content on Meta platforms (Facebook, Instagram). |
metric |
||
The number of comments received on TikTok content. |
metric |
||
creativeFormatType_{NUM} |
creativeFormatType_{NUM} |
The format type of the creative content used in an ad or post, such as image, video, or GIF. |
dimension |
date |
date |
The specific date for which the reporting data is recorded. |
dimension |
date_start |
date_start |
The start date for the reporting period. |
dimension |
date_{NUM} |
date_{NUM} |
The date associated with the reporting data, often used as a dimension to analyze metrics over specific time periods. |
dimension |
The total engagement (likes, comments, shares) received on posts or content on Meta platforms (Facebook, Instagram). |
metric |
||
facebook_region |
facebook_region |
The geographic region associated with Facebook activity or ad targeting. |
dimension |
The number of new followers gained on TikTok. |
metric |
||
gender_{NUM} |
gender_{NUM} |
The gender demographic of the audience interacting with content or ads. |
dimension |
impressions |
impressions |
The total number of times an ad or content was displayed. |
metric |
The total number of times content was displayed across all social media channels. |
metric |
||
inline_link_clicks |
inline_link_clicks |
The number of clicks on links within the ad creative itself, rather than external calls-to-action. |
metric |
The total number of likes received on posts or content on Meta platforms (Facebook, Instagram). |
metric |
||
The number of likes received on TikTok content. |
metric |
||
The number of clicks on links within content or ads on Meta platforms. |
metric |
||
measurementTime_{NUM} |
measurementTime_{NUM} |
The timestamp indicating when a metric was measured. |
dimension |
metrics |
metrics |
A collection of numerical measurements that quantify performance, such as engagement rate, reach, and impressions. |
metric |
The number of page views on Meta platforms, often related to Facebook pages or profiles. |
metric |
||
The total number of page views received on content published on Snapchat. |
metric |
||
paidInitiativeChannelId |
paidInitiativeChannelId |
The unique identifier for the channel used in a paid advertising initiative. |
dimension |
paidInitiativeChannelId_{NUM} |
paidInitiativeChannelId_{NUM} |
The unique identifier for the channel used in a paid advertising initiative. |
dimension |
paidInitiativeId |
paidInitiativeId |
The identifier for a specific paid initiative or advertisement campaign. |
dimension |
paidInitiativeId_{NUM} |
paidInitiativeId_{NUM} |
The unique identifier for a paid advertising initiative or campaign. |
dimension |
paidInitiativeSprinklrId_{NUM} |
paidInitiativeSprinklrId_{NUM} |
The unique Sprinklr identifier for a paid advertising initiative or campaign. |
dimension |
post_reaction_like |
post_reaction_like |
The total number of ‘like’ reactions received on a post. |
metric |
The total number of purchases attributed to activity on Meta platforms. |
metric |
||
The number of in-app purchases attributed to Snapchat activity. |
metric |
||
The number of web purchases attributed to Snapchat activity. |
metric |
||
reportingEnds_{NUM} |
reportingEnds_{NUM} |
The end date for the reporting period. |
dimension |
reportingStarts_{NUM} |
reportingStarts_{NUM} |
The start date for the reporting period. |
dimension |
results |
results |
An array containing the individual data records or rows returned by the reporting API query. |
metric |
A general metric representing the overall outcome or performance across all integrated platforms. |
metric |
||
segmentedAdDma_{NUM} |
segmentedAdDma_{NUM} |
A Designated Market Area (DMA) used for segmenting ad performance data. |
dimension |
segmentedAdRegion_{NUM} |
segmentedAdRegion_{NUM} |
A geographic region used for segmenting ad performance data. |
dimension |
The total number of shares received on posts or content on Meta platforms (Facebook, Instagram). |
metric |
||
The number of times content was shared on Snapchat. |
metric |
||
The number of shares for a TikTok video post. |
metric |
||
spend |
spend |
The total amount of money spent on an advertising campaign or paid initiative. |
metric |
The total amount of money spent on advertising across all social media channels. |
metric |
||
The total amount of money spent on advertising across all social media channels, converted to USD. |
metric |
||
The number of times a Snapchat story was opened. |
metric |
||
video_p100_watched_actions |
video_p100_watched_actions |
The number of times a video was watched to 100% completion. |
metric |
video_p25_watched_actions |
video_p25_watched_actions |
The number of times a video was watched to at least 25% completion. |
metric |
video_p50_watched_actions |
video_p50_watched_actions |
The number of times a video was watched to at least 50% completion. |
metric |
video_p75_watched_actions |
video_p75_watched_actions |
The number of times a video was watched to at least 75% completion. |
metric |
video_p95_watched_actions |
video_p95_watched_actions |
The number of times a video was watched to at least 95% completion. |
metric |
The number of times a video was watched to completion on Meta platforms (Facebook, Instagram). |
metric |
||
The number of times a video was watched to 100% completion on Snapchat. |
metric |
||
The number of times a video was watched to 100% completion on TikTok. |
metric |
||
The total number of video views on Meta platforms (Facebook, Instagram). |
metric |
||
The total number of video views on Snapchat. |
metric |
||
The total number of video views on TikTok. |
metric |