.png){kind=logo}
Days Since Lead Added to Instantly Campaign: Request for Prompt
I’m looking for a prompt to show me how many days it has been since a lead has been added to an instantly campaign
Based on the available integrations, you can use the "Get or Search for Leads with Instantly" action to retrieve lead information from your Instantly campaigns.However, there isn't a direct way to create a prompt specifically for showing the number of days since a lead was added to an Instantly campaign using the current integration features. You would need to: 1. Use the Get/Search Leads action to retrieve the lead data 2. Process the timestamp information in your Clay table once you have the dataIf you need this specific functionality, you may want to request human support to explore alternative solutions or custom implementations. Sources: Instantly x Clay integration | Clay.com Lookup Lead Status in Campaign with Smartlead.ai Add Lead to Campaign with Instantly
Tanvi R.··Hey there, thanks for reaching out - Do you mind sending the link (url) to the table so we can take a look? https://downloads.intercomcdn.com/i/o/w28k1kwz/1347419411/65baf32e1d2a789ffba395c6d35c/CleanShot+2025-01-22+at+_42I1FzxXHf%402x.png?expires=1738167300&signature=2b0ef0ea777740bb2dedd732079ea44d2a64d4c1d68c070ccbce2bd2d2f95e32&req=dSMjEc1%2FlIVeWPMW1HO4zVws4pk2C1OrgvYjA82bedDEjQ%3D%3D%0A
Aaron··https://app.clay.com/workspaces/460627/tables/t_xkjkRc2wnATY/views/gv_6NDmMNd3VHT2 i want to have a column that shows how many days ago a lead was pushed from clay to instantly
- Tanvi R.··
Did you send the lead to Instantly from this table?
- Aaron··
yes - this is still a test table, but you can see how there are a few rows that have “added to campaign” under the instantly column
- Tanvi R.··
It looks like this might just be a user interface bug, when I check the table it is writing to I see both of these columns are filled and have values
- Tanvi R.··
Let me know if there are any incorrect results you're seeing
- Aaron··
yes, but the column “# days since added” is not displaying what i want it to display. the goal is to “show me how many days it has been since a lead has been added to an instantly campaign”. currently, all values are 0 even if the row and lead was added to instantly a few days ago
- Tanvi R.··
Hey Aaron, the formula column cannot calculate this for you as it does not have enough data to measure how long it's been
- Tanvi R.··
Instead what I've done is call in the World time apiinto the HTTP API column right next to Instantly. I've applied a conditional formula so this only runs when the Instantly enrichment is updated.
- Tanvi R.··
This enables you to see the last date the Instantly cell was updated. I also created another worldtime api column called "today's date" that will update with today's date when it is run. In the formula column now, I've directed it to find the number days between today's date - instantly updated date
- Tanvi R.··