MDP CRM Data Stream Types

CRM stands for Customer Relationship Management. There are two data stream types for uploading CRM data. One type for uploading leads data called CRM Leads, and one for opportunities data called CRM. The CRM data stream type is equipped with slowly changing type 2 dimensions such as lead stage, lead status, and lead modified date. The CRM leads data stream type ingests data from lead generation platforms such as Marketing Cloud Account Engagement, Hubspot Marketing, and Intercom. It also ingests data from CRM platforms such as Salesforce, Sugar CRM, and CRM Creation.

• MDP Slowly Changing Dimensions Type 2
  With CRM data, opportunity or lead attributes are updated over time because an opportunity can go through different stages. The CRM leads data stream type uses the slowly changing dimensions type 2 method to enable a data display suitable for these changes in dimension values. After a dimension’s value changes, the new value appears from the modification date and onwards. The value isn’t updated retroactively.
• MDP Differences Between Leads and Opportunity Data Stream Types
  The difference between Leads and Opportunity data stream types is seen by their Type 2 dimensions.
• MDP Measurements in the CRM Data Stream Types
  There are two system-generated measurements, one for each CRM data stream type: Leads Count, and Opportunities Count. These measurements perform a distinct count at Lead Key and Opportunity Key level. For example, if you have a lead with three stages, the Leads Count measurement returns the result of one as opposed to three.