Clay Icon

Dividing a Master List for Targeted Campaign Enrichment

ยท
ยท

Anyone know if there's a way to push only a certain number of columns to a new table? IE - I have a Master List. I want to enrich all my leads via that master list. I have 6 campaigns I want to test from that master list. I would like to divide that master list by 6 and push them into the correct campaign's list for further enriching & so I can easily export later. Is there a way to do this or do I have to export the master list first -> divide it up -> import into each campaigns list

  • Avatar of Eric N.
    Eric N.
    ยท
    ยท

    What are you using to run campaigns?

  • Avatar of Kierin F.
    Kierin F.
    ยท
    ยท

    Smartlead

  • Avatar of Kierin F.
    Kierin F.
    ยท
    ยท

    I bet there's a way to do it via smartlead enrichment, isn't there? lol

  • Avatar of Kierin F.
    Kierin F.
    ยท
    ยท

    Well actually I take that back because I want to do further enrichment depending on the campaign so it needs to go in another table first

  • Avatar of Eric N.
    Eric N.
    ยท
    ยท

    Great Step 1 finish your clay table Step 2 make a clay formula like โ€œif email is valid, output a number between 1 and 6 Step 3 add all of your smartlead integrations for 6 different campaigns Step 4 add a conditional formula that the column can only run if the number equals 1. Next column only runs if it equals 2 etc

  • Avatar of Kierin F.
    Kierin F.
    ยท
    ยท

    Genius

  • Avatar of Kierin F.
    Kierin F.
    ยท
    ยท

    Thank you

  • Avatar of Eric N.
    Eric N.
    ยท
    ยท

    If you need to send it to another table make the conditional formula write to table instead of smartlead

  • Avatar of George D.
    George D.
    ยท
    ยท

    Great Step 1 finish your clay table Step 2 make a clay formula like โ€œif email is valid, output a number between 1 and 6 Step 3 add all of your smartlead integrations for 6 different campaigns Step 4 add a conditional formula that the column can only run if the number equals 1. Next column only runs if it equals 2 etc

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    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!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Kierin F.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: