Forum Discussion
Luca2020
5 years agoHelper I
KPI - Lead Conversion Rate
Hi,
I've the folowing table with the name of all of our Customers and Potential Customers (Leads),
| Type | Name | Insert as Lead (Date) | Conversion Lead to Costumer (Date) |
| Lead | xx | 01/01/2020 | |
| Lead | yy | 04/06/2020 | |
| Customer | zz | 25/08/2020 | 05/10/2020 |
| Lead | ww | 12/09/2020 |
In this table there is also the date the name was entered in our database as lead and the date this lead became an actual customer.
I want a measure that show for a specific date (used as filter in the report so it could be a specific month or a from ... to ... date) the conversion rate (N. of inserted leads in this period / N. of converted leads, non necessarelly the same leads)
ES. in the first 10 month of 2020 4 leads were entered and 1 become a customer (25%).
Thanks!
Luca2020 , Please refer to my HR blog, similar kind of problem is addressed
1 Reply
- amitchandakSuper User
Luca2020 , Please refer to my HR blog, similar kind of problem is addressed