Reporting · 1 page · 13 weeks of metrics
The Monday report template
The one-page report we send every client every Monday, and a weekly metrics sheet that works out MER, average order and cost per customer.
- MD3 KB
- CSV3 KB
Reporting · 5 channels · 12 months
Monthly channel KPI sheet
Spend, revenue and orders by channel for every month of 2027, set against what the store recorded, with ROAS, MER and cost per customer worked out.
- Every channel, every month, in one sheet
- A store total row per month, so MER sits next to platform ROAS
- Cost per order, cost per new customer and share of spend, worked out
- CSV16 KB
CSVhypential-channel-kpi-sheet.csvJan 2027 · formulas included
| 1 | Channel | Spend | Revenue | ROAS | Per order |
|---|---|---|---|---|---|
| 2 | Meta ads | =D2/C2 | =C2/E2 | ||
| 3 | Google Ads | =D3/C3 | =C3/E3 | ||
| 4 | TikTok ads | =D4/C4 | =C4/E4 | ||
| 5 | Email and SMS | =D5/C5 | =C5/E5 | ||
| 6 | Store total | =SUM(C2:C6) | MER | =C7/E7 |
What’s inside
Everything in the file.(07)
- 01Twelve months of 2027, each a block of six rows
- 02Meta ads, Google Ads, TikTok ads, email and SMS, organic and direct
- 03A store total row: store revenue, orders and new customers, with total ad spend added up
- 04ROAS per channel and MER for the store
- 05Cost per order and cost per new customer
- 06Each channel’s share of ad spend
- 07A note on every row saying where its numbers come from
The files
- hypential-channel-kpi-sheet.csvFor Google Sheets, Excel or NumbersCSV
16 KB
Free for your store and your clients’. Leave your email once, and this browser remembers it. Read the licence
Four steps
How to use it.
- Open the CSV in Google Sheets so the formulas work everywhere.
- At the start of each month, type last month’s spend, revenue and orders per channel.
- Type the store’s own revenue, orders and new customers in the store total row.
- Compare MER month to month before you look at any single platform’s ROAS.
Add up what Meta, Google and TikTok each say they sold and you will usually get more than the store took. This sheet keeps the platforms’ claims and the store’s truth side by side.
The store row is the one we steer by: total revenue over total ad spend, and what each new customer cost.
More from the library
You might need these next.
- Ad creative · 5 scripts · 30 hooks
UGC ad script templates
Five timed scripts for creator videos, thirty hooks to test on them, the one-page creator brief and the shot list.
- PDF389 KB
- MD10 KB
- Ad creative · 6 layouts · 1080 × 1350
Static ad layouts for Meta
Six editable ad layouts at 1080 × 1350: review card, us versus them, feature callouts, offer stack, three reasons and founder note.
- ZIP7 KB
FAQ
Questions about reporting.
Not on the list? Ask us.
Yes, and in Google Sheets and Numbers. The formulas use commas between arguments; if your Excel uses semicolons, open the file in Google Sheets instead.
Marketing efficiency ratio: store revenue divided by total ad spend. It doesn’t care which platform claims the sale, which is why we lead with it.
Yes. Put your name on it and send it. Just don’t sell the template itself.
Still unsure?Saimul Islam answers every message.Rather we ran it?
Let’s grow.
Book a strategy call
We do this every week in analytics and CRO. Book a call and we’ll show you how it would work for your store.
Or write to hello@hypential.com
