Pull Company Data into People Table for Industry Insights

Josephine V. · 2025-04-17T09:59:34.326406+00:00

if I have pulled people from a company table, using 'find people at these companies' is there a way to pull other data from that original company table into the people table such as the industry and sub vertical of their company

Yes, you can pull data like industry and sub-vertical from the original company table into your people table. When you use 'find people at these companies', Clay automatically creates a lookup column in your Find People table that links to the Find Companies table. This lookup column allows you to extract company attributes directly into your Find People table. To pull the data: 1. Locate the lookup column in your Find People table. 2. Click on the column header and select "Add as column" for the specific attributes you want (e.g., industry, sub-vertical). 3. If you've added new company data later, simply rerun the lookup in your people table to refresh the information. This method saves data credits and creates an integrated dataset combining individual and company information.

Sources: Find People [Clay 101] - Clay University Enrich People (Waterfalls) [CRM Enrichment] - Clay University Write to Table [Clay 101] - Clay University

2 comments