Marketo Measure Dynamics Schema marketo-measure-dynamics-schema

NOTE
You may see instructions specifying “Marketo Measure” in the documentation, but still see “Bizible” in your CRM. We are working to have that updated and the rebranding will be reflected in your CRM soon.

Below is the required Dynamics schema to get started with Marketo Measure. All entities and fields are listed, along with the required read and/or write access.

Buyer Touchpoints buyer-touchpoints

The Buyer Touchpoint is a Marketo Measure custom entity to encapsulate the marketing interactions for Contacts and Leads.

Buyer Touchpoint Relationships buyer-touchpoint-relationships

This diagram is a high-level visualization of the relationships between the Dynamics Stock entities and the Buyer Touchpoint.

Buyer Touchpoint buyer-touchpoint

Schema Name
Standard/Custom
Read
Write
bizible2_Ad_Campaign_Id
Custom
x
x
bizible2_Ad_Campaign_Name
Custom
x
x
bizible2_Ad_Content
Custom
x
x
bizible2_Ad_Destination_URL
Custom
x
x
bizible2_Ad_Group_Id
Custom
x
x
bizible2_Ad_Group_Name
Custom
x
x
bizible2_Ad_Id
Custom
x
x
bizible2_Bizible_TouchpointId
Custom
x
x
bizible2_Browser
Custom
x
x
bizible2_CampaignId
Custom
x
x
bizible2_ContactId
Custom
x
x
bizible2_Count_First_Touch
Custom
x
x
bizible2_Count_Lead_Conversion_Touch
Custom
x
x
bizible2_Count_U_Shaped
Custom
x
x
bizible2_Form_URL
Custom
x
x
bizible2_Form_URL_Raw
Custom
x
x
bizible2_Geo_City
Custom
x
x
bizible2_Geo_Country
Custom
x
x
bizible2_Geo_Region
Custom
x
x
bizible2_Keyword_Id
Custom
x
x
bizible2_Keyword_MatchType
Custom
x
x
bizible2_Keyword_Text
Custom
x
x
bizible2_Landing_Page
Custom
x
x
bizible2_Landing_Page_Raw
Custom
x
x
bizible2_LeadId
Custom
x
x
bizible2_Marketing_Channel
Custom
x
x
bizible2_Marketing_Channel_Path
Custom
x
x
bizible2_Medium
Custom
x
x
bizible2_Name
Custom
x
x
bizible2_Placement_Id
Custom
x
x
bizible2_Placement_Name
Custom
x
x
bizible2_Platform
Custom
x
x
bizible2_Referrer_Page
Custom
x
x
bizible2_Referrer_Page_Raw
Custom
x
x
bizible2_Search_Phrase
Custom
x
x
bizible2_Segment
Custom
x
x
bizible2_Site_Id
Custom
x
x
bizible2_Site_Name
Custom
x
x
bizible2_Touchpoint_Date
Custom
x
x
bizible2_Touchpoint_Position
Custom
x
x
bizible2_Touchpoint_Source
Custom
x
x
bizible2_Touchpoint_Type
Custom
x
x
bizible2_UniqueId
Custom
x
x
bizible2_Account
Custom
x
x

Buyer Attribution Touchpoint buyer-attribution-touchpoint

The Buyer Attribution Touchpoint is a Marketo Measure custom entity to encapsulate the marketing’s influence on Opportunities.

Buyer Attribution Touchpoint Relationships buyer-attribution-touchpoint-relationships

This diagram is a high-level visualization of the relationships between the Dynamics Stock entities and the Buyer Attribution Touchpoint.

Buyer Attribution Touchpoints buyer-attribution-touchpoints

