Ok, I have a scenario I require help to resolve. Our CRM isn't synced.
We have a weekly email which we send to all business contacts - coordinators.
On a weekly basis we will have to pull data from CRM and import to Marketo.
This is all fine, where we run into trouble is ensuring that if a co-ordinator changes, we need some way of identifying this and removing from database so they don't receve the next weeks communication.
Week 1 we import 1000 different coordinator contacts, business X coordinator is John@centrex.com
Week 2 we import our contacts again however business X coordinator is now Andy@centrex.com
I would then take all those who have changed on a weekly basis and create a smart list rule to remove them from database or unsubscribe them.
Is there a pain free way of identifying all those contacts who change from one week to next?