This is a one-time list I will have to pull, so I'm looking for a solution to avoid doing a step manually 150+ times.
So basically I have 150 Events named DATE-EVENTNAME each one containing one email named DATE-EVENTNAME.NoShow.
Each Event contains a Smartlist pulling the leads that clicked a link of the NoShow email of that event (see attachment). The final output I need is an excel file containing the leads that clicked on one of those links, and what email/event the link belonged to and this compiled for all the 150 events
Is there any way to automate this retrospectively? With reports maybe?