FilterDefinition
Defines audience segmentation filters in Salesforce Marketing Cloud. Each filter specifies logical rules that identify which contacts or subscribers meet specific criteria. This table supports update and query operations but does not allow inserts, as filters are managed within the platform interface.
Table-Specific Information
Select
The connector uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The connector processes other filters client-side within the connector.
For example, the following (but not only) query is processed server side:
SELECT * FROM FilterDefinition WHERE CreatedDate > '2017/01/25'
Update
You must specify the ObjectId in the WHERE clause when executing an update against this table.
UPDATE FilterDefinition SET Name = 'Changed' WHERE ObjectId = 'nzxcaslkjd-123'
Delete
You must specify the ObjectId in the WHERE clause when executing a delete against this table.
DELETE FROM FilterDefinition WHERE Object = 'nzxcaslkjd-123'
Columns
| Name | Type | ReadOnly | Description |
| ObjectID [KEY] | String | False |
Stores the system-controlled text string identifier (Id) that uniquely identifies the filter definition within Salesforce Marketing Cloud. This value is read-only and ensures consistent reference across filtering, segmentation, and automation activities. |
| Client_ID | Int | True |
Specifies the client Id that associates this filter definition with the correct Salesforce Marketing Cloud account or business unit. This value ensures that filtering logic executes in the appropriate account context. |
| Client_ClientPartnerKey | Int | True |
Stores the partner-assigned client key that links this filter definition to an external integration or partner system. This value provides cross-system traceability when filtering logic originates outside Salesforce Marketing Cloud. |
| Name | String | False |
Provides the display name of the filter definition. This value identifies the definition in the user interface and in API responses. |
| CustomerKey | String | False |
Stores the user-supplied unique Id for the filter definition. This Id corresponds to the external key that is used to reference the definition in API calls and automated workflows. |
| CreatedDate | Datetime | False |
Indicates the date and time when the filter definition was created. This timestamp supports auditing and version control in segmentation workflows. |
| ModifiedDate | Datetime | False |
Indicates the most recent date and time when the filter definition was modified. This value helps track updates to filtering logic and assists with troubleshooting. |
| Description | String | False |
Provides a detailed explanation of the purpose, criteria, and expected use of the filter definition. This text supports documentation efforts and improves maintainability. |
| DataSource_ID | Int | True |
Specifies the read-only numeric Id that identifies the data source used by the filter definition. The data source determines where the filter criteria are applied. |
| DataSource_ObjectID | String | True |
Stores the system-controlled text string Id that uniquely identifies the data source that is associated with the filter definition. This Id ensures consistent reference across data views and segmentation processes. |
| DataSource_Name | Int | True |
Provides the name of the data source that supplies the records being filtered. This value identifies the origin of the data used in the filtering operation. |
| DataSource_ListName | Int | True |
Specifies the list name that is associated with the data source when the filter definition references a subscriber list. This value helps identify the audience segment being targeted. |
| DataSource_CustomerKey | String | True |
Stores the user-supplied unique Id for the data source. This Id corresponds to the external key used to reference the data source in API operations. |
| DataSource_CreatedDate | Datetime | True |
Indicates the date and time when the associated data source was created. This timestamp helps track data lineage and dependency timing. |
| DataSource_ModifiedDate | Datetime | True |
Indicates the most recent date and time when the associated data source was modified. This value supports auditing and consistency checking when filter logic relies on evolving data structures. |
| DataFilter | String | False |
Contains the defined filtering criteria expressed as one or more filter parts. These criteria determine how the system evaluates records from the underlying data source to produce a targeted segmentation output. |