Sometimes staff has to do the work...
As a child, I was attracted to computers because of the games. As a young professional, I was attracted to computers to make my life easier (because I'm inherently lazy!). So when I work with my clients, I love to automate as much as can be automated. But sometimes we just gotta do the work ourselves, because it makes no sense (time or money or both) to try to make the computer do the work for us.
Case in point: a client of mine was recently trying to figure out how to make their database manage deferred revenue for ad insertions in their magazine. Their practice (a common one) is to book the order now but not invoice for the ad until the magazine is printed. After much discussion about what it would take to program the database to manage this, a wise staffer pointed out that staff could just capture the orders when they are originally placed (no financials associated with the orders), and create the invoices after the magazine had printed. Thus no need for deferred revenue. Problem solved!
Would it be "easier" for staff if the system would manage deferred revenue and they could create just one invoice and be done? Yes, it would. But the reality is that the magazine only prints every other month, and there are fewer than 20 ads per issue, so staff has to create 20 invoices once every two months. Maybe two hours of work.
It's not automatic, but it's not that much work, and it's far less expensive than trying to program the database to do it for them. Sometimes staff just has to do the work.
![]()
Wes's Wednesday Wisdom Archives
You might have to do SOME of the work yourself!
You might have to do SOME of the work yourself! Many, many years ago I […]
Don’t manage to the exception!
Don’t manage to the exception! One of the universal truths about data management is, wherever possible, […]
It’s always about improvement
It’s always about improvement Talking with a client recently, she expressed frustration about one particular project […]
Don’t be a hoarder!
Don’t be a hoarder! The simple truth is that it’s almost “free” to collect data. […]
With data analytics (as with most things), keep it simple!
With data analytics (as with most things), keep it simple! Over the past several years […]
Don’t forget about periodic maintenance
Don’t forget about periodic maintenance Just as most automobiles need periodic maintenance, keeping your data as […]
Users Groups are ALWAYS Valuable
Users Groups are ALWAYS Valuable I am a huge fan of users groups. (Here’s a […]
But will you DO anything with that data?
But will you DO anything with that data? I frequently exhort my clients to always answer […]
It’s not what happens, but how you react…
It’s not what happens, but how you react… “It’s not what happens to you, but […]
Saying it and doing it are two different things
Saying it and doing it are two different things When I work with my clients […]
