Does anyone know if there is a way to link a constituent’s former address to a particular date? I’m trying to find historical detail on promotions and addresses.
I created a list with a region and a promotion date range, and then ran this through an output set. The detail I get is all based on current address though.
I’m sure this isn’t a common question, but is it possible?
Thanks,
Mark
As you may know, inside the details for each postal address are "Start Date" and "End Date." As I understand it, when you run "Execute an Output Set," if you supply a value for the "Mailing Date" parameter it's supposed to return the address that is/was active on that date, or the primary address if there's no matching address.
However, if your organization is like mine (and everybody else I've talked to about this,) you probably haven't been filling in Start Date and End Date consistently, (if ever!)
Maybe there's an opportunity here for your SQL guru to dig into the audit data as Tom suggests. Perhaps one could script it so that all of your currently inactivated addresses had their start and end dates filled in from the audit data. And then maybe you could then use insert and update triggers to automatically fill in start and end dates as addresses are created and inactivated moving forward?
I haven't tried anything like this myself, but I also would love to hear if you end up with a good solution here.