MCAE (Pardot) Support

Pardot Automation Rule Criteria for Number Fields

September 4, 2018

Pardot Automation Rule Criteria:

Greater Than & Less Than

MarCloud Apple iPad retina favicon

Pardot   •   Fields

This blog was written before Pardot was renamed to Marketing Cloud Account Engagement. You can read more about the name change and what it means here.

Don’t you just hate it when you want to quickly find a sentence from the Pardot documentation that validates what you thought, but what you thought would take 2 minutes eventually turns into an endless pit of searching, worse than any YouTube hole you’ve ever gone through? Before you know it you’ve spent at least half an hour looking at the same articles…

Basically, this happened to me today and I found myself amending such minor keywords on my Google search to find the information I wanted.

It went like this:

  • Tom Search 1: ‘Is the Pardot criteria greater than inclusive or exclusive’
  • Tom Search 2: ‘Pardot automation criteria greater than exclusive inclusive’
  • Tom Search 3: ‘ Pardot number field automation inclusive or exclusive’
  • Tom Search 4: ‘ Pardot greater than less than number field includes value or’
  • Tom Search 5: ‘Did Pardot leave this out of the documentation as part of a big joke on me lol thought so’

Hence this blog. I think I wrote it more for me as I know I’ll be referring back to it at some point, but if I can save just 1 person from that time spent on Google, then I’ll be content with that.

The Logic

Pardot automation rule criteria

Is empty

Translation: Is your field value empty aka it has literally nothing in it.

Is not empty

Translation: Does your field have something in it.

It’s all going well so far…


Translation: Needs to be a perfect match (even upper/lower case)


Translation: Anything other than what you chose.

Here we go, the part that cost me 30-60 minutes of my day. Writing this feels like I’m playing a game for the 2nd time through and I’ve got to the final boss. I’ve already beat this boss before, but it still makes me nervous…

Exclusive = the number you type in will be excluded

Inclusive = the number you type in will be included

Greater than (EXCLUSIVE)

Translation: This is an exclusive field which means if you say ‘greater than 2’, then ‘2’ is not included. It’s like saying ‘anything more than 2, but not 2’.

Less than (EXCLUSIVE)

Translation: Also exclusive. It’s like saying ‘Less than 2, but not 2. So basically 0 or 1’.

Is between (INCLUSIVE)

Translation: This one is inclusive which means if you say ‘is between 1 and 9’ it means ‘1,2,3,4,5,6,7,8 and 9’

Date Fields

Pardot date field automation criteria

For some reason, date fields have been labeled a lot clearer. So much so, that I don’t really even need to write anything about it! Three simple words that can save someone 30-60 mins of their life (+ the time it took to write this blog).

I’m sure there are other Pardot details that you might be dealing with too, so drop me a message. Let’s work through it together.

Need a hand getting the most out of your Pardot or Salesforce account?

MarCloud is a team of certified Pardot and Salesforce specialists. We help businesses to unlock the potential of marketing automation.

Ready to save time, deliver more quality leads, and generate more revenue? Here's how we help.


Tom Ryan

Tom is a Salesforce Certified Pardot Consultant & Marketing Cloud Consultant and has a passion for how systems work. He's written blogs and other content for Pardot.com, regularly hosts webinars with Pardot and loves being involved with the wider Pardot community. He also uses (brackets) and ,commas, where (brackets) and ,commas, should not be used. A lot.

More by Tom Ryan →