Data Preparation and Setting up a File

Data preparation is the base of any good analysis. Getting it right from the start will just ensure that any analysis you do in the future, will be nice and easy for you.

I run through a number of different basics, from file naming and why you should follow a pattern, through to how you should be handling your raw data & your dashboards.

There are also a few different ways of setting up the raw data, and how to split your metrics. My personal preference includes a new row for each month across each segment. So multiple metrics could be used on the same row, however each row could be a different traffic source, or a different site section.

2 Comments

  1. Great ideas!

    I use all of these, especially the RAW tab,

    Re: Filenames
    I prefer to have the date first: Example: 10 Dec 2016 = 20161210

    Reply
    • The only bad thing about doing that date like that is that windows will sort the files alphabetically, which would be lower to higher or higher to lower numbers. With the first day of the date changing from 1 to 31 each month, you’ll end up with everything grouped based on the day.

      But throwing it in the format I mentioned, it’ll group them based on year first, then month, then day.

      Unless I have miss understood you and you do use the format I use, except you just put it at the start haha.

      Thanks,
      Sam.

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

Download the Keyword Categorisation Template!
  You will receive a download link via email. We hate spam and never share your details.
Download the Google Analytics Dashboard
  You will receive a download link via email. We hate spam and never share your details.