Campaigns
Tracks marketing campaigns, linking them to leads, contacts, and deals for measuring engagement and revenue impact.
Table-Specific Information
Select
This table supports COQL for filtering, meaning that most filters comparing columns to values are submitted server-side.
Insert
INSERT INTO Campaigns (CampaignName) VALUES ('a test campaign')
Required fields: CampaignName.
Any field which is not read-only (ReadOnly = false in the table below) can be inserted.
Delete
You must specify the Id in the WHERE clause when executing a delete against this table.
DELETE FROM Campaigns WHERE Id = '3152079000000485001'
Update
You must specify the Id in the WHERE clause when executing an update against this table.
UPDATE Campaigns SET CampaignName = 'Updated from API' WHERE Id = '3152079000000485001'
Required fields: Id.
Any field which is not read-only (ReadOnly = false in the table below) can be updated.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
Unique identifier for the campaign. |
| CampaignOwner_Id | String | False |
Identifier of the user who owns the campaign. |
| CampaignOwner_FirstName | String | True |
First name of the campaign owner. |
| CampaignOwner_LastName | String | True |
Last name of the campaign owner. |
| CampaignOwner_Email | String | True |
Email address of the campaign owner. |
| CampaignOwner_Name | String | True |
Full name of the campaign owner. |
| Type | String | False |
Type or category of the campaign, such as email, webinar, or advertisement. |
| CampaignName | String | False |
Name of the campaign. |
| Status | String | False |
Current status of the campaign, such as active or completed. |
| StartDate | Date | False |
Start date of the campaign. |
| EndDate | Date | False |
End date of the campaign. |
| ExpectedRevenue | Decimal | False |
Estimated revenue expected to be generated by the campaign. |
| BudgetedCost | Decimal | False |
Planned budget or cost allocated for the campaign. |
| ActualCost | Decimal | False |
Actual amount spent on the campaign. |
| ExpectedResponse | Long | False |
Projected number of responses the campaign is expected to receive. |
| Numberssent | Long | False |
Total number of messages or materials sent as part of the campaign. |
| CreatedBy_Id | String | False |
Identifier of the user who created the campaign record. |
| CreatedBy_FirstName | String | True |
First name of the user who created the campaign record. |
| CreatedBy_LastName | String | True |
Last name of the user who created the campaign record. |
| CreatedBy_Email | String | True |
Email address of the user who created the campaign record. |
| CreatedBy_Name | String | True |
Full name of the user who created the campaign record. |
| ModifiedBy_Id | String | False |
Identifier of the user who last modified the campaign record. |
| ModifiedBy_FirstName | String | True |
First name of the user who last modified the campaign record. |
| ModifiedBy_LastName | String | True |
Last name of the user who last modified the campaign record. |
| ModifiedBy_Email | String | True |
Email address of the user who last modified the campaign record. |
| ModifiedBy_Name | String | True |
Full name of the user who last modified the campaign record. |
| CreatedTime | Datetime | False |
Date and time when the campaign record was created. |
| ModifiedTime | Datetime | False |
Date and time when the campaign record was last updated. |
| Tag | String | False |
Tag associated with the campaign, used for categorization or filtering. |
| Description | String | False |
Textual description providing additional information about the campaign. |
| ParentCampaign_Id | String | False |
Identifier of the parent campaign if this campaign is part of a campaign hierarchy. |
| ParentCampaign_Name | String | True |
Name of the parent campaign. |
| LastActivityTime | Datetime | False |
Timestamp of the most recent activity related to the campaign. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| DuplicateCheckFields | String |
Field or fields used to detect duplicates during an upsert operation. The REST API supports multiple fields; the BULK API supports only one. |
| Trigger | String |
Flag to trigger automation rules during the insertion of the campaign record. |
| CustomViewId | Long |
Identifier of the custom view used to filter this record when the useCOQL parameter is set to false. |