Analysis on change of statuses on regular donations and not

Options
Hi there,


I would like to keep a record of everytime I change the status of my costituents so I can analise how many contacts, in every specific time range, change the status.

How do you face this situation?


Thank you.


 
Tagged:

Comments

  • You can start to keep a change log using Query....  Most fields allow an Output of "Date Last Changed" so you can build a log based on that.


    But the real question is, how are you saving these "status" details?  Are you talking about Constituency Codes, Attributes, etc.?  
  • Joy park:

    You can start to keep a change log using Query....  Most fields allow an Output of "Date Last Changed" so you can build a log based on that.


    But the real question is, how are you saving these "status" details?  Are you talking about Constituency Codes, Attributes, etc.?  

    I was thinking to build a query in SQL so I link constituent import ID & Status & Date last changed & most recent active Costituent code 1 & most recent active Costituent code 2 & most recent Cost code 3


    Does it make any sense? 


    About attributes, well.. it depends on the analysis you want to carry out..

Categories