Interactive Email for Sales Leaderboards

Connect the sheet or CRM that holds your sales, and a bar chart ranks the reps by revenue or deals won each time the email goes out. A scorecard gives the team's total, and each rep's copy can open with their own number.

Subject

This month's sales leaderboard

Rank your reps from your own sales data, fresh on every send. A bar chart puts the top seller first, a scorecard gives the team's total, and each rep's copy can open with their own number.

A leaderboard motivates when it's current and everyone sees it. Rebuilding one from a CRM export every Monday is the part that slips. Build it once in MailInApp, connect it to where your deals live, and each send reads the latest figures.

Connect your sales data

Add the source in the studio's Data panel with the role Repeat rows:

  • A Google Sheet of deals or rep totals, through Import table → Google Sheets Link. Click Sync now after you update it.
  • Your CRM, read fresh on every send. Salesforce has a step-by-step guide, and any system with an API connects the same way.

Rank the reps

Add a Bar chart, turn on Horizontal bars so names read easily, and under Bind to data set:

  • Group by: the rep's name, so each rep gets a bar.
  • Series 1 field: the deal amount with Sum for revenue, or Count for deals won.

A second series can show each rep's target beside their revenue. The bars keep the order of the rows they come from, so rank them in your source: a sheet tab with one row per rep, sorted from the top, gives a ranked chart of up to 24 reps.

Filter rows (optional) keeps the chart to what counts, such as won deals. With team equals {{team}}, each manager's copy ranks their own team.

The total and each rep's own number

A KPI scorecard bound to the same rows gives the team's total at the top. Add a second one with Filter rows set to the reader, such as owner_email equals {{email}}, and each rep's copy opens with their own revenue. See A different slice for each recipient.

Every rep gets the ranking in every inbox: the chart is a sharp picture with the same figures in a table under it.

A contest scored in points

For a sales contest with its own scoring, the Standings table ranks rows by points and puts 🥇🥈🥉 on the top three. Type one row per rep with their Points, turn off Show draws column, and Highlight team shows one name in bold on a tinted row.

Send it every week

A weekly recurring send with Send to everyone who matches on every run mails the whole team the latest ranking at the hour you pick. To crown a contest's winner, send the final ranking once from the Send tab.

Getting started

Connect your sales sheet or CRM in the Data panel, bind a horizontal Bar chart grouped by rep and a KPI scorecard for the total, then schedule a weekly recurring send. The full guide is Binding charts to real data.

A typical build-and-send sequence

  1. 1

    Connect your sales data

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

  2. 2

    Rank the reps

    Bind a bar chart: Group by the rep's name, with the Sum of the deal amount, and turn on horizontal bars.

  3. 3

    Add the totals

    Bind a KPI scorecard to the same rows for the team's total, and filter a second one to the reader for their own figure.

  4. 4

    Send it every week

    A weekly recurring send mails the whole team the latest ranking at the hour you pick.

Frequently asked questions

Where do the figures come from?

From your own data, read at each send: a Google Sheet, a table in MailInApp or your CRM. Salesforce connects with a step-by-step guide, and any system with an API connects the same way.

How are the reps ranked?

In the order of your rows. Give the chart one row per rep, sorted by the number that counts, and the top seller gets the first bar.

Can each rep see their own number?

Yes. Filter a KPI scorecard's rows to the reader, such as owner email equals {{email}}, and each rep's copy opens with their own revenue above the team ranking.

Can I run a contest scored in points?

Yes. The Standings table ranks rows by points and puts 🥇🥈🥉 on the top three. You type the rows, so it follows your contest's own scoring, and Highlight team shows one name in bold.

Does every rep see the ranking?

Yes. Every reader gets the ranking in every inbox: the chart is a sharp picture with the same figures in a table under it.

Build this in the studio

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