Jacob Fairclough
PPC Hero
Atlanta, GA, United States
Contact Jacob
Discover and connect with journalists and influencers around the world, save time on email research, monitor the news, and more.
| Recent: |
|
| Past: |
|
Past articles by Jacob:
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. → Read More
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. → Read More
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. → Read More
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. This is where adding extra data facets can help. → Read More
Getting a Little Help with Your Bids – ECPC vs CPA Bidding
Explore two advanced options available in Google Ads beyond standard CPC bidding - Enhanced CPC (ECPC) and CPA bidding. → Read More
Coding Languages for Marketers
Choosing a language can be hard. This article walks you through the three main languages for digital marketing analysts. → Read More
Updating Bids and Monitoring 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! → Read More
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. → Read More
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. → Read More
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. → Read More
How to Automate Excel Solver
In this article we'll automate Excel Solver from start to finish. We'll cover 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. → Read More
Automating Bidding with Google Sheets and AdWords Scripts
Explore how to set up an automated bidding system using Google Sheets bulk upload and AdWords scripts to format and post bid changes directly to AdWords. → Read More
Projecting Future Trends In Your PPC Account
Projecting an account's trajectory is a vital skill for every account team. You can't escape it. It comes up when performance is great and it comes up when → Read More
How To Utilize Excel Data Tables For Better Projections
Excel data tables allow you to quickly compare values and run calculations multiple times. This overlooked tool will help you quickly determine these → Read More
Use AdWords Scripts To Update Negative Placements
In this article, we'll show you how to use an AdWords script to implement negative Display Network placements. → Read More
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 → Read More
Using Google Sheets To Modify AdWords Scripts
Learn how to use Google Sheets to make AdWords script adjustments via spreadsheet rather than through the code itself. → Read More
How Often Does Google Search Match to Demographics?
Google publicly rolled out demographic targeting for search in the fall of 2016. This feature allows advertisers to segment data and adjust bids based on gender → Read More
Extracting Text in Excel for PPC
Working with text data is a necessary part of analysis but often overlooked in skill development. This leaves gaps in analysis and adds time and tedium to → Read More
Using Google Sheets To Modify AdWords Scripts
Learn how to use Google Sheets to make AdWords script adjustments via spreadsheet rather than through the code itself. → Read More