Facebook - page metrics

Metrics data structure

Before we show the list of available metrics, it’s important to understand that, based on the way we retrieve this information, some metrics will include breakdowns while others won’t:

Breakdowns

Metrics may or may not include additional breakdowns. For example:

  • A metric that calculates the number of impressions for your posts is not a breakdown metric; it only shows the total impressions per day.
  • A metric that calculates the number of impressions per day, broken down by user age and gender, contains a breakdown and shows detailed counts by day, age, and gender.

With this in mind, the structure of tables and columns follows a standard format: a main table aggregates metrics without breakdowns as columns, while separate tables handle metrics with breakdowns.

The main table will contain the following columns:

  • page_id: the ID of the page to which the metric refers (we recommend creating an integration with the “Pages” object to better associate the page name with its ID)
  • metric_date: the date of the metric for that page
  • metric_1, metric_2, metric_3: values of selected metrics without breakdowns for that page on that date

Tables for metrics with breakdowns will use the following column format:

  • page_id: the same value as in the main table
  • metric_date: the same value as in the main table
  • key: the breakdown key for the metric. For example, for a table showing users by country, this would be the country code.
  • value: the value for that key on that day for that page. In the previous example, “12” would indicate that there were 12 users from that country on that day for that page.

Available Metrics
The table below lists all available metrics, along with a description and an indication of whether or not they include a breakdown. Additional tables below provide more details on specific metrics. This table follows the format:

  • Category: the category of the metric; this doesn’t affect functionality, serving only as organization
  • Metric: the metric code as referenced in Kondado’s platform. An asterisk (*) indicates that this metric may be updated multiple times throughout the day
  • Description: a description of the metric
  • D: indicates whether this metric includes a breakdown

Due to time zone differences between data reported by Facebook on the platform (in Pacific Time) and via API, there is a 2-day difference between the date in Facebook and the date of data inserted into your destination (metric_date). This means data you see on Facebook on the 1st will appear as the 3rd in your destination.

CategoryMetricDescriptionD
Clicks on CTApage_total_actionsThe number of clicks on your page's contact information and the CTA buttonNo
Clicks on CTApage_get_directions_clicks_logged_in_uniqueThe number of logged-in people on Facebook who clicked the directions button for the addressNo
Engagementpage_post_engagements*The number of times people engaged with your posts with reactions, comments, shares, and moreNo
Engagementpage_fan_adds_by_paid_non_paid_uniqueThe number of new people who liked your page, detailed by paid or unpaidYes
Impressionspage_impressions_unique*The number of people who had any content from or about your page appear on their screen. Includes posts, stories, check-ins, ads, etc.No
Impressionspage_impressions_paid_unique*The number of people who had any content from your page appear on their screen through paid distribution, like an adNo
Impressionspage_impressions_viral_unique*The number of people who had any content from or about your page appear on their screen with associated social informationNo
Impressionspage_impressions_nonviral_unique*The number of people who had any content from your page appear on their screen without socially attributed contentNo
Postspage_posts_impressions*The number of times your page's posts appeared on a person’s screen. Includes status, photos, links, videos, and moreNo
Postspage_posts_impressions_unique*The number of people who had any post from your page appear on their screen. Includes status, photos, links, videos, and moreNo
Postspage_posts_impressions_paid*The number of times your page’s posts appeared on a person’s screen through paid distribution, like an adNo
Postspage_posts_impressions_paid_unique*The number of people who had any content from your page appear on their screen through paid distribution, like an adNo
Postspage_posts_served_impressions_organic_uniqueThe number of people who had your page’s posts offered to their feed, whether it appeared on their screen or notNo
Postspage_posts_impressions_viral*The number of times your page's posts appeared on people’s screens with associated social informationNo
Postspage_posts_impressions_viral_unique*The number of people who had any post from your page appear on their screen with associated social informationNo
Postspage_posts_impressions_nonviral*The number of times your page’s posts appeared on a person’s screen without associated social informationNo
Postspage_posts_impressions_nonviral_unique*The number of people who had any post from your page appear on their screen without associated social informationNo
Reactionspage_actions_post_reactions_like_totalThe total daily number of “like” reactions on a page's postsNo
Reactionspage_actions_post_reactions_love_totalThe total daily number of “love” reactions on a page's postsNo
Reactionspage_actions_post_reactions_wow_totalThe total daily number of “wow” reactions on a page's postsNo
Reactionspage_actions_post_reactions_haha_totalThe total daily number of “haha” reactions on a page's postsNo
Reactionspage_actions_post_reactions_sorry_totalThe total daily number of “sad” reactions on a page's postsNo
Reactionspage_actions_post_reactions_anger_totalThe total daily number of “angry” reactions on a page's postsNo
Reactionspage_actions_post_reactions_totalThe total daily number of reactions on a page's posts by typeYes
Videopage_video_viewsThe number of times your page's videos played for at least 3 seconds or almost fully if under 3 secondsNo
Videopage_video_views_paidThe number of times your page's promoted videos played for at least 3 seconds or almost fully if shorter than 3 secondsNo
Videopage_video_views_organicThe number of times your page's videos played for at least 3 seconds through organic reachNo
Videopage_video_views_by_paid_non_paid*The number of times your page's videos played for at least 3 seconds, detailed by total, paid, and unpaidYes
Videopage_video_views_autoplayedThe number of times your page’s videos were autoplayed for at least 3 seconds or almost fully if shorter than 3 secondsNo
Videopage_video_views_click_to_playThe number of times your page's videos played for at least 3 seconds after people pressed playNo
Videopage_video_views_uniqueThe number of people who watched your page's videos for at least 3 secondsNo
Videopage_video_repeat_viewsThe number of times your page's videos were replayed for at least 3 secondsNo
Videopage_video_complete_views_30sThe number of times your page's videos played for at least 30 secondsNo
Videopage_video_complete_views_30s_paidThe number of times your promoted videos played for at least 30 secondsNo
Videopage_video_complete_views_30s_organicThe number of times your page's videos played for at least 30 seconds through organic reachNo
Videopage_video_complete_views_30s_autoplayedThe number of times your page's videos autoplayed for at least 30 secondsNo
Videopage_video_complete_views_30s_click_to_playThe number of times your videos played for at least 30 seconds after people clicked playNo
Videopage_video_complete_views_30s_uniqueThe number of people who watched your videos for at least 30 secondsNo
Videopage_video_complete_views_30s_repeat_viewsThe number of times your videos replayed for at least 30 secondsNo
Videopage_video_view_timeThe total time, in milliseconds, people spent watching your page's videosNo
Viewspage_views_totalThe number of times your page profile was viewed by logged-in or non-logged-in people on FacebookNo

