9 Data

A broad and detailed data set is required to use the capabilities of Category Management to their fullest. Some of the data required is relatively easy to obtain, for example, information about sales, cost, space, and the like. Other data is only available from a data aggregator such as Nielsen or Symphony IRI. Examples of this type of data include information on product and category performance for the market as a whole. Still other data might be sliced in a particular way to provide insight about a particular facet of a customer's buying behavior.

This chapter deals with the data that ideally must be supplied in order to obtain the most benefit from Category Management. Each row represents a measure in Category Management. Data to be loaded into these measures must be supplied at the proper intersection with the proper measure (or file) name.

The optional/required column in the following table is intended to convey the importance of the data to the overall business process of the category management workflow. It does not necessarily indicate that the data feed is required in order to build a domain with success.

File Name	Measure Name	Label	Description	Optional or Required	Type	Base Intx
addvattrnwgtv.csv.ovr	ADDVAttrNWgtV	Attribute Name Weight	Administrator Default Value Attribute Name Weight Value	Optional	real	scls/csd/atn/sgyd
addvattrvwgtv.csv.ovr	ADDVAttrVWgtV	Attribute Value Weight	Administrator Default Value Attribute Value Weight Value	Optional	real	scls/csd/atv/sgyd
addvconsegdistv.csv.ovr	ADDVConSegDistV	Consumer Seg Distribution	Administrator Default Value Consumer Segment Distribution Value	Optional	real	clss/tdar/csd
drtyconsegdistv.csv.ovr	DRTYConSegDistV	TY Consumer Seg Distribution	Default Role This Year Consumer Segment Distribution Value	Optional	real	qrtr/scls/tdar/csd
addvconsegwgtv.csv.ovr	ADDVConSegWgtV	Consumer Seg Weight	Administrator Default Value Consumer Segment Weight Value	Optional	real	clss/tdar/csd
addvfocarwgtv.csv.ovr	ADDVFocArWgtV	Focus Area Weight	Administrator Default Value Focus Area Weight Value	Optional	real	scls/far/csd/sgyd
addvgppwgtv.csv.ovr	ADDVGPpWgtV	Gross Profit % Weight	Administrator Default Value Gross Profit % Weight Value	Optional	real	scls/far/csd/sgyd
addvgpwgtv.csv.ovr	ADDVGPWgtV	Gross Profit Weight	Administrator Default Value Gross Profit Weight Value	Optional	real	scls/far/csd/sgyd
addvloywgtv.csv.ovr	ADDVLoyWgtV	Loyalty Weight	Administrator Default Value Loyalty Weight Value	Optional	real	scls/far/csd/sgyd
addvmktbwgtv.csv.ovr	ADDVMktBWgtV	Market Basket Weight	Administrator Default Value Market Basket Weight Value	Optional	real	scls/far/csd/sgyd
addvslsrwgtv.csv.ovr	ADDVSlsRWgtV	Sales R Weight	Administrator Default Value Sales R Weight Value	Optional	real	scls/far/csd/sgyd
addvslsuwgtv.csv.ovr	ADDVSlsUWgtV	Sales U Weight	Administrator Default Value Sales U Weight Value	Optional	real	scls/far/csd/sgyd
adlyqrtrmaptx.csv.ovr	ADLYQrtrMapTx	LY Quarter Mapping	Administrator Last Year Quarter Mapping Text	Required	string	qrtr
adlyweekmaptx.csv.ovr	ADLYWeekMapTx	LY Week Mapping	Administrator Last Year Week Mapping Text	Required	string	week
adwpcdtprerngb.csv.ovr	ADWPCDTPrerngB	WP CDT Pre Range	Administrator Working Plan CDT Pre Range	Optional	Boolean	qrtr/clss/tdar/csvd
adwptactictx.csv.ovr	ADWPTacticTx	WP Tactic Values	Administrator Working Plan Tactic Values Text	Optional	string	scls/tdar/lnum/tctd
drtyannlspndx.csv.ovr	DRTYAnnlSpndX	TY Annual Spend Index	Default Role This Year Annual Spend Index	Optional	real	qrtr/clss/tdar/csd
drtyassrtelasv.csv.ovr	DRTYAssrtElasV	TY Assortment Elasticity	Default Role This Year ORASE Data Value	Required	real	clss/tdar/csd
drtyattrvaltx.csv.ovr	DRTYAttrValTx	Loaded Attribute Value ID	Attribute Value Position IDs loaded from external sources	Required	string	sku/atn
drtyattrwgtv.csv.ovr	DRTYAttrWgtV	TY Attribute Weight	TY Attribute Weight	Required	real	scls/tdar/csd/atn
	DRHdFuncFitB	Loaded Functional Fit	Functional Fit data is combined with Attribute Weights data inside the ORASE export. The Loaded Functional Fit is appended to the TY Attribute Weight into the TY Attribute Weight load file.		Boolean	clss/tdar/csd/atn
