Hi all,
Has anyone found a way to pull the last modified date (of a constituent record) into Analytics?
I'm trying to do a report on the number of deceased constituents by year (not the happiest of reports to be requested to do!). I can pull those consts with the Name Status marked as deceased, but can't work out how to find the date that the status was changed. I thought that finding the last modified date of the constituent record might work (with the theory that we inactivate people once they have been given the deceased status), but I'm not finding anything for that either.
Has anyone stumbled across a last modified date in Analytics by any chance?
Thanks,Alison
I could imagine doing this in lists, and a few outputs set elements. It might require a new element or two for this to work. If it does not already exist.
The challenge with Analytics, particularly for those who are hosted on RAMP is that these customizations may come with un-planned for out of pocket expenses. And depending on how often you need to do this. You may not want to make this kind of investment.
The interesting potential issue with the last updated date on T_Customer is that I think at least at one point in time some upgrades modify accounts and change these dates. (I could be mistaken.) It would be something I'd look out for. The other place to check on this might be in the updated logs. I don't know if inactivations are captured in those logs on the table T_Customer. Also, I'm not clear if your organization is not actively purging such logs. I have a sense that some organizations may do so.
Good, luck! Let us know how you get on with this.
Thanks for your quick reply Tom!
I was hoping to just have a pretty Analytic dashboard that could sit there forever, happily updating itself; but I think you're right and I will need to go down the lists and output sets path.
Also, thanks for mentioning the fact that the last updated date might change afterwards- I will look into that!