Hi there, question regarding Clayagent output/results. I'm trying to g...

Hi there, question regarding Clayagent output/results. I'm trying to get it to standardise the output of the query but I'm getting very different layouts in Clay although the prompt is exactly the same. How should I ask GPT to format the results for Clay to recognise the formatting properly so I can get each datapoint separately? See examples below - here is the table.

6 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
·
Hey Victor, thank you for the insights! checking this now
Clay Team
APP
·
·
The prompt looks like it's clear, but in such cases, I usually test out repeating or stating that it should follow the format you give it. Maybe letting it know it has to "follow the format mentioned below" in the paragraph of the prompt could also help. Let me know if that improves results!
Victor F.
·
·
Hey Arturo, I’ve done that. Maybe my question was not clear; what is the correct formatting rules so Clay can recognize them as separate datapoints? I want the Result to be recognized like in the first print screen
Clay Team
APP
·
·
Got it! The team tested out the output schema option to return values in such way but it wasn't working properly at scale so they decided to not much forward with it.The workaround is to give this Claygent's response to convert it into JSON and then having those fields in such format. Video on JSON mode in chatGPT: https://www.loom.com/share/317de47023fb429a80022de0f4a5d6dc
fefbf444-d0f8-41de-9994-c3a1db75af13.png(38 kB)
Victor F.
·
·
Ok, I’ll try that