This post will show you how the performance of several Facebook pages of one account can be seen all in one klip.  Some of the metrics in this example are likes, impressions, engaged users.

In our pre-build klip gallery, you have access to download the “Facebook Engaged users and Page Impressions” kilp which displays engaged users and impression for 1 page. But what if you have several pages in your account and you want to see the total number of Engaged Users and Impressions summed up all in one klip!

Note: This method is for an account with max of 20 pages.

The below algorithm is shown to give you an idea of the whole process in a high level.

1. The klip requires the creation of 2 data sources:

One static data source, which pulls all existing Page and Page IDs of an account, and the other is a dynamic data source, which comes from FB insights and holds the page fans, page fan adds, impressions and page engaged users for a page. In the dynamic data source, we show moving time range (last 93 days) as of date parameter.

1. 1. You can use the below query to create the static data source;

https://graph.facebook.com/v2.10/me/accounts?fields=name,id,username&limit=1000

1. 2. You can use the below query to create the dynamic data source;

https://graph.facebook.com/{props.FB_PageID}/insights/page_fans,page_fan_adds,page_engaged_users,page_impressions?since={date.add(-93).format()}&until={date.today}

Note: FB_PageID is the variable name which should be defined in klip editor prior to creating the dynamic data source. For more information support.

      2. Build the klip;

The klip below is constructed of three main components: Drop down list, Engaged Users display and Page Impressions display.

2.1. Drop down to show time periods

 The time period is driven by 2 hidden user input controls that indicate the start and end of each time interval. Both start and end time should be in epoch format.

• You can use below formula to define the start of the time intervals

• You can use below formula to define the end of the time intervals:

As we want to compare our values to those of the previous period, we need to define the start and end time of previous period as well.

• You can use below formula to define the start of the previous time intervals:

• You can use below formula to define the end of the previous time intervals:

2.2.  Engaged users

• To calculate the Engaged users from a set number of different pages (6 pages, in this example), you need to use MAPFLAT function. This function assigns each item in values, one at a time to a variable ( In this example: variable name= FB_PageID) , then executes the formula using the variable name.

• Add a hidden data column, to apply selected dates defined by the User input controls.

• Filter out hidden data column to react to your start and end time period.

 2.3.  Impressions

The impressions display can be created using the same procedure as was used to create Engaged Users display.

 __________________________________________________

Hope that helps!

Shima