Etsy Ads ROI Analyzer — Are Your Ads Paying? Free

Which of your Etsy ads lose money?

Drop in your Etsy Ads report and see, listing by listing, the profit after ad spend and the share of sales the ad had to actually cause for the fee to pay off. Etsy's report gives you sales and fees; it never subtracts what the item cost you.

The file is read in this browser tab and never leaves your device.

1. Your Etsy Ads report

Shop Manager → Marketing → Etsy Ads → Listings, download as CSV. Needs a listing ID or title, a Sales column and a Spend column; impressions, clicks, quantity sold and campaign are used when present. Several rows for one listing are added together.

Choose a CSV file …or paste the CSV text

Your profit margin before ad spend (% of sale price)

After item cost, Etsy fees and shipping you pay. Only you know this; try a few values.

Share of ad-credited sales that would have sold anyway (%)

Etsy credits the ad with any sale after a Etsy Ads click (within 30 days). Your guess, not a measurement.

Choose a file or paste CSV text, then click Analyze.

The model, and what it leaves out

Profit before ads = sales × your margin. Profit after fees = that minus ad spend, crediting the ad with every attributed sale.
Must be caused = ad spend ÷ profit before ads. It is the smallest share of the credited sales the ad must have really brought in. Above 100% the listing loses money even if the ad caused every sale.
Verdicts. loses: above 100%. marginal: above 60%. fails your assumption: positive at 0% sold-anyway but negative at the share you entered. pays: otherwise.
One margin for every listing. Real margins differ by item, so a verdict near a threshold is a prompt to check that item's own cost, not a finding.
Not modelled: returns and refunds after the report period, ad spend on cancelled orders, Etsy's listing-level suggested rates, and any effect an ad has on a listing's organic ranking.

Common questions

Where do I get the Etsy Ads report?

In Shop Manager go to Marketing, then Etsy Ads, open the listings view and download the stats for a date range. Drop the CSV here or paste its text. Column names vary a little between campaign types, so the tool matches common spellings and tells you if it cannot find a Sales or Ad spend column.

Why does it ask for my profit margin?

Etsy's report shows sales and ad spend but not what the item cost you. Profit before ads is your margin times sales, so every verdict depends on that one number. Use profit as a share of the sale price after item cost, Etsy's fees and shipping you pay. If you do not know it, try 15, 25 and 35 and see which listings change verdict.

What does 'must have been caused by the ad' mean?

Etsy credits an ad with a sale when the buyer clicked the ad within the attribution window before buying. Some of those buyers would have bought anyway. The tool shows, per listing, the share of attributed sales that must really come from the ad for the fee to pay for itself. Above 100% means it loses money even if the ad caused every sale.

Does it tell me what ad rate to set?

It shows the largest ad rate your margin can carry and which listings are above it. It cannot predict how a lower rate changes impressions, because that depends on competitors, so treat it as where to look and test one change at a time.

Is my file uploaded?

No. The file is read in your browser tab and never sent anywhere.

Is this financial advice?

No. It applies arithmetic to the file and margin you provide and does not replace your own records or a qualified adviser.