Yes, you can create scores using data from different tables in Clay. You can consolidate data from multiple sources using the "write to table" feature to bring data together, then create scoring formulas.
To set up scoring:
1. Add a Formula column to your table
2. Use the Formula Generator to create custom scoring criteria based on your data points
3. Alternatively, use the Score Row integration which allows up to 15 scoring criteria
You can also use "write to table" to map data from different tables and combine it for comprehensive scoring.
Thanks for sharing the Loom and for your patience as we worked through this.
I do think that the "Lookup Single Row" method is the best way forward here, because you'd be able to pull columns from various tables into your current one to create a score.
Could you provide some more context on the duplicate occurrences of companies and how this would impact the score - should a duplicate company record have a different score?