ProspectLists
Stores targeted prospect list definitions that are used for marketing outreach. This table supports segmentation, campaign targeting, and audience selection.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this prospect list. This value is used for access control, collaboration, and visibility filtering. |
| Acl_Team_Set_Id | String | False |
The identifier (Id) of the set of teams that have access to this prospect list. This value is used to manage shared permissions across multiple teams. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned to manage this prospect list. This value determines responsibility for list maintenance and campaign coordination. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to this prospect list. This value enhances readability in the user interface and reports. |
| Commentlog | String | True |
The comment log entries that are associated with this prospect list. This field stores notes, discussion history, or collaboration context. |
| Created_By | String | True |
The Id of the user who created this prospect list record. This value identifies the record author for auditing and ownership tracking. |
| Created_By_Name | String | True |
The display name of the user who created this prospect list record. This value is shown in the user interface for clarity and review. |
| Date_Entered | Datetime | True |
The date and time when this prospect list record was created. This value provides context for list lifecycle management and historical review. |
| Date_Modified | Datetime | True |
The date and time when this prospect list record was most recently updated. This field supports change tracking and audit visibility. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this prospect list record is marked as deleted. It returns a value of 'false' when the record remains active and available for use. |
| Description | String | False |
A detailed description of the prospect list. This field can include audience criteria, campaign usage notes, segmentation guidance, or business context. |
| Domain_Name | String | False |
The domain that is associated with this prospect list, when the list is configured to group contacts or leads by email domain. This value supports segmentation and outbound targeting. |
| Entry_Count | Int | True |
The total number of members that are currently included in this prospect list. This value helps measure audience size for targeting and campaign planning. |
| Id [KEY] | String | True |
The unique Id for this prospect list record. This value is used to reference the list across marketing campaigns, reporting, and related modules. |
| List_Type | String | False |
The classification of this prospect list, such as default, test, suppression, or marketing. This value determines how the list is used within marketing workflows. |
| Marketing_Id | String | False |
The Id of the marketing campaign that is associated with this prospect list. This value establishes the link between the list and campaign execution activities. |
| Marketing_Name | String | False |
The display name of the marketing campaign that is associated with this prospect list. This field supports readability and reporting. |
| Modified_By_Name | String | True |
The display name of the user who most recently modified this prospect list record. This value provides transparency into list maintenance activity. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this prospect list record. This field identifies the source of recent changes. |
| Name | String | False |
The name of the prospect list. This value is used as the primary label throughout the system when selecting, managing, or reporting on the list. |
| Tag | String | False |
The tags that are associated with this prospect list. Tags allow for flexible grouping, categorization, and search filtering across marketing and CRM modules. |
| Team_Count | String | False |
The number of teams that are associated with this prospect list. This value indicates the scale of collaboration and access distribution. |
| Team_Id | String | False |
The Id of the primary team responsible for this prospect list. This value establishes core ownership for permissions and visibility. |
| Team_Name | String | False |
The display name of the primary team that is associated with this prospect list. This value is shown in the user interface and reports for clarity. |
| Team_Set_Id | String | False |
The Id of the set of teams that share access to this prospect list. This value supports multi-team collaboration and permission configuration. |