In the recent years, Facebook pages have become a leading tool for brand promotion and management. By defining and following meaningful KPI’s over the brand’s page, a social media manager can analyze their Facebook page’s efficiency based on KPI’s for brand awareness and consumers’ engagement over time.

The Sisense Facebook Connector Kit includes an ElastiCube and a dashboard that consists of periodical growth in KPI’s such as reach and followers for brand awareness, or post number engagement consumption for consumers’ engagement rates.

After downloading the Sisense Facebook Connector Kit, all you need to do is connect to your Facebook account and rebuild the ElastiCube to analyze brand awareness and user engagement in order to:

  • Increase page reach by XX% on a quarterly basis
  • Increase page followers by XX% on a quarterly basis
  • Increase users’ engagement consumption by XX% on a quarterly basis
  • Identify methods to increase users’ posts’ engagement rate.

This page describes how to use the Sisense Facebook Connector Kit and the meaning behind your data displayed in the dashboard.

Prerequisites

  • Download and install the Facebook Connector.
  • Download and Import the Facebook ElastiCube. See Importing ElastiCubes for more information.
  • Download and Import the Facebook Dashboard. See Importing Dashboards for more information.

Facebook ElastiCube

The Facebook ElastiCube contains tables imported from the Facebook API with pre-defined relations. To ensure that the Facebook dashboard works as expected, these tables and their relations should not be modified.

Base Table NameTable NamePeriod AggregationMetricsCalculation
InsightsByPaidStatusRAW_InsightsByPaidStatusDayPaid, Unpaid
InsightsByPaidStatusRAW_InsightsByPaidStatusDayPaid, Unpaid
InsightsByConsumptionTypeRAW_Post_ConsumptionLifetimeClicksToPlay, OtherClicks, LinkClicks, PhotoView, ButtonClicks PostConsumptionPostConsumption= ClicksToPlay+ OtherClicks+ LinkClicks+ PhotoView+ ButtonClicks
InsightsByLikeSourceTypeInsightsByLikeSourceTypeNoneAll Like sources
simpleinsightsPage_Fans_OvertimeLifetimePage_Likes
SimpleInsightsPostVideoViewsLifetimeVideoViewsOrganic
Comments_For_Page_PostsComments_For_Page_PostsNoneCommentsCount
Comments_For_Page_PostsComments_For_Page_PostsNoneLikes
InsightsByReactionTotalsInishtsByReacionTotalsLifetimeLike Love Wow Haha Sorry Anger TotalReactionsTotalReactions= Like+ Love+ Wow+ Haha+ Sorry+ Anger
InsightsByLikeSourceTypePage_Followers_SourceNoneFollowersBy Source
Raw_InsightsByPaidStatusRaw_InsightsByPaidStatus Page_Reach_Impressions NoneReach Impressions
PostsPostsNoneCommentsCount
PostsPostsNoneLikesCount
PostsPostsNoneSharesCount
PostsPostsNoneTotal Post ConsumptionLookup RAW_Post_Consumption/ PostConsumption
PostsPostsNoneVideoViewsLookup Lookup RAW_Post_Consumption/ PostConsumption/VideoViewsOrganic
PostsPostsNoneTotal Post ReactionsLookup InsightsByReactionTotals/TotalReactions
PagesPagesNoneLikes Checkins TalkingAboutCount WereHereCount

Custom Table – Date

As time is a leading dimension on this dashboard, a date dimension table has been created using the common selection method based on all insights and posts tables’ dates.

Connecting to Facebook

Included in the Sisense Facebook Connector Kit is an ElastiCube and a predefined dashboard. To display your data in the dashboard, you need to update the Facebook credentials for the ElastiCube by providing a connection string with your Facebook API username and password.

This section describes how to create the connection string and then update the ElastiCube with your connection string to connect to your data.

Note: This section assumes you have already imported the Sisense Facebook ElastiCube.

Creating a Connection String

After downloading and installing the Sisense Facebook Connector Kit, you need to provide your Facebook Developer credentials to connect to your data. These credentials are sent in a connection string you provide in the ElastiCube Manager, for example,

jdbc:facebook:OAuthClientId=11233774486;OAuthClientSecret=064c52447224fad;InitiateOAuth=GETANDREFRESH;Version=2.8;

CallbackURL=http://localhost/;Timeout=0;ThrottleSeconds=15;ThrottleMaxPercent=90;Other=RetryWaitTime=60000;MaximumRequestRetries=5;

