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.
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
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.