---
schema_version: "1"
id: 1e86ae211bf440f36bb439f19373125b27c4cd86e8aed788ffec974755ad7d3e
title: Data Designer Templates
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_cab_data_designer_templates.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_cab_data_designer_templates.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: c49b77cd8f346d88b8ce97b4ba9e9d130dafa8c2cec0f7543d1684068f8462f0
description: Data Designer includes these templates for creating attribute groups in Contact Builder.
products:
  - Marketing
  - Marketing Cloud Engagement
release: "264"
---
# Data Designer Templates

Data Designer includes these templates for creating attribute groups in Contact Builder.

## Demographics Template

This template creates this data extension:

- Demographics
    - Birthday (Text)
    - City (Text)
    - Customer ID (Text)
    - First Name (Text)
    - Gender (Text)
    - Last Name (Text)
    - Postal Code (Text)
    - State (Text, restricted to postal code values for US states)

## Retail Transaction Template

This template creates the following data extensions, including listed fields and relationships:

- Retail Orders
    - Customer ID (Text)
    - Grand Total (Decimal)
    - Order Date (Date)
    - Order ID (Text)
    - Order Number (Text)
    - Order Status (Text)
    - Order Total (Decimal)
    - Tax Total (Decimal)
- Retail Order Lines
    - Discount (Decimal)
    - Extended Price (Decimal)
    - Order ID (Text)
    - Order Line ID (Text)
    - Order Line Status (Text)
    - Product ID (Text)
    - Quantity (Decimal)
    - Unit Price (Decimal)
- Products
    - Product Description (Text)
    - Product ID (Text)
    - Product Name (Text)
    - Product SKU (Text)
    - Unit Cost (Decimal)
    - Unit Price (Decimal)
- Returns
    - Customer ID (Text)
    - Grand Total (Decimal)
    - Return Date (Calendar)
    - Return ID (Text)
    - Return Number (Text)
    - Return Status (Text)
    - Return Total (Decimal)
    - Tax Total (Decimal)
- Return Lines
    - Discount (Decimal)
    - Extended Price (Decimal)
    - Product ID (Text)
    - Quantity (Decimal)
    - Return ID (Text)
    - Return Line ID (Text)
    - Return Number (Text)
    - Return Reason (Text)
    - Unit Price (Decimal)
- Payments
    - Order ID (Text)
    - Payment Amount (Decimal)
    - Payment ID (Text)
    - Payment Method (Text)
- Credits
    
    - Credit Amount (Decimal)
    
    - Credit ID (Text)
    - Credit Method (Text)
    - Return ID (Text)

The template creates one-to-many relationships from the contact record to the Orders and Returns data extensions. The template also creates one-to-many relationships from the Orders data extension to the Order Lines and Payments data extensions. The Returns data extension receives one-to-many relationships to the Return Lines and Credits data extensions. Finally, the template creates many-to-one relationships from the Order Lines and Return Lines data extensions to the Products data extension.

## Shopping Cart Template

This template creates these data extensions, including listed fields and relationships:

- Shopping Cart Products
    - Product Description (Text)
    - Product ID (Text)
    - Product Name (Text)
    - Product SKU (Text)
    - Unit Cost (Decimal)
    - Unit Price (Decimal)
- Product Views
    - Customer ID (Text)
    - First View Date (Date)
    - Last View Date (Date)
    - Product ID (Text)
    - Total Views (Number)
- Shopping Cart
    - Customer ID (Text)
    - Is Abandon (Boolean)
    - Shopping Cart ID (Text)
- Shopping Cart Items
- - Add Date (Date)
    - Is Deleted (Boolean)
    - Last Update Date (Date)
    - Product ID (Text)
    - Quantity (Text)
    - Shopping Cart ID (Text)

The template creates one-to-many relationships from the contact record to the Product Views and Shopping Cart data extensions. The template also creates a one-to-many relationship from the Shopping Cart data extension to the Shopping Cart Items data extension. Finally, the template creates a many-to-one relationship from the Shopping Cart Items and Product Views data extensions to the Product data extension.

## Travel Booking Template

This template creates these data extensions:

- Locations
    - City (Text)
    - Country (Text)
    - Location ID (Text)
    - Postal Code (Text)
    - Region (Text)
- Airports
    - Airport ID (Text)
    - City (Text)
    - Country (Text)
    - Location ID (Text)
    - Postal Code (Text)
    - Region (Text)
- Hotels
- - City (Text)
    - Country (Text)
    - Hotel ID (Text)
    - Location ID (Text)
    - Postal Code (Text)
    - Region (Text)
- Weather
    - Conditions (Text)
    - Date (Date)
    - High Temperature (Number)
    - Location ID (Text)
    - Low Temperature (Number)
- Flight History Airport
    - Airport ID (Text)
    - Booking ID (Text)
    - Destination (Boolean)
    - Origination (Boolean)
- Flight History
    - Airline (Text)
    - Booking ID (Text)
    - Cabin Class (Text)
    - Contact Key (Text)
    - Departure Date (Date)
    - Destination Airport (Text)
    - Originating Airport (Text)
    - Total Passengers (Number)
    - Cabin Class (Text)
- Hotel History
    - Booking ID (Text)
    - Check In Date (Date)
    - Check Out Date (Date)
    - City (Text)
    - Contact Key (Text)
    - Country (Text)
    - Hotel ID (Text)
    - Hotel Name (Text)
    - Postal Code (Text)
    - Region (Text)
- Booking Demographics
    - Contact Key (Text)
    - Likes Beach (Boolean)
    - Likes Snow (Boolean)
    - Number of Children (Number)
    - Preferred Airline 1 (Text)
    - Preferred Airline 2 (Text)
    - Preferred Airline 3 (Text)
    - Preferred Hotel 1 (Text)
    - Preferred Hotel 2 (Text)
    - Preferred Hotel 3 (Text)
    - Travels Domestically (Boolean)
    - Travels Internationally (Boolean)