reporting

A collection of 6 posts

excel

Creating a Day Index in Excel and Google Sheets

| 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

google analytics

The Three Best Features of Google Analytics

| 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

Data

Better Data Reporting Practices - Benchmarks, Cell References, Notes

| 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

Data

Better Data Reporting Practices - Gridless, Grouping, Layout Direction

| 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

google analytics

Google Analytics: How are Users Measured?

| 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

google analytics

Creating and Automating Google Analytics Reports in Google Sheets

| 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