Systems and methods for providing category aspect information by mining historical data is provided. A table comprising joined data is accessed. The table includes historical data that comprises user behavior data based on actions performed with past queries by users listing data that includes aspect data for each listing and a determined category for each listing. Demand scores based on the joined data are determined. The determined demand scores are used to determine at least one relevant aspect name for a category. A message is transmitted for display on a device of the user that indicates the at least one most relevant aspect name for the category and suggests the user provide an aspect value that corresponds to the at least one most relevant aspect name to be included in a new listing.