As a Gainsight Admin with a “fervor” for reporting and metrics, it would be nice to be able to edit a series of reports en mass as a maintenance and possibly deployment tool. . Primarily, I would like the ability to remove/add “Show me” fields and filters.
Use Case: I have X number of reports that feature a field from Data Source Y. When that field is retired and/or replaced, I would like the ability to “swap” fields without having to touch every report is resides in.
Anyone else have a case for this or support this capability? Has this been requested previously? (I can’t find anything on community)
Hi Kieth,
Thanks for posting. Its definitely a strong productivity usecase for admins where you don't have to hunt down each and every report to change a field. A couple of questions:-
I would be interested in the following:
Use Case (field swap): Yearly segmentation updates from Salesforce have resulted in new “Territory” and “Segment” designation fields. If there was a utility to “swap” fields across the platform and could be scheduled that would be ideal
Use Case (field remove): An existing integration will no longer be in existence and resulting data will be stale or erroneous. Once the field is retired from the source system, the ability to “remove field everywhere” would be ideal.
I understand “everywhere” is a bit obtuse and my primary concern is anything presented to the users, as you mentioned, reporting would be a great start? Bonus points to be able to clear out rules and merges automatically!
Please let me now if I can provide any more details or info.
Interesting use case Keith.
Some potential complications that would have to be solved for with bulk remove/replace actions:
There might be more, but those are just a few that come to mind as currently manual steps that need to be done today when fields are added or removed from reports.
It’s likely that an admin would want to manually verify each report regardless to prevent users or execs from getting broken reports in their dashboards if the automation did not make the correct assumptions on filtering and aggregations.
I would be willing to invest the time and patience to achieve the desired outcome. Perhaps starting with a dependencies report on a field and then using that as a baseline for a workflow of what needs to be reviewed and updated.
My current approach is to filter my report builder as best possible and open up one tab per report, update, save and close. Just trying to see how we can best improve the quality of life for Admins :)
If there is anything I can do to keep this convo going or additional feedback please let me know. Thank you for responding so quickly Dan.
My initial reaction was similar to@dan_ahrens - that has potential to complicate (break) existing reporting (at least for us where we rarely have reports that are so similarly structured) and, if you have to go manually validate/tweak each one anyway, I don’t really see it as a valuable/time saving feature.
I DO agree it’s a pain to identify where and how all the fields are being used in Reports (and elsewhere in Gainsight) which is why I keep pressing for enhancements to Object Analyzer.
Hi!
I originally started writing a post directly in the Community after looking for an associated one without luck, but afterward I moved to a notepad to proof the text and I did some changes in the title and I was prompted with this post… I submitted a very similar idea, but focused in a bulk swap in the case the “old field” exists only in the breakdowns. Leaving the link here for consideration.
Thanks!