Skip to main content
Contributor ⭐️⭐️⭐️
August 20, 2020
New Idea

Export function from Data Designer

  • August 20, 2020
  • 18 replies
  • 329 views

I’d like the ability to export the data returned in queries created in Data Designer. Currently you must create a dataspace from the design, create a report in report builder to then export.

 

Use case: I’m typically validating data when first creating a new data space and would like to export and review the data in excel.

18 replies

rakesh
Gainsight Employee ⭐️
Lets put your data to work!
October 26, 2021

Any update on this? Went down the path of making a DD for a one-time report, not realizing I couldn’t export it. It would have saved time to just create this in the rules engine to export. 

@kelly We do have S3 export in DD as well and you can export data from DD directly. 
Exporting reports data in DD is a bit further in our roadmap.

sarahmiracle
VIP ⭐️⭐️⭐️⭐️⭐️
November 2, 2021

Just adding my voice here! I ran into the same issue just the other day -- DD is a great tool for reporting on data across objects in a user friendly way, but I was disappointed when I made my report in the Explore section and couldn’t export that data unless I made the dataset universally available. I had an ad-hoc report request come through from Marketing operations, and I’d love to get people the data they need without creating a separate object in the MDA for it each time. (Or, using rules S3 export...)

Customer Success Systems Admin @ Amplitude, 3x Gainsight CS Ops Product Council Member
rakesh
Gainsight Employee ⭐️
Lets put your data to work!
November 26, 2021

 

Just adding my voice here! I ran into the same issue just the other day -- DD is a great tool for reporting on data across objects in a user friendly way, but I was disappointed when I made my report in the Explore section and couldn’t export that data unless I made the dataset universally available. I had an ad-hoc report request come through from Marketing operations, and I’d love to get people the data they need without creating a separate object in the MDA for it each time. (Or, using rules S3 export...)

Hi @sarahmiracle  

You can export the data which is prepared in DD today. Its from Execution History, not from inside Explore Screen. 

 

I believe this will perfectly solve the usecase you mentioned

sarahmiracle
VIP ⭐️⭐️⭐️⭐️⭐️
February 9, 2022

@rakesh thank you! I didn’t know that was possible, and that will be helpful for situations where I need the full dataset.

However, that gives me the full data set, and what I’m looking for is the ability to export the report that I create in Explore off of the full data set after it is executed (with my own filters, SHOW ME fields, etc)

Customer Success Systems Admin @ Amplitude, 3x Gainsight CS Ops Product Council Member
Stuart
Helper ⭐️⭐️
September 1, 2022

+1 to this; would be great to have this as an option.  I often use DD as a precursor to building a rule. I export to excel for data validation purposes.  Creating native excel export within DD will remove the extra step of creating a system object and building a report from this.  Looking forward to seeing this in an upcoming release!

heather_hansen
VIP ⭐️⭐️⭐️⭐️⭐️
September 1, 2022

Agree with all the posts here.  Often times I’m building a DD for one specific use case, but could see it having additional uses down the road, so I default to having the dataset show more, and then, use the reporting to filter down to what I want for that particular use case. With some of the way DDs function, it makes things quite cumbersome → making changes to the DD, refreshing the DD, going to report builder, updating the report, going back to DD, making another change, refreshing the DD, going back to report builder, etc.

spencer_engel
Expert ⭐️
September 23, 2022

I just ran into this issue again. I just have one simple report I need to export with about 20 records in it. It’s only achievable via Data Designer, but it does not need to live in the MDA. I’d like to simply be able to export it from DD and be done with it rather than create unnecessary overhead in both the MDA and report builder.

sarahmiracle
VIP ⭐️⭐️⭐️⭐️⭐️
July 26, 2023
Customer Success Systems Admin @ Amplitude, 3x Gainsight CS Ops Product Council Member