I have a clay table with the following columns: * Event job posting * Company record * Company name * Job title * Location * Company domain * Job LinkedIn URL post on What I wanna do is aggregate this table so that I can see how many roles are being hired by company (domain) to score that an trigger an outbound sequence by company. Essentially a pivot table aggregation. Then I wanna be able to send cold emails to those accounts and reference that number, how I do that? Asking Claude/ChatGPT/Google all refer to some group by column function that doesn't seem to actually exist in Clay.
Use the Lookup Multiple Rows integration to count roles per company domain. This scans your company domain column and counts matching values within the same table. Set up the lookup to reference your domain column, then use conditional formulas to trigger outbound sequences based on the count threshold. You can reference this count directly in your cold email templates using the lookup result column. This replaces traditional pivot table functionality and lets you perform actions on companies meeting specific role count criteria.
Hi Ben, thank you for reaching out! Creating a Pivot Table like aggregation is not something that we can do in Clay, but using the 'Lookup Multiple rows in Other Table' could come in handy here. Also, if you just want to know the job count for each company then there is an alternative way of doing that using the 'Find Active Job Openings' enrichments within a company table. Does this help? Let me know if you have further questions :)
That helps. The find Active Job Oppening enrichment doesn't let you elegantly filter for specific roles does it? It looks like you have to reference a column in the table for specific job titles for that enrichement
You can also put in static values instead of column references.
