I am looking to automate an incentive program that triggers specific emails upon hitting order milestones on a sales tool. I have data in PowerBI from two different SQL databases - sales data from the tool and CRM data on users - that are connected by email address. I'd like to import this data into Marketo as a smart list with various custom fields and build triggers for emails (i.e. a gift card email for a users tenth order placed). What is the best way to import these tables into Marketo? Does anyone have experience with this? I have read about API connections and webhooks but not sure the best course of action. I am curious if there is a direct way to pull data into Marketo from PowerBI. Any and all information will be helpful!
Thank you in advance!