4 Replies Latest reply on Feb 1, 2017 12:53 AM by Grégoire Michel

    Reports by Lead Status and Smart Lists

    Henry Wong

      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?