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. |