
Etsy Promoted Listing Profit Formula
Learn how an Etsy promoted listing profit estimate is calculated from price, costs, fees, ad spend, clicks and conversions.
This page explains the math behind an Etsy promoted listing profit estimate. It shows how ad spend turns into clicks, clicks turn into orders, and orders turn into revenue and profit after product costs, Etsy fees and advertising costs are subtracted.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Net Profit
Where:
Estimate how many ad-driven orders you get from your budget and conversion rate, calculate the revenue from those orders, then subtract product costs, Etsy fees and the total ad budget.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| salePrice - Sale price per order | Average amount paid by the customer for one order. | currency |
| productCost - Product cost per order | Direct cost to produce and fulfill one order, such as materials and packaging. | currency |
| etsyFeePercent - Total Etsy fee rate | Estimated combined Etsy fees as a percentage of the sale price. | percent |
| dailyAdSpend - Daily ad spend | Average amount spent on promoted listings each day. | currency |
| costPerClick - Average cost per click | Average advertising cost for each click. | currency |
| conversionRate - Ad conversion rate | Percentage of ad clicks that become orders. | percent |
| days - Campaign length | Number of days in the ad campaign. | days |
Step-by-Step Calculation
Calculate Etsy fee per order
Multiply the average order value by the estimated fee percentage to get the Etsy fee amount for one sale.
etsyFeeAmount = salePrice * (etsyFeePercent / 100)
Estimate daily clicks
Divide the daily ad budget by the average click cost to estimate how many clicks the ads generate each day.
dailyClicks = dailyAdSpend / costPerClick
Estimate daily and total orders
Convert clicks into orders using the conversion rate, then multiply by the number of campaign days.
totalOrders = (dailyClicks * (conversionRate / 100)) * days
Estimate revenue and variable costs
Use the projected order count to calculate total revenue, direct product cost and Etsy fees for the whole campaign.
totalRevenue = salePrice * totalOrders; totalProductCost = productCost * totalOrders; totalEtsyFees = etsyFeeAmount * totalOrders
Calculate total ad spend
Multiply the daily budget by the number of days to get the full advertising cost.
totalAdSpend = dailyAdSpend * days
Calculate net profit
Subtract all included costs from projected revenue to estimate the campaign's net profit.
netProfit = totalRevenue - totalProductCost - totalEtsyFees - totalAdSpend
Calculate margin and ROAS
Margin shows the share of revenue kept as profit, while ROAS shows how much revenue is generated for each ad dollar spent.
profitMargin = (netProfit / totalRevenue) * 100; roas = totalRevenue / totalAdSpend
Worked example for a 30-day Etsy ad campaign
Etsy fee per order
35.00 × 0.095
$3.33
Daily clicks
10.00 ÷ 0.25
40 clicks/day
Daily orders
40 × 0.025
1.0 orders/day
Total orders
1.0 × 30
30 orders
Revenue and costs
Revenue: 35 × 30; Product cost: 12 × 30; Etsy fees: 3.325 × 30; Ad spend: 10 × 30
Revenue $1,050.00; Product cost $360.00; Etsy fees $99.75; Ad spend $300.00
Net profit, margin and ROAS
1,050.00 - 360.00 - 99.75 - 300.00; 290.25 ÷ 1,050.00 × 100; 1,050.00 ÷ 300.00
Net profit $290.25; Margin 27.6%; ROAS 3.50x
Final Result
Estimated net profit is $290.25, with a profit margin of 27.6% and ROAS of 3.50x.
Assumptions
- ✓Sale price, product cost, fee rate, click cost and conversion rate stay consistent throughout the campaign.
- ✓All projected orders are attributed to the promoted listing traffic in the estimate.
- ✓The Etsy fee percentage entered is a blended estimate for the fees you want included.
- ✓Only direct product costs, Etsy fees and ad spend are included in the base calculation.
Limitations
- !Actual click costs and conversion rates often change over time, so real results may differ.
- !The estimate does not automatically include refunds, returns, coupon discounts, taxes or overhead.
- !ROAS measures revenue efficiency, not profit by itself.
- !Very low revenue or zero orders can make margin and profitability harder to interpret.
Common Mistakes to Avoid
Entering product cost without including packaging or other direct per-order fulfillment costs.
Using total store conversion rate instead of ad-specific conversion rate.
Forgetting that a strong ROAS can still produce weak profit if margins are thin.
Mixing organic sales assumptions with ad-driven sales in the same estimate.
Using an Etsy fee percentage that excludes payment processing or other selling fees you expect to pay.
Related Formulas
Frequently Asked Questions
What is the basic formula for Etsy promoted listing profit?
The basic formula is total revenue minus product costs, Etsy fees and total ad spend.
How do you calculate orders from Etsy ad spend?
First estimate clicks by dividing daily ad spend by cost per click, then multiply clicks by conversion rate, and finally multiply by campaign days.
How is ROAS different from profit margin?
ROAS compares revenue to ad spend only, while profit margin compares net profit to revenue after included costs are subtracted.
Why is Etsy fee percentage applied to sale price?
The calculator uses the entered fee rate as a percentage of the sale price to estimate average fees per order.
Can a campaign have positive ROAS but negative profit?
Yes. Revenue can exceed ad spend while total costs still outweigh revenue, especially when product costs and fees are high.
Does the formula include shipping, refunds or overhead?
Not unless you build those items into your sale price, product cost or fee assumptions.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.