Counting Unique Companies in a Database of Contacts

·

Team: how do I count unique records in a column? I have a database of contacts, and I want to know how many unique companies are represented. Thanks!

Channeled
APP
·
·
You can count unique companies in your database using two approaches: 1. Using the Count Occurrences integration: • Select your company column as the input • Enable the "Case-Insensitive" option to ensure accurate counting • The results will show you how many times each company appears 2. Using the Normalize and Deduplicate integration: • Input your list of company names • Enable "Remove empty values" if needed • This will give you a clean list of unique companies without duplicatesFor more precise counting, you can also use the Lookup Multiple Rows feature to scan your table for specific company identifiers like domains or names. Sources: Count Occurrences of Items with Clay Normalize and Deduplicate a List with Clay
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.