How to Run a Primary Role List?
Have tried a bunch of ways unsuccessfully over the years---How do I build a list of leads the have primary roles in SF Opportunities? Basically, I'm trying to build some funnel reports that focus on recent new business for leads in primary roles (or get rid of people without primary roles). Would also like to trigger some onboarding when a new biz deal becomes won for primary users.
What I'd Like
Member of Opportunity = True
- Primary is true
- Added to opportunity in past 90 days
- Type is NEW
Sounds straightforward, right?
The Issues:
I have tried all kinds of combinations around this with no luck.
- Has Opportunity filter does not have an Is Primary or Added to Opportunity constraint. I believe this would be one of the simplest solutions. A possible feature request.
- Opportunity was Updated filter (and trigger) also is missing an Is Primary constraint. A possible feature request.
- Added to Opportunity (and trigger) sounds like a great solution. However, there are issues where someone was added without a role, and then changed to a primary role later (or vise versa). Or a new biz deal changed from new to upsell (or vise versa) and I can't constrain the change to primary users.
- Another complication--Multiple Opportunities. Someone could have both a new opportunity and an upsell opportunity at the same time. This throws off the ability to rely on multiple versions of above.
- Segments. I went off the board and tried building Segments to address mutually exclusive rules for #4. That went nowhere fast as Segments are limited to the Has Opportunity filter (See #1 limitations).
Anyone find any workarounds? I'm thinking of going to old school Marketo thinking and use Add to List combinations.
Of course, Marketo could just make it easier by adding an Is Primary constraint (And add in Roles too).
Other Resources
Re: Want to trigger off of Opp Won, and enroll PRIMARY contact in nurture