Etsy Ads ROI & A/B Test Tracker | Digital Shop Conversion Tool (Google Sheets, Excel)

Q: Does it connect to my Etsy account?
A: No, and that's on purpose. Nothing to authorize and no data leaves your file. You copy a few numbers from your Etsy Stats and Etsy Ads pages (daily or weekly) and every calculation, verdict and chart updates instantly.

Q: Do I get both the Google Sheets* and Excel* versions?
A: Yes. Your download includes a PDF with a one-click link to copy the Google Sheets* version to your own Drive, plus a ready-to-use Excel* (.xlsx) file and an Instructions PDF.

Q: Is it built for high-volume digital shops?
A: Yes. It tracks up to 200 listings, 2,000 daily log rows and 100 A/B tests, and it uses digital-product math (no shipping or materials), so the break-even ROAS for each download is calculated correctly.

Q: I'm not a spreadsheet expert. Will I break the formulas?
A: Unlikely. You only type in green cells. Grey formula cells show a warning if you try to type over them, but nothing is locked, so you stay in control. The Start Here tab and Instructions PDF walk you through every step.

Q: Is this a physical product?
A: No. This is an instant digital download. No physical item will be shipped.

----------

STOP GUESSING WHETHER ETSY ADS ARE WORTH IT

Most digital sellers look at one number in the Etsy Ads dashboard and hope for the best. This etsy ads roi calculator and digital shop conversion tracker shows you the truth for every single listing: which products earn back their ad spend, which are close, and which quietly drain your marketing budget.

It also works as an etsy ab testing spreadsheet. Change a thumbnail or title, log the dates, and the tracker compares version A and version B side by side and tells you when there is a real winner.

----------

WHAT IT DOES

DASHBOARD (pick any date range)
- 18 live KPIs: revenue, visits, conversion rate, net profit, Etsy fees incl. Offsite Ads, organic orders, ad spend, ad revenue, ROAS, ad profit, TACoS, ad click rate and more
- ROAS shown next to your real break-even ROAS
- Best ad performers vs. budget drains, side by side
- Charts: ad profit by listing, verdict mix, ad spend vs. ad revenue by month

LISTINGS - A VERDICT FOR EVERY PRODUCT
- Break-even ROAS and profit per sale after Etsy fees
- Max affordable cost per click, compared with your actual CPC
- Automatic verdict: SCALE, KEEP, OPTIMIZE, CUT or NO SALES - PAUSE
- A plain-English next step for each listing

A/B TESTS - THUMBNAIL, TITLE, PRICE AND TAG TESTS
- Version A vs. B conversion rate, ad click rate, ROAS and revenue per visit
- Conversion-rate lift plus a statistical confidence score
- Calls the winner for you (or tells you to keep testing)
- Supports before/after tests and duplicate-listing tests

DAILY LOG
- Daily or weekly rows for visits, favorites, orders, revenue, ad views, clicks, spend, ad orders and Offsite Ads
- Calculates conversion rate, CPC, ROAS, fees, net profit and ad profit
- Shows which A/B test version was live on each day

MONTHLY SUMMARY + AD BUDGET
- 12-month table with chart: traffic, conversion, ROAS, TACoS, fees and profit
- Planned vs. actual ad budget, over-budget alerts and a suggested daily budget for the rest of the month

SETTINGS
- Editable Etsy fee rates (US defaults), Offsite Ads rate and verdict thresholds, so it fits your shop and country

----------

WHAT'S INCLUDED
- Google Sheets Download Link PDF (one-click "Make a copy" link)
- Excel* file (.xlsx)
- Instructions PDF (setup, resizing cells, keeping formulas safe)

HOW DELIVERY WORKS
1. After purchase, download the files from your Etsy Purchases page.
2. Open the Google Sheets Download Link PDF and click the link, then click "Make a copy". Or open the Excel* file.
3. Follow the Start Here tab. You'll be tracking in about 10 minutes.

COMPATIBILITY
- Google Sheets*: free Google account, any computer; view and edit in the Google Sheets* app on phones
- Excel*: Excel* 2016 or newer on Windows or Mac*
- No macros, no add-ons, no subscription

PLEASE NOTE
- Instant digital download. No physical item is shipped.
- The template arrives blank. Example numbers in the photos are for illustration only.
- Planning tool only, not financial or tax advice.

Questions? Send us a message on Etsy. More templates at ProFormaGrid.com

*Google Sheets and Google Drive are trademarks of Google LLC. Microsoft and Excel are trademarks of Microsoft Corporation. Mac is a trademark of Apple Inc. ProFormaGrid is an independent shop and is not affiliated with or endorsed by Etsy, Google, Microsoft or Apple.