I've found a way! It aint easy and you better make sure you have a hardcore BI analyst. We to use an API to pull out all the lead activities, from here it can look at members on a specific smart list or list, after that we were able to build out automated reports..... My advice..........Don't wait for marketo......they have decided to simply ignore the needs of their customers.
Just wanted to share a workaround I saw posted in the community (sorry I don't have the link for the original poster!) I would really like to subscribe to a weekly report of who filled out a demo request form (with the columns I want, and leads details) but there is no good solution through any of the standard Leads reports. However, since this form is hosted on a page, I can create a Web Page Activity Report with a Filled out Form filter in the Smart List, and subscribe to that. It doesn't give you all the details, but it does give you numbers of leads for certain programs/forms/actions etc. with basic information like name, title, and company.
We're running a high volume of Roadshows and our teams are really asking heavily for this function. Exporting a number of lists on a near on daily basis is not the best use of time. Any updates?
I'm excited. This is a great idea! Can someone at Marketo give me the actual date on when this feature will be available to use within my instance? Thank you and looking forward to it!