Can you add data to a flattened survey dataset?

  • 3
  • Question
  • Updated 1 month ago
  • Answered
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!
Photo of Ben

Ben, Champion

  • 8,126 Points 5k badge 2x thumb
  • hopeful

Posted 2 months ago

  • 3
Photo of Matthew Lind

Matthew Lind, Champion

  • 3,758 Points 3k badge 2x thumb
Right 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.
Photo of Ben

Ben, Champion

  • 8,126 Points 5k badge 2x thumb
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.
Photo of Matthew Lind

Matthew Lind, Champion

  • 3,758 Points 3k badge 2x thumb
I 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.
Photo of Ben

Ben, Champion

  • 8,126 Points 5k badge 2x thumb
This is the best way I have found to accomplish this task: https://community.gainsight.com/gainsight/topics/how-to-hack-bionic-reports
Photo of Leanne

Leanne, Champion

  • 4,828 Points 4k badge 2x thumb
@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.