A couple of weeks ago Larry Kim gave a webinar on keyword research, revealing his three-step process for discovering keywords. You can watch a recording of the webinar, as well as view the slides, below. You'll learn:How to dominate a search category for your brandWhy keyword niches are more important than single keywordsHow to apply your keyword research in on-page SEOAnd don't forget to sign up for our next webinar, Improving Quality Scores, on Wednesday, May 18.
Webinar: Winning with Keyword ResearchTo try the keyword tools demonstrated in the presentation, take a test drive today! ... > Read more
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 scorecards Dynamic controls for date ranges and campaign filtering Building 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 stuf... > Read more
Last week we gave you five tips on how to get more leads from PPC. But what if your main problem isn’t leads? Everyone wants more leads, of course, but what if your most immediate problem is that your PPC campaign just isn’t profitable?In this post we’ll walk through five more tips, this time for lowering your CPA.
Cost Per Action Lowering Tip 1: Lower Your BidsIf your cost per conversion is out of whack, this basically means that the following equation isn’t adding up properly for you:Cost / Conversions = CPAWe’re thinking about ways to get conversions for cheaper, so it’s pretty obvious that we might want to do something about the conversion end of this equation, but all too often I see people ignore the cost side to their own peril.Many times, there’s a range of conversion ... > Read more
Sometimes, the best thing I read over the week has nothing to do with Internet marketing. But I really want to share it with you, so by God, I make it have something to do with Internet marketing. This week, that thing was this list of the worst analogies written by high school students, originally published in the Washington Post.
The source above ("The Lost Eyeball") calls them the "worst/best" because many are actually quite brilliant – if I was a high school teacher and one my students wrote these gems, I’d give them a king-size gold star. To further qualify the list, the source says the paper “held a contest in which high school teachers sent in the ‘worst’ analogies they’d encountered in grading their students’ papers over... > Read more
April is over, you've paid your taxes, and now you're waiting for your tax return. Oh, the miserable wait: What to do in the meantime??? How about catching up on our best blog posts from the month? Is the Internet Bad for the Environment?: In honor of Earth Day we published this infographic detailing what kind of damage we're doing with our Internet addictions, as well as how the Internet is good for the planet.
Crayola Colored Bubbles: Reputation Management for a 1-Star Disaster: Worst product ever? Read some of the hilarious reviews for this mess of a product (literally) and learn what to do if this happens to your company. Understanding the Differences Between Google and Bing Match Types: This guest post by Bethany Bey from Hanapin Marketing explains the differences betwee... > Read more
Everyone wants more leads, right? This is probably your number 1 request from clients or upper management if you’re running pay-per-click campaigns (followed closely by “without increasing spend”). But the reality is you’re likely managing to a target cost per acquisition, so grabbing more volume isn’t as easy as jacking up bids and lifting your budgets.
The obvious answer to increasing conversions is focusing on conversion rate optimization, but we’ll walk through five slightly less obvious ideas worth testing that can help you grab more volume without ignoring your margins. Idea 1: Keyword Expansion The first idea is to try different keyword verticals and expand your keyword list. How do you do that? In all likelihood you’ve already brainstormed ... > Read more
Facebook develops new features and alters its layout and settings (and privacy policies) frequently, and the social giant recently introduced two new additions in its continued mission to take over the word. Facebook’s new Send button allows users to share items with select people rather than everyone in their friend network.
Maybe you found a great bar in which to throw your friend’s surprise party – but you certainly don’t want the birthday girl to find out. With the Send button, you can quickly and easily share and send the URL to specific friends, groups, and email addresses. Cynthia Boris at Marketing Pilgrim has a clever idea about how the Send button could be implemented as a marketing strategy: "As a marketer, I’d take this one step further and u... > Read more
Yesterday Google announced that their Instant Preview feature will now apply to ads. That means you’ll now be seeing that nifty little magnifying glass appear next to ads as well as organic search results. Clicking the Instant Preview magnifying glass brings up a window that lets users preview the ad landing page.
In the image below, you can see that my Google search for “flowers” brought up a few ads. Clicking the magnifying glass next to my 2nd ad, I got to see a preview page and was able to confirm that the ad would, in fact, lead me to a site with an abundance of beautiful flowers to sell (just seeing them all nearly makes me sneeze). Instant Preview allows users to preview the ads they are about to click on to ensure that the content of the landing page matches what... > Read more
When hiring for a tech startup, most companies focus, understandably, on technical talent: developers and engineers. Obviously, you need great engineers if you're going to build software, apps or a website of any kind. But don't underestimate the value that a great writer can bring to your organization.
A lot of startups make any writing tasks that come up the responsibility of whichever staff member is the most competent writer. When you're bootstrapping, multitasking is a necessity. But if you've got some funding, hiring an excellent writer can impact your business in a lot of positive ways. So whether you make a full-time hire or find a reliable contractor, it's worth the investment to seek out a writer who understands your business and industry and cares about the outcomes. Here are fi... > Read more
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"... > Read more
We recently put together a Keyword Research Kit that includes a lot of great resources for anyone doing keyword research and marketing for either SEO or PPC applications.The Keyword Research Kit is a completely free resource available to download. The kit includes:The Keyword Research Cheat Sheet – This PDF offers a bird's-eye view of what keyword research is, what it isn’t, and why it’s important.
This cheat sheet is helpful for quickly orienting those new to the concept of keyword research, from first-time hires to executives.Keyword Monitoring Worksheet – This tool allows you to plug in your keyword data every month and monitor trends in your rankings, traffic from SEO, and ultimately how your organic search engine marketing efforts are helping to drive your business.The Ultimat... > Read more
On Wednesday, Google rolled out a new Analytics upgrade. Here’s Mashable’s report on the upgrade: Google rolled out a new and improved version of Google Analytics to all current Analytics users on Wednesday. The upgraded product comes with a bevy of new features. In addition to faster performance and a streamlined UI, the new Analytics also packs quite a lot of improved and entirely new functionality.
Users can create multiple dashboards, up to 20 per user; and each dashboard can contain up to 12 widgets. Users can also set interaction goals (for example, you might use Google Analytics to track and optimize file downloads or video views), graph and compare certain metrics over time, and toggle between multiple profiles and sites while focusing on one report. Wiep Knol begs to d... > Read more
Being a bit of an SEO virgin, I sometimes find myself confounded by the intricacies and details of creating a successful SEO campaign. Talk of conversions, meta-data, and keywords can be overwhelming for any SEO newcomer. For SEO newbs like myself, I suggest checking out Brick Marketing's SEO Checklist Guide, which is a great manual for any beginner hoping to better understand SEO.
I read it and found it easy to read and loved the plethora of recommended free tools. And best of all, the guide itself if free! And who doesn't love free stuff? An Overview of What You'll Learn The guide is divided into two main sections, with individual mini chapters. The first section is about developing your website to match your SEO goals. It details the importance of things such as: Site Structure (h... > Read more
In Google’s continuing efforts to get more social, Google’s Map Maker tool made its introduction into the United States yesterday. Map Maker allows users to add and update maps with their own insights. This can mean a number of different things, such as moving place markers to more appropriate spots, pointing out certain parks and playgrounds, building a more detailed map of a college campus, or even marking the bike lanes in your town.
Essentially, it makes Google Maps into a Wiki.Google’s Lat Long blog notes that since the release of Map Maker, the percentage of the world’s population that has detailed online maps of their neighborhoods has jumped from 15% to 30%. Users have mapped road networks, bike lanes, schools, and even entire cities that were not documented ... > Read more
Dan Olson is the CEO of DIYSEO, a provider of SEO software for small businesses. Dan leads the strategic direction and manages all day-to-day activities at DIYSEO. He is a former vice president at Performics, the largest search marketing company in the United States that was acquired by DoubleClick, Google and eventually Publicis Groupe.
Follow Dan on Twitter, or check out the DIYSEO blog. How should small business owners think about and evaluate SEO? I think three things are important here: Approach it like marketing. SEO isn’t some tech-voodoo, it’s another way of getting customers to your site. Compare it to other things you do to market your business – sometimes that’s similar stuff like PPC, but it’s also print ads, billboards, etc. Fo... > Read more
The process of choosing a proper hosting service for your website is fairly straight-forward. First, you'll need to have an idea of the type of site you are aiming for. While you don't need to have every single page in mind that will be on your website, having good estimates will mean that you'll be able to properly gauge what type of hardware and software a web hosting server will need to be able to host your site.
During this planning phase, you'll also need to think ahead to how your website might grow, and what new hardware and software needs the site may have in the future. With this information in hand, you're prepared to start looking for a hosting service. Software Requirements Some websites require support for various programming languages, like PHP or Ruby on Rails. These differe... > Read more
Today I’m thrilled to announce the general availability of what I believe to be the World’s most comprehensive and accurate suite of keyword research tools for SEO and PPC – the new Keyword Research Suite from WordStream! You can test drive the tools for free, or read on for more information.
In this post, I’d like to talk a little about what the Keyword Research Suite does, how it’s different, and why I think it’s a must-have for anyone who's serious about search marketing. What Is the Keyword Research Suite? For the past several months we've been gathering feedback from our regular free tool users and buckling down to develop what we think of as the ultimate keyword research suite. We wanted to build a tool that would offer… The Biggest Key... > Read more
Interesting things you will learn in this how-to: How to prepare data for year-over-year analysis in Excel How to use the Excel INDEX-MATCH formula How to use the Excel ISNA formula A 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 Ju... > 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 met... > 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 m... > 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... > 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 ... > 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... > 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-... > Read more