How to Limit Employee Outreach by Company in a Table

Hey! Has anyone figured out if you have a large list and you want to make sure you only reach out to a certain nr of employees per company - how to do that in a tble? I know you have a function to chose the nr of people to import but what if its from another source that you have imported .

6 comments

Channeled
APP
·
·
You can use the "Lookup Multiple Rows" integration to manage the number of employees per company in your table. This integration allows you to: 1. Scan a column for identifying company information (like domain, name, or LinkedIn URL) 2. Count how many cells match that value 3. Use conditional formulas to control which prospects you reach out to based on the company countThis works both within the same table or across separate tables, giving you flexibility in managing your outreach limits per company.
Channeled
APP
·
·
Is that what you were looking for?
Louis (.
·
·
how would those formuals look like?
Channeled
APP
·
·
You can use the "Lookup Multiple Rows" integration to create formulas that control employee outreach per company. Here's how to set it up: 1. First, use the Lookup Multiple Rows integration to scan your table for matching company identifiers (like domain, name, or LinkedIn URL) 2. Count the matches for each company using this integration 3. Then create conditional formulas to: • Filter prospects based on the company count • Control which prospects you reach out to within each companyFor more detailed guidance on setting up these conditional formulas, you can check out the AI Formulas & Conditional Runs video in our Clay University.
Channeled
APP
·
·
Did that answer your question?
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.

How to Limit Employee Outreach by Company in a Table | Clay