Articles in this section

See more

Creating an Import from Facebook (Page Insights)

Avatar
Alex Marino
Updated
Follow

Overview

This import pulls data from a Facebook business page and outputs the following tables. See the column section below for a detailed description of the data in each table. 

  • post_basic_info – title, id, and metadata of each post that was created between the start/end date of your import.
  • post_insights – detailed, raw data on post impressions, shares, etc. within the date range selected for the import.
  • page_basic_info – summary data of the page, updated to the maximum date selected on the import. 
  • page_insights – page impressions, shares, and activity by day for the range of dates specified in the import
    • Use wide format checkmark parameter: If checked, the page_insights table will aggregate each metrics at the day level (level of the data), otherwise the page_insights table will have a row for each activity. We recommend you use the wide format. 

Adding a Facebook Custom Credential To Platform

Use this Service to create a Facebook Custom Credential to Platform. Note that the Facebook account you link to the credential must have admin permissions on the Facebook page you'll be importing data from. An existing Facebook group administrator on that page can give you the proper permission.

If you encounter any issues with the Service please reach out to Support@CivisAnalytics.com

To create an Import from Facebook

  1. On the top navigation menu, click Data, and then under Imports, select "Facebook."
  2. Add a Facebook credential to Civis. See ​​Adding a Facebook Custom Credential To Platform above for instructions to create one.
  3. Fill out the appropriate fields.
  4. To run the import, click "Run Now" in the upper right hand corner of the page

 Notes

  • This import is only supported for Redshift Databases.
  • This import only supports importing data from a maximum of 2 years from the current date. 

 Recommendations

  • This import produces a lot of data. There are currently 245 metrics, with lifetime, weekly, and daily breakdowns. For your first import run, we recommend pulling in just one day of data to see what it looks like.
  • If you are running the job on a schedule so the data updates each run, we recommend running the import in “upsert” mode, with days=30. This will pull and update data for the past 30 days, while still pulling a manageable amount of data from Facebook on each request.
  • The “reported” column in the post_insights table indicates when each value was last refreshed by the import job.
  • Enormous requests break Facebook's servers. If your import fails, try again with a smaller time range.

Migration from older Facebook Imports

  • If you have set up a Facebook Import before early 2020, you will likely need to make a couple of small changes to use the supported version. (Reach out to Support@CivisAnalytics.com or your Client Success Specialist if you do not know what version you are using).
  • To create a Facebook Import with the most recent version:
    • Select the “Import From Facebook” template in the Data section located in the top navigation bar.
    • Use the same values from your older Facebook Import job for most parameters, i.e. for anything that exists on both templates.
    • For the new parameters, it is recommended to do the following:
      • PAGE INSIGHTS TABLE NAME -- this can be any valid table name, but it is probably best to use a similar convention as the other tables you are using.
      • PAGE INSIGHTS, USE WIDE FORMAT? -- If you have been running the older version, you may have workflows that depend on the older format for the page insights data. Leave this unchecked in those cases. However, the data will be more readable if this is checked (see page_insights in the overview). We recommend re-importing the data in this new format if possible.
        • If in doubt, consult with your Client Success analyst on the workflow(s) you are running with this template.
    •  Make sure to set IF TABLES EXIST? to “upsert” if you have been running a scheduled job with the older template template.

Columns

More information about each column can be found in the Facebook documentation here.  

Post_basic_info- one row per post

  • Unshimmed_url,
  • Media_type,
  • Description,
  • Title,
  • Created_time,
  • Icon,
  • Is_hidden,
  • Message,
  • Id,
  • Reactions,
  • Shares,
  • Status_type,
  • Subscribed,
  • Updated_time,
  • reported

Post_insights- multiple rows per post, each row is a different insight per post

  • Description,
  • Id,
  • Name,
  • Period,
  • Title,- impressions, comments, (can we make a unique list here) 
  • Reported,
  • Value, - 
  • Value_type- 

Page_basic_info- one row per page

  • Reported,
  • About,
  • Category,
  • Fan_count,
  • Name,
  • website

