All Collections
Managing Your Data
Contact Search
Contact Search/Make Decision Query Glossary
Contact Search/Make Decision Query Glossary

Definitions of the queries available within the Contact Search or Make Decision component drop down options

Emma Dixon avatar
Written by Emma Dixon
Updated over a week ago

Activities refers to actions that has been done in the Force24 portal. This could be if a contact has clicked on an email, bounced, unsubscribe etc. Below is a list of Activities you can search for in the system and what they’re used for.  

Common

Activities – Bounced SMS campaign:

This query is used to search for contacts that have bounced from an SMS campaign or not. It is followed up by a ‘Yes’ or ‘No’: ‘Yes’ to search for the contacts that have bounced from an SMS campaign and ‘No’ to search for contacts that haven’t bounced from an SMS campaign.

Activities - Bounced SMS campaign Date:

This query is used to search for contacts that have bounced from an SMS campaign for a specific date.

Activities - Bounced SMS campaign Date – Relative:

This query is used to search for contacts that have bounced from an SMS campaign date relative to the day you are currently in.

Along with this activity query, there are other components that you need to add in relation to the date to complete the query in order to find the contacts you’re looking for. For example: 

Activities – Campaign WebActivity:

This query searches for contacts that have received a campaign and has carried out any WebActivity relating to that campaign. You would need to specify what campaign you want to look at. For example:

This query will show every contact that have had WebActivity with the ‘Liv Test’ campaign.

Activities – Clicked Email Campaign:

This query is used to search for contacts that have clicked on a specific email campaign.

Activities - Clicked Email Campaign Date:

This query is used to search for contacts that have clicked on a specific email on a specific date (the date that you input). For example:

Activities - Clicked Email Campaign Date – Relative:

This query is used to search for contacts that have clicked on a specific email on a date relative to the day you are currently in.

Activities - Clicked Email Campaign Name:

This query is used to see find a specific email campaign by name and check what contacts have clicked on the email.

Activities – Clicked Email URL:

This query is used to search for what contacts have clicked on a specific URL from an email campaign. For example:

Activities – Clicked SMS Campaign:

This query is used to search for contacts that have clicked on a specific SMS campaign.

Activities – Clicked SMS Campaign Name:

This query is used to see find a specific SMS campaign by name and check what contacts have clicked on the SMS.

Activities – Clicked SMS Date:

This query is used to search for contacts that have clicked on a specific SMS campaign on a specific date (the date that you input).

Activities – Clicked SMS Date – Relative:

This query is used to search for contacts that have clicked on a specific SMS on dates relative to the day you are currently in.

Activities – Clicked SMS URL:

This query is used to search for what contacts have clicked on a specific URL from an SMS campaign

Activities – Hard Bounced Email Campaign:

This query is used to search for contacts that have hard bounced from an email campaign or not. It is followed up by a ‘Yes’ or ‘No’: ‘Yes’ to search for the contacts that have hard bounced from an email campaign and ‘No’ to search for contacts that haven’t been hard bounced from an email campaign.

Activities – Hard Bounced Email Campaign Date:

This query is used to search for contacts that have hard bounced from an email campaign for a specific date

Activities – Hard Bounced Email Campaign Date – Relative:

This query is used to search for contacts that have hard bounced from an email campaign at certain dates relative to the day you are currently in.

Activities – Hard Bounced Email Campaign Name:

This query is used to search for contacts that have hard bounced from a specific email campaign (you will need to enter the email campaign name you want to look at).

Activities – Hard Bounced SMS Campaign Name:

This query is used to search for contacts that have hard bounced from a specific SMS campaign (you will need to enter the SMS campaign name you want to look at).

Activities – Has WebActivity:

This utilises the tracking script to track what users/contacts do on your website. This query will search for contacts that have been on your website and has carried out any activity.

Activities – Open Email Campaign:

This query searches for contacts that have opened up an email campaign and is not specific.

Activities – Open Email Campaign Date:

This query searches for contacts that have opened an email campaign. This is followed by a ‘Yes’ or a ‘No’ component

