I have a list of companies in another table. i have list of people in another table. can i populate my fields in the people table (extracted from a csv) and pair with the company table and populate my fields?
Import your CSV to the people table:
1. In your people table, click Actions
→ Import
2. Select Import from CSV
and upload your file
3. Map CSV columns to Clay table fields
4. Click Add to table
Link with company data:
Clay automatically links Find Companies and Find People tables, allowing you to extract company attributes directly into your people table. You can pull enriched company data (tech stack, revenue, location, etc.) into your people table using lookup columns.
When you add new company data later, simply rerun the lookup column in your people table to sync updated information.
no it doesn't work
if you want fields from the column table to show up in the people table, you will have to use "Clay Lookup Single Row in Other Table"
the idea would be to have a joining key (say the linkedin url of the company) show up in both tables
and then you use the "Lookup" function to bring fields from the company table to the people table
i have the linkedin company url in both tables but can't match it
actually it still doesnt work
you wanna dedupe users or companies? Is this dataset imported by Clay or did you upload a cSV?
users
its a csv
dedupe on their linkedin url
if you don't have it, then their email
if you don't have that, then a concatenation of their full name and company ULR
what makes you think it's not accurate?
is linkedin url unique?
yes
i didn't know that
there's one exception: each linkedin user can have two linkedin urls: a linkedin url with an id and a linkedin url with a name: so this is mine: https://www.linkedin.com/in/adilaijaz/, but there might be a user id tied to me so another url for me might be https://www.linkedin.com/in/12345678. In that corner case, it won't work well. Generally though this is not an issue since most of the times you have a user friendly linkedin url for someone.
yeah, you can create a separate company table with the linkedin URLs of the companies you don't wanna target. Then in your people table, you can look up if the company this person belongs to exists in that "do not contact" table
Hey - Thanks Adil!!! :) Let me know if you have more questions