Data

Data Analysis for Copywriters

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 * SEM (Search Engine Marketing) * Data to Observe * ...
Marketing

Essential Content Marketing Metrics and Dimensions

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 our checkbooks to acquire users by focusing only on driving organic channel traffic, but in reality it is not as easy as it sounds. As search engine technology has evolved into a generation filled with m...
Data

Stop Conducting Single Metric Data Analysis

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 the question that appears is how was this change discovered and measured? Was it discovered from analyzing a single primary KPI metric like revenue? Or was it from careful analysis of underlying metrics that were used to determine reven...

What Does UTM Mean?

UTM The acronym UTM, commonly paired with the word “parameter”, is a data tracking term associated with the process of manually tagging campaign data within Google Analytics. UTM tracking is common practice among marketers and despite heavily reliance on the feature on to understand campaign performance, very few users know what the three letter acronym means and its historical link to the creation of Google Analytics . The following history lesson reveals the words behind the letters, as well ...
Data

Syncing Google Sheets Data to Excel

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 approach and functionality that nearly mimics Microsoft Excel. Formula names are identical, visualizations and pivot tables are possible, and programming for the platform in JavaScript makes it a breeze for ...
Data

Creating and Automating Google Analytics Reports in Google Sheets

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 is a pretty common practice that results in a major waste of time and resources for companies of all sizes. In order to avoid this process and regain the time and resources that are lost...
Marketing

Solutions to Common Campaign Tracking Issues

Custom campaign tracking (or utm tracking), is Google Analytics' URL tagging system that allows collected data to be properly labeled for custom reporting needs. It has been a foundational element of Google Analytics since the purchase of Urchin Software Corporation and is the only way for marketers to reliably tag their custom marketing campaigns. The process of tagging a custom marketing campaign is a fairly simple task, requiring a marketer to append a short query string parameter at the end ...

The Differences in Segmenting Your Data by Users and Sessions

The “Advanced Segments” feature in Google Analytics is a powerful and important tool for marketers of all levels. The ability to look at subsets of your data in an easy and extremely customizable way gives you the ability to analyze trends and audiences in the matter of minutes. The information gained from segmentation allows you to make smarter business and product decisions, but at the same time this information can easily be misinterpreted, resulting in misguided decisions. The most common c...

How to Fix PayPal Referral Revenue Issues in Google Analytics

E-Commerce referral attribution on Google Analytics has had a long history history of misappropriated transactions. While there are many guides out there that depend on a utm parameter to fix the problem, there is unfortunately no guide that can resolve this issue in a manner that can be applied to various use cases. Like many before me, I found many issues with the utm parameter approach and since the public release of Universal Analytics, I figured out quickly that this solution does not work ...
Marketing

Basic SEO Checklist

SEO or Search Engine Optimization, is an online traffic process that provides organic visibility to a website. Where and how you rank on search engines are based on individual search engine algorithms, which serve the purpose of matching what a user is looking for with the most relevant content possible. There is no golden formula to rank number one for every search and best practices change over time as search engine algorithms become more complex. The purpose of this checklist is to not descri...