Hi, I want to find the headquarters of the companies in a table and see if the person's location is within 60 miles of the headquarter location of the company.. any help on how to do that?
To find company headquarters and check proximity to people: 1. Create a table with companies using the Find Companies source 2. Add location filters if needed during setup 3. Create a second table with people using Find People 4. Clay automatically links your company and people tables 5. Use a formula column to calculate the distance between headquarters and person locations The linked tables feature lets you reference company data (including HQ location) in your people table for distance calculations.
https://app.clay.com/workspaces/285114/workbooks/wb_0sxf6f3tQWBfgxFNEbU/tables/t_0sxf7cuBqstxEZCnskF/views/gv_0sxf7cvg3XUqbamr3yh For this table, I want to know the following - Confirm person is still in the role.. I got to know about their new roles through the job change event log but I want to have a full table (including ones who changed and those who not).. how do I do that as I want to take collective actions on both of them. In this case, there are 129 roles and 40 have changed jobs so I want to have a table with all 129 but obciously with all the new information as I am displaying here for the ones who changed jobs.. how do I do that? Part 2 is I want to find the headquarters of the companies in a table and see if the person's location is within 60 miles of the headquarter location of the company.. any help on how to do that?
For the first part — to get a full list of all 129 people with updated job info — use a Lookup from your current table to the job change table, matching by something like LinkedIn URL. This will bring in the new job details for anyone who’s changed roles, and you’ll still keep the full list of all contacts. For the second part — to check if someone is within 60 miles of a company’s HQ: 1. Use Claygent or an enrichment like Find Company Headquarters to get the company’s HQ location. 2. Use the Find Distance Between Two Locations enrichment to compare the person’s location and the company HQ. Let me know if you have more questions.