drtyavgbsktvalv.csv.ovr	DRTYAvgBsktValV	TY Avg Basket Value	Default Role This Year Average Basket Value	Optional	real	tdar/csd
drtybopr.csv.ovr	DRTYBOPR	TY BOP R	Default Role This Year Beginning of Period Inventory Retail	Optional	real	week/sku/str
drtybuyersl0p.csv.ovr	DRTYBuyersL0p	TY % Buyers @ SKU %	Default Role This Year % Buyers @ SKU Percent	Optional	real	sku/tdar/rsgd
drtybuyersl3p.csv.ovr	DRTYBuyersL3p	TY % Buyers @ Sub-Cat %	Default Role This Year % Buyers @ Sub-Category Percent	Optional	real	scls/tdar/rsgd
drtybuyersl4p.csv.ovr	DRTYBuyersL4p	TY % Buyers @ Cat %	Default Role This Year % Buyers @ Category Percent	Optional	real	clss/tdar/rsgd
drtybyerconvrtv.csv.ovr	DRTYByerConvRtV	TY Buyer Conversion Rate	Default Role This Year Buyer Conversion Rate Value	Optional	real	scls/str/retd/csd
drtyconsworthx.csv.ovr	DRTYConsWorthX	TY Consumer Worth Index	Default Role This Year Index	Optional	real	sku/str/csd
drtydollarsl0p.csv.ovr	DRTYDollarsL0p	TY % Dollars @ SKU %	Default Role This Year % Dollars @ SKU Percent	Optional	real	sku/tdar/rsgd
drtydollarsl3p.csv.ovr	DRTYDollarsL3p	TY % Dollars @ Sub-Cat %	Default Role This Year % Dollars @ Sub-Category Percent	Optional	real	scls/tdar/rsgd
drtydollarsl4p.csv.ovr	DRTYDollarsL4p	TY % Dollars @ Cat %	Default Role This Year % Dollars @ Category Percent	Optional	real	clss/tdar/rsgd
drtyeopr.csv.ovr	DRTYEOPR	TY EOP R	Default Role This Year Ending of Period Inventory Retail	Optional	real	week/sku/str
drtyexclusivityx.csv.ovr	DRTYExclusivityX	TY Exclusivity Index	Default Role This Year Index	Optional	real	sku/str/csd
drtyfragbrkptp.csv.ovr	DRTYFragBrkptp	TY Fragmentation Analysis Breakpoints %	Default Role This Year Fragmentation Analysis Breakpoints Percent	Required	real	pctd
drtyitmpentrl0p.csv.ovr	DRTYItmPentrL0p	TY Item Penetration @ SKU %	Default Role This Year Item Penetration @ SKU Percent	Optional	real	sku/tdar
drtyitmpentrl3p.csv.ovr	DRTYItmPentrL3p	TY Item Penetration @ Sub-Cat %	Default Role This Year Item Penetration @ Sub-Category Percents	Optional	real	scls/tdar
drtyitmpentrl4p.csv.ovr	DRTYItmPentrL4p	TY Item Penetration @ Cat %	Default Role This Year Item Penetration @ Category Percent	Optional	real	clss/tdar
drtyitmpentrp.csv.ovr	DRTYItmPentrp	TY Item Penetration %	Default Role This Year Item Penetration Percent	Optional	real	qrtr/clss/tdar
drtyitmrevpbyerl0v.csv.ovr	DRTYItmRevpByerL0V	TY Item Revenue per Buyer @ SKU	Default Role This Year Item Revenue per Buyer @ SKU Value	Optional	real	sku/tdar
drtyitmrevpbyerl3v.csv.ovr	DRTYItmRevpByerL3V	TY Item Revenue per Buyer @ Sub-Cat	Default Role This Year Item Revenue per Buyer @ Sub-Category Value	Optional	real	scls/tdar
drtyitmrevpbyerl4v.csv.ovr	DRTYItmRevpByerL4V	TY Item Revenue per Buyer @ Cat	Default Role This Year Item Revenue per Buyer @ Category Value	Optional	real	clss/tdar
drtyitmspndpromol0p.csv.ovr	DRTYItmSpndPromoL0p	TY % Item Spend on Promo @ SKU %	Default Role This Year % Item Spend on Promo @ SKU Percent	Optional	real	sku/tdar
drtyitmspndpromol3p.csv.ovr	DRTYItmSpndPromoL3p	TY % Item Spend on Promo @ Sub-Cat %	Default Role This Year % Item Spend on Promo @ Sub-Category Percent	Optional	real	scls/tdar
drtyitmspndpromol4p.csv.ovr	DRTYItmSpndPromoL4p	TY % Item Spend on Promo @ Cat %	Default Role This Year % Item Spend on Promo @ Category Percent	Optional	real	clss/tdar
drtyitmspndptrpl0v.csv.ovr	DRTYItmSpndpTrpL0V	TY Item Spend per Item per Trip @ SKU	Default Role This Year Item Spend per Item per Trip @ SKU Value	Optional	real	sku/tdar
drtyitmspndptrpl3v.csv.ovr	DRTYItmSpndpTrpL3V	TY Item Spend per Item per Trip @ Sub-Cat	Default Role This Year Item Spend per Item per Trip @ Sub-Category Value	Optional	real	scls/tdar
drtyitmspndptrpl4v.csv.ovr	DRTYItmSpndpTrpL4V	TY Item Spend per Item per Trip @ Cat	Default Role This Year Item Spend per Item per Trip @ Category Value	Optional	real	clss/tdar
drtyitmtrpspbyerl0v.csv.ovr	DRTYItmTrpspByerL0V	TY Item Trips per Item Buyer @ SKU	Default Role This Year Item Trips per Item Buyer @ SKU Value	Optional	real	sku/tdar
drtyitmtrpspbyerl3v.csv.ovr	DRTYItmTrpspByerL3V	TY Item Trips per Item Buyer @ Sub-Cat	Default Role This Year Item Trips per Item Buyer @ Sub-Category Value	Optional	int	scls/tdar
drtyitmtrpspbyerl4v.csv.ovr	DRTYItmTrpspByerL4V	TY Item Trips per Item Buyer @ Cat	Default Role This Year Item Trips per Item Buyer @ Category Value	Optional	real	clss/tdar
drtyloyaltyp.csv.ovr	DRTYLoyaltyp	TY Loyalty (% of Buyer Spend at Retailer)	Default Role This Year Loyalty (% of Buyer Spend at Retailer) Percent	Optional	real	tdar/retd
drtyloyaltyx.csv.ovr	DRTYLoyaltyX	TY Loyalty Index	Default Role This Year Loyalty Index	Optional	real	sku/str/csd
drtymktbasketx.csv.ovr	DRTYMktBasketX	TY Market Basket Index	Default Role This Year Market Basket Index	Optional	real	sku/str/csd
drtymktpromoslsr.csv.ovr	DRTYMktPromoSlsR	TY Market Promo Sales R	Default Role This Year Market Promo Sales Retail	Optional	real	qrtr/scls/tdar
drtymktpromoslsu.csv.ovr	TY Market Promo Sales U	TY Market Promo Sales U	Default Role This Year Market Promo Sales Units	Optional	real	qrtr/scls/tdar
drtymktslsbycsr.csv.ovr	DRTYMktSlsbyCSR	TY Market Sales by Consumer Seg R	Default Role This Year Market Sales by Consumer Segment Retail	Optional	real	qrtr/scls/tdar/csd
drtymktslsr.csv.ovr	DRTYMktSlsR	TY Market Sales R	Default Role This Year Market Sales Retail	Optional	real	week/sku/tdar/retd
drtymktslsu.csv.ovr	DRTYMktSlsU	TY Market Sales U	Default Role This Year Market Sales Units	Optional	real	week/sku/tdar/retd
drtymkttahhp.csv.ovr	DRTYMktTAHHp	TY Market Trading Area HH %	Default Role This Year Market Trading Area Household Percent	Optional	real	tdar/cprd
drtyrtltahhp.csv.ovr	DRTYRtlTAHHp	TY Retailer Trading Area HH %	Default Role This Year Retailer Trading Area Household Percent	Optional	real	tdar/cprd
drtymkttaspndp.csv.ovr	DRTYMktTASpndp	TY Market Trading Area Spend %	Default Role This Year Market Trading Area Spend Percent	Optional	real	tdar/cprd
drtymktturnrr.csv.ovr	DRTYMktTurnRr	TY Market Inv Turn	Default Role This Year Market Inventory Turn Retail Ratio	Optional	real	qrtr/clss/tdar
drtynumbsktwcatv.csv.ovr	DRTYNumBsktwCatV	TY # Baskets with Category	Default Role This Year Number Baskets with Category Value	Optional	real	qrtr/clss/tdar/csd
drtynumcatbsktv.csv.ovr	DRTYNumCatBsktV	TY # of Categories in Basket	Default Role This Year Number of Categories in Basket Value	Optional	real	tdar/csd
drtynumfacingsv.csv.ovr	DRTYNumFacingsV	TY Total # of Facings	Default Role This Year Total Number of Facings Value	Optional	real	week/sku/str
drtypentrp.csv.ovr	DRTYPentrp	TY Penetration (% Buying at Retailer)	Default Role This Year Penetration (% Buying at Retailer) Percent	Optional	real	tdar/retd
drtyprchfreqv.csv.ovr	DRTYPrchFreqV	TY Purchase Frequency	Default Role This Year Purchase Frequency Value	Optional	real	qrtr/clss/tdar/csd
drtypromoslsr.csv.ovr	DRTYPromoSlsR	TY Promo Sales R	Default Role This Year Promo Sales Retail	Required	real	week/sku/str
drtypromoslsu.csv.ovr	DRTYPromoSlsU	TY Promo Sales U	Default Role This Year Promo Sales Units	Required	real	week/sku/str
drtypvtlblslsc.csv.ovr	DRTYPvtLblSlsC	TY Private Label Sales AUC	Default Role This Year Private Label Sales Item Cost	Optional or required if you want to plan and analyze Private label sales.	real	week/sku/str
drtypvtlblslsr.csv.ovr	DRTYPvtLblSlsR	TY Private Label Sales R	Default Role This Year Private Label Sales Retail	Optional or required if you want to plan and analyze Private label sales.	real	week/sku/str
drtypvtlblslsu.csv.ovr	DRTYPvtLblSlsU	TY Private Label Sales U	Default Role This Year Private Label Sales Units	Optional or required if you want to plan and analyze Private label sales.	real	week/sku/str
drtyrsestrclst1lbl.csv.ovr	DRTYRseStrClst1Lbl	TY Store Cluster Attribute 1 Label	Default Role This Year Store Cluster Attribute 1 Label	Optional	string	clss/str
drtyrsestrclst1tx.csv.ovr	DRTYRseStrClst1Tx	TY Store Cluster Attribute 1	Default Role This Year Store Cluster Attribute 1 Text	Optional	string	clss/str
drtyrsestrclst2lbl.csv.ovr	DRTYRseStrClst2Lbl	TY Store Cluster Attribute 2 Label	Default Role This Year Store Cluster Attribute 2 Label	Optional	string	clss/str
drtyrsestrclst2tx.csv.ovr	DRTYRseStrClst2Tx	TY Store Cluster Attribute 2	Default Role This Year Store Cluster Attribute 2 Text	Optional	string	clss/str
drtyrsestrclst3lbl.csv.ovr	DRTYRseStrClst3Lbl	TY Store Cluster Attribute 3 Label	Default Role This Year Store Cluster Attribute 3 Label	Optional	string	clss/str
drtyrsestrclst3tx.csv.ovr	DRTYRseStrClst3Tx	TY Store Cluster Attribute 3	Default Role This Year Store Cluster Attribute 3 Text	Optional	string	clss/str
drtyrtltaspndp.csv.ovr	DRTYRtlTASpndp	TY Retailer Trading Area Spend %	Default Role This Year Retailer Trading Area Spend Percent	Optional	real	tdar/cprd
drtyshelfcapv.csv.ovr	DRTYShelfCapV	TY Total Shelf Capacity	Default Role This Year Total Shelf Capacity Value	Optional	real	week/sku/str
drtyshopfreqv.csv.ovr	DRTYShopFreqV	TY Shopping Frequency	Default Role This Year Shopping Frequency	Optional	real	tdar/csd
drtysiminv.csv.ovr	DRTYSimInV	TY Similarity In	Default Role This Year ORASE Data Value	Required	real	sku/tdar/csd/skur
drtyslsc.csv.ovr	DRTYSlsC	TY Sales AUC	Default Role This Year Sales Item Cost	Required	real	week/sku/str
drtyslsr.csv.ovr	DRTYSlsR	TY Sales R	Default Role This Year Sales Retail	Required	real	week/sku/str
drtyslsu.csv.ovr	DRTYSlsU	TY Sales U	Default Role This Year Sales Units	Required	real	week/sku/str
drtyspendx.csv.ovr	DRTYSpendX	TY Spend Index	Default Role This Year Spend Index (Buyer Spend Compared to Average Spend) Index	Optional	real	tdar/retd
drtysqftv.csv.ovr	DRTYSqFtV	TY Total Square Footage	Default Role This Year Total Square Footage Value	Optional	real	week/sku/str
drtystrclus.csv.ovr	DRTYStrClusLbl	Store Cluster Label	Default Role This Year Dynamic Store Cluster Label. The Label is appended to the Store Cluster Name in the Store Cluster Name load file.	Optional	string	qrtr/clss/str
	DRTYStrClusTx	Store Cluster Name	Default Role This Year Dynamic Store Cluster Text		string	qrtr/clss/str
