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?
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
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.
I'm looking to get this report for a specific list and not the whole database.
So just use the smartlist in the people performance report to filter in the correct people
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