Clay Icon

Scraping Keywords in Column for CRM Mentions in Job Descriptions

ยท
ยท

Does anyone know how to scrape info within a column for certain keywords? EG - I searched for specific open jobs, and then pulled matching job descriptions into a new column. Now I want to see if the job description mentions a specific CRM. Thanks in advance.

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

    Hi Joey W., happy to help!

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

    if you navigate to enrich data and search up 'keywords' in the search panel, you should see na option to "Find Keywords"

    7ec33008-ad90-48ba-a516-a53141d511e4.png(223 kB)
  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    this lets you indicate the keyword you're looking for as well as the cell in which it can be found

  • Avatar of Joey W.
    Joey W.
    ยท
    ยท

    Thanks! I gave it a go and had some success, but often it's saying there's a missing input - even though the column it's supposed to be searching is populated. Any ideas where I could be messing up?

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

    Joey W., can you send me a link to this table?

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

    Joey W. which description column would you like to check for keywords in? I see that there are a couple on your table and you might have accidentally pulled in the wrong one into the 'Find Keywords' enrichment. I reprinted the descriptions from the 'Find Active Job Openings' column and ran a keyword search on it (the last 2 columns on your table). I would check to make sure that you're referencing the correct target column in your enrichment panel

  • Avatar of Joey W.
    Joey W.
    ยท
    ยท

    Ahh yes, that makes sense. Thanks for your help! ๐Ÿ™‚ ๐Ÿฆธ