Docs

Destinations

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 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

Page Content Insights

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionend_timeEnd time2021-04-09T07:00:00+0000
2Metricspage_actions_post_ reactions_anger_totalDaily total post “sorry” reactions of a page.[{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
3Metricspage_actions_post_ reactions_haha_totalDaily total post “wow” reactions of a page.[{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
4Metricspage_actions_post_ reactions_like_totalThe 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”}]
5Metricspage_actions_post_ reactions_love_totalDaily total post “like” reactions of a page.[{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
6Metricspage_actions_post_ reactions_sorry_totalDaily total post “haha” reactions of a page.[{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
7Metricspage_actions_post_ reactions_totalDaily total post “anger” reactions of a page.[{“value”:{},”end_time”: “2021-04-09T07:00:00+0000”}]
8Metricspage_actions_post_ reactions_wow_totalDaily total post “love” reactions of a page.[{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
9Metricspage_call_phone_clicks_ by_age_gender_logged_ in_uniqueNumber of people who logged in to Facebook and clicked the Call Now button.
10Metricspage_call_phone_clicks_ by_site_logged_in_uniqueNumber 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”}]
11Metricspage_call_phone_clicks_ logged_in_by_city_uniqueNumber of people who logged in to Facebook and clicked the Call Now button, broken down by countries.
12Metricspage_call_phone_clicks_ logged_in_by_country_uniqueNumber of people who logged in to Facebook and clicked the Call Now button, broken down by age and
gender group.
13Metricspage_call_phone_clicks_ logged_in_uniqueNumber 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″}]
14Metricspage_consumptionsThe 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”}]
15Metricspage_consumptions_ by_consumption_typepage consumptions by consumption type[{“value”:{},”end_time”: “2021-04-09T07:00:00+0000”}]
16Metricspage_consumptions_by_ consumption_type_uniqueThe number of times people clicked on any of your content, by type.[{“value”:{},”end_time”: “2021-04-09T07:00:00+0000”}]
17Metricspage_consumptions_ uniqueThe number of times people clicked on any of your content.[{“value”:0,”end_time”: “2021-04-09T07:00:00+0000”}]
18Metricspage_cta_clicks_by_ age_gender_logged_in_uniqueNumber of people who are logged in to Facebook and clicked on the CTA button, broken down by www,
mobile, api or other.
19Metricspage_cta_clicks_by_ site_logged_in_uniqueUnique 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”}]
20Metricspage_cta_clicks_logged _in_by_city_uniqueNumber of people who are logged in to Facebook and clicked the Page CTA button, broken down by country.
21Metricspage_cta_clicks_logged _in_by_country_uniqueNumber of people who are logged in to Facebook and clicked the Page CTA button, broken down by age and
gender group.
22Metricspage_cta_clicks_ logged_in_totalThe 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”}]

23Metricspage_cta_clicks_ logged_in_uniqueTotal 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”}]

24Metricspage_engaged_usersNumber 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”}]

25Metricspage_fan_addsThe 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”}]

26Metricspage_fan_adds_ by_paid_non_ paid_uniqueThe 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″}]

27Metricspage_fan_adds_ uniqueThe number of new people who have liked your Page.[{“value”:0,”end_time”:

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

28Metricspage_fan_removesThe 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”}]

29Metricspage_fan_removes_ uniquepage fan removes unique[{“value”:0,”end_time”:

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

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

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

31Metricspage_fans_by_like_ sourceThe number of new people who have liked your Page.[{“value”:{},”end_time”:

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

32Metricpage_fans_by_like_ source_uniqueThis 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”}]

33Metricspage_fans_by_ unlike_sourcepage fans by unlike source[{“value”:{},”end_time”:

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

34Metricspage_fans_by_unlike_ source_uniquepage fans by unlike source unique[{“value”:{},”end_time”:

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

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

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

40Metricspage_fans_online_ per_dayThe number of your fans who saw any posts on Facebook on a given day, broken down by hour of day in
PST/PDT.
41Metricspage_get_directions_ clicks_by_age_ gender_logged_ in_uniqueNumber of people who logged in to Facebook and clicked the Get Directions button.
42Metricspage_get_directions_ clicks_by_site_ logged_in_uniqueNumber 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”}]

43Metricspage_get_directions_ clicks_logged_in_ by_city_uniqueNumber of people who logged in to Facebook and clicked the Get Directions button, broken down by
country.
44Metricspage_get_directions_ clicks_logged_in_ by_country_uniqueNumber of people who logged in to Facebook and clicked the Get Directions button, broken down by age and
gender group.
45Metricspage_get_directions_ clicks_logged_in_ uniqueThe 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”}]

46Dimensionpage_idpage id1.03873E+14
47Metricspage_impressionsThe 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”}]

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

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

