AdWords Tips Posts from the Internet Marketing Blog
In Part 1 of this series, you learned how to prepare the data we will be using to create our dashboard. In this article, I will show you:How to set up an Excel pivot table.How to use calculated metrics in a pivot table.How to use Named Ranges in Excel.How to use the OFFSET formula in Excel.Transformation (The “T” in “DTP”)We are going to use an Excel pivot table for our "transformation" layer in our DTP framework (worksheet).
You should already have your data prepared in the "current" worksheet, so you will need to:1. If you haven’t already, format your data as a table in Excel by highlighting your entire data set in the "current" worksheet and click on "Format as Table" from the "Home" menu.2. Now select any cell within your table and navigate to the "Insert" menu and insert a "... > Read more
Interesting things you will learn in this how-to:How to prepare data for year-over-year analysis in ExcelHow to use the Excel INDEX-MATCH formulaHow to use the Excel ISNA formulaA few weeks ago I showed you how to compare date ranges in AdWords, and then a few days later I came across an article on Search Engine Journal about using the new AdWords dashboard located on the "Home" tab.
In the article the author mentioned how, in the new version of the Home tab, you couldn’t do date range comparison like in the previous version. See the image below:So, I thought it might be interesting to try and recreate this chart and summary in Excel. The finished dashboard will look something like this:For this exercise I will be using a variation of the Juice Analytics DTP Framework.Data (the... > Read more
AdWords Position Preference Bidding Is Retired: What You Need to Know About AdWords Average Position
Google recently announced that they are retiring position preference bidding. Some smart PPC managers had been talking about how position bidding wastes money for some time, and Google's own chief economist had taken great pains to lay out the argument against bidding to position in your attempts to improve your actual sales and costs per sale.
If you're hearing this news now for the first time you might be wondering why people ever used bidding to position as a means of managing bids, what you should know about AdWords average position metric, and of course: whether or not there may be some instances where this data is still useful in your campaign.Why Bid to Position?Obviously with Google sharing some of its own data and Google and top PPC minds decrying the value of the metric... > Read more
We've written here about some of the things to be aware of with regard to the AdWords opportunities tab, and we've talked in depth about AdWords Campaign Experiments. AdWords recently announced a new feature that enables advertisers to run campaign experiments against AdWords opportunities. This is a really interesting feature combo -- both from a pure functionality standpoint and in thinking about where AdWords is heading, so let's unpack it.
What Exactly Does Opportunities & Experiments Combining Mean?So how does this play out, exactly? Basically all Google's done (from the end-user perspective anyway) is make the campaign experiments functionality visible and available as you're browsing the opportunities Google is presenting you with:(Funny aside: this is the screenshot from the Goo... > Read more
In the past I’ve written extensively about search query mining for negative keywords and new keyword opportunities, and while search query mining is arguably the best use of the search query report, there are other insights worth exploring. Have you ever wondered what search queries were driving your business last year and if they are still contributing this year? Are there new search queries emerging in your market? To answer these questions, you will have to do a year-over-year search query analysis.
While the AdWords interface does allow for date range comparisons down to the keyword level, it loses this functionality at the search term level. We are left with analyzing date range comparisons for search queries in Excel.Getting the right dataThe goal of this analysis is to c... > Read more
Reporting on Multiple 1-Per-Click Conversion Types (Conversion Action Names) in AdWords at the Campaign & Ad Group Level
If you're a PPC software company, one of the best opportunities to add value on top of the AdWords interface is by thinking more about advertiser pain points than Google is able to. Google frequently has to balance features that help their advertisers generate more revenue against features that help Google generate more revenue, and frequently since Google isn't an advertiser, even when they build something that seemingly has optimizing for conversions in mind, they don't always get it quite right for the advertiser.
Just as it's important to realize which new AdWords features aren't necessarily worth implementing, it's equally important to identify gaps in AdWords' feature set and reporting so you can find ways to fill it. Today we'll talk about one of these gaps: reporting on multiple 1-p... > Read more
Do you know the difference between broad match and modified broad match? Are you confident in your ability to use negative keywords to save money without losing valuable traffic? To maximize the profitability of your pay-per-click campaigns, you need to know how and when to use each of the keyword match types offered by Google AdWords.
Our newest white paper, the Complete Guide to AdWords Matching Options, can help you navigate the options. After reading this white paper, you'll have a clear understanding of: The differences between the keyword match types offered in AdWords How, when and why to use each match type to get the best results Using the new modified broad match option for more refined targeting How negative keywords can save you money and raise CTR Best practice... > Read more
If you work at a PPC agency – or simply manage PPC at a large or multi-faceted company – you may find yourself managing multiple AdWords accounts. The added complexities can make your job tricky, and your results may suffer in the process. Below are a few tips to make the management of several client accounts smoother and more efficient.
1. Log Into Each AdWords Account at Least Once a Day PPC can sometimes be unpredictable, and it’s important to make sure that the house isn’t burning down. When managing several Google AdWords accounts, a My Client Center (MCC) account can provide a useful dashboard for getting a quick daily overview of all of them simultaneously. On the MCC dashboard, there is a top-level view of key performance indicators including stats for impre... > Read more
Early this month I came across a blog post over at Vertical Leap about improving AdWords for the advertisers. There were lots of good suggestions in the post, and as you may know I like to make suggestions for AdWords myself. You never know when one of your suggestions will become a reality. I think it’s important to challenge AdWords and help them see things from the advertiser’s perspective.
One of the suggestions from the Vertical Leap post was to allow for the comparisons of date ranges. I thought this was a little odd since this feature is available today in the AdWords interface (very similar to the Google Analytics date range comparison).It’s very easy to overlook new features at the rate AdWords has been pumping them out lately, and I don’t remember AdWords even announcing d... > Read more
Over the past few weeks, I’ve come across more than one comment or statement about how powerful the AdWords Automated Rules are for bidding and how this could really put pressure on the third-party software companies, be the death of bid management software, etc. I don’t agree. Over at Ad Innovations, Google gives us the example of using Automated Rules for raising your bid (by 20%) based on a keyword’s position (worse than 4).
They also say, “Modify your Max CPC bids based on CTR or conversion rates,” but offer no real direction for how to do this. Brad Libby talked about shooting your eye out with automated rules, which doesn’t sound too profitable. What I haven’t come across is any examples of how to bid intelligently with this new feature. Where are the rules for the Aut... > Read more