Looking to build a report that shows the advancement of leads by sales person... | Community
Skip to main content
Rachel_Bryan
Level 2
December 21, 2016
Question

Looking to build a report that shows the advancement of leads by sales person...

  • December 21, 2016
  • 1 reply
  • 3060 views

I am looking to build a report that will allow us to see the advancement of leads from lifecycle status to lifecycle status (or even revenue stage to revenue stage) by sales person. The question we are trying to answer is if salespeople are actually changing the the statuses as they work contacts/leads like they are supposed.   Does anyone know what report I could see this information in?

We do have revenue cycle explorer, and I am pretty sure there has to be a way to accomplish this in there, but haven't been able to figure it out thus far.

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

1 reply

Level 4
December 23, 2016

Hi Rachel,

You can create a Model Performance Analysis (Leads) report in RCE and drag over the field 'Lead Owner Name' as a row. After you drag over the different measures (Conversion Ratio All Types is a good start), you will see how many leads your Rep owns have been converting.

An easy place to start is with a prebuilt report in your instance. It can be found here: RCE > Standard Reports > Model Reports > Lead Conversion Report.

Rachel_Bryan
Level 2
January 5, 2017

Hi Wyatt,

Thanks so much for your response.  While this is a good first step, we are really looking to figure out how many leads were moved out of one stage to the next by sales person.  Basically, we want to know if our sales people are moving people along the funnel or not for compliance reasons. 

Does that make sense?


Rachel

Level 4
January 6, 2017

Hi Rachel,

Yes, it makes sense. Any record that is shown by the Conversion measure between MQL > SAL > SQL stage with a Lead Owner populated will show you who is moving leads. Unless a Marketo User is manually moving them between revenue stages and updating the Lead Owner field, this report will show you what you seek. It will be a row for each Lead Owner with a count on each stage for the number of leads moved.