AnsweredAssumed Answered

Partially purge data from a text field

Question asked by Dan Stevens. Expert on Jun 15, 2018
Latest reply on Jun 15, 2018 by Sanford Whiteman

We have a history field used to store web page activity, which is then displayed in our real-time alerts:

 

It’s a text field (not string) and looks like this in the Marketo:

 

 

Even though this is a text field, over time, this may reach its limit by active, known users on our website.  Any thoughts on how to go about partially purging old data – let’s say ‘older than 6 months’ – while leaving the rest of the data intact?

Outcomes