51Metricspage_impressions_by_ locale_uniqueThe number of people who have seen any content associated with your Page by country.
52Metricspage_impressions_by_ story_typeThe 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”}]

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

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

54Metricspage_impressions_ frequency_distributionThe 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”}]

55Metricspage_impressions_ nonviralThe 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”}]

56Metricspage_impressions_ nonviral_uniqueThe 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”}]

57Metricspage_impressions_ organicThe 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”}]

58Metricspage_impressions_ organic_uniqueThe 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”}]

59Metricspage_impressions_paidThe 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”}]

60Metricspage_impressions_paid _uniqueThe 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”}]

61Metricspage_impressions_ uniqueThe 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”}]

62Metricspage_impressions_viralThe 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”}]

63Metricspage_impressions_viral_ frequency_distributionThe 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”}]

64Metricspage_impressions_viral_ uniqueThe 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”}]

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

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

66Metricspage_negative_feedback_ by_typeThe 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”}]

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

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

68Metricspage_negative_feedback_ uniqueThe 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”}]

69Metricspage_places_checkin_ mobileThe number of people who checked into a place.[{“value”:0,”end_time”:

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

70Metricspage_places_checkin_ mobile_uniqueThe number of times people checked into a place using mobile phones.[{“value”:0,”end_time”:

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

71Metricspage_places_checkin_ totalThe number of people who clicked on any of your content, by type.[{“value”:0,”end_time”:

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

72Metricspage_places_checkin_ total_uniqueThe number of times people checked into a place.[{“value”:0,”end_time”:

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

73Metricspage_places_checkins_ by_age_genderThe number of people who checked into a place using mobile phones.
74Metricspage_places_checkins_ by_countrytop locales of people who checked into your Place.
75Metricspage_places_checkins_ by_localegender and age of people who checked in at your Place.
76Metricspage_positive_feedback_ by_typeThe number of people who took a negative action broken down by type. (See possible types)[{“value”:{},”end_time”:

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

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

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

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

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

79Metricspage_tab_views_login_ topThe 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”}]

80Metricspage_tab_views_login_ top_uniquepage tab views login top unique[{“value”:{},”end_time”:

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

81Metricspage_tab_views_logout_ topThe 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”}]

82Metricspage_total_actionsThe 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”}]

83Metricspage_views_by_age_ gender_logged_in_ uniqueThe number of people logged in to Facebook who have viewed your Page profile, broken down by the type of
device.
84Metricspage_views_by_ internal_referer_logged _in_uniqueThe 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”}]

85Metricspage_views_by_ profile_tab_logged_ in_uniqueThe number of people who have viewed each Page profile tab.[{“value”:{},”end_time”:

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

86Metricspage_views_by_ profile_tab_totalTop referrering external domains sending traffic to your Page.[{“value”:{},”end_time”:

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

87Metricspage_views_by_ referers_logged_in _uniqueThe 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”}]

88Metricspage_views_by_site_ logged_in_uniqueThe 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”}]

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

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

90Metricspage_views_logged _in_totalThe 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”}]

91Metricspage_views_logged _in_uniqueThe 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”}]

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

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

94Metricspage_website_clicks _by_age_gender_ logged_in_uniqueNumber of people who logged in to Facebook and clicked the goto website CTA button.
95Metricspage_website_clicks _by_site_logged _in_uniqueNumber 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”}]

