Paid Ads Performance Dashboard

Track spend, ROAS, CPA, conversion rates, budget pacing, goals, and alerts in one premium command center.

Total Spend
$18,420
↑ 12.4% vs previous
Total Revenue
$72,860
↑ 18.7% vs previous
ROAS
3.95x
Above 3.5x target
CPA
$22.40
Below $25 target
CTR
1.82%
Healthy
Conversion Rate
2.74%
Above benchmark
Profit
$54,440
↑ 21.1%
Budget Used
84%
Monitor pacing

Performance Trend

Spend, revenue, and ROAS

Goal Progress

This month
Revenue Goal0%
Budget Used0%
Profit Goal0%
Lead Goal0%

Platform Comparison

Revenue by channel

Budget Allocation

Spend distribution

Meta Ads Breakdown

Combined Meta Ads view with Facebook, Instagram, and Threads split

No extra column is needed. Use Platform = Facebook, Instagram, or Threads in your Google Sheet. Choosing Meta Ads in the dashboard automatically combines Facebook + Instagram + Threads, while this table still shows the split.

Meta PlatformSpendRevenueROASCPACTRConversionsStatus

Campaign Tracker

Enter or import campaign-level data. Calculated KPIs update automatically in the dashboard.

View Mode

Switch between daily, weekly, and monthly performance views.

Daily shows each imported row. Weekly and monthly group your data by period, platform, and campaign.

DatePlatformCampaignSpendRevenueCTRCPAROASStatus

Budget Planner

Set planned budget by campaign and monitor actual spend, remaining budget, and pacing.

How budgets work

Budgets are monthly by default. Enter the monthly planned budget for each campaign below. Meta Ads is shown as a combined roll-up of Facebook + Instagram + Threads, while the editable budget inputs remain on each child campaign. Budget settings are saved in this browser.

Campaign Budget Settings

Edit planned budget per campaign
PlatformCampaignActual SpendPlanned BudgetRemaining% UsedStatus

KPI Goals

Set target ROAS, CPA, CTR, revenue, profit, leads, and budget thresholds.

Alerts Center

Automatic KPI monitoring with severity labels and recommended actions.

SeverityAlertPlatformCurrentTargetRecommended Action
WarningBudget usage above paceMeta Ads84%80%Reduce daily budget or shift spend to highest ROAS campaigns.
Action RequiredLow ROAS campaignTikTok Ads1.8x3.5xPause weak ad sets and test new creative hooks.
HealthyCPA under controlGoogle Ads$19.80$25.00Scale branded and high-intent campaigns carefully.

Period Comparison

Compare the selected period with the previous matching period.

Current vs Previous Period

Dynamic comparison
MetricCurrentPreviousChangeStatus

Agency Report

Client-facing performance summary, ready to export or screenshot.

Executive Summary

Import campaign data to generate a dynamic summary.

Recommended Next Step

Import campaign data to generate recommendations.

Performance Highlights

Best and weakest areas
AreaResultInsight

Benchmarks

Default KPI targets by business niche. These can be connected to Google Sheets later.

Benchmarks are editable starting points, not guarantees. Adjust them for margin, price point, funnel type, and market maturity. Changes are saved in this browser and used across KPI cards, alerts, comparison, and the agency report.

IndustryTarget ROASTarget CPATarget CTR %Target CVR %Target CPCTarget CPM

Instructions

Use this dashboard as a premium front-end for your paid ads Google Sheet.

Connect Google Sheets Data

Option 1: paste your published Google Sheet CSV link below. The dashboard saves it in this browser and tries to load the Campaign Tracker data automatically.

No Google Sheet connected yet. Use a published-to-web CSV link for the simple no-login version.

Backup Import Method

If live connection is blocked by the browser, download the Campaign Tracker tab as CSV and upload it here. This works offline and is the most reliable method for customers using the HTML file locally.

No CSV imported yet.

  1. Make a copy of the Google Sheets template.
  2. Fill the Campaign Tracker tab with your ad data. For Meta, use Facebook, Instagram, or Threads in the Platform column; the dashboard combines them automatically under Meta Ads.
  3. For live connection: go to File β†’ Share β†’ Publish to web, choose Campaign Tracker, choose Comma-separated values (.csv), then copy the generated link.
  4. Paste the CSV link above and click Connect Sheet.
  5. If live connection fails, go to File β†’ Download β†’ Comma-separated values (.csv), then use the Backup Import Method above.
  6. Use the top filters for industry, period, and platform.
  7. Set monthly campaign budgets in Budget Planner.
  8. Adjust benchmarks in the Benchmarks tab if your goals are different.
  9. Click Export Report to print or save the Agency Report as PDF.

How to Fill the Google Sheet Columns

Keep these exact column names in row 1.
ColumnWhat to enterHow the dashboard uses it
DateThe date for the row, such as 2026-06-01.Filters daily, weekly, monthly, and previous-period performance.
PlatformGoogle Ads, Facebook, Instagram, Threads, TikTok Ads, Pinterest Ads, LinkedIn Ads, Reddit Ads, etc. For Meta performance, enter Facebook, Instagram, or Threads directly.Filters and compares performance by channel. The dashboard automatically rolls Facebook + Instagram + Threads into the Meta Ads combined view.
IndustryYour niche, such as Skincare, Beauty, Fashion, SaaS, Real Estate, or Local Services.Optional. The top Industry selector controls benchmarks; this column is useful if you manage several industries in one file.
CampaignThe campaign name from your ad account.Groups performance and campaign-level budgets.
Ad SetAd set, ad group, audience, or creative group.Useful for notes and future detailed analysis.
SpendAd spend for that date/campaign. Enter numbers only, no currency symbols.Calculates budget used, ROAS, CPA, CPC, CPM, profit, and alerts.
ImpressionsNumber of times ads were shown.Calculates CTR and CPM.
ClicksNumber of ad clicks.Calculates CTR, CPC, and conversion rate.
ConversionsMain result: purchases, bookings, signups, or leads depending on your goal.Calculates CPA and conversion rate.
RevenueSales or value generated from the ads. Enter numbers only.Calculates ROAS and profit.
LeadsLead count, if applicable.Used for lead tracking and report context.
OrdersOrder or purchase count, if applicable.Used for ecommerce reporting.
NotesOptional comments like creative test, sale period, budget increase.Helps explain changes when reviewing results.