Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Troubleshooting Keyword Search for Competitor Identification | Clay

Troubleshooting Keyword Search for Competitor Identification

·Aug 11, 2025 04:25 PM·

am trying to check if prospects work at a competitor and the formula is not working properly, says everyone is a competitor. Im using a keyword search https://app.clay.com/workspaces/489571/workbooks/wb_0szjxxu4W5wgRtmQFFs/tables/t_0szjy0wk9YdEDjERbYX/views/gv_0szjy0wrMCfPaSkwzPz

Loading attachments

6 comments

· Sorted by Oldest

Clay
APP
·
·
Your keyword search is likely too broad, marking everyone as a competitor. Use the NOT operator (!) to exclude competitors instead. Try this formula structure: !{{competitor_column}} to identify prospects who are not competitors. For more precise filtering, combine conditions like: ({{employee_count}} > 500 AND {{location}} == "US") OR !{{competitor}} - this qualifies leads who either meet specific criteria OR are not competitors. Review your keyword parameters to ensure they're not overly inclusive.
Sources: Logical operators | Documentation | Clay University Logical operators | Documentation | Clay University
Garrett W.
·
·
https://app.clay.com/workspaces/489571/workbooks/wb_0szjxxu4W5wgRtmQFFs/tables/t_0szjy0wk9YdEDjERbYX/views/gv_0szjy0wrMCfPaSkwzPz
Mitch Howard
APP
·
·
Hey Garrett! Looks like you are looking for some help with that formula, let me take a look and see how I can help!
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.
Garrett W.
·
·
Loading attachments
Garrett W.
·
·
both of these columns