how can i ensure that when i do a Salesforce Account Lookup, that the website does a fuzzy match against all variations, such as:
i do not have "Exact match" enabled, so i thought it would already work. but i'm testing and it's not unless it's exact. i'm looking at row 1 in this table thanks!
The Salesforce Account Lookup in Clay uses a “contains” search by default when “Exact Match” is off, but it doesn’t perform fuzzy matching or automatically normalize website URLs (like handling different protocols or trailing slashes). If you need to match variations of a website, you’ll need to preprocess your data to standardize the URLs before the lookup, or use a more advanced method like SOQL with custom logic to handle these variations. [1] [2]
Is that what you were looking for?
When “Exact Match” is off, Clay uses a “contains” search, not a fuzzy match. This means it looks for your search string anywhere within the field, but it doesn’t automatically normalize or match variations like different protocols (http/https) or trailing slashes. If your Salesforce Account Website field has “apple.com” and you search for “https://www.apple.com/”, it won’t match unless the exact string is present. To improve matching, standardize your URLs before the lookup—strip protocols and trailing slashes so both sides use the same format (e.g., “apple.com”). [1] [2] [3]
Did that answer your question?
they are using the same format (see above)
When “Exact Match” is off, Clay uses a “contains” search, not a fuzzy match. This means it looks for your search string anywhere within the field, but it doesn’t automatically normalize or match variations like different protocols (http/https) or trailing slashes. If your Salesforce Account Website field has “apple.com” and you search for “https://www.apple.com/”, it won’t match unless the exact string is present. To improve matching, standardize your URLs before the lookup—strip protocols and trailing slashes so both sides use the same format (e.g., “apple.com”). [1] [2]
Was this helpful?
If you still need help with the Salesforce Account Lookup issue, I’m here to assist further. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?
