3 of 3 people found this helpful
Hey Phillip Wild
Many-to-many custom objects in Marketo are elegant in theory but of limited use in practice, because the second level CO is not accessible via velocity (the official docs are quite misleading on this point).
You are probably better creating a flat object (either in SFDC or Marketo) that connects the person to a list of eligible extras and contains the associated SKU ID of the product they have purchased.
You can use this object for segmentation (on SKU ID) then in sending your campaigns you can crunch this data in velocity.
The pre-processing work to create the flat object would need to be done in SFDC via apex or within a data integration tool.
Thanks a lot Justin. That's great background. I'll leave it alone
We run everything through Velocity these days so having it accessible there is key.