"Leads by Month" report that shows "Lead Owner"

[Anonymous]

Hi,

I am trying to generate a report that shows leads that were pushed to sales + the lead owner.

I managed to set up a respective report sorted by Comany Name but cannot figure out how to change this to Lead Owner, for in the report setup there is no option "Group Leads by LEAD OWNER".

Maybe someone knows a workaround to this.

Best,
Christine

[Anonymous · Accepted solution]

Christine, 

The Lead Performance Report doesn't let you group leads by lead owner, but there is a workaround:

1) Create a smart list for each lead owner with the criteria "Lead Owner Email Address is {Somebody@usp.at)"
2) In the report setup, add "Custom Columns"
3) in the popup, enter the name of each smart list. 
4) these smartlists will now show a count in a unique column for each lead owner

I'd group the leads by month so you can see a trend of leads assigned to each owner over time.

-Steven

[Anonymous]

Steven, you are a GENIUS; thanks so much!

Cheers,
Christine