Schema Name
Standard/Custom
Read
Write
bizible2_AccountId
Custom
x
x
bizible2_Ad_Campaign_Id
Custom
x
x
bizible2_Ad_Campaign_Name
Custom
x
x
bizible2_Ad_Content
Custom
x
x
bizible2_Ad_Destination_URL
Custom
x
x
bizible2_Ad_Group_Id
Custom
x
x
bizible2_Ad_Group_Name
Custom
x
x
bizible2_Ad_Id
Custom
x
x
bizible2_Attribution_Custom_Model
Custom
x
x
bizible2_Attribution_Custom_Model_2
Custom
x
x
bizible2_Attribution_First_Touch
Custom
x
x
bizible2_Attribution_Lead_Conversion_Touch
Custom
x
x
bizible2_Attribution_U_Shaped
Custom
x
x
bizible2_Attribution_W_Shaped
Custom
x
x
bizible2_Bizible_Attribution_TouchpointId
Custom
x
x
bizible2_Browser
Custom
x
x
bizible2_CampaignId
Custom
x
x
bizible2_ContactId
Custom
x
x
bizible2_Count_Custom_Model
Custom
x
x
bizible2_Count_Custom_Model_2
Custom
x
x
bizible2_Count_First_Touch
Custom
x
x
bizible2_Count_Lead_Creation_Touch
Custom
x
x
bizible2_Count_U_Shaped
Custom
x
x
bizible2_Count_W_Shaped
Custom
x
x
bizible2_Form_URL
Custom
x
x
bizible2_Form_URL_Raw
Custom
x
x
bizible2_Geo_City
Custom
x
x
bizible2_Geo_Country
Custom
x
x
bizible2_Geo_Region
Custom
x
x
bizible2_Keyword_Id
Custom
x
x
bizible2_Keyword_MatchType
Custom
x
x
bizible2_Keyword_Text
Custom
x
x
bizible2_Landing_Page
Custom
x
x
bizible2_Landing_Page_Raw
Custom
x
x
bizible2_Marketing_Channel
Custom
x
x
bizible2_Marketing_Channel_Path
Custom
x
x
bizible2_Medium
Custom
x
x
bizible2_Name
Custom
x
x
bizible2_OpportunityId
Custom
x
x
bizible2_Placement_Id
Custom
x
x
bizible2_Placement_Name
Custom
x
x
bizible2_Platform
Custom
x
x
bizible2_Referrer_Page
Custom
x
x
bizible2_Referrer_Page_Raw
Custom
x
x
bizible2_Revenue_Custom_Model
Custom
x
x
bizible2_Revenue_Custom_Model_2
Custom
x
x
bizible2_revenue_custom_model_2_Base
Custom
x
x
bizible2_revenue_custom_model_Base
Custom
x
x
bizible2_Revenue_First_Touch
Custom
x
x
bizible2_revenue_first_touch_Base
Custom
x
x
bizible2_Revenue_Lead_Conversion_Touch
Custom
x
x
bizible2_revenue_lead_conversion_Base
Custom
x
x
bizible2_Revenue_U_Shaped
Custom
x
x
bizible2_revenue_u_shaped_Base
Custom
x
x
bizible2_Revenue_W_Shaped
Custom
x
x
bizible2_revenue_w_shaped_Base
Custom
x
x
bizible2_Search_Phrase
Custom
x
x
bizible2_Segment
Custom
x
x
bizible2_Site_Id
Custom
x
x
bizible2_Site_Name
Custom
x
x
bizible2_Touchpoint_Date
Custom
x
x
bizible2_Touchpoint_Position
Custom
x
x
bizible2_Touchpoint_Source
Custom
x
x
bizible2_Touchpoint_Type
Custom
x
x
bizible2_UniqueId
Custom
x
x

Marketo Measure AB Tests marketo-measure-ab-tests

Schema Name
Standard/Custom
Read
Write
bizible2_Bizible_ABTestId
Custom
x
x
bizible2_BizibleId
Custom
x
x
bizible2_ContactId
Custom
x
x
bizible2_DateReported
Custom
x
x
bizible2_Experiment
Custom
x
x
bizible2_ExperimentId
Custom
x
x
bizible2_LeadId
Custom
x
x
bizible2_Name
Custom
x
x
bizible2_OpportunityId
Custom
x
x
bizible2_UserId
Custom
x
x
bizible2_Variation
Custom
x
x
bizible2_VariationId
Custom
x
x

Marketo Measure Events marketo-measure-events

Schema Name
Standard/Custom
Read
Write
bizible2_Bizible_EventId
Custom
x
x
bizible2_BizibleId
Custom
x
x
bizible2_ContactId
Custom
x
x
bizible2_DateReported
Custom
x
x
bizible2_EventName
Custom
x
x
bizible2_EventValue
Custom
x
x
bizible2_LeadId
Custom
x
x
bizible2_Name
Custom
x
x
bizible2_OpportunityId
Custom
x
x

