Would it be possible to achieve something like this with the reports Marketo generates?
|Lead status 1|
|Month||Smart List 1|| Smart List 2||Smart List 3||Smart List 4||Smart List 5||Smart List 1|| Smart List 2||Smart List 3||Smart List 4||Smart List 5|
I want to have the Lead Status on the top row. Then on the 2nd Row, show the applicable smart lists. On the left most column, have the month.
I want to breakdown the number of leads that have the lead status and fall under the conditions the smart lists define. Unfortunately the smart lists themselves do not have time sensitive conditions that can be used to filter/refine them.
Also is it possible to create a condition where they were a member of the smart list during the time period of Jan 1 - Jan 31?
Is there a way to achieve the above without exporting the contents and manually analyzing the data on Excel each month?