Tare

Weigh your Marketo database

A Marketo contract is sized by the people in your database. Tare counts the ones no campaign can reach: unsubscribed, bounced, duplicated, junk, and long gone.

The file is read in this browser tab and is never uploaded. No export to hand? .

Weigh ticket

Example

31% tare

GrossRecords your contract counts
412,300
Cannot be emailed
61,845
Duplicates
12,369
Test and junk
8,246
No activity in 12 months
45,353
TareRecords nobody can use
127,813
NetPeople you can reach
284,487

An example with invented numbers. Yours prints here.

What counts as tare

Tare is the weight of the container. On a scale you subtract it to find out what you are actually carrying. Here it is every record that takes up room in your database and can never answer a campaign.

Cannot be emailed
No email address, or Unsubscribed, Email Invalid, Blocklisted, or Marketing Suspended is true.
Duplicates
Every record after the first that shares an email address, ignoring capitals.
Test and junk
Disposable and reserved domains such as mailinator.com and example.com, addresses like test@ and asdf@, and names that are only digits or a link. The list is short on purpose: a real person wrongly called junk is worse than a junk record missed.
No activity in 12 months
Can be emailed, is none of the above, was created more than a year ago, and has not been touched since. If your export only has Updated At, a CRM sync counts as a touch, so the real number is higher.

Each record is counted once, in the first group it falls into, so the lines on the ticket add up.

Getting the export out of Marketo

  1. Open Database and select All People, or any smart list you want to weigh.
  2. On the People tab, choose or create a view with these columns: Email Address, First Name, Last Name, Unsubscribed, Email Invalid, Blocklisted, Marketing Suspended, Created At, Updated At.
  3. Use the export button under the list and choose Visible Columns. Pick CSV if Marketo asks for a format.
  4. Download the file when Marketo says it is ready, then drop it at the top of this page.

Tare finds the columns by their names and shows you what it matched. A column you leave out is not an error. That group is left off the ticket and the ticket says so.

Where your file goes

Nowhere. This page is a set of plain files with no server behind it. Your browser opens the export, counts it in memory, and forgets it when you close the tab. Tare keeps totals only. Names are read to spot junk, such as a first name that is a link, and are not kept.

You can check this yourself: load the page, disconnect from the internet, then run it.

What a lead export cannot show

The export is the database. It says nothing about what runs on top of it: programs that have sat idle for a year, forms that no page uses, custom fields that no smart list or form reads, smart lists that repeat each other, and campaigns still running inside archive folders.

The full audit reads those through a read-only API user that you create and can switch off at any time. You get a written report with a fix list, in the order worth doing.

Ask about a full audit