GeoSmart Weblog

Just another WordPress.com weblog

Analysing Car Sales Using WebMap Part 1

This can apply to any segment, but lets use car sales as an example today. Lets imagine you are Sales Manager for a car dealership. You have a budget to achieve and you need to understand what is going on in your territory. You have 6 sales people, each has a unit and dollar budget and you have a budget for each model of car you have on offer.

You have got some excellent sales history, because you are selling big ticket items and you know where the people live who purchased your cars. Using the GeoSmart Business Visualisation Application you can see the locations of all the cars sold in December.

Small Car Sales

In this example, you are looking at small engine car sales from your dealership in an area of Auckland’s North Shore. This already shows you that you seem to have made sales in clusters of area, but there are other areas where you haven’t made sales of this class of vehicle.

Now lets think about other things you can do. First we can also overlay in different colours, car sales for December of your other models. You can display each model’s sales in a different colour. Now you may start to see some change, you may see that you get clusters of SUV or high end sedan sales in other areas, or you may still see gaps.

Another thing you can do as a separate view is look at all sales by one of your sales people on the map. In the same way as you did with the car models, you can assign each sales person a colour and display their sales on the map at the same time. You may again see some interesting things. Maybe one sales person is getting more sales in a particular area. He may be using a referral technique that the others can learn from. I’m being simplistic and generalist here, but there is always going to be a reason for the results you are getting and these reasons are often impossible to find using spreadsheets and tables on their own.

Another query you could run is viewing car sales per sales person by model, comparing them with other sales people per model on the map.

Given that you have sales history for each month, you could do the same sort of thing by visualising the above information by date. Assign a different colour to each month and you can then view each map and see if you can spot any trends. In your financial systems you have a wealth of information and we provide the ability to query that information and display in on the map. For example, some of the things you might query are:

  • Gender of the purchaser?
  • Age Group?
  • Have they purchased from you before?
  • What was their last car? Same brand or change? Larger or smaller?
  • Was there a trade in?
  • Was it a profitable sale?
  • Was it for work or personal use?

The industry produces statistics each month. The latest reports on the AA Website say that the top selling model for December 2010 was the Toyota Corolla, but also interesting was that second was Toyota Hilux and third was Holden Commodore. So we have small to medium sized cars as most popular, but light commercials coming second and larger sedans coming third. Obviously there is much more to it and the dealership will have much more intelligence. The key here is whether the same trend is happening in your area and how you can capitalise on that knowledge, something I will look at in further blogs.

If this is of interest, please subscribe, or bookmark this blog and if you know anyone to whom this is of interest, why not send them a link. In business we all have a wealth of reports, but it is very easy to suffer death by statistics. There is an old adage that a picture speaks a thousand words and maps are a great way of delving into your business data to find knowledge that may otherwise remain hidden.

If you have questions, or would like to know more, please feel free to contact us.

Advertisements

January 19, 2011 - Posted by | Auckland, Business Analytics, Distribution, geosmart, GIS, lbs, location based services, map tools, Mapping Applications, maps, Marketing, new zealand, new zealand maps, Retail Profit, ROI, SaaS, Sales, sales territory, territory management, Uncategorized, Web Map, web maps | , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

1 Comment »

  1. I suspected when I wrote this that the great month might be corporate sales, which seems to be confirmed in an article in Autofile Magazine entitled Will the new market hold. It looks like a large percentage of December sales was Fleet sales placed in December to be delivered in Q1. It quoted Dave Pederson of LeasePlan saying that they had their biggest month on record with Government vehicle purchases. He said they still think it will be a pretty tough year. This supports the argument that those who want to have a better than tough year, need to get smart.

    Comment by Luigi Cappel | January 28, 2011 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: