Jacob Fairclough

  • How To Utilize Excel Data Tables For Better Projections

    September 8, 2016 We’ve all been in a situation where we needed to see the results of an equation based on a range of values. Maybe it was “what if we spent X amount or Y amount” or “what are the potential impacts of another ad test?” Calculating by hand is slow and cumbersome. Thankfully, data tables allow you to quickly compare values and run calculations multiple times.

    Jacob Fairclough/ PPC Hero- 6 readers -
  • How To Get More Out Of Excel Solver

    July 18, 2016 Excel Solver is a fantastic tool, but most examples only cover the simple marketing use cases. Leaving the advanced usages to your imagination with no clear path forward. In this post, we’ll cover the next steps of enhancing your models and then cover how to automate the process. The post focuses on the more technical aspects of Excel but will remain fully accessible.

    Jacob Fairclough/ PPC Hero- 10 readers -
  • Google’s Inclusion Of Buy Button A Game Changer For Retailers

    Last week news broke regarding Google’s plan to include buy buttons for mobile devices. These buttons would allow searchers to directly purchase a product from the search engine results page (SERP). This change is a significant departure, as users are no longer required to follow this process: Leave the SERP ——–> Go to the retailer’s site ——> Complete the purchase ...

    Jacob Fairclough/ PPC Heroin Paid Search- 9 readers -
  • Benefit From Better Search Functionality In AdWords Editor 11

    Google recently launched version 11 of AdWords Editor. Besides feature updates, the editor received an overhaul to the search functionality. Although it takes a little time to get back up to speed with the rearrangement, I’ve fallen in love with the new functionality and search bar. It takes the set up out of the menus and puts it rights back in your hands.

    Jacob Fairclough/ PPC Heroin Paid Search- 6 readers -
  • Simple Tips To Enhance Your Excel Spreadsheets

    Every now and then you stumble across an Excel tip or trick that blows your mind. However, this won’t always be the case and as your skills progress these insights are harder and harder to discover or take more effort than they are worth. Rather than going bigger, it is often much easier to take a step back and recognize little tricks you could try, or actions that lead to ...

    Jacob Fairclough/ PPC Heroin Paid Search Twitter- 6 readers -
  • Using Google Analytics for AdWords Conversion Tracking

    Everyone accepts the tenet that conversions matter. Any successful marketing campaign needs some form of conversion tracking, whether they are sales, leads, or e-mail sign ups. Most often accounts default to utilizing the AdWords conversion code. This simple to implement code automatically fires anytime someone reaches a certain stage of the customer cycle. However, there are other options.

    Jacob Fairclough/ PPC Heroin Paid Search Google- 9 readers -
  • Use The Destination URL Report To Find Your Best Landing Pages

    PPC Hero series week continues as we review how various reports can help you achieve your account goals. Yesterday, Carrie took a look at better reporting for location extensions. Today, Jacob dives into the destination URL report to find your best landing pages. The destination URL report, one of the many facets of the dimensions tab, delivers metrics tied to each unique U ...

    Jacob Fairclough/ PPC Heroin Paid Search- 1 readers -
  • Getting Your Shopping Campaigns Holiday Ready

    Product Listing Ads are now found within Google Shopping campaigns. Unlike text ads, these ads show photos of products, along with prices and product names right on the search results page when people search for items on Google. Product Listings are a crucial piece of online sales for Ecommerce accounts during this time, so make sure your accounts are ready.

    Jacob Fairclough/ PPC Heroin Paid Search Google- 5 readers -
  • The Theory of Growing Vs. Building a PPC Account

    There are two primary ways of conceptualizing PPC processes and systems. Both are viable but create difference paradigms in account management. For this post I’m going to title them mechanical and organic. The mechanical view considers performance as the sum of its parts. The organic takes the account as a larger whole, something akin of an ecosystem in which the parts comb ...

    Jacob Fairclough/ PPC Heroin Paid Search- 5 readers -
  • Looking Forward To AdWords Ad Customizers

    In case you’ve forgotten, ads are a big deal. As the one aspect of your work that users interact with, it is important to get them right. You need to make your ad copy compelling and worthy of the click. However, this notion is easier said than done , especially for large accounts. To help make ads more compelling, Google is rolling out ad customizers over the coming weeks.

    Jacob Fairclough/ PPC Heroin Paid Search Google- 15 readers -
  • The New Features In Google Shopping Scripts

    With the official arrival of Google Shopping Campaigns, marketers are now receiving the support and tools they need to succeed on the new platform. Shopping groups are not complicated but they aren’t always straightforward to manage and monitor. Thankfully we now have scripts to the rescue! With the new features and functionality, we will only be able to scratch the surface today.

    Jacob Fairclough/ PPC Heroin Paid Search Google- 4 readers -
  • Reviewing Negative Keywords In Light of Recent Changes

    With the recent AdWords close variant update, now is a good time to review your negative keywords. It is also prudent to review the rules of negative keywords and ensure they are working correctly in your accounts. If you are interested in seeing more data on the issue see Sam Owens post on the topic. The Anatomy of Negative Keywords Negative keywords are used to block certain queries.

    Jacob Fairclough/ PPC Hero- 8 readers -
  • The Necessity of Regular Bid Changes

    Bid strategy is often lost in all the talk about keywords, structure, and ad copy. At its core, AdWords has always been an auction. Bids ultimately have a major impact on the success of an account. Bid strategy should always be under evaluation. At no point should you settle on "well that is what the bids have always been set to". This attitude will either lead you to underspend or overspend.

    Jacob Fairclough/ PPC Hero- 4 readers -
  • 3 Scripts For More Effective Google Shopping Reporting

    A few month's ago I wrote about the power of AdWords scripts reporting. The reporting functionality in scripts allows you to access the API data tables. Not only is reporting faster and more efficient but allows access to additional metrics. Reporting is less technically demanding so even if you don't have a lot of experience coding, this method is very accessible to anyone.

    Jacob Fairclough/ PPC Heroin Google- 4 readers -
  • 5 Common AdWords Script Mistakes

    Despite its technical reputation, coding is a creative endeavor and offers a wealth of flexibility in solving problems. On the other hand, the language adheres to certain standards. Since a machine interprets code, you must follow certain protocols or risk non-working code. Even minor errors and typos can throw everything off and leave your code inoperable.

    Jacob Fairclough/ PPC Heroin Paid Search- 14 readers -
  • Get Ready for Google Shopping

    Google Shopping campaigns offer an intuitive way to advertise your products. Shopping has been out of beta for a few months now and I've had great success on the platform. If you haven't heard, Shopping campaigns will completely replace PLAs in August. As a result, it is important that you are both prepared to transition as well as manage the new campaigns.

    Jacob Fairclough/ PPC Heroin Google- 12 readers -
  • 3 Assumptions Every Great PPC Account Manager Makes

    They say, "don't make assumptions", but who are they to tell you how to live your life? Contrary to the expression, making assumptions can make you a better account manager, maybe even a great one. Now I can't condone every assumption you might have. Here are 3 big ones that will always point you in the right direction.

    Jacob Fairclough/ PPC Heroin Paid Search- 24 readers -