Home arrow Operations arrow How tracking results can triple your profits
How tracking results can triple your profits

Imagine you had unlimited resources. You could spend a fortune on advertising and guarantee an endless supply of enquiries. However, you may end up spending more on advertising than you generate in revenue from these enquiries. The net result is a loss instead of a profit.

In reality, advertising costs have to be closely monitored in relation to the amount of revenue they generate. I knew this when I started out because I had read a lot of marketing literature. All the guru’s stressed the importance of closely monitoring your results and to keep on testing adverts. But when I suggest monitoring advertising costs against the generated revenue, I do not mean immediate revenue.

Don’t make this common mistake or you will loose a fortune
When I first started I looked at how much income was generated as an immediate return from my advert. For example, if I spent say $100 on advertising I would hope to generate $1000 or more of business over the next month or so.

However, if I spent $100 in advertising and only generated $100 in revenue from a particular advertising source, I would have looked on that as a poor result.

DON’T MAKE THIS MISTAKE!

I would like to introduce you to a very important concept. It can alter how you look at your advertising spend. The concept is called: The lifetime value of a client

This means how much the client is worth to you in total. Not the first appointment, not the first month or even the first year. It refers to the revenue generated from this client until you are no longer in the business.

Why is this so important?

Let me give you an example. You spend $100 on an advert and it gives you an immediate return of $100. But now you have acquired a client. On average, you may find that they spend another $5,000 with you over the next 2 years. Your revenue goes up to 50 times your advert cost – an excellent return on your investment.

When you first start out you don’t have any statistics to work with but as you grow in experience you can look at your historical figures for guidance. Do your best to estimate how long you anticipate this client will be with you, how much they will spend and which ad they came from. Do your homework and you will get a rough idea of what return each advertising source has brought.

In an ideal world, we could always work on the lifetime value of the client. However, be fully aware that when you first start cashflow is of prime importance. If you spend lots of money on adverts that will pay off in the future, your business may fail because you cannot meet your bills in the present. Your advertising costs may be too high relative to the immediate return they produce.

Balance is the nature of the game here. One you have good cashflow then the lifetime value of a client increases in importance.
Vital steps in tracking your results
To successfully monitor your advertising results, you must:

1. Ask each client where they heard of you (which publication or which advert in that publication if you have more than one; which internet site; word of mouth; mailshot letter; introduction from another client and so on)

2. Make a note in your client database of which advertising source the client came from and the date of the enquiry

3. Record the date of each advert, the wording and the cost.

4. Use a spreadsheet to analyse these figures regularly. Check how much business each ad generates and how long, on average, its takes for the business to come in. Does most come in the first month? Or does it get spread over several months? Keep track of the trends to give you a decent feel for what is going on.

5. Look at the overall results. Add up all your revenue, all your advertising costs and see what the overall figures are showing.

6. Monitor over time the revenue coming from new clients as opposed to existing clients.

As already mentioned, results showed that my advertising costs dropped with time and more and more business was coming from existing clients. Once you have a client bank you may find that you can survive without advertising at all. This gives you somewhat more security than when first starting out.

2 essential tracking tools

You can track your results on paper but what’s the point? Why spend your valuable time doing calculations manually when a computer can automate the process for you?

Here are the tools I suggest you use:

Spreadsheet

I recorded my vital statistics using Excel. I recorded by month the following:

• No of new clients
• Total number of clients
• Advertising cost per month (also split by publication source)
• Total revenue per month
• Total revenue from new clients
• Total revenue from existing clients
• Number of appointments per month from new clients
• Number of appointments per month from existing clients
• Total number of appointments per month

This was relatively straightforward to do. At the end of each week I updated my figures and keep track of my progress. The trends were of great interest to me as it gave an insight into what was happening in my business. I just couldn’t believe how easy it all was and it pointed to a prosperous future.

I created ad hoc graphs to visually see the trend. It’s much easier to analyse what’s happening over time by viewing the data graphically. The trends were all positive, although after a while you reach plateau’s. Then they take off again.
Database
I also tried using a database. I created my own customer database using Microsoft Access. It allowed me to record the following information:

• Client Name and Address
• General notes about the client
• Advertising source
• Appointments made, the date, hourly charge rate, duration, why the appointment was made, whether an invoice has been sent, whether payment has been received and notes for each appointment.

Then I created a whole host of reports that gave me the vital statistics needed to run my business. Everything was available at the click of a button. This saved me enormous amounts of time as I got busier and busier.

Which must you start with, which should you finish with and why

Start by using a spreadsheet like Excel. You can set-up a spreadsheet to record your results in no time at all and not get side-tracked by developing a comprehensive database.

When you get busier and more experienced (say 3 months after launch), then you can look at improving your internal systems. By learning Microsoft Access, you can then offer training on it as well as using it to develop your database. You’ll kill 2 birds with one stone.

So, start with Excel and finish with MS Access.

Predicting future earnings down to the penny!

When you get several months data in, you can predict the results of your advertising with considerable confidence. When trying new media such as a competing local free ad paper, you have a rough idea of what might happen because you can look at your historical results from similar media.

This makes the whole process of predicting your future earnings easier. By using the reporting from your spreadsheet or database, you can see where you are heading and not be faced with the uncertainty that you face when first starting out.

Also, if you have carefully monitored your results you can decide how much work you want to generate. Just up your advertising spend if you are going through a dry patch. You can predict with some accuracy how much business that increased advertising spend will generate.

 
(C) 2008 Computer Consultant Secrets
Joomla! is Free Software released under the GNU/GPL License.