The Problem: “Most operators don’t find out their business is bleeding until it’s too late.” — Ezra Firestone
Is your Meta spend down 10% month-over-month, how about new customer revenue?
When small trends like these go unnoticed, they can become huge revenue leaks down the line.
That’s why Ezra Firestone uses the same Weekly KPI Spreadsheet to help run all his 8 & 9-figure brands. It automatically tracks every metric that matters across Shopify, Meta, Google, and Amazon, and gives him a complete snapshot of the health of his businesses in 5 minutes.
We’ll show you how to download your own copy of the spreadsheet and how to use AI to set it up in this quick article.
Here’s Ezra’s Solution: The Weekly KPI Spreadsheet
Most CEOs and managers don’t need to monitor 100+ metrics every day. They just need to see the right set of numbers, once a week, that alert them immediately if something is off.
Checking daily is too often because one outlier can make the whole business look broken. Monthly is too slow because by the time a problem shows up, it’s been compounding for four weeks.
That’s why Ezra reviews this spreadsheet every Monday morning, and it tells him exactly what he needs to fix or focus on at the start of every week.
Click here to download Ezra’s Weekly KPI Spreadsheet.
“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
Let AI Pull the Numbers for You
If you skip KPI reviews because exporting data from Shopify, Meta, Google, Microsoft, and Amazon is a pain, AI removes that bottleneck.
Now you can upload a CSV or screenshot into ChatGPT or Claude then have it populate the spreadsheet for you.
Ezra uses Claude Cowork to pull weekly data into his sheet automatically. The whole import process takes under 2 minutes. Build the process once, save it, and run it every Monday.
Quick Look Inside the Spreadsheet
Here are four of the +20 important KPIs Ezra looks at every Monday:
- Marketing Spend as a % of Net Sales: His earliest warning signal — anything creeping over 35% means the business doesn’t have enough margin to operate)
- New vs. Repeat Customer Revenue: The split that tells you instantly whether you need to fix your acquisition or lifecycle marketing that week.
- Average Order Value: This is because when AOV rises, profit margin expands across every other metric.
- Discount Percentage: A sudden spike almost always means a coupon code leaked — a common revenue leak for any Shopify store.
These four numbers help Ezra understand how his business is performing that week and that year.
Watch Ezra’s 10-Minute Walkthrough Video
But Ezra also recorded a 10-minute walkthrough video to go along with this spreadsheet:
He explains every section of his Weekly KPI Spreadsheet, then he drills down into each metric, why they’re important, and what to do if your performance dips.
It’s the fastest way to get this up and running for your business.
Get Ezra’s Weekly KPI Spreadsheet + walkthrough video here →
