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 ‘Email 1’ 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 ‘ex’.
'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 “example” 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 ‘example’.
'is empty': This component searches for contacts with empty data field in regard to the data type you’re searching for. For example:
'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 31st October 2023. You would need this query:
This search query will bring results of contacts that have clicked on an email campaign before the 31st October 2023 but not including the 31st.
'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 31st of October 2023 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 31st of October 2023 but not including the 31st.
'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 31st of October 2023 and onwards, this includes the 31st.
'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 30th of September 2023 and the 31st of October 2023.
'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 30th of September 2023 and the 31st 2023.
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.
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.
If you have any questions, feel free to reach out to us through the live chat function available bottom right in your Force24 Platform. Our team is ready to assist you and provide support whenever you need it!