Review and Understand your Magento 2 Data

read

Overview

Klaviyo's integration with Magento 2 pulls in all of the historical data in your Magento 2 store 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 2 icon are the ones synced from your Magento 2 integration.

The Magento 2 Metrics

This section covers each of the Magento 2 metrics and the data that is available for filtering when creating segments and flows.

Cancelled Order

This event is triggered when an order status is changed to Cancelled in your Magento 2 store.

  • ProductCategories: The categories of the products in the cancelled order.
  • Value: The value of the cancelled order.
  • Discounted: (True or False) The discount state of the cancelled order.
  • ProductNames: The names of the products in the cancelled order.
  • ItemCount: The number of products in the cancelled order.
  • OrderCurrencyCode: The currency code used with the cancelled order.

Fulfilled Order

This event is tracked when you set an order status to Fulfilled in your Magento 2 store.

  • ProductCategories: The categories of the products in the order.
  • Value: The value of the order.
  • Discounted: Whether the order is discounted or not.
  • ProductNames:The names of the products in the order.
  • ItemCount: The number of products in the order.
  • OrderCurrencyCode: The currency code used with the order.

Fulfilled Shipment

This event is tracked when you set an order status to Shipped from your Magento 2 store.

  • Shipping Address: The shipping address for the order.
  • StoreName: The name of the store where the order was placed.
  • StoreID: The ID of the store where the order was placed.
  • BillingAddress: The billing address for the order.

Ordered Product

This event is tracked once for every product a user orders when they place an order.

  • SKU: The SKU of the product.
  • OrderCurrencyCode:The currency code of the product.
  • Price: The value of the product.
  • Categories: The category of the product.
  • Discounted: Any discounts applied to the product.
  • Quantity: The number of products.
  • Value: The value of the product.
  • ProductID: The ID of the product.

Note

Ordered Product metric has a number of other data fields available for tracking. View the raw data of an individual Ordered Product event to see all of the available data for this event.

Placed Order

This event is tracked when a user places an order.

  • ProductCategories: The categories of the products in the order.
  • Value: The value of the order.
  • Discounted: Whether the order is discounted or not.
  • ProductNames:The names of the products in the order.
  • ItemCount: The number of products in the order.
  • OrderCurrencyCode: The currency code used with the order.

Started Checkout

This event is triggered when a customer who's email address is known begins a checkout. On a standard checkout page this event is triggered when a customer enters their contact and shipping information on the first page of the Magento checkout process and clicks continue.

  • Value: The value of the order during the checkout.
  • ItemCount: The number of items in the order during the checkout.
  • ProductCategories: The categories of the products in the order during the checkout.
  • ProductNames: The names of the products in the order during the checkout.
  • StoreName: The name of the store where the order was placed.
  • StoreID: The ID of the store where the order was placed.

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

If you update the customer group in Magento 2, 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.

Verify Your Synced Order Data

Klaviyo imports all of your Magento 2 data. To verify this, you can compare the number of orders on a particular day with what's in the Magento 2 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.

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