ClickEquations Blog

It’s a sad truth, but “most dashboards are on auto-delete” as our friend and Advisor Avinash Kaushik says.

Earlier this year, Craig had a chance to sit down with Avinash, Author of Web Analytics An Hour A Day, to get his tips for actionable paid search analysis and reporting.

Watch our first Paid Search Pros Video to learn:

• Why the “What’s Changed?” report is so actionable
• How to more effectively measure the Long Tail of search
• Avinash’s favorite ppc analytics tips

.
For more advanced ppc tips, sign up for our upcoming webinar, “Master Search Queries to Save Money and Increase Conversions” on Thursday 7/16 and subscribe to our email newsletter.

Search queries, the actual words people type vs. the keywords you buy, are a critical and often underused tool in managing paid search as we’ve said on this blog before:

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?

We’re tackling all things search queries in our next free webinar, “Master Search Queries to Save Money and Increase Conversions” on Thursday, July 16th at 1:00 EST. We’ll cover:

• What search queries are
• Where to find search queries
• The best way to organize your search queries to identify opportunities to save money and increase conversions
• Actions you should take daily, weekly and monthly to profit from search queries

Sign up for the free webinar!

-Alex

Suppose you had to quickly reduce your PPC spend. Where would you cut?

One very helpful analysis is rank your campaigns (or better yet AdGroups) by ROI. This tells you where you’re getting more return-per-dollar, and where you’re getting less.

To simplify this analysis we built a ClickEquations Analyst Report, which runs in Microsoft Excel. To use it you define three thresholds – a high ROI that you desire, a low ROI that you detest, and a medium ROI that is minimally acceptable.

With a single mouse click you can then find out what number of your campaigns and what percentage of your spend and revenue fall into each of these bands. On the next tab in the worksheet you can find out exactly which campaigns fell into each group.

In the example above, we look at how ROI falls into four clusters and two charts visualize the spend and difference between spend and revenue.

Armed with this visual, most people are encouraged to look inside the campaigns – probably first by running the Ad-Group version of this report – and find ways to fix the losers or kill the problematic groups or keywords.

But you can’t drive to those actions and decisions without information. This report is a good example of how ClickEquations Analyst can help you to understand the performance of your accounts, and make good decisions about how to prioritize your PPC efforts.

You can begin your use of ClickEquations with a 30-day free trial. Sign up here.

Two years ago we took a deep soul-searching look at paid search management practices and technology and decided both were inadequate.

Since then we’ve developed completely new management practices and technology, and it’s time to roll them both out publicly.

The management practices are built around a framework called ‘High Resolution PPC‘. It’s based on the idea that there are three distinct stages in the paid search process and specific steps and checks to sequentially create a well formed and effective campaign.

The technology is our ClickEquations platform, and was developed based on the idea that paid search is not as efficient and effective as it could be because the software tools we have had are inadequate in a number of very specific ways.

Background
We’ve been professionally managing paid search accounts for about five years. As the market and engine platforms have developed, the size and complexity of the accounts managed has grown. Working with both venture-backed startups and Fortune 100 companies we live with high expectations, competitive sensitivities, and serious budget and ROI oversight.

While it’s been exciting to go along for the ride as the market exploded and the technology evolved, anyone who’s lived deeply in paid search management over the past years knows the day-to-day hasn’t been exactly a picnic.

It’s a lot closer to a horror show.

The search engines are opaque (to put it kindly) on multiple layers. If you try to actually figure out what’s happening and why, you find key information is missing, available information is contradictory, and things aren’t exactly consistent. The Matching Algorithms used by the Search Engines and their rules change constantly.

The image of easy-management and easy-money that caught the media’s attention in the early years is ingrained in the imaginations of VPs of Marketing, Merchandising Managers, and even some Directors of eCommerce. Which means they have expectations and make requests that make the PPC Manager’s head spin – on a daily basis.

But most importantly, the amount of change that the industry has gone through over these short, jam-packed years has not been kept up with by either the ‘best practices’ or the ‘delivered technology’.

