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
Problems without solutions are not problems, they are facts of life
Problems without solutions are not problems, they are facts of life “Problems without solutions are […]
Perfect is not possible
Perfect is not possible We’ve all heard the phrase “Perfect is the enemy of good” and […]
“Different” isn’t necessarily better or worse.
“Different” isn’t necessarily better or worse. One of the biggest challenges I face when working […]
Once you know, what will you do?
Once you know, what will you do? I’ve yet to meet a client who didn’t […]
If it’s not in your AMS, why not?
If it’s not in your AMS, why not? I like to tell my clients they’ll […]
Why checkboxes and tags are awesome and dangerous
Why checkboxes and tags are awesome and dangerous One of the most common functions in […]
Don’t miss obvious engagement data
Don’t miss obvious engagement data What I’ve experienced with my clients over the years is […]
All data requires active management
All data requires active management It’s a simple fact of data management that is often […]
Documentation is critical for consistency
Documentation is critical for consistency There are so many reasons why documenting your data management […]
Consumer demands change and technology changes
Consumer demands change and technology changes When I work with clients on the selection of […]
