CampaignLog
Stores activity and response tracking data for marketing campaigns. This table supports performance attribution and engagement effectiveness analysis.
Columns
| Name | Type | ReadOnly | Description |
| Activity_Date | Datetime | False |
The date and time when the campaign-related activity occurs. This field supports chronological analysis of engagement behavior. |
| Activity_Type | String | False |
The type of campaign activity that occurs (for example, 'Viewed', 'Message', 'Bounced', or 'Opted Out'). This field classifies recipient behavior and supports campaign performance reporting. |
| Archived | Bool | False |
A Boolean field that returns a value of 'true' when the campaign log entry is archived. It returns a value of 'false' when the entry remains active. This field assists with long-term record retention and cleanup. |
| Campaign_Content | String | False |
The content or asset that is associated with the campaign activity, such as an email body or linked resource. This field supports review and content performance analysis. |
| Campaign_Id | String | False |
The unique identifier (Id) of the campaign that is associated with this log entry. This field links each activity event to a specific campaign. |
| Campaign_Name | String | False |
The display name of the campaign that is associated with this activity. This field provides a readable reference for the campaign_id field. |
| Campaign_Name1 | String | True |
An alternate or supplemental campaign name that is used for display, grouping, or reporting purposes. This field can support translations or localized naming conventions. |
| Campaign_Objective | String | False |
The stated goal or objective of the campaign. This field helps users evaluate campaign performance against intended outcomes. |
| Date_Modified | Datetime | True |
The date and time when this campaign log record was most recently modified. This field enables users to track update activity. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the campaign log record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and recovery. |
| Hits | Int | True |
The number of times the campaign action is triggered for this recipient, such as for multiple email openings or repeated click-throughs. This field supports engagement-level scoring and trend evaluation. |
| Id [KEY] | String | True |
The Id for this campaign log record. This field ensures that the record can be referenced reliably across reporting and analytics processes. |
| List_Id | String | False |
The Id of the target list from which the recipient originates. This field links the campaign activity to list segmentation strategy. |
| Marketing_Id | String | False |
The Id of the specific marketing email or outreach asset that triggers this log entry. This field ties activity data to messaging performance. |
| Marketing_Name | String | False |
The display name of the marketing asset that is associated with this activity, such as the name of an email template. This field provides a readable reference for the marketing_id field. |
| More_Information | String | False |
Additional context or explanatory details about the campaign activity. This field supports troubleshooting, auditing, and behavioral interpretation. |
| Recipient_Email | String | False |
The email address of the campaign recipient who performs or triggers the logged activity. This field supports outreach tracking and recipient identification. |
| Recipient_Name | String | True |
The name of the campaign recipient that is associated with this activity. This field provides a readable reference for recipient identity in dashboards and analytics. |
| Related_Id | String | False |
The Id of the record (for example, 'Contact' or 'Lead') that is linked to the campaign activity. This field enables relationship-based engagement reporting. |
| Related_Name | String | True |
The display name of the related record that is associated with this activity. This field provides a readable reference for the Related_Id field. |
| Related_Type | String | False |
The module or record type that the activity is related to (for example, 'Contact', 'Lead', or 'Account'). This field contextualizes the engagement interaction. |
| Target_Id | String | False |
The Id of the target record that receives the campaign outreach. This field links the activity to an individual prospect or customer. |
| Target_Tracker_Key | String | False |
The unique key that is associated with a tracked link or campaign tracking URL. This field enables click-through tracking and conversion measurement. |
| Target_Type | String | False |
The type of target record (for example, 'Contact' or 'Lead') that is associated with this campaign activity. This field supports segmentation and engagement reporting. |