# Looker Studio: Facebook Ads Dashboard

> A Looker Studio dashboard rolling up Facebook ad spend, revenue, ROAS and profit margin across a 9-month window.

Section: Looker Studio

Page: https://mburhan.com/case/looker-studio-facebook-ads

## 01. Project Overview

This dashboard is part of a larger multi-channel paid media reporting setup. It provides a dedicated view of Facebook advertising performance, allowing marketing and finance teams to review campaign-related spending, revenue, and performance indicators in one place.

### Paid Media Reporting

Part of a larger multi-channel Looker Studio report, this page rolls up spend, revenue and profit for Facebook campaigns specifically, alongside a daily revenue-vs-spend trend.

- $3.94M: Facebook spend (9 mo.)
- $3.99M: Facebook revenue
- 1.01: Facebook ROAS
- 27,184: Orders

The dashboard runs on Looker Studio so paid media and finance read from the same live numbers instead of a separate export from Meta.

## 02. The Challenge

Facebook advertising performance involves several interconnected metrics. Reviewing spend, revenue, purchases, orders, ROAS, and profit margin separately makes it harder to understand overall performance across a reporting period.

A consolidated dashboard helps make these indicators easier to review and compare.

## 03. The Solution

A dedicated Facebook Ads overview was created in Looker Studio, combining key financial and performance metrics with a revenue-versus-spend trend chart.

The dashboard includes:

- **Spend and Revenue:** Compare advertising costs with reported revenue.
- **Profit and Profit Margin:** Review the displayed profitability metrics.
- **ROAS:** Monitor return on advertising spend.
- **Purchases and Orders:** Track the conversion and order-volume figures shown in the report.
- **CPP:** Review cost per purchase.
- **Hook Rate:** Monitor the displayed creative-engagement indicator.
- **Date Filtering:** Review performance across a selected period.

## 04. Dashboard Overview

The dashboard presents high-level KPIs at the top and a revenue-versus-spend chart below. This makes it easier to scan the main figures and observe how spending and revenue move over time.

Image: Facebook performance overview across a 9-month window: spend, revenue, ROAS and profit margin alongside a daily revenue-vs-spend trend. (https://mburhan.com/case-content/ad-performance-dashboards/image3.png)

**Dashboard highlights:**

- Facebook spend: $3.94M
- Facebook revenue: $3.99M
- ROAS: 1.01
- Orders: 27,184
- Profit: -$1.03M
- Profit margin: 1.21%

*These figures are reproduced from the supplied dashboard screenshot. The displayed profit and profit-margin figures may require reconciliation before being used for financial decisions.*

## 05. Technology and Integration

- **Looker Studio:** Dashboard visualisation and reporting.
- **Meta Ads:** Facebook advertising performance data.

The report provides a dedicated Facebook performance view within the wider multi-channel reporting environment.

## 06. Outcome

The dashboard brings Facebook advertising and financial indicators into one reporting interface. It supports performance reviews by making spend, revenue, order volume, and ROAS easier to compare without relying solely on separate platform views or manual exports.
