Ads Break-even Calculator

A ready-to-use Google Sheets template in the language you choose, with instructions.

Type your order value and every cost of one order once. Paste campaign results, and each campaign gets CPA, ROAS, profit after ads and a clear decision.

What's in the file

  • Start here — step-by-step guide and colour legend
  • Guide — How to read the numbers. Plain explanations of every number, how to read the result and the mistakes to avoid.
  • Inputs — What one sale is worth. You fill in: Currency, Average order value, Product cost per order, Payment fees (% of order), Shipping & handling per order, Other cost per order, Profit you want per order.
  • Campaigns — Campaign results and what to do next. You fill in: Campaign, Platform, Spend, Purchases, Revenue. Worked out for you: CPA, ROAS, Profit after ads, Decision.
  • Dashboard — Where the ad money goes. Shows: Spend, Purchases, Overall CPA, Overall ROAS, Profit after ads, Break-even CPA, a chart.
  • Summary — What the numbers say. Shows: Break-even CPA, Target CPA, Overall CPA, Overall ROAS, Profit after ads, Campaigns to scale, Campaigns to pause, Spend on campaigns to pause, Best campaign (lowest CPA).
  • Action plan — What you will change next. Write what you will change, why, who owns it and by when; status shows in colour.
  • Checklist — Weekly ads routine. 9 steps to tick off, with a progress bar.

How to use it

  1. Open Inputs: type your average order value and every cost of one order, plus the profit you want to keep.
  2. Read your break-even and target CPA and ROAS.
  3. Paste campaign results into Campaigns: spend, purchases and revenue for one period.
  4. Check the Decision column and the Dashboard before you change budgets.

What it does

  • Break-even CPA and ROAS from your real costs
  • Target CPA that keeps your profit goal
  • Profit after ads per campaign
  • Scale / Keep / Pause / Wait decision per campaign
  • Two files in each language: a blank Template to fill in, and an Example filled with sample data
  • Available in several languages; Arabic files are laid out right-to-left
  • Formulas only, no macros or add-ins
  • Instant download after purchase

Included Files

  • A file in the language you choose
  • Arabic files laid out right-to-left
  • Step-by-step guide
  • Free updates for this version

Works With

  • Google Sheets

Support

Questions about setup? Send us a message from your account page and we reply by email.

Ads Break-even Calculator

The video tutorial for this template is coming soon.

No reviews yet. Reviews appear here after customers rate the template.

Write a review
Your rating
FAQ
  • Which language is the file in?

    You get the file in the language you pick at the top of the site. If a template is not available in that language yet, you get the English file. Arabic files are laid out right-to-left.

  • Do I need macros or add-ins?

    No. The templates use formulas and built-in charts only.

  • Can I change the template?

    Yes. Rename columns, add rows, change colours and add your logo.

  • How do I get the files after paying?

    The download link appears on the order page and in your account right after payment.

Personal License

For you, on your own projects and your own company reports.

Team License

Share the files with up to 10 people in your company.

$35.00

Free

File language: English

Add To Cart
Mia Ready
39 templates in the shop
View All Templates
Like this template?

Found it useful? Recommend it to other marketers and earn 30% of every sale you bring in.

Become an affiliate