This article is a more detailed look at constructing search queries in Close.
You can add filters to find Leads that have a certain status, were updated within a specific time period, have a Custom Field added, etc.
To add a new filter, click the
+ Add Filter button that will open up the Filters sidebar where you can search by different attributes. In the example below, we are looking for all Leads marked with the Potential status.
Adding another Filter will build upon this statement. For example, the below Filter will be looking for Leads with the Potential status AND were created this week:
The Match operator will return Leads that match the conditions you select. Leads matching
All of your conditions will return Leads that match each of your filters, and
Any of your filters will return Leads matching any of your conditions.
Not all of will exclude Leads that match every filter in that subgroup, and
None of will return Leads that don't match any of the filters you selected.
To build a set of conditions, add filters to the same row, then choose
Any of and then add another set of conditions to a different row. This will return Leads that match all the conditions in the first row OR the other.
Grouping filters together will apply the same rules to each subsection. To add a Group to a specific search term, hover over the search term and select
Wrap in a group. Then add your next filter.
You can combine any of these Match operator filters to return a set of Leads that match either one set of conditions in one row or another set of conditions in a different row.
Be aware of double negatives!
Searching for "none of" the current Lead status "is not" Potential will return Leads with the Potential status. This double negative will cancel itself out.
Use the matching dropdown menu on a filter statement to add a disqualifier. Using
is not will return Leads that do not have that particular condition. For example, to look for Leads created within the past week that do not have an address based in New York, your query would look like the below:
You can filter down to changes made down to the past few hours or minutes on any Date search function. In this example, we are building a query to look for Leads who were created within the past 5 hours:
You can filter for leads that are in a specific local time (e.g. leads with a local time between 10 AM and 4 PM):
Local time filtering is done by looking at leads' phone numbers and addresses and calculating their timezone.
For example, if a lead (contact) has
+1 310 123 456 as their phone number, the
310 area code is the Los Angeles area code so that lead would be assigned PDT (Pacific Daylight Time) timezone and local time filtering would take that into account. Likewise, if a lead has an address set to
New York City, NY, USA, that would be the EDT (Eastern Daylight Time) timezone that would be assigned to that lead.
A few notes about filtering by local times:
- A lead can be associated with multiple time zones if it has multiple addresses or phone numbers with different area codes.
- When you filter by a particular local time, we find leads where any of their time zones match the local time you requested.
- Keep in mind that the "Local time" column is not capable of showing multiple local times. If multiple time zones are associated with a lead, one local time is displayed at random.
- If it's currently Wednesday, a search looking for the latest call created
this weekwill show all Leads that had their latest call sometime between last Sunday and today.
If you need to change an existing filter, you don't need to remove it altogether to start new. Instead, simply click on the specific filter that needs to be edited. This will pull up the
Filter menu of that filter category. Any changes you make will be reflected in real time in your search results.
To remove a filter, click on the
x that appears next to the filter.
It can sometimes be helpful to limit the amount of Leads returned in a search. To do so, use the 'Set limit' function at the upper left corner of the Leads page, next to the number of results. Limiting your results to 100 Leads will return that many Leads (if at least 100 Leads match the filters you apply).
Using slice will split your results into different sections. This can be used when you want to split up sending a bulk email or target a section from a much larger number of Leads per day.
Slice can be found when using the Leads filter, under the Leads tab. For example, if you wanted to split your results into 8 different sections and view the first section, you would enter 1 / 8:
To view the second section of Leads, use 2 / 8. This would be continued until you are viewing 8 / 8, with each section showing different Leads.
The slice function can go up to 64 sections. Searching for 1/65 will lead to a search error with no results.
Updated 15 days ago