Scenario
How to show how many leads and prospect are converted to Customer on a specific date range
Solution
- Navigate to Lists > Search > Saved Search > New
- Click Customer
- Search Title: Enter Title
- Click Criteria
- Click Use Expressions
- Click Columns
- Field:
- Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed.
- Select System Notes : Old Value
- Description: contains Prospect
- Parens: (
- And/Or: Or
- Select System Notes : Old Value
- Description: contains Lead
- Parens: )
- And/Or: And
- Select System Notes : New Value
- Description: contains Customer
- And/Or: And
- Select System Notes : Date
- Description: is within Previous Month
- And/Or: And
8. Click Results
9. Field:
Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed.
- Select System Notes Field : Date
10. Click Save As