I've been using an AMPscript to bring RSS Content into an email for some time now. That work's without issua and I'm ready to try the next step to actually automate a subscription service...

It looks like MailChimp has a feature that does just what I'm looking for, but can't figure out how to do it in MarketingCloud.

Basically the following workflow would be: 1. Maintain a subscription list 2. Check Daily for the most recent post 3. If most recent post is > the date of last send, then 4. Trigger send to subscription list

Sure, I could trigger an email after we publish a blog post, but I'd like to not have to think about it. I'm not authoring the blogs themselves, so it'd take some coordination that wold be better served by automating.


There are a fair few moving parts and a number of variations, so I'm just giving the high-level elements you'll need and you can choose how much you do with AMPScript and how much with SQL.

  1. Create a Data Extension (LastArticles)
  2. Create a Data Extension with same structure (CurrentArticles)
  3. Create a Data Extension, again, with same structure (NewArticles)
  4. Create an email that goes and gets articles from the RSS via AMPScript and places all current articles into a Data Extension (CurrentArticles). The target for this email will be an internal inbox or blackhole email address.
  5. Create a Query Activity with code similar to this to populate NewArticles with overwrite:

    SELECT * FROM CurrentArticles ca LEFT JOIN LastArticles la ON ca.pubId = la.pubId AND la.pubId IS NULL

  6. Create an email that places rows from NewArticles into the body as it sends using AMPScript.

  7. Create a Query Activity with code similar to this to populate LastArticles with overwrite:

    SELECT * FROM CurrentArticles

  8. Create an Automation that runs 4, 5, then a Verification Activity on NewArticles, 6 and 7.

  9. Schedule the Automation to run as frequently as needed.
  • May I suggest to exchange number 4 with a Script Activity in Automation Studio? Thats a cleaner way to do that. – DonL Oct 18 '19 at 14:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.