Must-have app for admin sanity
July 02, 2020

Must-have app for admin sanity

Laura Straub | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Modules Used

  • MassEffect
  • MassImpact
  • ReassignOwnership
  • MassBackup
  • Single Table Deduplicator
  • Find / Report ID's

Overall Satisfaction with DemandTools

DemandTools is used primarily by our Salesforce admin team on a day-to-day basis to do data maintenance activities, i.e. ownership changes, territory changes, basic field updates. I have used it for monthly clean up activities such as removing bogus lead records or deleting email signature images that get added when emails are imported into Salesforce. We have used it extensively during data migrations to pull and compare data. Finance also uses the export data capabilities went pulling data for large reports or where it is just easier to get data from multiple related objects.
  • Report/Find IDs is the hidden gem of DemandTools. It is basically a super fast vlookup against your entire database. Easily add data to a report or find the records that match a list. I used this feature extensively when migrating data to a new org to do a compare numbers.
  • Data export by object is so easy and the ability to pull data from any related object is powerful. I find myself using data export more then running reports in SF because it's so much faster and hugely flexible.
  • Every module has clear steps and in-line help.
  • As much as I love the object export, I wish I could order the columns that get exported. I use it, at times, as a replace for running reports because it is so much faster but not getting to pick the column order is a bummer.
  • While you can filter fields you are looking for, it does not show related objects, so if you are looking to add the owner name you have to scroll down to owner and open it to fine the name field. If you have the Owner related object open, if you filter on "name" it will filter down correctly but if you then filter on something like "title" the Owner related fields will not reset to the full field list and will continue to only display fields with "name" in the fieldname. Annoying but not a deal breaker.
  • DemandTools biggest ROI is time savings. I can't even estimate the number of hours of tedious work this program has saved me.
DemandTools is a must have app if you have an org of 150+ users. It has saved me so many hours of doing work in Excel and then updating via data loads, by allowing me to manipulate the data directly in Salesforce. A task that would take 30 minutes now takes five. It really adds up. The Job Scheduler is a huge time saver as well if you have a bunch of scenarios that can run independently. At one point I had over 30 scenarios I needed to run daily and using Job Scheduler I would just auto run them every night.