High Level Design
Overview
Facebook Ads is one of the behemoths of the advertising industry. As such it is often a part of executive reports from the marketing team. This dashboard provides an executive snapshot of marketing campaigns running on Facebook ads and provides Ad Set and Ad level information by utilizing the Sisense Jump To Dashboard plugin in conjunction with the BloX plugin.Goals
Create a direct line of communication to managers and executives about Facebook Ads metrics and understand the underlying costs and outcomes.
Objectives
The set of the objects below enables to reach out the goal above:
- Understand current topline marketing activity
- Understand current marketing focus and execution by seeing metrics in funnel buckets.
- Identify the most expensive and effective ad sets or ads
KPIs Architecture
Objectives |
KPIs |
Measures |
Data Source |
Understand current topline marketing activity & Identify the most expensive and effective ad sets or ads |
# of Active Campaigns |
Count(CampaignID) where effective status = Active |
campaign_history |
# of Campaigns (not paused) |
Count(CampaignID) |
campaign_history |
|
US Dollar Spend |
Sum(Spend) |
adinsight |
|
CPM, CPC, CTR, ROAS |
CPM ([Total SPEND] , [OBJECTIVE] )/ ( ( [Total IMPRESSIONS] , [OBJECTIVE] ) / 1000 ) Objective = Brand Awareness OR Post Engagement CPC ([Total SPEND] , [OBJECTIVE1] ) / ( [Total CLICKS] , [OBJECTIVE2]) Objective = Link Clicks CTR ([Total CLICKS] , [OBJECTIVE]) / ( [Total IMPRESSIONS] , [OBJECTIVE] ) Objective = Link Clicks ROAS ( [Total TOTAL_ACTION_VALUE] , [OBJECTIVE1] ) / ( [Total SPEND] , [OBJECTIVE1] ) Objective = Conversion |
adinsight |
|
Understand current marketing focus and execution by seeing metrics in funnel buckets.
|
Spend by Funnel |
Sum(Spend) |
adinsight |
# of Campaigns by Funnel |
Count(CampaignID) |
campaign_history |
Entities Relationship Diagram
Connectors Used
FiveTran Facebook Connector
Plugins & Scripts
- BloX 2.0
- Variable Radius Pie Chart
- Dimension Switcher
- Jump to Dashboard
- Remove Columns That Contain All Nulls From Pivot
- Dashboard Padding and Shadow (Card View):
- Widget Border Radius:
dashboard.on(‘widgetready’,function(d) {
$(‘.dashboard-layout-column’).css(‘background-color’, ‘#f0f0f0’);
$(‘.dashboard-layout’).css(‘background-color’, ‘#f0f0f0’);
$(‘.dashboard-layout-cell-horizontal-divider’).remove();
$(‘.dashboard-layout-subcell-vertical’).css(‘background-color’, ‘white’).css(‘box-shadow’, ‘4px 5px 12px #00000078’)
$(‘.dashboard-layout-subcell-host’).css(‘padding’, ’10’);
$(‘.dashboard-layout’).css(‘padding-right’, ’20px’).css(‘padding-left’, ’20px’);
});
widget.on(‘ready’, ()=> {
$(element).parent().css(‘border-radius’, ’20px’);
$(element).parent().parent().css(‘border-radius’, ’20px’);
})