This content has been marked as final. Show 4 replies
One solution is to use an Opportunity Analysis report with the Lead Source attribute. Please see example screenshot below.
To avoid double counting opportunities, the opportunity "credit" is split equally. That is why the report shows fractions. For example, Blog is only getting 1/3 of the credit for the first opportunity because out of the three leads/contacts associated to this opportunity only one came from Blog. The other two came from other Lead Sources.
One last tip when you create this report: Don't forget to put a time filter first, e.g. Opportunities Created Month = November 2013. This will limit the data and give you better performance while you customize your report. Once the report is configured the way you want it, you can increase the time frame and let it run.
Where is this pulling Lead Source from? I tried this but the Lead Source is not matching the values in Salesforce. That was what I was looking for.
This is the Lead Source field in Marketo, which contains all the lead source values of all leads including those not synched to Salesforce. It's typically mapped to the LeadSource fields in Salesforce as shown below.
If you're still seeing discrepancies, please contact us at email@example.com and we'd be happy to help you.
Ok Ill file a ticket. There are Lead Sources on this list that I have never heard of and dont see any record for in Salesforce. Thanks