Become a PPC Hero

Join over 34,000 other subscribers and get the PPC resources that best fit your needs as a modern digital marketer. Select your subscriptions to the right.

@SomeSecretJake

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

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.

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.