Accelerate the Value of Data

Exploring the Advanced Search

You can use the Advanced Search functionality and create complex search queries.

Exploring Advanced Search

Advanced Search allows you to build complex queries by setting the search criteria for attributes, combining search conditions with various operators, and, grouping different search sets in an easy to use Query builder. To access the Advanced Search, click Advanced Search located in the Left panel.

You can select the entity type and build your search query in the Query builder.

Let us take an example of Debbie, who wants to filter a segment of individuals between a certain age range, who live in a specific state and who have email addresses. So the marketing team can target market these individuals on an anti-ageing cream promotion they are launching through email. In this case, Debbie will select the Entity type - Individual, then she would search and select the following attributes: Age, State, and Email. Notice that the list of attributes in the menu only displays relevant attributes based on the entity type selected.

We wanted to ensure that we provide our users with a guided experience to yield accurate search results. From here, she can change to attribute conditions and add the values she wants to filter on. In addition, she can also change the operators between attribute rows. The Advanced Search functionality supports four operators - And, Or, And not, and Or not.

In this case, Debbie is only interested in the individuals between the age range of 35 and 65 so lets say Age in range 35 to 65, individuals who live in the state of California, and, individuals who have an existing email address as our search criteria.

You can also get a dynamic count of profiles based on your search criteria.

For example, Debbie is given a file that contains a list of entities with unique Entity IDs. She wants to know the different types of email, such as home, work,and so on, and their count in this file. In her search query, she references the file using the In file option, uses the AND operator where she includes the Email Type attribute to further filter the records. See the example given below:

When you reference a file, make sure that the file size is not over 10 MB and/or the number of rows in the file does not exceed 5000. You can also upload multiple files, if required, but ensure that their combined file size does not exceed 10 MB and/or the total number of rows in all the files does not exceed 5000.

The Advanced Search supports contextual actions where you can insert a new row, duplicate a row, or delete a row. In addition, you can also add a new set for grouping, duplicate a set, or delete a set. So, if Debbie were to also search for individuals between 45 and 55, who live in New York and who have an existing email, she can simply duplicate this set, which saves her time from having to search and select the same set of attributes. Now, she has to only change the values.

At the bottom of the search panel, we have added a Search Query Summary where Debbie can view her search query and validate. She can also copy this query and share with others. After Debbie defines her search query, she is now ready to view her search results. She can minimize this Advanced Search panel so she can have the maximum amount of real estate for the high volume of search results returned. Alternatively, if she wants to focus on her search query and keep on extending it, she can expand the search panel to full screen.

Now, Debbie is ready to save her search results or export it and share it with her marketing team.

You may receive an error message while performing an advanced search, if the your search request contains more than 10000 search criteria.

Note: You can use the following shortcut keys to set the Advanced search criteria and continue using the keyboard without switching between your keyboard and mouse:
  • Use the "Tab" key to switch between the text fields.
  • Use the "Up/Down" arrow keys to navigate the menu items. For example, you can select an attribute or an operator by using the "Up/Down" arrow keys.
  • Use the "Enter" key to select the values.