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.