A weekly numbers email that fills itself in. KPI scorecards and charts read your own data each time the email is sent, so Monday's digest shows Monday's numbers, for the whole team or for each reader's own slice.
The usual weekly digest is a screenshot of a dashboard, pasted in by someone with better things to do. In MailInApp you build the digest once and connect it to where your numbers live. From then on, every send reads the figures again.
Start from a Dashboard starter
When you create the email, pick Dashboard. Three starters lay out the report for you, with example numbers in every block:
- Weekly performance: three scorecards (revenue, new sign-ups and conversion rate) above a bar chart.
- Monthly executive summary: the same scorecards with a revenue trend, a few lines of comment and a poll on what to look into next.
- Support team digest: tickets closed, average response time and open backlog, tickets closed by day and a poll on next week's focus.
Rename the labels to what your team tracks, then connect the data.
Connect your numbers
Your figures can come from three places, each added in the studio's Data panel with the role Repeat rows:
- A Google Sheet. Import table → Google Sheets Link reads one tab of your sheet, and Sync now brings in your latest changes before a send. See Hosted tables.
- A table in MailInApp, kept up to date by your team or your own tools.
- Your own system or CRM, read fresh on every send. Salesforce connects this way, with a step-by-step guide.
Bind each block
Each scorecard and chart has a Bind to data section. Pick the connected source, then:
- KPI scorecard: a Value field and how to add it up: Sum, Average, Count or Latest row. The small trend line follows the same rows.
- Bar chart and Line chart: Group by a field, such as week or region, with up to three series.
- Pie chart: shares of a whole, such as revenue by channel.
You set a scorecard's arrow with Previous value and Trend direction, so a rise in cancellations can show in red. The full walk-through is Binding charts to real data.
Every reader gets the figures in every inbox: each chart is a sharp picture with the same figures in a table under it.
Each reader's own numbers
Filter rows (optional) narrows the rows a block adds up, and it can compare a field with the reader's own data. With region equals {{region}}, one email shows each regional manager their own region, and the scorecard at the top becomes "your revenue". See A different slice for each recipient.
Send it every week
Set up a weekly recurring send at the hour you choose and tick Send to everyone who matches on every run. Each run reads your data again and mails the whole list that week's numbers. A daily send works the same way for a morning dashboard, and a monthly summary goes out from the Send tab at the start of each month.
Each email keeps the figures from the moment it was sent, and the live view shows the latest figures each time a reader opens it.
Hear back from the team
To learn what the team makes of the numbers, add a Poll under them, as the Monthly executive summary does, and show the results after voting. Each email records one vote per reader, so a new question each month goes in that month's own copy.
A chart can also plot what your emails collected. Under Bind to data, A campaign's response results draws a poll, rating, question, assignment or quiz from one of your emails, and the live view keeps it current as answers arrive.
Getting started
Create an email with the Dashboard purpose, connect your sheet or system in the Data panel and bind each KPI scorecard and Bar chart under Bind to data. Then schedule a weekly recurring send to everyone on the list.
