AdWords Tips Posts from the Internet Marketing Blog

Google AdWords Editor 101: AdWords Editor Tutorials, Tips & Resources

If you’re managing pay-per-click campaigns, the Google AdWords Editor is a really handy (but fundamentally limited) free tool provided by Google to help you with certain PPC tasks. It’s a free, desktop-based application, currently in the 10th version of the tool (check out the changelog here and get the application itself here).

To help you get the most out of Google's AdWord Editor, it’s important to understand what the tool is and what it isn’t.AdWords Editor is a free resource provided by Google that can help you with several bulk editing tasks within your AdWords campaigns, such as:Raising or lowering bids on a number of different keywordsCopying large sections of your campaigns and then tweaking certain areas (moving a list of keywords, a set of ad text, etc.)Changing keyword m... > Read more

July 11, 2011     |   Written by: Tom Demers   |   Posted In: AdWords Tips   |   Comments: 1

Google AdWords Remarketing Strategy: Three AdWords Remarketing Tips

Google AdWords remarketing (and really remarketing in general) is a hot trend in the world of pay-per-click marketing. Remarketing is basically a way of getting your message in front of people who have visited your site in the recent past – you’ve no doubt seen a site you recently visited “following you around” via advertisements.

And if you’re a paid search manager, you’ve likely set up a slew of remarketing campaigns in the last few months, many times at the specific request of the client, but there are still PPC advertisers who are either just getting their remarketing campaigns started or are still considering how much value there would be in a remarketing campaign.In this post we’ll cover three important things to consider as you get your first remarketing campaigns up an... > Read more

July 07, 2011     |   Written by: Tom Demers   |   Posted In: AdWords Tips   |   Comments: 2

AdWords Display Network Banners: 5 Tips for Using Crowdsourced Ad Banner Design

In a few recent posts on how to get more volume on the content network and on getting more leads from PPC, we talked about leveraging the content network to expand AdWords campaigns and attract more prospects via PPC.Most advertisers know how to get started with Google’s search network, and even with creating specific content network campaigns, but an area that often trips up advertisers – particularly new advertisers or those who are looking to expand beyond their initial structures – is building out “display” campaigns using Google AdWords, or creating banner ads for display on the content network.

Many times the stumbling block here is more around designing the creative (banner ads) than around the mechanics of creating a structure for your content network campaigns.For that r... > Read more

June 13, 2011     |   Written by: Tom Demers   |   Posted In: AdWords Tips   |   Comments: 1

AdWords Quality Score FAQ Continued: 5 More Questions About Quality Score

We received the following questions during our recent webinar, "Improving Quality Score." For more help with understanding and improving AdWords Quality Score, check out these resources:Quality Score Toolkit (this free kit includes a Quality Score worksheet, cheat sheet, white paper, and video)Quality Score FAQImproving Quality Score (webinar recording)Ultimate Guide to Quality Score (15 experts on Quality Score)Do site links improve CTR and Quality Score? According to data from Bigmouth Media, "ads that run with Ad Sitelinks typically result in an average click through rate increase of 30%.

" RKG reported similar results: "To take seasonal shifts out of the picture, I looked at the brand performance since the links were launched, and compared this data to the same time period last year. We... > Read more

June 01, 2011     |   Written by: Elisa Gabbert   |   Posted In: AdWords Tips   |   Comments: 2

Re-Creating AdWords Campaign Performance Charts in Excel, Part 5: Dynamic Controls

This is the final post in my series on Re-Creating the AdWords Dashboard in Excel. For the rest of the series, see below:Re-Creating AdWords Campaign Performance Charts in Excel, Part 1: The DataRe-Creating AdWords Campaign Performance Charts in Excel, Part 2: The TransformationRe-Creating AdWords Campaign Performance Charts in Excel, Part 3: Making the ScorecardRe-Creating AdWords Campaign Performance Charts in Excel, Part 4: Making the ChartsIn part four of this series, you learned how to build the charts for the AdWords dashboard.

In this article, I will show you how to make the dashboard dynamic by teaching you how to:Add a dynamic campaign filter.Add a dynamic date-range picker using a Data Validation list.Building the Campaign FilterAs you may recall we are using the DTP framework as... > Read more

May 19, 2011     |   Written by: Chad Summerhill   |   Posted In: AdWords Tips   |   Comments: 3

Re-Creating AdWords Campaign Performance Charts in Excel, Part 4: Making the Charts

In part three of this series, you learned how to build our dashboard’s scorecard. In this article, I will show you:How to build the charts.How to copy and reuse your charts to save time when building multiple charts.Building the Charts The AdWords Campaign Performance report only has two charts and they allow you to choose from many different available metrics for comparison.

Our dashboard isn’t really limited by space, so we will be creating a chart for each of our KPI’s.ImpressionsClicksCostConversionsCTRCRCPACPCThe best way to do this is to create and format one chart for one KPI, and then we will copy the chart several times for each of the other KPI’s. This technique will save you lots of time, because you will only have to format your chart once.Follow these steps:1. Ins... > Read more

May 11, 2011     |   Written by: Chad Summerhill   |   Posted In: AdWords Tips   |   Comments: 1

Re-Creating AdWords Campaign Performance Charts in Excel, Part 3: Making the Scorecard

In part two of this series, you learned how to transform the data we will be using to create our dashboard. In this article, I will show you:How to build the scorecard.How to use conditional formatting.How to use the camera tool.Presentation (the “P” in “DTP”)Again, we are using the DTP framework created by the smart folks at Juice Analytics.

The presentation layer for our exercise consists of all the pieces of our dashboard:Dynamic charts and scorecardsDynamic controls for date ranges and campaign filteringBuilding dynamic dashboards in Excel can be a challenge, but if you’ve already completed the steps from the first two posts in this series you’ve done the hard part. Now we are ready for the fun stuff.The Dashboard TabFirst, we need to create a new worksheet and rename it ... > Read more

May 03, 2011     |   Written by: Chad Summerhill   |   Posted In: AdWords Tips   |   Comments: 1

Re-Creating AdWords Campaign Performance Charts in Excel, Part 2: The Transformation

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

April 26, 2011     |   Written by: Chad Summerhill   |   Posted In: AdWords Tips   |   Comments: 2

Re-Creating AdWords Campaign Performance Charts in Excel, Part 1: The Data

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

April 18, 2011     |   Written by: Chad Summerhill   |   Posted In: AdWords Tips   |   Comments: 4

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

April 14, 2011     |   Written by: Tom Demers   |   Posted In: AdWords Tips   |   Comments: 2
 
Free Keyword Tool

Get thousands of relevent keyword suggestions - more,
faster, free!

Free Keyword Niche Finder

Discover profitable pockets of keywords for your
business.

Free Negative Keyword Suggestion Tool

Identify wasted spend before it happens and increase
your paid search ROI.

Contact Us | Company | Support | Site Map | Trademarks | Privacy Policy © 2007-2014 WordStream, Inc. All rights reserved.