Spend
$965
Conversions
84
Blended ROAS
6.6
Ad Spend & ROAS Tracker
Track daily ad spend, conversions and return on ad spend across platforms.
SpreadsheetAdvertising & Paid MediaFree
Turn budget and CPM, CTR and conversion assumptions into impressions, clicks, conversions, CPA and ROAS for every ad set.
Shown with sample data
Turn budget and CPM, CTR and conversion assumptions into impressions, clicks, conversions, CPA and ROAS for every ad set.
Latest: 1.7
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.
ROAS = revenue from ads ÷ ad spend. $6,000 revenue from $2,000 spend is a ROAS of 3.0 (or 300%).
The ROAS at which ad profit is zero after product costs: 1 ÷ gross margin. With a 40% margin, break-even ROAS is 2.5.
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.
One that leaves profit after product cost and fulfilment, ideally judged against customer lifetime value rather than the first order alone.
Download a copy
Downloads need a free account.