Clarity II – Questions About The Queries?

In the earlier posts in this series the point was made that it’s hard to get clear and complete information on the performance of PPC accounts. This is true, in part, because some important information is either unavailable or plays hard-to-get. Examples mentioned included search queries, information about missing clicks, and results in terms of true profitability. This post drills down on search queries; the others will be covered in future posts. Finding Queries Let’s start with an assertion: It is not possible or reasonable to competently manage paid search campaigns without full access to search query details. This isn’t a nice-to-have. It’s required. Managing without query details is like managing a baseball team without being allowed to know what happened at the plate. Suppose you’re told who gets on base and who doesn’t, but nothing else. How do you rate or make changes to your batting lineup without knowing who strikes out, who hits deep long fly balls miraculously caught on the warning track, or who gets hit by pitches? The analogy may not be perfect, but the point is that choosing to add, delete, change bids, add negatives, not add negatives, or modify match type without knowing queries is a bit of blind-folded juggling. And yet, most people do manage paid search without full and detailed query reports – they have to because the data is not available to them. With very limited exceptions, you can’t get it from the engines, in web analytics software, or even in specialized paid search management tools. Why Search Queries Matter (the short version) Queries are vital because they can contain insight into the desire or intent of the user. If you sell tennis racquets, for example, and buy the keyword ‘tennis racquet’ (using the standard Broad Match) then your ad might be shown to someone who wants ‘tennis racquet restringing’, or ‘New Prince V14 Tennis Racquet’ or  ‘used cheap tennis racquet’ or even someone looking for ‘tennis racquet art’. Are each of those people relevant to you? Are the ones that are relevant equally relevant? Can you write a single text ad that speaks directly to each of those people and persuades them to click and take action? If you know the search queries that people clicked on when triggered by the keywords you’re buying, you can answer these questions and take action to improve the targeting and results of your account. Without knowing, you’re left without the ability to fine tune your campaign, so you waste money and miss revenue opportunities. Where The Queries Are(n’t) When talking about this, I’ve found that people usually have either never thought much about the difference between queries and keywords, or have the impression that they do have access to that information but don’t use it aggressively so they haven’t realized the limitations in the little bit of query data they can access. Let’s review what search query data is available in some of the most widely used SEM analytics and reporting tools:

• In Google Adwords the Search Queries report lists queries at the ad-group level, but it does not tell you which keywords triggered which queries. And they notoriously hide a massive percentage of them in rows marked ‘Other Keywords’.
• In Google Analytics does not display search queries at all, at least by default. It can be hacked to display queries, but from what I can see in the ones I’ve used you cannot see/link the queries to specific keywords (or even bucket them into adgroups).
• In Omniture SiteCatalyst & SearchCenter offer great query support if you purchase the optional ‘db universal’ VISTA rule (typically $5K). With this enabled you gain fairly complete search query reporting and it’s a metric you can use with the full power of SiteCatalyst reporting, meaning you can use the ‘break down by’ feature to subsort by query relating it to keyword, product sold, or just about anything. You can also access it via their Excel tool in powerful ways.
• In most stand-alone paid search management tools (like Clickable, Acquisio, SearchRev, SearchIgnite, Efficient Frontier, and others), search queries do not exist. They’re completely unavailable. These tools rely on the search engine API’s for data – they don’t have their own page/URL tags – so they just can’t get query data. Which means their customers don’t get it either.

There are many other analytics and paid search tools of course, and I don’t personally know the details of many of them. (I believe Marin Software does have their own tags and can gather query data, but I don’t recall the level of reporting, for example.) If you know the details of available or unavailable query information and reporting, please leave details in the comments. Missing Data 1, Good Search Reporting 0 Based on this review of the popular platforms people use for paid search reporting, it seems safe to say that the vast majority – probably at least 90% and maybe as many as 98% of search managers do not have the ability to look at which queries drove clicks (and spent their money) on a keyword by keyword basis. Imagine if your sales records only told you what categories of items you sold, not which specific items or SKU’s were sold. How would you decide on inventory re-orders or future promotional plans. You couldn’t with any level of accuracy so you’d have to just guess and play the averages. This is what the search engines want you to do. Your inefficiency is their profit margin. It’s hard to understand why the web analytics and focused paid search software companies place such a low priority on this vital information. I have some theories, which I’ll share in future posts. A Fair Shot If it’s the search query/keyword combination that triggers ads, causes your money to be spent, and dramatically clarifies the ‘why’ of who clicked and converted, why should paid search advertisers have to manage their accounts without this information? I suggest you ask your search engine account managers, or analytics / PPC tool providers that question.