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.
	POPWGTCY	Percentage of how much one sub-category boundary current-year population is contained in the overlay geographic boundary.
	HHWGTCY	Percentage of how much one sub-geography boundary current-year households is contained in the overlay geographic boundary.
	HUWGTCY	Percentage of how much one sub-category boundary current-year housing units is contained in the overlay geographic boundary.
	BUSWGTCY	Percentage of how much one sub-category boundary current-year businesses 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.