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.

Step 4: 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.

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.

Step 8: 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.

Step 10: Click on Save button on the top.

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

What are the supported Data Destinations?

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

Google Big Query Data Destination-Elecrik.AI

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.

Step 4: Click on Add button to create a Facebook Page Insights 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. 

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.

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

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

Facebook Page Data Schema

Page Content Insights

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

Page Post Daily Insights

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

Page Video Daily Insights

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

Page Post Lifetime Insights

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

Page Video Lifetime Insights

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

Facebook Ads Insights Data Export

Freshdesk Data Export

What is Facebook?
How to add a Facebook Source in Electrik.AI?
What are the supported Data Destinations?
How to Export Facebook Page Insights?
Sample Facebook Page Insights?
Facebook Page Data Schema
Page Content Insights
Page Post Daily Insights
Page Video Daily Insights
Page Post Lifetime Insights
Page Video Lifetime Insights

Docs

Sources

Destinations