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.

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.

Petrol Price Hikes and Route Optimisation

If you are in business and have a fleet of vehicles on the road, you will be very aware of the increase in the price of petrol. This morning’s story in the NZ Herald Business Section suggests that fuel prices won’t be going down soon. There is of course the tension in the Middle East which has driven oil prices as high as US$103 a barrel and the NZ exchange rate has suffered not only with the Christchurch Earthquake, but also the expectation that the Reserve Bank will cut the cash rate on March 10. This makes our currency less attractive and we have dropped 2 cents against the US dollar in the last month.

One option is to shop around. Cardlink has a website called Pricewatch, which shows what people who have their fuel cards are paying, but of course these are discounted prices. Prices vary around the country, but even then you will struggle to find anything below $2 if you consider $1.999 as being below $2.

The AA Petrol Watch web page suggests that the oil companies have only passed on half their increase in costs, so far. There has also been talk of shielding Christchurch of increases which is great, but of course the rest of us will have to subsidise that.

The problem from a business perspective is that whilst our running costs increase, our clients expect to pay the same or less for our products and services. If your products and services involve distribution, delivery or field work, this becomes a serious problem. This is a problem that GeoSmart may be able to assist with.

Our solution is Route Optimisation. We have a solution called Route2Go, which you may have read about in previous blogs. In simple terms, give us a list of the jobs that a vehicle has to do in a day and our solution will advise you which order to do them in, to drive the least distance and in the shortest time by calculating the fastest route. Even without the price rises in petrol, this is saving clients a lot of cost, but now it is even more attractive.

The best thing is that we offer you the chance to evaluate this product in relation to your unique business for free. As per the PDF which you can download below, if you would like to send us the addresses of 5 existing daily runs (we don’t need to know the names of the companies, or will provide a confidentiality agreement) in the order that they have been done, we will optimise them for free and send you the results.

Route2GO is a Software a a Service (SaaS) application which means there is nothing to install and no set up fee. You simply pay for the number of locations you optimise to. With the results of the free trial, you will be able to see exactly what your savings can be as a result of using the service.

What have you got to lose? Try us now. Please note this service is currently only available in New Zealand.

Route2GO Flyer

P.S. Did I mention green? If you are reducing the distance you drive you are of course also reducing your carbon footprint.

P.P.S. Optimisation can also mean that you can fit more jobs into a day without increasing your fixed overheads.

Franchise Territory Mapping Part 1

A few days ago I blogged about a new application we are launching soon which will allow you to create business territories in a Software as a Service (SaaS) environment. The great thing about this is that it doesn’t require the installation of any software, all you need is a web browser and an account.

Location based business analytics usually requires expensive GIS software and people with GIS experience to operate. One of the concepts we are big on at GeoSmart Maps is providing access to this type of technology to any business people who need information, without requiring specialist skills. By providing solutions like this, Route2GO route optimisation and others in a browser environment all you really need is business expertise and the desire to improve business efficiency and profit.

The franchise industry is of course about location and often involves creating territories, which are then licensed to the franchisee. Key concerns about these territories is that they offer a viable business opportunity and are priced according to the potential earning capacity and customer base. The GeoSmart solution makes it easy to do this. First of all, creating a territory is as simple as clicking with your mouse to create a polygon covering the area of the territory. Territories can be ‘snapped’ to each other so that boundaries can align perfectly.

Where a territory comes with existing clients, they can be displayed on the map and an associated table can provide the ability to display a count of existing clients and related tabular information, which can contain any required information that can be uploaded from the accounting package, CRM or franchise software.

For example if it was a lawnmowing franchise, it could display and list each customer with their address, frequency of mowing, the dollar value per job, whether there payments are up to date, how the customer was acquired and how long they have been a client and so on. It might show the last date the client was serviced, or the next date that their lawn is due for mowing.

Within the application, Boolean queries can allow the franchisee or franchisor to visualise their clients on the web map based on the criteria in the tables. For example you could display all clients on the map that are due for mowing and use this to plan which clients to visit today. You could view the most profitable customers on a map.

You could view customers by acquisition method which could be valuable for marketing purposes, displaying all clients who responded to print advertising, letter box flyers or word of mouth recommendations. This could be analysed to identify not only what methods of marketing work,  differences by neighbourhood. It is amazing how visualising information on a map can highlight information that you may not notice when looking at reports and spreadsheets.

Franchise territory mapping can be a major asset to the franchise industry, helping people quickly and easily work on their business as well as in it. If this is of interest to you, please feel free to contact us and bookmark or subscribe to this blog where we will be providing more information on how to using territory mapping to improve your business.

Free AA Traffic on your Navman MY30 at Dick Smith if You are Quick

This isn’t really what this blog is usually about, but this is such a great deal, that I thought I’d share it with you.

This month, i.e. right now, we have supported a Navman promotion with Dick Smith Electronics. The deal is (while stocks last) that you can buy a Navman MY30 for $266 and they will include a free Lifetime License for AA Traffic. AA Traffic is normally a $129 add on, so this is an awesome deal.

This is a great opportunity to try out AA Real Time Traffic on a nav unit. This is one of the best ways to get AA Traffic. You don’t have to look at a web site like Roadwatch or AA Maps before you go. You don’t have to subscribe to a TXT or Email Alert service. You don’t even have to know where you are going before you get into your car.

