How to Do Round Robin Assignment with Pardot (Account Engagement)

Pardot Lead Assignement

One of the key things to get right between Pardot and Salesforce is how we hand off prospects to sales. Some organisations have their sales team set up by geography, by product or by company size – but let’s say we don’t do that. Instead, all leads should be split equally amongst our sales reps, one after the other. The cycle repeats when everyone has received an equal share of leads.

This is called “Round Robin” lead assignment, and can be achieved with the help of a Lead Assignment Rule in Salesforce and an Automation Rule in Pardot. But before we can do that, we need to put some steps in place…

Create an Auto Generated Number Field

First off, we need to create an auto number field on the lead object that will plus one every time a lead comes in. This number will be used in our lead assignment rule.

  1. Open Setup in Salesforce by clicking the cog in the top right.
  2. Click on Object Manager.
  3. Search for Lead and click it.
  4. Click Fields & Relationships.
  5. Click New.
  6. Select Autonumber and click Next.
  7. Name your field “Round Robin Number”.
  8. In Display Format, enter {0}.
  9. In the Starting Number, enter 1.
  10. Tick the box Generate Auto Number for Existing Records.
  11. Give user permission to the right people and click Next.
  12. Make sure all page layout boxes are unchecked (it doesn’t need to be on the page layout).

Create a Round Robin Field for Lead Assignment

Now, we are going to create a formula field and use the mathematical function MOD to help us with lead assignment. The MOD function works like this…

MOD(number, divisor)

This function returns a remainder after a number is divided by the divisor. The number for us is going to be the auto number field we just created in the previous step and the divisor is going to be how many sales reps are going to be included in this Round Robin.

For my example, I’m going to pretend I have 3 SDR’s I want to pass leads to.

We’re going to take that formula and add 1 to that reminder which will help ensure that the next person gets it.

Which means our formula will look like this…

MOD(VALUE({!Lead_Number__c}), 3) +1

  1. Go back to the lead object and create a new formula field.
  2. Name your field “Round Robin Number”.
  3. Select Number.
  4. In the decimal places dropdown, select 0.
  5. Select Advanced Formula.
  6. In the formula window, copy and paste the above formula. (NB. Adjust the divisor number to how many reps you have in the Round Robin).
  7. Click on Next.
  8. Again, make sure all Page Layout boxes are unchecked.
  9. Hit Save.

Creating the Lead Assignment Rule and Using an Automation Rule to Handoff

Now comes the part of actually creating the Lead Assignment rule that we’ll use to pass leads into from Pardot. This step is pretty straightforward, once we have the previous steps in place.

  1. In setup, search for Lead Assignment Rules in the Quick Find bar and click on New.
  2. Name the rule “Round Robin Assignment”. Hit Save.
  3. When you get to the rules section, click New.
  4. In Sort Order, enter 1.
  5. Choose Round Robin Number in the field dropdown, equals as the operator and 1 in the value field.
  6. Select the first sales rep to receive a lead in the Round Robin.
  7. Repeat the above steps until each sales rep has been assigned a number from the Round Robin Number field.
  8. Once all steps are completed, mark the rule as Active.

Now we are ready to pass prospects off from Pardot into the Lead Assignment rule.

  1. Create an automation rule called “Prospect Assignment via Round Robin Assignment”.
  2. Add criteria for your MQL score and grade. In my example, my MQL threshold is a score of 100 and a grade of C.
  3. Under Actions, add the option to Assign via Salesforce active assignment rule.
  4. Hit Create Automation Rule.

Summary

Following the steps above, you can automate the Round Robin process so all your reps get the same amount of leads in a fair and sequential manner, removing you and the team from the process.

If you need help in making sure your prospect to lead handoff is as slick as it should be, then get in touch!

 

 

This Pardot article written by: 

Salesforce Ben | The Drip

Lucy Mazalon is the Head Editor & Operations Director at Salesforceben.com, Founder of THE DRIP and Salesforce Marketing Champion 2020.

Original Pardot Article: https://www.salesforceben.com/the-drip/how-to-do-round-robin-assignment-with-pardot-account-engagement/

Find more great Pardot articles at www.salesforceben.com/the-drip/

Pardot Experts Blog

We have categorized all the different Pardot articles by topics.

Pardot Topic Categories

More Pardot Articles

See all posts

Account Engagement Copy Between Business Units- Bulk Asset Copy Flow

Skip to content
Continue reading

Account Engagement (Pardot) Importing Prospects

Prepare your spreadsheet and save it as a .csv file.  If you are grabbing prospects from Salesforce, ALWAYS include the CRM ID…
Continue reading

How B2B Marketing Analytics can monitor Pardot database churn

In a previous post I shared a low-fi way to track opt-outs and database churn inside your Account Engagement (Pardot) org.
Continue reading

How to build scoring and grading in Account Engagement (Pardot)

The ability to natively build scoring and grading on leads is one of the functions of Account Engagement (Pardot) that sets it…
Continue reading

Make this 30 Second Update in your Account Engagement Account Right Now

There's a fairly recent update to Account Engagement that everyone should enable in their accounts right away, it only takes a few…
Continue reading

How to build a full-funnel marketing campaign report in Salesforce

When building a campaign cadence in Account Engagement (Pardot), setting up the campaigns correctly in Salesforce is an important step.
Continue reading

How to see if your Pardot tracking code is not setting cookies

Before you create another form in Account Engagement (FKA Pardot), do yourself a favor.
Continue reading

Why the Pardot email preference center is so important

I had a philosophical conversation with Peter Sabba about the utility of email preference centers and their value as a whole to email marketing.
Continue reading

 

 

This Pardot article written by: 

Salesforce Ben | The Drip

Lucy Mazalon is the Head Editor & Operations Director at Salesforceben.com, Founder of THE DRIP and Salesforce Marketing Champion 2020.

Original Pardot Article: https://www.salesforceben.com/the-drip/how-to-do-round-robin-assignment-with-pardot-account-engagement/

Find more great Pardot articles at www.salesforceben.com/the-drip/