GeoSmart Weblog

Just another WordPress.com weblog

Lots of Requests for Accurate New Zealand Geocoding

We have been getting a lot of companies come to us for geocoding services lately. What is geocoding? Essentially it is generating accurate coordinates for a location or street address.

This can be really important if the locations are used in a GPS based device and especially where routing or directions are involved. For example it is often not practical for vehicles to zigzag from one side of the road to another. It may be impossible because of median barriers, difficult because of heavy traffic, or the vehicle could be one that must stay on one side of the road, for example a rubbish truck. Another classic situation would be where the address is given as Corner of X and Y Streets. That could be any one of four or more corners, which could have significant implications on routing and another time waster for people on the road.

GeoSmart has driven most roads to sub half a meter accuracy which means that when we provide coordinates they will be on the correct side of the road. We have seen frequent examples of map providers who use source maps which are not spatially accurate, which can often result in the road being displaced to the point that both odd and even numbers are shown as being on the wrong side of the road.

We have a number of services on offer. We have API’s which allow an application to look up addresses using an auto-completer. This is particularly good for accounting software, CRM and other applications, allowing companies to get the full information correct first time, right into the application. We never cease to be amazed at how bad some companies record keeping of addresses is for their clients. This may not be a problem when the same person calls on them for years, but when change happens, it can become a major time waster, especially in a country with so many duplicate place names. Go to http://www.aamaps.co.nz and see how many instances of Queen Street there are just in Auckland City!

We have a geocode web service and also a Software as a Service (SaaS) application which allows you to upload a CSV file of addresses. It will resolve them including looking at incorrect spelling, vanity (e.g. where someone says Remuera, but technically they are in Newmarket) or incorrect suburbs and much more. The results include Post Code ane even Census data such as Mesh Block and the ability to export to GIS in MapInfo format.Results are ranked based on the result, for example if you look for 21A X Street and we don’t have 21A, but we do have 21 X Street, it will show as a sub 100% result and an explanation that we believe that result is correct. The same if a name is misspelled or perhaps it was entered as 21 X Street when it should have been 21 X Avenue.

The application also allows you to modify the location by moving an icon on the map yourself. For example a property may have multiple entrances, or the location may not even be on a street. It could be a building in a park, or a location within a large complex such as a hospital, university or shopping mall. We offer the flexibility of doing it yourself and being able to interpret it yourself according to your needs, without requiring GIS software or skills.

Having driven pretty much every road in New Zealand with our mapping car in most cases to sub 1 meter accuracy, we are able to offer a degree of quality not available anywhere else.

In addition to a very attractive pricing model, we are a local company in your time zone, we have developers that you can talk to and are very passionate about all things location.

To top it off, we are a wholly owned subsidiary of the New Zealand Automobile Association which is of course committed to New Zealand motorists and all revenues are retained in New Zealand.

Want to know more. Why not contact us and be pleasantly surprised about how easy it is to use and of course affordable.

P.S. We can offer the same services for Australia.

Advertisements

June 27, 2012 Posted by | Auckland, Australia Maps, Business Intelligence, Business Tools, Data Mining, driving directions, Geocoding, geosmart, GIS, gps, map tools, Mapping Applications, new zealand maps, systems integrator, Web Map | , , , , , , , , | Leave a comment

Harnessing Your Business Data with a Map

There was a very good article on from eMarketer this month about the difficulties for online retailers in accessing, sharing and analysing information about their business. This is something we have found relates to all business, not just online. Business is all about numbers and understanding what your customers want and when. It doesn’t matter if you are a bricks and mortar retailer like the very successful Briscoes, a supermarket chain selling high volume for low margin or a company with a field sales or service workforce. Success comes down to being able to access quality information.

In retail the key information tends to be about stockturn, aged stock, shelf space, gross profit by product and category and so on. Retailers and department heads will have standard exception reports that arrive on their desks, daily, weekly and monthly and they will make their buying and promotional decisions based on these reports.

As per the table, research shows that often data is used for the key purposes of business as usual, but often it is only available to a few people and there is very little use made of information about who the customers are, where they come from, the context in which they do their shopping and much more.

GeoSmart’s BIonaMAP is a tool that can allow companies to visualise more information in a way that allows them to look strategically at location based information about their business. It might be a retail chain deciding where to place their next store, a loyalty program that wants to understand their customer demographics or a sales or divisional manager wanting to create fair and manageable sales territories.

