Power BI Connector for SugarCRM

Build 25.0.9454

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454