JDBC Driver for Vault CRM

Build 25.0.9434

MCCyclePlanProducts

Associates specific products with a multichannel cycle plan for targeting and tracking.

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 product in the system.

MC Cycle Plan Product Type String True

The classification or type of the marketing communication (MC) cycle plan product, specifying the category or nature of the product involved in the cycle.

Global ID String True

A globally unique identifier used for the consistent identification of the cycle plan product across various systems and platforms.

Link String False

A URL or hyperlink associated with the cycle plan product, providing direct access to additional details or resources related to the product.

Cycle Plan Product String True

The name of the cycle plan product, used to identify and reference the specific product involved in the marketing cycle plan.

Status String False

The current status of the cycle plan product, indicating whether the product 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 product record, providing traceability for record creation.

Created Date Datetime True

The timestamp when the cycle plan product 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 product record, ensuring accountability for changes.

Last Modified Date Datetime True

The timestamp of the most recent modification made to the cycle plan product record, reflecting the latest update to the data.

Activity Goal Edit Decimal False

The updated or adjusted activity goal for the cycle plan product, reflecting any changes made to the originally set target or objective.

Detail Priority Decimal False

The priority level assigned to the product in the cycle plan, determining the product's importance or order of focus during the campaign.

External ID String False

An identifier from an external system that is used to reference the cycle plan product, facilitating cross-system data integration.

Product Last Activity Date Date False

The date of the most recent activity related to the product in the cycle plan, providing insights into when the product was last engaged.

Product Last Activity Datetime Datetime False

The exact timestamp of the most recent activity related to the product in the cycle plan, providing precise tracking of the product's engagement.

Last Calculated Datetime False

The timestamp when the cycle plan product 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 product to a master alignment record, ensuring consistency across related marketing efforts.

Product Activity Goal Decimal False

The target activity goal set for the cycle plan product, used to measure how much activity is required to achieve the product's objectives.

Product Activity Max Decimal False

The maximum allowable or expected activity for the cycle plan product, setting an upper limit for the activity goal.

Product Activity Remaining Decimal False

The remaining amount of activity required to meet the set goal or target for the product in the cycle plan.

Product Activity Actual Decimal False

The actual amount of activity carried out for the product in the cycle plan, providing a real-time measurement of progress.

Product Attainment Double False

The percentage of the activity goal achieved for the cycle plan product, calculated by comparing actual activity with the set goal.

Product Interactions Actual Double False

The actual number of interactions (for example, clicks or responses) that have occurred for the product in the cycle plan, representing user engagement.

Product Interactions Earned Double False

The number of interactions earned through the cycle plan product, indicating how well the product met its interaction objectives.

Product Interactions Goal Double False

The target number of interactions set for the product in the cycle plan, used to evaluate its effectiveness in reaching users.

Product Status String False

The status of the cycle plan product, indicating whether it is active, inactive, or in another phase of the campaign.

Team Activity Goal Edit Decimal False

The updated activity goal set for the team managing the cycle plan product, reflecting any changes made to the original targets.

Team Product Last Activity Date Date False

The date of the most recent activity performed by the team for the product within the cycle plan, showing the latest team engagement.

Team Product Last Activity Datetime Datetime False

The exact timestamp of the most recent activity by the team for the product in the cycle plan, providing precise tracking.

Team Product Activity Goal Decimal False

The target activity goal set for the team, used to measure how much activity the team needs to complete for the product in the cycle plan.

Team Product Activity Max Decimal False

The maximum allowable or expected activity for the team regarding the product in the cycle plan, setting a limit for team performance.

Team Product Activity Remaining Decimal False

The remaining activity required for the team to reach the target set for the product in the cycle plan.

Team Product Actual Activity Decimal False

The actual amount of activity performed by the team for the product in the cycle plan, representing the team's performance.

Team Product Attainment Double False

The percentage of the team's activity goal achieved within the cycle plan product, indicating the team's progress towards its objectives.

Team Product Interactions Actual Double False

The actual number of interactions achieved by the team for the product in the cycle plan, reflecting the team's ability to engage users.

Team Product Interactions Earned Double False

The number of interactions earned by the team for the product in the cycle plan, showing how well the team met interaction objectives.

Team Product Interactions Goal Double False

The target number of interactions set for the team for the product in the cycle plan, used to evaluate team performance.

Team Product Status String False

The status of the product managed by the team in the cycle plan, indicating whether the product is active, inactive, or experiencing issues.

Veeva External ID String False

A unique identifier used in the Veeva Vault system to reference this cycle plan product, enabling integration with Veeva-related platforms.

Channel String True

The specific communication or marketing channel used for the cycle plan product, such as email, digital advertising, or other outreach methods.

Cycle Plan String True

The overall cycle plan to which this product belongs, representing the entire strategy or campaign being implemented.

Detail Group String True

The group or category to which the cycle plan product belongs, used to organize and categorize different products within the marketing cycle.

Product String True

The specific product involved in the cycle plan, representing the product being marketed and tracked within the cycle.

Controlling MC Cycle Plan String False

The identifier for the controlling the MC cycle plan to which this product belongs, ensuring alignment with the broader MC strategy.

Cycle Plan Target String False

The target goal or audience for the cycle plan product, defining the objectives or the group intended to be impacted by the cycle plan activities.

Cycle Plan Channel String False

The specific marketing channel used for the cycle plan product, representing the method or medium through which the campaign is executed.

Legacy CRM Id String False

An identifier from the legacy CRM system that is used to reference this cycle plan product, ensuring compatibility and data consistency during migration or integration.

Controlling MC Cycle String False

The identifier for the controlling the MC cycle to which this product belongs, ensuring that the cycle aligns with the broader strategy.

Controlling MC Cycle Channel String False

The identifier for the controlling the MC cycle channel associated with this product, ensuring synchronization of marketing efforts across different channels.

Cycle Product String False

The specific product involved in the cycle, representing the item or service being marketed within the cycle plan.

Product Last Activity Date2 Date False

The second recorded date for the last activity related to the product in the cycle plan, providing an additional tracking point for product engagement.

Team Product Last Activity Date2 Date False

The second recorded date for the last activity performed by the team for the product in the cycle plan, offering an additional tracking reference for team performance.

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