Jacob Fairclough

Director of Analytics at Brainlabs

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

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.

How to Validate Marketing Tags and Pixels

In this article, a Director of Analytics covers how to check which tags exist on a site, which information is sent, and proper tag setup.

Accounting for Future Performance in Paid Media

Changing circumstances can force you to confront the future. Planning ahead is essential and can better prepare you for what comes next.

Taking Advantage of MCC Scripts for Multi-Account PPC Efficiency

Working at the account level can be restrictive. MCC level scripts provide a solution for handling many accounts to scale further and work more efficiently.

How To Get More Out Of Excel Solver

Excel Solver is a fantastic tool, but most examples only cover simple marketing use cases. We’ll cover the next steps of enhancing your models and how to automate the process.

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.