Facebook Page Insights Data Export

What is Facebook Page Insights?

Facebook Page Insights provides the demographic about your page. Using Facebook for your business expands organizations, brands etc. FB Insights encourages to know your audience, provides accomplishment of your posts, pages, videos over time.

How to add Page Insights - Facebook Source in Electrik.AI?

Follow these steps to connect your Facebook Page Insights to Electrik.AI

Step 1: Ensure you have following prerequisites to create a Facebook Page Connection in Electrik.AI

a. Facebook Page Insights User Id and Password.

b. Access to Facebook account

Step 2: Sign-in into your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard

Step 4: Select the Connections tab in the left most navigation bar & click on “Add” action button.

Select the Connections tab in the left most navigation bar & click on “Add” action button

Step 5: The Source default tab is selected just click on “Facebook Page Insights” connection.

The Source default tab is selected just click on “Facebook Page Insights” connection

Step 6: Provide your Facebook account User Id and Password.

Provide your Facebook Page account User Id and Password.

Step 7: Select Page for which you want to export the insights.

Select Page for which you want to export the insights

Step 8: Allow Electrik.AI to access your selected Facebook Page.

Allow Electrik.AI to access your selected Facebook Page
Allow Electrik.AI to access your selected Facebook Page (2)

Step 9: Select the Facebook Page from the dropdown whose data you wish to export.

Select the Facebook Page from the dropdown whose data you wish to export

Step 10: Click on Save button on the top. 

Click on Save button on the top

Congratulations, you have successfully created a Page Insights – Facebook Connection in Electrik.AI

Congratulations, you have successfully created a Page Insights - Facebook Connection in ElectrikAI

What are the supported Data Destinations?

Electrik.AI supports the following destinations to export Facebook Page Data.

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI
EletrikAI

How to Export Facebook Page Insights?

Electrik.AI creates a data flow (or ETL process) that exports Facebook Page insights to a target database or data warehouse. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Facebook Page to Database/Data Warehouse

Step 1: Ensure you have the following prerequisites.

1. Access to Facebook Account.

2. Facebook Page Account User Id and Password.

3. Access to a Database/Warehouse of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)

4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password.

Step 2: Sign-in into your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard

Step 4: Click on Add button to create a Facebook Page Insights Flow.

Click on Add button to create a Microsoft Ads Flow

Step 5: Select Facebook Page Insights Connection present in the list of available sources

Select Facebook Page Connection present in the list of available sources

Step 6: Select your existing Facebook Page Insights connection in Electrik.AI.

Select your existing Facebook Page connection in Electrik.AI

To Configure a new connection, refer to this link.

Step 7: Click on a database/ warehouse of your choice from list of available destinations.
In this example we are choosing BigQuery. 

Click on a database-warehouse of your choice from list of available destinations

Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.

Flow Step 8 Select your existing BigQuery connection in Electrik.AI

Step 9:
a. Electrik.AI now supports 5 reports, choose the desired type to get the appropriate data. In this example we are choosing Page Content Insights.

Step 9a Electrik.AI now supports 5 reports, choose the desired type to get the appropriate data. In this example we are choosin Page Content Insights

b. Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.
Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

9b Review the Data Source, Data Destination, Database Schema, “Save and Proceed” to continue

Note: By Default, Electrik.AI chooses an existing Database Schema to load your Facebook Page Report. You can create a new schema in your database by selecting the “Create New Schema” radio button.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen

You have now successfully setup Facebook Page Insights Report to BigQuery Data Warehouse flow in Electrik.AI

You have now successfully setup Facebook Page Insights Report to BigQuery

Your Facebook Page Insights will start loading after 24 hours in your Data Warehouse. 

New-Your Facebook Page Insights will start loading after 24 hours in your Data Warehouse. 

Facebook Page Data Schema

