CData Power BI Connector for SugarCRM 2019 - Online Help
Questions / Feedback?

Campaigns

CData Power BI Connector for SugarCRM 2019 - Build 19.0.7354

Create, update, delete, and query the Campaigns module in SugarCRM.

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the Campaign is the favorite for the user.

Following Bool False

Whether the user is following this record.

Id [KEY] String False

The unique identifier of the campaign.

Name String False

The name of the campaign.

Date_Entered Datetime True

The date the record was created.

Date_Modified Datetime True

The date record was last modified.

Modified_User_Id String True

The Id of the user who last modified the record.

Modified_By_Name String True

The user name of the user who last modified the record.

Created_By String True

The Id of the user who created the record.

Created_By_Name String True

The user name of the user who last created the record.

Doc_Owner String False

The document owner.

User_Favorites String False

The user favorites for the campaign.

Description String False

The description for the campaign.

Deleted Bool False

Record deletion indicator.

Assigned_User_Id String False

The user Id assigned to the record.

Assigned_User_Name String False

The name of the user assigned to the record.

Team_Id String False

The Id of the primary team.

Team_Set_Id String False

The Id of the team set.

Team_Count String False

The count of the team set.

Team_Name String False

The name of the primary team.

Tracker_Key Int True

The internal Id of the tracker used in a campaign. 2. (See CampaignTrackers.)

Tracker_Count Int False

The number of accesses made to the tracker URL; no longer used as of 4.2. (See CampaignTrackers.)

Refer_Url String False

The URL referenced in the tracker URL. No longer used as of 4.2. (See CampaignTrackers.)

Tracker_Text String False

The text that appears in the tracker URL. No longer used as of 4.2. (See CampaignTrackers.)

Start_Date Datetime False

Starting date of the campaign.

End_Date Datetime False

Ending date of the campaign.

Status String False

Status of the campaign.

Impressions Int False

Expected click throughs manually entered by the campaign manager.

Currency_Id String False

Currency in use for the campaign.

Base_Rate Decimal False

The base rate for the campaign.

Budget Double False

Budgeted amount for the campaign.

Expected_Cost Double False

Expected cost of the campaign.

Actual_Cost Double False

Actual cost of the campaign.

Expected_Revenue Double False

Expected revenue stemming from the campaign.

Campaign_Type String False

The type of the campaign.

Objective String False

The objective of the campaign.

Content String False

The campaign description.

Frequency String False

Frequency of the campaign.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0