Clay Icon

Managing Thousands of Contacts: Optimizing LinkedIn Data Enrichment and Filtering Companies

ยท
ยท

Hi I need some help figuring out a way to do this. I have lists of many thousands (maybe 10k plus) people , where I have an "Expected" current company (in this table it is the col I_Co_Name - when I enrich via LinkedIn, I get a list of experiences (in this case for Ana Paula Gonzalez = 8 ). I need to cycle through the list ( 1 to n) applying some logic a) Does the company Experience n match the expected company in I_Co_Name and if so what was the End_Date and Is Current" b) Does Company Experience n fit some criteria (simplest way is via a look up to another table) [ in broad terms is it a VC/Investor type company]

  • Avatar of Jacob V.
    Jacob V.
    ยท
    ยท

    Can't you just add 8 columns and put 1 company name from each experience in each column. Then it would be pretty easy to some formula fields checking the results against your company name column. Seems simple, what am I missing?

  • Avatar of Ian M.
    Ian M.
    ยท
    ยท
  • Avatar of Ian M.
    Ian M.
    ยท
    ยท

    Jacob V. - thanks for the response. Yes I thought of that, and realised that I would have to allow for the max, which could be n=10. And If I needed the end date, this would use 20 cols. Seemed that I would burn a lot of cols for this "brute force" approach, was hoping for something more elegant.

  • Avatar of Ian M.
    Ian M.
    ยท
    ยท

    Also, how would I write the formula to find the matching col and return an end date, and figure out if it was current?

  • Avatar of Jacob V.
    Jacob V.
    ยท
    ยท

    What's your end goal with all this? Like what is your desired outcome and purpose for this?

  • Avatar of Ian M.
    Ian M.
    ยท
    ยท

    In one section of my app (alternatives.pe) I am storing Name, Email, LI Profile of 1) Founders, 2) Directors 3) Investors in every startup in Southeast Asia I want to use Clay to a) Source this data if I cant get it directly b) make sure that the data I have stays current. ie the desired out come and purpose is to spot people who are no longer with the company that we have them associated with

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Ian, maybe is better if you write all the experiences in a new table using the write to table integration:

    54c73429-440e-4c9f-9864-30b4319625ec.png(43 kB)