Activities – Open Email Campaign Date – Relative:

This query searches for contacts that have opened an email campaign at certain dates relative to the day you are currently in.

Activities – Opened Email Campaign Name:

This query searches for contacts that have opened a specific email campaign (a campaign that you would specify by name)

Activities – Replied SMS Campaign Name:

This query searches for contacts that have replied to a specific SMS campaign (a campaign you would specify by name)

Activities – Replied to SMS Campaign:

This query searches for contacts that have replied to an SMS campaign 

Activities – Reply Date

This query searches for contacts that have replied to an SMS campaign on a specific date (The date needs to be inputted in this format: DD-MM-YYYY).

Activities – Reply Date – Relative

This query searches for contacts that have replied to an SMS campaign on dates relative to the day you are currently in.

Activities – Reply Message

This query searches for contacts that have replied to an SMS campaign by the message that was sent (you would need to type in the message or a part of the message for this search query).

Activities – Soft Bounced Email Campaign

This query searches for contacts that soft bounced from an email campaign or not. It is followed up by a ‘Yes’ or ‘No’: ‘Yes’ to search for the contacts that have soft bounced from an email campaign and ‘No’ to search for contacts that haven’t soft bounced from an email campaign.

Activities – Soft Bounced Email Campaign Date

This query searches for contacts that have soft bounced from an email campaign for a specific date.

Activities – Soft Bounced Email Campaign Date – Relative

This query is used to search for contacts that have soft bounced from an email campaign date relative to the day you are currently in.

Activities – Soft Bounced Email Campaign Name

This query is used to search for contacts that have soft bounced from a specific email campaign (one that you would specify by name).

Activities – Spam Bounced Email Campaign 

This query is used to search for contacts that have spam bounced from an email campaign or not. It is followed up by a ‘Yes’ or ‘No’: ‘Yes’ to search for the contacts that have spam bounced from an email campaign and ‘No’ to search for contacts that haven’t spam bounced from an email campaign.

Activities – Spam Bounced Email Campaign Date

This query is used to search for contacts that have spam bounced from an email campaign for a specific date.

Activities – Spam Bounced Email Campaign Date – Relative

This query is used to search for contacts that have spam bounced from an email campaign date relative to the day you are currently in.

Activities – Spam Bounced Email Campaign Name

This query is used to see the contacts that have spam bounced from a specific email campaign (one that you would specify by name).

Activities – Unsubscribed From Email Campaign

This query is used to see the contacts that have unsubscribed from an email campaign. This is followed by a yes or a no component (This could be from any email campaign).

Activities – Unsubscribed From Email Campaign Date

This query is used to see the contacts that have unsubscribed from a campaign from a specific date (a date you have to input).

Activities – Unsubscribed From Email Campaign Date – Relative 

This query is used to search for contacts that have unsubscribed from a campaign from dates relative to the day you are currently in.

Activities – Unsubscribed From Email Campaign Name

This query is used to see if a person has unsubscribed from a specific email campaign (one that you would need to specify by name)

Activities – Unsubscribed From SMS Campaign

This query is used to search for contacts that have unsubscribed from an SMS campaign (this could be for any SMS campaign)

Activities – Unsubscribed From SMS Campaign Date

This query is used to search for contacts that have unsubscribed from an SMS campaign from a specific date.

Activities – Unsubscribed From SMS Campaign Date – Relative 

This query is used to search for contacts that have unsubscribed from an SMS campaign from dates relative to the day you are currently in.

Activities – Unsubscribed From SMS Campaign Name

This query is used to see the contacts that have unsubscribed from a specific SMS campaign (one that you would specify by name)

Activities – WebActivity Date

This query searches for contacts that have had any web activity on a specific date

Activities – WebActivity Date – Relative

This query searches for contacts that have had any web activity on dates that are relative to the day you are currently in.

Activities – WebActivity Is Goal

This query searches for contacts that have been on a tracked goal URL page and has had any web activity on the page.

Activities – WebActivity High Value

This query searches for contacts that have been on a tracked high value URL page and has had any web activity on the page.

