Monday, April 30, 2012

The first 5 things you should know about SiteCatalyst

"Hi Alec, with your help we've just successfully put SiteCatalyst on our website. My development team say that the data is being collected so can I use it now?" says my imaginary client.

"Sure." I say "Have you ever used SiteCatalyst before?"

"No, sorry!" comes the reply

"Ah." Time for a rethink "But you have used a web analytics tool before, haven't you?"

"No, sorry!" comes the reply

"Well in that case you should read my blog post on the first five things you should do in SiteCatalyst!" - I love nothing than a bit of self promotion with the clients.

"I didn't know you'd written one!" says my erstwhile client

"I'm writing the rather convoluted introduction to it now!" I say.

1. Understand the different types of data points

There are four different types of data in SiteCatalyst and they all have rather ridiculous names:

  • Traffic Variables: Traffic variables allow you to set a value on each page. Want to know how many times a certain page has been viewed? Traffic Variable. Want to know how many times a banner has been viewed? Traffic Variable. Want to know what search term users typed in? Traffic variable. You have a somewhat limited list of metrics that you can use, but I'll come on to that later.
  • Conversion Variables: Conversion variables aren't very well named. These aren't the variables that convert, these are the things that get converted. Want to know advert people saw on your site before buying? Conversion variable. Want to know what campaign people came from before signing up to your newsletter? Conversion variable. Want to know how many product pages people viewed before requesting more information? Conversion variable.
  • Events: Events are the things that convert against each of the values in your conversion variables. Events are the buying a product, signing up to the newsletter and requesting more information. You can put them wherever you want. You could put one on every page and call it Page Views (we do this sometimes).
  • Product Variables: Products are the things that people bought, the newsletter that they signed up to or the information that they requested. They're related directly to the event itself, how many of them there are and how much it cost.
Of course these variables each have their own 'standard' set ups and their own custom ones. When it gets set up the custom ones can be any way you want them to be, named anything you want them to be and put into the menu structure anywhere, so you may not know what they are.

2. Understand Metrics

Metrics are something that are almost always independent to any system and knowing what the metrics mean is vitally important. As is knowing what you can do with each of them:
  • Page Views, Visits and Visitors. These are your staple metrics for traffic variables. Page Views tell you how many times something has happened. Visits tell you whether it happened for a user in their session or not. Visitors tell you how many people did it.
  • Entries, Exits, Single Access. These metrics all relate to a visit. An entry is where it was the first time that a value was created in that variable, an exit is the last time that a value was created in that variable and single access is where only one value was created in that variable. In some variables these metrics make sense, in others they don't. For example having an entry page, an exit page and only viewing one different type of page in a visit makes sense. Having an entry search term (the first search term the visitor does in their visit), an exit search term (the last search term a user does in their visit) and single access search terms (the only search term that a user does in their visit) doesn't make sense.
  • Instances, Searches, Events. These are your staple for conversion variables. Instances are the number of times something happens and are analogous to page views. In your external search reports the guys at Adobe have decided to rename instances as searches (to confuse you). The events, as we discussed before, convert against the variables. They don't have to happen on the same page, but remember that you can set how long you want your conversion variables to persist for. Events will also convert against the product that they are set up for.
  • Calculated Metrics. This is where it gets a bit more complicated. You can use any of the above (within reason, obviously) to create your own metrics which you can call anything you want.


I've said this before, but there aren't really any standard reports in SiteCatalyst. You're mission, should you choose to accept it, is to create as many reports as you can using the above variables and metrics. Then you need to change something on your site and see if the data gets better.

3. Comparing Dates

There are two ways you can look at data over time in SiteCatalyst. You can compare two time periods or you can trend a variable over time.


By choosing the comparison chart you will be able to see all your variables and more than one metric if you want, as well as the difference between them. It's a useful tool in some situations where you know when something changed on the website.

In other cases you might want to see how something changed over time without knowing whether there was a change in the site at some point. For this, you need to use a trended view.


