Etsy Ads Cost Calculator Formula
Learn how Etsy Ads spend, clicks, orders, revenue, cost per order, and ROAS are estimated from your campaign inputs.
This page explains the math behind the Etsy Ads Cost Calculator. It shows how daily budget, average cost per click, conversion rate, average order value, and campaign length combine to estimate ad spend and sales performance.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Return on Ad Spend and Campaign Revenue Estimate
Where:
Estimate how many clicks your budget can buy, convert a share of those clicks into orders, multiply orders by average order value to get revenue, and then divide revenue by ad spend to get ROAS.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| dailyBudget - Daily ad budget | Average amount planned for Etsy Ads each day. | currency |
| averageCpc - Average cost per click | Estimated or actual average amount paid per ad click. | currency |
| campaignDays - Campaign length | Number of days the campaign runs or the review period covers. | days |
| conversionRate - Conversion rate | Percentage of clicks that turn into orders. | percent |
| averageOrderValue - Average order value | Average revenue earned per order from ad traffic. | currency |
| totalAdSpend - Total ad spend | Estimated total spend across the full campaign period. | currency |
| estimatedRevenue - Estimated revenue | Projected gross revenue from orders attributed to ad clicks. | currency |
| roas - Return on ad spend | Revenue divided by ad spend. | : |
Step-by-Step Calculation
Estimate daily clicks
Divide the daily budget by the average cost per click to estimate how many clicks the ads can generate each day.
estimatedDailyClicks = dailyBudget / averageCpc
Estimate total clicks
Multiply estimated daily clicks by the number of campaign days to project total clicks.
totalClicks = estimatedDailyClicks * campaignDays
Estimate orders
Apply the conversion rate to total clicks to estimate how many clicks become orders.
estimatedOrders = totalClicks * (conversionRate / 100)
Calculate total ad spend
Multiply the daily budget by campaign length to estimate total ad cost.
totalAdSpend = dailyBudget * campaignDays
Estimate revenue
Multiply estimated orders by average order value to project gross revenue from ad traffic.
estimatedRevenue = estimatedOrders * averageOrderValue
Calculate cost per order and ROAS
Cost per order shows average ad spend needed for one order. ROAS compares revenue to ad spend.
costPerOrder = totalAdSpend / max(estimatedOrders, 1); roas = estimatedRevenue / max(totalAdSpend, 1)
Worked example for a 30-day Etsy Ads campaign
Estimate daily clicks
10 / 0.40
25 clicks per day
Estimate total clicks
25 * 30
750 clicks
Estimate orders
750 * 0.03
22.5 orders
Calculate total ad spend
10 * 30
$300
Estimate revenue
22.5 * 35
$787.50
Calculate ROAS
787.50 / 300
2.63x
Final Result
Estimated ad spend is $300, estimated revenue is $787.50, cost per order is about $13.33, and ROAS is about 2.63x.
Assumptions
- ✓The full daily budget is spent each day of the campaign.
- ✓Average CPC stays relatively stable across the whole period.
- ✓Conversion rate remains consistent for the traffic driven by ads.
- ✓Average order value does not change materially during the campaign.
- ✓Revenue is based on gross order value before fees, product costs, shipping, taxes, or refunds.
Limitations
- !Real Etsy Ads performance can vary by listing quality, competition, seasonality, and keyword mix.
- !The calculator does not account for repeat purchases, refunds, cancellations, or partial attributions.
- !Averages can hide large day-to-day swings in CPC, click volume, and conversion rate.
- !ROAS alone does not show profit because other business costs are excluded.
Common Mistakes to Avoid
Entering conversion rate as a decimal instead of a percent, such as entering 0.03 instead of 3.
Using revenue after fees as average order value when the calculator expects gross order value.
Assuming a strong ROAS automatically means strong profit without checking margins and other costs.
Using a very short test period to estimate long-term CPC or conversion rate.
Ignoring the effect of seasonality or listing changes when projecting future results.
Related Formulas
Frequently Asked Questions
How do you calculate Etsy Ads spend over a campaign?
Multiply the daily ad budget by the number of campaign days. That gives the estimated total ad spend for the period.
How is estimated revenue from Etsy Ads calculated?
Estimated revenue equals estimated orders multiplied by average order value. Orders are based on clicks and conversion rate.
What is the formula for cost per order?
Cost per order is total ad spend divided by estimated orders. It shows the average advertising cost needed to generate one sale.
What is the ROAS formula for Etsy Ads?
ROAS is estimated revenue divided by total ad spend. A ROAS of 2 means $2 of revenue for each $1 spent on ads.
Why does the formula use max(estimatedOrders, 1)?
It prevents division by zero when estimated orders are very low or zero. It is a practical safeguard in the calculator logic.
Does this formula show profit?
No. It estimates revenue and ad cost, but it does not subtract Etsy fees, product costs, packaging, shipping, taxes, or overhead.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.