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

Relationship diagram- facebook ads dashboard

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

  8. Widget Border Radius:
  9. widget.on(‘ready’, ()=> {
    $(element).parent().css(‘border-radius’, ’20px’);
    $(element).parent().parent().css(‘border-radius’, ’20px’);
    })

Implementation
Kit

The following resources will enable you to design your dashboard and data model with sample data and then apply it to your own data. Note that you will need to have a previously installed version of Sisense (you can use the free trial version if you’re not a customer).

Sample data and dashboard examples (direct download)

Documentation