MCCyclePlanChannels
Represents the linkage between multichannel cycle plans and communication channels.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
A unique identifier for the record, which serves as the primary key to reference this cycle plan channel in the system. |
| MC Cycle Plan Channel Type | String | True |
The classification or type of the marketing communication (MC) cycle plan channel, specifying the category or nature of the channel used in the marketing cycle. |
| Global ID | String | True |
A globally unique identifier used for the consistent identification of the cycle plan channel across various systems and platforms. |
| Link | String | False |
A URL or hyperlink associated with the cycle plan channel, which provides direct access to additional details or resources related to the channel. |
| Cycle Plan Channel | String | True |
The name of the cycle plan channel, used to identify and reference the specific channel in the cycle plan, such as a digital channel or direct mail. |
| Status | String | False |
The current status of the cycle plan channel, indicating whether the channel is active, inactive, or in another phase of its lifecycle. |
| Created By | String | True |
The identifier or name of the individual or system that created the cycle plan channel record, providing traceability for record creation. |
| Created Date | Datetime | True |
The timestamp when the cycle plan channel record was created, allowing users to track the lifecycle and age of the record. |
| Last Modified By | String | True |
The identifier or name of the individual who last modified or updated the cycle plan channel record, ensuring accountability for changes. |
| Last Modified Date | Datetime | True |
The timestamp of the most recent modification made to the cycle plan channel record, reflecting the latest update to the data. |
| Activity Goal Edit | Decimal | False |
The updated or adjusted activity goal for the cycle plan channel, reflecting any changes made to the originally set target or objective. |
| Channel Activity Actual | Decimal | False |
The actual amount of activity carried out within the cycle plan channel, providing a real-time measurement of performance. |
| Channel Activity Goal | Decimal | False |
The target or goal set for the amount of activity to be carried out within the cycle plan channel, used for performance comparison. |
| Channel Activity Max | Decimal | False |
The maximum allowable or expected activity for the channel, setting an upper limit for the activity target. |
| Channel Activity Remaining | Decimal | False |
The remaining amount of activity required to meet the set goal or target for the cycle plan channel. |
| Channel Attainment | Double | False |
The percentage of the goal achieved for the channel activity, calculated by comparing actual activity with the set goal. |
| Channel Interactions Actual | Double | False |
The actual number of interactions (for example, clicks or responses) occurring within the cycle plan channel, representing user engagement. |
| Channel Interactions Earned | Double | False |
The number of interactions earned through the cycle plan channel, indicating how well the channel met its interaction objectives. |
| Channel Interactions Goal | Double | False |
The target number of interactions set for the cycle plan channel, used to evaluate the effectiveness of the channel's reach. |
| Channel Status | String | False |
The operational status of the cycle plan channel, indicating whether the channel is running smoothly, paused, or has issues. |
| External ID | String | False |
An identifier from an external system that is used to reference the cycle plan channel, facilitating cross-system data integration. |
| Channel Last Activity Date | Date | False |
The date of the most recent activity within the cycle plan channel, providing insights into when the channel was last active. |
| Channel Last Activity Datetime | Datetime | False |
The exact timestamp of the most recent activity within the cycle plan channel, providing precise tracking of the channel's activity. |
| Last Calculated | Datetime | False |
The timestamp when the cycle plan channel data was last calculated or updated, providing a reference for when performance metrics were last reviewed. |
| Master Align Id | String | False |
The identifier linking this cycle plan channel to a master alignment record, ensuring consistency across related marketing efforts. |
| Product Attainment | Double | False |
The percentage of the product-related goal achieved within the cycle plan channel, used to track product-specific objectives. |
| Product Interactions Earned | Double | False |
The number of product-related interactions earned through the cycle plan channel, indicating the success of product-specific goals. |
| Product Interactions Goal | Double | False |
The target number of product-related interactions set for the cycle plan channel, used to assess product engagement effectiveness. |
| Product Status | String | False |
The status of the product within the cycle plan channel, indicating whether it is active, inactive, or in another phase of the marketing cycle. |
| Team Activity Goal Edit | Decimal | False |
The updated activity goal set for the team managing the cycle plan channel, reflecting any changes made to the original targets. |
| Team Channel Activity Actual | Decimal | False |
The actual amount of activity carried out by the team within the cycle plan channel, representing the team's performance. |
| Team Channel Activity Goal | Decimal | False |
The target activity goal set for the team, used to measure how well the team is performing within the cycle plan channel. |
| Team Channel Activity Max | Decimal | False |
The maximum allowable or expected activity for the team within the cycle plan channel, setting a limit for team performance. |
| Team Channel Activity Remaining | Decimal | False |
The remaining activity required for the team to reach the target set for the cycle plan channel. |
| Team Channel Attainment | Double | False |
The percentage of the team's activity goal achieved within the cycle plan channel, indicating the team's progress towards its objectives. |
| Team Channel Interactions Actual | Double | False |
The actual number of interactions achieved by the team within the cycle plan channel, reflecting the team's ability to engage users. |
| Team Channel Interactions Earned | Double | False |
The number of interactions earned by the team within the cycle plan channel, showing how well the team met interaction objectives. |
| Team Channel Interactions Goal | Double | False |
The target number of interactions set for the team within the cycle plan channel, used to evaluate the team's success in engaging users. |
| Team Channel Status | String | False |
The status of the team within the cycle plan channel, indicating whether the team is active, inactive, or experiencing challenges. |
| Team Channel Last Activity Date | Date | False |
The date of the most recent activity performed by the team within the cycle plan channel, indicating when the team last engaged with the channel. |
| Team Channel Last Activity Datetime | Datetime | False |
The exact timestamp of the most recent activity by the team within the cycle plan channel, providing precise tracking. |
| Team Product Attainment | Double | False |
The percentage of the product-related goal achieved by the team within the cycle plan channel, reflecting the team's product-specific success. |
| Team Product Interactions Earned | Double | False |
The number of product-related interactions earned by the team within the cycle plan channel, indicating the team's product engagement. |
| Team Product Interactions Goal | Double | False |
The target number of product-related interactions set for the team, used to evaluate the team's effectiveness in promoting the product. |
| Team Product Status | String | False |
The status of the product managed by the team within the cycle plan channel, showing whether the product is active or in another state. |
| Veeva External ID | String | False |
A unique identifier used in the Veeva Vault system to reference this cycle plan channel, enabling integration with Veeva-related platforms. |
| Controlling MC Cycle | String | False |
The identifier for the controlling marketing communication cycle to which this channel belongs, ensuring alignment with the broader MC strategy. |
| Cycle Channel | String | False |
The specific marketing cycle channel used in the cycle plan, representing the method or medium through which the campaign is executed. |
| Cycle Plan Target | String | False |
The target goal or audience for the cycle plan, defining the objectives or the group intended to be impacted by the cycle plan activities. |
| Channel | String | True |
The specific communication or marketing channel used for the cycle plan, such as email, digital advertising, or other outreach methods. |
| Cycle Plan | String | True |
The overall cycle plan to which this channel belongs, representing the entire strategy or campaign being implemented. |
| Legacy CRM Id | String | False |
An identifier used in the legacy CRM system to reference this cycle plan channel, ensuring compatibility and data consistency during migration or integration. |
| MC Cycle Plan | String | True |
The identifier for the marketing communication (MC) cycle plan to which this cycle plan channel belongs, linking it to the broader MC strategy. |
| Channel Last Activity Date2 | Date | False |
The second recorded date for the last activity in the cycle plan channel, used for tracking purposes in different stages or variations. |
| Team Channel Last Activity Date2 | Date | False |
The second recorded date for the last activity performed by the team within the cycle plan channel, providing an additional tracking point. |