Jannis E.

Commented on Issue with Contact Ranking Formulas: Seeking Assis...·Posted inClay Support

Thank you for sharing the video! It would be amazing if I could also take a look at your Clay table - based on the video it seems like I just need to adjust my formula, but I’m not 100% sure. I’d also love to see your AI seniority ranking if you’re open to sharing.

Commented on Issue with Contact Ranking Formulas: Seeking Assis...·Posted inClay Support

Jannis E.

Mathis E. thanks a lot for sharing! I will check it out now 🔥

Commented on Issue with Contact Ranking Formulas: Seeking Assis...·Posted inClay Support

Jannis E.

Hey team, I’ve been running into continuous problems with ranking contacts within Clay. Here’s the situation: Issues

1.
Formulas keep breaking

I’ve tried multiple formulas (Records Sort, INDEX, GPT Reasoning model).
Each time they work for a while, then suddenly break or start returning rank 0 for every contact.
The same formula that failed before sometimes starts working again randomly.

2.
Inconsistent results

For some companies, the ranking is correct (highest score = rank 1, etc.).
For others, the same setup produces completely wrong rankings (e.g. top score gets rank 10 instead of 1).
Results can change between runs without me changing anything.

3.
Unreliable workflow

None of the methods (formulas or GPT) give me a stable, 100% reliable way to rank contacts by score within the same company.
I need something that doesn’t require me to constantly re-fix or change formulas.

Goal: I need a stable way to rank contacts per company by a numeric value (the adjusted relevance score) so that:

The highest score always = rank 1.
Lower scores follow in order.
Ties are handled consistently.
Results remain stable across runs.

Details:

Video to explain the issue: https://www.tella.tv/video/clay-ranking-issue-1-ayf2
Table: https://app.clay.com/workspaces/772112/workbooks/wb_0t2s1i05RT6RkDroorE/tables/t_0t2tocdk82qm5cPweEQ/views/gv_0t2tocd2GPQpYxDiCqq

Could you point me to the correct approach or best practice to achieve this reliably in Clay? Thanks!

Commented on Issue with Sending Leads from Clay to Growth Machi...·Posted inClay Support

Jannis E.

Problem solved. I now updated all LGM fields sync manually again and somehow it worked now. Thanks anyway!

Posted in Clay Support·

Jannis E.

Issue with Sending Leads from Clay to Growth Machine: Need Help

Hi Team, I’m running into an issue when trying to send leads from Clay to LGM.

Issue:

The workflow shows a positive signal that leads are being added, and I also verified that the contacts are not already in other campaigns. However, only a small fraction of the leads actually arrive in Growth Machine. For example, in my current setup only two contacts made it through, while the rest did not.

I’ve tried several things already:

Manually updating
Duplicating and re-running the automation
Letting the process run for over an hour

None of these attempts resolved the issue, and no additional leads showed up in Growth Machine.

It doesn’t seem to be an “already in IGN” issue for most of them, so I’m wondering if this might be a bug. Could you help me identify what’s going wrong and how to fix it? Here more infos:

Thanks in advance for your support! Best Jannis

1Comment

Commented on Issue with Contact Ranking Formulas: Seeking Assis...·Posted inClay Support

Jannis E.

Sure, I'm happy to help! Feel free to send me a PN with your email address so that I can give you access

Commented on Issue with Contact Ranking Formulas: Seeking Assis...·Posted inClay Support

Jannis E.

Unfortunately your solution did not work but I finally found a workaround! Here a quick video to elaborate on how I fixed it: https://www.loom.com/share/00c15a3452ba4a36a64cbd6564b2367d

Commented on Issue with Contact Ranking Formulas: Seeking Assis...·Posted inClay Support

Jannis E.

Ty 🙏🏼

Commented on Issue with Contact Ranking Formulas: Seeking Assis...·Posted inClay Support

Jannis E.

Those are the different prompts I've tried. I believe 3.4 is the best, but I'm not sure, as the results are all wrong

Commented on Issue with Contact Ranking Formulas: Seeking Assis...·Posted inClay Support

Jannis E.

Of course! Here is the table https://app.clay.com/workspaces/479052/workbooks/wb_0t16i0aGAVR4kfnUDnP/tables/t_0t19a7rGFe7pJceJmPG/views/gv_0swlqdinJzhX9UCheDv

About

Country
My Company Website
Title