Question:

Why are Channel Interaction Goals or Product Interaction Goals Blank when Channel Activity Goals or Product Activity Goals are zero in Veeva CRM?

Answer:

According to the calculations by the MCCP MCE (Multichannel Engine) process, the Channel Interaction Goals or Product Interaction Goals on MC Cycle Plan Channel or MC Cycle Plan Product objects are calculated only when the value of Channel Activity Goals or Product Activity Goals is greater than 0, otherwise, it will return a NULL value, hence the Channel Interaction Goals or Product Interaction Goals fields are Blank.

0 as a value can be applied for Channel Activity Goals or Product Activity Goals in special cases and requirements. Leaving these fields as null/blank is considered a misconfiguration. The fields above are not calculated by MCCP MCE (Multichannel Engine) process.

The formula used for calculating Channel Interaction Goals on MC Cycle Plan Channel object:

If(
Channel_Activity_Goal_vod > 0,
Channel_Activity_Goal_vod x Cycle_Channel_vod__r.Channel_Weight_vod,
NULL
)

The formula used for calculating Product Interaction Goals on MC Cycle Plan Product object:

If(
Product_Activity_Goal_vod > 0,
Product_Activity_Goal_vod x Cycle_Channel_vod__r.Product_Weight_vod,
NULL
)

Related Documentation:

Knowledge Article: Which Goal Fields of the MCCP Related Objects Need to be Populated by Customer System Admins in Veeva CRM?