Re: Creating a new table in the data model for product interest

Robb_Barrett
Marketo Employee

Creating a new table in the data model for product interest

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?
Robb Barrett
Tags (1)
3 REPLIES 3
Anonymous
Not applicable

Re: Creating a new table in the data model for product interest

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
Level 10 - Champion Alumni

Re: Creating a new table in the data model for product interest

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
Marketo Employee

Re: Creating a new table in the data model for product interest

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.
 
Robb Barrett