Marketo Measure Dynamics Schema

Last update: July 23, 2024

Topics:
Microsoft Dynamics

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

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

bizible2_BizibleId

Custom

x

bizible2_ContactId

Custom

x

bizible2_DateReported

Custom

x

bizible2_EventName

Custom

x

bizible2_EventValue

Custom

x

bizible2_LeadId

Custom

x

bizible2_Name

Custom

x

bizible2_OpportunityId

Custom

x

Marketo Measure History

Schema Name

Standard/Custom

Read

Write

bizible2_Bizible_HistoryId

Custom

x

bizible2_Entity_Type

Custom

x

bizible2_EntityId

Custom

x

bizible2_EntityLogicalName

Custom

x

bizible2_Name

Custom

x

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

bizible2_BizibleId

Custom

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

Account

Schema Name

Standard/Custom

Read

Write

accountid

Standard

x

websiteurl

Standard

x

createdon

Standard

x

modifiedon

Standard

x

bizible2_Engagement_Score

Custom

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

bizible2_bizible_opportunity_amount_Base

Custom

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

bizible2_Marketing_Lists_Sync

Custom

x

bizible2_UniqueId

Custom

x

bizible2_Touchpoint_End_Date

Custom

x

bizible2_Touchpoint_Start_Date

Custom

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

bizible2_Touchpoint_Status_Date

Custom

x

bizible2_Touchpoint_Status_Contact

Custom

x

bizible2_Touchpoint_Status_Leade

Custom

x

bizible2_Touchpoint_Status_Opportunity

Custom

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

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

bizible2_BizibleId

Custom

x

[] = V1 legacy customers only

recommendation-more-help