Is there a field in I_MKT_LEADOPPSCUBE view that represents status of the opportunity

[kirthana]

Hi,

I am trying to enhance the lead and opportunity reporting currently in our SMC system. I am utilizing the I_MKT_LEADSOPPSCUBE CDS. I am unable to find a field that represents the status of the opportunity (like lost or won, the ones we see in SalesCloud)

IS there any field I can consume for this very purpose?

Thanks,

Kirthana

[former_member226]

Hi,

It is not directly exposed in the mentioned CDS view...You need to create a new custom CDS view based on I_MKT_InteractionCube / I_Mkt_Interaction and then include InteractionSourceObjectStatus field to your custom CDS view...This shoud then reflect the status value from Sales Cloud to SMC(if mapped in middleware correctly)