Review and Understand Your Shopify Data

Overview

Once you enable Klaviyo's Shopify integration, it's important to fully understand the data that will begin to sync from Shopify to Klaviyo.

Navigate to the Metrics tab from the left-hand navigation sidebar, where you can view all of the metrics in your account. The metrics with a Shopify icon represent all of the metrics synced from your Shopify integration. You can filter this view to see only Shopify metrics by using the filter selector in the upper right-hand corner.

The Shopify Metrics

Below is a list of all the metrics synced from Shopify and an explanation of the data included along with each metric. If you are interested in learning how to review the raw metric data that gets synced to Klaviyo, check out this guide.

Checkout Started

This event is tracked when a customer enters his/her contact and shipping information on the first page of the Shopify checkout process and clicks continue. The event that Klaviyo tracks includes all of the product information about the items in someone's cart including product names, images, and variant information so you can use this information in your abandoned cart emails.

This event syncs with a checkout URL property, which links back to each customer’s unique cart. If someone opens an abandoned cart email from a new device, this link will rebuild the person's cart when clicked through. You can filter and target Checkout Started events based on the following criteria:

$value: The total value of the cart at time of started checkout

Items: The names of the products in someone's order, e.g., t-shirt or pants

Collections: The complete set of the collections of the products in someone's order, e.g., t-shirts, men's, pants and sale

Total Discounts: The total amount of any coupons or discounts if someone used code, e.g., 10.00

If there is billing address information available, we will also capture all relevant address details. If there is a referring site captured by Shopify, we will sync this as well.

Placed Order

This event is tracked when a customer completes the checkout process and creates an order in your Shopify store. The event Klaviyo tracks includes all of the product information about the items someone purchased including product names, images and variant information so you can use that information in purchase follow up emails. You can filter and target Placed Order events based on the following criteria:

$value: The total value of the placed order, inclusive of shipping and any applied discounts

Items: The names of the products in someone's order, e.g., t-shirt or pants

Collections: The complete set of the collections of the products in someone's order, e.g., t-shirts, mens, pants, and sale

Item Count: The number of items in the order, e.g., 2

Discount Codes: Any discount or coupon codes someone used towards the order, e.g., SPRING2015; while this isn't synced as a specific metric, there will be a Discount Codes property for each order that will allow you to see who purchased using particular codes.

Total Discounts: The total amount of any coupons or discounts if someone used a code, e.g., 10.00

Source Name: POS, Mobile etc.

Revenue, or Placed Order value, is calculated as follows: (sub-total + shipping) - any discounts.

You may see that the Revenue value on your Klaviyo dashboard does not always match up with the revenue value you see in Shopify; this is because Shopify subtracts canceled and refunded orders from their revenue calculation, while Klaviyo does not.

Note

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 your flow is triggered by the Placed Order event 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 the Placed Order event to trigger and filter flows and segments.

Ordered Product

This event 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 along with two Ordered Product events -- one Placed Order event for the purchase as a whole, and then one Ordered Product event for the t-shirt and one Ordered Product event for the pants.

The event Klaviyo tracks includes 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 in Shopify, e.g., t-shirt

Variant Name: The name or title of the product variant in Shopify, e.g., red, size medium t-shirt

SKU: The SKU of the product variant, e.g., REDMEDIUMTSHIRT

ProductID: The ID associated with the product in your store

Quantity: The total quantity ordered of the product

Collections: The complete set of collections or categories applied to the product, e.g., t-shirts, mens and sale

Tags: Any tags applied to the product in your store

Variant Option: <OptionName>: the name and value of any variant options for the variant ordered, e.g., Variant Option: Size would be Medium and Variant Option: Color would be Red

Attribute: <AttributeName>: the name and value of any product attributes for the product ordered, e.g., Attribute: Season would be Spring

Fulfilled Order

This event is tracked when an order is marked as "fulfilled" in your Shopify store. Klaviyo will track a Fulfilled Order event specifically when we sync an order with a Fulfillment Status of "fulfilled."

The event Klaviyo tracks includes all product information regarding the items someone purchased including product names and images so you can use that information in purchase follow up emails. You can filter and target Fulfilled Order events based on the following criteria:

$value: The total value of the fulfilled order

Items: The names of the products in someone's order, e.g., t-shirt or pants

Collections: The complete set of the collections of the products in someone's order, e.g., t-shirts, men's, pants, and sale

Total Discounts: The total amount of any coupons or discounts if someone used a code, e.g., 10.00

Cancelled Order

This event is tracked when a customer creates an order in your Shopify store but then cancels the order before fulfillment. The event Klaviyo tracks includes all of the product information about the items someone purchased including product names and images. You can filter and target Cancelled Order events based on the following criteria:

$value: The total value of the cancelled order

Items: The names of the products in someone's order, e.g., t-shirt or pants

Collections: The complete set of the collections of the products in someone's order, e.g., t-shirts, mens, pants and sale

Total Discounts: The total amount of any coupons or discounts if someone used a code, e.g., 10.00

Refunded Order

This event is tracked when a customer completes the checkout process in your Shopify store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders). The event Klaviyo tracks includes all of the product information about the items someone purchased including product names, images, and variant information. You can filter and target Refunded Order events based on the following criteria:

$value: The total value of the refunded order

Items: The names of the products in someone's order, e.g., t-shirt or pants

Collections: The complete set of the collections of the products in someone's order, e.g., t-shirts, mens, pants and sale

Total Discounts: The total amount of any coupons or discounts if someone used a code, e.g., 10.00

Synced Customer Data

In addition to the metrics Klaviyo syncs from Shopify, Klaviyo will also create a unique profile for every customer that we sync. When we sync contact information, there are also certain custom properties that may get added to each Klaviyo Profile. You can use these properties in segments and in flows. Here are the properties that are automatically synced from Shopify:

Email, First and Last Name, City, State/Region, Zip Code, Country, Phone Number: These built-in Klaviyo fields are automatically populated with all available data from Shopify

Accepts Marketing: Whether or not a customer has opted-in to receive marketing, e.g., True/False

Shopify Tags: Any custom tags assigned to that customer in Shopify, e.g., Wholesale or VIP

Frequency of the Shopify Sync

Metrics and profile properties from Shopify are synced in real-time. You should see event data appear in your Klaviyo account within a few seconds of when the event is tracked in your Shopify store.

Because we sync all metrics in real-time, any tags -- such as Order Tags -- that might be added to an order after it is processed will not sync into Klaviyo. Klaviyo does not re-sync metrics after the initial event takes place, so no tags or adjustments made to an order after-the-fact will be updated in Klaviyo.

Verify your Order Data

Klaviyo imports all of your Shopify data. To verify this, you can compare the number of orders on a particular day with what's in the Shopify interface and confirm they match. Click on the Metricstab, find the Placed Order metric, and click on it. This will take you to the metric's reporting page and show the last 30 days of data by default.

Hover over yesterday's data point or look in the table of data below the chart to see how many orders you had yesterday. Compare that number to what's stored in Shopify and you should see them match exactly. If they don't, the most likely issue is your Klaviyo account's timezone doesn't match Shopify's timezone. To check your timezone setting, go to your account page, then click the Organization tab at the top.