Skip to main content
Robb_Barrett
Robb_Barrett
Level 10
December 1, 2014
Question

Creating a new table in the data model for product interest

  • December 1, 2014
  • 3 replies
  • 2409 views
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?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

A
Anonymous
December 1, 2014
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
Josh_Hill13
Level 10
December 1, 2014
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
Robb_BarrettAuthor
Level 10
December 3, 2014
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
Terms & ConditionsAccessibility statement

Loading footer...