Essential Business Analyst Vocabulary - Attributes

Tool

Attribute

Description

Customer Prospecting - PCA

RANK

Number of PCA factors based criteria met.

Rank Similar Sites - PCA

RANK

Number of PCA factors based criteria met.

Rank Similar Sites - Conventional

RANK

Number of regular criteria met.

Find Optimal Store Locations

CENTROID

When you select the STORE_ID field, the source STORE_ID value that identifies the store to which the mean store center is related. When you don't select the STORE_ID but select the number of clusters, that would be just the unique IDs of the cluster in the order they were generated.

WEIGHT

When you select the Customer Weight field, this will contain the sum of weights of customers that are related to each STORE_ID, or to each cluster. The number of customers for each STORE_ID or for each cluster if weight field wasn't selected.

Rank Markets

Percentage

(Primary field to rank / Rank percentages) *100. For example, if the "Primary field to rank" is female population and the "Rank percentages" is total population, then the Percentage field is the percent of female population in the current area.

AVER_R

The average of all variable rankings.

Dissolve by Attribute

RADIUS

Upper break value. For example, if you select to dissolve by population and create contours of 50,000; 100,000 and 200,000 the field will contain 50000, 100000 and 200000.

Original Huff Model

GM_PROB

Huff probability of the geography unit. Probability for customers living in the geography unit to visit the new store rather than a competitor.

GM_TOTAL

Expected amount of dollars for this geography unit. Is defined as GM_PROB*PotentialSales(geography unit).

Customer Derived Areas

Count

Number of customers encompassed in the output polygon.

Weight

Sum of weights of the customers in the output polygon.

Market Penetration, Trade Area Penetration, Distance Decay

BA_CUST

Number of customers for each trade area.

BA_TCUST

Total number of customers for each store.

BA_PCUST

Percent of the customers (100*BA_CUST/BA_TCUST).

BA_CUSTW

Same as BA_CUST but based on assigned weights rather than customer counts.

BA_TCUSTW

Same as BA_TCUST but based on assigned weights rather than customer counts.

BA_PCUSTW

Same as BA_PCUST but based on assigned weights rather than customer counts.

BA_BASEVAL

Base value for calculating penetration (Total Mkt Count); this is often total households or population.

BA_MKT_P

Market Penetration (=100 *BA_CUST/BA_BASEVAL)

Proximity Analysis

TIME

Time measured from store to business location.

DISTANCE

Distance measured from store to business location.

DIRECTION

Direction between store and business location (NW, SE, and so on).

Rank Markets

Rank

Order of variables by statistical ranking, 1 being best.

Percentage

(Primary field to rank / Rank percentages) *100. For example, if the "Primary field to rank" is female population and the "Rank percentages" is total population, then the Percentage field is the percent of female population in the current area.

Summarize Points

POINTCOUNT

The sum of points within a boundary.

Spider Diagrams

DRTIME

The measure of drive time from store to customer.

DRDISTANCE

The traversable road distance unit from store to customer.

SLDISTANCE

The Euclidean distance unit from store to customer.

Customer Derived Areas

Count

The number of customers within each band.

Weight

The sum of the selected customer weight field from each customer within each band.

Threshold Drive Time Area

REAL_COST

Actual value when threshold is met; can vary slightly based on geographies drive times.

SUMM_FIELD

Variable used to determine the threshold.

Find Component Geographies

Ratio

Percentage of how much one sub-geography boundary is contained in the overlay geographic boundary.

POPWGT10

Percentage of how much one sub-geography boundary 2010 year population is contained in the overlay geographic boundary.

HHWGT10

Percentage of how much one sub-geography boundary 2010 year households is contained in the overlay geographic boundary.

HUWGT10

Percentage of how much one sub-geography boundary 2010 year housing units is contained in the overlay geographic boundary.

General (used throughout several tools)

AREA_ID

Uniquely identifies each trade area and ring within each trade area by combining the ID and RING values. This attribute is especially important for distinguishing multiple sites with multiple rings. If there are three Simple Ring breaks, The AREA_ID values are 0_1, 0_2, 0_3.

AREA_DESC

Used as a descriptive field for reports. Displays the RING_DEFN as a "from - to" description. AREA_DESC for a RING_DEFN of 5 Minutes = "0 - 5 Minutes". A 5-mile simple ring = "0 - 5 miles"

AREA_DESC2

Used as a descriptive field for reports. Displays the tool and the RING_DEFN. So a 5-minute drive time trade area = "Drive Time: 5 minutes". A 5-mile simple ring trade area = "Ring: 5 miles radius".

AREA_DESC3

Used as a descriptive field for reports. Displays the tool and the RING_DEFN plus combines each band. So a 5,10,15-min drive time trade area = "Drive Time: 5, 10, 15 minutes". A 5, 10, 25 mile simple ring trade area = "Ring: 5, 10, 15 miles radii".

TA_DESC

A description automatically given to certain trade areas. A Standard Geography ZIP Code trade area of 92373 would get a description of "TA from geography Layer : 92373".

ID

A unique identifier code used in a variety of tools. Automatically assigned a zero for Evaluate Site. FIPS or assigned numeric IDs for Counties and ZIP Codes.

STORE_ID

A unique ID assigned to a store, often in a Store layer. STORE_ID can often be found in a Customer layer to link the customer back to the store they shopped.

CUST_ID

A unique ID assigned to a customer.

STORE_NAME

Name given to a trade area that appears in some reports. In many cases, NAME or NAMES is used in place of STORE_NAME.

RING

Assigns an ascending numeric ID to each ring, beginning with 1. If there are three Simple Ring breaks, the RING values are 1, 2, 3.

RING_DEFN

Displays each ring value (distance/time or threshold units), defined by you. RING_DEFN for a 5Mile Simple Ring = 5. RING DEFN for the drive time option appends the ring value units, for example; The DEFN_RING for a 5min ring = 5 Minutes.


5/15/2012