High Level Design
Overview
In 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 the efficiency of this tool, based on KPI's for brand awareness and consumers' engagement over time. This dashboard consists of periodical growth in KPI's such as reach and followers for brand awareness, or post number engagement consumption for consumers' engagement rates.Goals
The goal of this dashboard is to provide an understanding of the key statistics and insights about a brand Facebook page so that managers could formulate strategies to increase brand awareness and user engagement on Facebook.
Objectives
- Identify methods to increase posts’ engagement rate.
- Increase page reach by XX% on a quarterly basis.
- Increase users’ engagement consumption by XX% on a quarterly basis.
- Increase page followers by XX% on a quarterly basis.
KPIs Architecture
|
Objectives |
KPIs |
Measures |
Data Source |
|
Identify methods to increase posts’ engagement rate. |
Top Posts: Number of Likes, Organic Impressions, and Organic Reach |
Sum(LikesCount) Sum(ImpressionsOrganic) Sum(ReachOrganic) |
FactPosts |
|
Average Likes per Post |
Avg(LikesCount) |
FactPosts |
|
|
Average Number of Post per Day |
Count(Id) / Count(Days) |
FactPosts |
|
|
Average Number of Likes by Day of the Week and Time of the Day |
Avg(Likes Count) |
FactPosts |
|
|
Increase page reach by XX% on a quarterly basis. |
Daily Snapshots of Page Impressions and Reach by Type (Organic, Paid, Viral)
|
Sum(Value) |
FactPageImpressions |
|
Daily, Weekly, Monthly Page Reach by Type (Organic, Paid, Viral) over Time |
Sum(Value) |
FactPageImpressions |
|
|
Increase users’ engagement consumption by XX% on a quarterly basis.
|
Engagement Rate By Consumption Type and Post Type |
Sum(LikesCount) / Count(Fans) Sum(CommentsCount) / Count(Fans) Sum(SharesCount) / Count(Fans) |
FactPosts FactPageFans |
|
Increase page followers by XX% on a quarterly basis. |
Current Number of Fans |
Sum(Value) |
FactPageFans |
|
New Fans over Time |
Sum(Value) |
FactPageFans |
|
|
Loss Fans over Time |
Sum(Value) |
FactPageFans |
|
|
Number of Fans by Gender and Age Group |
Sum(Value) |
FactPageFansByGenderAgeGroup |
|
|
Number of Fans by Country |
Sum(Value) |
FactPageFansByCountry |
Entities Relationship Diagram
Connectors Used
FiveTran Facebook Connector
Plugins & Scripts
Data Connectors
