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.
It’s back to basics time!
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.