DemandTools – Product Details
DemandTools is a data quality power toolset of 10+ individual software modules, each of them performing a specific data quality task working with Salesforce data.
The DemandTools modules are broken down into three major sections according to their primary objectives:
- Maintenance Tools – Modules for data loading, data backup, data manipulation
- Cleansing Tools – Modules for deduplication and merging of duplicates at the Salesforce.com data center
- Discovery Tools – Modules for comparing external data to the data already loaded into Salesforce.com before importing
DemandTools – Maintenance Tools
The MassImpact module is a multi-table data manipulation tool that does not require importing or exporting. MassImpact allows the administrator to develop and maintain data standards by developing corrective actions to common data mistakes. These changes can be made to any size and subset of data based on selection criteria.
It could be used for example to:
- Find all Accounts with a Billing State = Texas and change the state value to TX
- Find all items in the price book between $5 and $10 and add 20% to the list price
- Find all Contacts with no shipping information and move the Account billing information into those fields populating them
- Find all Opportunities that were projected to close last month but didn’t and drop their probability by 20%
Any field in any table of Salesforce (API permitting) can be mass modified using the MassImpact data manipulation module.
MassImpact YouTube Video:
The MassEffect tool is the ultimate data loader, data exporter, updater and delete tool for Salesforce and Force.com platform data.
With full support for importing and exporting advanced file formats including XLS, CSV, MDB and UDL, not to mention many unique features MassEffect is used by the serious administrator looking for full data loading power and our unique heads up console.
MassEffect is fully international character capable.
MassEffect YouTube Video:
PowerGrid is a spreadsheet like data canvas connected directly to your Salesforce data. Users use standard spreadsheet functions (drag and drop, copy and paste, direct entry, filtering etc) combined with the advanced data quality components from the other DemandTools modules to quickly and easily make ad hoc changes to Salesforce en mass.
PowerGrid Youtube Video:
The Reassign Ownership module adds the ability to mass transfer the ownership of any object in Salesforce and its related sub-objects (if so desired) in a single pass. The end user starts by selecting which Salesforce objects to change using where clauses and optional match conditions to spread changes across multiple new owners, and alternatively using an input file of Salesforce ID’s for changes. The module also includes options for selecting which sub objects to reassign, creating tasks directly on objects to track changes and reviewing the results grid.
Reassign Ownership YouTube Video:
The DemandTools MassBackup module allows the user to create an automatic MDB (Microsoft Access) backup of their salesforce.com data on their local computer. This useful tool allows for custom selection of tables and custom scheduling. The MDB database that is created is fully relational and useful for analytics, security and integrations. It may also be mass modified and re imported into salesforce.com with MassEffect!
MassBackup YouTube Video:
BulkBackup adds enterprise backup strength to the lighterweight MassBackup module. BulkBackup uses the Salesforce
Bulk API for more efficient data flow and the extended Microsoft Access .accdb file format providing a larger, more robust data environment.
DemandTools – Cleansing Modules
Single Table Dedupe
The industry standard batch deduplicator for Salesforce used by thousands of customers ranging from small business to large enterprise.
The Single Table Dedupe module is capable of finding and merging all types of Salesforce duplicate objects including Accounts, Leads, Contacts but also Events, Assets etc, even Custom Objects. The deduplicator allows for 100% control in terms of how the duplicates are identified and multiple different methods to merge the records. The user can choose between a fully manual “Custom Merge” or use one of our advanced record selection rules (or even create their own) to execute an automated master vs. servant merge process. Of course the Single Table Dedupe provides the user with the heuristic and phonetic matching tools in addition to excellent street and phone parsing matches, domain matches and much more.
With the newly revamped Single Table Dedupe in DemandTools 2.7 we have added increased flexibility with Field based Rules when merging. Field rules allow for an automated field-based custom merge, users pick a master record rule then set up rules for how to handle each field individually during the merge process. For example, use the Oldest record as Master record but use the phone number and email from the newest record etc.
Additionally, DemandTools now has the ability to mass merge duplicates found by either DupeBlocker Duplicate Warnings or Data.com Duplicate Record Management.
Single Table Dedupe YouTube Video:
Mass Lead Convert
Mass Lead Convert evolved from a customer request, and is a quick and easy way to select (using custom criteria) a large volume of Leads and have them automatically converted. The administrator defines the options for assignments, opportunity creation, auto tasking and more.
Mass Lead Convert YouTube Video:
Lead -> Contact Deduplication
The Lead-> Contact Deduplication module allows you to find duplicates which exist between Leads and Contacts using our advanced data matching algorithms. When the duplicates are discovered the Lead-> Contact Deduplication module batch converts the duplicate Leads (with their campaigns and activities) to the matching Contact.
Lead-> Contact Deduplication YouTube Video:
The Lead->Account Deduplication tool allows you to find duplicates which exist between Leads and Account, and converts the Lead (with their campaigns and activities) to a new Contact in the appropriate Account.
Lead->Account Deduplication Youtube Video:
DemandTools – Discovery Tools
The Find/Report ID’s module is a tool capable of comparing an external data source (XLS, MDB, CSV, and UDL) to ANY information (including Custom Objects) in Salesforce. The Find/Report ID’s module will do the custom comparison and develop a results file showing which objects matched and their location of where they are by object ID (no data is actually changed).
Find/Report ID’s Youtube Video:
Now that you understand what the DemandTools modules are capable of, download your free trial today!