Using system fields to display data last updated date

sdutoit
Level 2

Using system fields to display data last updated date

Our Marketo instance is linked to our internal data lake and a complete sync runs on a Saturday. Every other day a delta update is made (ie. any data fields that have been changed are updated.)

My challenge is that member preferences are held outside of Marketo and are also part of this process. When data failures occur we run the risk of emailing unsubscribed members, resulting in a breach.

What I am looking to do is to send a date "data last refreshed date" to Marketo and use this to pause campaigns via logic if the data is four days old (or more). We don't however want to send this as a lead field daily and update 2m records due to processing time. 

 

Does such a system field exist and if so, is anyone aware of it being used for this purpose?

1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: Using system fields to display data last updated date


Does such a system field exist and if so, is anyone aware of it being used for this purpose?

Are you asking about a field that stores the last time a record update was attempted, even if there were no material changes in that update?

 

If so, then no. Marketo only logs a true update, not merely access.