3 Replies Latest reply on Mar 22, 2018 10:37 AM by Phillip Wild

    Marketo custom objects - many to many relationship

    Phillip Wild

      Hi brains trust

       

      I'm reading through these docs around Marketo Custom Objects: Understanding Marketo Custom Objects - Marketo Docs - Product Documentation

       

      Here's what I'm trying to do...we have a list of about 600 SKUs, and these sales are stored in Salesforce custom objects (which syncs through to Marketo). Each of these SKUs have associated "extras" that can be bought. This information will change every few weeks or so, and there might be 10 for a SKU, or zero.

       

      Would the right structure for using this in emails be:

       

      * Create a Marketo Custom Object called "extras". This would have a field called "SKU Code", along with any other fields I would want to use (eg. cost, description, active or not).

      * Create a Marketo Custom Object called "SKUs". This would have a field called "SKU Code", and one called "MarketoID". "SKU Code" would be the link field to the "extras" object. "MarketoID" would be the link field to Persons in Marketo. Both fields would be "dedupe" fields.

      * Populate.

      * Use email scripting to see if a person has bought a particular SKU, and if they have, show them possible extras they could buy.

       

      If the data doesn't change super often, then I could update that "extras" custom object every couple of weeks with minimal risk, right? I'd only want to show extras that are active, and that are on a SKU that a person has bought.

       

      Is all this possible? Is it the right way to be attacking this?