Invaluable tool for Administrators or those who value data cleanliness and integrity
December 01, 2020
Invaluable tool for Administrators or those who value data cleanliness and integrity
Score 8 out of 10
Vetted Review
Verified User
Modules Used
- DupeBlocker
- PeopleImport
- MassEffect
- MassImpact
- PowerGrid
Overall Satisfaction with DemandTools
We use DemandTools heavily in our department. It is a vital tool for removing duplicates, checking for incomplete records and just mass moving data. I use PowerGrid weekly, the flexibility to be able to drill down and pull in exactly the fields and filtered data I need is very powerful. In PowerGrid, I can easily visually scan the pared down data and change only those exact fields on individual records that I want, in a mass batch. I also recently started building out jobs in "Job Builder". I build out scenarios in Mass effect (For example: Opportunities missing an Amount) then I can "batch" those individual jobs into "scenarios" that I run on a daily basis to scrub and clean my data. It's a game changer for data integrity.
I had used "Data Loader" for many years to complete mass updates. It is a good tool, but Demand Tools does SO MUCH MORE. There was a small learning curve, but the library of short videos got me up and running within an hour. The online and scheduled classes are short, to the point, and very helpful in walking through each part of the application. I liked the short videos, because I tend to search for specific information when I need it. I don't want to watch an hour long video and try to retain all of that knowledge. I like the targeted modules - that allowed me to locate the specific piece of the application I was working with, and gave me the particulars for that.
I had used "Data Loader" for many years to complete mass updates. It is a good tool, but Demand Tools does SO MUCH MORE. There was a small learning curve, but the library of short videos got me up and running within an hour. The online and scheduled classes are short, to the point, and very helpful in walking through each part of the application. I liked the short videos, because I tend to search for specific information when I need it. I don't want to watch an hour long video and try to retain all of that knowledge. I like the targeted modules - that allowed me to locate the specific piece of the application I was working with, and gave me the particulars for that.
- Job Builder batches that allow you to run batches of updates for data integrity.
- De-duplicating data for loading and to ensure we do not load redundant records.
- Using PowerGrid like excel to drill and filter to particular record sets.
- Support - The team is very helpful and will provide you with as many resources as you need to succeed.
- The interface is a little basic.
- More in tool help would be great (This has been steadily improving).
- Quarterly or Annual updates on improvements and "What's New".
- It is a tremendous time saver. It does things Salesforce doesn't even have the capability to do. Tasks that would take hours to manually complete.
- We can process a tremendous amount of data daily through one person, vs. weeks for the data to be cleaned, reviewed, routed and input.
- Saves on headcount by allowing a dedicated user to set up batches and jobs for other teams to ensure their data integrity.
- The return on investment isn't easily quantifiable but it is FELT in our department.
I have used DataLoader. It is a simple tool for inserts, upserts and deletions of records in a single object. It's great if you have a spreadsheet of ID's that need a field change. It is extremely limited, and has none of the additional features of functionality of DemandTools. You cannot de-duplicate, you cannot cross reference objects, you cannot batch jobs, and you cannot schedule data cleaning activities. It is VERY limited, but it is free for 10,000 rows of data a month. Salesforce has a couple of mass edit and delete features, but it is extremely limited to records in a single object.