Skip to main content
ben
ben
Helper ⭐️⭐️⭐️
August 7, 2018
Solved

Can you add data to a flattened survey dataset?

  • August 7, 2018
  • 5 replies
  • 159 views
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!
    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

    5 replies

    matthew_lind
    matthew_lind
    VIP ⭐️⭐️⭐️⭐️⭐️
    August 8, 2018
    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.
    Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?
      ben
      benAuthor
      Helper ⭐️⭐️⭐️
      August 8, 2018
      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.
      -Ben
      matthew_lind
      matthew_lind
      VIP ⭐️⭐️⭐️⭐️⭐️
      August 8, 2018
      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.
      Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?
        ben
        benAuthorAnswer
        Helper ⭐️⭐️⭐️
        August 14, 2018
        This is the best way I have found to accomplish this task: https://community.gainsight.com/gainsight/topics/how-to-hack-bionic-reports
        -Ben
        leanne
        leanne
        Contributor ⭐️⭐️⭐️⭐️⭐️
        August 14, 2018
        @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.
        Terms & ConditionsAccessibility statement