The Rule of 100 and 1,000 and automation

The Rule of 100 and 1,000 and automation

I originally coined the rule of 100 and 1,000 in relationship to data conversion (here and here). I extended that rule to ongoing data management here.

The rule of 100 and 1,000 can also be applied to automation. Simply put, if you're managing fewer than 100 records for some process (e.g., accepting 50 submissions for an awards program), it's probably not going to be worth the effort to automate most of that process. But if you're receiving over a thousand submissions, you're definitely going to want to automate the process as much as possible.

In fact, for automation, I might adjust the rule to 100 and 500, especially if there are multiple steps in the process (e.g., submission, review, multiple communications with applicants, etc.).

It often doesn't make sense (in terms of time and money) to automate a process that can be managed manually. And definitely don't automate for the sake of automation.

The rule of 100 and 500 might help you decide whether or not to automate a process.

Wes's Wednesday Wisdom Archives

Cheaper now; costlier later.

January 28, 2026

Cheaper now; costlier later. Most of my clients are very cost-conscious, understandably. After all, who […]

The unified shopping cart: Dreams vs. reality

January 21, 2026

The unified shopping cart: Dreams vs. reality One of the more common requests I hear […]

Don’t forget to celebrate!

January 14, 2026

Don’t forget to celebrate! Truth be told, I’m not a big celebrator. (Maybe it’s because […]

Three thoughts on duplicate records

January 7, 2026

Three thoughts on duplicate records Duplicate records are a reality in any database of any size, […]

Please don’t do this…

December 17, 2025

Please don’t do this… I’ve noticed a trend among online retailers that I want to […]

AI is perpetually patient

December 10, 2025

AI is perpetually patient My friend and colleague Noel Shatananda of fusionSpan was providing me some […]

User adoption is (almost) all that matters…

December 3, 2025

User adoption is (almost) all that matters… I was speaking with an association recently about their […]

When “overcommunicating” becomes overwhelming

November 19, 2025

When “overcommunicating” becomes overwhelming There is a common belief in project management and general business management that overcommunicating […]

Communicating when there is a major technology change

November 12, 2025

Communicating when there is a major technology change For those of you who are ASAE […]

Everything works, until it doesn’t.

November 5, 2025

Everything works, until it doesn’t. “If something cannot go on forever, it will stop.” – […]

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top