A weekly founder report from your Shopify data: what goes in it
Founders don't open dashboards. They read email on Monday morning. What a one-screen weekly report from Shopify should include, a template you can copy, and three ways to get it into your inbox.

The short answer
- A weekly founder report should fit on one phone screen and lead with the numbers that change a decision: sales against last week, stock-outs, dead stock and margin.
- Compare each week against the week before and the same week last year. A Shopify app can read only the last 60 days of orders by default, so year-on-year comparisons need the read_all_orders scope.
- For Indian D2C brands, the weekly report should show COD share and RTO, because a COD order that returns is revenue you never collected.
- A missing number, such as a product with no cost price, should show as unknown, never as zero.
- A custom Shopify dashboard with a scheduled founder brief costs ₹1,20,000 to ₹5,00,000 to build on Tanuj Rajput's published pricing.
Want this done rather than explained? a Shopify developer in Delhi NCR
A weekly founder report should fit on one phone screen and arrive at the same time every week, usually Monday morning. Lead with the numbers that change a decision: sales against last week and the same week last year, what sold out, what isn't selling, and margin after real cost prices. For Indian brands, add COD share and RTO. Everything else belongs in a dashboard you open when the report flags something.
I've built this for a D2C brand: a Monday brief that lands in the founders' inbox, built from their Shopify data and their own cost prices. The founders read it on their phones. They rarely open the custom dashboard behind it unless the brief tells them to. That's the design goal.
Why a report beats a dashboard for founders
Dashboards wait for you to open them. Founders are busy, so they don't. A report that arrives every Monday in the same layout gets read, and a change jumps out because everything else stays where it was last week.
A dashboard is still useful. It's where you dig in after the report has shown you something worth looking at.
What goes in the report
Eight sections, in this order:
- Sales and orders. Last week against the week before and the same week last year. The year-on-year comparison is the one that tells you if a slow week is seasonal.
- Average order value and units per order. Whether customers are buying more per visit.
- Top and bottom five products. By revenue, with the change from last week.
- Stock-outs and running low. What sold out, and which best sellers have fewer days of stock left than their vendor takes to deliver.
- Dead stock. Products that haven't sold in your chosen number of days, with the cash each one holds at cost price.
- Margin. Gross margin after real cost prices. A product with no cost price on file shows as unknown, never as zero cost, or the margin looks better than it is.
- COD and RTO, for Indian brands. COD share of orders and the return-to-origin rate. A COD order that comes back is revenue you never collected.
- New and returning customers. How much of the week came from people who'd bought before.
Finish with one line, written by a person: what changed and why. "Sales down 12% because the hero product sold out on Wednesday" is worth more than any chart.
A template you can copy
Weekly brief: [week, e.g. 3–9 Nov]
Sales ₹[sales] [±%] vs last week · [±%] vs same week last year
Orders [orders] AOV ₹[aov]
Top 5 [product] ₹[revenue] ([±%]) ...
Bottom 5 [product] ₹[revenue] ([±%]) ...
Sold out [products], about [n] missed sales at normal pace
Running low [products] with [n] days of cover vs [n]-day lead time
Dead stock [n] products, ₹[cash at cost] tied up
Margin [x]% gross, after cost prices ([n] products missing a cost: unknown)
COD / RTO COD [x]% of orders · RTO [x]%
Customers [x]% returning
What changed: [one sentence]
Keep the layout identical every week. The point is that a change jumps out.
Getting the data right
A few things make the difference between a report people trust and one they ignore:
- History. A Shopify app can read only the last 60 days of orders by default. The same-week-last-year line needs the
read_all_orderspermission and a one-time backfill. - Cost prices. Margin needs cost prices that match your accounting. In the brand's setup I built, cost prices come in from their accounting software and stay in the dashboard, never on Shopify.
- COD returns. RTO orders must be cancelled or refunded in Shopify, or every report counts them as revenue. The RTO rate itself usually comes from your courier or checkout app.
- Unknowns. Show a gap as unknown. A zero that should have been a blank makes people stop trusting the whole report.
Three ways to get it into your inbox
| Option | Effort | Includes your own data? |
|---|---|---|
| Export Shopify reports by hand each Monday | Someone's Monday morning | Only if they add it by hand |
| An analytics app's email summary | Low, if the app offers one | Only what the app holds |
| A custom dashboard that builds and sends the brief | A one-time build | Yes: cost prices, stock rules, vendors |
If an analytics app's summary covers your eight sections, use it. My guide to analytics apps for Indian D2C brands compares the main ones. When the sections that matter most need your own data, such as dead stock at cost or reorder alerts by vendor, that's where a custom dashboard beats an analytics app. The reorder side is covered in what a forecasting dashboard should show.
Who should get it
The founders and whoever owns operations, usually two to four people. A short list keeps someone responsible for acting on it. In the setup I built, the Monday brief goes to the founders by email.
What it costs
On my published pricing, a custom Shopify dashboard that builds and sends a weekly brief costs ₹1,20,000 to ₹5,00,000, or $2,000 to $8,000 for international brands. Most dashboards take 45 to 60 days. The ₹40,000 or $750 scoping sprint builds one working report on your real data first, and the brief is a good candidate for that first report. The fee is credited to the build.
What I'd do
Write the template above by hand for two Mondays. If the same five numbers keep mattering, and finding them takes someone an hour, automate it. See custom dashboard pricing or start a brief with the numbers you check every week.
Related reads
- Custom Shopify dashboard vs an analytics app
- Shopify inventory forecasting: what a dashboard should show
- Shopify analytics apps for Indian D2C brands, compared
- COD verification and RTO apps for Shopify in India
Sources
Frequently asked questions
What should a weekly Shopify report for founders include?
Sales and orders against last week and the same week last year, average order value, the top and bottom five products, stock-outs and products running low, cash tied up in dead stock, margin after cost prices, and for Indian brands COD share and RTO. Add one line on what changed and why.Can Shopify email me a weekly sales report automatically?
Shopify's reports live in the admin, so most brands export or screenshot them by hand. Some analytics apps send a daily or weekly email summary. For a report that includes your own data, such as cost prices and stock rules, a custom dashboard can build the brief and email it on a schedule.Why send a report instead of using a dashboard?
Because founders read email and rarely log in to dashboards. A report that arrives at the same time every week, in the same layout, gets read. A dashboard is better for digging into a number once the report has flagged it.Who should receive the weekly Shopify report?
The founders and whoever owns operations, usually two to four people. Keep the list short. A report sent to the whole company turns into something nobody feels responsible for acting on.How much does an automated weekly founder report cost?
As part of a custom Shopify dashboard, it falls inside my published build price of ₹1,20,000 to ₹5,00,000, or $2,000 to $8,000 for international brands. A ₹40,000 or $750 scoping sprint builds one working report on your real data first, and the fee is credited to the build.
Revision history· 1 entry
November 16, 2026
First published.
Last updated November 16, 2026