Page_insights (wide version)

  • Page_id,
  • Date,- this is at the day level
  • Page_content_activity_by_action_type_unique,
  • Page_content_activity_by_age_gender_unique,
  • Page_content_activity_by_city_unique,
  • Page_content_activity_by_country_unique,
  • Page_content_activity_by_locale_unique,
  • Page_content_activity,
  • Page_content_activity_by_action_type,
  • Page_impressions,
  • Page_impressions_unique,
  • Page_impressions_paid,
  • Page_impressions_paid_unique,
  • Page_impressions_organic,
  • Page_impressions_organic_unique,
  • Page_impressions_viral,
  • Page_impressions_viral_unique,
  • Page_impressions_nonviral,
  • Page_impressions_nonviral_unique,
  • Page_impressions_by_story_type,
  • Page_impressions_by_story_type_unique,
  • Page_impressions_by_city_unique,
  • Page_impressions_by_country_unique,
  • Page_impressions_by_locale_unique,
  • Page_impressions_by_age_gender_unique,
  • Page_impressions_frequency_distribution,
  • Page_impressions_viral_frequency_distribution,
  • Page_engaged_users,
  • Page_post_engagements,
  • Page_consumptions,
  • Page_consumptions_unique,
  • Page_consumptions_by_consumption_type,
  • Page_consumptions_by_consumption_type_unique,
  • Page_places_checkin_total,
  • Page_places_checkin_total_unique,
  • Page_places_checkin_mobile,
  • Page_places_checkin_mobile_unique,
  • Page_places_checkins_by_age_gender,
  • Page_places_checkins_by_locale,
  • Page_places_checkins_by_country,
  • Page_negative_feedback,
  • Page_negative_feedback_unique,
  • Page_negative_feedback_by_type,
  • Page_negative_feedback_by_type_unique,
  • Page_positive_feedback_by_type,
  • Page_positive_feedback_by_type_unique,
  • Page_fans_online,page_fans_online_per_day,
  • Page_fan_adds_by_paid_non_paid_unique,
  • Page_actions_post_reactions_like_total,
  • Page_actions_post_reactions_love_total,
  • Page_actions_post_reactions_wow_total,
  • Page_actions_post_reactions_haha_total,
  • Page_actions_post_reactions_sorry_total,
  • Page_actions_post_reactions_anger_total,
  • Page_actions_post_reactions_total,
  • Page_total_actions,page_cta_clicks_logged_in_total,
  • Page_cta_clicks_logged_in_unique,
  • Page_cta_clicks_by_site_logged_in_unique,
  • Page_cta_clicks_by_age_gender_logged_in_unique,
  • Page_cta_clicks_logged_in_by_country_unique,
  • Page_cta_clicks_logged_in_by_city_unique,
  • Page_call_phone_clicks_logged_in_unique,
  • Page_call_phone_clicks_by_age_gender_logged_in_unique,
  • Page_call_phone_clicks_logged_in_by_country_unique,
  • Page_call_phone_clicks_logged_in_by_city_unique,
  • Page_call_phone_clicks_by_site_logged_in_unique,
  • Page_get_directions_clicks_logged_in_unique,
  • Page_get_directions_clicks_by_age_gender_logged_in_unique,
  • Page_get_directions_clicks_logged_in_by_country_unique,
  • Page_get_directions_clicks_logged_in_by_city_unique,
  • Page_get_directions_clicks_by_site_logged_in_unique,
  • Page_website_clicks_logged_in_unique,
  • Page_website_clicks_by_age_gender_logged_in_unique,
  • Page_website_clicks_logged_in_by_country_unique,
  • Page_website_clicks_logged_in_by_city_unique,
  • Page_website_clicks_by_site_logged_in_unique,
  • Page_fans,page_fans_locale,page_fans_city,
  • Page_fans_country,page_fans_gender_age,
  • Page_fan_adds,page_fan_adds_unique,
  • Page_fans_by_like_source,page_fans_by_like_source_unique,
  • Page_fan_removes,page_fan_removes_unique,
  • Page_fans_by_unlike_source_unique,
  • Page_tab_views_login_top_unique,
  • Page_tab_views_login_top,
  • Page_tab_views_logout_top,
  • Page_views_total,
  • Page_views_logout,page_views_logged_in_total,
  • Page_views_logged_in_unique,
  • Page_views_external_referrals,
  • Page_views_by_profile_tab_total,
  • Page_views_by_profile_tab_logged_in_unique,
  • Page_views_by_internal_referer_logged_in_unique,
  • Page_views_by_site_logged_in_unique,
  • Page_views_by_age_gender_logged_in_unique,
  • Page_views_by_referers_logged_in_unique,
  • Page_video_views,page_video_views_paid,
  • Page_video_views_organic,page_video_views_by_paid_non_paid,
  • Page_video_views_autoplayed,page_video_views_click_to_play,
  • Page_video_views_unique,page_video_repeat_views,
  • Page_video_complete_views_30s,
  • Page_video_complete_views_30s_paid,
  • Page_video_complete_views_30s_organic,
  • Page_video_complete_views_30s_autoplayed,
  • Page_video_complete_views_30s_click_to_play,
  • Page_video_complete_views_30s_unique,
  • Page_video_complete_views_30s_repeat_views,
  • Post_video_complete_views_30s_autoplayed,
  • Post_video_complete_views_30s_clicked_to_play,
  • Post_video_complete_views_30s_organic,post_video_complete_views_30s_paid,
  • Post_video_complete_views_30s_unique,
  • Page_video_views_10s,page_video_views_10s_paid,
  • Page_video_views_10s_organic,page_video_views_10s_autoplayed,
  • Page_video_views_10s_click_to_play,page_video_views_10s_unique,
  • Page_video_views_10s_repeat,page_video_view_time,
  • Page_posts_impressions,page_posts_impressions_unique,
  • Page_posts_impressions_paid,
  • Page_posts_impressions_paid_unique,page_posts_impressions_organic,
  • Page_posts_impressions_organic_unique,
  • Page_posts_served_impressions_organic_unique,
  • Page_posts_impressions_viral,
  • Page_posts_impressions_viral_unique,
  • Page_posts_impressions_nonviral,
  • Page_posts_impressions_nonviral_unique,page_posts_impressions_frequency_distribution,
  • Page_daily_video_ad_break_ad_impressions_by_crosspost_status,
  • Page_daily_video_ad_break_cpm_by_crosspost_status,
  • page_daily_video_ad_break_earnings_by_crosspost_status

 

 

Related articles

Comments

0 comments

Please sign in to leave a comment.