A store was sending lots of email without knowing what each send earned. This project built a clear Klaviyo dashboard showing revenue per email, flows vs campaigns, and list health.
LIFECYCLE // KLAVIYO → LOOKER
The tiles show sends, opens, clicks and revenue per email.
The chart tracks opens and clicks day by day.
The donut shows how much revenue comes from automated flows vs campaigns.
The email calendar was full, but nobody knew if the automated flows or the weekly campaigns were making the money. Opens looked fine and revenue looked fine — but the two were never connected.
We connected every send to the orders it produced and built the dashboard around one number: revenue per email. Now the team knows what works and when the list needs a rest.
Klaviyo data is pulled and connected to orders at the individual email level. The results are shown in a clean, light Looker Studio dashboard, with alerts for fatigue and spam rates.
Sends, opens, clicks, unsubs, orders — message level.
Revenue-per-mail, flow-vs-campaign split, fatigue signals.
Six light-theme pages: program, flows, campaigns, list, deliverability, alerts.
Fatigue and spam-rate alerts · weekly send-plan summary.
Two more pages: the campaign table and the alerts page. Built in HTML with sample data.
LIFECYCLE // EVERY SUBJECT LINE, PRICED
| SUBJECT LINE | SENT | OPEN | CTR | REV / MAIL | ORDERS |
|---|---|---|---|---|---|
| Back in stock — 48h | 24.1K | 52% | 5.1% | $1.42 | 214 |
| VIP early access | 18.4K | 58% | 6.8% | $1.61 | 196 |
| Your size is waiting | 22.8K | 47% | 4.4% | $1.10 | 168 |
| Bundle week teaser | 26.6K | 44% | 3.6% | $0.84 | 129 |
| Weekly digest #41 | 31.2K | 38% | 2.1% | $0.31 | 44 |
AUTOMATION // FATIGUE + SYNC RULES → SLACK
Digest opens fell 44% → 38% across three sends. Suggest: drop to fortnightly.
Revenue share hit 42% after the subject test; $1.9K incremental this week.
Klaviyo pull landed 07:00. 9,214 events. 0 errors.
Flows earned 58% of email revenue; the abandoned-cart subject test paid for the month on its own.
The digest is tiring its segment — opens sliding, unsubs creeping. Fortnightly cadence recommended before it costs list health.
Revenue per email sits next to open rate, so send-frequency debates end with a number.
The team knows which part of the program earns the most, and focuses there.
Rising unsubscribes trigger an alert months before they hurt revenue.
NOTE: CLIENT DETAILS GENERALISED · ALL NUMBERS ARE SAMPLE DATA · DASHBOARDS ARE HTML RECREATIONS
If your email calendar is full but nobody knows what a send earns, this dashboard answers it.