Salesforce Commerce Cloud data reference

read
Last updated at:

You will learn

Learn what data syncs from Salesforce Commerce Cloud to Klaviyo after you enable Klaviyo's Salesforce Commerce Cloud integration, and how you can view it. 

View your Salesforce Commerce Cloud metrics 

  1. In your Klaviyo account, click the Analytics dropdown and select Metrics. Here, you can view all of the metrics in your account.
  2. The metrics with a Salesforce Commerce Cloud icon are synced from your Salesforce Commerce Cloud integration. Choose Salesforce Commerce Cloud from the dropdown menu to view only these metrics. Each metric is covered individually below.
    mceclip0.png

Salesforce Commerce Cloud metrics 

Below is a list of all the metrics synced from Salesforce Commerce Cloud and an explanation of the data included with each metric. You can also view the raw data for each metric within Klaviyo.

Searched Site

This metric is tracked when someone initiates a search. 

Viewed Product

This metric is tracked when someone views a product page on your site. 

Viewed Category

This metric is tracked when someone views a category page on your site.

Add to Cart

This metric is tracked when a logged-in user adds or modifies an item in their cart. This metric will not be tracked for users that have only been cookied.

If you would like to track Add to Cart events for cookied users, please refer to the Track API method outlined in our developer documentation. Please note that this solution requires a developer with JavaScript knowledge to implement.

Placed Order

This metric is tracked when a customer completes the checkout process and orders from you in your Salesforce Commerce Cloud store. The event will list all of the product information about the items someone purchased, including product names, images, and variant information. You can then use that information in purchase follow-up emails. You can filter and target Placed Order events based on the following criteria:

  • $value
    The total order value, including shipping and any applied discounts
  • ItemNames
    The names of the ordered products, e.g., t-shirt or pants
  • ItemCount
    The number of items in the order, e.g., 2
  • OrderNumber
    The order number associated with your store 
  • SiteID
    The ID of the site 
  • Status
    The status of their order 

Ordered Product

This metric is also tracked when a customer places an order, but a separate event is tracked for each item someone purchases. For example, if someone buys a t-shirt and a pair of pants, one Placed Order event will be tracked for the purchase as a whole along with two Ordered Product events — one for the t-shirt and one for the pants.

The metrics Klaviyo tracks include detailed information about each product someone purchases. This is useful when creating behavioral segments based on product variant options and other detailed information that's not available in the Placed Order event. You can filter and target Ordered Product events based on the following criteria:

  • $value
    The total value of the item purchased; no shipping costs or discounts included
  • Name
    The name or title of the ordered product, e.g., t-shirt 
  • Price
    The price of the item 
  • SKU
    The SKU of the product variant 
  • ProductID
    The ID associated with the product in your store 
  • Quantity
    The total quantity ordered of the product 
  • SiteID
    The ID of the site 
  • CurrencyCode
    The currency code used to purchase the product, e.g., USD
Placed Order and Ordered Product events are synced to Klaviyo seconds apart. For this reason, it is important to be consistent with the metric you use to trigger and filter your flows and segments. For example, if a flow is triggered by the Placed Order metric and you add a filter to exclude anyone who Ordered Product since starting the flow, all recipients will be skipped because the two events are separate, but sync seconds apart. As a best practice, use Placed Order to trigger and filter flows and segments.

Order Confirmation

This metric is similar to Placed Order but syncs in real-time, as opposed to hourly, and is segmentable using the Categories property. 

Note that while Klaviyo may sync many details about a given metric, not all synced properties are available for segmentation. For data management purposes, only the primary details of a metric are synced as "top-level" properties, and only these top-level properties are segmentable. Commerce Cloud's Placed Order and Ordered Product metrics do not sync with a top-level Categories property. If you wish to segment using the Categories property, you will need to use the Order Confirmation metric to do so. This is ideal for real-time order confirmation emails.

Salesforce Commerce Cloud metric sources

Different Salesforce Commerce Cloud metrics flow into Klaviyo in different ways - some through the Klaviyo Cartridge and some through the OCAPI integration. When you integrated with Salesforce Commerce Cloud, you should have both installed the Klaviyo Catridge in SFCC and enabled the SFCC OCAPI integration in Klaviyo. For more information on these steps, see our article on integrating with Salesforce Commerce Cloud.

The metrics that flow in through the Cartridge are the following:

  • Order Confirmation
  • Added to Cart
  • Searched Site
  • Viewed Category
  • Viewed Product

The metrics that flow in through OCAPI are the following:

  • Placed Order
  • Ordered Product

Historical data syncs every hour from OCAPI. Your catalog should sync every eight hours, and all other metrics will sync in real-time. 

Additional resources

 

x
Was this article helpful?
5 out of 7 found this helpful