---
schema_version: "1"
id: 296b0c8709a8373187d00031157f465eb3134b375f0d174cd2cd35dec833e844
title: Customizing the Marketing Semantic Data Model
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mke_unified_reporting_sdm.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mke_unified_reporting_sdm.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e3e1193246d0dc1141f1a9eae891b706552ead689154eb3fbd52740646d3f410
description: Extend or customize the semantic data model (SDM) that’s included with Marketing Cloud Next. You can associate objects from Data 360, such as data from Sales or Service Cloud. The SDM can also include other data, such as data from your data extensions in Marketing Cloud Engagement.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Customizing the Marketing Semantic Data Model

Extend or customize the semantic data model (SDM) that’s included with Marketing Cloud Next. You can associate objects from Data 360, such as data from Sales or Service Cloud. The SDM can also include other data, such as data from your data extensions in Marketing Cloud Engagement.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col style="width:100%"></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Marketing Cloud Engagement <strong>Pro+</strong>, <strong>Corporate+</strong>, and <strong>Enterprise+</strong> editions</td></tr></tbody></table>

The SDM that’s included with Marketing Cloud Next is called the Marketing Intelligence Semantic Data Model. The SDM is a reporting layer built on top of many different Data 360 objects. It’s helpful to use the Marketing Intelligence Semantic Data Model to create reports related to high-level engagement and deliverability KPIs.

![Important](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_marketing_cloud_overview-264-0-0-production-enus/2555afdb-8049-4e3c-8043-0e04803e5f16/images/icon_important.png)

Important Don’t modify the Marketing Intelligence Semantic Data Model directly. Instead, create a semantic data model based on it. See [Create an Extended Model Based on a Base Model](https://help.salesforce.com/s/articleView?id=analytics.c360_a_sl_data_models_create_existing.htm&language=en_US). This step creates a copy of the default SDM, while the original remains unchanged. Modify the copied version so that you can revert to the default version if necessary.

There are two main ways to expand and modify the SDM: joins and unions.

Joins

A join is a direct relationship between two tables that adds columns to existing rows of data.

For example, assume that you have a report that lists 100 individuals you sent messages to and indicates whether they opened the message. You want to add more columns to report on, such as each individual’s loyalty tier, postal code, lifetime value, registration data, and last purchase date.

The result of using a join is a table that contains the same number of rows, but contains more columns.

Unions

A union combines multiple tables into a single table based on a shared structure.

For example, assume that you want to create a report that lists all individuals who engaged with your brand in any way. You have a report that lists 100 individuals you sent messages to and indicates whether they opened the message. Now, you want to add more records for individuals who have made purchases on your website, engaged with your brand on social media, or logged in to your app.

The result of using a join is a table that contains more rows of data compared to the original dataset, but with the same number of columns.