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.