Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesMarketing & GrowthAdvertising & Paid MediaMeta Ads Campaign Planner

SpreadsheetAdvertising & Paid MediaFree

Meta Ads Campaign Planner

Turn budget and CPM, CTR and conversion assumptions into impressions, clicks, conversions, CPA and ROAS for every ad set.

Shown with sample data

Colour

Meta Ads Campaign Planner

Turn budget and CPM, CTR and conversion assumptions into impressions, clicks, conversions, CPA and ROAS for every ad set.

Total budget
$8,600
Forecast conversions
259
Blended CPA
$33.20
Blended ROAS
2.2
Break-even ROAS
1.8
1 ÷ gross margin
Actual ROAS to date
1.5
Actual CPA to date
$46.72
Forecast ROAS by ad set
  • Cart abandoners: 7 days6.1
  • Customers: new collection4.1
  • Retargeting: 30-day site visitors3
  • Lookalike 1%: purchasers2.2
  • Broad: women 25–45, US1.5
  • Interest: home cooking0.9
Actual ROAS by week
Oct 19, 2026Nov 9, 2026

Latest: 1.7

How to use it

  1. 1Enter your gross margin and target ROAS on the Settings sheet.
  2. 2Add each ad set with budget and assumptions from past campaigns or industry ranges.
  3. 3Rebalance budget towards ad sets marked Scale and rethink those below break-even.
  4. 4Each week, log actual spend, impressions, clicks, purchases and revenue from Ads Manager.
  5. 5Update the plan’s assumptions with real numbers after two to three weeks.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Forecast a Facebook and Instagram campaign before you spend a dollar, then compare it with what actually happens. For each ad set enter the monthly budget and your assumptions for CPM, click-through rate, conversion rate and order value; the planner works out impressions, clicks, conversions, cost per acquisition and ROAS, and compares ROAS with your target and break-even ROAS from gross margin. A weekly actuals sheet calculates the real CPM, CTR, CPA and ROAS so you can see which assumptions were wrong.

Who it’s for

  • Planning a monthly Meta ads budget
  • Pitching a campaign forecast to a client or boss
  • Checking whether ads can be profitable at your margins
  • Weekly performance reviews

What’s included

  • Plan sheet: Forecast for each ad set.
  • Weekly actuals sheet: Actual results by week from Ads Manager.
  • Settings sheet: Your margin and target.

How to use it

  1. 1Enter your gross margin and target ROAS on the Settings sheet.
  2. 2Add each ad set with budget and assumptions from past campaigns or industry ranges.
  3. 3Rebalance budget towards ad sets marked Scale and rethink those below break-even.
  4. 4Each week, log actual spend, impressions, clicks, purchases and revenue from Ads Manager.
  5. 5Update the plan’s assumptions with real numbers after two to three weeks.

Tips

  • Break-even ROAS is 1 ÷ gross margin: at a 50% margin, every $1 of ads must return $2 of revenue just to break even.
  • Retargeting usually shows a higher ROAS than prospecting but runs out of audience; judge prospecting on new-customer value, not ROAS alone.
  • Give each ad set enough budget to exit the learning phase (Meta suggests around 50 conversions a week) before judging it.
  • Platform-reported conversions and your store’s numbers rarely match exactly; compare trends with your own sales data.

Questions

How do I calculate ROAS?

ROAS = revenue from ads ÷ ad spend. $6,000 revenue from $2,000 spend is a ROAS of 3.0 (or 300%).

What is break-even ROAS?

The ROAS at which ad profit is zero after product costs: 1 ÷ gross margin. With a 40% margin, break-even ROAS is 2.5.

How are impressions and clicks estimated?

Impressions = budget ÷ CPM × 1,000. Clicks = impressions × CTR. Conversions = clicks × conversion rate. CPM and CTR vary by audience, season and creative; use your own history where you can.

What is a good CPA?

One that leaves profit after product cost and fulfilment, ideally judged against customer lifetime value rather than the first order alone.

Related searchesfacebook ads plannermeta ads calculatorinstagram ads budget plannerroas calculatorfacebook ads forecastcpa calculator

Details

Format
Spreadsheet
Category
Advertising & Paid Media
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAdvertising & Paid MediaFree

Meta Ads Campaign Planner

Turn budget and CPM, CTR and conversion assumptions into impressions, clicks, conversions, CPA and ROAS for every ad set.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Advertising & Paid Media
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More advertising & paid media templates

View all
Ad Spend & ROAS Tracker2 sheets

Spend

$965

Conversions

84

Blended ROAS

6.6

Spend over time
SpreadsheetAdvertising & Paid Media

Ad Spend & ROAS Tracker

Track daily ad spend, conversions and return on ad spend across platforms.

10 min setupPreview
Google Ads Campaign Planner2 sheets

Monthly budget needed

$4,395

Forecast leads

245

Blended cost per lead

$18

Monthly spend by campaign type
$2,652
$1,017
$399
$327.60
ProductProblemBrandCompetitor
SpreadsheetAdvertising & Paid Media

Google Ads Campaign Planner

Plan search campaigns by ad group: keywords, bids and budget, with forecast clicks, leads and cost per lead.

10 min setupPreview
Media Plan & Flowchart2 sheets

Total budget

$76,500

Planned impressions

6,195,748

Blended CPM

$12

ABCD
1ChannelPlacementObjectiveMonth 1
2Paid searchGoogle, non-brandConversion$6,000
3Paid socialMeta, prospectingConsideration$5,000
4Paid socialMeta, retargetingConversion$1,500
5VideoYouTube in-streamAwareness$4,000
Plan
SpreadsheetAdvertising & Paid Media

Media Plan & Flowchart

Budget by channel and month with planned impressions, cost per thousand and share of spend.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