Challenge for lead assignation using round robin

Rodrigo Rojas
Rodrigo Rojas Posts: 42
Second Anniversary Photogenic

We are working with a startup that is integrating leads from forms from social media (facebook, instagram) and creating deals in the CRM using the Pipedrive API.

We have facing a challenge to assign the leads to 3 branches, each one with 6-7 users, using round robin, but there are some limitations to follow:

1.- All leads should be assigned to users using round robin but following these shifts:

Each branch work on 2 shifts:

→ AM from 9a to 5p from Mon to Fri
→ PM from 12p to 9p from Mon to Fri
→ On saturdays it goes from 10a to 3p

2.- All leads that are out of these shifts, goes into a "temporary bucket" that re-assign all of the leads out of this time to the next day to both shifts in the same amount in order everyone has the same amount of leads

This is a real challenge and we are aware of RouterJet but I believe we need a more sophisticated way to work assigning the leads.

What could be the suggestions you have to do this?

Comments

  • Gerson Andrade
    Gerson Andrade Posts: 20
    edited February 25 #2

    Hi, 

    I have something similar working, for that I use Zapier with  a "lookup" into a excel file in google sheets where the deal owner search is done taking into consideration the rules defined.

    We don't count the number of deals assigned to each owner, but we check if the person or organization already has a previous owner (from a previous sale made) so that the owner of the account (person or organization) prevails.

  • Rodrigo Rojas
    Rodrigo Rojas Posts: 42
    Second Anniversary Photogenic
    edited April 2021 #3

    Hi, 

    I have something similar working, for that I use Zapier with  a "lookup" into a excel file in google sheets where the deal owner search is done taking into consideration the rules defined.

    We don't count the number of deals assigned to each owner, but we check if the person or organization already has a previous owner (from a previous sale made) so that the owner of the account (person or organization) prevails.

    Thanks Miguel, that looks like a solution, we did something similar with an integration with Google Sheet but we are looking for an option to deal with a more complex situation with superposed swifts. Thanks!

  • Akhil_Supermeet.ai
    Akhil_Supermeet.ai Posts: 57
    10 Comments Name Dropper Photogenic
    edited June 7 #4

    @Rodrigo Rojas  Did you able to find the right solution?

     

    Would love to understand how you solve such a scenario.

    Thanks.

  • Rodrigo Rojas
    Rodrigo Rojas Posts: 42
    Second Anniversary Photogenic
    edited June 6 #5
    Akhil said:

    @Rodrigo Rojas  Did you able to find the right solution?

     

    Would love to understand how you solve such a scenario.

    Thanks.

    I already did a great job using Make.com for the Round Robin and a fractal price of ZAPIER.

  • Akhil_Supermeet.ai
    Akhil_Supermeet.ai Posts: 57
    10 Comments Name Dropper Photogenic
    edited June 7 #6
    Akhil said:

    @Rodrigo Rojas  Did you able to find the right solution?

     

    Would love to understand how you solve such a scenario.

    Thanks.

    Thanks for the reply.

     

    Will try make!