JDBC Driver for Facebook

Build 24.0.9060

Insight Mapping Reference

The following provides a mapping of specific Facebook insights, showing which periods are available for them, what view they can be used from, and what types of targets are available.

See also: The Meta Developers Guide

Create Insight Schema

The following insights are derived from CreateInsightSchema:

Insight Name Available Periods Target Type Previous Name
PAGE_CONTENT_ACTIVITY_BY_AGE_GENDER_UNIQUE day, week, days_28 page PAGE_STORYTELLERS_BY_AGE_GENDER
PAGE_CONTENT_ACTIVITY_BY_CITY_UNIQUE day, week, days_28 page PAGE_STORYTELLERS_BY_CITY
PAGE_CONTENT_ACTIVITY_BY_COUNTRY_UNIQUE day, week, days_28 page PAGE_STORYTELLERS_BY_COUNTRY
PAGE_CONTENT_ACTIVITY_BY_LOCALE_UNIQUE day, week, days_28 page PAGE_STORYTELLERS_BY_LOCALE
PAGE_IMPRESSIONS_BY_CITY_UNIQUE day, week, days_28 page -
PAGE_IMPRESSIONS_BY_COUNTRY_UNIQUE day, week, days_28 page -
PAGE_IMPRESSIONS_BY_LOCALE_UNIQUE day, week, days_28 page -
PAGE_IMPRESSIONS_BY_AGE_GENDER_UNIQUE day, week, days_28 page -
PAGE_PLACES_CHECKINS_BY_AGE_GENDER day page -
PAGE_PLACES_CHECKINS_BY_LOCALE day page -
PAGE_PLACES_CHECKINS_BY_COUNTRY day page -
PAGE_FANS_LOCALE day page -
PAGE_FANS_CITY day page -
PAGE_FANS_COUNTRY day page -
PAGE_FANS_GENDER_AGE day page -
PAGE_VIEWS_EXTERNAL_REFERRALS day page -
POST_STORIES_BY_ACTION_TYPE lifetime post -
POST_STORYTELLERS_BY_ACTION_TYPE lifetime post -
PAGE_POSTS_IMPRESSIONS_FREQUENCY_DISTRIBUTION day, week, days_28 post -
POST_VIDEO_RETENTION_GRAPH lifetime post -


Page and Post Insights

The following insights are derived from PageAndPostInsights:

