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

Update Bids and Monitor Changes with AdWords Scripts

Explore different ways to use Google Sheets and AdWords Scripts to change bids and handle uploads. Get started with creating your own bidding system!

Up and Running with AdWords Add-on for Google Sheets

In this article we will set up for the AdWords add-on for Google Sheets. By the end you'll set up your own reports and automate the data gathering portion of your workflow.

Analyzing the AdWords Distance Report

The distance report provides a unique view of your geographic data. The report helps users understand how distance from a location impacts search ad performance.

How To Use AdWords Geographic Data Reports

AdWords geographic reports provide performance data by location. This data is vital to identifying efficiencies and growth opportunities. In this article we will cover the three main rebuilt reports in AdWords and cover their uses.

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.

Automating Bidding with Google Sheets and AdWords Scripts

In this article, we’ll cover setting up an automated bidding system using both Google Sheets and AdWords scripts. Specifically, we’ll utilize the bulk upload functionality to format and post the changes directly to AdWords.

Projecting Future Trends In Your PPC Account

Projecting the trajectory of a PPC account can be extremely helpful. Get tips on utilizing certain methods to make better decisions for your accounts!