Skip to main content
catherine_lilly
catherine_lilly
Contributor ⭐️⭐️
August 19, 2019
Solved

report on customer status changes

  • August 19, 2019
  • 2 replies
  • 71 views
I am looking to track status changes of a customer from Implementation to Ongoing Delivery. The data needs to be tracked in a reportable way. I beleive this can be done in the MDA, and would appreciate some guidance on how to write only changes (rather than a daily snapshot) to the MDA with timestamps, and keep the full history of status changes.

Any documentation or suggestions?

Best answer by dan_ahrens
Hi Catherine,

You could do this by creating a custom MDA Table, then copy all the current values to that table, then create a rule that runs daily to compare the current value to the value stored in the MDA table and if the values are different, then write a new record with the new value and the current date. Over time you will end up with a historical record of the values as they changed, and the date on which they changed.

2 replies

dan_ahrens
dan_ahrensAnswer
Expert ⭐️⭐️⭐️
August 27, 2019
Hi Catherine,

You could do this by creating a custom MDA Table, then copy all the current values to that table, then create a rule that runs daily to compare the current value to the value stored in the MDA table and if the values are different, then write a new record with the new value and the current date. Over time you will end up with a historical record of the values as they changed, and the date on which they changed.

VP of Customer Success at Forcepoint
spencer_engel
spencer_engel
Expert ⭐️
August 27, 2019
Also, Catherine, if you need a guide to get started on Dan's solution, this tutorial might help: https://community.gainsight.com/conversations/how-to-historically-snapshot-data-to-the-mda-5d28eadae4b00474137fe904

    Terms & ConditionsAccessibility statement