03-09-2020, 06:03 PM
I need identify and remove leads duplicates.
in my case, duplicates occurs because other app ( digital marketing ) like as RD Station, Facebook, site, etc, I means visitor normally access more than one, channel, and is common too, at first moment, lead include, less data, and when him get more information, fells more trust to complete more data, like as phone number
In fact at first moment, lead fill your first name and email
But when I try removed duplicates, occurs two situation
1) System considering blank, or null with a valid information, and remove ALL leads with email is blank ( no value )
2) If there a lot of registries in lead, ( about 20000 or more ), transaction is too long, all system performance is affected
I suggest, a way system not removed registries with blank value and possibility chose maintain newer registry ( removed older similar registries )
in my case, duplicates occurs because other app ( digital marketing ) like as RD Station, Facebook, site, etc, I means visitor normally access more than one, channel, and is common too, at first moment, lead include, less data, and when him get more information, fells more trust to complete more data, like as phone number
In fact at first moment, lead fill your first name and email
But when I try removed duplicates, occurs two situation
1) System considering blank, or null with a valid information, and remove ALL leads with email is blank ( no value )
2) If there a lot of registries in lead, ( about 20000 or more ), transaction is too long, all system performance is affected
I suggest, a way system not removed registries with blank value and possibility chose maintain newer registry ( removed older similar registries )
Ranieri
eCRM Web
eCRM Web