Get count of leads by a common field value | Community
Skip to main content
J
Jeff_Bedford
Level 2
August 9, 2018
Question

Get count of leads by a common field value

  • August 9, 2018
  • 1 reply
  • 2393 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SanfordWhiteman
SanfordWhiteman
Level 10
August 9, 2018

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.

    J
    Jeff_BedfordAuthor
    Level 2
    August 9, 2018

    Thank you!

    Terms & ConditionsAccessibility statement

    Loading footer...