Review and Understand your Magento Data

Overview

Klaviyo's integration with Magento pulls in all of the historical data in your Magento store through with the initial historic sync. Once enabled the integration will also begin to sync metrics and customer data in near real-time. Examples of this data include the information associated with past placed orders, fulfilled orders, etc.

In Klaviyo, you can navigate to your account's Metrics tab in the left sidebar to view all of the metrics in your account; the metrics with a Magento icon are the ones synced from your Magento integration.

647752

The Magento Metrics

Checkout Started

This event is tracked when a customer enters their contact and shipping information on the first page of the Magento checkout process and clicks continue. The event 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 that information in your abandoned cart emails. This event has a checkout URL property, which links back to each customer’s exact cart and will rebuild the cart if a customer opens the email from a new device.

You can filter and target Checkout Started events based on the following criteria:

  • Value: The value of the cart at time of checkout
  • Items: The names of the products in someone's cart; for example, t-shirt or pants.
  • Items Count: The total amount of items in someone's cart
  • Discount Codes (optional): Any coupon or discount codes applied
  • Total Discounts (optional): Total dollar value of any coupons or discounts

Placed Order

This event is tracked when a customer completes the checkout process and creates an order in your Magento 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: Total value of the order (sub-total + shipping cost - any discounts)
  • Items: The names of the products in someone's order.
    ex: t-shirt or pants. If ordered multiple times will show multiple of the same item
  • Item Categories: The complete set of categories of the items in someone's order.
    ex: t-shirts, mens, pants and sale
  • Item Count: The number of items in the order.
    ex: 2
  • Currency Code: The specific currency paid for an item based on country.
    ex: USD, EUR
  • Discounted: If this specific item has a discount applied (true/false)
  • Coupon: The coupon code applied
  • Unique Items: The individual item created in an order.
    ex: shirts, shorts. If multiple products are ordered, the unique item will only display once
  • Unique Item Categories: The categories unique items are grouped in.
    ex: mens, sale
  • Attributes (optional): Custom product attributes

Ordered Product

This event is tracked when a customer places their order and one 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 is tracked and two Ordered Product events -- one event for the t-shirt and one event for the pants.

The Ordered Product 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: Total price of item (does not include shipping costs or any discounts taken).
  • Name: The name given to this specific item.
  • SKU: The specific SKU assigned to track an item.
    ex: REDMEDIUMTSHIRT
  • Categories: The complete set of the collections of the products in someone's order.
    ex: t-shirts, mens, pants and sale
  • Price: The dollar value of the specific product
    ex: shirts 25.50, shoes 50.25
  • Cost: The cost to make a product.
    ex: shirts 13.85, shoes 20.00
  • Currency Code: The specific currency paid for an item based on country.
    ex: USD, EUR
  • Discounted: If this specific item has a discount applied (True or False).
  • ProductID: ID of specific product in your store.
  • Quantity: Quantity ordered.
  • Attributes (optional): Custom product attributes.

Fulfilled Order

This event is tracked when you mark an order in your Magento store as shipped. 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 Fulfilled Order events based on the following criteria:

  • Value: Total value of the order (sub-total + shipping cost - any discounts)
  • Items: The names of the products in someone's order. For example, t-shirt or pants. If ordered multiple times will show multiple of the same item
  • Item Categories: The complete set of categories of the items in someone's order. For example, t-shirts, mens, pants and sale
  • Item Count: The number of items in the order. For example, 2.
  • Currency Code: The specific currency paid for an item based on country. For example, USD, EUR
  • Discounted: If this specific item has a discount applied (true/false)
  • Coupon: The coupon code applied
  • Unique Items: The individual item created in an order. For example shirts, shorts. If multiple products are ordered, the unique item will only display once
  • Unique Item Categories: The categories unique items are grouped in. For example mens, sale
  • Attributes (optional): Custom product attributes

Cancelled Order

This event is tracked when a customer creates an order in your Magento 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, images, and variant information so you can use that information in purchase follow up emails.

You can filter and target Canceled Order events based on the following criteria:

  • Value: Total value of the order (sub-total + shipping cost - any discounts)
  • Items: The names of the products in someone's order.
    ex: t-shirt or pants. If ordered multiple times will show multiple of the same item
  • Item Categories: The complete set of categories of the items in someone's order.
    ex: t-shirts, mens, pants and sale
  • Item Count: The number of items in the order.
    ex: 2.
  • Currency Code: The specific currency paid for an item based on country.
    ex: USD, EUR
  • Discounted: If this specific item has a discount applied (true/false)
  • Coupon: The coupon code applied
  • Unique Items: The individual item created in an order.
    ex: shirts, shorts. If multiple products are ordered, the unique item will only display once
  • Unique Item Categories: The categories unique items are grouped in.
    ex: mens, sale
  • Attributes (optional): Custom product attributes

Synced Customer Data

Klaviyo creates a contact from the creation of an existing order, an existing customer record, or when a checkout is started. Klaviyo will create a new Klaviyo Profile for every synced contact, and will populate this profile with the following information:

  • Email
  • First and Last Name
  • City, State/Region, Zip Code, Country
  • Phone Number
  • Magento Account Created (e.g. 2015-05-01 00:00:00)
  • Magento Customer Group (e.g. Wholesale)
  • Magento Store (e.g. US Store)
  • Date of Birth (e.g. 1990-01-01)
  • Gender
  • website_ID will not be pulled
  • Suppressions are not copied into Klaviyo so they will not be in the Klaviyo platform

If you update the customer group in Magento, even after the original profile has been created in Klaviyo, the customer group will update in Klaviyo.

Note

Website_ID will not be pulled. Suppressions are not copied into Klaviyo so they will not be in the Klaviyo platform.

Klaviyo cannot pull custom image locations.

Custom Product Attributes

Custom Product Attributes will not automatically flow into Klaviyo; however you can request Klaviyo to pull in up to 10 custom attributes. To do this, you should collect the custom attribute ID (instructions below) and send a request to Klaviyo Success.

Find the Custom Product IDs in the Magento's Admin panel by going to  Catalog->Attributes->Manage Attributes and clicking on the attribute.

The ID can be found in the url like so: 
647753

Verify Your Synced Order Data

Klaviyo imports all of your Magento data. To verify this, you can compare the number of orders on a particular day with what's in the Magento interface and confirm they match. Click on Metrics in the left sidebar, find the Placed Order metric and click on it. This will take you to the metric chart page and show the last 30 days of data by default. You can see an example of the metric chart displayed below.

Mouseover 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 Magento and you should see they match exactly. If they don't, the most likely issue is your Klaviyo account's timezone doesn't match your Magento timezone. To check your timezone setting, go your accounts page, then navigate to Contact Information > Organization.647754

 

Was this article helpful?
1 out of 1 found this helpful