96Metricspage_website_clicks_ logged_in_by_city_uniqueNumber of people who logged in to Facebook and clicked the goto website CTA button, broken down by
country.
97Metricspage_website_clicks_ logged_in_by_country_uniqueNumber of people who logged in to Facebook and clicked the goto website CTA button, broken down by age
and gender group.
98Metricspage_website_clicks_ logged_in_uniqueNumber 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”}]

99Dimensionsnapshot_dtSnapshot Date2021/04/10
100Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb

50c269 4c14878f352013ca5b0c

997a777b454

101Electrik.AIetl_orgOrganization IdORG000097
102Electrik.AIetl_projectProject IdPR000154
103Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
104Electrik.AIetl_create_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
105Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
106Electrik.AIetl_flow_nmEAI Flow CodeFL001282
107Electrik.AIetl_flow_instance _idEAI Flow Execution Instance IdFL00AD-20190910144445424196

Page Post Daily Insights

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionend_timeEnd time2021-11-29T08: 00:00+0000
2Dimensionpage_idpage id283158445521185.00
3Metricspage_posts_impressionsThe 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”}]
4Metricspage_posts_impressions_ frequency_distributionThe 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″}]
5Metricspage_posts_impressions_ nonviralThe 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″}]
6Metricspage_posts_impressions_ nonviral_uniqueThe 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″}]
7Metricspage_posts_impressions_ organicThe 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″}]
8Metricspage_posts_impressions_ organic_uniqueThe 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″}]
9Metricspage_posts_impressions_paidThe 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″}]
10Metricspage_posts_impressions_ paid_uniqueThe 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″}]
11Metricspage_posts_impressions_ uniqueThe 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″}]
12Metricspage_posts_impressions_ viralThe 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″}]
13Metricspage_posts_impressions_ viral_uniqueThe 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″}]
14Metricspage_posts_served_ impressions_organic_uniqueThe 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″}]
15Dimensionsnapshot_dtSnapshot Date2021/11/30
16Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
17Electrik.AIetl_orgOrganization IdORG000097
18Electrik.AIetl_projectProject IdPR000154
19Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
20Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
21Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
22Electrik.AIetl_flow_nmEAI Flow CodeFL001282
23Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196

Page Video Daily Insights

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionend_timeEnd time2021-11-29T08:00:00+0000
2Dimensionpage_idpage id283158445521185
3Metricspage_video_complete_ views_30sThe 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″}]
4Metricspage_video_complete_ views_30s_autoplayedThe 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″}]
5Metricspage_video_complete_ views_30s_click_to_playThe 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″}]
6Metricspage_video_complete_ views_30s_organicThe 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″}]
7Metricspage_video_complete_ views_30s_paidThe 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″}]
8Metricspage_video_complete_ views_30s_repeat_viewsThe 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″}]
9Metricspage_video_complete_ views_30s_uniqueThe 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″}]
10Metricspage_video_repeat_viewsThe 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″}]
11Metricspage_video_view_timeThe total time, in milliseconds, people viewed your Page’s video.[{“value”:4672,”end_time”:”2021-11-29T08:00:00+0000″}]
12Metricspage_video_viewsThe 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″}]
13Metricspage_video_views_10sThe 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″}]
14Metricspage_video_views_ 10s_autoplayedThe 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″}]
15Metricspage_video_views_ 10s_click_to_playThe 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″}]
16Metricspage_video_views_ 10s_organicThe 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″}]
17Metricspage_video_views_ 10s_paidThe 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″}]
18Metricspage_video_views_ 10s_repeatThe 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″}]
19Metricspage_video_views_ 10s_uniqueThe 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″}]
20Metricspage_video_views_ autoplayedThe 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″}]
21Metricspage_video_views_ by_paid_non_paidThe 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″}]
22Metricspage_video_views_ click_to_playThe 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″}]
23Metricspage_video_views_ organicThe 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″}]
24Metricspage_video_views_ paidThe 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″}]
25Metricspage_video_views_ uniqueThe 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″}]
26Metricspost_video_view_timeThe 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″}]
27Metricspost_video_view_ time_by_region_idThe total time, in milliseconds, your videos played for your Top 45 Locations, Region – Country.[{“value”:1,”end_time”:”2021-11-29T08:00:00+0000″}]
28Metricspost_video_view_ time_organicThe 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″}]
29Metricspost_video_viewsThe 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″}]
30Metricspost_video_views_ 10sThe 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″}]
31Metricspost_video_views_ 10s_paidThe 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″}]
32Metricpost_video_views_ 60s_excludes_shorterThe 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″}]
33Metricspost_video_views_ organicThe 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.
34Metricspost_video_views_ paidThe 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.
35Metricspost_video_views_ uniqueThe 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.
36Dimensionsnapshot_dtSnapshot Date2021/11/30
37Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
38Electrik.AIetl_orgOrganization IdORG000097
39Electrik.AIetl_projectProject IdPR000154
40Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
41Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
42Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
43Electrik.AIetl_flow_nmEAI Flow CodeFL001282
44Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196

