Now we'd like to make a weekly option for those who don't want a daily email. Since the number of posts published in a week would be overwhelming for a single email, we'd like to send out only the most popular posts that week (that would be by views or by shares). However, we haven't found a way to do this via RSS, because we haven't found a plugin which could generate an RSS feed of the most popular posts from the prior week. Of course it could be put together each week manually, but an automated method is our goal.
Does anyone know any approaches through which we could make this work with Wordpress + Mailchimp?