The Rule of 100 and 1,000 revisited
I'm finding that the "Rule of 100 and 1,000" comes up quite often in discussions with clients, so thought it was a good time to revisit it. (You can read more about the rule here and here.)
I was recently talking with a client about how they should transfer data from their event registration system into their primary AMS. We discussed how we might integrate the two systems so that the data can be easily passed between both systems.
As we got deeper into the discussion, they pointed out that there are only two events per year, and each event has only about 50-75 attendees. So by the "Rule of 100 and 1,000," this data should be managed manually. In other words, we shouldn't spend a lot of time (and money) trying to integrate the two systems, because manually entering the event registration data into their AMS (either in realtime or in a batch after the event) will be more time- and cost-effective.
The "Rule of 100 and 1,000" can help you make data management decisions more quickly, so it's probably worth familiarizing yourself with it.
![]()
Wes's Wednesday Wisdom Archives
Just start. And it’s never done.
Just start. And it’s never done. Last week I had the opportunity to lead a […]
Don’t ask if you’re not going to answer!
Don’t ask if you’re not going to answer! In the past week, on three different […]
Seek forgiveness rather than permission
Seek forgiveness rather than permission “Seek forgiveness, not permission.” I can’t remember when I first […]
Is a 360 degree view necessary?
Is a 360 degree view necessary? “A 360 degree view of our members should NOT […]
Why data matters
Why data matters I write about data because managing our data effectively will help us […]
It’s about process
It’s about process I’m in the midst of adding an AI agent to my website […]
Data integrity reports
Data integrity reports I speak and write a lot about data integrity reports. So I […]
The most important training tip
The most important training tip I’ve been sitting in a lot of database training sessions […]
Be careful about getting tangled
Be careful about getting tangled “We had done a lot to tangle ourselves up.” – […]
Discipline. Always discipline.
Discipline. Always discipline. I’ve been producing a newsletter in some form for over 25 years […]
