A collection of 7 posts
| 4 min read
An underused feature of Google Sheets that I find to be a major reason to use the software over excel (yes I said it) is the IMPORTRANGE() Function. It is a function that doesn’t exist in other spreadsheet platforms and is specifically tied to the collaborative cloud-based capabilities that
| 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
| 4 min read
There is a point in every business's life where an agreement must be made about which visit-based metric, sessions or users, should be used to calculate conversion rates at each step of a sales funnel. This metric is the leading barometer of performance and the first to be scrutinized for
| 6 min read
Data Analysis for Copywriters [//www.slideshare.net/ConnorPhillips3/data-analysis-for-copywriters-58178411] from Connor Phillips [//www.slideshare.net/ConnorPhillips3] 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
| 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
| 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
