Example FACT_MKT_Tables Description Value Dollars raised from the sale of a product in the defined period among products under store promotion in the rest of $1,100 DOLLARS_ANY_PROMO_RM the market (all other companies) All Commodity Volume percentage in the rest of the 84 PCT_ACV_TOTAL_RM market (all other companies) Hypothetical Total Dollars expected to be raised in the absence of all store promotions in the rest of the market (all $865.43 BASE_DOLLARS_TOTAL_RM other companies) Total number of units sold of a given product in the defined 900 UNITS_RM time period in the rest of the market (all other companies) Total number of units sold of a given product in the defined time period among products under store promotion in the 840 UNITS_ANY_PROMO_RM rest of the market (all other companies) Hypothetical units expected to be sold in the absence of all store promotions in the rest of the market (all other 600 BASE_UNITS_TOTAL_RM companies) Total Dollars raised from sale of a product in the defined time period in the previous year in the rest of the market $456.32 DOLLARS_RM_PY (all other companies) Total Dollars raised from sale of a product in the defined time period in the previous year among products under $345.21 DOLLARS_ANY_PROMO_RM_PY store promotion in the rest of the market (all other companies) All Commodity Volume percentage in the previous year in 73 PCT_ACV_TOTAL_RM_PY the rest of the market (all other companies) Hypothetical Total Dollars expected to be raised in the absence of all store promotions in the previous year in the $698.32 BASE_DOLLARS_TOTAL_RM_PY rest of the market (all other companies) Total number of units sold of a given product in the defined time period in the previous year in the rest of the market 485 UNITS_RM_PY (all other companies) Total Dollars raised from the sale of a product in the defined period among products under store promotion in 432 UNITS_ANY_PROMO_RM_PY the previous year in the rest of the market (all other companies) Hypothetical units expected to be sold in the absence of all store promotions in the previous year in the rest of the 344 BASE_UNITS_TOTAL_RM_PY market (all other companies) Description Example MARKET Table Sales market identifier 5 MKTKEY
FACT_MKT_Tables Description Example Value DOLLARS_ANY_PROMO_RM Dollars raised from the sale of a product in the defined period among products under store promotion in the rest of the market (all other companies) $1,100 PCT_ACV_TOTAL_RM All Commodity Volume percentage in the rest of the market (all other companies) 84 BASE_DOLLARS_TOTAL_RM Hypothetical Total Dollars expected to be raised in the absence of all store promotions in the rest of the market (all other companies) $865.43 UNITS_RM Total number of units sold of a given product in the defined time period in the rest of the market (all other companies) 900 UNITS_ANY_PROMO_RM Total number of units sold of a given product in the defined time period among products under store promotion in the rest of the market (all other companies) 840 BASE_UNITS_TOTAL_RM Hypothetical units expected to be sold in the absence of all store promotions in the rest of the market (all other companies) 600 DOLLARS_RM_PY Total Dollars raised from sale of a product in the defined time period in the previous year in the rest of the market (all other companies) $456.32 DOLLARS_ANY_PROMO_RM_PY Total Dollars raised from sale of a product in the defined time period in the previous year among products under store promotion in the rest of the market (all other companies) $345.21 PCT_ACV_TOTAL_RM_PY All Commodity Volume percentage in the previous year in the rest of the market (all other companies) 73 BASE_DOLLARS_TOTAL_RM_PY Hypothetical Total Dollars expected to be raised in the absence of all store promotions in the previous year in the rest of the market (all other companies) $698.32 UNITS_RM_PY Total number of units sold of a given product in the defined time period in the previous year in the rest of the market (all other companies) 485 UNITS_ANY_PROMO_RM_PY Total Dollars raised from the sale of a product in the defined period among products under store promotion in the previous year in the rest of the market (all other companies) 432 BASE_UNITS_TOTAL_RM_PY Hypothetical units expected to be sold in the absence of all store promotions in the previous year in the rest of the market (all other companies) 344 MARKET Table Description Example MKTKEY Sales market identifier 5
nielsen1-dataset-data-dictionary.docx