Our Marketing are interested to know how long each lead was in each status, from New to Qualified.
Eventually, they want to reduce the numbers to as short as possible.
We have about 5 statuses they are interested in.
I want to create (just like the oppty age) a report that can summarize for each lead, how many days it was in each stage.
The Lead History report type could have what I want. But how can I create a meaningful report form the following?
- assuming I ignore the "Last Transfer Date" -
Taking an example lead
I know the dates it changed status: 2/1, 23/1 and 1/2, but how can I calculate the number of days it was in each status?