Two Companies, One Story
<![if !vml]><![endif]>Over the past three years I have had a chance to do some consulting for two very different companies. Yet for all of the differences, my consulting has been very similar. The common thread is my contribution of a missing element in these organizations. Now I am not a “spring chicken” as I started my professional career after graduate school in the Spring of 1967. Because of the varied experiences, I have come to have a generalist’s approach to problem solving. For each of these clients I have been able to contribute a different, but vital function such that the receiving firm had a more complete offering.
The first client was a marketing communications (MarCom) company. Although it had many unique aspects, even the most casual of observers would recognize the firm as an advertising agency. It had a single, rather large, account that made up 90% of its business. This customer was a high tech systems integrator. The president of the MarCom had always wanted to be a full-line marketing services organization. He recognized that his company could do a lot more for the systems integrator. In particular, there was a need for a Customer Relationship Management (CRM) system. How could a MarCom help?
In this setting the S. I.
Inc. contribution was the development of this computer based marketing
system. In past issues of
My second, and current client, is a software house. They are trying to make the transition from a board-level (sometimes call embedded) programming shop to a more traditional full-line software organization. At first glance the software house has nothing in common with the MarCom. Look a little deeper and you see that this firm is a specialty organization that wants to become a full-line software company. They are looking for a plan to grow their business in the area of what was once call business data processing. That term is out and web services is in, but the function is still the same. The software house has a client that needs to put their CRM system on the Internet.
What we were going to bring to the software house obviously was not going to be computer methods. They have all of the computer techniques they need. What was called for was some good old marketing management systems and procedures. S. I. Inc. was able to recognize the need, create a plan, and develop customers that would buy the products and services. The need recognition was to look at the software house’s skill set and see how these capabilities could be presented in a way the prospects would buy. It is not easy to look at the skill called “writer of device driver” and see how that could be presented as “deliverer of CRM solutions.” This was exactly what was needed and done. Once the skill set was repackaged we went on to develop a plan to sell that skill set. The software house is well on its way towards realizing its goals while enjoying its new “look.”
Why do I say these two stories are really one? In each case a firm that specialized needed some one from the outside to point out what was missing. Having identified the problem S. I. Inc., was able to use one of its skills to meet the need. Providing the missing piece is what we do best. I trust we can keep doing that into the foreseeable future.
The more things change,
the more they remain the same.
Using a Database for Time Management
<![if !vml]><![endif]>You do not usually think of a database, or a database tool, as a vehicle for planning people’s time. Even less obvious is using a Customer Relationship Management (CRM) application for time management. But it is just what I have been doing while helping the second firm mentioned in the article above. This was not the first tool that was employed. The approach evolved over time.
The first generation “tool” was good old pencil and paper. For more years than I would like to admit, I have been planning my time. Those of you who know me well understand that I am a bit of a fanatic at record keeping. Since the early 1970s I have recorded my time. Not only do I do this in order to invoice clients, the Schuldenfrei family likes to eat, but I want to see how I spend my time. Now recording time spent has utility, but it is a little like driving your car but only looking out the back window! It soon becomes apparent that you are only looking at where you have been. When you need to plan projects you need to look forward. Thus, you quickly develop the need to forecast how your time will be spent in the future. The instructive part of time management comes in the comparison between the forecast of time and how long things actually took. Writing things down is the key. Since I have had constant computer access since 1965, I augmented my paper with computer data files. A big step forward came in 1979 when the cost of a computer became low enough such that I could buy one for my own use. From then on it was time management in the electronic age.
Having a medium, the computer, is not the same as having a message with all due respects to Marshall McLuhan. Over the years the need emerged for managing, not only my time, but the time of others. Accounting systems gradually took over the chore of invoicing the clients. However, accounting systems rarely look forward. Project management tools, like the excellent package Microsoft Project, is good for forecasting and recording actual. It, however, is project orientated and cumbersome too boot. Let’s look at both of these issues in turn.
Microsoft will tell you right up front that Project is for projects. A project has a beginning, a middle, and (most importantly) an end. It is just great for client engagements of the right size. The trouble with Project for managing a small group is that this type of time management is on-going. It never comes to an end. After many attempts to use Project where it was ill suited, I began to look elsewhere. The second issue with Project is that it is large, cumbersome, and hard to use for modest sized projects. It is great if you are running a missile development project, or releasing the next version of the Windows operating system, but it is hard to use for small projects that last a month or two. This is because of the time commitment of set-up. There is a real, and large, fixed cost of time to get Project established and ready for use. Something else is needed for the day to day work of managing a team.
I have been using an Access based CRM system since 1993. It is a design of my own creation and not meant to be a commercial product. It does just what I want, and unencumbered by the wants and desires of others. As I have performed consulting engagements over the last 10 years, I have brought this homebrew system to other organizations. It has taken root in some shops and not in others. Just recently I have taken to entering non-customers into the database. Room was made for client personnel, competitors, and suppliers. The features that make the tool useful for time management are: proximo scheduling, unlimited note taking, and the excellent database tools of Microsoft Access.
What is proximo scheduling? This is the technique that keeps reminding a system that a reoccurring event is coming due. The CRM system has a “date of next activity” field to remind a sales rep what must be done. This field is used such that a report is generated every morning on what the team being managed is doing. It does not have to be on a daily basis, but I like to be advised each morning. Usually the team member is doing work for a client that is in the CRM system. The proximo scheduling will report on the client record. Both of these reminders are brief, one line on a report. Here is where the second feature comes in.
The system has unlimited note taking ability. Anyone who knows me knows I am a prodigious note taker. By being able to explain what needs to be done by the team member on his record is very useful to me as the manager. Further, by having additional notes on the client record I can get an over all view of what needs to be done for the client by each team member. The notes are general and can be used in any way that makes sense. Since the CRM records are not project oriented, cross project control is realized. The notes explain in as much detail as necessary what needs to be done. Each note is threaded to the CRM Contact record. It does not matter if the contact is a prospect, customer, employee, supplier, or even competitor.
Finally, the excellent report writing features of Access allow for a rich set of standard reports to be available. In addition, the query capability makes ad hoc reports easy and quick to produce. I would not claim that these techniques make for a salable computer package, certainly not shrink-wrapped software. They do, however, constitute an extremely powerful set of tools with high utility for time management.
For additional information:
Or send USPS mail to: