Etsy Ads ROI Formula
Learn how Etsy ad revenue, profit, cost metrics, and ROI are estimated from clicks, conversion rate, order value, margin, fees, and ad spend.
The Etsy Ads ROI formula estimates whether your ad-driven sales are covering Etsy fees and advertising costs. Understanding each step helps you see which input has the biggest effect on profitability, such as conversion rate, average order value, or margin.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Return on Investment
Where:
First estimate how many orders your ads generated. Then estimate revenue, calculate profit before fees, subtract Etsy fees and ad spend, and divide the remaining profit by ad spend to get ROI as a percentage.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| adSpend - Ad spend | Total amount spent on Etsy ads during the period being analyzed. | currency |
| adClicks - Ad clicks | Total number of clicks received from Etsy ads in the same period. | number |
| conversionRate - Conversion rate | Percentage of ad clicks that turned into orders. | percent |
| averageOrderValue - Average order value | Average revenue per order from ad-attributed sales. | currency |
| profitMargin - Profit margin | Estimated profit margin before ad costs and before separately applied Etsy fees. | percent |
| etsyFeeRate - Etsy fee rate | Blended Etsy selling fee percentage applied to ad-attributed revenue. | percent |
Step-by-Step Calculation
Estimate orders from ad clicks
Multiply total ad clicks by the conversion rate to estimate how many orders came from the ads.
estimatedOrders = adClicks * (conversionRate / 100)
Estimate ad-driven revenue
Multiply estimated orders by average order value to get revenue attributed to the ads.
adRevenue = estimatedOrders * averageOrderValue
Estimate gross profit before Etsy fees
Apply your pre-fee profit margin to ad revenue to estimate gross profit before Etsy fees and ad costs.
grossProfitBeforeFees = adRevenue * (profitMargin / 100)
Estimate Etsy fees
Apply the blended Etsy fee rate to ad revenue to estimate selling fees on those sales.
etsyFees = adRevenue * (etsyFeeRate / 100)
Estimate net profit after ads
Subtract Etsy fees and ad spend from gross profit to estimate the remaining profit.
netProfitAfterAds = grossProfitBeforeFees - etsyFees - adSpend
Calculate ROI
Divide net profit after ads by ad spend and convert it to a percentage to measure return on ad spend.
roi = (netProfitAfterAds / adSpend) * 100
Example: Monthly Etsy ads ROI estimate
Estimate orders
500 × 3%
15 orders
Estimate ad revenue
15 × $35
$525
Estimate gross profit before fees
$525 × 40%
$210
Estimate Etsy fees
$525 × 9.5%
$49.88
Estimate net profit after ads
$210 - $49.88 - $300
-$139.88
Calculate ROI
(-$139.88 ÷ $300) × 100
-46.6%
Final Result
Estimated ad revenue is $525, net profit after ads is about -$139.88, and ROI is about -46.6%.
Assumptions
- ✓All clicks, conversion rate, and revenue inputs cover the same time period.
- ✓Profit margin represents profit before ad costs and before the separately entered Etsy fee rate is deducted.
- ✓The Etsy fee rate is treated as one blended percentage rather than separate fee types.
- ✓All estimated orders are attributed to ad clicks using the entered conversion rate.
- ✓Average order value is assumed to be stable across all ad-generated orders.
Limitations
- !The estimate does not automatically include refunds, cancellations, shipping adjustments, or off-platform costs unless you account for them in your margin.
- !Results depend heavily on attribution assumptions, and real Etsy reporting may assign orders differently.
- !Repeat purchases and lifetime customer value are not included in the direct ROI calculation.
- !If ad spend is zero, ROI cannot be calculated using the standard formula.
- !Break-even revenue is only meaningful when profit margin is greater than Etsy fee rate.
Common Mistakes to Avoid
Using a profit margin that already subtracts Etsy fees and then entering Etsy fees again separately.
Mixing monthly ad spend with weekly clicks or conversion data from a different period.
Entering conversion rate as a whole number in decimal form, such as 0.03 instead of 3, when the field expects a percent.
Using total shop average order value when ad-driven customers usually spend more or less than average.
Ignoring product mix differences that change margin across advertised listings.
Related Formulas
Frequently Asked Questions
How do you calculate Etsy Ads ROI?
Estimate orders from clicks and conversion rate, estimate revenue from average order value, subtract Etsy fees and ad spend from profit, then divide net profit by ad spend and multiply by 100.
What is the formula for estimated Etsy ad revenue?
Estimated ad revenue is calculated as ad clicks multiplied by conversion rate, then multiplied by average order value.
Why does the formula subtract Etsy fees separately?
The calculator assumes profit margin is entered before Etsy fees, so the fee rate is deducted as its own cost line to avoid understating platform costs.
What does a negative Etsy ads ROI mean?
It means the estimated profit remaining after Etsy fees and ad spend is below zero, so the campaign is not covering its costs based on the inputs used.
How is cost per order calculated in Etsy ads?
Cost per order is ad spend divided by estimated orders. It shows how much advertising spend was needed to generate each order.
What is break-even revenue for Etsy ads?
Break-even revenue estimates how much ad-attributed sales revenue is needed so that profit after Etsy fees covers ad spend. It depends on your margin and fee rate.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.