Experience Profile Commerce tab
The Sitecore Experience Profile application contains reports that display the data gathered by Sitecore Commerce Connect. After you install the Sitecore Commerce Connect module, the Experience Profile contains an additional Commerce tab and six subtabs.
These subtabs contain reports that are independent of the external commerce system that is being used. The data used for the reports comes from the page events, goals, and outcomes that are triggered by Commerce Connect when a customer visits the storefront.
The Experience Analytics reports are only available in Commerce Connect version 9.0.2 and later.
Overview
The Overview subtab displays the aggregated order and abandoned cart metrics that represent the key performance indicators (KPI) for both turnover and potential missed sales opportunities, including:
-
Total value
-
Average value
-
Number of orders / abandoned carts
-
Number of unique products
-
Total number of products
-
Frequency of orders / abandoned carts
-
First order placed / First abandoned cart
-
Last order placed / last abandoned cart
The report contains every recorded interaction that the current contact has made.
Orders
The Orders subtab displays a complete history of the orders placed by the current contact including the order history and order details of each order.
To see the order details of an order, select it and open the Order Details report.
On the right-hand side of the Order details report, you can see the individual order lines, the shipping and billing information, and adjustments. Adjustments are the different types of charges and discounts that affect the entire order as well as the individual lines.
If no value is available, two dashes are displayed.
If you move the mouse over an individual order line, a tooltip displays additional information, such as reductions, charges, inventory status, and so on.
If you move the mouse over the individual shipping and billing information lines, a tooltip displays the billing or shipping information, and the cart line IDs.
The list of adjustments includes the charges and reductions that were applied to both the entire order and the individual order lines. In the Adjustments list, the Line ID column can contain a value that refers to the corresponding line in the Lines list. Otherwise the column is left empty.
Products
The Product subtab displays three lists – Products viewed, Products added to cart, and Products purchased.
Each list contains information about the:
-
Product ID
-
Product name
-
Price
-
Recency
-
Number of times the product was viewed
-
Number of times the product was added
-
Number of times the product was purchased
This indicates the level of interest that the contact has shown in the individual products.
You can reverse each column's sort order to see the products that the contact is least interested in.
Missed sales opportunities
The Missed sales opportunity subtab shows you a list of the products that the contact visited or added to a cart but did not purchase. These are grouped by product ID and sorted by the number of times the product was added to a cart. This indicates the level of interest that the contact has shown in the individual products.
The report focuses on products and a shop owner uses it to find those products that contacts most often look at or add to carts without purchasing. The shop owner can use this information to plan discounts and promotions to make the contact finalize the purchase.
Abandoned carts
In Commerce Connect 9.x, the Abandoned Cart marketing campaign does not trigger the Abandoned Carts outcome. Therefore, the Abandoned Carts report does not show any data.
The Abandoned carts subtab displays the complete history of abandoned carts and the details of each individual cart is available in a popup window. The default engagement plan specifies that a cart is considered abandoned after three days. The list is sorted by date in descending order by default.
Click a row in the list to display the abandoned cart details.
The Abandoned Cart Details list contains information about the cart, such as the status, subtotal, sales tax, reductions and shipping costs. You can also see the shipping and billing addresses for the abandoned cart.
On the right-hand side, you can see the individual cart lines, the shipping and billing information for the individual cart lines and any adjustments that were made. Adjustments are every kind of charge and discount that affects the entire cart as well as the individual lines.
If you move the cursor over a cart line, a tooltip displays additional information about that cart line, such as reductions, charges, inventory status, and so on.
If you move the cursor over a shipping or billing information line, a tooltip displays additional information, such as the billing or shipping information and the cart line IDs.
Shopping cart activity
The Shopping cart activity subtab shows you all of the shopping cart activities, including lines removed, lines added, and lines updated. The activities cover sessions, interactions, and shopping carts. This report gives you an overview of what products the contact is interested in over a period of time, as well as and the products they considered buying but for some reason did not.