Page Post Lifetime Insights

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionpage_idpage id136851279731545
2Metricspost_clicksThe number of times people clicked anywhere in your posts without generating a story.[{“value”:0}]
3Metricspost_clicks_by

_ type

The number of times people clicked on anywhere in your posts without generating a story, by consumption type.[{“value”:{}}]
4Metricspost_clicks_by_ type_uniqueThe number of people who clicked anywhere in your post without generating a story, by consumption type.[{“value”:{}}]
5Metricspost_clicks_uniqueThe number of people who clicked anywhere in your post without generating a story.[{“value”:0}]
6Metricspost_engaged_fanPeople who have liked your Page and engaged with your post.[{“value”:0}]
7Metricspost_engaged_

users

The number of people who clicked anywhere in your posts.[{“value”:0}]
8Dimensionpost_idpost id136851279731545_ 2186554151427904
9Metricspost_impressionsThe number of times your Page’s post entered a person’s screen. Posts include statuses, photos, links, videos and more.[{“value”:25}]
10Metricspost_impressions_ by_story_typeThe number of times this post was seen via a story published by a friend of the person viewing the post.[{“value”:{“other”:20}}]
11Metricspost_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}}]
12Metricspost_impressions_

fan

The number of impressions for your Page post by people who have liked your Page.[{“value”:4}]
13Metricspost_impressions_ fan_paidThe number of impressions for your Page post by people who like your Page in an Ad or Sponsored Story.[{“value”:0}]
14Metricspost_impressions_ fan_paid_uniqueThe number of people who have like your Page and saw your Page post in an Ad or Sponsored Story.[{“value”:0}]
15Metricspost_impressions_ fan_uniqueThe number of people who have like your Page who saw your Page post.[{“value”:4}]
16Metricspost_impressions_ nonviralThe 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}]
17Metricspost_impressions_ nonviral_uniqueThe 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}]
18Metricspost_impressions

_organic

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

_paid

The number of times your Page’s post entered a person’s screen through paid distribution such as an ad.[{“value”:0}]
21Metricspost_impressions_ paid_uniqueThe number of people who had your Page’s post enter their screen through paid distribution such as an ad.[{“value”:0}]
22Metricspost_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}]
23Metricspost_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}]
24Metricspost_impressions_ viral_uniqueThe 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}]
25Metricspost_negative_

feedback

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

feedback_ unique

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

anger_ total

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

_type_ total

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

haha_ total

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

like_ total

Total “like” reactions of a post.[{“value”:0}]
33Metricspost_reactions_ love_totalTotal “love” reactions of a post.[{“value”:0}]
34Metricspost_reactions_ sorry_totalTotal “sad” reactions of a post.[{“value”:0}]
35Metricspost_reactions_ wow_totalTotal “wow” reactions of a post.[{“value”:0}]
36Dimensionsnapshot_dtSnapshot Date2021/05/01
37Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
38Electrik.AIetl_orgOrganization IdORG000097
39Electrik.AIetl_projectProject IdPR000154
40Electrik.AIetl_create_utc_

dttm

