How to use the New MSN Ad Intellegence PPC Tool like a Pro

A look at MSN Ad Center- Ad Intelligence Excel plug in.

Now that the MSN Ad Intelligence Excel Plug in has been out for about 3 months, and I’ve had a chance to use all of its features, attended a webinar and read all possible documentation on it; I decided to put together a quick start guide for those interested in adding a new and useful tool to their PPC bag of tricks. OR for those who have downloaded it already and are wondering “what the hell do all of those colorful little buttons do?”

This will be a 3 part series of posts. In the first, we will cover all of the buttons on the Excel toolbar and what they do. The second will discuss various uses for each of the buttons/features and a more detailed analysis of algorithms’ and techniques used by MSN to gather the data for this toolbar. The third will discuss various uses and combination uses with Google Adwords editor.


Keyword Extraction
Extracts commonly used keywords from a given website address, which allows the user to see what keywords are in popular use on that site. Great for competitive analysis and finding new keywords.

Keyword Suggestion
Enables quick generation of a large list of relevant keywords from an initial list of Keywords entered. Works something like the Google Suggestions or Yahoo.

Campaign Association
An algorithm option under Keyword Suggestion. Keywords are suggested based on association and on competition/ advertiser’s keyword bidding behavior.
Another great option to find new, niche keywords.

An algorithm option under Keyword Suggestion above. Keywords are suggested based on past user searches that contained those keywords.

An algorithm option under Keyword Suggestion above. Keywords are suggested, which are similar in context to other keywords used on the World Wide Web.

Search Buzz
Returns the top keywords by vertical market, for the given time period. Two keyword trend research options are offered Date Ranges available: past 1, 10, 30 or 60 day period or a custom range

Monthly Traffic
Allows the user to look at monthly historical and future, forecasted query counts for the given keywords. Date ranges available: past data for 1, 3, 6, 12 or 24 month period forecasted for 1, 3, 6 or 12 months

Daily Traffic
Provides the user with daily query counts for the given keywords. Date ranges available: past data for 1, 7, 10, 30 or 60 day period — or you may specify a time period.

Keyword Categorization
Input keywords, then the algorithm suggests a category based on the Microsoft Contextual Taxonomy.

Provides location information of searchers for specific keywords (user can specify country, state or city) about the input keywords within a set time period. Date ranges available : past data for 1, 7, 10, 30 or 60 day period — or you may specify a time period.

Provides demographic information on searchers (by gender, age group) about the given keywords within a set time period. Great research tool to use for a PPC Demographic targeting tests. Date ranges available : past data for 1, 7, 10, 30 or 60 day period — or you may specify a time period

This feature allows users to set the algorithm parameters for the features to suit their preferences, algorithm or needs.

This feature allows users to change general settings, KSP server settings and algorithm Settings, to suit their preferences or needs.

This feature allows users to gather KPI (Key Performance Indicators) Monetization Information for the selected keywords. This feature has two sub-features: Monetization and Vertical KPIs as described below. Date ranges available: past day, week or 30 day period.

Monetization KPI
An option under monetization above. This feature provides KPI information about clicks, impressions, position, click through rate, cost per click, and match type within a date range. Date ranges available: past day, week or 30 day period.

An option under Monetization above. This feature returns KPI Monetization Information for selected verticals and keywords within a date range. Date ranges available: past day, week or 30 day period.

Top Spiky Keywords
Returns the keywords whose trends are sudden and spiking (i.e. not overall popularity, but demonstrate flashing and surging popularity). Similar to Google Trends , but still has a long way to go. Date Ranges available: past 1, 10, 30 or 60 day period or a custom range.

Top Frequent Keywords
Displays the keyword trends for the overall most popular keywords. Date ranges available: past day, week or 30 day period.

Keyword Wizard
The Keyword Wizard button assists users in implementing all applicable features available. Wizard through the program in order to set up a working keyword profile.

This tool would be a lot more useful if MSN could manage to scrape up a little more than 10% market search share. Because the reality of it is, not only does MSN hardly provide enough traffic, but the traffic they do provide is extremely inconsistent.

It fluctuates week to week with no rhyme or reason. Their interface is constantly running at the speed of molasses. And their customer service is practically nonexistent, and that’s with a dedicated rep. Now, with all that said and out of the way, I like the tool. It’s genius is that it integrates right with excel. Granted, MSN tool looks much cooler than Google Adwords Editor. But, Adwords Editor is sooo much more useful in day to day PPC management and development than the MSN tool.

Although used in combination, they add a powerful tool to your PPC war chest. (And if anyone from Google Adwords Editor Team or MSN Ad Intelligence team is reading, why not steal the others idea and develop a tool that incorporates the great research and historical data features in the MSN tool, with the practical and useful features for creating, editing and manipulating Google Adwords account data with Adwords Editor. ; )



Search Engine Consulatation and Training in Miami

I’m happy to announce Subliminal Pixels will be starting up our launching our training services for Florida and select US cities, like N.Y.C., N.J., Atlanta, L.A, San Fransisco and more..

 I have worked on, many sites through out my years in SEM, achieved many #1 listings, achieved great conversion rates and ROI, and have made businesses very successful. I want to be able to offer my services, ideas and training to local businesses, and organizations whom are looking to capitalize on the power of the web. I strongly believe in offering a transparent business model regarding SEO and Online Marketing. All of the info is already out there, so why not put it together in small targeted classes. helping everyone from local mom and pop business  drive traffic to their stores, to mid to large companies looking to harness the true power of the web. I will be setting up various training sessions starting May 1, 2007 , each class will have up-to 30 spots. The schedules and class syllabus will be made available on my site. In addition please feel free to contact me to set up individual, or larger group sessions tailored to your specific industry.

 In addition, If you are interested in joining or learning more about SEO, online mArketing please feel free to contact me as I love to talk shop and share the wealth of info I have amassed

Classes will vary depending on demand, here are some of the topics we will be covering.

Organic Search Engine optimization, Paid Search Marketing Basics ( Google Adwords, Yahoo Search and MSN Adcenter), Social Media , the rise of Web2.0 and how can I leverage them into profit for my business, Paid Search marketing 2 (Campaign Management, landing Page optimization, text ad optimization and top tools for PPC management and implementation), Advertising on Ad networks , Contextual Advertising, And in addition I will be providing preliminary site audits for the participants.

Please feel free to send me an email to discuss your specifc needs.


Google Adwords Pro! Yeeeeaah Boy!

So alright, for the last 1 1/2 years I’ve been telling myself that I would re-take the ad-words pro test, since my certification had lapsed. And for 1 1/2 years I have been procrastinating. But finally I did it, I closed my eyes , signed up and just took it.  I got a 95%, alright! Now It’s time for the Yahoo Search Ambassador test. I wonder if MSN will be coming out with anything like that.  I’ll be honest, when I was there at the MSN in Seattle, I met with many of the “top dogs”, “big wigs”, or “big kahunas”. The bulk of them seemed to be lost somewhere between Google and Yahoo. Well I’m glad I passed and I can use my logo now to show the world what a bad ass ad-words pro I am!

Google Adwords Pro