It is common to want to exclude specific types of Opportunities before running Align.ly Attribution. The most common example is to exclude "Renewal" Opportunities and that is typcially done by excluding an Opportunity Record Type or an Opportunity Type. If you have this requirement, here are the steps to follow:
For Opportunity-based Model
- Go to Align.ly Attribution Admin -> Settings -> Scroll to WHERE Clauses section
- Find the "WHERE Clause for Contact Role (OB)" setting
- As an example, enter Opportunity.Type != 'Renewal' to exclude Opportunity Types of "Renewal"
- Click "Save Settings"
Here are some other examples:
- Role != 'Partner'
- Opportunity.RecordTypeId != '0125e000000QZmvAAG'
- Opportunity.RecordTypeId IN ('0125e000000QZmvAAG', '0125e000000qnJXAAY')
- Opportunity.RecordTypeId NOT IN ('0125e000000QZmvAAG', '0125e000000qnJXAAY')
For Account-based Model
- Go to Align.ly Attribution Admin -> Settings -> Scroll to WHERE Clauses section
- Find the "WHERE Clause for Opportunity (AB)" setting
- As an example, enter Type != 'Renewal' to exclude Opportunity Types of "Renewal"
- Click "Save Settings"
Here are some other examples:
- RecordTypeId != '0125e000000QZmvAAG'
- RecordTypeId IN ('0125e000000QZmvAAG', '0125e000000qnJXAAY')
- RecordTypeId NOT IN ('0125e000000QZmvAAG', '0125e000000qnJXAAY')