Travel Guide to Built-in Reporting

Taking a journey without a good guidebook can be exciting and scary all at the same time. Having completed a look at the journey our data moves through from collection, squeezed through formatting to arrive at reporting, I figure we should have some more detailed guiding points (the cheap man’s guide book) as to what we can ‘do’ on the journey.

If you are looking for some guidance on the Sitecore provided reports and screens checkout there excellent walk-throughs over at

Dimensions + Filters = Segments

Travel Guide Image Segments

When talking about the tables and charts that are combined into the reporting dashboards of Experience Analytics (xAnaltyics) the data is shown based on “Segmentation”. In marketing terms, a segmentation is a targeted subset of the general visitor base to the website. Sitecore’s reporting is built on this idea as its purpose it to allows us to best focus the visitor experience to further foster long term engagement with them.

A major point of confusion for my users has been the re-use of the concept of ‘segmentation’ in the context of Email Experience Manager (EXM) and xAnayltics. Grammatically the use of segmentation is the same in both contexts, but they are configured and maintained separately. Thus it has to be clearly shown and explained that just because there exists an email segment called ‘High Caffeine Drinkers’, the same named segment in xAnayltics possibly do not report on the same group of visitors. [With proper setup and management is possible for these to be exactly the same.]

Every request to the Reporting Services API requires the Sitecore ID of a segment item. A segments are defined in the Marketing Control Panel as children of a dimension.  In this context, ‘dimensions’ define what fact the data will be summarized on, such as goals or page URL. New dimensions can be added to the system by a developer.  Once the proper dimension is selected, and the new segment item is created, you will apply a filter to the segment.

Filters use the Sitecore rules engine to define condition(s) that a data point must meet to be summarized for a segment. Filters can be defined once and used across many different segments, depending on the dimension the segment is summarized on, the filter may not provide any data to be calculated.

Steps to Creating Custom Reporting within Sitecore

There are number of steps that must be accomplished to get us to the point of either enhancing the out-of-the-box tables and charts in xAnalytics or creating our own tables and charts to answer business specific questions.

To provide context for the review of what is needed, we will use the Paragon Coffeehouse demo site built to reflect an ecommerce experience. (Note, there is no real ecommerce backing the site, just the appearance to help facilitate an experience for testing Sitecore specific elements.)

We will assume the business would like to understand what page a visitor who has completed an order for coffee entered the site on. This will help them to gauge elements a successful landing page should contain to increase order volume.

To do this there are four major steps that will be explored

  1. <a href=”To: Guide to Creating Dimensions and Filters”>Create New Dimensions</a>
  2. <a href=”To: Guide to Creating Dimensions and Filters”>Create New Filters</a>
  3. <a href=”To: Creating Dimensions and Filters”>Create New Segment</a>
  4. <a href=”To: Creating Dimensions and Filters”>Applying the New Segment</a>