SSIS Components for SugarCRM

Build 24.0.8963

Campaigns

The Campaigns table.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

Acl_Team_Set_Id String False

Actual_Cost Decimal True

Actual cost of the campaign

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Base_Rate String False

Budget Decimal True

Budgeted amount for the campaign

Campaign_Type String False

The type of campaign

Commentlog String True

Content String False

The campaign description

Created_By String True

User who created record

Created_By_Name String True

Currency_Id String False

Currency_Name String True

Currency_Symbol String True

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Deleted Bool False

Record deletion indicator

Description String True

inhertied but not used

End_Date Date False

Ending date of the campaign

Expected_Cost Decimal True

Expected cost of the campaign

Expected_Revenue Decimal True

Expected revenue stemming from the campaign

Following Bool False

Is user following this record

Frequency String False

Frequency of the campaign

Id [KEY] String True

Unique identifier

Impressions Int True

Expected Click throughs manually entered by Campaign Manager

Locked_Fields String True

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String False

The name of the campaign

Objective String False

The objective of the campaign

Start_Date Date False

Starting date of the campaign

Status String False

Status of the campaign

Sync_Key String True

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Tracker_Count Int True

The number of accesses made to the tracker URL; no longer used as of 4.2 (see campaign_trkrs)

Tracker_Key Int False

The internal ID of the tracker used in a campaign; no longer used as of 4.2 (see campaign_trkrs)

Tracker_Text String False

The text that appears in the tracker URL; no longer used as of 4.2 (see campaign_trkrs)

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963