Jacob Fairclough

Associate Director of Analytics at Hanapin Marketing

Jacob is the Associate Director of Analytics at Hanapin Marketing, a search engine marketing firm focused on generating results through pay-per-click advertising. Find him on Google+ or on Twitter at @SomeSecretJake

Index Match: The Better Alternative to Vlookup

VLOOKUP is one of those functions that makes Excel great. VLOOKUP has its issues though. Don't worry there is an alternative, INDEX MATCH. Not only does it replicate the functionality but has its own perks and bonuses. By the end...

Robust Reporting with Google Sheets Query Function

The reporting steps and examples in this article will assist in automating your own complex report and creating dynamic tables to save your time and sanity.

How to Automate Excel Solver

In this article we’ll go in depth from start to finish covering the concepts and methods step by step. By the end you’ll be able to automate any of your own personal models and scale your analysis.

Upgrade Your Data, Upgrade Your Analysis

It’s easy to hit a rut in your analysis. Problems become stale, questions feel like they will never be resolved, and there isn’t anything left to find in the data. This is where adding extra data sources or facets can help.

Getting a Little Help with Your Bids – ECPC vs CPA Bidding

Beyond standard CPC bidding, Google Ads lets you choose two advanced options, enhanced cost-per-click and CPA bidding. This post serves as a primer to the bidding types.

Starter Projects for New Coders

Knowing what to do can be one of the biggest challenges for new coders. In a previous article we covered choosing a language. Now you’ve made your way around tutorials on variables, loops, and functions but how can you apply it to your job?

Coding for Marketers - Where to Start

Choosing a language can be hard. This article walks you through the three main languages for digital marketing analysts.