Index Category Electrik.AI Column Name Description Sample Value
1 Dimension end_time End time 2021-04-09T07:00:00+0000
2 Metrics page_actions_post_ reactions_anger_total Daily total post “sorry” reactions of a page. [{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
3 Metrics page_actions_post_ reactions_haha_total Daily total post “wow” reactions of a page. [{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
4 Metrics page_actions_post_ reactions_like_total The number of people your Page reached from a story published by a friend, broken down by how many times people saw stories about your Page. [{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
5 Metrics page_actions_post_ reactions_love_total Daily total post “like” reactions of a page. [{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
6 Metrics page_actions_post_ reactions_sorry_total Daily total post “haha” reactions of a page. [{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
7 Metrics page_actions_post_ reactions_total Daily total post “anger” reactions of a page. [{“value”:{},”end_time”: “2021-04-09T07:00:00+0000”}]
8 Metrics page_actions_post_ reactions_wow_total Daily total post “love” reactions of a page. [{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
9 Metrics page_call_phone_clicks_ by_age_gender_logged_ in_unique Number of people who logged in to Facebook and clicked the Call Now button.
10 Metrics page_call_phone_clicks_ by_site_logged_in_unique Number of people who logged in to Facebook and clicked the Call Now button, broken down by city. [{“value”:{},”end_time”: “2021-04-09T07:00:00+0000”}]
11 Metrics page_call_phone_clicks_ logged_in_by_city_unique Number of people who logged in to Facebook and clicked the Call Now button, broken down by countries.
12 Metrics page_call_phone_clicks_ logged_in_by_country_unique Number of people who logged in to Facebook and clicked the Call Now button, broken down by age and gender group.
13 Metrics page_call_phone_clicks_ logged_in_unique Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by city. [{“value”:0,”end_time”:” 2021-04-09T07:00:00+0000″}]
14 Metrics page_consumptions The number of times people have engaged with your posts through reactions, comments, shares and more. [{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
15 Metrics page_consumptions_ by_consumption_type page consumptions by consumption type [{“value”:{},”end_time”: “2021-04-09T07:00:00+0000”}]
16 Metrics page_consumptions_by_ consumption_type_unique The number of times people clicked on any of your content, by type. [{“value”:{},”end_time”: “2021-04-09T07:00:00+0000”}]
17 Metrics page_consumptions_ unique The number of times people clicked on any of your content. [{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
18 Metrics page_cta_clicks_by_ age_gender_logged_in_unique Number of people who are logged in to Facebook and clicked on the CTA button, broken down by www, mobile, api or other.
19 Metrics page_cta_clicks_by_ site_logged_in_unique Unique number of clicks on the Page CTA button by people who are logged in to Facebook. [{“value”:{},”end_time”: “2021-04-09T07:00:00+0000”}]
20 Metrics page_cta_clicks_logged _in_by_city_unique Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by country.
21 Metrics page_cta_clicks_logged _in_by_country_unique Number of people who are logged in to Facebook and clicked the Page CTA button, broken down by age and gender group.
22 Metrics page_cta_clicks_ logged_in_total The number of clicks on your Page’s contact info and call-to-action button. [{“value”:{“198307808758289″: 0,”198307772091626″:0,”198307768

758293″

:0,”198307765424960″ :0,”198307762091627″:0,”19830775

8758294”:0}, “end_time”: “2021-04-09T07:00:00+0000”}]

23 Metrics page_cta_clicks_ logged_in_unique Total number of clicks on the Page CTA button by people who are logged in to Facebook. [{“value”:{“198307808758289″: 0,”198307772091626″:0,”198307768758293″:

0,”198307765424960″:0,”198307762091627″ :0,”198307758758294”:0}, “end_time”:

“2021-04-09T07: 00:00+0000”}]

24 Metrics page_engaged_users Number of people who logged in to Facebook and clicked the Page CTA button, broken down by www, mobile, api and other. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

25 Metrics page_fan_adds The number of people who saw any of your posts at least once, grouped by age and gender. Aggregated demographic data is based on a number of factors, including age and gender information users provide in their Facebook profiles. This number
is an estimate.
[{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

26 Metrics page_fan_adds_ by_paid_non_ paid_unique The number of your fans who saw any posts on Facebook on a given day. [{“value”:{“total”:0,”paid”:0,”unpaid”:0},

“end_time”:”2021-04-09T07: 00:00+0000″}]

27 Metrics page_fan_adds_ unique The number of new people who have liked your Page. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

28 Metrics page_fan_removes The number of people who liked your Page, broken down by the most common places where people can like your Page. (See possible types) [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

29 Metrics page_fan_removes_ unique page fan removes unique [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

30 Metrics page_fans Logged-in Page visit counts (unique users) by referral source. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

31 Metrics page_fans_by_like_ source The number of new people who have liked your Page. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

32 Metric page_fans_by_like_ source_unique This is a breakdown of the number of Page likes from the most common places where people can like your Page. (See possible types) [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

33 Metrics page_fans_by_ unlike_source page fans by unlike source [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

34 Metrics page_fans_by_unlike_ source_unique page fans by unlike source unique [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

35 Metrics page_fans_city Aggregated language data about the people who like your Page based on the default language setting selected when accessing Facebook.
36 Metrics page_fans_country Aggregated Facebook location data, sorted by city, about the people who like your Page.
37 Metrics page_fans_gender_ age The number of people, aggregated per country, that like your Page. Only the 45 countries with the most people that like your Page are included.
38 Metrics page_fans_locale The total number of people who have liked your Page. 156417
39 Metrics page_fans_online The number of people who took a positive action broken down by type. (See possible types) [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

40 Metrics page_fans_online_ per_day The number of your fans who saw any posts on Facebook on a given day, broken down by hour of day in PST/PDT.
41 Metrics page_get_directions_ clicks_by_age_ gender_logged_ in_unique Number of people who logged in to Facebook and clicked the Get Directions button.
42 Metrics page_get_directions_ clicks_by_site_ logged_in_unique Number of people who logged in to Facebook and clicked the Get Directions button, broken down by city. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

43 Metrics page_get_directions_ clicks_logged_in_ by_city_unique Number of people who logged in to Facebook and clicked the Get Directions button, broken down by country.
44 Metrics page_get_directions_ clicks_logged_in_ by_country_unique Number of people who logged in to Facebook and clicked the Get Directions button, broken down by age and gender group.
45 Metrics page_get_directions_ clicks_logged_in_ unique The number of people who clicked your Page’s phone number or Call Now button while they were logged into Facebook, broken down by the type of device they used. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

46 Dimension page_id page id 1.03873E+14
47 Metrics page_impressions The number of new people who have liked your Page broken down by paid and non-paid. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

48 Metrics page_impressions_by_ age_gender_unique The number of people who have seen any content associated with your Page by user selected language.
49 Metrics page_impressions_by_ city_unique The number of people who saw posts published by a friend about your Page by type. (See possible types)
50 Metrics page_impressions_by_ country_unique The number of people who have seen any content associated with your Page by city. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

51 Metrics page_impressions_by_ locale_unique The number of people who have seen any content associated with your Page by country.
52 Metrics page_impressions_by_ story_type The number of people who had any content from your Page enter their screen. This does not include content created about your Page with social information attached. As a form of organic distribution, social information displays when a person’s
friend interacted with your Page, post or story. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

53 Metrics page_impressions_by_ story_type_unique Total impressions of posts published by a friend about your Page by type. (See possible types) [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

54 Metrics page_impressions_ frequency_distribution The number of people who saw any content by your Page or about your Page, grouped by age and gender. This number is an estimate. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

55 Metrics page_impressions_ nonviral The number of people who had any content from your Page or about your Page enter their screen through with social information attached. As a form of organic distribution, social information displays when a person’s friend interacted with your
Page, post or story. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

56 Metrics page_impressions_ nonviral_unique The number of times any content from your Page entered a person’s screen. This does not include content created about your Page with social information attached. Social information displays when a person’s friend interacted with your Page,
post or story. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

57 Metrics page_impressions_ organic The number of people who had any content from your Page or about your Page enter their screen through paid distribution such as an ad. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

58 Metrics page_impressions_ organic_unique The number of times any content from your Page or about your Page entered a person’s screen through unpaid distribution. This includes posts, stories, check-ins, social information from people who interact with your Page and more. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

59 Metrics page_impressions_paid The number of people who had any content from your Page or about your Page enter their screen. This includes posts, stories, check-ins, ads, social information from people who interact with your Page and more. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

60 Metrics page_impressions_paid _unique The number of times any content from your Page or about your Page entered a person’s screen through paid distribution such as an ad. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

61 Metrics page_impressions_ unique The number of times any content from your Page or about your Page entered a person’s screen. This includes posts, stories, check-ins, ads, social information from people who interact with your Page and more. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

62 Metrics page_impressions_viral The number of people who had any content from your Page or about your Page enter their screen through unpaid distribution. This includes posts, stories, check-ins, social information from people who interact with your Page and more. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

63 Metrics page_impressions_viral_ frequency_distribution The number of people your Page reached broken down by how many times people saw any content about your Page. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

64 Metrics page_impressions_viral_ unique The number of times any content from your Page or about your Page entered a person’s screen with social information attached. Social information displays when a person’s friend interacted with your Page, post or story. This includes when someone’s
friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

65 Metrics page_negative_feedback top countries of people who checked into your Place. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

66 Metrics page_negative_feedback_ by_type The number of people who took a negative action (e.g., un-liked or hid a post). [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

67 Metrics page_cta_clicks_logged_ in_by_country_unique The number of times people took a negative action broken down by type. (See possible types) [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

68 Metrics page_negative_feedback_ unique The number of times people took a negative action (e.g., un-liked or hid a post). [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

69 Metrics page_places_checkin_ mobile The number of people who checked into a place. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

70 Metrics page_places_checkin_ mobile_unique The number of times people checked into a place using mobile phones. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

71 Metrics page_places_checkin_ total The number of people who clicked on any of your content, by type. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

72 Metrics page_places_checkin_ total_unique The number of times people checked into a place. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

73 Metrics page_places_checkins_ by_age_gender The number of people who checked into a place using mobile phones.
74 Metrics page_places_checkins_ by_country top locales of people who checked into your Place.
75 Metrics page_places_checkins_ by_locale gender and age of people who checked in at your Place.
76 Metrics page_positive_feedback_ by_type The number of people who took a negative action broken down by type. (See possible types) [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

77 Metrics page_positive_feedback_ by_type_unique The number of times people took a positive action broken down by type. (See possible types) [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

78 Metric page_post_engagements The number of people who engaged with your Page. Engagement includes any click. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

79 Metrics page_tab_views_login_ top The number of users logged in to Facebook who saw tabs on your Page. (See possible types) [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

80 Metrics page_tab_views_login_ top_unique page tab views login top unique [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

81 Metrics page_tab_views_logout_ top The number of times users logged in to Facebook saw tabs on your Page. (See possible types) [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

82 Metrics page_total_actions The number of times users not logged in to Facebook saw tabs on your Page. (See possible types) [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

83 Metrics page_views_by_age_ gender_logged_in_ unique The number of people logged in to Facebook who have viewed your Page profile, broken down by the type of device.
84 Metrics page_views_by_ internal_referer_logged _in_unique The number of people logged in to Facebook who have viewed your Page’s profile, broken down by each tab. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

85 Metrics page_views_by_ profile_tab_logged_ in_unique The number of people who have viewed each Page profile tab. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

86 Metrics page_views_by_ profile_tab_total Top referrering external domains sending traffic to your Page. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

87 Metrics page_views_by_ referers_logged_in _unique The number of people logged in to Facebook who have viewed your Page profile, broken down by gender group. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

88 Metrics page_views_by_site_ logged_in_unique The number of people logged in to Facebook who have viewed your Page, broken down by the internal referer within Facebook. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

89 Metrics page_views_external_ referrals The number of people logged in to Facebook who have viewed the Page profile. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

90 Metrics page_views_logged _in_total The number of times a Page’s profile has been viewed by people not logged in to Facebook. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

91 Metrics page_views_logged _in_unique The number of times a Page’s profile has been viewed by people logged in to Facebook. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

92 Metrics page_views_logout The number of times a Page’s profile has been viewed by logged in and logged out people.
93 Metrics page_views_total Daily total post reactions of a page by type. [{“value”:0,”end_time”:

“2021-04-09T07:00:00+0000”}]

94 Metrics page_website_clicks _by_age_gender_ logged_in_unique Number of people who logged in to Facebook and clicked the goto website CTA button.
95 Metrics page_website_clicks _by_site_logged _in_unique Number of people who logged in to Facebook and clicked the goto website CTA button, broken down by city. [{“value”:{},”end_time”:

“2021-04-09T07:00:00+0000”}]

96 Metrics page_website_clicks_ logged_in_by_city_unique Number of people who logged in to Facebook and clicked the goto website CTA button, broken down by country.
97 Metrics page_website_clicks_ logged_in_by_country_unique Number of people who logged in to Facebook and clicked the goto website CTA button, broken down by age and gender group.
98 Metrics page_website_clicks_ logged_in_unique Number of people who logged in to Facebook and clicked the Get Directions button, broken down by www, mobile, api or other. [{“value”:0,”end_time”: “2021-04-

09T07:00:00+0000”}]

99 Dimension snapshot_dt Snapshot Date 2021/04/10
100 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb

50c269 4c14878f352013ca5b0c

997a777b454

101 Electrik.AI etl_org Organization Id ORG000097
102 Electrik.AI etl_project Project Id PR000154
103 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
104 Electrik.AI etl_create_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
105 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
106 Electrik.AI etl_flow_nm EAI Flow Code FL001282
107 Electrik.AI etl_flow_instance _id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension end_time End time 2021-11-29T08: 00:00+0000
2 Dimension page_id page id 283158445521185.00
3 Metrics page_posts_impressions The number of times your Page’s posts entered a person’s screen. Posts include statuses, photos, links, videos and more. [{“value”:32,”end_time”: “2021-11-29T08:00:00+0000”}]
4 Metrics page_posts_impressions_ frequency_distribution The number of people who saw your Page posts, broken down by how many times people saw your posts. [{“value”:{“1″:2,”2″:3,”4″:1,”5″:1,”6-10″:2},”end_time”:”2021-11-29T08:00:00+0000″}]
5 Metrics page_posts_impressions_ nonviral The number of times your Page’s posts entered a person’s screen. This does not include content created about your Page with social information attached. Social information displays when a person’s friend interacted with you Page or post. This
includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
6 Metrics page_posts_impressions_ nonviral_unique The number of people who had any posts by your Page enter their screen. This does not include content created about your Page with social information attached. As a form of organic distribution, social information displays when a person’s
friend interacted with you Page or post. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
7 Metrics page_posts_impressions_ organic The number of times your Page’s posts entered a person’s screen through unpaid distribution. [{“value”:32,”end_time”:”2021-11-29T08:00:00+0000″}]
8 Metrics page_posts_impressions_ organic_unique The number of people who had any of your Page’s posts enter their screen through unpaid distribution. [{“value”:9,”end_time”:”2021-11-29T08:00:00+0000″}]
9 Metrics page_posts_impressions_paid The number of times your Page’s posts entered a person’s screen through paid distribution such as an ad. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
10 Metrics page_posts_impressions_ paid_unique The number of people who had any of your Page’s posts enter their screen through paid distribution such as an ad. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
11 Metrics page_posts_impressions_ unique The number of people who had any of your Page’s posts enter their screen. Posts include statuses, photos, links, videos and more. [{“value”:9,”end_time”:”2021-11-29T08:00:00+0000″}]
12 Metrics page_posts_impressions_ viral The number of times your Page’s posts entered a person’s screen with social information attached. Social information displays when a person’s friend interacted with you Page or post. This includes when someone’s friend likes or follows your
Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:31,”end_time”:”2021-11-29T08:00:00+0000″}]
13 Metrics page_posts_impressions_ viral_unique The number of people who had any of your Page’s posts enter their screen with social information attached. As a form of organic distribution, social information displays when a person’s friend interacted with you Page or post. This includes
when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:9,”end_time”:”2021-11-29T08:00:00+0000″}]
14 Metrics page_posts_served_ impressions_organic_unique The number of people who were served your Page’s posts in their News Feed whether it entered their screen or not. Posts include statuses, photos, links, videos and more. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
15 Dimension snapshot_dt Snapshot Date 2021/11/30
16 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
17 Electrik.AI etl_org Organization Id ORG000097
18 Electrik.AI etl_project Project Id PR000154
19 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
20 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
21 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
22 Electrik.AI etl_flow_nm EAI Flow Code FL001282
23 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension end_time End time 2021-11-29T08:00:00+0000
2 Dimension page_id page id 283158445521185
3 Metrics page_video_complete_ views_30s The number of times your Page’s videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
4 Metrics page_video_complete_ views_30s_autoplayed The number of times your Page’s automatically played videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying
the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
5 Metrics page_video_complete_ views_30s_click_to_play The number of times your Page’s videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds, after people clicked play. During a single instance of a video playing, we’ll exclude any time spent
replaying the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
6 Metrics page_video_complete_ views_30s_organic The number of times your Page’s videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying
the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
7 Metrics page_video_complete_ views_30s_paid The number of times your Page’s promoted videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent
replaying the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
8 Metrics page_video_complete_ views_30s_repeat_views The number of times your Page’s videos replayed for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
9 Metrics page_video_complete_ views_30s_unique The number of people who viewed your Page’s videos for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
10 Metrics page_video_repeat_views The number of times your Page’s videos were replayed for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
11 Metrics page_video_view_time The total time, in milliseconds, people viewed your Page’s video. [{“value”:4672,”end_time”:”2021-11-29T08:00:00+0000″}]
12 Metrics page_video_views The number of times your Page’s videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
13 Metrics page_video_views_10s The number of times your Page’s videos played for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
14 Metrics page_video_views_ 10s_autoplayed The number of times your Page’s videos automatically played for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the
video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
15 Metrics page_video_views_ 10s_click_to_play The number of times your Page’s videos played for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds, after people clicked play. During a single instance of a video playing, we’ll exclude any time spent
replaying the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
16 Metrics page_video_views_ 10s_organic The number of times your Page’s videos played for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying
the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
17 Metrics page_video_views_ 10s_paid The number of times your Page’s promoted videos played for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent
replaying the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
18 Metrics page_video_views_ 10s_repeat The number of times your Page’s videos replayed for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
19 Metrics page_video_views_ 10s_unique The number of people who viewed your Page’s videos for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
20 Metrics page_video_views_ autoplayed The number of times your Page’s videos automatically played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the
video.
[{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
21 Metrics page_video_views_ by_paid_non_paid The number of times your Page’s videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, broken down by total, paid, and non-paid. During a single instance of a video playing, we’ll exclude
any time spent replaying the video.
[{“value”:{“total”:1,”unpaid”:1,”paid”:0}, “end_time”:”2021-11-29T08:00:00+0000″}]
22 Metrics page_video_views_ click_to_play The number of times your Page’s videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, after people clicked play. During a single instance of a video playing, we’ll exclude any time spent
replaying the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
23 Metrics page_video_views_ organic The number of times your Page’s videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying
the video.
[{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
24 Metrics page_video_views_ paid The number of times your Page’s promoted videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent
replaying the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
25 Metrics page_video_views_ unique The number of people who viewed your Page’s videos for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
26 Metrics post_video_view_time The total time, in milliseconds, your videos played, including videos played for less than 3 seconds and replays. Returns 0 for reshared videos. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
27 Metrics post_video_view_ time_by_region_id The total time, in milliseconds, your videos played for your Top 45 Locations, Region – Country. [{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
28 Metrics post_video_view_ time_organic The total time, in milliseconds, your videos played by organic reach. Returns 0 for reshared videos. [{“value”:{“total”:1,”unpaid”:1,”paid”:0}, “end_time”:”2021-11-29T08:00:00+0000″}]
29 Metrics post_video_views The number of times your videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
30 Metrics post_video_views_ 10s The number of times your videos played for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
31 Metrics post_video_views_ 10s_paid The number of times your promoted videos played for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent replaying
the video.
[{“value”:0,”end_time”:”2021-11-29T08:00:00+0000″}]
32 Metric post_video_views_ 60s_excludes_shorter The number of times your videos played for at least 60 seconds. This metric is counted only for videos that are 60 seconds or longer. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
33 Metrics post_video_views_ organic The number of times your videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying the video.
34 Metrics post_video_views_ paid The number of times your promoted videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent replaying
the video.
35 Metrics post_video_views_ unique The number of people who viewed your videos for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video.
36 Dimension snapshot_dt Snapshot Date 2021/11/30
37 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
38 Electrik.AI etl_org Organization Id ORG000097
39 Electrik.AI etl_project Project Id PR000154
40 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
41 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
42 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
43 Electrik.AI etl_flow_nm EAI Flow Code FL001282
44 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension page_id page id 136851279731545
2 Metrics post_clicks The number of times people clicked anywhere in your posts without generating a story. [{“value”:0}]
3 Metrics post_clicks_by

_ type

The number of times people clicked on anywhere in your posts without generating a story, by consumption type. [{“value”:{}}]
4 Metrics post_clicks_by_ type_unique The number of people who clicked anywhere in your post without generating a story, by consumption type. [{“value”:{}}]
5 Metrics post_clicks_unique The number of people who clicked anywhere in your post without generating a story. [{“value”:0}]
6 Metrics post_engaged_fan People who have liked your Page and engaged with your post. [{“value”:0}]
7 Metrics post_engaged_

users

The number of people who clicked anywhere in your posts. [{“value”:0}]
8 Dimension post_id post id 136851279731545_ 2186554151427904
9 Metrics post_impressions The number of times your Page’s post entered a person’s screen. Posts include statuses, photos, links, videos and more. [{“value”:25}]
10 Metrics post_impressions_ by_story_type The number of times this post was seen via a story published by a friend of the person viewing the post. [{“value”:{“other”:20}}]
11 Metrics post_impressions_ by_story_type_

unique

The number of people who saw your Page post in a story from a friend, by story type. [{“value”:{“other”:19}}]
12 Metrics post_impressions_

fan

The number of impressions for your Page post by people who have liked your Page. [{“value”:4}]
13 Metrics post_impressions_ fan_paid The number of impressions for your Page post by people who like your Page in an Ad or Sponsored Story. [{“value”:0}]
14 Metrics post_impressions_ fan_paid_unique The number of people who have like your Page and saw your Page post in an Ad or Sponsored Story. [{“value”:0}]
15 Metrics post_impressions_ fan_unique The number of people who have like your Page who saw your Page post. [{“value”:4}]
16 Metrics post_impressions_ nonviral The number of times your Page’s post entered a person’s screen. This does not include content created about your Page with social information attached. Social information displays when a person’s friend interacted with you Page or post. This
includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:5}]
17 Metrics post_impressions_ nonviral_unique The number of people who had your Page’s post enter their screen. This does not include content created about your Page with social information attached. As a form of organic distribution, social information displays when a person’s friend
interacted with you Page or post. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:5}]
18 Metrics post_impressions

_organic

The number of times your Page’s posts entered a person’s screen through unpaid distribution. [{“value”:25}]
19 Metrics post_impressions_ organic_unique The number of people who had your Page’s post enter their screen through unpaid distribution. [{“value”:24}]
20 Metrics post_impressions

_paid

The number of times your Page’s post entered a person’s screen through paid distribution such as an ad. [{“value”:0}]
21 Metrics post_impressions_ paid_unique The number of people who had your Page’s post enter their screen through paid distribution such as an ad. [{“value”:0}]
22 Metrics post_impressions

_unique

The number of people who had your Page’s post enter their screen. Posts include statuses, photos, links, videos and more. [{“value”:24}]
23 Metrics post_impressions

_viral

The number of times your Page’s post entered a person’s screen with social information attached. Social information displays when a person’s friend interacted with you Page or post. This includes when someone’s friend likes or follows your
Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:20}]
24 Metrics post_impressions_ viral_unique The number of people who had your Page’s post enter their screen with social information attached. As a form of organic distribution, social information displays when a person’s friend interacted with you Page or post. This includes when someone’s
friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:19}]
25 Metrics post_negative_

feedback

The number of times people took a negative action in your post (e.g. hid it). [{“value”:0}]
26 Metrics post_negative_ feedback_by_type The number of times people took a negative action in your post broken down by type. [{“value”:{}}]
27 Metrics post_negative_ feedback_by_type_ unique The number of people who took a negative action in your post broken down by type. [{“value”:{}}]
28 Metrics post_negative_

feedback_ unique

post negative feedback unique [{“value”:0}]
29 Metrics post_reactions_

anger_ total

Total “anger” reactions of a post. [{“value”:0}]
30 Metrics post_reactions_by

_type_ total

Total post reactions by type. [{“value”:{“like”:5}}]
31 Metrics post_reactions_

haha_ total

Total “haha” reactions of a post. [{“value”:0}]
32 Metric post_reactions_

like_ total

Total “like” reactions of a post. [{“value”:0}]
33 Metrics post_reactions_ love_total Total “love” reactions of a post. [{“value”:0}]
34 Metrics post_reactions_ sorry_total Total “sad” reactions of a post. [{“value”:0}]
35 Metrics post_reactions_ wow_total Total “wow” reactions of a post. [{“value”:0}]
36 Dimension snapshot_dt Snapshot Date 2021/05/01
37 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
38 Electrik.AI etl_org Organization Id ORG000097
39 Electrik.AI etl_project Project Id PR000154
40 Electrik.AI etl_create_utc_

dttm

Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
41 Electrik.AI etl_update_utc_

dttm

Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
42 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
43 Electrik.AI etl_flow_nm EAI Flow Code FL001282
44 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description  Sample Value
1 Dimension page_id page id 136851279731545
2 Metrics post_clicks The number of times people clicked anywhere in your posts without generating a story. [{“value”:0}]
3 Metrics post_clicks_by_type The number of times people clicked on anywhere in your posts without generating a story, by consumption type. [{“value”:{}}]
4 Metrics post_clicks_by_type_unique The number of people who clicked anywhere in your post without generating a story, by consumption type. [{“value”:{}}]
5 Metrics post_clicks_unique The number of people who clicked anywhere in your post without generating a story. [{“value”:0}]
6 Metrics post_engaged_fan People who have liked your Page and engaged with your post. [{“value”:0}]
7 Metrics post_engaged_users The number of people who clicked anywhere in your posts. [{“value”:0}]
8 Dimension post_id post id 136851279731545_2186554151427904
9 Metrics post_impressions The number of times your Page’s post entered a person’s screen. Posts include statuses, photos, links, videos and more. [{“value”:25}]
10 Metrics post_impressions_by_story_type The number of times this post was seen via a story published by a friend of the person viewing the post. [{“value”:{“other”:20}}]
11 Metrics post_impressions_by_story_type_unique The number of people who saw your Page post in a story from a friend, by story type. [{“value”:{“other”:19}}]
12 Metrics post_impressions_fan The number of impressions for your Page post by people who have liked your Page. [{“value”:4}]
13 Metrics post_impressions_fan_paid The number of impressions for your Page post by people who like your Page in an Ad or Sponsored Story. [{“value”:0}]
14 Metrics post_impressions_fan_paid_unique The number of people who have like your Page and saw your Page post in an Ad or Sponsored Story. [{“value”:0}]
15 Metrics post_impressions_fan_unique The number of people who have like your Page who saw your Page post. [{“value”:4}]
16 Metrics post_impressions_nonviral The number of times your Page’s post entered a person’s screen. This does not include content created about your Page with social information attached. Social information displays when a person’s friend interacted with you Page or post. This
includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:5}]
17 Metrics post_impressions_nonviral_unique The number of people who had your Page’s post enter their screen. This does not include content created about your Page with social information attached. As a form of organic distribution, social information displays when a person’s friend
interacted with you Page or post. This includes when someone’s friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:5}]
18 Metrics post_impressions_organic The number of times your Page’s posts entered a person’s screen through unpaid distribution. [{“value”:25}]
19 Metrics post_impressions_organic_unique The number of people who had your Page’s post enter their screen through unpaid distribution. [{“value”:24}]
20 Metrics post_impressions_paid The number of times your Page’s post entered a person’s screen through paid distribution such as an ad. [{“value”:0}]
21 Metrics post_impressions_paid_unique The number of people who had your Page’s post enter their screen through paid distribution such as an ad. [{“value”:0}]
22 Metrics post_impressions_unique The number of people who had your Page’s post enter their screen. Posts include statuses, photos, links, videos and more. [{“value”:24}]
23 Metrics post_impressions_viral The number of times your Page’s post entered a person’s screen with social information attached. Social information displays when a person’s friend interacted with you Page or post. This includes when someone’s friend likes or follows your
Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:20}]
24 Metrics post_impressions_viral_unique The number of people who had your Page’s post enter their screen with social information attached. As a form of organic distribution, social information displays when a person’s friend interacted with you Page or post. This includes when someone’s
friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page.
[{“value”:19}]
25 Metrics post_negative_feedback The number of times people took a negative action in your post (e.g. hid it). [{“value”:0}]
26 Metrics post_negative_feedback_by_type The number of times people took a negative action in your post broken down by type. [{“value”:{}}]
27 Metrics post_negative_feedback_by_type_unique The number of people who took a negative action in your post broken down by type. [{“value”:{}}]
28 Metrics post_negative_feedback_unique post negative feedback unique [{“value”:0}]
29 Metrics post_reactions_anger_total Total “anger” reactions of a post. [{“value”:0}]
30 Metrics post_reactions_by_type_total Total post reactions by type. [{“value”:{“like”:5}}]
31 Metrics post_reactions_haha_total Total “haha” reactions of a post. [{“value”:0}]
32 Metric post_reactions_like_total Total “like” reactions of a post. [{“value”:0}]
33 Metrics post_reactions_love_total Total “love” reactions of a post. [{“value”:0}]
34 Metrics post_reactions_sorry_total Total “sad” reactions of a post. [{“value”:0}]
35 Metrics post_reactions_wow_total Total “wow” reactions of a post. [{“value”:0}]
36 Dimension snapshot_dt Snapshot Date 2021/05/01
37 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
38 Electrik.AI etl_org Organization Id ORG000097
39 Electrik.AI etl_project Project Id PR000154
40 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
41 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
42 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
43 Electrik.AI etl_flow_nm EAI Flow Code FL001282
44 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196
Index Category Electrik.AI Column Name Description Sample Value
1 Dimension page_id page id 283158445521185
2 Dimension post_id post id 283158445521185_ 795874867582871
3 Metrics post_video_avg_ time_watched The average time, in milliseconds, people viewed your videos. Only available for videos created after August 25th 2016. Returns 0 for reshared videos. [{“value”:0}]
4 Metrics post_video_complete_ views_30s_autoplayed The number of times your Page’s automatically played videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying
the video.
[{“value”:0}]
5 Metrics post_video_complete_ views_30s_clicked_to_play The number of times your Page’s videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds, after people clicked play. During a single instance of a video playing, we’ll exclude any time spent
replaying the video.
[{“value”:0}]
6 Metrics post_video_complete_ views_30s_organic The number of times your Page’s videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying
the video.
[{“value”:0}]
7 Metrics post_video_complete_ views_30s_paid The number of times your Page’s promoted videos played for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent
replaying the video.
[{“value”:0}]
8 Metrics post_video_complete_ views_30s_unique The number of people who viewed your Page’s videos for at least 30 seconds, or for nearly their total length if they’re shorter than 30 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0}]
9 Metrics post_video_complete_ views_organic The number of times your videos played from the beginning to 95%, or more, of its length, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying the video. Returns 0 for reshared videos. [{“value”:0}]
10 Metrics post_video_complete_ views_organic_unique The number of people who viewed your videos from the beginning to 95%, or more, of its length, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying the video. Returns 0 for reshared videos. [{“value”:0}]
11 Metrics post_video_complete_ views_paid The number of times your promoted videos played from the beginning to 95%, or more, of its length. For each impression of a video, we’ll count video views separately and exclude any time spent replaying the video. Returns 0 for reshared videos. [{“value”:0}]
12 Metrics post_video_complete_ views_paid_unique The number of people who viewed your promoted videos from the beginning to 95%, or more, of its length. For each impression of a video, we’ll count video views separately and exclude any time spent replaying the video. [{“value”:0}]
13 Metrics post_video_length The length, in milliseconds, of a video post. [{“value”:0}]
14 Metrics post_video_retention_ graph The number of times your videos played at each interval as a percentage of all views. Videos are divided into 40 equal intervals. This metric does not count impressions while the video was live. Retention graphs may show more impressions later
in the video than at the beginning. People might start the video in the middle, skip ahead, save, and rewatch it from that point, or other similar behaviors.
[{“value”:{}}]
15 Metrics post_video_retention_ graph_autoplayed The number of times your videos automatically played at each interval as a percentage of all automatic views. Videos are divided into 40 equal intervals.This metric does not count impressions while the video was live. Retention graphs may
show more impressions later in the video than at the beginning. People might start the video in the middle, skip ahead, save, and rewatch it from that point, or other similar behaviors.
[{“value”:{}}]
16 Metrics post_video_retention_ graph_clicked_to_play The number of times your videos played at each interval as a percentage of all views, after people clicked play. Videos are divided into 40 equal intervals. This metric does not count impressions while the video was live. Retention graphs
may show more impressions later in the video than at the beginning. People might start the video in the middle, skip ahead, save, and rewatch it from that point, or other similar behaviors.
[{“value”:{}}]
17 Metrics post_video_view_ time ” The total time, in milliseconds, your videos played, including videos played for less than 3 seconds and replays. Returns 0 for reshared videos.” [{“value”:0}]
18 Metrics post_video_view_time_ by_age_bucket_and_ gender The total time, in milliseconds, your videos played for your Top Audiences, age and gender.
19 Metrics post_video_view_ time_by_country_id The total number of minutes your videos played for your Top 45 Locations; Country. [{“value”:{}}]
20 Metrics post_video_view_ time_by_distribution_type The total time, in milliseconds, your videos played by distribution type; page_owned and shared. [{“value”:{}}]
21 Metrics post_video_view_ time_by_region_id The total time, in milliseconds, your videos played for your Top 45 Locations, Region – Country. [{“value”:{}}]
22 Metrics post_video_view_ time_organic The total time, in milliseconds, your videos played by organic reach. Returns 0 for reshared videos. [{“value”:0}]
23 Metrics post_video_views The number of times your videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. This includes
live views
[{“value”:0}]
24 Metrics post_video_views_10s The number of times your videos played for at least 15 seconds, or for nearly their total length if they’re shorter than 10 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0}]
25 Metrics post_video_views_ 10s_autoplayed The number of times your videos played automatically for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0}]
26 Metrics post_video_views_ 10s_clicked_to_play The number of times your videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, after people clicked play. During a single instance of a video playing, we’ll exclude any time spent replaying
the video.
[{“value”:0}]
27 Metrics post_video_views_ 10s_organic The number of times your videos played for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying the
video.
[{“value”:0}]
28 Metrics post_video_views_ 10s_paid The number of times your promoted videos played for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent replaying
the video.
[{“value”:0}]
29 Metrics post_video_views_ 10s_sound_on The number of times your videos played with sound on for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0}]
30 Metrics post_video_views_ 10s_unique The number of people who viewed your videos for at least 10 seconds, or for nearly their total length if they’re shorter than 10 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent replaying
the vide
[{“value”:0}]
31 Metrics post_video_views_ 15s The number of times your videos played for at least 15 seconds, or for nearly their total length if they’re shorter than 10 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0}]
32 Metric post_video_views_ 60s_excludes_shorter The number of times your videos played for at least 60 seconds. This metric is counted only for videos that are 60 seconds or longer. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0}]
33 Metrics post_video_views_ autoplayed ” The number of times your videos automatically played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video.” [{“value”:0}]
34 Metrics post_video_views_ by_distribution_type The number of times your videos played by distribution type; page_owned and shared. [{“value”:{}}]
35 Metrics post_video_views_ clicked_to_play The number of times your videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, after people clicked play. During a single instance of a video playing, we’ll exclude any time spent replaying
the video.
[{“value”:0}]
36 Metrics post_video_views_ organic The number of times your videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0}]
37 Metrics post_video_views_ organic_unique The number of people who viewed your videos for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds, by organic reach. During a single instance of a video playing, we’ll exclude any time spent replaying the
video.
[{“value”:0}]
38 Metrics post_video_views_ paid ” The number of times your promoted videos played for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent replaying
the video.”
[{“value”:0}]
39 Metrics post_video_views_ paid_unique ” The number of people who viewed your promoted videos for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. For each impression of a video, we’ll count video views separately and exclude any time spent
replaying the video.”
[{“value”:0}]
40 Metrics post_video_views_ sound_on The number of times your videos played with sound on for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video. [{“value”:0}]
41 Metrics post_video_views_ unique “The number of people who viewed your videos for at least 3 seconds, or for nearly their total length if they’re shorter than 3 seconds. During a single instance of a video playing, we’ll exclude any time spent replaying the video.” [{“value”:0}]
42 Dimension snapshot_dt Snapshot Date 2021/11/30
43 Electrik.AI sha_id Hashed Primary Key 4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
44 Electrik.AI etl_org Organization Id ORG000097
45 Electrik.AI etl_project Project Id PR000154
46 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 2021-06-13 12:45:42 UTC
47 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 2021-06-13 12:45:42 UTC
48 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2021-06-13 12:45:42 UTC
49 Electrik.AI etl_flow_nm EAI Flow Code FL001282
50 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL00AD-20190910144445424196