People have often said, I know my way around, so I don’t need car navigation. They may well be right, but they don’t know what may be happening on the road ahead.  Does it matter, not if you don’t mind spending hours detouring around an incident or waiting until a road reopens. This week we had a stock truck and trailer roll on State Highway One by Puhoi. AA Traffic started sending out alerts at around 6:30 AM, so traffic heading north who were using AA Traffic didn’t get stuck. Here’s the thing. That road, the main road between Auckland and Northland, didn’t reopen for almost 6 hours! What is 6 hours of your work day worth to you?

This was a bad one, but there are always incidents, roadworks, slips, floods, wandering stock and all manner of issues on our roads. At the time I am writing this blog, we have 479 current incidents and 478 upcoming incidents such as ramp closures, sporting events etc. Here’s a classic situation for you. You go to an evening concert in Auckland City and you’re heading home to the North Shore. You get to Fanshawe St to get on the motorway to cross the Auckland Harbour Bridge and the on-ramp is closed for maintenance, which they deliberately do at night to reduce inconvenience to motorists, but it has to be done. Do you know how to get to an alternative on-ramp? Your car nav does and would have told you when you first got in your car, so you wouldn’t have even tried that entrance.

Smart people who know their way around New Zealand but spend a lot of time on the road will be buying car navigation to be able to access real time traffic so they can avoid accidents and incidents. This deal is only for limited stock, so you need to get to your local Dick Smith Electronics store quick-smart.  The deal is for a Navman MY30 at $266 and AA Traffic (usually $129) is only while stocks last. Great Mother’s Day gift, or for yourself.

Not convinced? If you lost a few hours on 4th of May when SH1 closed by Puhoi, how much was that time worth to your company? Less than $266? How often can you buy a business tool that gives you ROI that quickly? What if you were heading to the airport to catch a plane for a day trip to Wellington or for an overseas business trip or holiday. I’m sure it happened to some people.

Sometimes these incidents are an irritation, sometimes they are major.  With AA Traffic on your car navigation unit, they can very often be avoided entirely.

GeoSmart seeks channel partners and Systems Integrators for Route²GO Lite

We have had a route optimisation  product Route²GO for several years, but it has been at the complex end and designed for companies with a skilled IT department or systems integrators who typically work with Fleet Management companies such as Navman Wireless. This is great for the big guys who can cost justify a semi bespoke integration into their legacy systems or a new installation, but that doesn’t fit most companies in New Zealand.

We have just completed a new product called Route²GO Lite. This product can work stand-alone for people that have database skills and we are happy to offer it to companies who can deal with it, however what we are really looking for is companies who already have solutions that support people who travel in the field, mostly for business purposes of some sort. Route²GO Lite can add value to your application and of course we offer a generous income stream for software companies and channel partners who wish to add value to their products and services. It is a SAAS (Software as a Service) product and the pricing is based around usage of the services, with pricing scaled around volume usage. Please contact us to discuss how this can work for you.

Route²GO Lite has 2 components. The first component is geocoding. Geocoding is essentially generating spatial co-ordinates for each location (usually a street address, but could be anywhere, for example a jetty or a park bench for pizza delivery). Essentially a CSV file is uploaded and those addresses that don’t already have co-ordinates will have them added. The second component is identifying in which order to make the stops on a trip.

This in itself is wonderful, but software developers and systems integrators can make it far more relevant to the specific industry segment or activity, adding serious value to their products and solutions and providing a great ROI for their customers, and thereby improving client retention and increasing new sales and revenue opportunities. Future blogs will discuss more specifics about value adds. You might like to subscribe to or bookmark this blog.

Our target is to partner with companies who develop or sell and set up software solutions. Examples of the type of applications we are looking for are:

• Sales Force Automation – Sales is often about how many visits you can make in a day, especially for merchandisers and travelling sales people.
• Routine Delivery / Swap Out Services – This would also be a classic case for many repeat delivery type sales situations, for example delivery and exchange of gas bottles, water bottles etc. Also time critical runs such as medical test samples, the list goes on. Most business these days requires a degree of software to automate their operations, but they are usually focussed on business imperatives rather than the location logistics which are a major factor in the timeliness and quality of service.
• Field Service Automation – There are many aspects to the field service such as Preventative Maintenance (PM) visits where time is the difference between being competitive and profitable or not. This includes meter reading, building inspections, security system maintenance, air conditioning maintenance, an endless variety of industries.
• CRM – A lot of customer relationships are about visits.
• Retail specialist Point of Sale – There are many software applications designed for retail stores such as furniture, appliances and other large items that require delivery. They are often good at recording the sale, collecting the delivery address etc, but there are challenges around charging a fair price for the delivery, giving the customer an estimate of when to expect the delivery etc. Route²GO Lite would replace the traditional bullseye method of doing deliveries which often can’t reflect the actual driving distance.

• Taxi despatch applications. There are often situations where a taxi van has to pick up and drop off a number of people to different locations. It could be picking up elderly people to go to their hospital appointments, taking special needs children to school, picking up people to go to or from the airport. All of these situations can benefit from optimisation to reduce distance, time and stress, which all impact on the quality of the service, often with serious implications.
• Security Industry software. What’s the best order for travelling security personnel for checking business locations? This can determine how many staff are needed to meet contractual obligations and provide the best service.
• ERP and Logistics. There are many applications of all sizes from massive to small that automate the value chain in a business. Most businesses ultimately have an element that involves vehicles making several stops in one run. These solutions are designed to work together with 3rd party applications and plugins.
• Accounting Software. On a per capita basis New Zealand has a phenomenal number of different accounting packages. Most of these support export and import of data from other sources, probably all of them support CSV import and export which is where Route²GO Lite excels.

If you have a software application that supports any of the industries listed above, or support these tpes of businesses please contact us to discuss how we can work with you. GeoSmart wants to help.