PPC Excel Tips For Every Level: Part 3, Advanced Level Keyword Research And Data Visualization

ppc-puzzle-featured We close out our three-part series of Excel tips from Bing Ads Evangelist John Gagnon today with some advanced level tools that, in fact, even beginners can start using successfully today. While many of the tips we've covered can also help SEOs as well as PPC practitioners, today's focus on keyword research is particularly relevant to both camps. Advanced Tip: Bing Ads Intelligence for deep-dive keyword research and Power BI for big data analysis and visualization. Bing Ads Intelligence is an Excel add-in for keyword research that enables Excel to integrate directly with your Bing Ads a [...]

Google Keyword Planner Now Shows Trademarked Terms

google-adwords-featured At some point recently, Google started to indicate terms that are trademarked in the Keyword Planner with the TM mark. Dan Shure of Evolving SEO tweeted about the new feature, noting that McDonald's "I'm Lovin' It" tagline is not marked as trademarked while Staples' "The Easy Button" is marked as such. (Burger King's "Have It Your Way" also gets a TM.) Keyword Planner apparently now indicates Trademarked terms pic.twitter.com/ZIvRusweRK — Dan Shure (@dan_shure) November 27, 2013 What is marked as trademarked and what isn't appears to be somewhat inconsistent at this point. For exampl [...]

Google Keyword Tool Is Officially Dead, Keyword Planner Gets Lukewarm Welcome

google-keyword-tool-dead-featured Lukewarm may be overstating it. If Twitter sentiment is any gauge, the SEM world has not exactly embraced Google's new Keyword Planner, which as of yesterday officially replaces the Keyword Tool.  Looking at tweets over the past 7 days, "Keyword Tool" yields a sentiment score of 59 on Topsy.com compared to just 45 for "Keyword Planner." https://twitter.com/inkovic/status/372183942637424640 Unlike the Keyword Tool, used by SEOs and PPC managers alike, users must login to an AdWords account to access the Planner. That's just one of the grumbles heard around the Internet about the Keyword [...]

New Updates To Bing Ads Intelligence, Excel Add-In For Keyword Research And Analysis

bing-ads-square Microsoft has released an update to Bing Ads Intelligence, the free Excel add-in for keyword research and keyword performance analysis on the Yahoo! Bing Network. From the new ribbon at the top of the page (shown above), the Keyword Suggestions tool provides keyword and bid research in one place. Enter a handful of keywords, and the tool generates a list of suggested keywords by match type, associated KPIs, and estimated bids based on the keywords you entered. From the Select Account tool, you can opt to download all keywords from an account, or select specific campaigns or ad [...]

RKG Launches SEO Forecasting Tool & Pilot Program Offering Insight On ‘Not Provided’ Query Data

SEO bubble On the heels of acquiring Nine By Nine Blue along with its search analytics Blueprint software, digital and search marketing firm RKG announced today a new SEO predictive forecasting tool to be added to the Blueprint software suite. In addition to the newly added SEO solution, RKG is launching a pilot program for companies interested in uncovering previously "not provided" search query data. "To understand search, you have to understand why you were discovered and then how you can improve on this," said RKG CEO George Gallate, "The ability to see what customers are searching for, includi [...]

Rediscovering The Google AdWords Editor Keyword Opportunities Tool

Google's Keyword Opportunities (Beta) tool is a gem of a keyword idea tool integrated into AdWords Editor. I recently rediscovered this tool and have been tearing through my clients' accounts, adding keywords. The tool generates suggestions similar to the Web-based tool, but is integrated into Editor quite nicely. Suggested use: Launch AdWords Editor and open your Account Launch the Tool - keyboard: ALT-T-O (menu: Tools | Keyword Opportunities (Beta)) Uncheck the box for "Include Additional Items" Set Match Type to "Exact" Input your seed keyword, and click the "Get Keywords" Bu [...]

Google Merges Insights For Search With Google Trends

google-g-logo Google has merged two of its popular search/keyword research tools. Google Insights for Search has been absorbed by Google Trends; the combined tool keeps the Google Trends name and exists at the www.google.com/trends address, too. If you try to access the Insights for Search address (www.google.com/insights/search), Google redirects you to the new Google Trends. When Google launched Insights for Search in 2008, I remember one of the first really helpful uses that I had for it was to help a client figure out if he should be using the term "lawyer" or "attorney" more frequently. As I use [...]

Infographic: How To Do Keyword Research For SEO

Good SEO begins with good keyword research. After all, if you don't know the ways people are seeking your content, it's pretty hard to ensure that your content "speaks" to them using the words they search for. The folks at Promodo have an infographic outlining some key parts of the keyword research process. Understanding that each page has its own terms to target, brainstorming possible terms, researching with the Google Keyword Tool and more are covered. Check it out: Want the infographic for yourself? You'll find it here: Keyword Research Infographic. Looking to improve your key [...]

Three Free Keyword Research Tools

One of the hardest things to do in keyword research is to uncover related keywords. With that in mind, the tools I’m reviewing today all help identify related keywords that you may want to search in more detail. These tools are not a substitute for detailed keyword research like I talked about in my first series of articles. Rather, they may help to either identify those keywords that are most important to your competitors, or help find obscure opportunities where there may be little search volume, but there is also little competition. All of the tools I reviewed for this article are [...]

Why Google Should Retire The Global Market Finder

Does Google really "get" international? There are clearly some very clever people within Google who do -- but the corporation's behavior bizarrely still tends to suggest a silicon valley tech company that's a little insulated from the non-English speaking world. Take, for example, the "Global Market Finder" tool which you can find here. This tool was originally conceived in the UK and then made its way into the Google mothership. The idea behind the tool is that you can enter a keyword or several keywords -- and it will then automatically in a matter of seconds rank the markets where the [...]

Keyword Research Tool Review: Google AdWords

Keywords are important. I've heard from several potential clients recently who have talked to other "professionals" who told them keywords are no longer important for SEO, and that good content is all you really need. Here's the thing. Keywords are language. They'll always be important because words are how we communicate with each other. So until someone invents the microchip that can be implanted in your brain and read your thoughts without using words, you'll need to think about language in marketing. And I can only hope that those potential clients were told this by one seriously mis [...]

Tips For Growing Keyword Seeds With Excel Formulas

Have your seeds germinated yet? Last time, we talked about keywords as "seeds" of ideas; a single keyword to represent an entire keyword cluster. Now it’s time to make our seeds grow. [caption id="attachment_114848" align="alignright" width="240" caption="Germinating your Keyword Seeds"][/caption] Using the example of Artisan Construction Services again (thanks!), we’ll walk through the process that I use to grow a single seed. In this case, let’s use "deck". To begin with, I want to think of the types of decks my client might build: Composite Wood PVC Hardwood Ceda [...]

Dictionaries, Grammar & Feeds: A Rules-Based Keyword Generation Approach For PPC

This article presents a rules-based approach for Keyword Generation using Dictionaries, Grammar, and Feeds. Essentially, Dictionaries define the various groups of words that are relevant to an account. Grammar defines how to combine them. Feeds define the data that may be changing regularly, like e-commerce inventory, store locations, etc. Readers may be able to generalize these terms to apply to existing rules-based tool if one is currently in use. First, a word about where this approach fits in to the broader picture. The Broader Landscape of Managing Keywords & Negatives There are [...]

The Keyword Research Rabbit Hole

A few weeks ago, I wrote about how to use your first meeting with a client to understand their business and collect information that could later inform your keyword research. Now, you’re back at your desk and wondering what to do with all that information. To begin with, you should have three lists of keyword-types (I call them seeds): [caption id="attachment_110492" align="alignright" width="240" caption="Elements to include in keyword research"][/caption] Seeds most important to your clients (note that these may include jargon and industry-specific terms that need further researc [...]

Google Tweaks Competition Rank In AdWords Keyword Tool To “Low,” “Medium” or “High”

Google-Search-Tool-Changes Many users are now seeing a change in the way that Google's Keyword Ranking tool is providing competition data. Instead of the traditional bars to display competitiveness, Google is using text as the description. Up until now, this tool used small green bars to display the competitiveness of keywords. The more green in the bar, the more competitive the term was: Now the Google tool is only showing text-based descriptions of competitiveness: Low, Medium or High: While the competitiveness has been replaced by text in the web version, the good news is that Google has maint [...]

Yahoo Clues Relaunches With More Data, Wider Keyword Coverage

Yahoo has relaunched Yahoo Clues, its search trends product that doubles as an underrated keyword research tool. Among the new features, the most important from a search marketing perspective are these: Expanded data: Yahoo Clues now includes a full year of data, up from just a month Wider coverage: It includes all English-language searches made globally The new Yahoo Clues also offers a "Top Trends" tab (as part of its new look-and-feel) that lets users explore and analyze the most popular search terms on Yahoo. But the expanded data is also part of the regular Trend Analysis to [...]

Google Correlate: A New Way To Research Keyword Popularity & Trends

google-correlate-cartoon-featured I love search data. Being able to mine through millions of search queries to find out what people are really interested in is fascinating (and useful!). Google provides search data a number of ways, including Google Trends, Google Insights for Search, and via the Google AdWords Keyword Tool, and Microsoft has some great stuff via its Excel Advertising Intelligence add in (if you have Office 2007 or higher running on Windows). Google has also done some cool things with search data, including forecasting Flu Trends and predicting the impact of the Gulf oil spill on tourism in Florida. Now, t [...]

Yahoo Clues: New Fun Search Keyword Tool

Today, Yahoo announced a new tool named Yahoo Clues. Yahoo Clues basically gives you insight into the types of people searching for specific keyword phrases and shows related terms based on those searches and searchers. The tool allows you to plug in one or two keyword phrases and it then plots the search trends of those keywords on the page. It shows you keyword popularity over time, searches by age and gender, income level, geographic location, "search flow" and related searches. Let me take you through each metric for a comparison of iphone vs android on Yahoo Clues. Here you can [...]

Adchemy Promises Better Search ROI Through Intent-Based Ad Copy And Landing Pages

Billing itself as one of the "best kept secrets in Silicon Valley," Adchemy is a technology provider that promises to help search marketers "dynamically" create more relevant ad copy and landing pages at scale. The company recently released its WordMap application, which is intended for very large campaigns with millions of keywords but where the ad copy and landing pages are more general and thus unable to reflect the variety and nuance of the more specific associated keywords. Adchemy says that it can "dynamically generate tens of thousands of paid-search ads directly related to intent [...]

Call Analytics Bring Sophisticated New Data, Insights to Search Marketing

Many search marketers have experimented with call tracking and measurement as a way to capture online-to-offline consumer activity and determine which ads and campaigns are generating calls. But there has also been debate about whether unique phone numbers required by call tracking harms SEO especially for local advertisers. Some new developments in the field make a compelling argument for call tracking and analytics, at the very least among enterprises or large advertisers trying to generate calls to call centers. Search marketing platform Kenshoo earlier this summer introduced what it cal [...]

Get Our News, Everywhere!

Daily Email:

Follow Search Engine Land on Twitter @sengineland Like Search Engine Land on Facebook Follow Search Engine Land on Google+ Get the Search Engine Land Feed Connect with Search Engine Land on LinkedIn Check out our Tumblr! See us on Pinterest


Click to watch SMX conference video

Join us at one of our SMX or MarTech events:

United States


Australia & China

Learn more about: SMX | MarTech

Free Daily Search News Recap!

SearchCap is a once-per-day newsletter update - sign up below and get the news delivered to you!



Search Engine Land Periodic Table of SEO Success Factors

Get Your Copy
Read The Full SEO Guide