The downside of the trended view is that you can only have one metric at a time and you can only have five items at a time. Obviously you can change the metric and you can change the items as well, but it is a limitation.

You can also decide how to have your chart. Do you want each data point to be one day or do you want it to be a whole week? That's an option that you can choose at this point. Having the data daily is a pain if your site has big drop offs at the weekend - you won't be able to see your trend at all!

4. Do stuff with your reports

Right, so you've got the reports that you want to see. How do you get them out of SiteCatalyst so that you can show them to your boss?

This is where you need to make use of the icons at the top of the page.


From this point you can download your report in a number of different formats or if you don't want to have a middleman you can email it directly to the person who would like to see it.

Of course the next step is to automate your report to send it on a regular basis once you've decided that it is 'the one'. You can do this in the email options by choosing to deliver it for a later date in the advanced delivery options.

If you want to get to the report again so that you can check it in the future, you can add it to a bookmark (it will then appear in your 'favourites' list in the top left hand corner).

Or if you have a number of reports that you want to group together you can add it to a dashboard. You can then create a little pdf booklet of reports that you can send to someone. The SiteCatalyst dashboard creator is really easy to use as well.

5. Sit back and bask in your glory

Of course the last step is not to sit back and bask in your glory at all.

The last step is to use this information to make your site better.

Data is nothing if you don't do anything with it. All you've done is waste your time getting it in the first place. You need to use the data in two ways:
  1. Work out what you should be changing. The data will help you decide what parts of the site are working and what parts aren't so that you can focus your efforts
  2. When you change something on the site, in your marketing or in your pricing you can see the effect of that change in real data
By doing these two things you'll be making your website data driven. You won't make lots of changes on parts of the website where they won't have any effect and you'll be able to learn from your mistakes.

Oh yes, you'll make mistakes when you change your site. Part of the trick is being able to spot them.

Friday, April 20, 2012

5 tips for SiteCatalyst Report Builder

I promise that the posts about SiteCatalyst detail are going to stop in the next few months in favour of more online featured posts, but today I thought I'd do a little bit on Report builder. For those of you who weren't aware, Report Builder was actually a HBX tool before the 'merger' with Omniture. Previously Omniture customers were used to using Excel Client, which isn't quite in the same class as Report Builder.

Excel Client is one of those oddities - almost all SiteCatalyst people will be able to use it if they want to. It is, however, slightly outmoded because of the dashboard features that you have in SiteCatalyst that you didn't in HBX. SiteCatalyst itself has much more functionality than HBX does (or did - is there anyone still left on it?), so Excel Client, as I wrote last time, is a little disappointing. With Report Builder you always felt that you could do more than you could in HBX and it was more malleable; With Excel Client you could do just about the same or less and it wasn't malleable at all.

So Report Builder in SiteCatalyst should be brilliant, should it not? Well it is and it isn't. There are things that you can do in report builder that you'd never have been able to do in SiteCatalyst because you can do all the stuff that you can do in Excel alongside it, plus you can have multiple requests in a worksheet. Here are my top tips:

1. Create a Lookup from one report to another

How many times have you created two reports in Excel and then used a VLookup to get the values from one into the other report? Far too often? This is where Report Builder comes into its own, because you can use your second report as a lookup from the first one.

So for example I want to create a report that shows my site sections and how many visits they get, along with the entries and the bounce rate. Simple? Not on your nelly, unless you have hundreds of segments set up.

I've set a custom traffic variable (prop) to be the site section though, so I can get visits for it, but I can't get entries, single access or exits because I don't have pathing enabled (and those variables don't mean the same thing when it comes to props anyway). I do however have the site section as part of the name of each page.

So I create one report which shows me the top 10 site sections and the visits. I then create another report with a filter attached that looks for the first value as such, with a large number of rows, so that we capture everything.