Activities – WebActivity Referrer

This query searches for contacts that have been referred to a webpage. You would insert the referrer URL to see what contacts have been referred to that page. 

Activities – WebActivity URL

This query searches for contacts that have got onto your tracked web page using the URL.

 There are other components that you will need to use to complete your query to specify what contacts you’re looking for. These are components like: equal, not equal, begins with, contains, doesn’t contain, is empty, is not empty, less, less or equal, greater, greater or equal, between, not between.

 'equal': Used with a query to search for contacts from the exact data you input in the next field. For instance, if you were searching for a specific email address you would select “Email Address” from the dropdown then select “equal” and type in the exact email address you want to find, exactly the way it is stored in the system. (Visual Example below)

 
'not equal':
Used with a query to search for all contacts excluding the data you input in the next field. For instance, if you were searching for a specific email address you would select “Email Address” from the dropdown then select “not equal” and type in the exact email address you want to find, exactly the way it is. (Visual Example below)


'begins with':
This component is used to search for information that begins with whatever you have inputted on the right. For instance:

This search query would search for all contacts with email addresses that begin with ‘am’.


'contains':
This component is used to search for contacts that contains the information you input on the right relating to the data type on the left that you are searching for. For instance:

 The search query above searches for contacts with email addresses that contains “amani.white” within it. This search method isn’t specific and can be used if you’re not sure what the exact email address you are looking for is. It can be used instead of ‘equal’ as equal is specific and your input has to match the exact data within the system otherwise it would show no results.

 

'doesn’t contain': This component works the same way the ‘contains’ component works except in reverse. This component searches for every contact except those that contains data for the information that you input on the right relating to the data type on the left. For instance:

This search query searches for every contact except those whose email address contains ‘Amani’.


'is empty':
This component searches for contacts with empty data field in regard to the data type you’re searching for. For example:


'equivalent':

[image]

 

This query searches for all the contacts with no data in the email address field (this should return no contacts as every contact needs an email address to be in the system).

 

'is not empty': Much like the ‘is empty’ component, the ‘is not empty’ component will search for all contacts with populated data field in regard to the data type you’re searching for. For example:

 This query searches for all the contacts that have data within the email address field, this will show you all your contacts as a contact cannot be added into the system without an email address.

 

'Less': Used to search for contacts on a date/time basis. You would need the ‘Less’ field to find contacts previous to the date/time you want to find information about. For instance, if you are looking for contacts that clicked on an email campaign previous to the 5th of February 2019. You would need this query:

This search query will bring results of contacts that have clicked on an email campaign before the 5th February 2019 but not including the 5th.

 

'less or equal': This works in the same way the Less field works. The ‘Less or equal’ field would bring results that are before and including the date that you will specify. For instance, 

This search query will bring results of contacts that have clicked on an email campaign from the 5th of February 2019 and before that date.

 

'greater': The greater component is much like the ‘less than’ component, but in reverse. With the ‘greater’ query you can use this to find information about contacts after the date/time you want but not including the date you input. For example:

This search query will bring results of contacts that have clicked on an email campaign after the 5th of February 2019 but not including the 5th.

 

'greater or equal': This component is used to find information on a contact from a certain date/time onwards. The difference between this component and the greater component is that this includes the date that you specify. For instance:

This query searches for contacts that have clicked on an email campaign from the 5th of February 2019 and onwards, this includes the 5th.

'between': Used to search for contacts on a date/time basis. You would need the ‘between’ component to find contacts between the two dates/times you want to find information about. For example:

This query searches for contacts that have clicked on an email campaign between the 5th of February 2019 and the 5th of March 2019.

 

'not between': This component is much like the ‘between’ component but in reverse. The not between is used to search for contacts on a date/time basis. You would need the ‘not between’ component to find contacts except for between the two dates/times you want to find information about. For example:

This query searches for contacts that have clicked on an email campaign excluding those that have clicked on an email campaign between the 5th of February 2019 and the 5th of March 2019.

There are other queries besides Activities that you can search for in the system. Below is a list of queries that you can search for and what they mean.

