Map and Harmonize Your Data
Learning Objectives
After completing this unit, you’ll be able to:
- Determine when to use the ecommerce data model.
- List the entities that are available with the ecommerce data model.
- Map your data with the ecommerce data stream type.
What Is the Ecommerce Data Model?
The ecommerce data model ingests different data types from ecommerce platforms. It provides levels of data for product catalogs, placed orders, the number of purchased items within each order, and more.
The ecommerce data model is an extension of the product data model. It accommodates more use cases and datasets revolving around ecommerce data. You can use it for any flat file that contains ecommerce data related to orders, order items, and products. It’s also the data stream type that’s used for ecommerce API connectors, including Amazon Seller Central, Amazon Vendor Central Inventory, Salesforce Order Management (OMS), and Commerce Cloud B2C.
The ecommerce data model provides this information.
- Product catalog—Tracks and analyzes products that you have in different ecommerce sources. You can tie it to the revenue for each product and use it to remove the granularity of the order level.
- Order level data—Tracks details about orders placed over time, including revenue, tax, quantity ordered and shipped, and order level discounts.
- Order item level data—Applies to each product purchased in a specific order. It includes the product level data and price on the date of purchase. You link it to the product catalog to fill in the data of each item purchased, such as image, category, and SKU.
The Entities of the Ecommerce Data Model
This diagram describes the entities of the ecommerce data model.
The Ecommerce Order is the main entity and covers a large amount of ecommerce order information. If the data doesn’t have an order key, default values are created for the separate orders based on the date the data was uploaded.
These entities are also included.
- Product—An overarching entity that exists across other data stream types in Marketing Cloud Intelligence. You can use it for connectivity across datasets outside of the ecommerce data model.
- Order Items—Revolves around the items within an order. It contains granular information regarding ecommerce order items.
- Campaign—An entity that exists within multiple data stream types. You can use it to connect ecommerce data with advertising data across Marketing Cloud Intelligence. By default, campaign data isn’t connected to advertising data.
- Client—Contains information regarding the customer who placed an ecommerce order. Personally identifiable information is properly secured.
Map Data with the Ecommerce Data Stream Type
If you’re uploading a file that contains ecommerce data, you can use the ecommerce data stream type to ensure the data is mapped correctly in Marketing Cloud Intelligence. Here’s how.
- To map your data, first, create a data stream using the steps you learned in the previous unit: In Marketing Cloud Intelligence, go to the Connect & Mix tab (1), click Data Streams List (2) and then click Create New (3).
- You can either use TotalConnect (if you want to upload data using an external file, such as an Excel or CSV file) or use an API connector to pull in your data. (To learn more about these options, see Data Uploading in Marketing Cloud Intelligence.) Follow the steps in the previous unit to define your data stream and then move on to the mapping stage.
- To switch to the ecommerce data stream type, click Switch Data Stream Type at the top-right corner of the page. Then search for and select ecommerce.
After you switch types, all the available fields appear. You can expand each section to see the available measurements and dimensions.
In this unit you read about the ecommerce data model and learned how and when to use it. Move on to the next unit to learn about another product in the ecommerce offering, the Ecommerce Marketing Insights app.