Clay Icon

How to Calculate Job Duration on LinkedIn Profiles for Enriching Emails

ยท
ยท

Happy New Year to the amazing Clay team! I'm looking to enrich my email with the latest job duration on Linkedin profiles. The issue is that it captures the "start date" which doesn't correspond to the Linkedin duration (when start date is on the 1st, it returns 1 month less than the actual duration, when start date is on the 31st,30th,28th, the result is 2 months less than the actual duration). I'm using Claygent (AI Web Scraper) + a formula to convert the result for "start date" to a duration (ex. 2 years and 3 months). I tried to prompt it but didn't work. Maybe I should just scrape the duration with AI (but it burns openAI credits...) Any ideas?

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Hey Alois, thanks for reaching out and appreciate your patience! Happy new year!!

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    I'll record a quick video and show an example with the formula generator in case that would help your use case too.

  • Avatar of Clay Team
    Clay Team
    APP
    ยท
    ยท

    Here's how to calculate a person's total years of experience with the AI formula generator. You can also modify this to calculate the total amount of time in just their current role if needed - ยญยญhttps://www.loom.com/share/e05b071f35e14a288306f72ec6724ea1