retrospective demand mining