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. |