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
This week Google’s Panda update went global, shutting out spam sites worldwide. Sistrix posted a nice little chart listing the “losers” of the new updates. Sites like suite101.com and associatedcontent.com suffer just as much now as they did in the US, but there were some surprises; eHow, which most expected to suffer from the US Panda update, was actually deemed one of the “winners” originally, but with the global changes, eHow is now losing the numbers we expected it to.
There is some speculation that this might be a result of Google implementing data from users who manually blocked certain sites. Ever since Google released a block link directly in search results, it’s been expected that this data will end up affe... > 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
Kellogg’s Cereal has space-themed nutrition lessons in downloadable PDF files. Orkin Pest Control has a virtual insect designed to offer an alternative to classroom dissection. Ben and Jerry’s has interactive games about the environment. Big companies have, for years, been putting educational materials online and getting benefits in the form of coveted .
edu links and serendipitous traffic.Smaller sites can do the same. They usually don’t, but the benefits can be significant. High-quality sites that would never link to your commercial website’s homepage will link to your educational page. You can also list your educational page in high-value places like Google groups for educators or Teacher’s Sourcebook – as long as you’ve got actual educational materials.The first step is to... > Read more
Todd Wilkinson, CEO of WordWatch, began his online career in 1999 with WorldOnline/Tiscali, a pioneering European ISP. Todd later co-founded a digital agency in Amsterdam in 2002, called iizt (pronounce “east”), serving the advertising industry in the Benelux. In 2006, Todd co-founded and served as CEO to Respectance.
com, a social media play described by TechCrunch as the “MySpace for dead people.” Funded by two European VCs, Respectance was located in San Francisco, CA and Amsterdam, NL. Todd exited Respectance in 2010 and launched WordWatch in March 2011, based in Foster City, CA and Amsterdam, NL, with production and algorithm development in Krakow. You believe that bid management is the most time-intensive part of search engine marketing. Why is it so time-consuming and what... > Read more
The following link building tip may or may not sit well with all SEOs, and when deciding on a link building strategy that will suit your business, it's important to weight all the pros and cons before making a choice. Now, with that said, let's talk a little about tiered link building.Tiered link building allows you to drive some extra juice to your quality links and keep the more aggressive link building tactics aimed at buffers in between the more questionable links and your website.
The below is a very quick overview of what this may look like.Getting Quality LinksQuality links in the above diagram are those you are proud of. They are the kids in the frame on your living room wall, with happy faces having just graduated from college. There are a number of ways to get quality links:1) Cr... > Read more
Looking for your next career move? Interested in search marketing? Inbound marketing? Apply for a job at WordStream! We're on a mission to build the world's best PPC management and keyword research solutions to help companies with their online marketing efforts. We're currently hiring for positions in search marketing product management and software development.
How to Get a Job at WordStream (or anywhere, actually)Before diving into the job descriptions, thought it might be helpful to give my personal three best tips on how to get a job at WordStream, or anywhere else for that matter!Don't use find and replace in a generic cover letter – This is so obvious, I don't know why people do this. Instead, write a short note about what you thought about the position, what got you interested abou... > Read more
One of my many brilliant Twitter followees pointed me this week to a hilarious page of Amazon reviews for a product called Crayola Colored Bubbles Wand Set. This piqued my interest because I remember reading an interview in The Believer a few years back with Tim Kehoe, a toy inventor who had been working for more than a decade to develop colored bubbles that wouldn't stain.
(You can read an excerpt from the interview online, but the full text is only available in print. FWIW, I seem to remember the whole issue being fantastic. I believe it also included interviews with Will Sheff of Okkervil River and Rivka Galchen, author of Atmospheric Disturbances.)Kehoe's product was set to be called Zubbles and debut in 2008, but I never heard anything else about them, until now. At first I thought Ke... > 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
I thought I had a good grasp on keyword match types – that is, until I started studying for the adCenter exam. Then I realized there were some noteworthy differences between how Google and Bing interpret match types. If you’ve been treating match types the same in both search engines, read on to learn the key differences between the two and how they may be affecting your account.
For this example we are going to be owners of a flower shop. We want to include the keyword "red flowers" in our Google and Bing accounts. I’m going to go through how the different match types for "red flowers" will affect when our ads show in each account. List of Match Types: Broad Match Phrase Match Exact Match Negative Keywords Broad Match Google: An ad is eligible to appear when a user's search term ... > 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
If you were ever wondering how Google Suggest is so good at predicting your desired search, Google today revealed (through a job posting) some rare insight into exactly what powers Google suggestions.If you search on Google today with Google Instant on, you'll see a little link on the bottom of the suggested searches that says "We're Hiring Autocompleters", as shown here:Clicking on the highlighted link will take you to the job description of a Google Autocompleter (click here for a screenshot).
And here are some of the job description highlights... Required Responsibilities of a Google AutocompleterWatch anonymized search queries as they come in to Google.Predict and type completions based on your personal experience and intuition.Suggest spelling corrections when relevant.Keep ... > Read more
Clearly, Google’s latest foray into social was the big search news of the week. But we’ve already covered what Google +1 is and how +1 will affect your campaigns. So rather than forcing yet more +1 down your throats, I’m wrapping our usual round-up of the month’s best blog posts in with my recommended reading for the week.
You voted with your clicks and eyeballs, and here they are, our top 10 slammingest posts from the month of March:Five Great "Hidden" Link Building Resources: Tom identified a handful of sources for reliably great information on link building, outside of the 100% link-building-focused blogs like Ontolo.PPC Ad Writing Tips from the Experts: An Interview with BoostCTR: I talked with BoostCTR’s Jeff Sexton and Ryan Healy about what goes into a kick-ass pay-per-click... > 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
All day yesterday I watched the news of the Google +1 beta launch reverberate around the SEO space (see WordStream's own coverage for Google Plus One screenshots and impact on AdWords). There is a lot of great coverage and some interesting insights, including (but I can guarantee you not limited to): Danny Sullivan's take SEO Moz's response Coverage on Tech pubs And the list goes on.
Obviously if you're here at the WordStream blog, you're likely concerned with what this all means for SEO and AdWords. Let's try to unpack that step-by-step, thinking through the following questions: What's the actual, honest-to-goodness impact on SERPs tomorrow and in the next few months? How is Google likely to implement this data? What impact (if any) should this have on your marketing efforts -- today, ... > Read more
Stemming from Facebook’s popular “Like” button, the search engine colossus Google is joining the social fray once again. Google’s new “+1” feature has just been introduced, and it’s quite exciting. Starting today, a small percentage of Googlers will see a +1 button next to search listings.
If you aren’t seeing it and just can’t wait to try this new feature out for yourself, head over to Google Experiment and click “Join this experiment.” With Google’s new tool, when you click the +1 button next to a search result, it will light up, basking in the glory of your approval. Now, when you or a friend search a similar topic, they can see that you recommended certain results. And if your buddy recommende... > Read more
Cynthia Boris wrote a nice little article recently about the gamification of the mobile market that has really got me thinking.At WordStream, we've seen how a good mobile marketing strategy can reach stellar results - it’s no surprise that a lot of successful marketing campaigns integrate an element of fun or user interaction.
While this recent Skittles ad isn’t a game per se, it definitely invites a unique interaction for the viewer.Gaming marketing campaigns have potential to reach a HUGE user base. Especially with the increasing attention to mobile games, people are spending large amounts of time playing games. After all, Angry Birds alone has reached more than 50 million downloads!Mobile games are a real untapped market for online marketers. They have a potential to reach a large a... > Read more
If you run a local business in a competitive market (and whose market isn’t competitive these days), it’s essential to set your AdWords campaigns up in a particular way for local online marketing. You will need to set up a minimum of two different campaigns, and sometimes four. Why is this? Let’s look at an example for a plumber from Swindon, in the UK.
The first campaign will be set up with general keywords. Examples are: Plumber Local plumber Plumbers Emergency plumbers Local plumbers 24 hour plumbers The best practice in order to get high Quality Scores, hence a cheaper Cost Per Click (CPC), is to add each of these keywords in their own ad group, with ads containing these specific keywords. You will then set this campaign to run ONLY within the Swindon area. You can do this... > Read more
That's right folks, it's the auspicious return of Pimp Your PPC Ad, in which I scan the SERPs for sponsored ads that don't pass the sniff test, then tell you how to make them better (-smelling?). I always meant to make this a regular feature, but apparently I only did it once in 2009. Oops. So, maybe it's only a biannual feature.
Anyway, here we go with five more lessons from poorly executed pay-per-click ads. Lesson #1: Don't Put All Your Keyword Eggs in One Basket These are some of the ads I was served up for "army surplus gear": This last one suffers from a lack of targeting – these different keywords (ACU headgear, ACU jackets, etc.) should really all be in their own ad groups. In addition, the ad doesn't communication any value proposition and doesn't have a ca... > Read more
People are writing books about the increasing importance of the way you interact with your customers and the power of social media. There's a different, more democratized sort of voting going on. Social blogging platforms that aren't Twitter are exploding. Google is pushing more and more personalization and socialization into their SERPs.
The first real introduction of social signals outside of click-through rate in AdWords SERPs are contained within rich snippets, and specifically product reviews. What's the Status of Rich Snippets in AdWords? Google updated their data requirements for Google Product Feeds. Product feeds are a great way to get some additional real estate for your ads in many cases: Note the confidence-inspiring five stars: good stuff for the advertiser! If we click throu... > Read more
There was a really interesting article in Fast Company this week: “How Carrots Became the New Junk Food,” by Douglas McGray. (Hat tip to Mark Bittman – this is why it’s good to leave your filter bubble!) It tells the story of the rise of baby carrots in the hearts of America – not actual young carrots, but the little mechanically rounded, ready-to-eat nubbins of carrot you can buy in a bag in the produce section.
Real baby carrots look like the image to the right. "Baby carrots" are more like ponies – they don't grow up to be real horses. Baby carrots were conceived as a way to reduce costly food waste: Supermarkets expected carrots to be a particular size, shape, and color. Anything else had to be sold for juice or processing o... > Read more
If you're not familiar with it, Quora is a relatively new question and answer site. It's much-hyped and has a huge following within the tech/startup community, and features participation from well-known entreprenuers, angel investors, and venture capitalists. There's some debate about how scalable the site is, how useful and interesting it is to people outside this initial niche, etc.
We won't focus on any of that or on the basic mechanics of asking a question on Quora here -- what I want to talk about is two interesting ways an SEO can use Quora. 1. Find Content Topic Ideas for Tech-Oriented Content This is really true of any Q and A site, but if you can find a niche with some activity, Quora is a great way to find content topic ideas. Let's say I'm looking to build out an editorial calen... > 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
If anyone asked, I’m sure you could spout off a hundred reasons your company should be involved in social media. But do you still need to get started? Which social network would be the best fit? What are some good first steps? Yes, I believe in social media. How else can you scale talking to people and learning more about them? Building relationships is a two-way street that can benefit you far more than just turning on a faucet of traditional advertising media.
But to have conversations, you need to be where your customers are. B2B? Yes, you have customers, too! Slow and steady wins the race – so setting up one account that you spend an hour on each day is going to be worth more than setting up five accounts and forgetting about them all. But you want to pick the right account to crea... > Read more
Anatomy of a Personalized Search Result: Interesting Localized SERPs & Google Bidding on the Term "SEO"!
The evolution of Google's search engine results page is pretty well documented in the search engine marketing space. The reality is getting a clean, pure, consistent ranking in organic search is nearly impossible because of: More aggressively localized search results The attack of paid search on organic search listings Blended results for video and news Personalized search never sleeps Recently when I Googled the term "SEO" I saw a number of things I found interesting (DISCLAIMER: these are my personalized SERPs, your mileage may vary and the same query may be doing something different for you): (Click the image to enlarge.
) Specifically I think the things of interest here are: PPC is taking up a lot of this SERP, and we see a service that really can't (or at least shouldn't) be sold w... > Read more
If you’ve been following the WordStream blog for a while, you know we’re longtime fans of Aaron Wall at SEO Book. (You should have seen the glow around Tom Demers when Aaron agreed to do an interview with him.) In addition to being a great tactical resource on both SEO and PPC, Aaron is a must-follow blogger for his regular rants and essayistic analysis on the industry at large.
He has also taken a watchdogging stance toward Google, and his thoughts about the company’s direction are always enlightening, even if you’re inclined to give GOOG the benefit of the doubt. Twice this week Aaron reminded me of the power of a single image in a blog post – not a fancy infographic or even a beautiful photograph, just a basic screenshot – and how much an image can co... > Read more
If you're a PPC agency there are some fundamentals within the campaign that you want to understand before you do anything else: Margins & Profit - Before you do anything else with PPC, you want to understand what "profitable" means. If you're working on a VC-backed company willing to take a loss on each lead this might just be a target cost per acquisition (CPA), but in most cases it means a hard cost that leads a company into the black.
This is the most critical single metric in your PPC campaign (and it has nothing to do with click-through rate, Quality Score, etc.!). Costs & Costs Per Click - Obviously you want to be cognizant of what you're spending -- not just in the context of your cost per conversion and your margins, but also in the context of the volume you can drive... > Read more
Last night I performed a Google search on my home computer, using Firefox. I only got four results back on the first page, though there were over 55,000 results total (see below). I was not signed in but Instant was on. It looks like Google is testing this style of SERP when it thinks a handful of pages are clearly the most valuable, relevant results for the query.
Presumably, some users would prefer fewer choices as long as those choices clearly addressed the query. Didn't either Sergey or Larry once say that in a perfect world, Google would return only one result? This page did not address my needs as a searcher, because I was specifically trying to determine where my own blog ranks for this query -- i.e., whether I rank on the first page. If this experiment became the norm, "the f... > 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