How can I identify the fields that are in each of the core entities of the marketo database? | Community
Skip to main content
A
Anonymous
May 18, 2015
Question

How can I identify the fields that are in each of the core entities of the marketo database?

  • May 18, 2015
  • 1 reply
  • 977 views

I am trying to identify what data is stored in each one of these tables. I can see all the fields that are available using the Marketo admin field management panel but it doesn't tell me where those fields reside. Here is diagram of the core entities and their relationships.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Elliott_Lowe1
Elliott_Lowe1
Level 7
May 19, 2015

You can see the fields that are mapped to your CRM's primary objects (Lead, Contact, Account) by exporting the field map in Admin | Field Management. The Program fields are Marketo only fields, which you won't see in Field Management, but there are only a few of those that you can identify by looking at the Change Program Status and Member of Program filter constraints. The Opportunity fields you can identify by looking at the Has Opportunity and Added to Opportunity filter constraints or in your CRM identify which of the Opportunity object fields are visible to the Marketo sync user. The activities in the Activity Log only have a few fields, which again you can identify by looking at the various filters in the Lead History folder in the Smart List tab of a smart list or smart campaign.

Terms & ConditionsAccessibility statement

Loading footer...