In Salesforce, it’s easy to find Accounts that have Opportunities, but there is not a good way to find Accounts WITHOUT Opportunities.
Using MassImpact and "Object Count" this is very easy to do:
- Create a custom field in Salesforce to track the number of Opportunities on an Account (e.g. Opp_count)
- Use the MassImpact "Object Count" feature in the Set Value step to add up the Opportunities in an Account and populate this value in the custom field on the Account record
- Use MassEffect export function to export the Accounts where the Opp_count equals "0"
NOTE: This process can be repeated for ANY sub-object on the Account object (or any other object for that matter). Since this count is static (will not automatically increment the count whenever a new Opportunity is created), you can also add another custom (date) field Opp_count_lastupdated, and set this to the current date (using our custom formula "today()") to track the last time this value was updated. Save your scenario and then automate the scenario to run to keep this field up-to-date.