Address 1

The ‘Address’ query is used to search for fields relating to data about a contact’s address. Along with address are 11 specifiers for Address. ‘City,’ ‘Country,’ ‘County,’ ‘Fax,’ ‘Line 1,’ ‘Line 2,’ ‘Line 3,’ ‘Post Code,’ ‘Telephone 1,’ ‘Telephone 2,’ ‘Telephone 3,’ there are also spare fields for these set of queries under the ‘Address 2’ query 

City

This specifier is used to search for data stored in the city field

Country

This specifier is used to search for data stored in the country field

County 

This specifier is used to search for data stored in the county field

Fax

This specifier is used to search for data stored in the fax field

Line 1

This specifier is used to search for data stored in the line 1 field

Line 2

This specifier is used to search for data stored in the line 2 field

Line 3

This specifier is used to search for data stored in the line 3 field

Post Code

This specifier is used to search for data stored in the post code field

Telephone 1

This specifier is used to search for data stored in the telephone 1 field

Telephone 2

This specifier is used to search for data stored in the telephone 2 field

Telephone 3

This specifier is used to search for data stored in the telephone 3 field

Aux Fields

The Aux fields are custom fields to store data, there are 10 Aux fields and this query would be used to search for whatever data is stored in an Aux field. 

Aux Dates + Relative

Much like the Aux field, the Aux date query is used to search for custom dates. (Dates need to be inputted in this format: DD-MM-YYYY). Along with the Aux dates are Aux date relative, this is used in the same way the Aux date query would be used except the dates you specify are relative to the day you are currently in. There are 5 Date fields and 5 Date relative fields. 

Aux Date Time + Relative

The Aux Date Time field is much like Aux Date, the query is used to search for custom date-time. (Date-time needs to be inputted in this format: DD-MM-YYYY HH:mm:ss:), Along with the Aux date-time, are Aux date-time relatives. This is used in the same way the Aux date-time query would be used except the date-time you specify are relative to the day you are currently in. There are 3 Date-time fields and 3 Date-time relative fields

Birth Date

This query is used to search for contacts birth date that you specify (The date needs to be inputted in this format: DD-MM-YYYY).

BirthDay – Relative

This query is used to search for contacts Birthday that you specify. The difference between this query and the Birth Date query is that this query’s date is relative to the day you are currently in.

Campaign – Channel

This query is used to search for campaigns that are either Emails or SMSs

Campaign – Has Received Any

This query is used to search for contacts that have received any campaigns, or those that haven’t received any.

Campaign – Received Campaign Date

This query is used to search for contacts that have received a campaign at a specific date (A date that you specify).

Campaign – Received Campaign Date – Relative

This query is used to search for contacts that have received a campaign at dates that are relative to the day you are currently in.

Campaign – Received Campaign Name

This query is used to search for contacts that have received a specific campaign (one that you would specify by name).

Company Name

This query is used to search for contacts with data in the company name field (you will need to specify the company name you are searching for)

Contact ID

This query is used to search for specific contacts through their contact ID

Created On

This query is used to search for when a contact has been added into the system. This query is date related and you would need to search the date to view what contacts were added into the system on that date.

Created On – Relative

This query is just like the ‘Created On’ query except the date that you search for is relative to the date that you are currently in. For instance:

This query searches for contacts that have been added to the system ‘yesterday’. No matter what the date is, the yesterday will always be the day before the date you’re in as it is ‘relative’ to the date you’re in.

Email Address

This query is used to search for contacts through their email address. This query also has two other spare fields: Email address 2 & 3.

Fax

This query is used to search for contacts through their Fax details.

First Name

This query is used to search for contacts by their first name [*note]: This will show every contact sharing the same first name and isn’t specific.

Format Optimized Phone Number

This query is the is the last 8 digits of a phone number (no spaces, prefixes, parenthesis etc.) this is mostly used internally to approximately do phone number deduplication for contacts.

Has Valid Phone Number

This query searches for all the contacts with a valid phone number.

Import Key

