Skip to main content
catherine_lilly
catherine_lilly
Contributor ⭐️⭐️
Aug 19, 2019 3:45 PM UTC
Solved

report on customer status changes

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?

dan_ahrens
dan_ahrensAnswer
Expert ⭐️⭐️⭐️
Aug 27, 2019 2:49 AM UTC
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
View in thread

2 replies

dan_ahrens
dan_ahrensAnswer
Expert ⭐️⭐️⭐️
Aug 27, 2019 2:49 AM UTC
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.

Translate
VP of Customer Success at Forcepoint
spencer_engel
spencer_engel
Expert ⭐️
Aug 27, 2019 12:54 PM UTC
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

Translate
    Terms & ConditionsAccessibility statement