Campaigns
Stores marketing campaign configuration, scheduling, and targeting details. This table supports planning, execution, and performance evaluation across campaign channels.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this campaign record. Each name identifies a team with access permissions for viewing or managing the campaign. |
| Acl_Team_Set_Id | String | False |
The unique identifier (Id) of the team set that defines access to this campaign. The team set determines which users and groups can view or modify the campaign. |
| Actual_Cost | Decimal | True |
The total actual cost that is incurred while running the campaign. This field supports cost-to-performance evaluation and budgeting analysis. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned to manage or oversee this campaign. This field supports ownership, accountability, and workflow routing. |
| Assigned_User_Name | String | True |
The name of the user who is assigned to this campaign. This field provides a readable reference for the assigned_user_id field. |
| Base_Rate | String | False |
The base exchange rate that is used when converting campaign-related financial values. This field supports multi-currency reporting. |
| Budget | Decimal | True |
The budgeted amount allocated for the campaign. This field is used for financial planning and cost comparison. |
| Campaign_Type | String | False |
The classification of the campaign, such as Email, Webinar, or Advertisement. This field supports segmentation and campaign strategy reporting. |
| Commentlog | String | True |
The list of comments that are associated with this campaign. This field supports collaboration and historical note keeping. |
| Content | String | False |
The descriptive content or narrative message for the campaign. This field provides context for campaign goals and messaging intent. |
| Created_By | String | True |
The unique Id of the user who created this campaign record. This field supports audit tracking and origin documentation. |
| Created_By_Name | String | True |
The name of the user who created this campaign record. This field provides a readable reference for the Created_By field. |
| Currency_Id | String | False |
The Id of the currency that is associated with campaign financial values. This field supports multi-currency budgeting and reporting. |
| Currency_Name | String | True |
The name of the currency that is used for campaign financial values. This field provides a readable reference for the Currency_Id field. |
| Currency_Symbol | String | True |
The symbol of the currency used for representing financial amounts in this campaign. This field supports UI display formatting and clarity. |
| Date_Entered | Datetime | True |
The date and time when this campaign record was created in the system. This field supports lifecycle auditing and temporal reporting. |
| Date_Modified | Datetime | True |
The date and time when this campaign record was most recently modified. This field supports update tracking and change auditing. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the campaign record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and record recovery. |
| Description | String | True |
A descriptive text field that is inherited from parent structures but not actively used. This field remains available for legacy compatibility. |
| End_Date | Date | False |
The date when the campaign is scheduled to end. This field is used for planning and activity timeline coordination. |
| Expected_Cost | Decimal | True |
The projected cost of running the campaign. This field supports pre-campaign budgeting and financial forecasting. |
| Expected_Revenue | Decimal | True |
The projected revenue that is anticipated as a result of the campaign. This field supports return-on-investment planning and performance evaluation. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this campaign record to receive updates. It returns a value of 'false' when the user is not subscribed. |
| Frequency | String | False |
The frequency or repetition interval for campaign execution. This field is used for scheduling recurring or multi-phase campaigns. |
| Id [KEY] | String | True |
The Id for this campaign record. This field ensures that the campaign can be referenced reliably across modules and integrations. |
| Impressions | Int | True |
The expected number of message views or click-through engagements that are manually entered by the campaign manager. This field supports audience reach prediction. |
| Locked_Fields | String | True |
The list of fields that are locked from modification for this campaign record. This field helps preserve data integrity after approval or publishing. |
| Modified_By_Name | String | True |
The name of the user who most recently modified this campaign record. This field provides a readable reference for the modified_user_id field. |
| Modified_User_Id | String | True |
The Id of the user who most recently modified this campaign record. This field supports audit tracking and ownership transparency. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the current user marks this campaign record as a favorite. It returns a value of 'false' when the record is not marked as a favorite. |
| Name | String | False |
The display name of the campaign. This field is used for campaign identification in dashboards, analytics, and selection lists. |
| Objective | String | False |
The primary goal or intended business outcome of the campaign. This field helps stakeholders evaluate performance against purpose. |
| Start_Date | Date | False |
The date when the campaign is scheduled to begin. This field supports planning, execution timing, and timeline reporting. |
| Status | String | False |
The current state of the campaign (for example, 'Planning', 'In Progress', or 'Completed'). This field supports workflow tracking and operational alignment. |
| Sync_Key | String | True |
The synchronization key that links this campaign record to external systems or data integrations. This field supports cross-system consistency. |
| Team_Count | String | False |
The number of teams that have access to this campaign record. This field supports access control and collaboration visibility. |
| Team_Id | String | False |
The Id of the primary team that is associated with this campaign. This field determines default access and ownership alignment. |
| Team_Name | String | False |
The name of the primary team that is associated with this campaign record. This field provides a readable reference for the Team_Id field. |
| Team_Set_Id | String | False |
The Id of the team set that defines combined team access for this campaign. This field enables shared work environments across multiple teams. |