Free Shopify KPI Spreadsheet

Your weekly KPI early warning system.

Get the tool Ezra Firestone uses to run multiple 8-figure Shopify stores. This spreadsheet gives you instant clarity into your business, so you catch problems early — and fix them before they happen.

No credit card Instant access
Zipify is trusted by 50,000 Shopify merchants.
20+
KPIs tracked across every sales & ad channel — your entire business at a glance
8–9fig
Brands using it — the exact tool Ezra Firestone built to manage his stores, every single week
10min
Monday ritual — color-coded to instantly show what's working and what's not
The Dashboard

This is the sheet you're getting.

20+ metrics, 6 channels, one simple location. Drop your Current Week figures into the sheet and see the total health of your Shopify store at a glance — every Monday morning.

Your Weekly KPI Spreadsheet
H7 fx =(F7-G7)/G7
Early Warning System · Y/Y flags when >5% change ● FALLING <−5% ● STABLE ±5% ● RISING >+5%
METRIC
YEAR TO DATE
MONTH TO DATE
CURRENT WEEK
PRIOR YEAR WK
Y/Y
SHOPIFY — SALES
·
Net Sales
$1,842,000
$284,140
$71,040
$62,980
▲ +12.8%
·
Average Order Value
$68.40
$72.40
$72.40
$68.10
▲ +6.3%
·
Discounts (% of Gross)
9.2%
8.4%
8.4%
11.2%
▲ −2.8pp
·
New Customers
24,100
2,410
604
548
▲ +10.2%
·
Returning Customers
15,090
1,509
377
378
● −0.3%
MARKETING
·
Total Marketing Spend
$712,800
$71,280
$21,400
$18,525
▼ +15.5%
·
Spend as % of Net Sales
38.7%
25.1%
30.1%
29.4%
● +2.4pp
·
Customer Acquisition Cost
$29.58
$29.58
$38.90
$33.83
▼ +15.0%
FACEBOOK / META
·
Revenue
$1,189,000
$118,900
$29,725
$25,600
▲ +16.1%
·
Ad Spend
$382,000
$38,200
$9,550
$10,675
▲ −10.5%
·
ROAS
3.11×
3.11×
3.11×
2.40×
▲ +29.6%
GOOGLE
·
Revenue
$614,000
$61,400
$11,200
$14,725
▼ −23.9%
·
Ad Spend
$198,000
$19,800
$5,800
$4,775
▼ +21.5%
·
ROAS
3.10×
3.10×
1.93×
3.08×
▼ −37.3%
AMAZON — US
·
Net Sales
$427,000
$42,700
$10,675
$9,550
▲ +11.8%
·
Ad Spend
$91,400
$9,140
$2,285
$2,200
● +3.9%
·
ROAS
4.67×
4.67×
4.67×
4.34×
▲ +7.6%
·
Cost Per Click
$0.82
$0.82
$0.82
$0.88
▲ −6.8%
TOTAL — COMPANY
·
Total Sales
$3,882,400
$388,240
$97,060
$87,125
▲ +11.4%
·
Ad Spend % of Sales
17.4%
18.3%
18.3%
21.2%
▲ −2.9pp
Start Here
Weekly KPI Dashboard
Resources & Benchmarks

Weekly KPI Dashboard

20+ metrics across Shopify, Meta, Google, Microsoft, Amazon, Walmart. Y/Y auto-calculates the moment you drop in Monday's numbers.

Channel Contribution

See exactly how much of total sales each channel is driving — and when one starts quietly carrying or bleeding the rest.

Resources & Benchmarks

Targets from 100+ Shopify Plus brands so you know whether your key metrics are on track, ahead, or leaving money on the table.

THE PROBLEM

By the time most merchants realize something's wrong, it's already too late.

Any channel can look fine on the surface but be down 20% year over year — that's why so many merchants don't know there's a problem until it's too late. By the time it shows up in your monthly revenue, the damage is already done.

This spreadsheet solves that in just 10 minutes.
What today looks like — vs. the trend behind it ▼ REPEAT CUSTOMER −23% Y/Y
PAST · can't see the trend FUTURE · projected → 52w ago 40w 24w 8w TODAY +8w +16w +24w +52w YOU ARE HERE Today looks fine.

At any single snapshot, every channel can look healthy. Without the year-over-year trend, you can't see what today is hiding.

TOTAL REPEAT NEW META GOOGLE AMAZON
Who this is for

For Shopify operators who can't afford to guess.

Whether you're running one business or five, this spreadsheet gives you a single source of truth across every channel, every week — so you always know where you stand, what's working, and what needs your attention before it becomes a problem.

01 / 03

Founders

You're running multiple brands and you need to know the health of each one without getting into the weeds. One spreadsheet per store. Ten minutes on Monday. You know where everything stands.

Multi-brand Shopify founders
02 / 03

CEOs

You own the P&L. This gives you every sales channel, every budget line, and every key metric in one view — so you can walk into any conversation with your team knowing exactly what's working and what isn't.

Shopify CEOs & operators
03 / 03

Ecommerce Managers

You live in the data. This is your source of truth for ad spend, ROAS, channel performance, and spend as a percentage of net sales — week over week, year over year, all in one place.

DTC growth & ecom leads
Built by someone who actually uses it

$250M+ in Shopify revenue.
Managed from this file.

Ezra Firestone has built and scaled some of the most recognized brands in ecommerce — including one that's done $250M+ in Shopify revenue. He runs multiple 8 and 9-figure stores. This is the spreadsheet he uses to manage all of them.

"
EF

"You could run your entire company using just one spreadsheet. I can tell you how my business is doing and what I need to focus on that week by looking at this every Monday."

Ezra Firestone Founder & CEO · Zipify · Smart Marketer · BOOM!
Brands Ezra has built & scaled BOOM! by Cindy Joseph Zipify Apps Smart Marketer Blue Ribbon Mastermind
Trusted by 50,000+ Shopify brands, including
FORIA
FORIA
Victoria Beckham Beauty
Victoria Beckham Beauty
Cheech & Chong's
Cheech & Chong's
Pura
Pura
Manta Sleep
Manta Sleep
Vitality Extracts
Vitality Extracts
Primal Harvest
Primal Harvest
Lume
Lume
Lifeboost Coffee
Lifeboost Coffee
NutriPaw
NutriPaw
FORIA
FORIA
Victoria Beckham Beauty
Victoria Beckham Beauty
Cheech & Chong's
Cheech & Chong's
Pura
Pura
Manta Sleep
Manta Sleep
Vitality Extracts
Vitality Extracts
Primal Harvest
Primal Harvest
Lume
Lume
Lifeboost Coffee
Lifeboost Coffee
NutriPaw
NutriPaw
Get Instant Access — It's Free

One Spreadsheet.
Total Clarity.

No credit card Instant access
Zipify is trusted by 50,000 Shopify merchants.