Creating an OMS Profile Score Report

Introduction

Sitecore Analytics has a number of existing reports that can be used out of the box, such as Top Landing Pages and Latest Human Sessions. Although you can modify existing reports, you may also encounter cases where you’d like to create a new report from scratch.

The aim of this blog post is to demonstrate how to create a new report. As an example, I’ll create a report that lists the highest scoring organizations for a single profile key on the Nicam Web site.

On the Nicam site the profile Skill Level has the following profile keys:

· Beginner

· Amateur

· Semi-pro

· Professional

This report will display a top 20 list of organizations that scored the most for the Semi-pro profile key. In other words the top 20 organizations that have shown the most interest in content related to semi-professional photography.

A report like this could help sales people or marketers to determine which organizations should be targeted in future sales and product promotions.

To create this report I used the Nicam site and the Windows Report Designer client from Stimulsoft. Download the Report Designer here: http://www.stimulsoft.com/Downloads.aspx. Choose the following product from the download page: Stimulsoft Reports.Net 2009.2 for Visual Studio 2005, 2008.

When you have worked through all the steps in this blog your report should look something like this.

Creating a Profile Score Report

To create a profile score report, you need to complete the following steps:

1. Create a new report

2. Create a data connection

3. Understand the Database structure

4. Create a data source

5. Create a SQL query

6. Design the layout of the report

My next post: Step 1 – Create a New Report