Converting a lead to a customer

[Former Member]

Hi All,

Is there any way we can get a list of all customers that were converted from a lead at a given point of time. Maybe some kind of a query or a report?

Regards,

Payal

[Former Member]

Hi Payal,

You may try from here to start:

SELECT DIstinct T0.CardCode, T0.CardType, COUNT(CardType)

FROM dbo.ACRD T0

WHERE T0.CardType IN ('L','C')

Group By T0.CardCode, T0.CardType

ORDER BY CardCode

Thanks,

Gordon