Reporting TRUE AdWords Assisted Conversion Values


Great, Multi-Channel Expectations

When Google Analytics Multi-Channel funnels first came out, we were AWED and AMAZED. The metrics I latched onto first were the assisted transaction and revenue attributions. At last! Now those lower-converting AdWords campaigns could show their value. I knew they had to be doing something, but I didn’t have the tools to prove it before.

A Sad Discovery

I quickly came to discover, however, that these Assisted attributions are not in addition to the Last-Interaction conversions but rather include any conversion that involves an AdWords click along the conversion path, even if the Last-Interaction conversion was through AdWords as well. This means that we were reporting overlapping attribution on our AdWords transactions and revenue values! Basically, we couldn’t get anywhere near accurate revenue values for Assisted and Last-Interaction Conversions when combining their values together.

Data-Driven Redemption

That is, until we built a User-Defined Conversion Segment. We call our heroine “Exclude AdWords Last Interaction.” She looks a little something like this:

Exclude AdWords Last Interaction

Turn on this segment in the AdWords section of the Multi-Channel Funnels Assisted Conversions tab and it’ll set all of your Last-Interaction values to zero in addition to excluding any overlapping Last-Interaction revenue attributions from your Assisted conversion metrics. These are the REAL sidekicks — none posing as the breadwinner.

True Assisted Conversion Value

These reports now show overall revenue numbers that I can pass on to clients and not feel like they’re being quite so duped by the illusions of attribution as I once was.

If you need help setting up this segment or any similar to it, we’re here to help. Just let us know.

What the Wire Can Teach Us About SEM – Part 1 of 2


The Wire is everyone’s favorite show for a reason. A deep well of characters, a sprawling narrative that felt intimate and alive, a searing critique of the drug war and a top to bottom post-mortem on the heart of a once-great city. It could only be described as, well, “Dickensian.” Sorry, Gus!

The Wire was one of those shows that kept you on the hook with long-developing plot lines (investigations, mergers, a series of major news reports) that typically extended over an entire season. It also delivered incredible quotes and moments of drama and comedy on a weekly basis – sometimes both in the same scene. It’s what gave the show its weekly entertainment punch to go along with its historical level of sophistication and “reporting.”

Here at Delegator we’re big fans, and we even started using some of those quotes around the office to reference some of the things we were doing for clients related to AdWords, SEO, Analytics, and more. With a recent upswing in attention on the show (thanks Grantland!) we thought now might be a good time to share with our clients and readers what we’ve been talking about for years. Search Engine Marketing – As Explained by the Cast of The Wire. Sheeeeeeee…

“When you take a shot at the King, you best not miss.” – Omar Little

Omar Little

Taking aim at the number one Google ranking is a formidable task. That’s especially true when you happen to be going up against another entity that a) has a clearly more relevant relationship to the keyword than you do or b) can spend you under the table. Unfortunately for most companies, it’s not a realistic goal.

Now that doesn’t necessarily mean you shouldn’t try, or shouldn’t at least set it as your goal. Sometimes toppling the king is easier than you thought (just ask Marlo). But more often than not, as Wee-Bey found out, you end up eating chicken salad across from Bunk and McNulty. What is realistic for most companies is getting a few corners of their own – corners the big boys  might not know about. The way to do this in SEO is by investigating and then investing in long tail keywords. Maybe Huge Company X has the market cornered on “The Wire Posters,” but you could get a real foothold in “Michael K. Williams Posters,” “Omar Little Wire Posters,” or “Omar Little Season 5 Posters.” You won’t get quite as much traffic as you would for a generic term, but the traffic you do get will be specific, and motivated to convert.

The only way to achieve a ranking like that for a competitive keyword is perfect preparation, determination in the form of time and money, and luck.

“Look the part, be the part.” – Proposition Joe

Proposition Joe

Joe came in for some ridicule from Avon when he showed up to the annual East/West showdown in full “Pat Riley” suit and tie regalia, but his commitment to looking like a “real” basketball coach helped him coach with more authority and confidence. In other words, getting the look right helped him get the job right. That, and a hired ringer. This is a lesson that can be easily applied to SEM.

Everything starts with your site design. A newcomer to your site should immediately be able to understand what you’re about and trust that you can deliver the goods. Building that initial trust element and creating a homepage that effectively funnels users to the pages you want them to hit is a complicated, multi-faceted process, but it’s a time and design investment well worth making. When you look like a “real” site, you’ll see yourself start to perform like one.

