Our marketing department are looking for a funnel report of our leads current status.
The information should look like any funnel report, but I don't see how I can collect the data.
The values need to be:
Total number of leads created this year.
Total number of leads that moved to the next stage (Contacted)
Total number of leads that moved to the next stage (Q processing)
Total number of Qualified leads (generally a small number)
The first value is easy to collect, but how can I display all 4 in one funnel report/chart?
A lot of the information I need is in the Lead History report
So while the "Field/Event" equals: "Lead Status" I can see the old and the new values.
There should be someway I can calculate these fields, and than display either in a funnel, or even a cumulative bar chart (not ideal)