Break-even ROAS for Etsy Ads
sellerprofit_ads_breakevenWorks out the ROAS at which an Etsy shop's Etsy Ads pay for themselves (break-even ROAS = order ÷ what an ad order keeps after Etsy's fees and costs), the most an ad can cost per sale, and, with the shop's ROAS, what the ads gain or lose a month. Call it when a seller asks whether Etsy Ads are worth it, what ROAS they need, or whether to turn ads off. Pass the item price, shipping charged, materials, label cost, and the daily budget or exact monthly spend; packaging is optional ($1 typical, flagged) and ROAS from the Etsy Ads page adds the monthly gain or loss and the fix. Returns the margin, break-even ROAS, ad sales and earnings, the monthly gain or loss and, when the ads lose money, the fix and what it's worth. US dollars; dated Etsy rules with sources. Free, no sign-in. Takes numbers only; nothing is stored.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| roas | No | Return on ad spend, last 30 days (Etsy Ads page): ad revenue ÷ ad spend, such as 1.5. Left out: only the break-even is returned. | |
| itemPrice | Yes | Typical item price, US dollars, before shipping. | |
| labelCost | Yes | The shipping label, US dollars. | |
| materials | Yes | Materials and supplies per item, US dollars. | |
| packaging | No | Packaging per order in US dollars, or mailer (about $1), box (about $3) or not-sure. Left out: $1, a weakly sourced typical figure, flagged as a default. | |
| adsDailyBudget | No | Etsy Ads daily budget, US dollars (assumed fully spent, 30 days a month). Or send adsMonthlySpend. | |
| adsMonthlySpend | No | Exact Etsy Ads spend last 30 days, US dollars. Or send adsDailyBudget. | |
| shippingCharged | No | What the buyer pays for shipping, US dollars (0 if free). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fix | Yes | ||
| roas | Yes | ||
| text | Yes | ||
| rates | Yes | Which rules the numbers use, as of when, and where they come from. | |
| status | Yes | ||
| adSales | Yes | ROAS × spend, a month. | |
| platform | Yes | ||
| orderTotal | Yes | ||
| assumptions | Yes | ||
| marginForAds | Yes | profitPerAdOrder ÷ order total. | |
| breakEvenRoas | Yes | 1 ÷ margin: ads pay back at this ROAS or more. Null when each order loses money before the ad. | |
| adSpendMonthly | Yes | ||
| earnedAfterCosts | Yes | Ad sales × margin, a month. | |
| profitPerAdOrder | Yes | What an order an ad brought keeps before the ad: order − Etsy fees − materials − packaging − label (no Offsite fee on it). Also the most an ad can cost per sale. | |
| monthlyGainOrLoss | Yes | earnedAfterCosts − spend: negative means the ads cost more than they bring in. |