AnsweredAssumed Answered

Ensuring Database Integrity

Question asked by Michael O'Donnell on Jul 3, 2019
Latest reply on Jul 3, 2019 by James T Fletcher

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.

 

e.g.

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 need a way to identify that the coordinator has changed so I can prevent John@centrex.com getting it if the actual 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?

 

Thanks

 

Michael

Outcomes