Preventing Duplicate Enrichment of Contact Emails in Database Management

Ravi P. · 2024-12-13 14:36:22.938161+00

How do i ensure i don't duplicate the enrichment of a person contact. Lets say from a company table, i have filtered down, and found people there, and then enriched for email. When i filter again in the company table, how do i ensure i do not find that person and add their email again since its on a Person table

Preventing Duplicate Enrichment of Contact Emails in Database Management | Clay

6 comments

· Sorted by Oldest

Channeled
APP
·
·
To prevent duplicate enrichments and save credits, here's the recommended approach: 1. When finding people at companies, use the "write each item to new row in other table" function to extract all results into a separate people table. 2. Use Lookup columns to pull existing data before running new enrichments. This way, you can check if the data already exists in your other tables. 3. When you add new company data to your company table, simply rerun the lookup in your people table. This will pull the enriched company data into your people table without duplicating enrichments.This approach not only saves credits but also creates an integrated dataset that combines individual and company information efficiently. Sources: Guide: Ways to save Clay credits | Clay University [FAQ: Why am I seeing email_not_unlocked@domain.com in Apollo?](https://docs.clay.com/en/articles/9757360-faq-why-am-i-seeing-email%5Fnot%5Funlocked-domain-com-in-apollo) Enrich People (Waterfalls) [Automated Outbound] - Clay University
Ravi P.
·
·
So right now i have multiple people lists in one workbook, can i combine it into one list?
Channeled
APP
·
·
Yes, you can combine multiple people lists within a workbook. Workbooks allow you to manage multiple tables and organize them efficiently. You can: 1. Add multiple tables to a workbook 2. Move tables across workbooks 3. Organize multiple tables within a workbook using reorderable tabsTo combine lists, you can move all your people data into a single table within the workbook. Source: Clay workbooks
Ravi P.
·
·
How to - move all your people data into a single table within the workbook
Channeled
APP
·
·
You can combine your people data into a single table using these methods: 1. Using Import: • Open the destination table where you want to consolidate the data • Click Actions > Import • Add the data to your current table by selecting "Add to current table" > "Continue" • Select the columns you want to add • Click "Add to table" 2. Using Write to Table: • Select your Clay account • Choose your destination table within your workbook • Map the columns from your source table to match the appropriate columns in your destination table • Optionally, you can enable auto-update to automatically sync new rowsRepeat this process for each people table you want to consolidate into your main table. Sources: Write to table integration overview | Clay University Import a File
Channeled
APP
·
·
Hi Ravi P.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

Loading comments

Channeled
APP
·
·
To prevent duplicate enrichments and save credits, here's the recommended approach: 1. When finding people at companies, use the "write each item to new row in other table" function to extract all results into a separate people table. 2. Use Lookup columns to pull existing data before running new enrichments. This way, you can check if the data already exists in your other tables. 3. When you add new company data to your company table, simply rerun the lookup in your people table. This will pull the enriched company data into your people table without duplicating enrichments.This approach not only saves credits but also creates an integrated dataset that combines individual and company information efficiently. Sources: Guide: Ways to save Clay credits | Clay University [FAQ: Why am I seeing email_not_unlocked@domain.com in Apollo?](https://docs.clay.com/en/articles/9757360-faq-why-am-i-seeing-email%5Fnot%5Funlocked-domain-com-in-apollo) Enrich People (Waterfalls) [Automated Outbound] - Clay University
Ravi P.
·
·
So right now i have multiple people lists in one workbook, can i combine it into one list?
Channeled
APP
·
·
Yes, you can combine multiple people lists within a workbook. Workbooks allow you to manage multiple tables and organize them efficiently. You can: 1. Add multiple tables to a workbook 2. Move tables across workbooks 3. Organize multiple tables within a workbook using reorderable tabsTo combine lists, you can move all your people data into a single table within the workbook. Source: Clay workbooks
Ravi P.
·
·
How to - move all your people data into a single table within the workbook
Channeled
APP
·
·
You can combine your people data into a single table using these methods: 1. Using Import: • Open the destination table where you want to consolidate the data • Click Actions > Import • Add the data to your current table by selecting "Add to current table" > "Continue" • Select the columns you want to add • Click "Add to table" 2. Using Write to Table: • Select your Clay account • Choose your destination table within your workbook • Map the columns from your source table to match the appropriate columns in your destination table • Optionally, you can enable auto-update to automatically sync new rowsRepeat this process for each people table you want to consolidate into your main table. Sources: Write to table integration overview | Clay University Import a File
Channeled
APP
·
·
Hi Ravi P.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: