How does auto-deduplication work when pushing daily webhook results?

Auto-Deduplication for Daily Webhook Pushes

Clay deduplicates data at insert time by comparing incoming rows against existing records in your destination table.

How It Works

• Compares new records against existing data using a deduplication key (email, domain, ID, etc.)
• Only inserts records that don't already exist in the table
• Example: If Day 1 has 50 results and Day 2 has 52 results with 50 duplicates, only the 2 new records are added

Requirements

• The destination table must be active
• The deduplication key must remain consistent across pushes