Hey there party people -- curious if anyone has found a better way of loading accounts lists from big exports into TAM tables without a bunch of duplicates and stuff? Made this workflow to solve this for myself today. Happy to put the scripts in a public github and share if anyone would find it useful https://www.linkedin.com/posts/maxthilen_revops-salesops-automation-activity-7328100867058905090-q5Ou
To load account lists from large exports into TAM tables without duplicates, you can use several Clay features: 1. Use the "Lookup" integration to check if records already exist in your tables before adding new ones. This helps prevent duplicates by verifying if specific records exist in other tables. 2. The "Normalize and Deduplicate a List" integration standardizes data formats and removes duplicate entries, improving data quality and consistency. 3. For managing large imports, use the "write to table" integration to map data properly: • Select your Clay account • Choose a destination table • Map your source data to appropriate columns • Use conditional runs to control when data is added 4. Set up conditional runs to only process new records, saving credits by avoiding duplicate enrichments. 5. When importing from other systems, create separate columns for each field you want to integrate to ensure proper data mapping. The "write to table" feature is particularly useful for mapping list data into rows for another table, helping organize your imported accounts efficiently.