I have raised the below with support but they were unable to advise any fixes. Does anyone else have this problem and can anyone advise any work arounds?
Gainsight currently uses a field within Salesforce as a primary key to pull back data from the data extract into reports within Gainsight. For clients this key can change over time dependent on the product they have with us. When the field changes it only brings back the associated data since the change within Gainsight. If I change the field back to the previous key and leave Gainsight to update overnight, I can get the data associated to the previous key.
Is there a way to be able to either link the multiple Keys or amend the historic Key to the new one within the data ingested into Gainsight so the Reports in Gainsight show all historic data relating to a client as well as the data?
Any help would be gratefully received