Campaigns
Create, update, delete, and query the SuiteCRM project's campaigns
テーブル固有の情報
Select
WHERE 句で任意の条件を使用して、Campaigns テーブルをクエリできます。本製品 はSuiteCRM API を使用して結果をフィルタリングします。
SELECT * FROM Campaigns WHERE Name = 'campaign name'
Insert
書き込み可能なカラムを指定して、Campaign を作成します。
INSERT INTO Campaigns (Id, Name) VALUES ('id', 'Energy')
Update
Id を指定して、書き込み可能なCampaign カラムを更新できます。
UPDATE Campaigns SET Budget = 30000 WHERE Id = 'Test123'
Delete
Id を指定して、Campaign を削除します。
DELETE FROM Campaigns WHERE Id = '10003'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
The unique identifier of the campaign. |
Name | String | False |
The name of the campaign. |
DateEntered | Datetime | False |
The date the record was created. |
DateModified | Datetime | False |
The date the record was last modified. |
ModifiedUserId | String | False |
The Id of the user who last modified the record. |
ModifiedByName | String | True |
The name of the user who last modified the record. |
CreatedBy | String | False |
The Id of the user who created the record. |
CreatedByName | String | True |
The name of the user who created the record. |
Description | String | False |
The description for the campaign. |
Deleted | Bool | False |
The record deletion indicator. |
CreatedByLink | String | True |
Link to the record who created it |
ModifiedUserLink | String | True |
Link to the record who modified it. |
AssignedUserId | String | False |
The Id of the user assigned to the record. |
AssignedUserName | String | True |
The user name of the user assigned to the record. |
AssignedUserLink | String | True |
Link to the user which the record has been assigned to |
SecurityGroups | String | True |
The security group associated with the record. |
TrackerKey | String | False |
|
TrackerCount | String | False |
The number of accesses made to the tracker URL; no longer used as of 4.2. (See CampaignTrackers.) |
ReferUrl | String | False |
|
TrackerText | String | False |
|
StartDate | String | False |
Starting date of the campaign. |
EndDate | String | False |
Ending date of the campaign. |
Status | String | False |
The status of the record. |
Impressions | String | False |
Expected click throughs manually entered by the campaign manager. |
CurrencyId | String | False |
|
Budget | String | False |
Budgeted amount for the campaign. |
ExpectedCost | String | False |
Expected cost of the campaign. |
ActualCost | String | False |
Actual cost of the campaign. |
ExpectedRevenue | String | False |
Expected revenue stemming from the campaign. |
CampaignType | String | False |
|
Objective | String | False |
The objective of the campaign. |
Content | String | False |
The campaign description. |
Prospectlists | String | True |
|
Emailmarketing | String | True |
|
Queueitems | String | True |
|
LogEntries | String | True |
|
TrackedUrls | String | True |
|
Frequency | String | False |
Frequency of the campaign. |
Leads | String | True |
The leads associated with the record. |
Opportunities | String | True |
The opportunities associated with the record. |
Contacts | String | True |
The contacts associated with the record |
Accounts | String | True |
The accounts associated with the record |
Survey | String | True |
|
SurveyName | String | True |
|
SurveyId | String | False |
|
SurveyresponsesCampaigns | String | True |
|