Reviewing Your Salesforce Commerce Cloud Data

read
Last updated at:

Overview 

Once you enable Klaviyo's Salesforce Commerce Cloud integration, it's important to fully understand the data that syncs from Salesforce Commerce Cloud to Klaviyo. 

View Your Salesforce Commerce Cloud Metrics 

In your Klaviyo account, navigate to the Analytics tab and select Metrics. Here, you can view all of the metrics in your account. 

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

Klaviyo limits the number of unique metrics you can create to 200. When you approach this threshold, you will get a warning in your account, along with an email to the account owner. 

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.

Added to Cart

This metric is tracked when someone adds or modifies an item in their cart.

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: 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 How to Integrate 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. 

x
Was this article helpful?
0 out of 0 found this helpful