By combining information from the Point of Sale system or the financials with a map, it becomes possible to cut through the clutter and see the big picture. BIonaMAP is a SaaS (Software as a Service) application. What that effectively means is that all you need in order to use it is a web browser and an Internet connection. You don’t need to install any software.

Now you can share information with whoever needs it, management,sales and marketing, business partners and suppliers. It might be about where your customers live or work, which ones use one of your products but not another. It might be customers within a certain distance from a store or using demographics to decide where best to place your next store. The potential is limited by your imagination and currently to within Australia and New Zealand. Effectively anything that has a location element to it and where data can be exported as a CSV file from your financials, CRM or other application can be interrogated within BIonaMAP.

Do you suffer from death by spreadsheet or wish you could see the big picture, large corporate, franchise or SME, we would like to talk to you about how to harness your business data and increase your productivity and profit.

May 23, 2012 Posted by | Australia Maps, Business Analytics, Business Intelligence, Business Tools, Data Mining, geosmart, GIS, Loyalty Card, Mapping Applications, Marketing, new zealand, new zealand maps, Retail, Retail Profit, SaaS, sales territory, territory management, Uncategorized | , , , , , , , , , , , , , , | Leave a comment

Whose territory does a new prospect belong to?

Does this sound familiar to you? We talk to companies all the time who have problems with who to allocate a new customer or prospect to when they ring the sales or franchise company or call centre. Sales territories have always been a bit of a problem to deal with, but this will no longer be a problem for people who use GeoSmart’s new BIonaMAP business intelligence SaaS (Software as a Service) application.

Old school BAU (Business As Usual) is still the way most sales and service companies work. They pin a map on the wall, draw the territory on it with a sharpie pen and write the name on the map. There are always arguments over whether a territory includes both sides of the road, where the suburb boundaries are and don’t even start about what happens when you want to modify a territory.

Queen Street

If the call centre or people taking the calls don’t have access to the map when new customers ring, there can be major time wasting and potential for problems ensuring that the right person is dealing with the client quickly and professionally in order to secure new business. There are also issues over making sure the address is correct. There are a dozen Queen Streets in Auckland and we have heard plenty of stories about people driving up and down a road in the wrong suburb looking for a client they are meant to be meeting with. Then there are vanity suburbs like the person on Remuera Road who say they are in Remuera, but they are actually in Newmarket and knowing which numbers of the street belong in which territory. It is a problem that has been around for years.

This problem goes away with BIonaMAP and there are a number of ways that we can deal with it. Some companies are simply going to use a query on the BIonaMAP home page which effectively allows you to start entering the address, with an autocompleter allowing you to select from a drop down menu to get the right one. Some companies are going to integrate this function right into their accounting software, CRM or other business database application, which means that the full correct address with Post Code and correct suburb as well as the coordinates are recorded into the right fields.

What makes this different? Database applications on their own can deal with suburbs or post codes, but typically can not deal with spatial queries, i.e. in what territory or polygon does this belong to? The answer effectively will be one of the following:

  • It belongs in Territory X.
  • It appears in Territory X and overlapping Territory Y (e.g. a sales and a service territory)
  • It doesn’t appear in any territory

If this is an issue that you have to grapple with in your business, why not contact us and ask us how BIonaMAP can help you?

BIonaMAP is available for New Zealand and Australia and has a host of location based business analytics capability. It is Software as a Service which means no software installation and it can be accessed by using a web browser. We also welcome inquiries from sales, service, franchise and other business consultants, resellers and systems integrators.

May 1, 2012 Posted by | Australia Maps, Business Analytics, Business Intelligence, Business Tools, Data Mining, Distribution, geosmart, GIS, map tools, Mapping Applications, Marketing, new zealand, new zealand maps, SaaS, Sales, sales territory, systems integrator, territory management, Uncategorized | , , , , , , , , , , , , , , , , | Leave a comment

Giving Location Based Business Intelligence to Middle Management

In the traditional corporate environment location based information about your business tends to come from the IT or GIS department. This tends to result in traditional reports based on historic requirements. They tend to be standard reports that you receive in the same way as you receive your financial reports. In New Zealand only large corporates even have access to GIS data. BAU (Business As Usual) means results as usual at best, but if someone else is working smarter, that means that they are likely to be taking business off yours.

Our BIonaMAP application changes that. There is no installation required and it is now simple for a Sales Manager, Service Manager, Product Manager, Marketing Manager and others to have access to what is going on in their business in ways they haven’t been able to before.

