Heads up we created two generic data streams via total connect queries from an SOQL where every row record represents a lead in the Lead data streams and every row represents an opportunity in the opportunity data stream
If I were to look at a given Month (let's say Jan 2025) and I would look at Lead count and Opportunity count to calculate a Lead to Opportunity ratio via Lead Count/Opportunity Count. How is this calculated? Is the percentage off the opportunities that were created out of the leads that were created in the same months or is this independent from when they were created?
Example:
Leads Generated = 10
Opportunities generated (out of the 10 Leads) = 5
Lead to Opportunity ratio = 50%
OR
Leads Generated = 10
Opportunities generated (in total in that month) = 8 (5 from lead generated in January 2025 and 3 from Leads generated in December 2024)
Lead to Opportunity ratio = 80%