IMPORTRANGE() - Google Sheets Most Powerful Function

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 Google Sheets has to offer. Pass a Google Sheet Url ID and a specific range within that sheet to the function and next thing you know, the content of those cells appear in your current sheet...Wow, how amazing, right? Probably not spectacular or useful at first, but when you

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

Users vs Sessions: Conversion Metric Dilemma

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 drops in performance. While it may seem like a schoolyard debate that ultimately has no major impact on business performance, standardizing one metric for reporting and understanding the differences in how they are calculated will assure that data is consistent across all reports and ensure that any performance changes are

Read More

Data Analysis for Copywriters

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 Quality Score Ranking Dimensions/Metrics of Interest Key Takeaways Slide 4 Why Does Data Matter? Importance Improves Decision Making Accuracy The power of data analysis is that it improves the probability of making successful decisions by examining historical evidence. This evidence comes in the form of quantitative and qualitative data.

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.