JDBC Driver for Facebook

Build 22.0.8462

Insight Mapping

Below is a mapping of specific Facebook insights, which periods are available for them, what view they can be used from, and what types of targets are available. Since Facebook frequently makes changes to the available insights, we also include a table indicating which insights have been removed recently from Facebook, and the previous name for an insight if it has been renamed.

Current Insights

View or Stored Procedure Insight Name Available Periods Target Type Previous Name
SimpleInsights PAGE_ACTIONS_POST_REACTIONS_ANGER_TOTAL day page
SimpleInsights PAGE_ACTIONS_POST_REACTIONS_HAHA_TOTAL day page
SimpleInsights PAGE_ACTIONS_POST_REACTIONS_LIKE_TOTAL day page
SimpleInsights PAGE_ACTIONS_POST_REACTIONS_LOVE_TOTAL day page
SimpleInsights PAGE_ACTIONS_POST_REACTIONS_SORRY_TOTAL day page
SimpleInsights PAGE_ACTIONS_POST_REACTIONS_WOW_TOTAL day page
SimpleInsights PAGE_CONSUMPTIONS day, week, days_28 page
SimpleInsights PAGE_CONSUMPTIONS_UNIQUE day, week, days_28 page
SimpleInsights PAGE_ENGAGED_USERS day, week, days_28 page
SimpleInsights PAGE_FAN_ADDS day page
SimpleInsights PAGE_FAN_ADDS_UNIQUE day, week, days_28 page
SimpleInsights PAGE_FAN_REMOVES day page
SimpleInsights PAGE_FAN_REMOVES_UNIQUE day page
SimpleInsights PAGE_FANS day page
SimpleInsights PAGE_FANS_ONLINE day page
SimpleInsights PAGE_FANS_ONLINE_PER_DAY day page
SimpleInsights PAGE_IMPRESSIONS day, week, days_28 page
SimpleInsights PAGE_IMPRESSIONS_FREQUENCY_DISTRIBUTION day, week, days_28 page
SimpleInsights PAGE_IMPRESSIONS_ORGANIC day, week, days_28 page
SimpleInsights PAGE_IMPRESSIONS_ORGANIC_UNIQUE day, week, days_28 page
SimpleInsights PAGE_IMPRESSIONS_PAID day, week, days_28 page
SimpleInsights PAGE_IMPRESSIONS_PAID_UNIQUE day, week, days_28 page
SimpleInsights PAGE_IMPRESSIONS_UNIQUE day, week, days_28 page
SimpleInsights PAGE_IMPRESSIONS_VIRAL day, week, days_28 page
SimpleInsights PAGE_IMPRESSIONS_VIRAL_FREQUENCY_DISTRIBUTION day, week, days_28 page
SimpleInsights PAGE_IMPRESSIONS_VIRAL_UNIQUE day, week, days_28 page
SimpleInsights PAGE_NEGATIVE_FEEDBACK day, week, days_28 page
SimpleInsights PAGE_NEGATIVE_FEEDBACK_UNIQUE day, week, days_28 page
SimpleInsights PAGE_PLACES_CHECKIN_MOBILE day, week, days_28 page
SimpleInsights PAGE_PLACES_CHECKIN_MOBILE_UNIQUE day, week, days_28 page
SimpleInsights PAGE_PLACES_CHECKIN_TOTAL day, week, days_28 page
SimpleInsights PAGE_PLACES_CHECKIN_TOTAL_UNIQUE day, week, days_28 page
SimpleInsights PAGE_POST_ENGAGEMENTS day, week, days_28 page
SimpleInsights PAGE_POSTS_IMPRESSIONS day, week, days_28 page
SimpleInsights PAGE_POSTS_IMPRESSIONS_ORGANIC day, week, days_28 page
SimpleInsights PAGE_POSTS_IMPRESSIONS_ORGANIC_UNIQUE day, week, days_28 page
SimpleInsights PAGE_POSTS_IMPRESSIONS_PAID day, week, days_28 page
SimpleInsights PAGE_POSTS_IMPRESSIONS_PAID_UNIQUE day, week, days_28 page
SimpleInsights PAGE_POSTS_IMPRESSIONS_UNIQUE day, week, days_28 page
SimpleInsights PAGE_POSTS_IMPRESSIONS_VIRAL day, week, days_28 page
SimpleInsights PAGE_POSTS_IMPRESSIONS_VIRAL_UNIQUE day, week, days_28 page
SimpleInsights PAGE_CONTENT_ACTIVITY day, week, days_28 page PAGE_STORIES
SimpleInsights PAGE_VIDEO_COMPLETE_VIEWS_30S day, week, days_28 page
SimpleInsights PAGE_VIDEO_COMPLETE_VIEWS_30S_AUTOPLAYED day, week, days_28 page
SimpleInsights PAGE_VIDEO_COMPLETE_VIEWS_30S_CLICK_TO_PLAY day, week, days_28 page
SimpleInsights PAGE_VIDEO_COMPLETE_VIEWS_30S_ORGANIC day, week, days_28 page
SimpleInsights PAGE_VIDEO_COMPLETE_VIEWS_30S_PAID day, week, days_28 page
SimpleInsights PAGE_VIDEO_COMPLETE_VIEWS_30S_REPEAT_VIEWS day, week, days_28 page
SimpleInsights PAGE_VIDEO_COMPLETE_VIEWS_30S_UNIQUE day, week, days_28 page
SimpleInsights PAGE_VIDEO_REPEAT_VIEWS day, week, days_28 page
SimpleInsights PAGE_VIDEO_VIEWS day, week, days_28 page
SimpleInsights PAGE_VIDEO_VIEWS_AUTOPLAYED day, week, days_28 page
SimpleInsights PAGE_VIDEO_VIEWS_CLICK_TO_PLAY day, week, days_28 page
SimpleInsights PAGE_VIDEO_VIEWS_ORGANIC day, week, days_28 page
SimpleInsights PAGE_VIDEO_VIEWS_PAID day, week, days_28 page
SimpleInsights PAGE_VIDEO_VIEWS_UNIQUE day, week, days_28 page
SimpleInsights PAGE_VIEWS_TOTAL day, week, days_28 page PAGE_VIEWS
SimpleInsights PAGE_VIEWS_LOGGED_IN_TOTAL day, week, days_28 page PAGE_VIEWS_LOGIN
SimpleInsights PAGE_VIEWS_LOGGED_IN_UNIQUE day, week, days_28 page PAGE_VIEWS_LOGIN_UNIQUE
SimpleInsights PAGE_VIEWS_LOGOUT day page
SimpleInsights POST_CLICKS lifetime post POST_CONSUMPTIONS
SimpleInsights POST_CLICKS_UNIQUE lifetime post POST_CONSUMPTIONS_UNIQUE
SimpleInsights POST_ENGAGED_USERS lifetime post
SimpleInsights POST_IMPRESSIONS lifetime post
SimpleInsights POST_IMPRESSIONS_FAN lifetime post
SimpleInsights POST_IMPRESSIONS_FAN_PAID lifetime post
SimpleInsights POST_IMPRESSIONS_FAN_PAID_UNIQUE lifetime post
SimpleInsights POST_IMPRESSIONS_FAN_UNIQUE lifetime post
SimpleInsights POST_IMPRESSIONS_ORGANIC lifetime post
SimpleInsights POST_IMPRESSIONS_ORGANIC_UNIQUE lifetime post
SimpleInsights POST_IMPRESSIONS_PAID lifetime post
SimpleInsights POST_IMPRESSIONS_PAID_UNIQUE lifetime post
SimpleInsights POST_IMPRESSIONS_UNIQUE lifetime post
SimpleInsights POST_IMPRESSIONS_VIRAL lifetime post
SimpleInsights POST_IMPRESSIONS_VIRAL_UNIQUE lifetime post
SimpleInsights POST_NEGATIVE_FEEDBACK lifetime post
SimpleInsights POST_NEGATIVE_FEEDBACK_UNIQUE lifetime post
SimpleInsights POST_ACTIVITY lifetime post POST_STORIES
SimpleInsights POST_ACTIVITY_UNIQUE lifetime post POST_STORYTELLERS
SimpleInsights POST_VIDEO_AVG_TIME_WATCHED lifetime post
SimpleInsights POST_VIDEO_COMPLETE_VIEWS_ORGANIC lifetime post
SimpleInsights POST_VIDEO_COMPLETE_VIEWS_ORGANIC_UNIQUE lifetime post
SimpleInsights POST_VIDEO_COMPLETE_VIEWS_PAID lifetime post
SimpleInsights POST_VIDEO_COMPLETE_VIEWS_PAID_UNIQUE lifetime post
SimpleInsights POST_VIDEO_LENGTH lifetime post
SimpleInsights POST_VIDEO_VIEW_TIME lifetime post
SimpleInsights POST_VIDEO_VIEW_TIME_ORGANIC lifetime post
SimpleInsights POST_VIDEO_VIEWS_10S lifetime post
SimpleInsights POST_VIDEO_VIEWS_10S_AUTOPLAYED lifetime post
SimpleInsights POST_VIDEO_VIEWS_10S_CLICKED_TO_PLAY lifetime post
SimpleInsights POST_VIDEO_VIEWS_10S_ORGANIC lifetime post
SimpleInsights POST_VIDEO_VIEWS_10S_PAID lifetime post
SimpleInsights POST_VIDEO_VIEWS_10S_SOUND_ON lifetime post
SimpleInsights POST_VIDEO_VIEWS_10S_UNIQUE lifetime post
SimpleInsights POST_VIDEO_VIEWS_ORGANIC lifetime post
SimpleInsights POST_VIDEO_VIEWS_ORGANIC_UNIQUE lifetime post
SimpleInsights POST_VIDEO_VIEWS_PAID lifetime post
SimpleInsights POST_VIDEO_VIEWS_PAID_UNIQUEPOST_VIDEO_VIEWS_SOUND_ON lifetime post
InsightsByConsumptionType PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE day, week, days_28 page
InsightsByConsumptionType PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE_UNIQUE day, week, days_28 page
InsightsByConsumptionType POST_CLICKS_BY_TYPE lifetime post POST_CONSUMPTIONS_BY_CONSUMPTION_TYPE
InsightsByConsumptionType POST_CLICKS_BY_TYPE_UNIQUE lifetime post POST_CONSUMPTIONS_BY_CONSUMPTION_TYPE_UNIQUE
InsightsByFeedbackType PAGE_NEGATIVE_FEEDBACK_BY_TYPE day, week, days_28 page
InsightsByFeedbackType PAGE_NEGATIVE_FEEDBACK_BY_TYPE_UNIQUE day, week, days_28 page
InsightsByFeedbackType PAGE_POSITIVE_FEEDBACK_BY_TYPE day, week, days_28 page
InsightsByFeedbackType PAGE_POSITIVE_FEEDBACK_BY_TYPE_UNIQUE day, week, days_28 page
InsightsByFeedbackType POST_NEGATIVE_FEEDBACK_BY_TYPE lifetime post
InsightsByFeedbackType POST_NEGATIVE_FEEDBACK_BY_TYPE_UNIQUE lifetime post
InsightsByLikeSourceType PAGE_FANS_BY_LIKE_SOURCE day page
InsightsByLikeSourceType PAGE_FANS_BY_LIKE_SOURCE_UNIQUE day page
InsightsByUnLikeSourceType PAGE_FANS_BY_UNLIKE_SOURCE day page
InsightsByUnLikeSourceType PAGE_FANS_BY_UNLIKE_SOURCE_UNIQUE day page
InsightsByReactionTotals PAGE_ACTIONS_POST_REACTIONS_TOTAL day page
InsightsByReactionTotals POST_REACTIONS_BY_TYPE_TOTAL day page
InsightsByStoryType PAGE_CONTENT_ACTIVITY_BY_ACTION_TYPE day, week, days_28 page PAGE_STORIES_BY_STORY_TYPE
InsightsByStoryType PAGE_IMPRESSIONS_BY_STORY_TYPE day, week, days_28 page
InsightsByStoryType PAGE_IMPRESSIONS_BY_STORY_TYPE_UNIQUE day, week, days_28 page
InsightsByStoryType POST_IMPRESSIONS_BY_STORY_TYPE day, week, days_28 page
InsightsByStoryType POST_IMPRESSIONS_BY_STORY_TYPE_UNIQUE day, week, days_28 page
InsightsByTabType PAGE_TAB_VIEWS_LOGIN_TOP_UNIQUE day, week page
InsightsByTabType PAGE_TAB_VIEWS_LOGIN_TOP day, week page
InsightsByTabType PAGE_TAB_VIEWS_LOGOUT_TOP day page
SimpleVideoInsights PAGE_VIDEO_VIEW_TIME day page
SimpleVideoInsights TOTAL_VIDEO_VIEWS lifetime video
SimpleVideoInsights TOTAL_VIDEO_VIEWS_UNIQUE lifetime video
SimpleVideoInsights TOTAL_VIDEO_VIEWS_AUTOPLAYED lifetime video
SimpleVideoInsights TOTAL_VIDEO_VIEWS_CLICKED_TO_PLAY lifetime video
SimpleVideoInsights TOTAL_VIDEO_VIEWS_SOUND_ON lifetime video
SimpleVideoInsights TOTAL_VIDEO_COMPLETE_VIEWS lifetime video
SimpleVideoInsights TOTAL_VIDEO_COMPLETE_VIEWS_UNIQUE lifetime video
SimpleVideoInsights TOTAL_VIDEO_COMPLETE_VIEWS_AUTO_PLAYED lifetime video
SimpleVideoInsights TOTAL_VIDEO_COMPLETE_VIEWS_CLICKED_TO_PLAY lifetime video
SimpleVideoInsights TOTAL_VIDEO_10S_VIEWS lifetime video
SimpleVideoInsights TOTAL_VIDEO_10S_VIEWS_UNIQUE lifetime video
SimpleVideoInsights TOTAL_VIDEO_10S_VIEWS_auto_played lifetime video
SimpleVideoInsights TOTAL_VIDEO_10S_VIEWS_CLICKED_TO_PLAY lifetime video
SimpleVideoInsights TOTAL_VIDEO_10S_VIEWS_SOUND_ON lifetime video
SimpleVideoInsights TOTAL_VIDEO_AVG_TIME_WATCHED lifetime video
SimpleVideoInsights TOTAL_VIDEO_VIEW_TOTAL_TIME lifetime video
SimpleVideoInsights TOTAL_VIDEO_IMPRESSIONS lifetime video
SimpleVideoInsights TOTAL_VIDEO_IMPRESSIONS_UNIQUE lifetime video
SimpleVideoInsights TOTAL_VIDEO_IMPRESSIONS_VIRAL_UNIQUE lifetime video
SimpleVideoInsights TOTAL_VIDEO_IMPRESSIONS_VIRAL lifetime video
SimpleVideoInsights TOTAL_VIDEO_IMPRESSIONS_FAN_UNIQUE lifetime video
SimpleVideoInsights TOTAL_VIDEO_IMPRESSIONS_FAN lifetime video
VideoInsightsByActionType TOTAL_VIDEO_STORIES_BY_ACTION_TYPE lifetime video
VideoInsightsByDistributionType TOTAL_VIDEO_VIEWS_BY_DISTRIBUTION_TYPE lifetime video
VideoInsightsByDistributionType TOTAL_VIDEO_VIEW_TIME_BY_DISTRIBUTION_TYPE lifetime video
VideoInsightsByReactionType TOTAL_VIDEO_REACTIONS_BY_TYPE_TOTAL lifetime video
CreateInsightSchema PAGE_CONTENT_ACTIVITY_BY_AGE_GENDER_UNIQUE day, week, days_28 page PAGE_STORYTELLERS_BY_AGE_GENDER
CreateInsightSchema PAGE_CONTENT_ACTIVITY_BY_CITY_UNIQUE day, week, days_28 page PAGE_STORYTELLERS_BY_CITY
CreateInsightSchema PAGE_CONTENT_ACTIVITY_BY_COUNTRY_UNIQUE day, week, days_28 page PAGE_STORYTELLERS_BY_COUNTRY
CreateInsightSchema PAGE_CONTENT_ACTIVITY_BY_LOCALE_UNIQUE day, week, days_28 page PAGE_STORYTELLERS_BY_LOCALE
CreateInsightSchema PAGE_IMPRESSIONS_BY_CITY_UNIQUE day, week, days_28 page
CreateInsightSchema PAGE_IMPRESSIONS_BY_COUNTRY_UNIQUE day, week, days_28 page
CreateInsightSchema PAGE_IMPRESSIONS_BY_LOCALE_UNIQUE day, week, days_28 page
CreateInsightSchema PAGE_IMPRESSIONS_BY_AGE_GENDER_UNIQUE day, week, days_28 page
CreateInsightSchema PAGE_PLACES_CHECKINS_BY_AGE_GENDER day page
CreateInsightSchema PAGE_PLACES_CHECKINS_BY_LOCALE day page
CreateInsightSchema PAGE_PLACES_CHECKINS_BY_COUNTRY day page
CreateInsightSchema PAGE_FANS_LOCALE day page
CreateInsightSchema PAGE_FANS_CITY day page
CreateInsightSchema PAGE_FANS_COUNTRY day page
CreateInsightSchema PAGE_FANS_GENDER_AGE day page
CreateInsightSchema PAGE_VIEWS_EXTERNAL_REFERRALS day page
CreateInsightSchema POST_STORIES_BY_ACTION_TYPE lifetime post
CreateInsightSchema POST_STORYTELLERS_BY_ACTION_TYPE lifetime post
CreateInsightSchema PAGE_POSTS_IMPRESSIONS_FREQUENCY_DISTRIBUTION day, week, days_28 post
CreateInsightSchema POST_VIDEO_RETENTION_GRAPH lifetime post

Insights Removed By Facebook

View or Stored Procedure Insight Name Available Periods Target Type
SimpleInsights PAGE_VIEWS_UNIQUE day, week page
InsightsByPaidStatus PAGE_STORYTELLERS_BY_STORY_TYPE day, week, days_28 page
InsightsByPaidStatus POST_IMPRESSIONS_BY_PAID_NON_PAID lifetime page
InsightsByPaidStatus PAGE_IMPRESSIONS_BY_PAID_NON_PAID day, week, days_28 page
InsightsByPaidStatus PAGE_IMPRESSIONS_BY_PAID_NON_PAID_UNIQUE day, week, days_28 page
InsightsByPaidStatus POST_IMPRESSIONS_BY_PAID_NON_PAID_UNIQUE lifetime page
InsightsByPaidStatus PAGE_POSTS_IMPRESSIONS_BY_PAID_NON_PAID day, week, days_28 page
InsightsByPaidStatus PAGE_POSTS_IMPRESSIONS_BY_PAID_NON_PAID_UNIQUE day, week, days_28 page

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462