Video Introduction to Raven Tools

Those of you who are regular readers of this blog, clients or students of Search Engine College will know that my favorite and most-used piece of equipment in my search marketing toolbox is Raven Tools.

Jon and the team at Raven have worked tirelessly over the past few years to fine-tune and polish the collection of tools available to the point where my day starts and ends within the Raven Tools interface.

Lately, I’ve had some clients and workshop attendees ask me what particular features of Raven Tools I use most often and which ones I think would benefit them the most. This is a difficult question to answer, because I tend to use ALL the features at different times, depending on client requirements and specific projects.

For example, one day I might use the AdWords Insights feature to discover how to further boost the ROI of a client’s AdWords account, while the next day I might use the Site Auditor and Reporting features to produce a 100 page Web Site Audit for a new client.

Just yesterday I used Raven Tools to help a client research keyword data and decide between two different keyword phrases to target on a product landing page. After lunch I sent another client a Social Mentions report revealing how often their brand was discussed last month on social media channels.

Explaining all these features of Raven Tools in detail is simply not possible in a single conversation. Thankfully, the team at Raven just released a new video which does the job for me, briefly outlining all the stand-out features and benefits. They offer a 30 day free trial and if you decide to purchase, the price won’t give you sticker-shock like some of those other marketing tool suites.

If you haven’t already tried Raven Tools (or even if you have!), check out the video above and see if it has the potential to turbo-charge your site marketing too. Click on the video at any time to be taken to Raven’s own site.


Spread the joy!

The 12 Days of Christmas Online Scavenger Hunt

santa-sackIt’s beginning to look a lot like Christmas. And what better way to kick off the holiday season than by receiving a Christmas present from Search Engine College?

All last week, we were tossing about ideas for how to gift our blog readers and members at Search Engine College in a fun and unique way this holiday season. We could have sent out an animated snowman card; we could have given out a boring discount coupon; or we could have had a one-day Black Friday sale that many people would have missed out on.

But this year, we’ve come up with something completely different. Presenting: the 12 Days of Christmas Online Scavenger Hunt!

How to Win

Every day for the first 12 days of December, we are giving away a 6 month subscription to Search Engine College. Each subscription includes access to ALL our online courses and training videos, as well as our exclusive discussion forums and industry discounts area. Each 6 month subscription is worth USD 594. That’s over $7,100 in prizes to be won!

All you have to do to win is be the first person to find the Christmas icon hidden somewhere on our web site at The icon will change daily and will look like one of the following:

As soon as you spot the Christmas icon, simply tweet the page URL to us @secollege so we can verify and send you your prize. Make sure you follow us and use the hashtag #xmasscavengerhunt in your tweet. If you don’t have a Twitter account, simply post the URL and hashtag to our Facebook Wall, or our Google+ Page, or you can email the URL to us study [at] searchenginecollege [dot] com.

We will have a countdown banner at the top of every page on Search Engine College reminding you which icon you are looking for and how many hours/minutes/seconds you have left to find it. When someone has found the icon, the banner image will change to WINNER FOUND and the clock stopped until the next icon is posted. And NO, the banner icon does not count as a find - it must be within the page body ;-). Also, category or tag archive pages don’t count. We need the individual post/page URL please.

There will be 12 winners in total (1 each day) and if the icon isn’t found one day, it will carry over to the next day until all prizes are won. If you win and are an existing paid member of Search Engine College, your free 6 month subscription will be tacked on to the end of your existing subscription.

We will send out clues to the icon’s location and announce our winners each day via Twitter, Facebook and Google+. If you are already on our mailing list, we will also email you a picture of the day’s icon in advance to give you a headstart.

Starts 1st December

As this competition is a global one, we have tried to plan the daily start time to suit as many timezones as possible. The fun kicks off at the following times:

  • New York (U.S.A.)  Sunday, 1 December 2013 at 5:00 p.m   EST  UTC-5 hours
  • Los Angeles (U.S.A.)  Sunday, 1 December 2013 at 2:00 p.m   PST  UTC-8 hours
  • London (United Kingdom)  Sunday, 1 December 2013 at 10:00 p.m   GMT  UTC
  • Sydney (Australia)  Monday, 2 December 2013 at 9:00 a.m   AEDT  UTC+11 hours
  • Wellington (New Zealand)  Monday, 2 December 2013 at 11:00 a.m   NZDT UTC+13 hours

So don’t miss out, - make sure you brush up on your searching skills in advance and join us for the scavenger hunt fun from December 1st.

Happy Holidays from Search Engine College!

Spread the joy!

5 Must-Have Spreadsheets For Online Marketing Professionals

I_love_spreadsheets_hatAs an online marketing consultant and trainer for the past 15 years, I have used a LOT of online tools to help me do my job.

I’ve seen time-saving tools come and go in crazy peaks and troughs. I’ve also seen a few that have ridden the waves of consumer fascination to become permanent fixtures in the online marketer’s toolbox.

Below are 5 spreadsheet-based tools that I use myself or recommend on a regular basis:

