I am working with a flattened survey for the first time and am hitting some snags. I usually merge survey data with Account and other SFDC data using a Data Space. I cannot do that with a flattened survey due to it being in MDA.
So then I tried to add fields to the flattened survey MDA table. Unfortunately, that table is locked.
The only other thought I have would be to make a new MDA table, map all the current flattened survey fields over to that object, make the new field I want, then map those over from SFDC. Doable, but doesn't sound enjoyable.
Is there an easier way?
Thanks!
Solved
Can you add data to a flattened survey dataset?
Best answer by ben
This is the best way I have found to accomplish this task: https://community.gainsight.com/gainsight/topics/how-to-hack-bionic-reports
-Ben
+11Right there with you, Ben. While the flattened table works well in and of itself, it's proves to be difficult to link out to other data sources, especially because the survey information lives in MDA, where as much of the metadata you would want to link to (especially Accounts and Contacts) is over in SFDC.
Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?
Yup, its a pretty sticky problem. My only idea as a workaround is to export the raw survey data from the survey itself, export account or contact data from SFDC, then merge them in Excel.
+11I ended up effectively doing that via the Rules Engine. With a Bionic Rule, you can query the results from the flattened survey table, the Advanced Outreach / Journey that sent the survey and the SFDC Contacts. Through some pivoting and merging, they can be re-united. However, that solution gives me an export (which in my case is all I needed); it doesn't truly re-unite the survey with the contact in the MDA or in SFDC on an evergreen basis.
Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?
This is the best way I have found to accomplish this task: https://community.gainsight.com/gainsight/topics/how-to-hack-bionic-reports
+1@Ben, you're reading my mind. This use case is exactly the reason I want Bionic Reports. I can't add the right Relationship CSM to my flattened survey report, and need to lookup against the Associated object ID to pull the right CSM in. The only way I've come up with to do it is to right a Bionic rule that basically copies the flattened survey table, and adds a couple of fields to it, just as you've said.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.