drtyswitchingx.csv.ovr	DRTYSwitchingX	TY Switching Index	Default Role This Year Index	Optional	real	sku/str/csd
drtytopshopx.csv.ovr	DRTYTopShopX	TY Top Shopper Index	Default Role This Year Top Shopper Index	Optional	real	scls/str/retd
drtytrnsszwcatv.csv.ovr	DRTYTrnsSzwCatV	TY Transaction Size with Category	Default Role This Year Transaction Size with Category Value	Optional	real	qrtr/clss/tdar/csd
drtyttlshopperx.csv.ovr	DRTYTtlShopperX	TY Total Shoppers Index	Default Role This Year Total Shoppers Index	Optional	real	tdar/csd
locplan_sales.csv.ovr	DRTYLPSlsU	Loc Plan Sales U		Optional	real	week/scls/str
	DRTYLPSlsR	Loc Plan Sales R		Optional	real	week/scls/str
	DRTYLPSlsC	Loc Plan Sales C		Optional	real	week/ scls/str
mfp_sales.csv.ovr	DRMfSlsU	MFP Sales U		Required	real	week/scls/chnl
	DRMfSlsR	MFP Sales R		Required	real	week/scls/chnl
	DRMfSlsC	MFP Sales C		Required	real	week/scls/chnl