Creating a new table in the data model for product interest

[Robb_Barrett]

Hi there -

Going through a bit of a challenge here and looking for some help.  It doesn't look like we can add new tables to the data model, or can we?  

We have a LOT of different products in which a person may have multiple interests.  I'd like to build a table with a 1:n relationship to the Lead table.  The new table would have product name and scoring fields.  This would allow me to have a very scalable data model where I can score each product individually and I wouldn't need to clutter my lead table with multiple fields for each products.

I know other Marketing Automation products can do this easily but I don't know how to do this in Marketo.  Does anyone have experience doing this?

[Anonymous]

http://developers.marketo.com/documentation/getting-started/

Custom object tables can be created in Marketo but need to be done so through a service request as the creation of the table and it's field is done by a member of the MArketo services team. You would then need to update the custom object via the API

[Josh_Hill13]

Are you considering adding this to the CRM first? You can also do this and work with Marketo to activate it.

See SFDC Custom Object Sync. If you need to write to it, then go with Cathal's suggestion.

[Robb_Barrett]

This would be pre-SFDC.  We're using SFDC for marketing and sales qualified leads and Marketo for our higher-funnel leads.

I'd like to create a dimensionalized table for product interest and scoring. This would allow a 1:n relationship between leads and product insterests and scores.

Thoughts: 

1. We create temp storage fields for responses.
2. We have a campaign listening for those fields to get populated.
3. The values are written to the new table: LeadID, ProductID, FieldA, FieldB, FieldC (etc).
4. Values are wiped from the temp fields.

Now I need to segment by my new table.  If I have a lead that's qualified for ProductA, send that to sales. If he's not yet qualified for ProductB then put him in Nurture for ProductB and turn ProductA into an opportunity. As he qualifies for B then send him into SFDC.