A collection of 6 posts
| 6 min read
A fun challenge that I faced a few days was creating a weekday/weekend day index in Google sheets to count and index the number of weekdays/weekends in a month. This might sound like something easily achieved by placing a static value next to the date based on the
| 5 min read
This blog is geared toward the novice Google Analytics users who feel overwhelmed by concepts like filtering, segments and customs reports. My hope is that by the end of this post, I will be able to provide you with enough context on these concepts to give you the courage to
| 3 min read
A continuation of part one, [Better Data Reporting Practices - Gridless, Grouping, Layout Direction](http://www.connordphillips.com/2017/02/08/better-data-reporting-practices-gridless-grouping-layout-direction/). Use Benchmarks This tip should be a given, but if you are not comparing your performance against some historical time series or relevant benchmark metric, then there will
| 5 min read
One of the most overlooked elements of reporting is data presentation. It is an afterthought compared to core reporting elements like data compilation and analysis largely due to its focus on aesthetics rather than computation. This focus may seem irrelevant to the general purpose of a report, which is to
| 3 min read
Understanding how the user metric is measured in Google Analytics (GA) is a more complex process than its straightforward definition. In layman’s terms, a user, is a person who has visited a website within a reported time frame. Where this understanding gets more complex is when reporting criteria is
| 7 min read
Manually populating spreadsheets with Google Analytics data on a weekly or daily basis is a time consuming task.The typical report building format follows the uniform process of generating a custom report, exporting that data to an excel format and then pasting the values into a customized reporting format. This
