Marketo Measure Dynamics Schema

Last update: 2023-08-09

Topics:
Microsoft Dynamics
View more on this topic

Created for:

NOTE

You may see instructions specifying “Marketo Measure” in our 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 you’ll find the required Dynamics schema in order to get started with Marketo Measure. All entities and fields are listed, along with the required read and/or write access.

Buyer Touchpoints

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

Buyer Touchpoint Relationships

This diagram is a high-level visualization of the relationships between the Dynamics Stock entities and the 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

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

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

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

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

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

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

This lists provides the Dynamics Standard Entities that Marketo Measure interacts with, as well as 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

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

Marketo Measure Dynamics Schema

Buyer Touchpoints

Buyer Touchpoint Relationships

Buyer Touchpoint

Buyer Attribution Touchpoint

Buyer Attribution Touchpoint Relationships

Buyer Attribution Touchpoints

Marketo Measure AB Tests

Marketo Measure Events

Marketo Measure History

Dynamics Standard Entities

On this page

View next:

Learn

Documentation

Community

Support

Resources

Adobe Account

Adobe