CampaignLog
Create, update, delete, and query logs related to SuiteCRM campaigns
Table Specific Information
Select
You can query the Campaign Log table using any criteria in the WHERE clause. The connector will use the SuiteCRM API to filter the results.
SELECT * FROM [Campaign Log] WHERE Campaign_Id = 'campaign1'
Insert
Create a Campaign Log by specifying any writable column.
INSERT INTO [Campaign Log] (Name, Campaign_Id) VALUES ('Test Log', 'Campaign2')
Update
You can update any Campaign Log column that is writable, by specifying the Id.
UPDATE [Campaign Log] SET Archived = true WHERE Id = 'Test123'
Delete
Delete a Campaign Log by specifying the Id.
DELETE FROM [Campaign Log] WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the record. |
| ActivityDate | Datetime | False |
The date the activity occurred. |
| ActivityType | String | False |
The activity that occurred (e.g., Viewed Message, Bounced, or Opted out). |
| Archived | Bool | False |
Indicates if the item has been archived. |
| campaign_content | String | True |
The campaign content. |
| campaign_id | String | False |
The identifier of the campaign associated with the campaign log. |
| campaign_name | String | True |
The name of the campaign associated with the campaign log. |
| campaign_objective | String | True |
The campaign objective. |
| DateModified | Datetime | False |
The date the campaign log was last modified. |
| Deleted | Bool | False |
Record deletion indicator. |
| Hits | Int | False |
Number of times the item has been invoked (e.g., multiple click throughs). |
| LBL_MARKETING_ID | String | False |
The Id of the marketing email this entry is associated with. |
| marketing_name | String | False |
The marketing name. |
| MoreInformation | String | False |
More information about the campaign log. |
| Name | String | True |
The name of the campaign associated with the campaign log. |
| ProspectListID | String | False |
The prospect list from which the item originated. |
| recipient_email | String | True |
The email of the recipient. |
| recipient_name | String | True |
The name of the recipient. |
| RelatedId | String | False |
The Id of the related record. |
| RelatedType | String | False |
The type of the related record. |
| TargetID | String | False |
The identifier of the target record. |
| TargetTrackerKey | String | False |
The identifier of the tracker URL. |
| TargetType | String | False |
The target record type (e.g., Contact or Lead). |
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 |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |