Hi Guys, we have a ChatGPT integration column where always some cells are not executed. Or they are executed and they do not have any returned data. It is quite a large prompt of 3367 tokens though. But we need that prompt. It is that table: https://app.clay.com/workspaces/307417/tables/t_qp2bxEAyggSy/views/gv_AHSySDGKTvp5
The column is "Select best contact person"
Regarding your related discussion link: Since I tried to give the input as a JSON and have optional variables in it, that might be an issue for GPT. If that is the case, I would love to know how I could approach that input differently.
Hey there Hendrik thanks for reaching out, taking at your prompt it is well written. Also, JSON and optional values will not be an issue for the GPT model. Taking a look at this the issue looked to be Rate related as rerunning one of the rows that had no results showed the prompt is able to return a value like the others. https://downloads.intercomcdn.com/i/o/w28k1kwz/1247798304/c841c52b62db3db40b444a4fade4/image.png?expires=1731351600&signature=76239bb27686201592b31b87842589b716e68f261e1daeec4ea188f77f69aa64&req=dSIjEc53lYJfXfMW1HO4zWaynZ%2FmDSjxHQqOR6Uh8vUjtdXl9E9K2AJwnEyz%0AmAgr%0A
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Hi Hendrik H.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Hi LuisArturo, I did not see that the thread was closed. What was the result? Were you able to find the reason? Is "rate related" a topic that I can solve?
Hello Hendrik! It looks like LuisArturo came to the conclusion that the issue is likely rate related. This means that the cells will take a longer time to run due to the length of the input. However, it could also mean that they could time out if they take too long to run, causing them to error out. Also, I went into your table and it looks like all the cells in the enrichment gave results as expected. Is there a particular one that is still not doing so?
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Hi Tomi F., it might be related to the rate, but they do not finish ever. They are stuck with stale data. I have seen a explicit timeout only once in that column. The stale thing is happening way more frequently. "Also, I went into your table and it looks like all the cells in the enrichment gave results as expected." -> For every run, I go to the cells in the Column "Select best contact person" and trigger it manually again. We have a running process, so I cannot let it not produce any output. afterwards I push to the other table "manually".
Is there stale data issues with this enrichment? I just re-ran a few cells and I don't see that issue popping up. They also ran pretty quickly, so I am not sure what the issue previously was with the long queues. If you'd like to run the enrichment automatically, you should turn the table on here: https://downloads.intercomcdn.com/i/o/w28k1kwz/1256168317/031daef613bf236a613a7a256c8a/CleanShot+2024-11-18+at+09_43_48%402x.png?expires=1731942900&signature=d351dca97630e7688fec56052f8f15170d7383e5c18f7b09efd75b7640cbb34f&req=dSIiEMh4lYJeXvMW1HO4zbsNTzEGPlJfWLEuusqm5QNUbwAIZZaGdhGnyR6K%0Anv2c%0A Currently, the table is off so enrichments will not run automatically.
"Is there stale data issues with this enrichment?" -> Sometimes there is stale data, sometimes there is a response without content. It happens to 10% of the rows for the mentioned column, when the table is running automated. Re-running is perfectly fine, but we need it to work without re-running certain cells manually. Currently, it is on auto-update. Where do you see that it is disabled?
Both screenshot show the usual cases when the cell has run and ended up with either stale data or without a proper response.
Hey there Hendrik jumping back in here, I do not see this table being turned off anywhere either. Currently there is no way to schedule automated runs for unrun rows in Clay tables, although there are plans to include a feature that may help with this in the future however there is no ETA on when this feature could arrive. Right now, the best workaround you can use is to create a separate view that filters for a specific output column such as Name or Job Title so that way you can have all of the rows where the GPT column did not return a result in one place, and you can run them all together without having to search for them
But what can I do to prevent those cells from not running or running without an output (it drains credits though) in the first place? Is there a reason why those cells are not running? We have other prompts that are lengthy as well but return a proper response. I want to know what we might did wrong with that one. The usecase we have is to send those leads to clay, lets everything run through and push it back into our system without touching any lead manually.
Hey there Hendrik, if you want to prevent a row from running you can use a conditional formula to prevent the row from running. This document goes over how to use conditional formulas. https://docs.clay.com/en/articles/9642377-conditional-formulas. Taking a look at this, the reason as to why certain cells were not running properly, is because the AI model is assuming there was no need to return a value, as it was having issues interpreting the need to return a "-" if there was not value to be found initially. In situations like this is best to just write the word dash out instead, explicitly telling it to return a specific output, in a situation where there is no value to be returned.
.png&w=3840&q=75){kind=logo}
