If you click the Download Report button, it will be a static link containing the smart list data at the time the subscription was sent. If you want real-time data, click the smart list URL in the report email and then export the list.
Thanks for the reply Nick!
I have a non-marketo user who is receiving the subscription. So they're unable to log in and see the real-time data. This is good info for me to know.