[New Guide!] The Complete Guide to Using Excel for PPC

By Jamie Newton | @jnewton09 | Senior Communications Manager at Hanapin Marketing

Excel is a crucial tool for any PPC marketer’s daily workflow. From building campaigns and writing ads to analyzing aspects of your account, your job will be made (a bit) easier by being Excel savvy. Written by PPC Hero bloggers and excel masters, Rachael Law and Jacob Brown, this whitepaper will outline the most important tasks that we use Excel for in our day-to-day PPC work.

In this Whitepaper we’ll discuss:

  • Different functions you can use to create and test ads
  • How to calculate metrics like Lost Impressions (formulas included!)
  • Quick ways to make your keyword list
  • Utilizing pivot tables for ads, keywords, landing pages, and account analysis
  • Calculating your optimal average position with grouping

Get the Guide

Reasons to Not Use an Automated PPC Bidding Strategy

There are so many situations when it is a good idea to test out PPC Bidding Strategies on campaigns. In this article, we are going to discuss different reasons why you might want to avoid using automated bid strategies.

Take the 2018 State of PPC Survey!

We're looking for marketers to take our State of PPC survey! The survey takes about 5 minutes to complete and establishes benchmarks, identify trends, and helps marketers around the world understand what's working and what's not in PPC.

Amazon Launches Seller Central Sponsored Products Dashboard

Amazon has released a new dashboard feature for the Seller Central marketing platform. Found in the Seller Central campaign manager, the dashboard makes it easier than ever to visualize your campaign data and take away valuable insights from your Amazon marketing account.