Excel Guide for SEO - Lessons for Aspiring Ninjas Table of Contents Excel for SEO is a guide we wrote up to help SEO professionals get meaningful information from mountains of data. This guide was originally written to be read from start to finish, as some examples are worked on through different lessons. That said, you should be able to jump ahead if you feel like you’ve got the basics down. Please report any errors or confusing stuff to one of the Twitter accounts on the right and we’ll be sure to fix it right up. Feel free to download the XLS with the data from the examples. Keyword Niche Finder - Research Tool Learn More about The FREE Keyword Niche Finder Want to know more about The Free Keyword Niche Finder, like what are "keyword niches," or what does "relative frequency" mean, or where do we get the data from for our keyword finder? Then, keep reading or you can use the links to the right to jump down to a particular topic of interest. What People are Saying about The FREE Keyword Niche Finder "The Keyword Niche Finder from Wordstream gives our writers a unique free tool to assist in content topic selection and for finding valuable, previously undiscovered long-tail keyword variations to help increase traffic to their articles from search engines." — Tim Blacquier, Director, Online Marketing, Life123 Yes!
Insights - How consumers think How many times have you started reading an email on your phone while commuting, and then continued it on your laptop when you got home? Or perhaps you saw a commercial for a new car and then used your tablet to search for the specs and see it in action? If these things sound familiar, that’s because they’re all part of the new norm in multi-screen behavior. In “The New Multi-screen World: Understanding Cross-Platform Consumer Behavior,” we discovered that 90% of people move between devices to accomplish a goal, whether that’s on smartphones, PCs, tablets or TV. We set out to learn not just how much of our media consumption happens on screens, but also how we use these multiple devices together, and what that means for the way that businesses connect with consumers. Below are highlights from our research:
Google SERP Snippet Optimization Tool Notes If you select the Add a date checkbox, today's date will be filled in automatically. If you plan on publishing your web page at a later date, you can still edit the date input field manually. In most cases, the date Google shows in the SERP snippet will match the date it found in your page content (for example, the date a blog post was first published). 55 SEO Productivity Tools Looking for a new tool that will help you get the most out of your SEO campaigns? Consider any of the following programs that we use at Single Grain in order to maximize the efficiency of our SEO activities and our general productivity: Tool #1 – Google Adwords Keyword Research Tool Although the free Keyword Research Tool offered by Google’s Adwords doesn’t offer as many features as standalone SEO programs offer, this resource is a great option for checking general search, competition, and CPC metrics on the fly. Be sure to check out the feature that allows you to brainstorm keywords by URL in order to uncover the keywords your competitors may be targeting! Tool #2 – Google Trends
Web Analytics - IBM Digital Analytics Gain insight from digital analytics and comparative benchmarks IBM® Digital Analytics is the analytics center that fuels the IBM Digital Marketing Optimization Suite. Your enterprise can gain a competitive edge by benefitting not just from state-of-the-art analytics, but also from comparative benchmarks and knowledge of how the best performers are achieving their successes. A data warehouse on visitors' digital journeys — across marketing touch points and channels — is included by default so you can go from insight to personalized marketing action with a few clicks. Because the analytics are tightly integrated with the IBM Enterprise Marketing Management applications, no IT efforts are needed. Gain insight with intuitive reporting.
A Quick and Dirty Guide to Modern-Day Link Baiting In the last five years, link bait has grown up. It’s gone from a guerilla tactic to a full-blown sophisticated SEO science. That means a list of “must-have” resources or the “best of” just won’t cut it anymore…you need long posts, stellar design and a high-quality network. SEO Tips - Experts Share Strats Are you looking for fresh ideas to improve your rankings and hone your SEO skills? If so, this collection of SEO tips from the experts will help you. I was fortunate enough to recently interview 14 SEO experts and put together this article with a few of their top tips. These are people who actively manage SEO campaigns for clients and large companies. 5 Tools for Creating Awesome SEO Reports Do you spend hours hacking around Microsoft Excel every month to create a compelling SEO report for your clients, knowing that they are probably not going to get read or even opened? Manage your website SEO and Social Media – Free 30 Day Trial In my post below I have provided five tools that can help improve your SEO reports, taking them from being the standard Excel spreadsheet to a report that can be given to anybody at any level within your client’s organisation. ShufflePoint Price: Offers three different pricing plans – 30 day trial available.
Author Rank, SEO and Google Plus: What you need to know - Raven Internet Marketing Tools Google has given Internet marketers a new way to prove page quality and authority. It’s Author Rank, and you can still get in on the ground floor. The first I really heard about this approach was at Pubcon 2011 where none other than Google Senior Engineer Matt Cutts said during his keynote: “Social is a good way to create a reputation for authors. If the reputation of content authors is transparent, it will make the whole web better.”