Clay Icon

Implementing a Round Robin Value Assignment for Data Rows

ยท
ยท

Hey everyone, wondering if there's a way to assign a value to a row, e.g. row 1, value = 1, through to row 4, value = 4, then from row 5 it's back to 1 again. Essentially want a way to send data from clay to instantly but "round robin" the campaign it's sent to so we can send from different people within the business.

  • Avatar of Kate L.
    Kate L.
    ยท
    ยท

    Thinking the solution is probably:

    1. 1.

      Use a formula on the Google sheet we add contacts to & assign the value here

    2. 2.

      Lookup that value on the google sheet

    3. 3.

      Restrict running campaign col based on the returned number

  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท

    Generate a random number from 1-5 and assign the campaigns depending on the randomly generated number. it wont be perfectly 1-5 each time but will serve the rounrobin purpose of distributing leads to different campaigns/people

  • Avatar of Kate L.
    Kate L.
    ยท
    ยท

    fab thanks muhammad

  • Avatar of Bo (.
    Bo (.
    ยท
    ยท

    Well done Muhammad! Yes exactly Kate :) Cheers!

  • 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 Kate L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: