AnsweredAssumed Answered

Reports by Lead Status and Smart Lists

Question asked by 1dcd8bb73ffdc5eaae07d8360eff9d02e60356fc on Jan 31, 2017
Latest reply on Feb 1, 2017 by e6615dd679b5dd0c3e60c20085706f392a9af2cb

Would it be possible to achieve something like this with the reports Marketo generates?

Lead status 1
Lead status 1
Lead status 1
Lead status 1
Lead status 1
Lead status 2
Lead status 2
Lead status 2
Lead status 2
Lead status 2
Month
Smart List 1 Smart List 2Smart List 3Smart List 4Smart List 5Smart List 1 Smart List 2Smart List 3Smart List 4Smart List 5
Jan
Feb
Mar

 

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?

Outcomes