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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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.

CData Python Connector for Zoho CRM