Business dashboard template: FACEBOOK ADS

dashboard template for tableau on Facebook Facebook Facebook Ads cockpit

Providea workbookcontaining at least15 attributes

Geta ready-to-use,best-in-marketFACEBOOK ADS dashboard

Facebook Ads Home

Get a Home Page for your Facebook Ads dashboard

Facebook Ads Cockpit

Get an overview on the performance of your Facebook Ads campaigns

Facebook Ads Campaign Performance

Get an overview of the performance of each Facebook Ads camapign

Facebook Ads: 1 - Awareness

Visualize your efficiency in developing brand awareness on Facebook

15 required attributes

Period
Campaign Name
Ad Set Name
Ad Name
Cost
Impressions
Reach
Link Clicks
Page Likes
Post Shares
Post Comments
Post Reactions
Website Leads
Website Purchases
Website Purchases Conversion Value
...add your own attributes!

11 dashboard pages

Required Attributes

To get your Facebook Ads dashboard, you need to provide a Tableau workbook file with (at least) the following 5 attributes (the name of your attributes can differ):

Period Report Start Date (Date used for time-series analysis)
Campaign Name Campaign Name
Ad Set Name Ad Set Name
Ad Name Ad Name
Cost The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule
Impressions The number of times that your adverts were on-screen
Reach The number of people who saw your adverts at least once. Reach is different to impressions, which may include multiple views of your adverts by the same people.
Link Clicks The number of clicks on links within the ad that led to destinations or experiences, on or off Facebook
Page Likes The number of likes of your Facebook Page attributed to your ads
Post Shares The number of shares of your adverts. People can share your adverts or posts on their own or friends' Timelines, in groups and on their own Pages.
Post Comments The number of comments on your adverts
Post Reactions The number of reactions on your ads. The reactions button on an ad allows people to share different reactions to its content: like, love, haha, wow, sad or angry.
Website Leads The number of lead events tracked by the pixel on your website and attributed to your adverts
Website Purchases The number of purchase events tracked by the pixel on your website and attributed to your adverts
Website Purchases Conversion Value The total value of website purchases for products belonging to a catalogue segment used in a campaign

KPIs

Your Facebook Ads dashboard will contain 27 KPIs

