Table schemas in Common Data Model
Common Data Model is a declarative specification, and a definition of standard tables that represent commonly used concepts and activities across business and productivity applications. This model is being extended to observational and analytical data as well. Common Data Model provides well-defined, modular, and extensible business tables—such as Account, Business Unit, Case, Contact, Lead, Opportunity, and Product—as well as interactions with vendors, workers, and customers—such as activities and service level agreements. Anyone can build on and extend Common Data Model definitions to capture additional business-specific ideas.
This shared data model allows applications and data integrators to collaborate more easily by providing a unified definition of data. Common Data Model includes a rich metadata system with standard tables, relationships, hierarchies, traits, and more. It originated from Dynamics 365 apps and is open-sourced on GitHub with over 260 standard tables. A large system of internal and external partners contributes industry-specific concepts to Common Data Model.
Multiple systems and platforms implement the Common Data Model today, including Power BI dataflows and Azure Data Services. It's already supported in Microsoft Dataverse, Dynamics 365, Power Apps, Power BI, and upcoming Azure data services, directly accruing value towards the Open Data Initiative.
Customer Insights - Data table schemas
To establish a 360-degree view of the customer and make Dynamics 365 Customer Insights - Data models available in Common Data Model for extensibility, we've published the following table schemas:
| Table | Description |
|---|---|
| CustomerActivity | An activity performed by a user that has observational value to the business. |
| CustomerProfile | A person or organization that either performed, or has the potential to engage in, business activities. |
| MeasureDefinition | Definition of KPIs partitioned by zero or more dimensions (such as Monthly Active Users, Total Spend By Customer, Average Customer Acquisition Cost) |
| Segment | Defines a group of members with common traits. |
| SegmentMembership | Members participating in a given segment. |
For more information, see the documentation about the Customer Insights - Data table schemas in Common Data Model.
View tables using the Common Data Model Table Navigator
View tables in the Common Data Model Table Navigator. Select a table from the Insights Application section to get the list of Customer Insights - Data tables and their definitions.
