How to Count and Group Unique Company URLs in a Workbook

Hey Clay! I'm trying to count the number of unique Company URLs in a workbook and group them by count. What am I doing wrong?

9 comments

Channeled
APP
·
·
To count unique Company URLs and group them by count, you can use the Lookup Multiple Rows integration. Here's how: 1. Create a column for the Company URLs you want to count. 2. Use the Lookup Multiple Rows integration to scan this column. 3. Count how many cells have matching values. To deduplicate and get a unique count: 1. Click on the Company URL column header. 2. Select "Dedupe" from the dropdown menu. For grouping by count, you can use conditional formulas to perform actions based on specific counts. If you need more detailed guidance, consider requesting human assistance by clicking on "Talk to a person".
Channeled
APP
·
·
Did that answer your question?
Muhammad S.
·
·
Clay only has row level memory when you are using formulas. You have to use a lookup multiple rows in the table enrichment and do a lookup in the same table on the domain and it will give you a count grouped by domains. Formulas can not count vertically.
Channeled
APP
·
·
To count unique Company URLs and group them by count in Clay, you can use the Lookup Multiple Rows integration. Here's how: 1. Create a column for the Company URLs you want to count. 2. Use the Lookup Multiple Rows integration to scan this column within the same table. 3. The integration will count how many cells have matching values, effectively grouping them by count. This method works because Clay has row-level memory when using integrations like Lookup Multiple Rows. It allows you to perform vertical counts and groupings that aren't possible with standard formulas. If you need more detailed guidance, you can request human assistance by clicking on "Talk to a person" in your current conversation.
Channeled
APP
·
·
Is that what you were looking for?
Channeled
APP
·
·
Looks like you're still looking for help.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
LuisArturo
·
·
Hey there Kate thanks for reaching out, are you still trying to count the number of times a URL appears in a table? Do you mind sending the link (url) to the table so we can take a look? We do have a workflow that you can use to count the number of times a data point appears in a table, you can use the following video to set it up. https://www.loom.com/share/a39a4569d95244b7886026f3c70812c7?sid=63af9c39-51d9-41a8-b891-0d5c4bad3a80
(52 kB)
Kate M.
·
·
All figured out, Muhammad helped me!
Channeled
APP
·
·
Thank you so much for sharing your feedback Kate M.!