Answered by:
Lead Opportunity Conversion Ratio.

Question
-
Hello all,
I want to make one report on Lead-Opportunity Conversion ratio.
so can i find that how many lead are converted to opportunity.
what are the way??
Please suggest me solution if any??
Kartik Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad
Thursday, May 31, 2012 12:14 PM
Answers
-
I thought that things I wrote is enough to build SQL Query. If not - here is it:
select count(*) From FilteredOpportunity Where OriginatingLeadId is not null
Microsoft CRM Freelancer
My blog (english)
Мой блог (русскоязычный)
- Proposed as answer by Andrii ButenkoMVP, Moderator Friday, June 1, 2012 8:48 AM
- Marked as answer by kartik ghodasara Friday, June 1, 2012 8:52 AM
Thursday, May 31, 2012 2:41 PMModerator
All replies
-
Hello Kartik,
Opportunity contains field OriginatingLeadId. In case Lead is converted to Opportunity OriginatingLeadId field contains identifier of lead from which this opportunity was converted.
Microsoft CRM Freelancer
My blog (english)
Мой блог (русскоязычный)
- Proposed as answer by Andrii ButenkoMVP, Moderator Thursday, May 31, 2012 1:19 PM
Thursday, May 31, 2012 1:18 PMModerator -
hi Andrii,
Thanks for your reply.
but how can i find the number of converted lead as i have to create report(chart) i need numeric value.
Kartik Associative Software engineer, Synoverge Tech Pvt. Ltd. Ahmedabad
Thursday, May 31, 2012 1:26 PM -
A pie chart on the status reason should do the job assuming a conversion always creates an opportunity. If this assumption cannot be made what you can do is create a 1:N from Opportunity to Lead i.e. going the other way, create a workflow to populate this lookup when the opportunity is created and then use a filtered view for the graph which strips out those without a lookup link from the lead back to the opportunity.
Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/
or hear me tweet http://www.twitter.com/leontribeWant to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
- Proposed as answer by Leon TribeMVP Thursday, May 31, 2012 2:07 PM
Thursday, May 31, 2012 2:07 PM -
I thought that things I wrote is enough to build SQL Query. If not - here is it:
select count(*) From FilteredOpportunity Where OriginatingLeadId is not null
Microsoft CRM Freelancer
My blog (english)
Мой блог (русскоязычный)
- Proposed as answer by Andrii ButenkoMVP, Moderator Friday, June 1, 2012 8:48 AM
- Marked as answer by kartik ghodasara Friday, June 1, 2012 8:52 AM
Thursday, May 31, 2012 2:41 PMModerator