Programming

Creating Responsive Newsletters with the MJML Email Framework

The process of coding email newsletters sucks! You are forced to use web 1.0 code and have to abide by various platform and device standards. It isn’t a pretty process and definitely a time consuming task, but thankfully, there are groups of programmers who put in a lot of time and effort to create email frameworks that take all of the pain points out of coding an email and make it simple for anyone to take an email from to design to product. For their dedication to helping make everyone's live...
Marketing

10 Excel Keyboard Shortcuts & Tricks for Marketers

A platform that is frequently used by every marketer is Microsoft Excel. This platform is helpful to marketers in a variety of ways with the core purpose of pairing up and analyzing data points from various analytics and marketing platforms. It is an extremely powerful tool and tends to be the most utilized platform for daily data analysis work. With the amount of analysis that is done within Excel, you would think that the majority of marketers would learn keyboard shortcuts and tricks to reduc...
Marketing

Introduction to Web Scraping for Marketers

Over the span of just a few years the digital marketing landscape has evolved into a data-crazed world filled with programmatic marketing products that are aimed at mining data and making bid adjustments based on real time cost-benefit analysis. With the advent of this type of software, businesses have flocked to purchase these solutions in order to reap the exponential lifts that the platforms promise. In some instances these decisions turn out to be a slam dunk, while in other instances the re...
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 ...