We then add in entries and single access as metrics and choose a custom layout. We hide the page names (although the filters will still apply, we just don't want them on the page) and make the metrics be the sub totals and apply them to the next two fields.


This now gives us two new cells which will show the total entries and single access for all of the top 1000 pages with that site section name in it (don't forget that you can add up entries and single access because they don't need to be deduplicated - they only occur once per visit).

The next step is a simple copy and paste (using the tool) for all of other sections:


Don't forget that you'll need to do a refresh of the requests to get the actual data!

2. Create requests with different date ranges

As well as being able to use the fixed dates (eg April 2012, 10th March - 14th March, Q1 2011, etc), rolling dates (last week, this week, last month, etc), preset dates (a combination of fixed and rolling!) and using cells to set date ranges (so that you can copy and paste as above or just simply change the date range on a whim), you can also use custom expressions.

The custom expressions don't really make sense to start with until you start playing with them. The way they work is that you can choose a start and end date based on expressions of the current day, week, month, quarter, year.


  • cd is the current day
  • cw is the current week (starting on a Sunday)
  • cm is the current month (starting on the first)
  • cq is the current quarter (starting on the first of the quarter - Jan, Apr, July, Oct)
  • cy is the current year (starting on the first)
So if you want to run a report for last month you have a start date of 'cm - 1m' and an end date of 'cm - 1d' (this would show you from the first of the month before the current one to the day before the start of the current month).

This allows you to do lots of rolling time periods that you might not ordinarily be able to do using SiteCatalyst. Eg if you're in the financial sector and your weeks run from Thursday through to Wednesday you can have a report that reflects this by creating a report with the date range:
cw - 1w - 3d to cw - 1w + 3d   (effectively last Sunday minus three days to last Sunday plus three days) 
This handy ability allows you to manipulate SiteCatalyst to run reports on the date range the rest of your company wants to, rather than the way it wants to. With the implementation of the 'visitors' metric in version 15 (rather than daily, weekly, monthly, etc) means you can go any way you want with dates.

3. Create trended reports for multiple metrics and different values of a variable

A pet hate of virtually everyone who has used SiteCatalyst is that when you turn your data into a trended report you can only have 5 variables at once and you can't have more than one metric! Arrrgggghhhh!

You obviously have more flexibility in Excel because you can put your metrics on different axis to create more exciting reports.


By creating these reports like this you can do lots of different things with them, including graphing them over time, showing percentage increases over time, etc, etc.



Those additional graphs that normally would involve you creating several reports in SiteCatalyst for, downloading and then playing around in Excel with are a huge time saver.

One of my favourite things is the the 'sub total' part that we discussed in the first part. By giving page names sensible titles based on their hierarchy I can create filters based on common site sections or content types then you can create entries and bounce rates and so on really easily.

4. Create a filter for your search terms to exclude your brand

When I talk about SEO metrics (which I do quite often), I often talk about measuring search minus brand. It's a big metric for me because I think that you should be ranking for your brand search terms anyway, so by looking at this metric you are discovering how well you rank for your products.

This is of course very easy using report builder, especially when you want totals to report to your management.

Create a report for your search keywords, add in a filter for your top 10,000 (or however many) that removes any 'brand' keywords and then use the sub total option to give you the visits, revenue and so on that you have generated for non-brand related keywords.



Then run it alongside one that has brand related keywords to show how well your brand team are doing!

5. Use your Sub Relations to create filters

I know in the sitecatalyst version 15 you can create filters anyway using the segment builder option. But using the ability to show sub relations in Report Builder is really good considering you can hide the options.

So for example I want to know what channels people were in when they bought stuff arriving at the site through non-branded search terms (or branded, whatever). I can create a report that has the primary dimension of the non-branded search terms using the filter we created earlier and the secondary dimension of the channel the user was in.



By hiding the search terms and using sub totals again I can easily see where people were. In fact, using tip number 1 above, I can use this to compare the revenue through the channels in total with the revenue that came through the search channel.

Here I have really just combined three of the separate reports. Now if I only could come up with a way of combining the other two into this last tip as well...


 
Blog Directory - Blogged