Are you sorting by the wrong column?

Every account review starts the same way. Open the search term report, sort by Spend, high to low, start reading from the top. That is how all of us learnt it and that is how most of us are still doing it.

For Selterm the top of that list was ugly. $5,767 in four weeks on search terms that gave back zero orders. Zero. Monthly spend is $22,000, so 26% of the account was doing nothing, and it was the worst number across the fifty accounts we manage. For an account that has the great ACoS at 18% the number never didn't sit right.

Is this what a large tail looks like?

We ran the same 900 terms through our SellerBridge tool, and just asked it ignore the spend and sort via clicks. What we got was a completely different version on what we would normally read. 637 had exactly one click. Another 121 had two. That is 84% of the lines and, at a $1.00 CPC, $879. Fifteen percent of the money. We thought 637 was a waste, Selterm converts at 7% so 637 single click terms with nothing to show we thought it was a waste. Realising something that we only read in our text book is always a EUREKA moment and we were like hmmmm… that's what a Large Tail looks like.

"Not everything that costs money is a leak"

The strange ones are the terms sitting at fifty clicks or more with still no order. So the negation list is thirty lines and $1,800. Not nine hundred lines and $5,767.

Sounds like a small answer until you cost the other one, and that is where the evidence layer earned its place. Negate the whole tail and we pull 5,767 clicks out of a four week window, 26% of the account's click volume. Most of that tail sits inside the auto campaigns, which carried 73% of Sponsored Products spend and feed terms into the other 24.

Cleanup always looks like a past mistake on the day you do it.

What we did: thirty exact negatives, ad group level only, so the auto campaigns keep discovering. Ten minutes of work. The other 870 we left alone and wrote down that we left them alone, on a client call "we didn't touch it" and "we checked it and it isn't a problem yet" are very different sentences. The $1,800 went back into terms that already convert, which at Selterm's numbers is around $10,000 of sales in the same four weeks.

Then we stopped doing it by hand. SellerBridge runs the click depth cut weekly on every account, each against its own conversion rate, and it only brings back the terms that have moved past the threshold since the last check.