114k views
5 votes
A customer has three data extensions that need to be added to Contact Builder

> Customers contains customer information
> Orders contains order information
> Products contains product information

How should these data extensions be linked within an Attribute Group?

A. Customer Data Customers Orders Products

B. Customer Data Customers Orders Products

C. Customer Data Customers Orders Products

D. Customer Data Products Orders Customers

User Wuerg
by
8.4k points

1 Answer

6 votes

Final answer:

The best way to link the data extensions in an Attribute Group within Contact Builder is A. Customer Data→Customers→Orders→Products, allowing for a relational data model based on customer identifiers.

Step-by-step explanation:

A common task in marketing platforms like Salesforce Marketing Cloud is to manage and structure data to enable personalized marketing communications. When working with Contact Builder and its Attribute Groups, you need to link Data Extensions in a logical manner that reflects the relationships between them.


In the scenario presented, the best option appears to be:
A. Customer Data→Customers→Orders→Products

The Customer Data Extension likely contains unique identifiers for each customer, which can be used to link to Orders since each order should be associated with a customer ID. From Orders, each order would contain information about the purchased products, which links to the Products Data Extension.


This arrangement allows for a relational data model as follows:

  • Customers: The core of the relationship, containing unique customer information.
  • Orders: Connect to Customers via a key such as Customer ID.
  • Products: Connect to Orders through linked product identifiers in the Orders Data Extension.


The given options do not explicitly describe the relations, assumedly, they would be linked with primary and foreign keys that represent these relationships.

User Gbabu
by
8.3k points