I'm needing to send a couple emails using automation studio (we aren't paying for journey builder) to Contacts that are entered into Sales Cloud that match certain criteria. Here are the steps I've taken:
- Setup and configured Marketing Cloud Connect.
- Setup a DE with ContactID, FirstName, LastName, Email.
- Setup an automation in automation studio to query contacts that meet my criteria and dump them into my DE.
- Setup an email to send to the contacts.
Seems like I'm so close, but basically I want this automation to run every 30 minutes, put the contacts that meet my criteria into the DE and then send a series of emails. Seems like potentially I need two automations, one to put the contacts into my DE and another to send the series of emails when they are put into the DE. The problem is that I can't figure out how to initiate the automation based on when the contact is inserted into the DE.
Further, it seems not efficient to be constantly querying the synchronized data source from SF for criteria that match. I really only care about inserted/updated contacts that meet my criteria. Maybe I'm going about this wrong? Should I use a triggered email send from SF or is there another way to tackle this that I'm missing?