Get count of leads by a common field value

Highlighted
Level 2

Get count of leads by a common field value

Hello Marketo Nation-

Thank you for helping this noob out. I'm doing a data audit and am hitting a bit of a roadblock. In our database, we have a field - let's call it 'Group ID' that ties our lead records to a certain group. The goal is to get a count of leads per group. We have too many records to do an export of all the leads - so I'm hoping there is a mechanism that will help me export or pull a table of this data.

To explain more...

Let's say I have 1M leads that belong to 1000 groups. I'd like to get a table of 1000 rows that show a count of leads per group.

2 REPLIES 2
Highlighted
Level 10 - Community Moderator

Re: Get count of leads by a common field value

There's no way to generate this within the UI.

You'd have to use the Get Leads by Filter Type API (which will actually get the leads, not precompute the aggregate count) then do the count() on the result.

Highlighted
Level 2

Re: Get count of leads by a common field value

Thank you!