Improving Title Matching Functionality in Clay for ICP Analysis

Garrett W. · 2025-08-20T07:21:35.151Z

bit of a crazy question on checking titles in clay i am running a formula on website visitors to check if titles match ICP titles (photo 1) the formula it ends of returning is photo 2 however, partner and design director contains the substring "engineer" which is a matched word is there not better functionality in clay for this? im like kinda surprised that this is all the support team is recommending OR to use AI, when this feels like there should be more native "check if this is an included title" functionality out of the box. lmk what yall think or if im missing something big!!

Improving Title Matching Functionality in Clay for ICP Analysis | Clay

11 comments

· Sorted by Oldest

Smit V.
·
·
Hi Garrett, thank you for reaching out!
You probably should be able to use formula to do this task, do you mind sending the link (url) to the table so we can take a look?
Loading attachments
Garrett W.
·
·
someone in a community recommended using regex which is much better https://app.clay.com/workspaces/489571/workbooks/wb_RgSGDqsqiv5b/tables/t_8KcyfCUVFHVX/views/gv_e2gNppr8CjvM
Garrett W.
·
·
!!({{Title}}?.toLowerCase().match( /\b(founder|co[\s-]?founder|cto|chief technology officer|swe|software engineer|full stack engineer|backend engineer|data engineer|database engineer|principal engineer|staff software engineer|principal software engineer|engineering team lead|vp of engineering|engineering vp|senior software engineer|software engineering manager|founding engineer|founding software engineer|engineering lead|lead engineer|software developer|full stack developer|backend developer|staff software developer|principal software developer|founding software developer|data scientist|member of technical staff|mts|director of engineering|head of engineering|vp of technology|analytics engineer|head of data|vp of data|director of data|data platform lead|data infrastructure engineer|product engineer|devops engineer|head of product|software architect|business intelligence|product manager)\b/ ))
Garrett W.
·
·
but still surprised there isnt better support for this tbh
Smit V.
·
·
Hi Garrett, thank you for reaching out!
You probably should be able to use formula to do this task, do you mind sending the link (url) to the table so we can take a look?
Loading attachments
Smit V.
·
·
Thanks for sharing! We do have a 'Find Keywords' native action which you can run, I added an example column in the table that could help.
For these kind of tasks formulas are the best way to go about it as it gives you much more flexibility and in the natural language you can always mention that use regex and that will give you much more control over it.
Loading attachments
Smit V.
·
·
Thanks for sharing! We do have a 'Find Keywords' native action which you can run, I added an example column in the table that could help.
For these kind of tasks formulas are the best way to go about it as it gives you much more flexibility and in the natural language you can always mention that use regex and that will give you much more control over it.
Loading attachments
Smit V.
·
·
Thanks for sharing! We do have a 'Find Keywords' native action which you can run, I added an example column in the table that could help.
For these kind of tasks formulas are the best way to go about it as it gives you much more flexibility and in the natural language you can always mention that use regex and that will give you much more control over it.
Loading attachments
Smit V.
·
·
Apologies for the multiple replies, it seems like a tooling problem
Garrett W.
·
·
lolol nw
Smit V.
·
·
Thanks for sharing! We do have a 'Find Keywords' native action which you can run, I added an example column in the table that could help.
For these kind of tasks formulas are the best way to go about it as it gives you much more flexibility and in the natural language you can always mention that use regex and that will give you much more control over it.
Loading attachments

Smit V.
·
·
Hi Garrett, thank you for reaching out!
You probably should be able to use formula to do this task, do you mind sending the link (url) to the table so we can take a look?
Loading attachments
Garrett W.
·
·
someone in a community recommended using regex which is much better https://app.clay.com/workspaces/489571/workbooks/wb_RgSGDqsqiv5b/tables/t_8KcyfCUVFHVX/views/gv_e2gNppr8CjvM
Garrett W.
·
·
!!({{Title}}?.toLowerCase().match( /\b(founder|co[\s-]?founder|cto|chief technology officer|swe|software engineer|full stack engineer|backend engineer|data engineer|database engineer|principal engineer|staff software engineer|principal software engineer|engineering team lead|vp of engineering|engineering vp|senior software engineer|software engineering manager|founding engineer|founding software engineer|engineering lead|lead engineer|software developer|full stack developer|backend developer|staff software developer|principal software developer|founding software developer|data scientist|member of technical staff|mts|director of engineering|head of engineering|vp of technology|analytics engineer|head of data|vp of data|director of data|data platform lead|data infrastructure engineer|product engineer|devops engineer|head of product|software architect|business intelligence|product manager)\b/ ))
Garrett W.
·
·
but still surprised there isnt better support for this tbh
Smit V.
·
·
Hi Garrett, thank you for reaching out!
You probably should be able to use formula to do this task, do you mind sending the link (url) to the table so we can take a look?
Loading attachments
Smit V.
·
·
Thanks for sharing! We do have a 'Find Keywords' native action which you can run, I added an example column in the table that could help.
For these kind of tasks formulas are the best way to go about it as it gives you much more flexibility and in the natural language you can always mention that use regex and that will give you much more control over it.
Loading attachments
Smit V.
·
·
Thanks for sharing! We do have a 'Find Keywords' native action which you can run, I added an example column in the table that could help.
For these kind of tasks formulas are the best way to go about it as it gives you much more flexibility and in the natural language you can always mention that use regex and that will give you much more control over it.
Loading attachments
Smit V.
·
·
Thanks for sharing! We do have a 'Find Keywords' native action which you can run, I added an example column in the table that could help.
For these kind of tasks formulas are the best way to go about it as it gives you much more flexibility and in the natural language you can always mention that use regex and that will give you much more control over it.
Loading attachments
Smit V.
·
·
Apologies for the multiple replies, it seems like a tooling problem
Garrett W.
·
·
lolol nw
Smit V.
·
·
Thanks for sharing! We do have a 'Find Keywords' native action which you can run, I added an example column in the table that could help.
For these kind of tasks formulas are the best way to go about it as it gives you much more flexibility and in the natural language you can always mention that use regex and that will give you much more control over it.
Loading attachments