Paid search management is a young profession, one in which everyone has been learning on the job, sharing info via the web, and attending  those endless conferences, but past a very small number of truly universal tactics there is no agreed upon ‘right way’ to organize and manage paid search, in even the most general sense.

That’s no way to spend $9 Billion or $10 Billion.

And the software tools haven’t fared will in this rapid-change environment either. The engines built interfaces that primarily serve their own needs. Instead of thinking about how paid search managers actually should and do work, and building tools to facilitate this effort, the tools are organized around the needs of the engines and their algorithms.

This leaves search managers often facing screens with 5 open applications, each which has one piece of the data or one tool they want, none designed for the whole job. In this environment work flow requires on a lot of application and context switching, cutting and pasting, and mental contortions supported by the acceptance of silly limitations and obvious inaccuracies.

We think it’s time for both the process and technology of PPC to catch up with the market realities and demands.

Introducing High Resolution PPC & ClickEquations
In the next few posts I’ll formally introduce both High Resolution PPC and ClickEquations.

High Resolution PPC starts with three primary goals – targeting the right prospects, assigning an accurate value to each, and then satisfying them. It provides the context for using the available paid search controls and options with clear ways to measure results and priorize work.

ClickEquations was and is being developed with three primary goals as well – delivering clear and accurate data, helping to prioritize opportunities and tasks, and automating as many PPC process steps as possible.

We’re excited to share the results of the last few years of work, and are eager to get your feedback.

After the upcoming introductory posts, I’ll deep dive into the specific components of each over the coming weeks and months.

Last week I taped an interview with WebMaster Radio, in which we discuss my SES presentation on SEM Analytics, and talk about ClickEquations and how it can help paid search managers.

If you’ve got a few minutes, check it out! Click the image below to go to the page where you can start listening.

And when you’re done listening, please rank the episode (if you like it) so it can get more visibility on the WMR ‘hot lists’ – thanks.

One thought I wasn’t able to put in the last post about missing and misleading click data, was about keyword click-through-rates.

Do keywords really have click-through-rates?

Objectively they do because the engines report them. But does that make sense?

If A Keyword Falls In The Forest, And The User Doesn’t See It…

The user doesn’t even know the keyword exists. The user typed a query (which in some small percentage of searches was exactly matched to the keyword, but far more often was only related to the keyword) and was shown (if they even saw it) a text-ad (containing some specific copy) in some position on the page in relation to a number of other text-ads (not to mention the organic search results.)

What portion of the influence in that click, or lack thereof, did the keyword have?

• We know different text-ad copy produces different CTRs.
• We know different positions result in different CTRs.
• We know that the presence or absence of specific competitive adds produce different CTRs.
• We know different queries that may match to the same keyword in broad or phrase match type have different CTRs.
• We can assume that CTRs vary by time and the geography of the user.
• There must be a couple of other factors I’m not thinking of right now… (comments?)

So does the keyword really have a CTR, or do the combinations really have CTRs? Clearly the Keyword CTR is the average of a range of different situations and conditions.

The Average Average is Only So-So

There are a lot of averages presented in search analytics. That’s necessary as we can’t handle all the granules, but close attention must be paid to the composition of these averages, lest they be less than clear or useful.

If the campaign is reasonably constructed in terms of organization and match type application, and are being reasonably run (meaning the text-ads and bids have both logic and dilligence being regularly applied to them), then the average CTR as reported for keywords can be useful. If any of these elements are missing, the utility dwindles rapidly.

As with most averages in PPC reports, if you aren’t sure dive down and look at the components – the more performance diversity you find inside the less weight you should place on the average.

Know Your Metrics

Just another example of the fact that even the simple metrics of paid search have more to or behind them than you might realize, and how some understanding and healthy skepticism can help you get closer to truly understanding what’s happening in your campaigns.

(Credit where it’s due: The idea of questioning KW CTRs, and many other ideas you’ll find in this blog from time to time, was first suggested by Bruce Ernst)

(Upcoming Events: I’ll be at the Semphonic XChange Conference in San Francisco on Aug 17-19, and am Speaking on “Identify, Analyze, Act: SEM by the Numbers” at Search Engine Strategies in San Jose on August 19th)

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.