Magic AdWords Button
Frustrated with the
confusing and messy spreadsheets
you get from the AdWords Report Center? Missing crucial conversion data
because it takes so darn long to make any sense of the vast fields of
numbers?
The Magic AdWords Button instantly turns Microsoft Excel
into your own personal AdWords Conversion Valet!
This tool
will save you dozens of hours poring over AdWords reports - and will
highlight the "Instant Pay Raise" actions you can take to boost your
profits 20-75% - like magic!
"Shine the Light on Profit Leaks"
That's one of my
favorite David Bullock phrases - as soon as he gets hired to make a
website more profitable, he sets up tracking and reporting so he can
"Shine a Light on Profit Leaks."
Once he sees exactly which
keywords are wasting money, he pauses them.
Once he
identifies the best-performing ads (in terms of money in the bank, not
CTR!), he kills the rest.
Once he find the content sites that cost
more in clicks than they generate in sales, he excludes those
sites.
The result: Instant and Significant Improvement. Without researching new keywords, creating new ads, or
designing new pages. Without being brilliant, clever, diligent or
empathetic.
So why don't we all do that? Because - until now - in
order to take advantage of the powerful reporting tools in the AdWords
Report Center, you needed to be a freaking Excel expert. Otherwise you
were just looking at a giant spreadsheet filled with thousands of cells of
who-knows-what, trying to find needles in the haystack of
figures.
Unnecessary columns - who cares about "Ad ID" anyway?
Elizabeth Makes a Magic Button
I've been doing
AdWords professionally since early 2003. Until recently, I had just
resigned myself to the long, boring, repetitive work of sculpting these
messy and confusing spreadsheets into actionable data. After all, I
decided, that's my competitive advantage. I know how to build a flashlight
to shine the light on what is and isn't working. So my clients can stop
what isn't working, and do more of what is.
Then I hired Elizabeth
as a project manager.
Elizabeth is a neighbor of mine. Very
brilliant person. Professor of Computer Science at a well-known North
Carolina university, specializing in advanced Excel programming. Ready to
take on the entrepreneurial joy ride.
I didn't hire her for the
Excel stuff. Like I said, I thought I had that handled.
No, I
asked Elizabeth to set up systems that could harness my feverish
ADD-addled brain and make sure I stay productive after my morning sugar
rush wears off. Keep me focused on creating value. Finishing what I start.
Remembering to show up for appointments. And to handle some of the routine
AdWords work that I do for clients - running reports, prepping me for
meetings, looking for ways to automate parts of the business.
So
one day Elizabeth came into the office and told me, "I got tired of doing
the same stuff over and over again with the reports. So I spent the
weekend automating the three main reports - keyword, ad and placement
performance - so I just press a button and they get formatted exactly the
way I want them."
I watched as she took raw ad performance data
from Google and with one click and 4 seconds of waiting, turned into a
clear spreadsheet that had bolded every winning ad.
Then she
grabbed a keyword report and one-clicked her way to a color-coded, "This
is losing you money and you should stop doing it" cheat sheet.
And
then she did the same thing with a placement report.
I was
flabbergasted! Elizabeth had turned my precious "TWAFA" methodology, the
guts of what I do for my clients, into a damn button! (TWAFA stands for
Test/Watch/Act/Filter/Automate. I registered TWAFA.com, just to have
bragging rights to a 5-character .com domain, but I have no idea what to
do with it. Anyway, I digress...)
I admit, my pride was hurt for a
while. But then I remembered that it was my IP in there, and I felt
better. And then I installed the Magic AdWords Button (her words) onto my
computer (it took about 15 seconds) and started churning out valuable
reports left and right.
Take a look at the following screen shots to see what you'll get from the Magic AdWords Button:
And check out these short videos of the Button in action:
Who Will Benefit from the Magic AdWords Button?
You have to be tracking either leads or sales. If you're not paying attention to site conversion, this tool will not help you make money. For that, you need a Magic 8 Ball:
You: "Should I choose the ad with 0.9 CTR or 1.1 CTR?"
Magic 8 Ball: "Signs point to yes."
Actually, the Magic 8 Ball doesn't look like it's going to be much help there either.
Why Use Magic AdWords Button?
Now, you either run reports right now or you don't.If you don't, you should.
If you do, you're probably spending more time than you should massaging the data, or less time than you should acting and improving your ROI. Or both.
A Client Case Study
On February 7, we installed conversion
tracking and started running reports. On March 1, I paused 30% of the
keywords and resolved 15 split tests.
Result: ROI jumped from 300%
to 500% overnight.
Translation: this client used to spend $35 to
make $100. Now they spend $20 to make the same $100. So they can put all
that extra cash in their pocket, instead of shoveling it into Google's
endless pockets.
Now, I didn't have the Magic Button back then. I
did it all manually. But that's my job.
Have you been doing TWAFA?
If not, would you Test/Watch/Act/Filter/Automate if it were as easy as a
single button?
And if you are an AdWords Professional, what
would it be worth to you to have most of the repetitive grunt work of your
job magically eliminated?
Q: Will the Magic AdWords Button
work on my Mac / PC / Office 2007 / OpenOffice / iPhone / Vita-Mix Blender
/ etc?
PC: Excel 2003, Excel 2007
Mac: Excel 2004
It isn't yet configured for Open Office, and we haven't yet gotten our hands on Office 2008 for Mac (I hear it sucks, so I haven't bought it, but maybe I'll sneak a copy of Magic AdWords Button onto the 24" iMac at the Apple Store next week and give it a try).
Q: I'm not a geek. How hard is it to install and configure the Magic AdWords Button?
A: I'm not a geek either, and I did it in about 20 seconds.
Check it out:
Q: How Much Does Magic AdWords Button Cost?
A: $147 - for now.
Elizabeth estimates that she's spent about 45
hours working on the button. She's a $150/hr programmer. My trusty
calculator informs me that the tool has cost $6750 to develop. So you
could expect to pay that much to create it for yourself. Maybe a little
less, maybe a little more. Now, if you're doing a significant amount of
Adwords business, that probably would pay for itself in a month or less.
But economies of scale are beautiful things. Because I'm the one
who's paid for the development (if you count charming smiles and the
occasional paltry check as "paying"), and I have access to thousands
of AdWords users, I can sell the Magic AdWords Button for a tiny fraction
of what it would cost you to develop it yourself. (And in case you're
worried about me exploiting Elizabeth, she and I are splitting the profits
50/50.)
Q: What's your guarantee?
A: The Magic AdWords Button will work with your version of Excel or your money back (you have 30 days to make sure).
Will you make $103,453.89 in the first 60 days after downloading MAB? Who the heck knows? This isn't one of these Get Rich on the Internet courses. It's a tool that allows you to do quickly and easily and conveniently what before was time-consuming, hard, and annoying. If that something - identifying profit leaks in your AdWords account - is valuable to you, then MAB will be valuable too.
Click here to purchase MAB from my much-less-annoying-now-that-they-redesigned-it 1ShoppingCart order form (which you should always euphemize as an "Action Form" or something like that, because you never want to alert your customers to the fact that they will be giving you money, because they're that stupid, right?).
Sincerely,
Howie Jacobson, PhD
Gentleman and Author of AdWords For Dummies
PS Click here to buy from a much shorter blue link.
PPS And an even shorter one.
PPPS Buy Now.
PPPPS Buy!
PPPPPS !