One of the most basic areas I have found in previous lives as a Sales Manager and as a Franchisor has been creating fair territories on a map. This traditionally involved buying a map, using a sharpie pen to create a territory and covering it in different colours of map pins. Of course as soon as you created a territory and needed to change it, it was start again and of course now your office wall is covered in holes. Now it is as simple as clicking with your mouse and your new territory has been created. Zoom in on the map to tidy it up so that you can split streets up to left and right if necessary and now you can start viewing what is going on in your business.

Understanding what is happening in a territory

Any information you have about your customers in a CRM, accounting software that you can export can now be viewed on the map and you can run queries about that data and view the results straight away on the map. Examples might be profitable customers, customers who haven’t bought anything in the last month, customers who buy one product but not another, prospects who use a competitors product. You can count results and compare territories with each other with ease. Why is one territory better than another?

I wish I had browser based software like this in the past, it is just so powerful and easy. What information would you like to unlock from your business? Find out more at www.bionamap.co.nz

April 22, 2012 Posted by | Business Analytics, Business Intelligence, Business Tools, Data Mining, GIS, new zealand maps, Sales, sales territory, Uncategorized | , , , , , , , , , | Leave a comment

Banking, Finance, Location and Business Intelligence

I was just reading an article about some research from Avaya and BT about The Autonomous Customer. It reiterates a lot of inmation you already know but should perhaps be reminded of.

  • 60% of respondents said they change their contact channel with brands based on context, i.e. where they are and what they are doing.
  • 51%, the autonomous customers, cut organisations out of the loop altogether but trust the advice of unknown others on forums, review sites etc.
  • 46% regard customer loyalty as a thing of the past

I found this research through an article at thewherebusiness.com which discussed research about how people are managing their money. Where they bank, how they decide to borrow money and the influence in location on those factors. It makes for interesting reading and whilst New Zealand is a small country and has few banks, one element that shone through with high relevance was the willingness of people to share their location with their bank or credit card company.

The relevance for New Zealand of course is that 4 Canadian people have just been arrested for putting skimmers (devices that copy the information from the magnetic stripe on your credit or EFTPOS card) and subsequently allowing people to draw money from at least 60 people’s accounts over Easter 2012 from ATM machines in Canada. The story says that these skimmers had apparently been installed in Parnell, Ponsonby, Orewa, Takapuna and Howick and allowed the theft of account information from at least 500 people.

If the banks embraced location based technology with Smartphones (before Google Wallet, Paypal or a telco takes over m-commerce) people who allow their banks to know where they are through their mobile could be protected. Effectively if the bank knows I am in New Zealand, then I am unlikely to be in a position to withdraw money from an ATM in Canada with my card.

Of course there is a lot more gold (pardon the pun) in location based intelligence for banks. Banks probably all have a GIS person on board who has the ability to prepare reports for Business Analysts to make decisions about where to put branches, based on where their customers live, work and play. However, the problem with GIS is that unless you have personal access to it in real time and can do modelling with ease (requiring software and skills) and without long delays or having to wait for someone else to run queries on what they think you asked for, it can easily end up in the too hard basket.

In today’s world where a large percentage of people do not carry cash, but want to borrow and spend money, finance houses and banks need tools like BIonaMAP to be able to understand what their customers are doing and where. Tools that are secure, but can be accessed via a web browser within the intranet can allow the modern banker to stay a step ahead of their competitors. If you can’t assume loyalty, you need to understand your clients and their needs and be ready to adapt quickly.

According to this 3 News Story today, Credit Card Fraud Proceeds Surpass the Drug Trade. That must be a good motivator for banks to start talking to location based service companies like GeoSmart.

According to this Australian story from Today Tonight, it takes just 60 seconds for someone to convert a retail EFTPOS terminal to steal information from all of the cards that are swiped through it and the customers would have no idea their identities had been stolen. What does this cost the industry and what stress does this cause to consumers? BAU Business As Usual can’t be the way forward for the finance industry. I’m sure we don’t want to go back to carrying cash. Would you be happy to let the banking system know where you are so that they can confirm that the person using your card is you?

April 10, 2012 Posted by | Business Analytics, Business Intelligence, Data Mining, geosmart, GIS, location based services, new zealand, proximity based marketing, Retail, Uncategorized | , , , , , , , , , , , , , , , , , , | Leave a comment

