I am having a little trouble wrapping my head around this and not sure it is possible in Marketo. We have two custom objects built. One of them is purchasing data. This contains a customers history of each product number they have purchased. We also have a custom object built that contains items that are/or have been discontinued with a date and product number.
Now I would like to create a smarlist that looks into the purchase history for product numbers and then looks in the discontinued custom object to see if it exists there. From there we can send customers emails to let them know they have a product that is being discontinued. Possible?