Troubleshooting Incorrect Results in Clay Formula for Valid Lead

Loh Y.

The Clay formula is returning me the wrong result, how can I ensure it's correct?

See link here.
Row 168
Check the Valid Lead column.
The formula should return me "Qualified" but it kept giving me trash. Why?

8 comments

Loh Y.
·
·
This is the formula used in the Valid Lead column: ({{Email Classification Result}} === "Work Email" && ({{Valid Email?}} === "✅" || {{Valid Domain?}} === "✅" || {{Company LinkedIn Exists?}} === "✅")) || ({{Email Classification Result}} === "Personal Email" && ({{Valid Domain?}} === "✅" || {{Company LinkedIn Exists?}} === "✅")) ? "Qualified" : "Trash"
Channeled
APP
·
·
To address the issue with your Clay formula returning incorrect results, we need to review the formula's logic and the data it's using. Here are some steps to help ensure your formula returns "Qualified" as expected: 1. Check the criteria: Review your lead scoring criteria and ensure they align with your definition of a "Qualified" lead. 2. Verify data points: Make sure all necessary data points for qualification are present and accurate in Row 168. 3. Test the formula: Apply the formula to known qualified leads to see if it works correctly in those cases. 4. Use conditional runs: Consider setting up conditional runs to filter leads based on specific criteria before applying the formula. Can you share the current formula you're using for the "Valid Lead" column? This will help us identify any potential issues in the logic or syntax.
Sources: Guide: Ways to save Clay credits | Documentation | Clay University Example Salesforce workflows Intro to Inbound Messaging [Automated Inbound] - Clay University
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 02 Support.
Loh Y.
·
·
row 182 has the same condition as row 168, but only row 182 got it correct. Why?
Loh Y.
·
·
Hi there, please help me re-open this ticket
Loh Y.
·
·
It is not resolved!
Muhammad S.
·
·
cross check if there are any leading or trailing spaces in both the rows?
Loh Y.
·
·
Apologies, are you a Clay support agent? I'm trying to follow up on a problem where a row finished running, but then there is always one column that did not finish its execution. And I had to re-run the row and everything would work accordingly.

Troubleshooting Incorrect Results in Clay Formula for Valid Lead | Clay