“Our job is to report the news, not manufacture it!” – Gus Haynes

Gus Haynes and Scott Templeton
Season 5 of The Wire was about the breakdown of professional ethics within the main character, Detective Jimmy McNulty, as well as the august offices of the Baltimore Sun (where series creator David Simon began his career as a journalist). McNulty, frustrated with the lack of institutional support for his wire investigations, (SPOILER ALERT) fakes the presence of a serial killer by “adjusting” bodies post mortem. Scott Templeton, a hotshot up and comer at the Sun, began his career making up innocuous stories about wheelchair bound children going to Orioles games, but he eventually begins to stretch the truth about the serial killer case – he is the only reporter the “killer” ever contacts.

In the end McNulty loses his badge and Templeton wins a Pulitzer.

When you go with “black hat” SEO – SEO that attempts to get around Google standards and practices through any one of a dozen illicit strategies – you’re taking the same chance. Maybe it will work, you won’t get caught, and your business will go up, up, up. But maybe you’ll get caught, blacklisted, and penalized indefinitely in the organic results, crippling and even killing your business. Is that really a chance you want to take?

At Delegator we only do “white hat” SEO. Be very careful before getting in bed with any firm that doesn’t, and make sure that if you’re running your own SEO operation you don’t cross the line. It’s not worth risking your entire business.

“If Snotboogie always stole the money, then why did you let him play?”

“Got to. This America, man.” – McNulty and Man on Stoop


Anybody can play the AdWords game. Doesn’t matter if they don’t understand it, try to cheat it, or run their accounts into the ground. Because it depends on the quality of your site much less than the value of your dollar, it’s as open as it gets in the land of SEM. The only thing you need to play is money – Google allows you to set up your account and start spending faster than you can run down to your neighborhood game of bones (though your ROI is likely to be higher with Google). You will almost certainly need an expert to guide you through the weeds with no pain and plenty of profit.

Active AdWords management is the best way to navigate the choppy waters of paid search. Active management means going in every day and making changes, re-organizing, raising and lowering bids, and identifying and exploiting new best practices. That’s the only proven way to consistently stay ahead of the curve when it comes to the wide open AdWords game.

Come back for more Wire action next week!

Part 2 of 2.

Riding the New Google Analytics Features Roll-Out


With great patience, we’ve all been waiting for Google Analytics to roll out new features on its swanky, contemporary interface. As the resident analyst here at Delegator, I admit I was wary of the new Analytics when it first appeared this past fall. I compulsively clicked  the “Old Version” option in the top navigation bar upon logging in for a couple of weeks, but I gradually (begrudgingly) trained my eye to the new look and feel. And as any good love story goes, distaste slowly transforms into bedazzlement for my new GA beau as each refined feature appears.

New Feature Improves Productivity

The first thing that stood out to me on the new interface was how much more user-friendly it is than the old version, which meant it didn’t appear to be quite as analyst-friendly as I desired. It was easier to find the quick hit metrics, but I didn’t initially see how the layout was as conducive to cross-metric analysis. As each new feature is released, however, I find my worries falling away one-by-one. There are a couple of highlights worth noting already, and they haven’t even rolled out the custom reporting PDF or email features yet (hint hint)!

1. Multi-Channel Funnels

Most notably, the multi-channel funnel feature has improved my traffic sources-conversion analysis beyond compare. I’ve singularly used this tool to optimize a small AdWords account within the past month, which resulted in truly staggering ROI results. For companies with fewer conversions, having this ability to optimize for assisted conversions adds a level of unprecedented refinement to data analysis that I didn’t even think to request.

2. Converting Standard Reports Into Custom Reports

I’m trying not to go too crazy on this one. When I saw the “Customize” option in one of the Standard Reports tabs, I gasped thinking of the endless reports I could build from these standard platforms. However, I do urge caution on this frontier. Building custom reports from scratch may be a pain, but they remain my most valuable reports. I can imagine this customize feature being incredibly useful in instances where you really do just need to add one or two more metric columns to a standard report, but I don’t think it should supplement the careful planning that typically goes into a custom report. Customize wisely, my analytical brothers and sisters.

Much to my delight, the new Analytics interface is beautiful and fast. With fresh new buttons, streamlined categorization, and new dashboard building options, it seems Google is finding that sweet spot where Analytics will please both the average user and the analytics guru alike.