Make it possible search/export 'people' by 'company' fields
I want to set up custom fields within a company record so that I can group them by a number of parameters such as 'Type' (e.g. School, Retailer, etc), or 'Revenue Band' ($1-5m, $5-10m, etc).
Then, I want to search for and potentially export all the contacts (people) from within that group of companies (e.g. I may want to target contacts from 'Retailers' earning revenues of between '$1-5m' for a sales campaign).
This feels like it should be a fundamental feature of the advanced search, but I can't seem to figure it out without the use of tags on companies AND contacts. I love tags, but they are unfit for this purpose for a number of reasons:
I want to categorise companies in a number of different ways and it will create far too many tags and get really messy (we already have too many in my opinion)
Tags are too easy to 'accidentally' delete.
The company fields are unlikely to change that often (if at all), so a custom field would be far better than a tag.
There's no point tagging a person with a 'Revenue Band' for example. That would be impractical as people switch companies regularly. We don't want to have to update the revenue band of every employee within a company just so that we can search for them - totally impractical.
Surely the simplest solution would be to make it possible to search for people by 'company' specific fields or tags.
Please make it happen. Or tell me if I'm missing something :)
Thank you