Marketo Measure History marketo-measure-history

Schema Name
Standard/Custom
Read
Write
bizible2_Bizible_HistoryId
Custom
x
x
bizible2_Entity_Type
Custom
x
x
bizible2_EntityId
Custom
x
x
bizible2_EntityLogicalName
Custom
x
x
bizible2_Name
Custom
x
x

Dynamics Standard Entities dynamics-standard-entities

This list provides the Dynamics Standard Entities that Marketo Measure interacts with, and the custom fields that we add to these entities.

Lead

Schema Name
Standard/Custom
Read
Write
leadid
Standard
x
emailaddress1
Standard
x
statecode
Standard
x
statuscode
Standard
x
createdon
Standard
x
modifiedon
Standard
x
contactid
Standard
x
qualifyingopportunityid
Standard
x
websiteurl
Standard
x
companyname
Standard
x
bizible2_Account
Custom
x
x
bizible2_BizibleId
Custom
x
x

Contact

Schema Name
Standard/Custom
Read
Write
contactid
Standard
x
emailaddress1
Standard
x
accountid
Standard
x
createdon
Standard
x
modifiedon
Standard
x
bizible2_BizibleId
Custom
x
x

Account

Schema Name
Standard/Custom
Read
Write
accountid
Standard
x
websiteurl
Standard
x
createdon
Standard
x
modifiedon
Standard
x
bizible2_Engagement_Score
Custom
x
x

Opportunity

Schema Name
Standard/Custom
Read
Write
opportunityid
Standard
x
accountid
Standard
x
createdon
Standard
x
modifiedon
Standard
x
statecode
Standard
x
statecodename
Standard
x
salesstage
Standard
x
salesstagecode
Standard
x
estimatedclosedate
Standard
x
actualvalue
Standard
x
bizible2_Bizible_Opportunity_Amount
Custom
x
x
bizible2_bizible_opportunity_amount_Base
Custom
x
x

Campaign

Campaign “Create” permissions are also required, in addition to the read/write permissions below.

Schema Name
Standard/Custom
Read
Write
campaignid
Standard
x
typecode
Standard
x
typecodename
Standard
x
createdon
Standard
x
modifiedon
Standard
x
bizible2_Bizible_Attribution_SyncType
Custom
x
x
bizible2_Marketing_Lists_Sync
Custom
x
x
bizible2_UniqueId
Custom
x
x
bizible2_Touchpoint_End_Date
Custom
x
x
bizible2_Touchpoint_Start_Date
Custom
x
x

Campaign Response

Schema Name
Standard/Custom
Read
Write
activityid
Standard
x
activitytypecode
Standard
x
activitytypecodename
Standard
x
createdon
Standard
x
modifiedon
Standard
x
responsecode
Standard
x
responsecodename
Standard
x
customer
Standard
x
regardingobjectid
Standard
x
bizible2_Bizible_Touchpoint_Date
Custom
x
x
bizible2_Touchpoint_Status_Date
Custom
x
x
bizible2_Touchpoint_Status_Contact
Custom
x
x
bizible2_Touchpoint_Status_Leade
Custom
x
x
bizible2_Touchpoint_Status_Opportunity
Custom
x
x

List

Schema Name
Standard/Custom
Read
Write
listid
Standard
x
createdfromcode
Standard
x
membertype
Standard
x
createdon
Standard
x
modifiedon
Standard
x
bizible2_Bizible_Touchpoint_Date
Custom
x
x

ListMember

Schema Name
Standard/Custom
Read
Write
listid
Standard
x
entityid
Standard
x
listmemberid
Standard
x
createdon
Standard
x
modifiedon
Standard
x

Phone Call

Schema Name
Standard/Custom
Read
Write
activityid
Standard
x
activitytypecode
Standard
x
activitytypecodename
Standard
x
createdon
Standard
x
modifiedon
Standard
x
customer
Standard
x
regardingobjectid
Standard
x
bizible2_Bizible_Touchpoint_Date
Custom
x
x
bizible2_BizibleId
Custom
x
x

[] = V1 legacy customers only

recommendation-more-help
9deee213-85c8-4c42-8ba8-089345b91d20