JDBC Driver for Vault CRM

Build 25.0.9434

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.

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