AdWords Tips Posts from the Internet Marketing Blog

AdWords Top vs. Side Ad Performance: How to Use the Latest AdWords Report Segment

The Inside AdWords blog announced yesterday that there will be a new report segment available in AdWords accounts: top versus side. Basically the idea here is that you can see how your ads perform when they’re placed above search results versus when they’re placed below search results – the focus here being on physical position on the page rather than the numeric order in which the ads appear.

The report looks like this:As with any new AdWords feature, the key question to ask as you’re shown more data by the folks at Google is: What can I actually do with this information? In this case the top versus side segment data can be useful in a few different ways.What to Do with AdWords Top Versus Side DataLooking at the new top vs. side reports, I see three interesting potential applicati... > Read more

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

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: 2

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
 
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.