Sitecore Experience Commerce 9 – Reporting

With the release of Experience Commerce 9.0.2 you now get a whole heap of Commerce specific analytics data collected for you out of the box. This comes in the form of aggregated reports covering overall activity on your site, and also individual user level reporting allowing you to drill down and see how each of your individual users are interacting with your site. So let’s take a look at each of these now.

Experience Analytics

When you head to Experience Analytics in Sitecore you should quickly see the new Commerce panel on the left. You still get all of the standard reports you know from the Sitecore Experience Platform but they’re now being augmented with an entire section dedicated purely to Commerce. To get an overview of the features that Experience Analytics provides in the platform you can checkout out our doc site. In this post we’re going to focus purely on the Commerce section.

The first area you get in the Commerce panel, is the Overview section. This is there to give you a series of reports allowing you to quickly get some key metrics on how your site is performing. You’re instantly presented with data on the Number of Orders, Total Order Amount, Bestsellers, Most Viewed Categories & Registrations.

These are some great metrics that can give you a high level overview of how the site has been performing in the timeframe selected, but you get a lot more data than just this. Below the Overview section you will also see sections for Orders, Campaigns, Products, Categories, Customers, Shopping Cart Activity, Filtering and Sorting, Regional Settings, Internal Search, Payment and Shipping, Wish list activity & Loyalty programs. Each of these sections contain a series of reports. For example if you look at the Products section then you will get reports on the amount of products viewed, which products are viewed most, and which are your best sellers. If you look at the Customers section then you’ll get reports covering the registrations on the site, the top customers by order total and number of orders.

All in all you get over 40 commerce-specific reports detailing all of the different interactions that your users have had with your site. That combined with the standard reports you get with the Sitecore Experience Platform, gives you a wealth of insight into how people are actually using your site and what you can do help drive more revenue from it.

Experience Profile

As I mentioned above you don’t only get the high level analytics seen in the Experience Analytics section, you can also drill down into every one of your users to see all of their individual interactions with your site. With the release of 9.0.2 you now get an entire Commerce section showing all of the commerce-specific interactions that a user has made with you.

When you load up the details for one of your contacts in the Experience Profile you will soon see that, much like with Experience Analytics, there is now a Commerce tab present. 

The data within the Commerce section is again split into different sections. When you initially click on it you will be presented with the Overview section that shows you some of those more commonly needed data, e.g. how many orders a contact has made, when their last order was along with other key data.

These are some great initial data points for the contact, but the other tabs will give you much more detail. You have tabs covering Orders, Products, Missed Sales Opportunities, Abandoned Carts, and Shopping cart activity. These give you detailed information about what orders the contact has placed, which products were in the those orders, which products the contacts has added & removed from their cart, amongst other things.

This commerce data really complements the existing reporting present in the Sitecore Experience Platform, giving data on commerce-specific site interactions from a macro view in Experience Analytics all the way down to a micro view in Experience Profile. This gives your merchandisers & marketers a series of powerful dashboards and reports right at their fingertips to help them identify patterns and trends in how your site is being used.