Record loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
41Electrik.AIetl_update_utc_

dttm

Record Update Timestamp in UTC2021-06-13 12:45:42 UTC
42Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
43Electrik.AIetl_flow_nmEAI Flow CodeFL001282
44Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column Name Description Sample Value
1Dimensionpage_idpage id136851279731545
2Metricspost_clicksThe number of times people clicked anywhere in your posts without generating a story.[{“value”:0}]
3Metricspost_clicks_by_typeThe number of times people clicked on anywhere in your posts without generating a story, by consumption type.[{“value”:{}}]
4Metricspost_clicks_by_type_uniqueThe number of people who clicked anywhere in your post without generating a story, by consumption type.[{“value”:{}}]
5Metricspost_clicks_uniqueThe number of people who clicked anywhere in your post without generating a story.[{“value”:0}]
6Metricspost_engaged_fanPeople who have liked your Page and engaged with your post.[{“value”:0}]
7Metricspost_engaged_usersThe number of people who clicked anywhere in your posts.[{“value”:0}]
8Dimensionpost_idpost id136851279731545_2186554151427904
9Metricspost_impressionsThe number of times your Page’s post entered a person’s screen. Posts include statuses, photos, links, videos and more.[{“value”:25}]
10Metricspost_impressions_by_story_typeThe number of times this post was seen via a story published by a friend of the person viewing the post.[{“value”:{“other”:20}}]
11Metricspost_impressions_by_story_type_uniqueThe number of people who saw your Page post in a story from a friend, by story type.[{“value”:{“other”:19}}]
12Metricspost_impressions_fanThe number of impressions for your Page post by people who have liked your Page.[{“value”:4}]
13Metricspost_impressions_fan_paidThe number of impressions for your Page post by people who like your Page in an Ad or Sponsored Story.[{“value”:0}]
14Metricspost_impressions_fan_paid_uniqueThe number of people who have like your Page and saw your Page post in an Ad or Sponsored Story.[{“value”:0}]
15Metricspost_impressions_fan_uniqueThe number of people who have like your Page who saw your Page post.[{“value”:4}]
16Metricspost_impressions_nonviralThe 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}]
17Metricspost_impressions_nonviral_uniqueThe 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}]
18Metricspost_impressions_organicThe number of times your Page’s posts entered a person’s screen through unpaid distribution.[{“value”:25}]
19Metricspost_impressions_organic_uniqueThe number of people who had your Page’s post enter their screen through unpaid distribution.[{“value”:24}]
20Metricspost_impressions_paidThe number of times your Page’s post entered a person’s screen through paid distribution such as an ad.[{“value”:0}]
21Metricspost_impressions_paid_uniqueThe number of people who had your Page’s post enter their screen through paid distribution such as an ad.[{“value”:0}]
22Metricspost_impressions_uniqueThe number of people who had your Page’s post enter their screen. Posts include statuses, photos, links, videos and more.[{“value”:24}]
23Metricspost_impressions_viralThe 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}]
24Metricspost_impressions_viral_uniqueThe 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}]
25Metricspost_negative_feedbackThe number of times people took a negative action in your post (e.g. hid it).[{“value”:0}]
26Metricspost_negative_feedback_by_typeThe number of times people took a negative action in your post broken down by type.[{“value”:{}}]
27Metricspost_negative_feedback_by_type_uniqueThe number of people who took a negative action in your post broken down by type.[{“value”:{}}]
28Metricspost_negative_feedback_uniquepost negative feedback unique[{“value”:0}]
29Metricspost_reactions_anger_totalTotal “anger” reactions of a post.[{“value”:0}]
30Metricspost_reactions_by_type_totalTotal post reactions by type.[{“value”:{“like”:5}}]
31Metricspost_reactions_haha_totalTotal “haha” reactions of a post.[{“value”:0}]
32Metricpost_reactions_like_totalTotal “like” reactions of a post.[{“value”:0}]
33Metricspost_reactions_love_totalTotal “love” reactions of a post.[{“value”:0}]
34Metricspost_reactions_sorry_totalTotal “sad” reactions of a post.[{“value”:0}]
35Metricspost_reactions_wow_totalTotal “wow” reactions of a post.[{“value”:0}]
36Dimensionsnapshot_dtSnapshot Date2021/05/01
37Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
38Electrik.AIetl_orgOrganization IdORG000097
39Electrik.AIetl_projectProject IdPR000154
40Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
41Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
42Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
43Electrik.AIetl_flow_nmEAI Flow CodeFL001282
44Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196

