Facebook Ads Dashboard

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

1. BloX 2.0
2. Variable Radius Pie Chart
3. Dimension Switcher
4. Jump to Dashboard
5. Remove Columns That Contain All Nulls From Pivot
6. Dashboard Padding and Shadow (Card View):

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’);
});

7. Widget Border Radius:

widget.on(‘ready’, ()=> {
$(element).parent().css(‘border-radius’, ’20px’);
$(element).parent().parent().css(‘border-radius’, ’20px’);
})