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} |
Represents a unique account identifier, where {NUM} can denote a specific account or type. |
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 |
CHANNEL_STATUS_ID |
CHANNEL_STATUS_ID |
The internal Sprinklr ID number associated with a social media channel or account. |
dimension |
CHANNEL_STATUS_ID_{NUM} |
CHANNEL_STATUS_ID_{NUM} |
The internal Sprinklr ID number associated with a social media channel or account. |
metric |
D_ACCOUNTIDEXTERNAL |
D_ACCOUNTIDEXTERNAL |
Represents an external identifier for an account, used as a dimension for reporting. |
metric |
D_ACCOUNTIDEXTERNAL_{NUM} |
D_ACCOUNTIDEXTERNAL_{NUM} |
Represents an external account identifier, where {NUM} can denote a specific account, used as a dimension for reporting. |
metric |
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_PERMALINK_{NUM} |
D_PERMALINK_{NUM} |
Represents the permanent URL (permalink) of a post or content item, where {NUM} can denote a specific item, used as a dimension for reporting. |
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 |
D_SOCIAL_MEDIA_ASSET_MEDIA_URL_EXTERNAL_{NUM} |
D_SOCIAL_MEDIA_ASSET_MEDIA_URL_EXTERNAL_{NUM} |
The external URL of a social media asset, such as an image or video, as published on a social network. This can include the full link as published within a post or a permalink to the specific asset. |
dimension |
D_STATUSIDEXTERNAL |
D_STATUSIDEXTERNAL |
Represents an external status identifier, used as a dimension for reporting. |
metric |
D_STATUSIDEXTERNAL_{NUM} |
D_STATUSIDEXTERNAL_{NUM} |
Represents an external status identifier, where {NUM} can denote a specific status, used as a dimension for reporting. |
metric |
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_DARK_POST |
IS_DARK_POST |
Indicates whether a post is a ‘dark post’ (an unpublished ad targeting specific audiences). |
dimension |
IS_DELETED |
IS_DELETED |
Indicates whether a message or post 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} |
Indicates whether the content is sponsored, where {NUM} can denote a specific instance or type. |
dimension |
Lifetime_Budget |
Lifetime_Budget |
The total budget allocated for an ad campaign over its entire duration. |
metric |
MEDIA_ASSET_ID_{NUM} |
MEDIA_ASSET_ID_{NUM} |
Represents the unique identifier for a media asset, where {NUM} can denote a specific asset. |
dimension |
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} |
Represents the type of media (e.g., image, video), where {NUM} can denote a specific media item. |
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} |
Represents the total number of followers for a Pinterest user account, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_ACCOUNT_INSIGHTS_PINTEREST_USER_PIN_COUNT_{NUM} |
M_ACCOUNT_INSIGHTS_PINTEREST_USER_PIN_COUNT_{NUM} |
Represents the total number of Pins created by a Pinterest user, where {NUM} can denote a specific aggregation or timeframe. |
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_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_POST_INSIGHTS_FOLLOWER_COUNT_AT_POST_{NUM} |
M_POST_INSIGHTS_FOLLOWER_COUNT_AT_POST_{NUM} |
Represents the total follower count of an account at the time a specific post was published, where {NUM} can denote a specific post. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_IMPRESSIONS_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_IMPRESSIONS_{NUM} |
Represents the total number of times an Instagram Business post was displayed, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REACH_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REACH_{NUM} |
Represents the number of unique Instagram accounts that saw a Business post, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REEL_AVERAGE_WATCH_TIME_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_REEL_AVERAGE_WATCH_TIME_{NUM} |
Represents the average watch time for an Instagram Business Reel post, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_SAVED_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_SAVED_{NUM} |
Represents the number of times an Instagram Business post was saved, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_SHARES_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_BUSINESS_POST_SHARES_{NUM} |
Represents the number of times an Instagram Business post was shared, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_INSTAGRAM_POST_COMMENTS_COUNT_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_POST_COMMENTS_COUNT_{NUM} |
Represents the total number of comments received on an Instagram post, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_INSTAGRAM_POST_FOLLOWS_COUNT_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_POST_FOLLOWS_COUNT_{NUM} |
Represents the number of new followers gained directly from an Instagram post, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_INSTAGRAM_POST_LIKES_COUNT_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_POST_LIKES_COUNT_{NUM} |
Represents the total number of likes received on an Instagram post, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_INSTAGRAM_POST_PROFILE_VISITS_{NUM} |
M_POST_INSIGHTS_INSTAGRAM_POST_PROFILE_VISITS_{NUM} |
Represents the number of profile visits to an Instagram account resulting from a post, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_PIN_IMPRESSIONS_QUARTERLY_{NUM} |
M_POST_INSIGHTS_PIN_IMPRESSIONS_QUARTERLY_{NUM} |
Represents the total number of times a Pinterest Pin was displayed on screen during a quarter, where {NUM} can denote a specific aggregation or version. |
metric |
M_POST_INSIGHTS_PIN_LAST_{NUM}_DAYS_ENGAGEMENT_{NUM} |
M_POST_INSIGHTS_PIN_LAST_{NUM}_DAYS_ENGAGEMENT_{NUM} |
Represents the total engagement received by a Pinterest Pin over the last specified number of days, where the second {NUM} can denote a specific aggregation or version. |
metric |
M_POST_INSIGHTS_POST_LIKE_COUNT_{NUM} |
M_POST_INSIGHTS_POST_LIKE_COUNT_{NUM} |
Represents the total number of likes received on a post, where {NUM} can denote a specific aggregation or timeframe. |
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_REAL_CLICK_COUNT_{NUM} |
M_POST_INSIGHTS_POST_REAL_CLICK_COUNT_{NUM} |
The estimated number of clicks on a post’s link, excluding clicks from known bots. This metric was previously referred to as ‘Filtered Clicks’ or ‘Real Clicks’. |
metric |
M_POST_INSIGHTS_TIKTOK_FULL_VIDEO_WATCHED_RATE_{NUM} |
M_POST_INSIGHTS_TIKTOK_FULL_VIDEO_WATCHED_RATE_{NUM} |
Represents the percentage of a TikTok video that was watched completely, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_AVERAGE_TIME_WATCHED_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_AVERAGE_TIME_WATCHED_{NUM} |
Represents the average time a TikTok video was watched, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_COMMENTS_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_COMMENTS_{NUM} |
Represents the total number of comments received on a TikTok video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_LIKES_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_LIKES_{NUM} |
Represents the total number of likes received on a TikTok video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_REACH_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_REACH_{NUM} |
Represents the number of unique users who saw a TikTok video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_SHARES_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_SHARES_{NUM} |
Represents the total number of shares for a TikTok video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_TIKTOK_VIDEO_VIEWS_{NUM} |
M_POST_INSIGHTS_TIKTOK_VIDEO_VIEWS_{NUM} |
Represents the total number of views for a TikTok video, where {NUM} can denote a specific aggregation or timeframe. |
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_TREND_PIN_IMPRESSIONS_QUARTERLY_{NUM} |
M_POST_INSIGHTS_TREND_PIN_IMPRESSIONS_QUARTERLY_{NUM} |
Represents the total number of times a trending Pinterest Pin was displayed on screen during a quarter, where {NUM} can denote a specific aggregation or version. |
metric |
M_POST_INSIGHTS_YOUTUBE_PAID_VIDEO_VIEWS_{NUM} |
M_POST_INSIGHTS_YOUTUBE_PAID_VIDEO_VIEWS_{NUM} |
Represents the number of paid views for a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_ANNOTATION_CLICK_THROUGH_RATE_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_ANNOTATION_CLICK_THROUGH_RATE_{NUM} |
Represents the click-through rate for annotations on a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_AVERAGE_VIEW_DURATION_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_AVERAGE_VIEW_DURATION_{NUM} |
Represents the average duration of views for a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_AVERAGE_VIEW_PERCENTAGE_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_AVERAGE_VIEW_PERCENTAGE_{NUM} |
Represents the average percentage of a YouTube video watched, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_COMMENTS_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_COMMENTS_{NUM} |
Represents the total number of comments received on a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_DISLIKES_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_DISLIKES_{NUM} |
Represents the total number of dislikes received on a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_ENGAGED_VIEWS_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_ENGAGED_VIEWS_{NUM} |
Represents the number of engaged views for a YouTube video, where engaged implies a certain level of interaction, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_ESTIMATED_MINUTES_WATCHED_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_ESTIMATED_MINUTES_WATCHED_{NUM} |
Represents the estimated total minutes watched for a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_LIKES_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_LIKES_{NUM} |
Represents the total number of likes received on a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SHARES_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SHARES_{NUM} |
Represents the total number of shares for a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SUBSCRIBERS_GAINED_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SUBSCRIBERS_GAINED_{NUM} |
Represents the number of subscribers gained from a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SUBSCRIBERS_LOST_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_SUBSCRIBERS_LOST_{NUM} |
Represents the number of subscribers lost from a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_UNIQUE_VIEWS_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_UNIQUE_VIEWS_{NUM} |
Represents the number of unique viewers for a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
metric |
M_POST_INSIGHTS_YOUTUBE_VIDEO_VIEWS_{NUM} |
M_POST_INSIGHTS_YOUTUBE_VIDEO_VIEWS_{NUM} |
Represents the total number of views for a YouTube video, where {NUM} can denote a specific aggregation or timeframe. |
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_NO_LOOKUP_{NUM} |
POST_ID_NO_LOOKUP_{NUM} |
Represents the unique identifier for a post without performing a lookup, where {NUM} can denote a specific post. |
metric |
POST_ID_{NUM} |
POST_ID_{NUM} |
Represents the unique identifier for a post, where {NUM} can denote a specific 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} |
Represents the date when a post was published, where {NUM} can denote a specific post. |
metric |
POST_VIDEO_DURATION |
POST_VIDEO_DURATION |
The duration of the video attached to a post. |
metric |
Region |
Region |
A geographic region associated with the data. |
dimension |
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 |
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 |
adChannelId_{NUM} |
adChannelId_{NUM} |
The unique identifier for the advertising channel. |
metric |
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 |
||
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 |