Insight Name Available Periods Target Type Previous Name
PAGE_ACTIONS_POST_REACTIONS_ANGER_TOTAL day page -
PAGE_ACTIONS_POST_REACTIONS_HAHA_TOTAL day page -
PAGE_ACTIONS_POST_REACTIONS_LIKE_TOTAL day page -
PAGE_ACTIONS_POST_REACTIONS_LOVE_TOTAL day page -
PAGE_ACTIONS_POST_REACTIONS_SORRY_TOTAL day page -
PAGE_ACTIONS_POST_REACTIONS_WOW_TOTAL day page -
PAGE_CONSUMPTIONS day, week, days_28 page -
PAGE_CONSUMPTIONS_UNIQUE day, week, days_28 page -
PAGE_ENGAGED_USERS day, week, days_28 page -
PAGE_FAN_ADDS day page -
PAGE_FAN_ADDS_UNIQUE day, week, days_28 page -
PAGE_FAN_REMOVES day page -
PAGE_FAN_REMOVES_UNIQUE day page -
PAGE_FANS day page -
PAGE_FANS_ONLINE day page -
PAGE_FANS_ONLINE_PER_DAY day page -
PAGE_IMPRESSIONS day, week, days_28 page -
PAGE_IMPRESSIONS_FREQUENCY_DISTRIBUTION day, week, days_28 page -
PAGE_IMPRESSIONS_ORGANIC day, week, days_28 page -
PAGE_IMPRESSIONS_ORGANIC_UNIQUE day, week, days_28 page -
PAGE_IMPRESSIONS_PAID day, week, days_28 page -
PAGE_IMPRESSIONS_PAID_UNIQUE day, week, days_28 page -
PAGE_IMPRESSIONS_UNIQUE day, week, days_28 page -
PAGE_IMPRESSIONS_VIRAL day, week, days_28 page -
PAGE_IMPRESSIONS_VIRAL_FREQUENCY_DISTRIBUTION day, week, days_28 page -
PAGE_IMPRESSIONS_VIRAL_UNIQUE day, week, days_28 page -
PAGE_NEGATIVE_FEEDBACK day, week, days_28 page -
PAGE_NEGATIVE_FEEDBACK_UNIQUE day, week, days_28 page -
PAGE_PLACES_CHECKIN_MOBILE day, week, days_28 page -
PAGE_PLACES_CHECKIN_MOBILE_UNIQUE day, week, days_28 page -
PAGE_PLACES_CHECKIN_TOTAL day, week, days_28 page -
PAGE_PLACES_CHECKIN_TOTAL_UNIQUE day, week, days_28 page -
PAGE_POST_ENGAGEMENTS day, week, days_28 page -
PAGE_POSTS_IMPRESSIONS day, week, days_28 page -
PAGE_POSTS_IMPRESSIONS_ORGANIC day, week, days_28 page -
PAGE_POSTS_IMPRESSIONS_ORGANIC_UNIQUE day, week, days_28 page -
PAGE_POSTS_IMPRESSIONS_PAID day, week, days_28 page -
PAGE_POSTS_IMPRESSIONS_PAID_UNIQUE day, week, days_28 page -
PAGE_POSTS_IMPRESSIONS_UNIQUE day, week, days_28 page -
PAGE_POSTS_IMPRESSIONS_VIRAL day, week, days_28 page -
PAGE_POSTS_IMPRESSIONS_VIRAL_UNIQUE day, week, days_28 page -
PAGE_CONTENT_ACTIVITY day, week, days_28 page PAGE_STORIES
PAGE_VIDEO_COMPLETE_VIEWS_30S day, week, days_28 page -
PAGE_VIDEO_COMPLETE_VIEWS_30S_AUTOPLAYED day, week, days_28 page -
PAGE_VIDEO_COMPLETE_VIEWS_30S_CLICK_TO_PLAY day, week, days_28 page -
PAGE_VIDEO_COMPLETE_VIEWS_30S_ORGANIC day, week, days_28 page -
PAGE_VIDEO_COMPLETE_VIEWS_30S_PAID day, week, days_28 page -
PAGE_VIDEO_COMPLETE_VIEWS_30S_REPEAT_VIEWS day, week, days_28 page -
PAGE_VIDEO_COMPLETE_VIEWS_30S_UNIQUE day, week, days_28 page -
PAGE_VIDEO_REPEAT_VIEWS day, week, days_28 page -
PAGE_VIDEO_VIEWS day, week, days_28 page -
PAGE_VIDEO_VIEWS_AUTOPLAYED day, week, days_28 page -
PAGE_VIDEO_VIEWS_CLICK_TO_PLAY day, week, days_28 page -
PAGE_VIDEO_VIEWS_ORGANIC day, week, days_28 page -
PAGE_VIDEO_VIEWS_PAID day, week, days_28 page -
PAGE_VIDEO_VIEWS_UNIQUE day, week, days_28 page -
PAGE_VIEWS_TOTAL day, week, days_28 page PAGE_VIEWS
PAGE_VIEWS_LOGGED_IN_TOTAL day, week, days_28 page PAGE_VIEWS_LOGIN
PAGE_VIEWS_LOGGED_IN_UNIQUE day, week, days_28 page PAGE_VIEWS_LOGIN_UNIQUE
PAGE_VIEWS_LOGOUT day page -
POST_CLICKS lifetime post POST_CONSUMPTIONS
POST_CLICKS_UNIQUE lifetime post POST_CONSUMPTIONS_UNIQUE
POST_ENGAGED_USERS lifetime post -
POST_IMPRESSIONS lifetime post -
POST_IMPRESSIONS_FAN lifetime post -
POST_IMPRESSIONS_FAN_PAID lifetime post -
POST_IMPRESSIONS_FAN_PAID_UNIQUE lifetime post -
POST_IMPRESSIONS_FAN_UNIQUE lifetime post -
POST_IMPRESSIONS_ORGANIC lifetime post -
POST_IMPRESSIONS_ORGANIC_UNIQUE lifetime post -
POST_IMPRESSIONS_PAID lifetime post -
POST_IMPRESSIONS_PAID_UNIQUE lifetime post -
POST_IMPRESSIONS_UNIQUE lifetime post -
POST_IMPRESSIONS_VIRAL lifetime post -
POST_IMPRESSIONS_VIRAL_UNIQUE lifetime post -
POST_NEGATIVE_FEEDBACK lifetime post -
POST_NEGATIVE_FEEDBACK_UNIQUE lifetime post -
POST_ACTIVITY lifetime post POST_STORIES
POST_ACTIVITY_UNIQUE lifetime post POST_STORYTELLERS
POST_VIDEO_AVG_TIME_WATCHED lifetime post -
POST_VIDEO_COMPLETE_VIEWS_ORGANIC lifetime post -
POST_VIDEO_COMPLETE_VIEWS_ORGANIC_UNIQUE lifetime post -
POST_VIDEO_COMPLETE_VIEWS_PAID lifetime post -
POST_VIDEO_COMPLETE_VIEWS_PAID_UNIQUE lifetime post -
POST_VIDEO_LENGTH lifetime post -
POST_VIDEO_VIEW_TIME lifetime post -
POST_VIDEO_VIEW_TIME_ORGANIC lifetime post -
POST_VIDEO_VIEWS_10S lifetime post -
POST_VIDEO_VIEWS_10S_AUTOPLAYED lifetime post -
POST_VIDEO_VIEWS_10S_CLICKED_TO_PLAY lifetime post -
POST_VIDEO_VIEWS_10S_ORGANIC lifetime post -
POST_VIDEO_VIEWS_10S_PAID lifetime post -
POST_VIDEO_VIEWS_10S_SOUND_ON lifetime post -
POST_VIDEO_VIEWS_10S_UNIQUE lifetime post -
POST_VIDEO_VIEWS_ORGANIC lifetime post -
POST_VIDEO_VIEWS_ORGANIC_UNIQUE lifetime post -
POST_VIDEO_VIEWS_PAID lifetime post -
POST_VIDEO_VIEWS_PAID_UNIQUEPOST_VIDEO_VIEWS_SOUND_ON lifetime post -


