Listing, grouping, and counting duplicate email addresses in the Marketo UI

I put myself on the “no code needed” side of a friendly Community debate the other day, so this is a chance to prove I'm not always shoving people toward Velocity or JavaScript.

The requirement is a single report with:

  1.  the list of email addresses linked to more than one lead
  2.  the count of how many addresses are duplicated (i.e. simple row count of the above, without having to export + count separately)
  3.  the count of how many times each address appears (how many potential dupes there are for each email)

You can get this done with a Lead Performance report and a nested Smart List.

First, the Smart List, which simply uses the Duplicate Fields filter:

ss
ss

Next, the Lead Performance report, which groups by Email Address:

ss

And filters by Member of Smart List, nesting the Smart List above:

ss

And there you have it:

ss

In case it's not clear what's what in the output, here's the screenshot with some callouts:

ss

You can add even more visibility by creating other Smart Lists with mutually exclusive filters, like Lead was Created with a [Source Type is] constraint:

ss

Then add those to the report as custom columns:

ss

And you've got more background on your dupes:

ss

That's it!