Total CostThe estimated total amount of money you've spent on your campaign, ad set or ad during its schedule
Total People ReachedThe number of people who saw your adverts at least once. Reach is different to impressions, which may include multiple views of your adverts by the same people.
Cost per People ReachedAverage Cost per People Reach
Total ImpressionsThe number of times that your adverts were on-screen
CPM (Cost per 1'000 impressions)Average Cost per 1'000 impressions
CTR (Click-Through-Rate)Click Through Rate: Total Link Clicks / Total Impressions
Total Link ClicksThe number of clicks on links within the ad that led to destinations or experiences, on or off Facebook
CPC (Cost per Click)Average Cost per Click
Total Social InteractionsTotal Social Interactions: Page Likes, Post Shares, Post Comments and Post Reactions
CPA (Cost per Action)Average Cost per Social Interaction
Social Interaction per ImpressionAverage Social Interactions per Impression
Total Page LikesThe number of likes of your Facebook Page attributed to your ads
Total Post SharesThe number of shares of your adverts. People can share your adverts or posts on their own or friends' Timelines, in groups and on their own Pages.
Total Post CommentsThe number of comments on your adverts
Total Post ReactionsThe number of reactions on your ads. The reactions button on an ad allows people to share different reactions to its content: like, love, haha, wow, sad or angry.
Page Likes per ImpressionAverage Page Likes per Impression
Post Shares per ImpressionAverage Post Shares per Impression
Post Comments per ImpressionAverage Post Comments per Impression
Post Reactions per ImpressionAverage Post Reactions per Impression
Total Website LeadsThe number of lead events tracked by the pixel on your website and attributed to your adverts
CPL (Cost per Lead)Average Cost per Website Lead
LTR (Lead-Through-Rate)Lead Through Rate: Total Website Leads / Total Link Clicks
Total Website PurchasesThe number of purchase events tracked by the pixel on your website and attributed to your adverts
Total Website Purchases ValueThe total value of website purchases for products belonging to a catalogue segment used in a campaign
Avg Purchase ValueAverage Value per Purchase
Total MarginTotal Margin
ROI %Total Return on Investment

Dashboard Pages & Data Visualizations

Your Facebook Ads dashboard will contain 11 pages

Home

Facebook Ads Home

Get a Home Page for your Facebook Ads dashboard

Cockpit

Facebook Ads Cockpit

Get an overview on the performance of your Facebook Ads campaigns

Facebook Ads Top Performers

Get an instant understanding of your top Facebook Ads performers: current, mid and long term performance

Top 4 KPIs Trends (MTD/YTD)

Visualize how your Performance is evolving (Month-to-Date and Year-to-Date)

Campaign Performance

Facebook Ads Campaign Performance

Get an overview of the performance of each Facebook Ads camapign

Facebook Ads: 1 - Awareness

Visualize your efficiency in developing brand awareness on Facebook

Facebook Ads: 2 - Engagement

Visualize your efficiency in engaging with your target audience on Facebook

Facebook Ads: 3 - Conversion

Visualize your efficiency in converting your ads to actual business on Facebook

Facebook Ads Investment Efficiency

Visualize the efficiency of your investment on Facebook Ads

Historical Performance

Visualize how the performance of your Facebook Ads campaigns evolve across time

Behavioral Analytics

Facebook Ads Adhoc Analysis

Perform simple ad-hoc analysis on your Facebook Ads data set: analyze any of your KPIs across any dimension (trends, distribution and pareto analysis)

Creating your FACEBOOK ADS dashboard Step-by-Step

You want to get a clear understanding on your Facebook Ads results? You want to build a Tableau dashboard to better understand your Facebook Ads data?

Using LinPack-for-Tableau.com, you can generate an eye-catching, fit-for-purpose Tableau Dashboard on your Facebook Ads data in less than 5 minutes!

Facebook Ads dashboard Live Demo

1st STEP: Create the initial Tableau workbook file

Create a Tableau workbook in which you map your Facebook Ads data (whether it comes from: ERP, database, Excel, CSV file...)

You must retrieve at least the following attributes (it is ok if the names don't match, and it is better to add additional attributes to analyze):

Period Report Start Date (Date used for time-series analysis)
Campaign Name Campaign Name
Ad Set Name Ad Set Name
Ad Name Ad Name
Cost The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule
Impressions The number of times that your adverts were on-screen
Reach The number of people who saw your adverts at least once. Reach is different to impressions, which may include multiple views of your adverts by the same people.
Link Clicks The number of clicks on links within the ad that led to destinations or experiences, on or off Facebook
Page Likes The number of likes of your Facebook Page attributed to your ads
Post Shares The number of shares of your adverts. People can share your adverts or posts on their own or friends' Timelines, in groups and on their own Pages.
Post Comments The number of comments on your adverts
Post Reactions The number of reactions on your ads. The reactions button on an ad allows people to share different reactions to its content: like, love, haha, wow, sad or angry.
Website Leads The number of lead events tracked by the pixel on your website and attributed to your adverts
Website Purchases The number of purchase events tracked by the pixel on your website and attributed to your adverts
Website Purchases Conversion Value The total value of website purchases for products belonging to a catalogue segment used in a campaign

2nd STEP: Upload your Tableau workbook file

On LinPack-for-Tableau.com, select 'create dashboard from template: Facebook Ads' and upload your Tableau workbook (note: your data is NOT uploaded).

Collapse All Expand All

83 Dashboard Templates

Predefined (and customizable) KPIs
Predefined DataViz

▶ Transverse Functions

Sales

Marketing

Digital Marketing

Web Traffic

Digital Ads

Email Marketing Campaigns

Corporate Finance

Finance

Financial Statement

Actual vs Budget Follow-up

Profit & Loss

Income Statement

Income Statement (+Budget)

Balance Sheet

Balance Sheet (+Budget)

AR / AP

Accounts Receivable

Accounts Payable

Cash Flow

Bank Cash Flow

Bank Cash Flow (Trx)

Human Resources

Headcount

Headcount (basic)

Headcount (advanced)

Headcount (expert)

Expenses

HR Expenses

Salaries

Procurement

Purchasing

Spend Analytics

Purchasing

Contract Management

Procurement

Supply Chain & Manufacturing

Supply Chain

Shipment

Inventory Management

Stock Coverage (ABC-XYZ)

Inventory

Quality & Production

Scraps (qty & cost)

Scraps (cost-based)

Scraps (quantity-based)

General Services

Service Management

Service Desk

Call Center

Travel Management

Business Travel (Air)

Business Travel (Hotel)

Project Management

PMO

Risk & Compliance

Risk Register

Survey

Sentiment Analysis

Survey

NPS - Net Promoter Score

Questionnaires

Likert Scale

Single-Choice

Multiple-Choices

▶ Specific to a Business Sector

Healthcare

Stays & Patients

Patient Record + DRG

Medical Stays

Medical Visits

Visits - Wait Time

Finance (Bank, Wealth, FO...)

AuM Balance

AuM (NNM)

AuM (Flows)

AuM Profitability

AuM & Income (NNM)

AuM & Income (Flows)

CAL Balance

AuM, Lending Stock (NNM, NNL)

AuM, Lending Stock (Flows)

CAL Profitability

AuM, Lending Stock & Income (NNM, NNL)

AuM, Lending Stock & Income (Flows)

Wealth

Wealth Management

Trading

Loans

Insurance

Work Accidents

Claims

Fraudulent Claims

Retail

POS - Point of Sales

Non-for-Profit

Fundraising

Donations (advanced)

Donations (expert)

Education

Admission Process

Admissions

Telco

Telecommunications

Telco

Manufacturing

CEO Manufacturing

CEO Dashboard Manufacturing (demo)

Hospitality

Rooms Revenue

Hospitality Finance

▶ Specific to a Data Source

SAP

SAP Sales

SAP SD

SAP Finance

SAP AR

SAP Material

SAP MM

SAP Expenses

SAP Concur

Salesforce

Sales Cloud

Salesforce Sales Pipeline

Google

Google Analytics

Google Ads

Facebook

Facebook Ads

Twitter

Twitter Ads

ServiceNow

3rd STEP: Map your attributes

Map the attributes of your workbook on the attributes of the template.

The template attribute Your workbook attribute

Period Report Start Date

Campaign Name Campaign Name

Ad Set Name Ad Set Name

Ad Name Ad Name

Cost The estimated total amount of money you've spent on your campaign, ad set or ad during its schedule

Impressions The number of times that your adverts were on-screen

Reach The number of people who saw your adverts at least once. Reach is different to impressions, which may include multiple views of your adverts by the same people.

Link Clicks The number of clicks on links within the ad that led to destinations or experiences, on or off Facebook

Page Likes The number of likes of your Facebook Page attributed to your ads

Post Shares The number of shares of your adverts. People can share your adverts or posts on their own or friends' Timelines, in groups and on their own Pages.

Post Comments The number of comments on your adverts

Post Reactions The number of reactions on your ads. The reactions button on an ad allows people to share different reactions to its content: like, love, haha, wow, sad or angry.

Website Leads The number of lead events tracked by the pixel on your website and attributed to your adverts

Website Purchases The number of purchase events tracked by the pixel on your website and attributed to your adverts

Website Purchases Conversion Value The total value of website purchases for products belonging to a catalogue segment used in a campaign

Finally, click 'Confirm & Download'... and your Facebook Ads dashboard is already downloading :-)

Open the Tableau workbook file you received, it will automatically reconnect to your data sources.

Your Facebook Ads dashboard is now ready to be used or customized!

Create Facebook Ads dashboard