Before I even strike out to attempt this, I need some more info on
feasibility.

My goal:

To create a map that will define hot/cold sales regions based on sales
data, and create polygons around said regions. I will also incorporate
sales data into the pop-up callouts.

I know I can load the lat/long data from our database, but I'm not
sure about the sales data, and defining regions based on that.

For instance:
Company A - we sold $3k in March, $0 in April, and $4k in May
Company B - no sales from Feb-June, $2k in July, no sales Aug.-Sept.
Company C - sold $15k consistently every month
Company D - no sales all year
Company E - $20k Feb, $2.5k March, $9k April, and so on.

Companies A and C are 20 miles apart, Companies B and D are 30 miles
apart.

Based on that sales data, and geo-data, plot a polygon that
encapsulates B and D, and another that encapsulates A and C, so we can
see where we need to be focusing.
If Company E falls in the region of B and D, there would be a ratio of
sales/nosales. If sales/nosales>1.5, plot green and label region OK.
If 1.5>sales/nosales>1, plot yellow and label region Needs Work. If
0.25<sales/nosales<1, plot orange and label region Attention Needed.
If sales/nosales<0.25, plot red and label region Needs Market
Penetration.

OR

Find areas where sales/nosales>1, <1, 0, etc. and plot them
accordingly.

The goal is to show us where we need to market to, and where we don't
need to focus as much energy. It will incorporate data from several
hundred companies.

Is the maps API ready to handle such a thing? The math is going to be
fun, but I need to know if it is even possible before I delve too
deeply into it.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Google Maps API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/Google-Maps-API?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to