To learn how to create a connection string to connect to Facebook’s API, see Connecting to Facebook.

Changing Connectivity Settings

Once you have created your connection string, you need to apply the string to your ElastiCube so Sisense can update the Facebook dashboard with your data.

To change the Facebook connectivity settings:

  1. In the ElastiCube Manager, select ElastiCube > Change Connectivity Settings…
  2. In the Change Source Provider Wizard, select Facebook.
  3. In the Datasource Connection String field, enter your Facebook connection string and choose the relevant date range.
  4. Click Connect to Server and then OK.

Analyzing Facebook

The Facebook dashboard included in the Sisense Facebook kit includes predefined widgets to help you quickly and easily gain insights from your Facebook data.

This section describes how to change your dashboard’s data source to your Facebook ElastiCube and then describes the business value that you can extract from each of the widgets from the dashboard included in this kit.

Note: This section assumes you have already imported the Sisense Facebook dashboard.

Changing Your Dashboard’s Data Source

To change your dashboard’s ElastiCube:

  1. In the top-left corner of your dashboard, click the ElastiCube link.
  2. Hover over Change Data Source and select the new data source.
  3. The source is added to your list. You now add new widgets from any of your data sources to the dashboard.
  4. Facebook DashboardThe Facebooks dashboard includes predefined widgets that provide information about how well your ads are performing.


Widgets

The Facebook dashboard includes the following widgets:

Followers

This widget describes the total amount of your followers and the growth in followers over a given period of time. Followers are the number of new people who have followed your page. This widget answers the question,

“How many people are following my page and how quickly is in growing”

Organic Reach

This widget describes how many people your page has reached organically and how well your reach is growing. Organic reach refers to how many people you can reach for free by posting to your page.

This widget answers the question,

“How far is your page reaching organically and is your organic reach growing?”

This is useful when determining your organic reach and if you need to invest in expanding your organic reach or invest more in sponsored reach.

Sponsored Reach

This widget describes how many people your page has reached through sponsored posts and how well your reach is growing. Sponsored Reach is the number of people who saw any of your Page posts as a result of ads

This widget answers the question,

“How far is your page reaching through sponsored posts and is your sponsored reach growing?”

If you have high amount of organic reach with steady growth in reach, you may wish to consider your investment in sponsored posts.

Page Reach

This widget describes your page reach over time. Page Reach Overtime is the number of people who saw any of your Page posts for a given period of time. This widget answers the question,

“What is my reach for a given period of time?”

Followers and Engagements over Time

This widget describes the number of times people liked your page versus consumption. Consumption includes, likes, comments and shares. This widget answers the question,

“Is my content still engaging users?”

Page Followers by Source

This widget describes where your page’s followers came from, ads, sponsored stories or somewhere else. This widget answers the question,

“Where am I attracting the most followers?”

Page Likes YoY

This widget describes how many page likes you received for a given time frame. Page Likes YOY is the number of times people liked your page year over year.

This widget answers the question,

“How many people liked my page and are my likes growing?”

# of Posts

This widget describes how many posts were published on the page over a given period of time including video, photo and links. This widget answers the question,

“How many posts have I published?”

This information is useful for seeing how many pages your posting and if these is a correlation between publishing posts and your organic reach. Fewer posts may lead to a decline in organic reach.

Engagement Consumption

This widget describes how many of your posts were consumed. Consumption includes Total Post Consumption, Total Post Reactions, and Total Video Views. This widget answers the question,

“How much activity is happening on my page?”

Growth in Engagement Consumption

This widget describes your growth in engagement consumption. When consumption is growing the indicator is green and when consumption is declining, the indicator is red.

This widget answers the question,

“How effective is my page’s content at engaging viewers?”

Average Engagement by Post Type

This widget describes how content type is the most engaging on your page. The average engagement is Likes, Comments, and Shares by post type for video, photo, and links. This widget answers the question,

“How cost-effective is my campaign?”

This is useful for establishing a rate for each consumption type so you can experiment with your content to discover which changes improves your consumption.

Posts Engagement by Publishing Time

This widget describes your page’s engagement for each day of the week.

This widget answers the question,

“What day of the week do people engage more?”

Organic Posts Published

This widget provides a detailed analysis of your posts, such as Post Clicks, Reactions comments and shares and video views.

This widget answers the question,

“What was the content of my posts and how engaging was it?”

Post Likes over Time

This widget describes how many posts you published and how liked they were. This widget answers the question,

“Is my content that is being consumed liked?”