Clay Icon

How to Write Number Patterns in Different Columns for Campaigns in SmartLead?

·
·

Does anyone know get Clay to write number patterns in in the different columns? Im trying to make it say 1,2,3,1,2,3,1,2,3 all the way down as I want the different numbers to be different campaigns to test(dont think i can differentiate it via normal way as the leads have the same results/personalization but just different copies in smartlead). I want the numbers as an easy way to tell the smartlead integration to know which rows/leads that go in different campaigns. So its equally split into the 3 different campaigns

  • Avatar of Joe R.
    Joe R.
    ·
    ·

    You mean randomly assign a row to 1, 2, or 3? If so, try inputting this as a formula column: Math.floor(Math.random() * 3) + 1 This won’t split your rows into equal numbers since it’s random, but for a large enough sample size the difference between should be negligible

  • Avatar of Mathew A.
    Mathew A.
    ·
    ·

    yeah like just have it 1,2,3,1,2,3 etc down for segmenting

  • Avatar of Mathew A.
    Mathew A.
    ·
    ·

    where would you paste the Math.floor(Math.random() * 3) + 1? I want an equal amout of 1,2,3s

  • Avatar of Joe R.
    Joe R.
    ·
    ·

    ^Doesn’t work if you want an equal amount. Export your list to Google Sheets, manually assign 1,2, and 3, then import back