« User Vs. Search Engine Vs. Perception? | Main | Nielsen Finally Asked to Go Away? »
Wasted Time
June 16, 2006
One of my favorite things in life is Microsoft Excel. It has continually helped me eliminate wasted time since I keep finding ways to mold it to my purposes that it has become one the indispensable tools. I’ve recently found some great ways to use Excel in manipulating large amounts of text with keywords and key phrases and I thought I’d share the wealth.
Have you ever…wanted to compare two lists of data (in my case keywords)? Here is a great link to a formula and some formatting that will compare two lists in a snap.
Have you ever…wanted to break apart key phrases into separate words? Try the “Text to Columns� tool located under the “Data� menu in Excel.
Have you ever… wanted to put the words back together in a different order or with some added tags? For example if you wanted to combine two cells with a # sign between them here how it’s done. [=A1&�#�&A2] This is wonderful for creating dynamic tracking url’s.
On another train of though here’s some recent news from the paid search world….
Google is now offering “Ad Scheduling�. My comment, it’s about time.
MSN AdCenter has finally cut the cord with serving up Yahoo paid search listings. Apparently they switched over to MSN exclusively on 6/1/06. This is from our Yahoo ad representative and some of the numbers I'm seeing would seem to back up this shift.
We are all still holding our breath to see the new version of Yahoo Search Marketing…I’ll keep you posted.
Unrelated, meaningless, and just for fun… And finally, a link to an OkGo’s music video “Do What You Want�. They are a great band with an awesome sound and live show. I highly recommend them!
Have a great weekend!
All posts by Brent Sharp
posted by Brent Sharp at June 16, 2006 11:09 AM
Intrapromote: [ Case studies | SEO services | Bios ]
Trackback Pings
To TrackBack this entry, use the following URL:
http://seoblog.intrapromote.com/mt-tb.cgi/236