Business Intelligence for Security and Alarm Companies

I just read a story about an application in the US which I posted on our Facebook Page about an alarm company which is providing an application for people who use their home alarm systems, which uses geofences (a line around an area, such as your property)  drawn with a mouse on a map to send a notification to people’s mobiles when they have left home, but haven’t set the alarm.

Of course the first thing I thought of was why didn’t someone in New Zealand think of that. The answer is probably that alarm and security companies in New Zealand are probably too focussed on BAU (Business As Usual) although I’d love to be proved wrong.

Of course GeoSmart has the technology to enable a solution like this. It would be easy to do and could be a huge value add to the purchase of a home burglar alarm. I’d probably go a step further and enable the possibility of arming the alarm remotely when you realise you have dones this and you have already left, or the ability to disarm it if you have someone at home that doesn’t have the code and has just set the alarm off.

I had previously thought that the security industry could use our BIonaMAP application as well, but have focussed on industries where we already have client demand. As you can see on the web page above, BIonaMAP allows you to see your customer locations on a map and run queries from your business data and view it on a map. This could include:

  • Show all customers on a map who have a particular type of alarm
  • Show all customers whose alarm needs a preventative maintenance visit
  • Show all customers who hasn’t ad a visit or sales call within a certain period of time
  • Show all customers in an area by the number of security guard visits
  • Show scheduled visits by security guard run on different nights of the week, different staff in different colours
  • Show results of sales calls including yes, no, maybe or by competitor brand
  • Show domestic clients by demographic
  • Find new clients by demographic statistics e.g. household income right down to street addresses within a mesh block

As an example, this picture illustrates using BIonaMAP to find areas where the people have lived in their homes for between 5 and 9 years AND have a household income of over $80,000 p.a. which could possibly be a good target market to purchase monitored home burglar alarms. BIonaMAP can even provide street addresses for the houses within those shaded areas.

March 28, 2012 Posted by | Auckland, Business Analytics, Business Intelligence, Business Tools, geosmart, GIS, iphone, Mapping Applications, new zealand, sales territory, Uncategorized | , , , , , , , , , , , , , , | Leave a comment

Adding Location To Loyalty Card Apps

There are obviously lots of different kinds of loyalty cards. I have somewhere between 10 and 20 cards ranging from Coffee Cards through to Airline Frequent Flyer Cards. I have so many I can’t carry them all in my wallet, which is unfortunate when I find myself in a position to use one. I do carry a Smartphone, so there are opportunities to carry apps. Many retail companies in New Zealand now have apps, mostly on iPhone and Android. They range from cafe’s and fast food companies to tourism and banks. Features include the ability to order food from a specific store, the ability to view the store on the map, make reservations and view points.

A lot of companies have had back on using Smartphone applications for loyalty programs on the basis that there are not enough people using them. At the last Social Media Club Auckland event one of the panel questions was what is the penetration of Smartphones in New Zealand. No one had an answer as the telco’s generally don’t want to share this competitive information. However in this month’s IT Brief there was a quote from Tony Baird of Vodafone saying that 66% of their mobile users now have Smartphones. That’s pretty high penetration and growing rapidly as is their data traffic which grew from 60TB in June last year to 135 TB in June this year. It would be reasonable to expect at least Telecom to be showing similar penetration.

So, in my last post I talked about a number of aspects of getting to know your customers. Given the statistics in the poll on my previous blog almost 70% of loyalty card holders do not specifically head to shop at a store where they have a loyalty card. In effect this says that the loyalty card in most cases is not attracting people to do business, or effectively be loyal to the retailer or group who invest a lot of time and money into the card systems in manufacture, distribution and all the other aspects of running a loyalty program.

What is missing? I believe that one aspect is not really understanding the customer. Let’s start simple. How do you get a loyalty card? Obviously it varies. Some cards like a coffee card are as simple as the retailer offering the card to a customer when they are in the store buying a coffee, the retailer invites them to start using a card, typically offering your 11th cup free. At the other end of the scale there are forms to fill out, which confidentially provides the company with significant information about the person. This may include:

  • Home address
  • Home and Mobile Phone numbers
  • Age
  • Household income
  • Interests
  • Family details e.g. single, married, children under or over a certain age
  • Occupation
  • Email address

