Salesforce Docs Portal

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)