Report: Leads by Country

[Anonymous]

There may be a simple solution that I might be trying to overthink.

I'm looking to create a report that shows the count of leads by country in a specific list. The only way I can think of doing this is to export the list and create a pivot table in Excel. Can't find anything in Revenue Explorer. Is there a way to create this report so I don't have to run this manually?

[Anonymous]

Yes, this is doable in a standard report.

1)  Create a people performance report

2) at the smart list tab, select your list(s)

3) at the set up tab select group by:  Country

Viola

[Josh_Hill13]

In RCE you can certainly run a Lead Analysis report by Country, just group by Country and use LeadID or Lead Email as a count.

[Anonymous]

I'm looking to get this report for a specific list and not the whole database.

[Anonymous]

So just use the smartlist in the people performance report to filter in the correct people

[Anonymous]

Also. if it doesn't show up on RCE, make sure that the sync status of the field to RCE is enabled. You can do this through Admin > Revenue Cycle Analytics > Custom Field Sync