SEOmoz Daily SEO Blog |
Remembering a Dog Named Goodnewscowboy Posted: 16 Aug 2011 05:51 AM PDT Posted by gfiorelli1 This post was originally in YOUmoz, and was promoted to the main blog because it provides great value and interest to our community. The author's views are entirely his or her own and may not reflect the views of SEOmoz, Inc. Sunday, August the 7th, was a sad day for the Moz community when we lost a beloved member due to cancer. Maybe the newest don’t know him, but there was a “Dog” here that was the smartest and funnier commenter of all: we knew him as goodnewscowboy; his real name was Bullitt Darlington. The Moz community is proud of these qualities, so well expressed by the SEOmoz TAGFEE Tenets:
and Bullitt was the best example of this philosophy. Transparent, because – even though he used for a long time the photo of his beloved golden retriever – we always knew he was talking from his soul; Authentic, because he never hide himself behind a curtain of presumed knowledge or superiority; Fun, because he was able to invent the most amusing joke and his a la Laurel & Hardy comments threads are going to be in the story of the SEOmoz blog; Empathetic, because he was there when someone needed it, with an email, with a tweet, with a comment in Facebook; Exceptional, because his intuition was so lucid, that he was able to argue and well guess so many things in SEO and marketing... while declaring, in his honestly and humbleness not being a real SEO. Yes, SEO was not Bullitt’s main profession. It was his dream, what he wanted to be and what he started to be and preparing to make as his real job, one of the passions that made him fight his cancer. But he was an SEO in his heart. I still remember a night this last January when I, Bullitt, Casey and Dr. Pete where having a totally not SEO chat on Twitter. It was like a conversation friends have sitting in a bar and sharing a beer, nothing remarkable, but unforgettable was that sensation of closeness we felt for few minutes. We left with a promise that Bullitt’s health prevented us from making: to have the same conversation but in person during the last MozCon in Seattle, where we all were going to be. Bullitt has passed away, but someone only dies when the last memory of him fades away. His 2689 comments here will make live in our memory always. Go and read them… and remember a man called goodnewscowboy.
From the SEOmoz staff: We remember Bullitt Darlington, aka goodnewscowboy, as the most kind, witty, helpful and warmhearted soul to grace this community. Donations in Bullitt's memory can be made to the Salvation Army, one of goodnewscowboy's favorite charities. Below are some of our favorite comments from goodnewscowboy. Feel free to share your own memories in the comments below. He wouldn't want it any other way. |
How to Get Search Volume Data Straight into Excel [Mozcon Debrief] Posted: 15 Aug 2011 02:00 PM PDT Posted by richardbaxterseo A few weeks ago I attended (and had the honour of speaking at) Mozcon. Mozcon is without a doubt the best SEO conference I’ve ever been to, and I’ve been to a lot. It rocks to be amongst so many stars! Anyhoo, just to say thanks to the Mozteam for flying me over to sunny Seattle, I brought them a new toy to play with. And the best part, it’s free for anyone to use. Introducing the Adwords API Extension for Excel. Oh Gosh, Richard Made a VideoMy team were insistent – no light piano jazz this time. It sucks. I have no idea what’s wrong with them – elevator music is awesome. So here’s a quick tour in my best British accent. Think: “shine yer shoes, Guvnor?” (If you’ve ever heard Rand’s Brit accent attempts, you’ll know where I’m coming from with that.) Get Yourself an Adwords API KeyObviously that’s a pretty quick tour in the video, so it didn’t include the fiendishly simple set up process. So you know, you’ll need an Adwords API key. Adwords API keys are available to My Client Center account holders. Get one of those from here. For whatever reason, it’s tough to migrate to an MCC account from a plain old Adwords account, so take my advice and create a fresh Google account login for your Adwords API. Learn the QueriesLearning the queries is pretty easy. Here are the most important: getAdWordAvg() getAdWordAvg(keyword,"[MATCHTYPE]","[COUNTRYCODE]","DEVICE") Example: =getAdWordAvg(A1,"EXACT","GB","WEB") Description: returns average search volume from the adwords API. Matchtype accepts broad, exact and phrase match. Country codes can be found in the Adwords documentation and devices can be mobile or web. arrayGetAdWordStats() arrayGetAdWordStats([TABLE],"[MATCHTYPE]","[COUNTRYCODE]","DEVICE") Example: =arrayGetAdWordStats(myKWlist,"EXACT","US","MOBILE") Description: array formula (auto adds {} brackets) will return data from a list of keywords in a table (average search volume and seasonal data). arrayGetAdWordIdeas() arrayGetAdWordIdeas([TABLE],"[MATCHTYPE]","[COUNTRYCODE]","DEVICE",[NoOfResults]) Example: =arrayGetAdWordIdeas(Table1,"BROAD","US","WEB",20) Description: array formula (auto adds {} brackets) will return suggestions from a list of keywords in a table (average search volume and seasonal data). I Want, I Want! Gimme the Download! Gimme!Just so you know, the full installation guide is over on SEOgadget. All you have to do is download this zip file and run setup.xls. That’s all! After years of working with Excel, I’m still really excited by it. It’s solved a lot of problems for me in the past and I'd just like to personally thank my chief data wrangler and master datasmith of Choice, Tom Gleeson. He rocks. I’d really love to hear your thoughts, feedback and of course how you’re using the extension to work smarter in your keyword research. |
You are subscribed to email updates from SEOmoz Daily SEO Blog To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 20 West Kinzie, Chicago IL USA 60610 |