Which data model is recommended for storing purchase data like $9.99?

The recommended data model for storing purchase data, such as amounts like $9.99, is a Data Extension. Data Extensions are specifically designed for storing and managing relational data within Salesforce Marketing Cloud. They offer greater flexibility and the ability to structure data in ways that can be tailored to meet marketing needs.

By utilizing Data Extensions, marketers can define various attributes associated with purchase data, such as product IDs, customer IDs, and transaction dates, along with monetary values. This structure allows for complex queries and segmentation, enabling more personalized marketing efforts based on specific purchase behaviors.

In contrast, Lists are more suited for simple, flat subscriber data and have limitations in terms of relational capabilities. A SQL Database, while powerful, is not natively integrated into Marketing Cloud for campaign execution and would require additional management and setup. CSV Files, while useful for temporary storage or data import/export, do not have the same capabilities for interaction within Marketing Cloud campaigns as Data Extensions do. Thus, Data Extensions provide the optimal solution for managing and leveraging purchase data effectively.