In theory this enables the loyalty program to target information to the member and under strict Direct Marketing opt in guidelines, make offers to the members, which typically comes in the form of eDM’s and Direct Mail. The latter is a very expensive form of marketing as is normal advertising such as print, radio and TVC’s. For many industries and products this is tough business. How often do you buy a lawn mower, a TV or an iPhone? The marketing only works when you are open to buy. I recently purchased a new lawn mower, but it was the first one in over 10 years. If I had kept every lawn mower advertisement that arrived in my letter box trying to sell me one and looked at the creative, print and distribution costs, it might have been cheaper for them to give me a lawnmower. Of course all of this advertising is focussed on products that everyone is selling, there is very little focus on products that are unique. Everyone has a promotion on a printer, a TV, an iPhone which forces everyone to focus on price, heavy discounts and the consumer wins if they are looking for that product. Profits up the value chain are massively eroded through the competitive pricing and costs of marketing.

Data Mining and Business Intelligence are already used by some companies and very soon GeoSmart will be launching the much anticipated BIonaMAP we have discussed in many blogs in the past. This will allow companies to better understand their customers on the basis of the data provided, including the ability to view their customers and query their information in relation to the Department of Statistics mesh blocks and area units.

Canberra Income $100,000+

In this example we looked for   where the average household income in Canberra (yes we do Australia too) is equal to or greater than $100,000. If we were looking for loyalty members who had higher than average discretionary spending capability, this could be a very useful tool for target marketing. We could potentially make special offers by overlaying our loyalty card members in this SaaS (Software as a Service) application and then querying them from a combination of the information we have about them and the information the statistics department has about people in the area.

In the coming blogs I will get into more detail about what the implications are from the perspective of location, but like anything you need to start at the beginning and in many cases as I have outlined,  scatter gun marketing, throwing leaflets into letter boxes does not effectively target people who might change their behaviour in favour of your product or brand.

The key to loyalty is a relationship and this comes from engagement. You don’t engage well by putting something in someone’s letterbox. You engage by understanding who they are, what their needs are, when they are out and about and open to buy. As a retailer with a loyalty program you have huge amounts of information about your clients at your fingertips, which is untouched.

Here’s a simple example to finish this blog. Paper Plus not only supports Fly Buys, but they also have their own card called My Big Deal. They run promotions for people who use that card. Right now they have a sale on certain children’s books. If you buy the books using your loyalty card and they store that information, they now know (if they didn’t ask in their registration form) that you either have children or have a relationship with children, perhaps as a grandparent. So they know you buy children’s books. This is valuable information that you could take advantage of in your proximity based marketing application.

More on the location based aspect for apps is coming up, now that we have covered some basics. If this is of interest, please bookmark or subscribe. If you know of someone else who might be interested, why not send them a link? If you would like to discuss these concepts with us about your own business, please contact us.

September 20, 2011 Posted by | Australia Maps, Business Analytics, Business Intelligence, Business Tools, Data Mining, Distribution, geosmart, GIS, iphone, location based services, Loyalty Card, Mapping Applications, Marketing, new zealand, new zealand maps, Print Advertising, proximity based marketing, Radio Advertising, Retail, Retail Profit, SaaS, territory management | , , , , , , , , , , , , , , , , , , , , , , | 1 Comment

Sead Latest in IT Seminar – Mobile Technology

A couple of weeks ago our Sales & Marketing Manager, Luigi Cappel had the privilege of presenting to a group of ICT professionals at the Mercure Hotel hosted by Sead I.T. People. The presentation in the series of Sead Latest in IT Seminar was on Mobile Marketing.

Sead Presentation

The audience came from a wide range of industries and were encouraged to remember the passion that encouraged them to join the industry as innovators in their companies, showing them how to use technology to grow their companies, solving business problems, improving efficiencies and increasing productivity and profit.

Covering topics including the latest Gartner Hype Cycle predictions, Location and Proximity Based Marketing, Check In Marketing, Mobile Computing, QR Codes, Business Intelligence using maps and the hot topic of the use of personal devices in a corporate market, there was something in it for everyone. Case studies illustrated not only practical use of technology, but professional processes to ensure that projects were well designed for success.

The presentation outlined the ongoing chasm between people in the ICT profession and their colleagues when it came to understanding and use of new technologies, particularly mobile and location based. Luigi encouraged the audience ranging from consultants to CIO’s to consider how they can educate and encourage their companies to understand the new technologies and how they fit into their business frameworks. There are great opportunities for IT people to be welcomed back into the boardroom by working closely with the management team to show them how to implement and benefit from new technologies, safely and securely.

