Active lead report

[Harish_Gupta6]

Hi, Is there any way in Marketo to get the lead reports for those leads who are active from last 1 year. (Active means who have clicked any link in any marketo email, opened any email sent by marketo, form submitted)?

[Josh_Hill13]

sure, just use those filters in a smart list and it will give you a list of leads.

[Harish_Gupta6]

Hi Josh, using smart list, i have to select all emails, forms in smart list filter.

Also I want Country column in report. In smart list, i am getting all this, but when i trying this in reporting (Analytic section), I am not getting the country name in report.

[Elliott_Lowe1]

If you are creating a Lead Performance report, you can change the Group Leads by Country field to get a count of the leads by Country, but you can't have both their name or email address and the country on that report.  Hopefully in this month's new release, you will be able to create subscriptions for smart lists similar to reports, which may be what you need.