How to identify profiles with duplicate emails

If multiple customer profiles share the same email address, customers can receive the same email campaign several times.

Use this guide to create a simple report that identifies customer profiles with duplicate email addresses.

Instructions

1. Create a Report. In the Metrics section, select Count and customer.

   

   Apply a VALUE FILTER with the condition greater than 1. This step is essential to ensure that only duplicate entries are included in the report output.

2. Apply Drill down by customer attribute email.

   

   If your report returns the Report limit reached error, adjust the Grouping setting in the Drill down section (for example TOP 9999). This error occurs because the output exceeds 10,000 rows, which is the maximum limit for reports.

   

3. The final report uses the Count customer metric with active filters. It also groups rows by the email customer attribute.

   

   In the resulting table, the Email column displays the email value, while the Count(Customer) column shows how many times each email appears in the project - that is, the number of profiles sharing the same email attribute.

   

With this report, you can identify the number of duplicate emails in your project and target these profiles during your next clean-up.