Luigi and the Sead Team at the Mercure

September 5, 2011 Posted by | Auckland, Business Analytics, Business Intelligence, Business Tools, Check Ins, Data Mining, facebook, foursquare, geosmart, GIS, ICT, iphone, location based services, map tools, Mapping Applications, maps, Marketing, new zealand, proximity based marketing, Retail Profit, ROI, territory management, Uncategorized | , , , , , , , , , , , , , , | Leave a comment

Analysing Car Sales Using Web Map Part 2

Last week I blogged about analysing your car sales (picking an industry at random) from a dealership on a map. I looked at comparing sales between reps by looking at where the clients lived on a map.

The concept is that we have a rich amount of data about our customers, especially when it is large ticket items and their are warranty and other ongoing commitments, not to mention the desire for repeat business. I used examples such as gender, personal or business use, age group, whether there was a trade in and so on. There is of course a lot more information available and there are also of course KPI’s. Please note that in order to do the things I’m talking about, you do not need expensive GIS software or specialist engineers. You already have the people you need, although in some cases an external consultant may help you see things from a fresh perspective.

Selling high ticket items like cars, real estate, quality furniture and furnishings is a tough business, especially in New Zealand and Australia. It’s competitive and the industries also have high staff turnover meaning that personal relationships are likely to be lost. This means that business intelligence and the ability to data mine becomes a lot more important. But at the risk of playing a broken record, finding useful information from your CRM or accounting software other than basic information is difficult. Now most companies in these industries have done business a certain way for many years and often the sales people go from one company to the next, staying in the industry and reinforce the concepts that this is the way the industry does it and we know the industry.

Our focus takes a different tack. These industries have leaders who swim against the current and use whatever technology or new ideas they can find. Are the over achievers or sales champions working harder? I would argue that most of them are working smarter rather than harder. The difference is that they look for ways to work smarter, whereas the other 95% plus use what they are given. The fact that you are reading this blog puts you in the top 10%. I’ve been told that in the industries I’m writing about here, the Pareto Principle is actually way out. They say that the best business is actually done by less than 5% of the sales people.

So what can you do as a company to improve your odds? How about trying something different? Let us help you find the low hanging fruit that has been eluding you. Lets use some business intelligence and move on. Now ideally what I am talking about would start at Head Office with the Sales Manager, Marketing Manager, Financial Controller or perhaps all of the above. Who is motivated to increase your profitability and productivity? How can you make it easy for your branches or dealerships to improve their performance?

In the last blog we talked about measuring performance at the dealership level, by the dealership. I’ve been in those offices and seen sales people going through the accounting system looking for people or companies whose leases are about to expire, or who last made a purchase 3-5 years ago and making prospecting phone calls. I’ve seen them cold calling using Yellow Pages or other directories. I’ve attended some of the sales meetings as a guest and seen the white board which shows the branch budget by model, the sales to date for the month and the stressed looks on the faces of all involved whose income and livelihood depend on achieving those targets. It’s very seat of the pants and very reactive.

Imagine if at head office, you could provide the dealerships with business intelligence that increased branch sales nationally. If you could give them information that allowed them to increase productivity and profitability and at the same time increase your brand market share. Wouldn’t it be nice to achieve the KPI’s you or the manufacturers are setting? Selling the cars (or whatever your product is) that have the higher margins, or perhaps more accessories which carry that extra margin.

How? I’m sorry but I’m going to tease you here. Have a look through the previous blogs here because a lot of the information I have to share works across multiple industries. Bookmark this page because I am going to write Part 3 of Analysing Car Sales Using Web Map some time in the next few days and give you some specific examples. Where are your potential low hanging fruit? Do you want to pick them? Jump on the school bus and drive through the opposition.

Drive through the opposition

Of course you can also contact us and discuss how we can help you or ask for a demonstration. You can also email me directly. We would also like to hear from business and franchise consultants looking to add tools to their toolbox.

Also please feel free to leave a comment or ask any questions here on the blog, we welcome your feedback.

January 26, 2011 Posted by | Auckland, Australia, Australia Maps, Business Analytics, Business Intelligence, Car Sales, competition, Data Mining, Distribution, geosmart, GIS, location based services, map tools, Mapping Applications, maps, Marketing, new zealand, new zealand maps, Real Estate, ROI, SaaS, sales territory, software, territory management, Uncategorized, Web Map, web maps | , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

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.

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