I am reviewing a request to track changes performed on the address field and some other custom fields on the contact object for long periods of time.
I have evaluated Field Tracking History and Field Audit Trail, but I believe both of these solution will not meet the requirements.
I am looking for some clarification / verification on whether or not Field Tracking History or Field Audit Trail meets my requirements. I'm essentially trying to find the simplest way to capture this data for usage within the Analytics Studio to easily track changes over time.
Field Tracking History
My understanding of the following documentation indicates Field Tracking History is only kept for 18 months.
Field Audit Trail
It's not very clear to me whether or not compound fields such as address are considered formula fields or roll-up fields... if they are, this would disqualify my ability view address change data. HOWEVER, I am able to track address changes in Field History Tracking so I would think I would be good.
In addition, ideally tracking data over a longer period of time than 10 years would be ideal.
I'm leaning towards just creating a trigger upon Contact address and other field changes that creates a new custom object that tracks the changes, but that seems a little excessive.
After reading more into field tracking, could the Event Log object be utilized? I'm pulling up the object in Analytics studio, but I'm not seeing any way to configure to show event types that pertain to updating an object field, and just as importantly, then filtering event logs to display object field updates to counting entries of when a field was updated.
To answer my question in the above EDIT, please see: Event Log Object - Tracking Field Changes