1) Distilled’s MS Excel for SEOs - This Excel-based workbook is like a detailed instruction manual for SEOs on how to manipulate bulky data into logical form using Microsoft Excel. If you are an Excel wizard, you’ll love this tool. If not, you’ll probably need a week to wrap your head around the analysis, but it will be worth it - I promise.

2) HubSpot’s Blog Editorial Calendar Template - If you are a content curator or social media marketer, this template will save your life. It simplifies calendar-based content allocation and helps you prioritize content deadlines and build an annual strategy to meet multiple marketing campaign objectives.

3) Shimon Sandler’s PPC Campaign Kick-Off Template - this Excel template is quite a few years old now, but I still use it as a starting point when kicking off a new AdWords or Bing Ads campaign for a client. It helps you and your client to focus on the big picture objectives and build a unique campaign to suit specific requirements rather than implementing a cookie-cutter PPC campaign that needs tweaking to fit.

4) Google SEO Rank Checker Spreadsheet - a recent discovery, this customizable Google Docs template is all kinds of awesome. It includes a clever integration of ImportXML that allows you to collect at-a-glance keyword rankings on Google in real time.

5) Outspoken Media’s Link Building Spreadsheet - another Google Drive shared doc, this is a customizable template consisting of a gigantic list of link building strategies collated by Rhea Drysdale and her team at Outspoken Media.

Sick of paying others to SEO your site? Download my Free SEO Lesson. No catch!

Spread the joy!

Search Industry Job of the Week - Creative Editor - Paid SEM Media

Job Title: Creative Editor - Paid SEM Media
Job Reference: Unknown
Position Type: full time
Name of employer: The Search Agency
Location: Los Angeles
Date Posted: 31 October 2013
Position description:

The SEM Creative Editor will be a company leader in creating, testing, and optimizing keywords and messaging for top-tier clients with the goal of maximizing reach, awareness, and new customer acquisition. They will be responsible for building organized account structures for top companies to ensure relevant ad copy appears for all available SERP queries. The Creative Editor is responsible for writing, testing, and reporting on all new SEM initiatives and taking charge of keyword development, organization, and analysis as it relates to the structure for presenting clients’ ads online.

Key Responsibilities:

  • Work closely with Account Managers, web experts, etc. to create unique and optimized search and display campaigns.
  • Develop and organize keywords into a strategic campaign structure that puts client ads in front of highly relevant online searchers.
  • Work creatively and analytically to change underperforming SEM initiatives by addressing issues with landing page relevance, quality score, and account structure.
  • Actively participate in meetings, training, and create tools to help optimize client SEM campaigns.
  • Ability to act quickly and proactively for client success in a deadline-driven environment.


The successfull candidate must have:

  • Recent SEM experience in an active online marketing environment.
  • Familiarity with AdWords Editor and UI as well as Bing UI and desktop tool.
  • Excellent knowledge of Microsoft Word and Excel as it relates to SEM account builds and optimization.
  • Knowledge of Enhanced Campaigns.
  • Great attention to detail and organization.
  • Intuitive/creative thinker.
  • Outstanding computer and online search skills.
  • Ability to function independently and as part of a team.
  • Adaptability to a changing environment quickly and easily.
  • Manage multiple assignments and prioritize work while meeting deadlines.
  • Resolve complex editorial challenges in a professional and timely manner.
  • Fun, smart, energetic people will move to the top of the candidate list.

Desired Skill Include:

  • Comfortable participating in meetings/trainings to improve account performance across multiple clients and services teams.
  • Excel template and tool creation to improve account structure and performance.
  • Excellent knowledge of third party industry tools used for tracking and reporting on key client metrics.
  • Experience with the Google DoubleClick management platform.


Market competitive salary
Equity opportunities

To Apply please send your resume and salary history to hr(at)thesearchagency(dot)com with “SEM Editor” in the subject line. Please no telephone calls or faxes. The Search Agency, Inc. is a EOE.

Salary range: Unknown
Closing date: Unknown
More info from:
Contact: Send resumes via online form to: hr(at)thesearchagency(dot)com

For more search industry jobs, or to post a vacancy, visit Search Engine College Jobs Board.

Spread the joy!

Students in 60 Countries Taught by Search Engine College

SEC-smiley-150x178Staff at Search Engine College did their own version of the Harlem Shake this week to celebrate reaching students in 60 countries worldwide.

The 60 country milestone was reached when a new student from Columbia took up our $99 subscription this week.

Since its inception in 2004, Search Engine College has set new industry standards for online training in the field of Search Engine Marketing and we are very proud to have produced over 1,500 happy graduates.

Here’s a list of countries / regions where our students to date are located :

England (UK)
South Africa
Sri Lanka
West Africa
New Zealand
Russian Federation
Hong Kong (China)
Czech Republic
Trinidad and Tobago
United Arab Emirates
Dominican Republic
The Netherlands
Costa Rica
Cayman Islands (UK)
Syrian Arab Republic (Syria)

I wonder which country will be next?


Like to learn SEO? Download a free SEO lesson. No catch!

Spread the joy!