Hello,
We’ve noticed that some users do not follow the standard Salesforce process, which involves creating the opportunity at the time of lead conversion. Instead, they create the opportunity later, directly from the account.
This deviation from the standard flow compromises the reliability of our data, especially when calculating the winrate which becomes inaccurate since the opportunities are not properly linked to the full lead lifecycle.
To address this, we introduced a checkbox called "Created by Lead", which is automatically checked when a lead is created. This flag is then passed down to both the account and the opportunity if they are generated through lead conversion.
We’re trying to build a unified report that includes both converted leads and opportunities created after conversion, while retaining visibility into each opportunity’s origin. However, we're facing difficulties because the joined report lacks common fields that would allow us to correlate the data accurately.
Any suggestions on how to achieve this efficiently?
Divya Chauhan (Kcloud Technologies) Forum Ambassador
Hello @Diana Georgieva
To report on opportunities not created at Lead conversion using the "Created by Lead" checkbox-
1. Custom Report type-
Create a report with Lead as the primary object linking Accounts and Opportunities via "Converted Account" and Converted Opportunity".
Include fields: Lead ID , Converted Date, Account ID, Opportunity I, "Created by Lead" checkbox, and Amount Stage.
Use "with or without " related records.
2. Joined Report:
Use the custom report type with two blocks: Leads(Converted=True) and Opportunities
(Created by Lead=False for direct creations).
Correlate manually using Account ID/Opportunity ID.
3. Filters:
Add date filters(e.g., Converted Data, Created Date) and "Created by Lead" to track origins.
4. Export to Excel for manual correlation or use a formula field.
5. Group by "Created by Lead" and Stage. Use a summary formula(Closed Won COUNT/total COUNT) for win rate.
Add to a dashboard for visualization.