Power BI Connector for SugarCRM

Build 25.0.9454

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454