Interactive Email for Automated Performance Digests

Start from a Dashboard starter, connect the sheet, table or system that holds your numbers and bind each scorecard and chart to it. Every send reads the data again, so Monday's digest shows Monday's numbers, and each manager can see their own team's figures.

Subject

This week's performance digest

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.

Watch: turn a Google Sheet into a data story email

From 149,116 coffee orders on Kaggle to an email that tells their story: import Google Sheets tabs as linked tables, bind charts to them, personalise a chart for each reader, send the answers to a spreadsheet, then read the results in Insights.

A typical build-and-send sequence

  1. 1

    Start from a Dashboard starter

    Pick Dashboard when you create the email. Weekly performance, Monthly executive summary or Support team digest lays out the scorecards and charts with example numbers.

  2. 2

    Connect your numbers

    Add the Google Sheet, table or system that holds your figures in the studio's Data panel, with the role Repeat rows.

  3. 3

    Bind each block

    Under Bind to data, pick the field and how to add it up. Filter rows can narrow it to the reader's own team or region.

  4. 4

    Send it every week

    A weekly recurring send with Send to everyone who matches on every run mails the whole list that week's numbers.

Frequently asked questions

Which blocks can read my data?

KPI scorecard, bar chart, line chart and pie chart read the rows of a connected source and add them up for you. Every other chart, the gauge included, can take its value from a merge tag, such as a figure kept on each reader's contact.

Do readers see the latest figures?

Each email carries the figures from the moment it was sent, and the live view shows the latest figures each time a reader opens it. Every weekly send reads your data again, so each digest starts current.

Can each manager see their own team's numbers?

Yes. A block's Filter rows can compare a field with the reader's own data, such as team equals {{team}}, so one email shows every manager their own team.

Can I send it once a month?

Yes. Recurring sends run daily or weekly, and a monthly summary goes out from the Send tab at the start of each month. It reads your data at that moment, like every send.

Can the digest show answers from my own emails?

Yes. Under Bind to data, A campaign's response results plots a poll, rating, question, assignment or quiz from one of your emails, and the live view keeps it up to date as answers arrive.

Do I need a developer?

Everything is set up in the studio. A Google Sheet or a table in MailInApp is ready in a few clicks, and connecting your own system takes its address and a key.

Build this in the studio

Start on the free plan — every interactive block and the full fallback engine are included on every tier.