ClickEquations Blog

The last post covered the basics of revenue allocation in paid search, and discussed the four methods of allocation supported in ClickEquations; last click, first click, linear, and weighted.

Deciding between even these four allocation models is not simple. None of them perfectly captures the complexity of our interaction with the many different prospects visiting our site. None of them turns our paid search or online marketing efforts into a simple, accurate, clearly instructive number.

This is not true just in terms of the simple matter of how to spread revenue across successively clicked keywords. There are also other complexities in the real world that impact the accuracy and appropriateness of any allocation method.

Time Frames
While attribution is chiefly recognizing the fact that many visitors come to your site multiple times from multiple keywords before converting, it also matters that these visits and the final conversion event also occur over a span of time.

First, you need to define the range of time that will be considered when tracking the string of visits. This is generally referred to as the ‘cookie length’ or ‘cookie duration’ but we call it ‘Conversion Tracking Range’ in ClickEquations.

The default range in most packages is 30 days, although in ClickEquations and many others you can customize this range to be just about any length that is appropriate for your business. It should be set to a length which will cover the vast majority of full purchase cycles that occur in your business.

Since the purchase of paid search software is generally a long and considered purchase among high volume advertisers and agencies, we use a 4 month range for our own ClickEquations.com tracking, for example.

Assuming you’re using the standard 30-day length, if a person visits your site five times over two months before purchasing, only those visits within the 30 days prior to purchase will get any revenue allocation no matter which method you’re using. And since people often purchase many days after their last PPC visit, this can easily exclude the majority of the related visits if your range is incorrectly set to too short of a period.

Most web analytics packages provide ‘days to purchase’ reports. Consult these to see the history of your site and then set your cookie length appropriately.

Revenue Allocation Over Time
If visits happen over time on multiple keywords, allocation is going to spread the revenue to one or more keywords, but on what date should the revenue be recorded?

Should the keywords record the revenue on the date of the conversion event? Or should the keywords get the revenue on the date of the click?

There is a huge difference between these two options. The first results in keywords gaining revenue on days when they may not have been clicked, and avoids any matching of expenses and revenues. This is ‘cash basis’ accounting. Yet this is the most common method of revenue allocation.

The alternative is like ‘accrual basis’ accounting, where we’ll match our expenses with our revenues – if I paid for a click last week and it eventually generates revenue, that revenue is allocated to the day of the expense and I can see the net results for that day.

To look at this in greater detail, let’s revisit our example from the prior post, with a few new details. Suppose each of the three PPC clicks took place on a successive Monday morning, with the purchase on the fourth Monday. Three of these Mondays were in the current calendar month, but the first took place last month.

Assume for now we’ve chosen Linear allocation. And to make this example really clear and simple (something the real world is not) assume that these keywords received no other clicks during this time-frame. Lastly, assume each click cost us $10 – So we spent $40 to get our $100 sale.

In the common ‘cash basis’ reporting used by most web analytics and PPC management tools, a ‘month to date’ report would show that we’ve spent $30 and earned $100 related to this transaction. This reflects the fact that our first $10 click took place last month but the revenue is all allocated to the three keywords on the date of the purchase.

Our keyword report would show us that two of the keywords had costs and revenue this month, but one had revenue but no cost. The cost took place last month and therefore won’t show up in the report. Note that is also is why you’ll often see keywords with revenue and no clicks – the clicks that generated that revenue took place in a prior reporting period.

Of course, this same report (when expanded to all keywords during the timeframe) will show us costs for clicks that won’t produce revenue until some time in the future. This is why the reports don’t all look entirely whacky, but unless your business and marketing has absolutely zero seasonality or time-based variations of any kind is why the average monthly expense/revenue report for PPC – on a keyword or adgroup or any other basis – is of very questionable value.

The alternative, which incidentally is what Google AdWords does (but not Google Analytics nor just about any other package I know about), is to shift revenue back to the date of the relevant click.

The implication of this is that revenue numbers for days long gone can change. If you ran a revenue report for last week on Monday morning, but then someone who clicked a paid ad last week came to your site via a bookmark and purchased, that revenue would be credited back to the keyword last week, and your Monday mornning report is obsolete and inaccurate.

Since AdWords uses a 30 day cookie, any AdWords revenue report covering dates within the last 30 is ’subject to change’. Adwords only supports last-click allocation so this doesn’t make the kind of mess using this method would for first or linear allocation. But very few people are aware that this is what’s happening.

Subsequent Conversions
Each click-chain ends in a conversion right? But what happens if they buy again?

Suppose after our $100 order, the same person returns 3 or 5 days later – before they did another search – and buys again. Should the keyword(s) that received revenue credit for the first sale get allocated money from the second sale?

In ClickEquations and AdWords and most current systems, it does, within the same time range parameters as the cookie. This raises questions and issues in it’s simplest form, and not all the forms are simple….

In The Simplest Terms
As I’ve argued before, paid search marketing has become quite complicated. But it’s still easy to spend money and even easier to aviod the complex reality and accept overly simplified views of how the marketplace you’re participating in really works.

Reality however is sinking in. The broad interst and embrace of Quality Score is a level of detail and sophistication that wouldn’t have happened two years ago. The strong growing interest in revenue allocation is another example.

Moving away from Last Click allocation to some form of Linear or Weighted allocation is, despite all the other options and complexities (including those highlighted in this post), a substantial step.

That is not to say there is really a one-size-fits-all allocation solution. There are many valid reasons why different businesses should choose different allocation models and even use/apply them differently. And we’re just talking about revenue allocation within paid search; the real solution will ultimately have to allocate revenue across all visits of all types.

Until I write a more detailed post on that, I’ll stand by the idea that last-click has gotta go. But as this post tried to point out, it’s complicated, there is more work to do, and marketers should understand all the grains of salt with which they need to read the numbers on their daily and weekly and monthly reports.

Related posts:

1. Revenue Allocation (Attribution) Models in ClickEquations One of the new features in...
2. Revenue Allocation Madness Here’s a wild one to end...
3. The Crazy World of Revenue Attribution Revenue attribution is how you (or...
4. Attribution Question For You The issue of how to allocate...
5. Quality Score Final Thoughts (for now) Over the past 7 days we’ve...
6. Top 3 Blog Post Series of 2009 As promised, we continued counting ballots,...