You need your CRM admin to tie opportunity activity to a field at the account level so that you can apply account filters. For example, when a new opportunity opens on one of our accounts, we have an "Account Stage" field that flips to "Prospect." When that opportunity closes, the Account Stage field flips to "Client" if it is Closed/Won or "Former Prospect" if it is Closed/Lost.
Now I can run a smartlist for all contacts at a Prospect account and know that there is an open opportunity there, even if the contact is not on that opportunity.