Linking User IDs in SFDC Contact for Product Usage Data
In our SFDC Contact object, we have a field that represents the user ID of the contact in our own app.
In our usage data Gainsight object populated from our app, we also have this user ID on each record to show who created each "deal".
What is the best way of linking these so I can see all "deals"/records created in our app by Contact X (by name or email)? Do I need to store all this contact data in a Gainsight object as well or can I lookup from the Gainsight object field directly to the SFDC contact custom field?