Insights By Consumption Type

The following insights are derived from InsightsByConsumptionType:

Insight Name Available Periods Target Type Previous Name
PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE day, week, days_28 page -
PAGE_CONSUMPTIONS_BY_CONSUMPTION_TYPE_UNIQUE day, week, days_28 page -
POST_CLICKS_BY_TYPE lifetime post POST_CONSUMPTIONS_BY_CONSUMPTION_TYPE
POST_CLICKS_BY_TYPE_UNIQUE lifetime post POST_CONSUMPTIONS_BY_CONSUMPTION_TYPE_UNIQUE


Insights By Feedback Type

The following insights are derived from InsightsByFeedbackType:

Insight Name Available Periods Target Type Previous Name
PAGE_NEGATIVE_FEEDBACK_BY_TYPE day, week, days_28 page -
PAGE_NEGATIVE_FEEDBACK_BY_TYPE_UNIQUE day, week, days_28 page -
PAGE_POSITIVE_FEEDBACK_BY_TYPE day, week, days_28 page -
PAGE_POSITIVE_FEEDBACK_BY_TYPE_UNIQUE day, week, days_28 page -
POST_NEGATIVE_FEEDBACK_BY_TYPE lifetime post -
POST_NEGATIVE_FEEDBACK_BY_TYPE_UNIQUE lifetime post -


Insights By Like Source Type

The following insights are derived from InsightsByLikeSourceType:

Insight Name Available Periods Target Type Previous Name
PAGE_FANS_BY_LIKE_SOURCE day page -
PAGE_FANS_BY_LIKE_SOURCE_UNIQUE day page -


Insights By Un Like Source Type

The following insights are derived from InsightsByUnLikeSourceType:

Insight Name Available Periods Target Type Previous Name
PAGE_FANS_BY_UNLIKE_SOURCE day page -
PAGE_FANS_BY_UNLIKE_SOURCE_UNIQUE day page -


Insights By Reaction Totals

