Campaigns
The Campaigns table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Name | String | False |
The name of the campaign |
| Date_Entered | Datetime | True |
Date record created |
| Date_Modified | Datetime | True |
Date record last modified |
| Modified_User_Id | String | True |
User who last modified record |
| Modified_By_Name | String | True | |
| Created_By | String | True |
User who created record |
| Created_By_Name | String | True | |
| Description | String | True |
inhertied but not used |
| Deleted | Bool | False |
Record deletion indicator |
| 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_Count | Int | True |
The number of accesses made to the tracker URL; 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) |
| Start_Date | Date | False |
Starting date of the campaign |
| End_Date | Date | False |
Ending date of the campaign |
| Status | String | False |
Status of the campaign |
| Impressions | Int | True |
Expected Click throughs manually entered by Campaign Manager |
| Budget | Decimal | True |
Budgeted amount for the campaign |
| Expected_Cost | Decimal | True |
Expected cost of the campaign |
| Actual_Cost | Decimal | True |
Actual cost of the campaign |
| Expected_Revenue | Decimal | True |
Expected revenue stemming from the campaign |
| Campaign_Type | String | False |
The type of campaign |
| Objective | String | False |
The objective of the campaign |
| Content | String | False |
The campaign description |
| Frequency | String | False |
Frequency of the campaign |
| Following | Bool | False |
Is user following this record |
| My_Favorite | Bool | False |
Favorite for the user |
| Commentlog | String | True | |
| Locked_Fields | String | True | |
| Sync_Key | String | True | |
| Assigned_User_Id | String | False |
User ID assigned to record |
| Assigned_User_Name | String | True | |
| Team_Id | String | False |
Team ID for the account |
| Team_Set_Id | String | False | |
| Acl_Team_Set_Id | String | False | |
| Team_Count | String | False | |
| Team_Name | String | False | |
| Acl_Team_Names | String | True | |
| Currency_Id | String | False | |
| Base_Rate | String | False | |
| Currency_Name | String | True | |
| Currency_Symbol | String | True |