Bizible Dynamics Schema

Below you’ll find the required Dynamics schema in order to get started with Bizible. All entities and fields are listed, along with the required read and/or write access.

Bizible Touchpoints

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

Bizible Touchpoint Relationships

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

Bizible 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

Bizible Attribution Touchpoint

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

Bizible Attribution Touchpoint Relationships

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

Bizible 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

Bizible 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

Bizible 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

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

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

On this page