This query is used to search for all the contacts linked with an import key (you will need to specify the import key).

Is Deleted

This query is used to search for contacts that has been deleted. 

Is Form Capture

This query is used to search for contacts that have been added into the system via a form capture.

Job Title

This query is used to search for contacts through their job title. It will show all contacts that share the same job title you specify as long as there is data in that field

Last Name

This query is used to search for contacts by their last name [*note]: This will show every contact sharing the same last name and isn’t specific.

Lead Score

This query is used to search for contacts by their lead score.

Manager Name

This query is used to search for contacts by their manager name.

Manager Phone

This query is used to search for contacts by their manager phone.

Marketing List

This query is used to search for contacts in a specific marketing list. 

Marketing List – Is In Any

This query is used to search for contacts that are in any marketing list, or contacts that aren’t in any marketing list.

Middle Name

This query is used to search for contacts by their middle name and will bring all contacts sharing that middle name

Modified On 

This query is used to search for contacts that have had any personal details modified on a specific date.

Modified On - Relative

This query is used to search for contacts that have had any personal details modified on a date relative to the one you are currently in.

Person Id

This query is used to identify/search for contacts by their Person ID. It can be used in instances whereby a contact gets overwritten; the person ID stays the same and can be used to find the original information for that contact. 

Phone Number

This query is used to search for contacts by their phone number.

Salutation

This query is used to search for contact by their salutation. Salutations are manually added to a contact when they are uploaded to the system, but you can add Salutations later if you go to the contact’s profile and edit the contact details for that contact.

Send Filter

This will allow you to select the contacts only with the send filter applied to receive the email. Even if they are in the target marketing list, the send filter will block contacts unless they have the correct send filter. You may add a send filter to a contact by performing a contact search and selecting the ‘Send Filter’ option at the bottom of the filtered contacts grid. [visual example below]

Status – Direct Mail

This query is used to search the status of all contacts that are either: Active, Unsubscribed, Bounce or Inactive in terms of Direct Mail

Status – Email

This query is used to search the status of all contacts that are either: Active, Unsubscribed, Bounce or Inactive in terms of Email

Status – Global

This query is used to search the status of all contacts that are either: Active or Inactive. The global status is the over all

Status – SMS

This query is used to search the status of all contacts that are either: Active, Unsubscribed, Bounce or Inactive in terms of SMS

Subscription Preference

This query searches for contacts that have either subscribed or unsubscribed from a certain campaign.

Journey Stage

Date Added

This query is used to search for contacts that have been added to a stage for any journey on a specific date (The date needs to be inputted in this format: DD-MM-YYYY)

Date Added - Relative

This query is used to search for contacts that have been added to a stage for any journey on a date relative to the day you are currently in.

Date Completed

This query is used to search for contacts that have completed any journey on a specific date (The date needs to be inputted in this format: DD-MM-YYYY).

Date Completed – Relative

This query is used to search for contacts that have completed any journey on a date relative to the day you are currently in.

Name

This query is used to search for contacts at specific stages of a journey (you will need to select what stage of the journey you would like to look at) or this query could be used in the complete opposite way and you can use it to look at contacts at every other stage but the one specified using the ‘is not’ component.

Status

This query is used to search for contacts by their status within a journey. This could be by those that are ‘active’, have ‘completed’, are ‘delayed’, ‘queued’ or ‘skipped’ in the journey.

Journey

Date Added

This query searches for contacts that have been added to any journey on a specific date (The date needs to be inputted in this format: DD-MM-YYYY).

Date Added - Relative

This query is used to search for contacts that have been added to any journey by a date that is relative to the day you are currently in. 

Date Completed

This query is used to search for contacts that have completed any journey at a date that you specify. For instance:


Date Completed – Relative

This query is similar to the ‘Date Completed’ query and is used to search for contacts that have completed a journey on dates that are relative to the day you are currently in. For instance:


Name

This query is used to search for contacts that are in a specific journey.

Status

This query is used to search for contacts by their status within a journey. This could be by those that have ‘completed’ the journey or those that are ‘active’ in the journey.

