16 May '13, 1pm

Using Excel Formulas To Group Your Google Analtycis Long Tail Keywords Into Themes

We all know that long tail keywords can be as valuable, if not more so, than one or two word phrases, right? It is easy to start to get traffic from them while building for something more competitive, they are a perfect fit for content strategies and as most SEM professionals would tell you, they are great indicators of consumer intent. Individually though they don't send a lot of traffic. This can make it a little harder to analyse their impact compared to high volume phrases. Especially when you treat them as individual keywords. Of Landing Pages and Themes Fortunately long tail keywords tend to match the subject of the landing page, and can also be grouped by common terms. Assuming the content is tightly themed and the searches it appears for are relatively focused, treating the landing page's organic traffic on aggregate can be a viable strategy. This approach will lea...

Full article: http://www.searchenginepeople.com/blog/using-excel-formul...

Tweets

AdWords Keywords: Are Your Keyword Research & G...

wordstream.com 17 May '13, 9pm

Of course, extensive and effective keyword grouping can be difficult to accomplish when you have limited time and tools (l...

OK Google: 'The End of Search as We Know It'

OK Google: 'The End of Search as We Know It'

searchenginewatch.com 16 May '13, 7pm

"People communicate with each other by conversation, not by typing keywords -- and we've been hard at work to make Google ...

GeoFlow: An Eye-Popping Excel Feature to Showcase Big Data

GeoFlow: An Eye-Popping Excel Feature to Showca...

searchenginewatch.com 16 May '13, 12pm

If a picture says a 1,000 words, then a beautiful interactive map overlaid with amazing advertising data must say 1 millio...

Does keywords have to match in the text?

forums.seochat.com 18 May '13, 8pm

Does keywords have to match in the text? Let's say I wanted to use the exact keyword "interaktions design" for a site beca...

8 Great Tools to use with Google Analytics

8 Great Tools to use with Google Analytics

seoptimise.com 24 May '13, 3pm

We hear so much about great SEO tools that we should be using, but we rarely see much written about tools to help you with...

Nofollow Your Links? How Long Until Google Notices

seroundtable.com 20 May '13, 1pm

A WebmasterWorld thread has one SEO/Webmaster asking how long will it take for Google to show him the fruits of his effort...

I just completed an activity using RunKeeper

runkeeper.com 18 May '13, 5pm

Only 's friends can see the map for this activity. Add as your friend on RunKeeper to check it out!

McIlroy to set up his own management group

McIlroy to set up his own management group

golfweek.com 17 May '13, 1pm

Two-time major champion Rory McIlroy is leaving Dublin-based Horizon Sports Management to set up his own management group,...

Google Analytics Language Report: What You Can Learn About Your Visitors

Google Analytics Language Report: What You Can ...

searchenginewatch.com 21 May '13, 11am

This Google Analytics Language report is beneficial for understanding your users better and seeing how activity might vary...