Terminology
-
Query Group:
The blue box consisting of a subgroup and match operators is known as a Query Group. There may be multiple query groups depending on the structure of the query. -
Operators:
There are two Operators -- AND - all of the query groups need to be TRUE
- OR - one of the query groups needs to TRUE
-
Match Operators: This is used as a rule between query field and value
- Any - at least one of the provided input values needs to match for a TRUE evaluation. Input values can be alphanumeric.
- Contains - all of the provided input values need to match for TRUE evaluation. Input values can be alphanumeric.
- gt - checks if the stored value of the field is greater than the provided input value. Input value has to be numeric.
- gte - checks if the stored value of the field is greater than or equal to the provided input value. Input value has to be numeric.
- lt - checks if the stored value of the field is less than the provided input value. Input value has to be numeric.
- lte - checks if the stored value of the field is less than or equal to the provided input value. Input value has to be numeric.
- eq - checks if the stored value of the field is equal to the provided input value. Input value has to be numeric.
- any_exact - at least one of the provided input values needs to match the stored input field value with exactly the same number of character counts for TRUE evaluation. Input values can be alphanumeric.
- like - at least one of the provided input values needs to be a substring match for TRUE evaluation. Input values can be alphanumeric.
- time-overlap - helps to slice out a time period for certain attributes
- contains_exact - all of the provided input values need to match the stored input field value with exactly the same number of character counts for TRUE evaluation. Input values can be alphanumeric.
- exists - whether the stored field has a value or not
4. Qualifiers: There are 4 default Qualifiers
- None - checks for a match anywhere across the complete time range available for that attribute
- Recent - checks for a match in the last 3 years including the current one
- Current - checks for a match for the current tenure only
- Past - checks for a match anytime in the past, except during the current tenure
5. Query field: These are database fields where values for each profile are stored and used for matching against the provided input values. e.g., candidates job titles are stored in WorkExperience.projects.title, a company's website link is stored in WorkExperience.company.domain.
Building a 'React JS Developer' job title query (Current and IC)
- Go to the Queries Page.
- Click on Create Query
- Toggle to Query View
- Click on Add a query group
- Click on the query field and from the dropdown search for WorkExperience.Projects.Title
- Select match operator as any and add the following input values - React, ReactJS, react.js
- In the subgroup select Qualifier as Current
- Click on Add Rule to add another rule.
- In the newly added field, provide the following input values- Engineer, Developer, engineer, SDE, programmer, SWE, engg, software dev, software development, member of the technical staff.
- Add another Query Group by clicking on the Add Query Group in the top left corner. Select query group operator as AND
- This query group is added to exclude current job titles that are not required. You can provide any input value as exclusion by prefixing your input values with an exclamation '!' sign. If you wish to add multiple exclusion, use the Contains match operator. For now, go ahead and add the following values as exclusion -- !lead, !manager, !freelancer, !independent, !Architect,!Principal
- In the subgroup select Qualifier as Current
Saving an Attribute
- Click on Save Query button in the bottom right corner for the Query's page
- Select Query Categorization as Other - Explain in Query Description
- Add an attribute name, description and click on Create
- The query will start indexing as shown in the image. Wait for the query to be fully indexed before using it.
Testing an Attribute
- Browse a few profiles on LinkedIn which are a match. Make sure that the Findem extension is installed before you browse profiles.
- Come back to the Queries Page and click on the Test match button for the attribute you wish to test.
- The browsed profiles which are matching your attribute will appear under the Match tab. Click on it to toggle to Not Match to view profiles which are not matching the attribute.
- Click on the check mark or on the cross, to view the match details.
Using the created Attribute
- Open an existing Search or start a new search.
- Click on Advanced
- On the modal, search for the created attribute by name
Building Target Company List Attribute (Current)
- Go to the Queries Page.
- Click on Create Query
- Toggle to Query View
- Click on Add a query group
- Click on the query field and from the dropdown search for WorkExperience.company.domain
- Select Match Operator as any
- Provide company domain URL as input values separated by commas - e.g. amplitude.com, mixpanel.com, google.com
- Make sure that any values prefixed or postfixed to the domain url as shown above removed.
- www.google.com --> google.com
- https://www.linkedin.com/in/johndoe/ --> linkedin.com
- In the subgroup select Qualifier as Current.
- Save your query with Other - Explain in Query Description categorization
Comments
0 comments
Please sign in to leave a comment.