The following insights are derived from InsightsByReactionTotals:

Insight Name Available Periods Target Type Previous Name
PAGE_ACTIONS_POST_REACTIONS_TOTAL day page -
POST_REACTIONS_BY_TYPE_TOTAL day page -


Insights By Story Type

The following insights are derived from InsightsByStoryType:

Insight Name Available Periods Target Type Previous Name
PAGE_CONTENT_ACTIVITY_BY_ACTION_TYPE day, week, days_28 page PAGE_STORIES_BY_STORY_TYPE
PAGE_IMPRESSIONS_BY_STORY_TYPE day, week, days_28 page -
PAGE_IMPRESSIONS_BY_STORY_TYPE_UNIQUE day, week, days_28 page -
POST_IMPRESSIONS_BY_STORY_TYPE day, week, days_28 page -
POST_IMPRESSIONS_BY_STORY_TYPE_UNIQUE day, week, days_28 page -


Insights By Tab Type

The following insights are derived from InsightsByTabType:

Insight Name Available Periods Target Type Previous Name
PAGE_TAB_VIEWS_LOGIN_TOP_UNIQUE day, week page -
PAGE_TAB_VIEWS_LOGIN_TOP day, week page -
PAGE_TAB_VIEWS_LOGOUT_TOP day page -


Simple Video Insights

The following insights are derived from SimpleVideoInsights:

Insight Name Available Periods Target Type Previous Name
PAGE_VIDEO_VIEW_TIME day page -
TOTAL_VIDEO_VIEWS lifetime video -
TOTAL_VIDEO_VIEWS_UNIQUE lifetime video -
TOTAL_VIDEO_VIEWS_AUTOPLAYED lifetime video -
TOTAL_VIDEO_VIEWS_CLICKED_TO_PLAY lifetime video -
TOTAL_VIDEO_VIEWS_SOUND_ON lifetime video -
TOTAL_VIDEO_COMPLETE_VIEWS lifetime video -
TOTAL_VIDEO_COMPLETE_VIEWS_UNIQUE lifetime video -
TOTAL_VIDEO_COMPLETE_VIEWS_AUTO_PLAYED lifetime video -
TOTAL_VIDEO_COMPLETE_VIEWS_CLICKED_TO_PLAY lifetime video -
TOTAL_VIDEO_10S_VIEWS lifetime video -
TOTAL_VIDEO_10S_VIEWS_UNIQUE lifetime video -
TOTAL_VIDEO_10S_VIEWS_auto_played lifetime video -
TOTAL_VIDEO_10S_VIEWS_CLICKED_TO_PLAY lifetime video -
TOTAL_VIDEO_10S_VIEWS_SOUND_ON lifetime video -
TOTAL_VIDEO_AVG_TIME_WATCHED lifetime video -
TOTAL_VIDEO_VIEW_TOTAL_TIME lifetime video -
TOTAL_VIDEO_IMPRESSIONS lifetime video -
TOTAL_VIDEO_IMPRESSIONS_UNIQUE lifetime video -
TOTAL_VIDEO_IMPRESSIONS_VIRAL_UNIQUE lifetime video -
TOTAL_VIDEO_IMPRESSIONS_VIRAL lifetime video -
TOTAL_VIDEO_IMPRESSIONS_FAN_UNIQUE lifetime video -
TOTAL_VIDEO_IMPRESSIONS_FAN lifetime video -


Video Insights By Action Type

The following insights are derived from VideoInsightsByActionType:

Insight Name Available Periods Target Type Previous Name
TOTAL_VIDEO_STORIES_BY_ACTION_TYPE lifetime video -


Video Insights By Distribution Type

The following insights are derived from VideoInsightsByDistributionType:

Insight Name Available Periods Target Type Previous Name
TOTAL_VIDEO_VIEWS_BY_DISTRIBUTION_TYPE lifetime video -
TOTAL_VIDEO_VIEW_TIME_BY_DISTRIBUTION_TYPE lifetime video -


Video Insights By Reaction Type

The following insights are derived from VideoInsightsByReactionType:

Insight Name Available Periods Target Type Previous Name
TOTAL_VIDEO_REACTIONS_BY_TYPE_TOTAL lifetime video -

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060