Create a Salesforce B2C Commerce Intelligence Data Stream (Beta)

Start the flow of data by creating a data stream for your Salesforce B2C Commerce Intelligence data source. The data stream creates a data lake object (DLO) in Data Cloud that you can map to the Customer 360 Data Model to use across Data Cloud.

Before you begin:

• Make sure that the required Salesforce B2C Commerce Intelligence connection is set up.

1. In Data Cloud, on the Data Streams tab, click New.

   You can also use App Launcher to find and select Data Streams.

2. Under Other Sources, select the Salesforce B2C Commerce Intelligence connection source, and click Next.

3. Select from the available Salesforce B2C Commerce Intelligence connections.

4. Select the object that you want to import, and click Next.

   You can select one new object on the Available Objects tab or an existing object on the In Use Objects tab.

5. Under Object Details, for category, identify the type of data in the data stream.

6. For primary key, select a unique field to identify a source record.

   Object	Primary/Composite Keys
   ccdw_aggr_product_cobuy	submit_date product_one_id product_two_id order_channel nsite_id registered first_time_buyer device_class_code
   ccdw_aggr_product_sales_summary	business_channel_id registered site_id first_time_buyer sku_id product_id device_class_code
   ccdw_aggr_promotion_cobuy	submit_date promotion_one_id promotion_two_id promotion_one_class promotion_two_class order_channel nsite_id registered first_time_buyer device_class_code
   ccdw_aggr_promotion_sales_summary	submit_date business_channel_id registered site_id first_time_buyer promotion_id coupon_id device_class_code
   ccdw_aggr_sales_summary	submit_date business_channel_id registered site_id first_time_buyer device_class_code
   ccdw_aggr_search	search_date site_id registered device_class_code
   ccdw_aggr_search_conversion	search_date site_id registered device_class_code query has_results
   ccdw_aggr_search_query	search_date site_id registered device_class_code query
   ccdw_dim_coupon	coupon_id
   ccdw_dim_currency	currency_id
   ccdw_dim_customer	customer_id
   ccdw_dim_date	day_id
   ccdw_dim_geography	geography_id
   ccdw_dim_product	sku_id
   ccdw_dim_promotion	promotion_id
   ccdw_dim_site	site_id
   ccdw_dim_time	time_id
   ccdw_dim_timezone	timezone_id
   ccdw_fact_line_item	line_item_id
   ccdw_fact_order_payments	order_payment_id
   ccdw_fact_promotion_line_item	promotion_line_item_id

   If a composite key is required or a key doesn’t exist, you can create one using a formula field. See Create a Formula Field or Use Case 2: Create a Primary Key.

7. (Optional) Select a record modified field.

   If data is received out of order, the record modified field provides a reference point to determine whether to update the record. The record with the most up-to-date timestamp is loaded.

8. (Optional) To identify the data lineage of a record’s business unit, add the organization unit identifier.

9. Click Next.

10. For Data Space, if the default data space isn’t selected, assign the data stream to the appropriate data space.

11. Click Deploy.

When the Last Run Status displays success, you can see how many records were processed and the total number of records that were loaded.

You can now map the created DLO to the data model to use the data in segments, calculated insights, and other use cases.