Channel guide
Email marketing dashboard: what to track and how to build one people trust
An email marketing dashboard brings sends, deliverability, clicks, conversions and revenue from your email platform into one live view, checked against the orders or leads your business actually recorded. This guide is for ecommerce brands, in-house email teams and marketing agencies reporting on Klaviyo, Mailchimp, HubSpot or similar platforms for one or many clients. It covers the metrics that matter, why open rates and platform revenue mislead, a worked reconciliation, and how our team builds these reports in Data Studio.

Quick answer
What should an email marketing dashboard include?
An email marketing dashboard should show delivered volume, bounce and spam complaint rates, clicks, click rate, unsubscribes, conversions and revenue per recipient, split by campaigns and automated flows. Open rate belongs in a secondary view because Apple Mail Privacy Protection inflates it, and email revenue should be checked against GA4 and your store or CRM.
- Lead with clicks, revenue per recipient and list health, not open rate.
- Apple Mail Privacy Protection loads email content in the background, so opens are inflated.
- Klaviyo credits revenue to the last email opened or clicked within 5 days by default.
- Gmail asks bulk senders to keep spam rates below 0.30%, so track complaints on page one.
What is an email marketing dashboard, and why do the numbers get questioned?
An email marketing dashboard is a live report that combines data from your email service provider (ESP) with website and sales data, so you can see whether email is producing customers and keeping the list healthy. The useful ones answer three questions on the first screen: did the emails reach the inbox, did people act on them, and how much revenue or pipeline followed.
Email dashboards get questioned for a reason most template pages skip. The ESP reports opens that nobody made, and it credits itself with revenue that GA4 and paid media platforms also claim. A founder who adds Klaviyo revenue, Meta revenue and Google Ads revenue together often finds the total is larger than the store's actual sales. Once that happens, every figure in the report loses credibility.
The pages that rank for this topic today are mostly product tours from reporting tools. They list open rate, click rate and bounce rate, which you need, but they rarely explain how privacy features changed open tracking, how ESP attribution works, or how to reconcile email with the rest of the marketing mix. That is where most of the value in a good build sits, so this guide spends most of its time there.
Which metrics belong on an email marketing dashboard?
Group metrics by the question they answer and label the source of each one. A click from the ESP, a session in GA4 and an order in Shopify are three different counts of related events, and the report should never let a reader compare them by accident.
Split every metric by campaigns (one-off sends) and flows or automations (welcome series, abandoned cart, post-purchase, win-back). Flows usually behave very differently from campaigns, and blending them hides which part of the programme is doing the work.
| Question | Metrics | Source |
|---|---|---|
| Did it reach the inbox? | Delivered, bounce rate (hard and soft), spam complaint rate, unsubscribe rate | ESP, plus Google Postmaster Tools for Gmail spam rate |
| Did people act? | Unique clicks, click rate, click-to-open rate (secondary), top links | ESP |
| What did it produce? | Conversions, revenue, revenue per recipient, average order value | ESP attribution, cross-checked with GA4 and the store or CRM |
| Is the list growing well? | Net list growth, new subscribers by source, active profiles, suppressed profiles | ESP |
| How does it compare? | Email channel sessions, key events and revenue in GA4; email share of total revenue | GA4 and the store or CRM |
Why can't you trust email open rates any more?
Because a large share of recorded opens are made by software, not people. Apple's own privacy documentation says that with Mail Privacy Protection, rather than only downloading remote content when you open an email, Mail downloads it in the background by default. It covers Mail on iPhone, iPad, Mac and Vision Pro devices and Mail on iCloud.com. The tracking pixel loads whether or not the subscriber ever reads the message.
Mailchimp states this plainly in its Apple privacy help page: emails present in Apple Mail are reported as opened regardless of the contact's activity, which produces inflated and inaccurate open rates. Mailchimp lets users exclude these opens from reports for emails sent on or after June 22, 2024. Klaviyo's attribution settings also let you remove bot clicks and Apple privacy opens from attribution, but that is a setting someone has to choose.
For a dashboard, the practical rules are simple. Move open rate off the summary page. Where the ESP separates machine opens, show the adjusted figure and label it. Use clicks, click rate and revenue per recipient as the engagement measures that matter, and never use opens to judge subject line tests or to decide who counts as an engaged subscriber without checking the ESP's filtering first.
How does email revenue attribution work, and why does it disagree with GA4?
Every system counts revenue by its own rules, so their email totals will not match. A good email marketing dashboard shows each figure in its own place and explains the gap instead of picking one silently.
Klaviyo's help centre describes its default model as last touch: 100% of conversion credit goes to the last eligible touchpoint before the conversion, with default windows of 5 days for email opens and 5 days for email clicks. That means a subscriber who opened a newsletter on Monday and bought on Thursday after clicking a Google ad can be credited to email in Klaviyo and to Google Ads in the Ads account. If the open was an Apple privacy open, the customer may never have seen the email at all.
GA4 sees something different. It only knows a visit came from email if the link carried tags it recognises. Google's documentation for the default channel group puts a session in Email when the source or medium matches email, e-mail, e_mail or e mail. Untagged links from Gmail web often show up as referral traffic, and links opened in desktop mail apps often arrive as direct. GA4 then applies its own attribution across every channel, which typically gives email far less credit than the ESP does.
The store or CRM is the only system that counts each order or lead once. Use it as the total, show ESP-attributed revenue as an upper bound and GA4 email revenue as a lower bound, and let the reader see both.
- Attribution window: ESP opens and clicks within days, GA4 by its own model, ad platforms by theirs.
- Open-based credit: ESPs can credit opens, including machine opens, while GA4 only sees clicks that land on the site.
- Tagging: missing or inconsistent utm_medium values send email traffic to referral, direct or unassigned in GA4.
- Double counting: the ESP and ad platforms can each claim the same order.
- Refunds and cancellations: the store removes them, while the ESP may still show the original order value.
Worked example: reconciling email revenue for one month
Take one hypothetical online store for one month. These figures are illustrative, not benchmarks. Shopify records $150,000 in net sales. Klaviyo attributes $42,000 to email, split $27,000 to flows and $15,000 to campaigns. GA4's Email channel shows $14,500 of purchase revenue.
On the ESP figure alone, email drove 28% of revenue ($42,000 divided by $150,000). On GA4's figure it drove under 10% ($14,500 divided by $150,000). Both are correct by their own rules. The difference of $27,500 is revenue Klaviyo credits through opens or clicks within 5 days that GA4 credits to another channel, or does not see as email because of missing tags.
Now the open rate. Suppose a campaign was delivered to 20,000 subscribers and the ESP reports 9,000 opens, a 45% open rate. If the ESP's Apple filter shows 5,000 of those as privacy opens, the human-verified figure is closer to 4,000 opens, or 20%. The campaign recorded 600 unique clicks, which is a 3% click rate either way. Click rate did not move when the filter was applied, which is why it belongs on the summary page and open rate does not.
In Data Studio, we show this as a three-column scorecard: store revenue, ESP-attributed email revenue and GA4 email revenue, with email share calculated against store revenue in each case. Revenue per recipient is a calculated field, SUM(attributed_revenue) / SUM(delivered), on a table where ESP sends and revenue share the same date and message keys. The reader sees a range, not a single claim, and stops arguing about which number is right.
Which deliverability numbers should sit on page one?
Spam complaints and bounces deserve a place on the summary page because they decide whether future emails reach anyone. A drop in revenue often starts as a rise in complaints that nobody was watching.
Google's email sender guidelines set requirements for anyone sending 5,000 or more messages a day to Gmail accounts, in force since February 1, 2024. Senders must authenticate with SPF, DKIM and DMARC, support one-click unsubscribe with a clearly visible unsubscribe link, and keep the spam rate reported in Postmaster Tools below 0.30%, with Google recommending staying below 0.10%. A dashboard that shows spam rate against those two lines turns a vague worry into a number an account manager can act on.
ESP complaint rates and Postmaster Tools spam rates are measured differently, so show them separately and label the source. Postmaster Tools data is not available through a native Data Studio connector, so most teams record it weekly in a Google Sheet that feeds the report.
- Spam complaint rate by send, with reference lines at 0.10% and 0.30%.
- Hard bounce rate, which points to list quality and stale imports.
- Unsubscribe rate by campaign, to catch send-frequency fatigue.
- Authentication status for SPF, DKIM and DMARC, recorded as a simple pass or fail.
How do you build an email marketing dashboard in Data Studio?
Data Studio (formerly Looker Studio) is free and connects natively to GA4, Google Sheets and BigQuery, but it has no native connector for Klaviyo, Mailchimp or most other ESPs. That shapes the build. Our usual process has five steps.
For a single brand with one ESP, a partner connector feeding the report directly can be enough. For agencies with many clients, or brands that want history beyond what an API returns, we land daily ESP, GA4 and store data in BigQuery and report from that copy. It keeps reports fast, protects history if a platform changes its API, and makes the store-versus-ESP reconciliation a simple join.
- Define metrics: agree which revenue figure is the headline, whether Apple privacy opens are excluded, and how flows and campaigns are named.
- Fix tagging: set a consistent utm_source and utm_medium=email on every ESP link so GA4's Email channel captures the traffic.
- Connect sources: ESP data through a partner connector from vendors such as Supermetrics, Windsor.ai or Porter Metrics (check that the vendor supports your ESP and its current price), GA4 natively, and the store or CRM through a connector, Sheets or BigQuery.
- Model the data: build one daily table keyed on date, message and client, with sends, clicks, conversions and revenue from each source side by side.
- Design and test: summary, campaigns, flows, deliverability and list growth pages, with totals reconciled against the ESP and the store before handover.
Which Data Studio limits affect email reporting?
A few platform limits explain most of the broken email reports we are asked to fix. None of them is a reason to avoid Data Studio, but each one changes how the report should be designed.
- Blends join at most 5 data sources with equality joins only, so ESP, GA4, store and targets data quickly outgrow a live blend.
- Fixed-schema sources such as GA4 cap a table at 10 dimensions and 20 metrics.
- The GA4 Data API allows 14,000 tokens per project per property per hour on standard properties, so reports with many charts and viewers can hit quota errors.
- Large message-level tables can trigger too many rows errors and need aggregation or a warehouse.
- Data Studio gives no warning when a connector breaks, so someone has to check data freshness after each refresh.
What mistakes make email marketing reports misleading?
Most misleading email reports are not wrong line by line. They put numbers side by side that were measured on different rules. These are the issues we look for first when a brand or agency asks us to review an existing report.
- Leading with open rate and celebrating a rise that came from Apple privacy opens.
- Adding ESP-attributed revenue to ad platform revenue and reporting the sum as marketing revenue.
- Mixing flows and campaigns in one total, which hides a weak campaign calendar behind strong automations.
- Comparing months across a change in attribution settings without a dated note.
- Untagged links, so GA4 shows email traffic as referral or direct.
- No spam complaint or bounce view, so deliverability problems show up only as falling revenue.
Should you build it yourself, use a reporting tool, or hire an agency?
Use the ESP's own reports if you run one brand on one platform and only need campaign-level results. Klaviyo and Mailchimp both report sends, clicks and attributed revenue well within their own walls, and you do not need a separate email marketing dashboard to read them.
Use a per-client reporting tool if you are an agency that wants a ready-made template and a client login with little custom work. Our guide to client reporting tools for agencies compares the main options.
Bring in an agency when you need email reconciled with GA4, paid media and store or CRM revenue in one place, when you report for many clients and want the reports branded as your own, or when you want history stored in BigQuery. That is the work our marketing dashboards and white-label reporting services cover. We are not the right fit if a single ESP report already answers your questions.
How Greenwolf Tech Labs builds email marketing dashboards
We start with a free review of your ESP, your GA4 tagging and where your real orders or leads are recorded. We then agree the headline revenue figure and how opens are treated, fix link tagging, connect the sources, model a daily table in Sheets or BigQuery, and design the report in Data Studio with totals reconciled against each system before handover.
Our team has delivered 100+ projects for 200+ clients and builds multi-channel marketing dashboards that bring Google Ads, Meta, LinkedIn, GA4 and Search Console together, so email can sit alongside the rest of the mix. We quote a fixed price after the review, and every report and data source we build sits in accounts you own.
FAQ
Frequently asked questions
What metrics should an email marketing dashboard track?
Track delivered volume, bounce rate, spam complaint rate, unsubscribe rate, unique clicks, click rate, conversions, revenue and revenue per recipient, split by campaigns and flows. Add list growth by source. Keep open rate in a secondary view because Apple Mail Privacy Protection inflates it.
Can Data Studio connect to Klaviyo or Mailchimp?
Not natively. Data Studio connects natively to GA4, Google Sheets and BigQuery, and ESP data comes in through partner connectors from vendors such as Supermetrics, Windsor.ai or Porter Metrics, or through a BigQuery pipeline. Check that the connector supports your ESP and the fields you need before you buy.
Why is Klaviyo revenue higher than GA4 email revenue?
Klaviyo uses last-touch attribution with default 5-day windows for both email opens and clicks, so it can credit a sale to an email the customer only opened. GA4 only counts tagged visits from email and applies its own model across all channels. Show both, and use store or CRM revenue as the total.
Are email open rates still useful?
Only with care. Apple Mail downloads email content in the background by default when Mail Privacy Protection is on, so opens are recorded even when nobody reads the email. Use filtered opens where your ESP offers them, and rely on clicks and revenue per recipient for decisions.
What spam complaint rate is acceptable for Gmail?
Google's sender guidelines ask senders to keep the spam rate reported in Postmaster Tools below 0.30% and recommend staying below 0.10%. Senders of 5,000 or more messages a day to Gmail must also authenticate with SPF, DKIM and DMARC and support one-click unsubscribe.
How do I make GA4 recognise traffic from my emails?
Tag every link with utm_medium=email and a consistent utm_source such as your ESP's name. GA4's default channel group places a session in Email when the source or medium matches email or a close spelling variant. Most ESPs can add these tags automatically in their settings.
Can an agency white-label email marketing reports for clients?
Yes. In Data Studio you control the theme, logo, colours and layout, and clients view reports free because viewers never need a Data Studio Pro licence. A master template copied per client keeps metric definitions identical across accounts.
Keep reading
Related pages
Get started
Tell us what your reporting has to do
Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.
- Free 30-minute reporting review
- Fixed quote before any work starts
- Everything built and owned in your Google account
Prefer email? info@greenwolftechlabs.com
Get a free proposal
Two lines is enough to start.