data

A collection of 8 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

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

analytics

Data Analysis for Copywriters

| 6 min read

Data Analysis for Copywriters from Connor Phillips Slide 3 Why Does Data Matter? Importance Content Data to Observe Acquisition Data Pageview Data Dimensions/Metrics of Interest SEO (Search Engine Optimization) Data to Observe Keyword Rankings Backlink Data Dimensions/Metrics of Interest SEM (Search Engine Marketing) Data to Observe Acquisition Data

analytics

Essential Content Marketing Metrics and Dimensions

| 4 min read

A big component of successful marketing in 2016 is having a good content strategy in place. Content strategy is the key to acquiring free users through organic search engine rankings, which is a crucial element of keeping acquisition costs down. We would all enjoy a scenario where we avoid using

analytics

Stop Conducting Single Metric Data Analysis

| 4 min read

Running a business day in and day out is a lot of work. Each day poses a new challenge and decisions have to be made in order for the business to generate revenue and remain operational. When one part of the business veers off course everyone feels the impact and

analytics

Syncing Google Sheets Data to Excel

| 4 min read

Google Sheets is a popular collaborative spreadsheet platform that has become a legitimate threat to Microsoft Excel’s market share over the past few years. Part of the reason why the platform has made such an unprecedented rise in a short period of time is because of its cloud-first product

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