Skip to main content
A
Anonymous
September 21, 2016
Question

Report: Leads by Country

  • September 21, 2016
  • 3 replies
  • 2196 views

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?

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

3 replies

A
Anonymous
September 21, 2016

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
    Josh_Hill13
    Level 10
    September 21, 2016

    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.

    A
    Anonymous
    September 21, 2016

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

    A
    Anonymous
    September 22, 2016

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

    A
    Anonymous
    September 22, 2016

    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

    Terms & ConditionsAccessibility statement

    Loading footer...