Google Maps Expert

Summary We have an outlet base of circa 350 to 400 sales points. We supply 2 different magazine titles. These outlets cover a large area of mainland Spain. These outlets have several layers of information, delivery agent, Magazine title, accounting type, Weekly sales volume and outlet type. We need to be able to map these to give both a visual view of these outlets and a report of the outputs. We need to be able to slice and sort the data by the attached hierarchy. Sales Agents We have up to 15 delivery agents Magazine Titles We have two different magazine titles. ( 3 categories are required, one for each title and one for both) Accounting type Our outlets are classed by two different accounting types Sales volume We classify the outlets by 5 different levels of sale. Outlet type We classify our outlets by 5 different types. We require a system that allows us to map our outlets by one or more of the above categories simply by selecting one or more of the categories. The project delivery is a working program that allows us to add / remove outlets and change delivery agent, accounting type and sales volume. At the simplest level we would want to see all the outlets plotted on a map at the most complex it would be outlet by sales agent, by magazine title, by accounting type, by sales, by outlet type and all variations in between. For any of the criteria we would want to be able to sort by one of the types.