We are creating an automation that enriches decision makers in a clay...

We are creating an automation that enriches decision makers in a clay table and equally splits them into two seperate linkedin automation campaigns through expandi. We are unable to find a way to split the contacts into multiple campaigns though. Any ideas?

25 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 Sergio! Good one— are there any specific criteria that you're splitting them by, or just equal split overall?
Sergio A.
·
Equal split
Sergio A.
·
No criteria
Sergio A.
·
Arturo O.
Eric N.
·
I literally make a formula saying "output a random number between 1 and 2" and then I make a conditional run for each campaign being either a 1 or a 2
Sergio A.
·
This is smart hahah
Clay Team
APP
·
Cool! So it's probably best to have a formula column that assigns a number to each lead, either 1 or 2, and have two export columns that each run only when that criteria is met in campaign 1 or campaign 2.Not perfect but it's automatic
Sergio A.
·
I was thinking to make a formula if row is even or odd but didnt work
Eric N.
·
it's like kind of dumb, which makes it smart haha
Clay Team
APP
·
ahhh, there you go. Eric beat me to it lol
Sergio A.
·
Thank you guys !! Eric N. Arturo O.
Sergio A.
·
I feel like the (clay) parenthesis should still be around Erics name haha !!
Clay Team
APP
·
My sneaky way to even it out a bit further is to: 1. first assign a random number, 1 or 2, 2. then I use a Lookup Record to count how many of each (1s or 2s are in that column) 3. if that count is an odd number, then I use a final formula to spit out the opposite number to "even it out"
Clay Team
APP
·
Let me know if that makes sense or need help setting it up!
Sergio A.
·
Yea we were thinking of pushing data to airtable then processing through n8n but I like this solution a lot better
Sergio A.
·
Atleast for a short term solution
Eric N.
·
WOW that's wild Arutro. I don't care enough to split it down the middle to do that
Clay Team
APP
·
Yeah, I got a similar request last week but they had 3 campaigns instead and wanted to keep it roughly equal so that seemed to work okay-ish haha
Eric N.
·
why don't you just do random number 1 to 3
Nikhil B.
·
what does the opposite number mean here? Arturo O.
Nikhil B.
·
for example the lookup record gives 41, what would be the opposite number here?
Clay Team
APP
·
Oh, I did randomize 1-3 but they wanted an even split because the first option was kind of too random to work for that, Eric N.
Clay Team
APP
·
Nikhil B., this is the actual prompt I used for that example in case it helps clarify it or for your test:
3b974978-4f47-46ac-ae33-37fefab89650.png(33 kB)
Clay Team
APP
·
Overall this is what the setup looks like, and you would use the "Number split" column as a condition for your campaign columns.
5a80260e-86ef-43a4-a2ce-89c224cf8f3d.png(18 kB)