Page Video Lifetime Insights

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1Dimensionpage_idpage id283158445521185
2Dimensionpost_idpost id283158445521185_ 795874867582871
3Metricspost_video_avg_ time_watchedThe average time, in milliseconds, people viewed your videos. Only available for videos created after August 25th 2016. Returns 0 for reshared videos.[{“value”:0}]
4Metricspost_video_complete_ views_30s_autoplayedThe 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}]
5Metricspost_video_complete_ views_30s_clicked_to_playThe 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}]
6Metricspost_video_complete_ views_30s_organicThe 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}]
7Metricspost_video_complete_ views_30s_paidThe 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}]
8Metricspost_video_complete_ views_30s_uniqueThe 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}]
9Metricspost_video_complete_ views_organicThe 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}]
10Metricspost_video_complete_ views_organic_uniqueThe 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}]
11Metricspost_video_complete_ views_paidThe 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}]
12Metricspost_video_complete_ views_paid_uniqueThe 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}]
13Metricspost_video_lengthThe length, in milliseconds, of a video post.[{“value”:0}]
14Metricspost_video_retention_ graphThe 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”:{}}]
15Metricspost_video_retention_ graph_autoplayedThe 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”:{}}]
16Metricspost_video_retention_ graph_clicked_to_playThe 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”:{}}]
17Metricspost_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}]
18Metricspost_video_view_time_ by_age_bucket_and_ genderThe total time, in milliseconds, your videos played for your Top Audiences, age and gender.
19Metricspost_video_view_ time_by_country_idThe total number of minutes your videos played for your Top 45 Locations; Country.[{“value”:{}}]
20Metricspost_video_view_ time_by_distribution_typeThe total time, in milliseconds, your videos played by distribution type; page_owned and shared.[{“value”:{}}]
21Metricspost_video_view_ time_by_region_idThe total time, in milliseconds, your videos played for your Top 45 Locations, Region – Country.[{“value”:{}}]
22Metricspost_video_view_ time_organicThe total time, in milliseconds, your videos played by organic reach. Returns 0 for reshared videos.[{“value”:0}]
23Metricspost_video_viewsThe 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}]
24Metricspost_video_views_10sThe 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}]
25Metricspost_video_views_ 10s_autoplayedThe 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}]
26Metricspost_video_views_ 10s_clicked_to_playThe 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}]
27Metricspost_video_views_ 10s_organicThe 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}]
28Metricspost_video_views_ 10s_paidThe 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}]
29Metricspost_video_views_ 10s_sound_onThe 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}]
30Metricspost_video_views_ 10s_uniqueThe 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}]
31Metricspost_video_views_ 15sThe 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}]
32Metricpost_video_views_ 60s_excludes_shorterThe 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}]
33Metricspost_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}]
34Metricspost_video_views_ by_distribution_typeThe number of times your videos played by distribution type; page_owned and shared.[{“value”:{}}]
35Metricspost_video_views_ clicked_to_playThe 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}]
36Metricspost_video_views_ organicThe 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}]
37Metricspost_video_views_ organic_uniqueThe 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}]
38Metricspost_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}]
39Metricspost_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}]
40Metricspost_video_views_ sound_onThe 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}]
41Metricspost_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}]
42Dimensionsnapshot_dtSnapshot Date2021/11/30
43Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
44Electrik.AIetl_orgOrganization IdORG000097
45Electrik.AIetl_projectProject IdPR000154
46Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
47Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
48Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
49Electrik.AIetl_flow_nmEAI Flow CodeFL001282
50Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
Facebook Ads Insights Data Export
Freshdesk Data Export

On this page

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