I have a data set that includes Emails and LinkedIn Profiles, but than some are missing. Want to enrich only for the missing ones and than add emails and LinkedIn links to only one Column for the ones that are already available and the ones that are enriched.
Here's how you can enrich your dataset and combine the information:1. For missing LinkedIn profiles: โข Use Clay's reverse waterfall enrichment on existing emails to find LinkedIn profile URLs โข Use Mixrank's person enrichment service with email addresses to retrieve LinkedIn profiles 2. For missing emails: โข If you have LinkedIn URLs, use Prospeo to find work emails โข Alternatively, use the "Enrich Person from Profile" feature to get comprehensive details from LinkedIn URLs 3. To combine data in one column: โข First, run the enrichment processes for missing data โข Create a formula column that prioritizes existing data first, then pulls from your enriched data sourcesRemember that match rates may vary, so it's recommended to test the enrichment process on a small sample first to gauge accuracy before applying it to your entire dataset. Sources: Lead Scoring [Clay 101] - Clay University Enrich Person from Email with Mixrank Find Work Email and Enrich Person from LinkedIn URL with Prospeo