CalculatorMasters

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

Net Profit = Total Revenue - Total Product Cost - Total Etsy Fees - Total Ad Spend

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

VariableWhat It MeansUnit
salePrice - Sale price per orderAverage amount paid by the customer for one order.currency
productCost - Product cost per orderDirect cost to produce and fulfill one order, such as materials and packaging.currency
etsyFeePercent - Total Etsy fee rateEstimated combined Etsy fees as a percentage of the sale price.percent
dailyAdSpend - Daily ad spendAverage amount spent on promoted listings each day.currency
costPerClick - Average cost per clickAverage advertising cost for each click.currency
conversionRate - Ad conversion ratePercentage of ad clicks that become orders.percent
days - Campaign lengthNumber of days in the ad campaign.days

Step-by-Step Calculation

1

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)

2

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

3

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

4

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

5

Calculate total ad spend

Multiply the daily budget by the number of days to get the full advertising cost.

totalAdSpend = dailyAdSpend * days

6

Calculate net profit

Subtract all included costs from projected revenue to estimate the campaign's net profit.

netProfit = totalRevenue - totalProductCost - totalEtsyFees - totalAdSpend

7

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

Sale price per order$35.00
Product cost per order$12.00
Total Etsy fee rate9.5%
Daily ad spend$10.00
Average cost per click$0.25
Ad conversion rate2.5%
Campaign length30 days
1

Etsy fee per order

35.00 × 0.095

$3.33

2

Daily clicks

10.00 ÷ 0.25

40 clicks/day

3

Daily orders

40 × 0.025

1.0 orders/day

4

Total orders

1.0 × 30

30 orders

5

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

6

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.

Try the Calculator →

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

1

Entering product cost without including packaging or other direct per-order fulfillment costs.

2

Using total store conversion rate instead of ad-specific conversion rate.

3

Forgetting that a strong ROAS can still produce weak profit if margins are thin.

4

Mixing organic sales assumptions with ad-driven sales in the same estimate.

5

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.

Try Etsy Promoted Listing Profit