Lead Status progression through months
I want to look at the lead status of program members within past months. So on x month (or even x day), 100 leads involved in a program were a Named Target, and 5 were opportunities. On Y month (or Y day), 90 leads involved in a program were a Named Target , and 15 were Opportunities. I can view field histories in SFDC but I can't attribute it to certain campaigns (and we all know how much SFDC loves to limit it's field look up in the search function).
Has anybody done something similar?