Creating a Day Index in Excel and Google Sheets

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 preceding index value and day of the week, but the more this process has to be replicated, the more boring and tedious the task will become. This process is simply not for me as I hate manual excel work. As a result, I decided to take some additional time to

Read More

The Three Best Features of Google Analytics

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 use in these features in day to day work. Filters The “Filter” feature in Google Analytics is used to limit or modify collected pixel data before it is processed and accessible within the view reporting interface or through the API. It is the first line of defense against dirty data

Read More

Better Data Reporting Practices - Benchmarks, Cell References, Notes

A continuation of part one, 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 be no way for you to understand if your business is growing or shrinking. The decision on what type of benchmark you choose should be dictated by the data types being presented in the report. Some commonly used benchmarks regardless of the data types being used are planned goals, previous time period or trailing historical averages. Just make

Read More

Better Data Reporting Practices - Gridless, Grouping, Layout Direction

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 communicate compiled information, but if it is forgotten, then the door is left open to a communication breakdown. If this happens, then it is very likely that misinformed business decisions will happen, voiding the report and potentially hurting a business. In order to prevent this from happening, everything from sheet

Read More

5 AdWords Tips for Beginners

Starting a new AdWords account can be a very daunting task. Foreign concepts and metrics like keyword match types and quality score are not very intuitive to users who are new to digital marketing, making it is very easy to make mistakes and waste money in a short period of time. In a quest to help prevent costly mistakes right from the gate, I have thrown together five important tips for new users to watch for as they navigate through their account creation. 1. Structure is Key AdWords, like any bid-based advertising platform requires a lot of maintenance to limit

Read More

Connor Phillips

Senior Marketing Analyst

ShopKeep

Connor Phillips is a Senior Marketing Analyst located in New York City. He enjoys digging into data and making data-driven marketing decisions. In his spare time he bartends, works on coding and loves to run.