How can I find duplicate contacts?

How can I find duplicate contacts?

Merge duplicates

1. On your Android phone or tablet, open the Contacts app .
2. At the top left, tap Menu Merge & fix.
3. Tap Merge duplicates. If you don’t get this option, you don’t have any contacts that can be merged.
4. Optional: If you’d rather choose which contacts to merge: Open your device’s Contacts app .

How do I find duplicate contacts in Salesforce?

Required Editions and User Permissions Choose a contact record. A message tells you if duplicates exist for that record. To see them, click View Duplicates. Choose up to three contact records to merge.

How do I delete duplicate contacts in marketing cloud?

Log in to your Marketing Cloud account and click Audience Builder in the app switcher. Next, click Contact Builder . Then click Contacts Configuration . Navigate to the Contact Delete section and click Enabled .

Which is the best Query Studio for SFMC?

A Query Studio by Salesforce. It is a Marketing Cloud App available in AppExchange that is must-have for anyone interested in working with SQL in SFMC. Think about SQL Server Studio or, if this is not telling you much, a one-stop-shop for writing, validating, checking and saving your queries.

What’s the difference between SQL Server and SFMC?

The main difference from standard SQL (SFMC uses more or less SQL Server 2016) is that SFMC supports only SELECT statement. Neither INSERT, UPDATE or DELETE are officially supported. It is because the queries are executed as a part of the backend query and are limited to provide non-breakable functionality.

Which is a limiting characteristic of SFMC SQL?

Another limiting characteristic of SFMC SQL is visible in the data accessible by queries. Only data stored in data extensions or system data views is available. Moreover, you can save the results only to the data extensions. The reason is other data structures of SFMC are not relational databases.