Journey Activities

Email Click Journey Name

This query is used to search for contacts that have clicked on an email within a journey (you will need to enter the journey name you want to look at).

Email Hard Bounce Journey Name

This query is used to search for contacts that have hard bounced from an email within a journey (you will need to enter the journey name you want to look at).

Email Open Journey Name

This query is used to search for contacts that have opened up any email within a journey (you will need to enter the journey name you want to look at).

Email Received Journey Name

This query is used to search for contacts that have received an email within a journey (you will need to enter the journey name you want to look at).

Email Soft Bounce Journey Name

This query is used to search for contacts that have soft bounced from an email within a journey (you will need to enter the journey name you want to look at).

Email Spam Bounce Journey Name

This query is used to search for contacts that have spam bounced from an email within a journey (you will need to enter the journey name you want to look at)

Email Unsubscribe Journey Name

This query is used to search for contacts that have unsubscribed from any email within a journey (you will need to enter the journey name you want to look at).

SMS Click Journey Name

This query is used to search for contact that have clicked on a link in an SMS within a journey (you will need to enter the journey name you want to look at).

SMS Hard Bounce Journey Name

This query is used to search for contacts that have hard bounced from an SMS within a journey (you will need to enter the journey name you want to look at).

SMS Received Journey Name

This query is used to search for contacts that have received an SMS within a journey (you will need to enter the journey name you want to look at).

SMS Reply Journey Name

This query is used to search for contacts that have replied to an SMS within a journey (you will need to enter the journey name you want to look at).

SMS Unsubscribe Journey Name

This query is used to search for contacts that have unsubscribed from an SMS within a journey.

WebActivity Journey Name

This query searches for contacts that is a part of a specific journey and have carried out any WebActivity relating to campaigns within that journey.

Journey Stage Activities

Email Click Stage Name

This query searches for contacts that have clicked on an email campaign from a stage in a journey. For instance:

This query is often used in the make decision stage, in the example above this query would be used to search for contacts that have clicked on the first email in this journey.

Email Hard Bounce Stage Name

This query searches for contacts that have hard bounced from an email at a specific stage in a certain journey. You will need to select the exact stage in the journey when you search for the stage name.

Email Open Stage Name

This query searches for contacts that have opened the email at a specific send email stage in a certain journey. You will need to type in the name of the send email component to view the contacts (all opens are unique opens).

Email Received Stage Name

This query searches for contacts that have received an email from a specific stage in a certain journey. You will need to select the exact stage in the journey when you search for the stage name.

Email Soft Bounce Stage Name

This query searches for contacts that have soft bounced from an email at a specific stage in a certain journey. You will need to select the exact stage in the journey when you search for the stage name.

Email Spam Bounce Stage Name

This query searches for contacts that have spam bounced from an email at a specific stage in a certain journey. You will need to select the exact stage in the journey when you search for the stage name.

Email Unsubscribe Stage Name

This query searches for contacts that have unsubscribed from an email at a specific stage in a certain journey. You will need to select the exact stage in the journey when you search for the stage name.

SMS Click Stage Name

This query searches for contacts that have clicked on an SMS campaign from a stage in a journey. You will need to select the exact stage in the journey when you search for the stage name.

SMS Hard Bounce Stage Name

This query searches for contacts that have hard bounced from an SMS campaign at a specific stage in a certain journey. You will need to select the exact stage in the journey when you search for the stage name.

SMS Received Stage Name

This query searches for contacts that have received an SMS from a specific stage in a certain journey. You will need to select the exact stage in the journey when you search for the stage name.

SMS Reply Stage Name

This query is used to search for contacts that have replied to an SMS campaign at a certain stage in a journey.

SMS Unsubscribe Stage Name

This query searches for contacts that have unsubscribed from an SMS at a specific stage in a certain journey. You will need to select the exact stage in the journey when you search for the stage name.

WebActivity Email Stage Name

This query searches for contacts that is at a send email stage within a journey and have received the email campaign and carried out any web activity relating to that specific campaign within the journey.

Did this answer your question?