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 databases to export Facebook Page Insights. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
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.

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

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.

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. 

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