Orders
Revenue
Shop visits
Ad spend
Etsy fees
COGS
Conversion rate2.00%
AOV25.00
Revenue growth—
Ad ROAS10.00
Gross sales500.00
Net sales465.00
Net profit265.00
Profit margin53.00%
Etsy hands you the numbers one month at a time, spread across several stats pages, and leaves the arithmetic to you. This Etsy shop KPI dashboard takes the handful of figures you copy out each month and works out the ones that actually tell you how the shop is doing — conversion, average order value, revenue growth, ad ROAS, net profit and margin. You type nine numbers a month; it does every calculation, and shows you the year, the quarter and how it compares with the same period last year.
| Month | Orders | Revenue | Visits |
|---|---|---|---|
| Jan 2026 | 20 | $500 | 1,000 |
| Feb 2026 | 24 | $600 | 1,200 |
Illustrative example — the workbook itself is a clean spreadsheet.
This mill is a picture of the idea, not the product: type a month’s figures on the tags and watch the six discs stamp themselves in the drawer. Leave the ad-spend tag at zero and the ROAS disc comes out smooth and blank — nothing to stamp. In the workbook itself, the same maths is done for real: one typed row per month on Monthly Data, and every ratio worked out for you on the KPIs sheet.
You know the feeling of opening your Etsy stats and coming away with an impression rather than a fact. Last month felt good. This month feels slower. The ads seem to be doing something. Somewhere in that fog is a real answer about whether the shop is growing, whether your traffic is converting, whether the money you put into ads is coming back — and you can’t get to it, because the numbers live on separate screens and change the moment you move to another one.
So the decisions get made on the impression. You list more because it feels quiet. You boost a listing because a friend liked it. You tell yourself the shop is fine, or the shop is struggling, and you have nothing to check that against — and even if you did check, you’d have to work out conversion and average order value and growth by hand every month, which is the kind of arithmetic that gets abandoned in February.
This Etsy shop KPI dashboard ends that by making the arithmetic automatic. It’s a ready-made Excel workbook with one data-entry sheet and the rest built to read it. Each month you type the same nine figures you already copy from Etsy: orders, revenue, shop visits, ad spend, new listings, reviews, fees and cost of goods. The workbook takes it from there — every ratio, every comparison, every flag — and the Dashboard sheet assembles the year and the quarter into something you can look at for ten seconds and understand.
One plain note before you read on: the visuals and interactive elements on this page are illustrations, made only to introduce the product and show what it does. What you receive is the Excel workbook described here — those illustrations aren’t part of the file.
What changes is that you stop reacting to a feeling and start reacting to a number. A slow month becomes a slow month in conversion, or a slow month in traffic, or a slow month that isn’t actually slow once you see the revenue line. When a month misses the target you set, the row says so plainly, and you can look at the months around it. And when someone asks how the shop is doing, you open the Dashboard instead of describing your mood.
Etsy will show you a conversion rate for a period and an order count for a period, but it won’t put the ratios you care about side by side, month after month, in a form you can compare. The workbook’s KPIs sheet does exactly that, one row per month, nothing to type on it. From each typed row it works out conversion, average order value, revenue growth against the previous month, ad ROAS, gross and net sales, net profit and profit margin. Every formula is already written; the only thing you supply is the raw figures.
Etsy’s stats are built for looking backwards at short windows. The Dashboard sheet has two selectors at the top — a year and a quarter — and everything below them follows the period you choose. Set it to a year and the headline cards give you that year’s revenue, orders and conversion. Set it to a quarter and the same cards narrow to those three months. That’s the difference between checking on last month and understanding a season.
A revenue number on its own tells you almost nothing, which is why each headline card carries a comparison line against the equivalent period a year earlier. The conversion card compares in percentage points, because a conversion rate moving from 3.0% to 3.2% is a point-of-percentage change, not a percentage change. And the conversion figure itself is weighted — the period’s total orders divided by the period’s total visits — rather than an average of monthly percentages, which would let a quiet month with three visits distort the whole picture. The trend table below does the same job month by month: for each of the twelve months it shows revenue and orders this year beside the same month last year, with the change between them.
In Settings you set three numbers once: a monthly revenue target, an annual orders target and a conversion rate target. Those three values then do real work. On the monthly data sheet, a target column flags each month as a hit or a miss against the revenue target. On the Dashboard, a goals block works out the revenue goal for the selected period, how much of it you’ve reached, how much is still to go, the same for orders, and a plain verdict on whether the conversion target has been met. You’re not relying on willpower to keep your own targets in view — they’re wired into the file.
The Traffic Sources sheet lists your sources of visits and orders and works out each one’s conversion, with a verdict against the average of all your sources. The dashboard’s traffic panel then shows total visits, your top source and your best-converting source. It is a snapshot you refresh from Etsy’s stats each month, not a month-by-month history.
Every sheet is protected, without a password. Only the yellow cells accept typing; every white cell is a locked formula. That’s not a restriction, it’s a guarantee: the totals can’t be overwritten by accident, a stray keystroke can’t corrupt a month, and the figures you read are always the figures the workbook calculated. Sorting, filtering, inserting rows and columns and formatting all stay switched on, so the protection never gets in your way — it only stops you from breaking the machine.
The workbook contains eight sheets that work together, in this order: START HERE, Dashboard, Monthly Data, KPIs, Traffic Sources, Settings, Lists and Guide.
START HERE opens the file with four all-time headline cards — Total Revenue, Total Orders, Average Conversion (total orders divided by total visits across everything you’ve entered) and Best Month Revenue — plus a map of how the sheets connect.
Monthly Data is the only place you type shop numbers: one row per month, 240 monthly entry rows, and the workbook ships empty, so you begin with your own figures. Each month you fill nine yellow columns — the month itself (dates from 1 January 2023 through 31 December 2030), orders, revenue, shop visits, ad spend, new listings, reviews, Etsy fees and cost of goods. Negative entries are rejected. Two columns calculate themselves beside your entries: Revenue Rank, that month’s revenue ranked against every month you’ve entered, and Target Hit, whether the month reached your monthly revenue target.
KPIs mirrors those monthly rows with calculated results and nothing to type: conversion, average order value, revenue growth against the previous month, ad ROAS, gross sales, net sales, net profit and profit margin. Where a calculation has no valid divisor — zero orders, zero visits — the result stays blank rather than showing a misleading zero or an error.
The Dashboard is the workbook’s main overview, labelled “ETSY COMMAND CENTER”. Choose a year (it ships set to 2026) and a quarter (All, Q1, Q2, Q3 or Q4; it ships set to All) and everything follows that period: the headline cards for revenue, orders and weighted conversion, each compared with the same period last year; the Revenue Core panel with the period’s revenue, net profit, average order value and ad ROAS; the Traffic Mix panel fed by Traffic Sources; a Data Volume line counting the months you’ve entered; the trend table setting the selected year’s twelve months beside the same months last year, with a TOTAL row; the goals block working from your three targets; and the workbook’s one chart — a line chart of monthly revenue this year against last year.
Traffic Sources is where your buyers come from: a 20-row table whose ten supplied names — Etsy Search, Etsy Ads, Direct / Bookmarked, Instagram, Pinterest, Google Search, Email Newsletter, Repeat Buyers, Etsy Gift Mode, Other — are all editable, with ten blank rows for your own sources. You enter visits and orders per source; conversion and an above- or below-average verdict are calculated. It is a current snapshot you refresh from Etsy’s stats, not a month-by-month history. Settings holds exactly three targets — a Monthly Revenue Target ($2,000 as shipped), an Annual Orders Target (600 as shipped) and a Conversion Rate Target (3.0% as shipped) — and nothing else. Lists holds the quarter choices behind the Dashboard dropdown. Guide explains every sheet in plain language, including the golden rule — yellow cells are the only cells you type in — and the working order: Monthly Data first, Traffic Sources next, Dashboard last.
Opens the file with four all-time headline cards — Total Revenue, Total Orders, Average Conversion and Best Month Revenue — plus a map of how the sheets connect.
The period view, labelled “ETSY COMMAND CENTER”: year and quarter selectors, headline cards against the same period last year, the Revenue Core and Traffic Mix panels, the trend table, the goals block and the workbook’s one revenue chart.
The engine: one typed row per month, 240 rows, ships empty. Nine yellow columns; Revenue Rank and Target Hit are calculated beside the entries.
The calculated mirror: conversion, AOV, revenue growth, ad ROAS, gross sales, net sales, net profit and profit margin for every month — nothing to type.
Twenty rows — ten supplied source names, all editable, plus ten blank. Visits and orders typed; conversion and a verdict against the average calculated. A current snapshot, not a history.
Exactly three targets, all editable: Monthly Revenue Target $2,000, Annual Orders Target 600 and Conversion Rate Target 3.0%, as shipped.
The quarter choices behind the Dashboard dropdown: All, Q1, Q2, Q3 and Q4.
Every sheet explained in plain language, including the golden rule — yellow cells are the only cells you type in — and the working order: Monthly Data first, Traffic Sources next, Dashboard last.
Short walkthroughs for this workbook. Nothing loads until you press play.
Short, focused walkthroughs of the Etsy Shop KPI Dashboard are being recorded — getting started, working each sheet, and the month-end routine. When they are published, they will appear right here, filed under the categories above.
The KPIs sheet’s maths, in miniature — one card per month, running live in your browser. Type a month’s six figures and read its conversion rate, AOV, revenue growth, ad ROAS, gross sales, net sales, net profit and profit margin; add more months and each new card measures its growth against the one before it. It runs entirely here: nothing is stored, and no data leaves the page. The full workbook remains the complete version.
One card per month, carrying the KPIs sheet’s own maths. Type a month’s six figures and the card works out its conversion rate, AOV, revenue growth against the month before it, ad ROAS, gross sales, net sales, net profit and profit margin. A result that would divide by zero reads —, exactly as the sheet leaves it blank. Blank fields count as 0.
A negative or non-numeric entry is rejected — it counts as 0 until it is fixed.
New Listings and Reviews are not inputs here, exactly as in the file — the workbook records them, but they feed no KPI. The full workbook holds 240 monthly rows, the Dashboard’s year and quarter views and the year-on-year comparisons; this miniature is the per-month maths only.
This is for the Etsy seller who already copies their monthly numbers out of Etsy’s stats pages — into a note, a notebook, a spreadsheet, wherever — and wants those numbers turned into an honest overview instead of a pile of figures. You’ve been running long enough to have a few months behind you and enough months ahead to want the comparison. You’re comfortable typing figures in by hand and you’d rather have one place that works everything out than six places that each show you a fragment.
It’s not for you if you’re hoping for something that connects to Etsy and imports your data — every number here is typed by hand, and there’s no API or CSV import. It doesn’t do daily or weekly figures, and it doesn’t track individual listings or orders. Etsy fees go in as one monthly total rather than being worked out from fee rates, and there are no forecasts, projections or additional charts.
You pay once on Etsy, and the file is yours to keep and reuse.
Delivery is an instant download the moment you check out, with nothing shipped and nothing to wait for.
Open the workbook in Microsoft Excel, Google Sheets or LibreOffice Calc — its formulas update the calculations as you type.
The workbook is an .xlsx file that opens in Microsoft Excel, Google Sheets and LibreOffice Calc, so you can work in whichever you already have. Its formulas update the calculations as you type, while the protected formula cells remain locked and the yellow input cells remain available for entry. The sheets are protected without a password, with sorting, filtering, row and column changes, and formatting left enabled. Delivery is an instant download the moment you check out, with nothing shipped and nothing to wait for. You pay once on Etsy, and the file is yours to keep and reuse.
You type them. The workbook has no connection to Etsy and no import of any kind — that’s deliberate, since it means nothing can break when Etsy changes a page. You copy the figures from your stats and enter them; everything after that is calculated for you.
Nine things, once a month: the month, orders, revenue, shop visits, ad spend, new listings, reviews, Etsy fees and cost of goods. That’s the entire data-entry job. The two target and rank columns, the KPIs sheet and the whole Dashboard are calculated from those nine figures.
Yes. The monthly table covers dates from January 2023 to December 2030, and it ships empty, so you can type in past months to build the history the year-on-year comparison needs. Until you enter them, cells that would divide by zero stay honestly blank rather than showing errors.
You pay once on Etsy, and the file is yours to keep and reuse.
Instant download after checkout. One payment, and the workbook is yours to keep.