Create Spider Diagram (Desire Lines)

Desire lines show which customers visit which stores. A line is drawn from each customer point to its associated store point, making it easy to see the actual area of influence of each store.

Spider diagrams are a series of rays drawn from each customer to the store. They can be unweighted (where each customer is counted equally) or weighted (the line from each customer is drawn in different colors or thicknesses depending on variables such as sales or visits). Spider diagrams graphically illustrate the direction or directions of pull in the marketplace. More customers may be pulled from one or two directions than from other directions. Spider diagrams also provide a quick and simple method to see if stores are cannibalizing each other.

The graphic below shows unweighted desire lines drawn from each customer to its store. The desire lines have been drawn as different colors for each store.

Weighted values aren't used to calculate desire lines but to display the lines differently. The thickness (or color) of each desire line is proportional to the weighted variable for that particular customer.

Spider diagrams can be weighted by any number in the customer database. For example, a hospital might weight each patient line by the number of hospital stays per year. Insurance policyholders might be weighted by the number of policies or the dollar value of claims.

Some other examples of desire lines include the following:

Input Prerequisites

You must have customer and store layers with customer to store assignments already generated.

Output Example

This example shows typical output from a desire lines analysis. The attribute table contains a distance field representing the travel time/length between a store and its customers. The map visually shows the spokes between the store and customer points.

Desire Lines

9/16/2010