Challenge for lead assignation using round robin

Rodrigo Rojas

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?

Gerson Andrade

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

Gerson Andrade said:

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

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

 

Would love to understand how you solve such a scenario.

Thanks.

Rodrigo Rojas

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 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!

Anna R

Note that Routerjet does #1 easily. For #2 it would assign all leads that come in when there isn't anyone on shift, in a round robin fashion, to the next shift. So for example any leads that came in overnight on a Tuesday would get evenly distributed to the Wednesday AM shift.