Build a report
Sign in with Google
Works with Looker Studio

Facebook Ads campaign performance dashboard template for Google Sheets

Track your Meta Ads customer journey from first impression to final purchase in one comprehensive view. Monitor top-funnel reach through bottom-funnel conversions effortlessly.

Download Template

By Porter

This template is built by the same marketers behind all our tutorials, support, and our template gallery.

Data sources included

+40,000 marketers have downloaded our dashboards

Questions you can answer using this Facebook Ads dashboard template

  • What is the total ad spend across all campaigns?
  • Which campaign has the highest number of conversions?
  • How does the overall ROAS (Return on Ad Spend) compare to individual campaign performance?
  • Which campaigns are significantly underdelivering in terms of budget pacing?
  • What is the average CPA (Cost Per Acquisition) across all campaigns?
  • Which campaign has the best performing CTR (Click-Through Rate)?
  • What percentage of the total budget has been spent so far?
  • How does the daily ad spend trend change over time according to the graph?
  • How do conversion rates vary across different stages of the marketing funnel for each campaign?

How to set up this Google Sheets template?

Copy the Facebook Ads campaign performance dashboard template for Google Sheets in one click and automate your reporting

Follow these steps:


  • Step 1: Make a copy of the template.

  • Step 2: Download the extension and authorize your profile.

  • Step 3: Choose the accounts you want to pull data from.

  • Step 4: Use our prebuilt queries or build one from scratch to automate your data collection. Alternatively, you can input data manually.

  • Step 5: Set up automatic refresh to keep your dashboard updated.


Metrics and dimensions included

Customize the template’s metrics and dimensions as you like. See all available Facebook Ads fields.

Metrics

  • Conversion Metrics

    • Daily spend
    • Cumulative amount spend
    • Pacing ($) / Pacing %

  • Customizable charts

    • Link clicks
    • CTR (Click-Through Rate)
    • CPC (Cost Per Click)

  • Visibility metrics

    • Impressions
    • CPM (Cost Per Mille/1000 Impressions)
    • Ad spend

Dimensions

  • Date

    • Time progress: hours, days, weeks, month, quarter, and year.
    • Status: overspending or underspending
    • By day, week, month, quarter, or year.

  • Campaign

    • Campaign name
    • Adset name
    • Objective

  • Performance

    • Status (e.g., Delivering, Underdelivering)

Features

You can customize your marketing reports directly in Google Sheets with your logo, colors, and branding.
Set up email alerts using conditional notifications when a cell value changes.
Edit all charts and change style values, and then paste them on your Google Slides so they can auto sync.

Utilize functions like SUMIF, VLOOKUP, IF, and ARRAYFORMULA to calculate key metrics like CPA, ROAS, and CTR, automating calculations and combining data fields.

Pull your historical marketing data automatically using our Google Sheets marketing extension.

Filter by date, campaign, channel, and more to get the insights you need.
Set, track, and achieve marketing goals with real-time updates.
Set sync intervals to match your reporting needs, whether daily, weekly, or monthly.
Connect Google Analytics, Facebook Ads, Instagram, LinkedIn, and more to create a unified view of your marketing performance.

FAQs

For a comprehensive Facebook Ads tracking and pacing dashboard template, you should include the following:

  • Conversion Metrics: Total conversions and conversion value.
  • Engagement Metrics: Link clicks and impressions.
  • Efficiency Metrics: Cost Per Acquisition (CPA), Return On Ad Spend (ROAS), Cost Per Click (CPC), Average Click-Through Rate (CTR), and Average Cost Per Mille (CPM).
  • Budget Overview: Total budget, actual spend, and remaining budget.
  • Pacing Metrics: Pacing in dollars and percentages, with drill-down capabilities by day, week, month, and quarter.
  • Campaign Performance: Breakdown by campaign name, objective, amount spent, and key performance indicators.
  • Visual Data: Time series graph to show performance trends over time.

To automate this report, you should consider using a data integration tool that can connect directly to the Facebook Ads API. This will allow for automatic syncing of your Facebook Ads data, ensuring real-time updates and enabling more timely optimizations to your campaigns.

While this template is designed specifically for Facebook Ads, you can use Google Sheets’ multichannel connectors such as LinkedIn Ads, GA4, Shopify to integrate data from other marketing platforms. By combining insights from different sources, you can create a unified view of your overall marketing performance.

To set up email alerts, use the built-in notifications feature in Google Sheets. You can create custom rules to trigger email alerts based on specific conditions, such as when your actual spend exceeds the budget or when pacing percentages hit certain thresholds.

Yes, you can fully customize the charts in the dashboard. You can choose different chart types, adjust colors, fonts, and styles, add data labels, legends, and trendlines, and customize axes and gridlines to match your reporting needs.

Additional marketing templates you can copy

Start a 14-day free trial

Connectors

Learn Looker Studio

Looker Studio templates

Resources