data-analysis

A collection of 7 posts

google sheets

IMPORTRANGE() - Google Sheets Most Powerful Function

| 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

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

Users vs Sessions: Conversion Metric Dilemma

| 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

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