Tab Types

KeyDescription
allactivityAdministrative tab
appCustom tab
info"About" tab
insightsInsights tab
likesLikes tab
locationsMap tab
photosPhotos tab
photos_albumsPhotos tab
photos_streamPhotos tab
profilePage timeline
profile_infoInformation tab
profile_likesLikes tab
profile_photosPhotos tab
timelinePage timeline
eventsEvents tab
videosVideos tab
wallTimeline

Types of Negative Feedback

KeyDescription
hide_clicksHide this story
hide_all_clicksHide all posts from this page
report_spam_clicksReport an item as spam
unlike_page_clicksUnlike the page

Types of Positive Feedback

KeyDescription
answerAnswer a question
claimAccept an offer
commentComment on a story
likeLike a story
linkShare a story
otherOther types, such as check-ins
rsvpRespond to an event invitation

Types of Stories

KeyDescription
checkinCheck-ins on the page
couponOffers
eventEvent RSVPs
fanPage likes
mentionMentions of the page
page postPage posts
questionResponses to questions
user postUser posts on the page
otherOther types

Sources of Likes

KeyDescription
AdsPage likes from people who saw your page or post in an ad
News FeedPage likes from people who saw content published by or about your page in their feed
Page SuggestionsPage likes from people who saw your page in a list of suggested pages
Restored Likes from Reactivated AccountsPage likes from people who reactivated their Facebook profile
SearchPage likes from people who saw your page or post in search
Your PagePage likes from people who visited your page

Sources of Unlikes

KeyDescription
Deactivated or Memorialized Account RemovalsPage likes removed due to accounts being deactivated or memorialized
OtherPage likes removed for reasons other than account deletion, memorialization, suspicious accounts, unlikes from posts, feed, or search
Suspicious Account RemovalsPage likes removed due to suspicious account activity
Unlikes from Page, Posts, or News FeedPage likes removed by people who saw content posted by or about your page in the feed
Unlikes from SearchPage likes removed by people who saw your page or post in search