Is there any way to get the Campaign Inspector (an excellent treasure chest addition, btw!) to also show Last Activity -- and not just Last Updated? This would be super helpful for better managing an instance with a long history.
Josh, thanks for the Members by Week idea. For the particular client that got me thinking about this, they have 221 active campaigns, some more than 5 years old. So an at-a-glance look at which of those have been associated with recent activity would be super helpful.
Well, in the realm of attempting to answer my own question out of necessity, I discovered that (with some manual intervention), one can get pretty close to the desired functionality by aligning two spreadsheets worth of exported info from Marketo:
1. A Campaign Activity report (which has a Last Activity field) run for all campaigns; then eliminating all but active trigged, active triggered archived, and campaign is requested
2. A Campaign Inspector report run for all active campaigns
With 221 campaigns, it was only 4 lines away from matching up perfectly.
Was useful for me. Hopefully it'll be useful to someone else...