Topics: seo, search marketing, excel, microsoft, training, spreadsheet
It’s important to stay ahead of the game and decent spreadsheet software such as Microsoft Excel is still regarded as one of the most empowering and flexible ways to track your SEO campaigns. In conjunction with important tools such as Google Analytics & Keyword Tools, Excel is able to help provide unrivalled analysis to aid the decision making processes for your business.
When discussing SEO, it’d be impossible not to mention keywords. And with this, there are two sides to the story. Firstly, which keywords to settle upon and secondly, tracking their effectiveness.
Deciding which keywords to run with is a big decision. It needs to fit in with both your business goals and marketing strategy, leaving no room for error. Using an Excel spreadsheet as a tool to track your keyword ideas in conjunction with a combination of free and paid online tools, you’ll be able to save both time and money in the long term.
Two of the most popular tools include, Google Keyword Tool & Google Trends. Use the aids to provide insight as to the search volumes of your terms (both local and worldwide) and also to help with variations upon your keywords (e.g. if your main term is “Light Bulbs” you could find alternatives such as “Halogen Bulbs”, “Energy Saving Light Bulbs”).
Add your findings to your spreadsheet using columns:
Local Search Volume
Worldwide Search Volume
This will give you a quick indicator as to which keywords your company should target. Put simply, high competition and low search volume is more often than not, worth being left alone.
Once you’ve decided upon your specific search terms, you’ll need to track these too. Again, free tools such as Rank Checker will provide you with a quick breakdown of where you appear in the three major search engines. Create a new spreadsheet, with the columns:
I’d recommend doing a separate spreadsheet for each month, then you can always cross reference these in the future to analyse trends specific to your website. Knowing which keywords are effective will provide you with insight as to where to channel your paid and organic campaigns.
If you’re a business with an emphasis on SEO (which to be honest, who isn’t these days?), you’re likely interested in spreading a wide net for your content. Submitting your posts to directories is a great way to increase the reach of your content, but merely submitting them shouldn’t be the end of it.
Measuring the effectiveness of an action or process is key, and there is no simpler or more effective method than creating an Excel spreadsheet. First, you’ll need to find those directories, if you haven’t already. A quick Google search will provide you with a comprehensive list for your specific needs. Once you’ve got the list, create an Excel document with columns for:
Date Link Submitted
Date Link Confirmed
Knowing where and when you submitted a post to a directory will save you time (and money) in the future, reducing the occurrence of duplication and ineffective listings. (If you are worried you have entered something twice, have a look at this post describing how to deduplicate data). It always pays to include an additional info column to remember login details and the like.
Tracking your spend makes simple accounting sense. Excel is a fantastic way to note down where your SEO budget is going. From paid directories to PPC campaigns and everything in between. Your spreadsheet may include the following columns:
Average Monthly Cost
Now, this document in itself provides little more insight than where your money is going. However, when analysed in conjunction with conversation rates for example, Excel will allow you to decipher the exact effectiveness of a campaign per cost. It’s also a great “go to” document when making budgeting decisions.
Of course, in order to stay one step ahead of the competition, you need to know what they’re up to. That’s just common sense, right?
Again, there are plenty of tools out there to help you track the numbers of backlinks to your site. OpenSiteExplorer is a handy tool to quickly scan a webpage.
To make things easier to analyse trends, use your spreadsheet. For this you can add as many or as little columns as you desire, but you may wish to include;
Linking Root Domains
It goes without saying that a link from a site with a higher domain authority will increase the likelihood of your content reaching a greater audience. The more links and shares that you receive can only be beneficial too for spreading your word.
To conclude, there’s a world of data out there which you can analyse. Excel can help you decide whether a particular SEO campaign has been successful in terms of return on investment and much more.
Author is a trainer with a Microsoft Office Training company, the UK industry leader in its sector. For more information on Microsoft Office Training, please visit
Previous Articles Highlighter:
Four Proven Tactical Ways To Optimize The Size Of Your Email List (1)
I'm not saying that it would be impossible, it could be done with a spreadsheet, I suppose, but is that really your dream of what an Internet Marketer's life should be like?
5 Tips For More Effective Business Social Networking (2)
4) Focus on giving first. One of the best ways to demonstrate your expertise or the benefits of your business is by "showing, not telling". This means that you give advice, share resources, point people to information that will educate and inform them.
Search Engines Are Not The Only Path To Targeted Traffic (3)
You are basically providing for incentives for your readers-cum-customers to make repeat visits and to recommend the website to their own networks. The freebies can be anything from products and services.
More Traffic Means More Potential Sales For Your Online Business (4)
To illustrate the difference, think of the websites of competitors, say, ABC with emphasis on quantity and XYZ with focus on quality. ABC has 1,000 visitors per day but only 100 are target customers while XYZ only has 500 visitors per day but 300 are target customers.
What You Need To Understand About Maryland SEO Services (5)
Otherwise, they are at risk of losing out to the competition. But online presence alone cannot get the job done. To get the best results, it will be wise to invest in the services of Maryland SEO services as they can help further your business interests.
Maryland Search Engine Optimization - Is It Important? (6)
If they have a website, make sure you check for testimonials made by previous clients. This way, you would be able to get an idea on how good they are at doing the job.
Commit To Continuous Citation Building For Your Business (7)
The more votes for the candidate, the higher the chances for winning the election in the same way that the more citations from other businesses, the higher the opportunities to spread awareness of your business among your primary and secondary markets.
Make Press Releases A Part Of Your Overall Brand (8)
But not all press releases are crafted equal. Your success in using press releases to promote your brand rests on several factors including its: a. Content - Be sure that the contents are, indeed, newsworthy while also being informative, engaging and interesting.
5 Website Design Tips (9)
Make the Site Easy to Edit If you are serious about marketing the website, you need to make sure the site stays up-to-date so people have a reason to check out your site again or possibly subscribe.
Make Ongoing Page Management A Part Of Your Social Media Effort (10)
- Keep a balance of professional and personal posts. - Advertise your social media accounts. Start on your page management now and you will soon see why social media is part and parcel of a successful online business!
4 Tips From A Website Troubleshooter (11)
Your website will then be ranked on the pages accordingly, thus, explaining the importance of continuous citation building for your business. There are other factors involved in ranking websites, of course, but continuous citation building is a must.
Some Of The Benefits Of Article Distribution Techniques (12)
Pros can create dozens of interesting and informative articles in a short period of time. By using a professional service, you are assured that the results are structured in such a way as to get the best results from the search engines.
What Is Blogging? Blog Creation Tips (13)
This is very valuable because it encourages users to help you with the marketing of your site. Without them you will be forced to do all of the marketing for your site on your own.
Importance Of Being Visible On The Web (14)
This is where search engine optimization (SEO) becomes important. SEO is a method of keyword generation that allows a website to achieve a top position on a search engine results page.
How A Maryland SEO Company Can Help Improve Your Website's Visibility (15)
Topics: search engine, search engines, major search engines Maryland SEO services play an important role in the success of many businesses regardless of their size. Try keying SEO in major search engines and you will see a lot of websites that are offering local SEO services.
Canon EOS 5D Mark III Review (16)
This is much higher than the 3.9 fps continuous skills offered by the 5d Mark II. This feature makes this camera the preferred choice for photographers who love capturing fast moving action.
Four Must Have WordPress Plugins For Your Website To Make It Succeed Online (17)
I have used all three in the past and my (currently) favorite is 'WordPress SEO' by Yoast. Yoast is top SEO guy who knows his stuff and keeps his SEO plugin up to date and simple to follow even for beginners.
How To Find Ways To Earn Money Through The Internet (18)
There are lot of funding resources that new business owners can appeal to including state, federal and even private grants. One very common option for new entrepreneurs is that of affiliate marketing.
All About Trade Show Displays And Aluminum Extrusions (19)
For those individuals who are on the lookout for cost-efficient components, aluminum extrusions are the material of choice. These components can provide large custom displays at a reduced cost and less weight.
Van Graphics - How To Make Your Business Easily Identifiable (20)
Advertising through van graphics is the new method of mobile advertising. It makes advertisements more noticeable from the rest in comparison with some other techniques of marketing. For example, advertising in newspapers or magazines can make it difficult for your product or service to be noticeable since some other companies do this as well.
Newer Articles Highlighter:
Why SEO Matters In The Lehigh Valley (1)
You may be wondering whether getting help with your SEO in the Lehigh Valley is a worthwhile investment for your business. While SEO is not the best option for every business in the Lehigh Valley, in many cases it can go a long way in ensuring that businesses get the most amount of exposure to their intended clients.
SEO In The Lehigh Valley (2)
Web design agencies can help you improve your SEO in the Lehigh Valley. SEO will play an increasingly important role within your companys overall marketing strategy, and ultimately your short-term and long-term success.
Keyword Research: What To Know When Sourcing SEO Services For Your Business (3)
Design & Promote, a leading provider of Chicago SEO services (www.designandpromote.com) helps businesses in every industry tap into their niche's most powerful keyword search terms and phrases. Ready to make a major online impact and beat out the competition?
Directing Internet Traffic To Your Company Website (4)
An easy, effective way for your business to get ahead of the rest is to hire a good web design agency that specializes in internet marketing. A web design agency can not only rework your company website, but also help you with search engine marketing (SEM) and search engine optimization (SEO) in the Lehigh Valley to increase traffic to your business.
Benefits Of Working With A Web Design Agency (5)
A web design agency can help increase your search engine ranking through SEO in the Lehigh Valley. SEO in the Lehigh Valley is the process of creating website content that is search engine friendly.
Unique Marketing Strategies For Businesses (6)
Web design agency professionals can help you maximize your marketing and advertising potential through competitive research analysis. It is important that your marketing strategies are all in-sync. Your web design agency will make sure that your SEO in the Lehigh Valley and web design in the Lehigh Valley all connect and portray a stellar first impression for customers who visit your website.
How Fast Is Your Internet: Does It Really Matter Or Not? (7)
You can use this information to compare your internet services but it means nothing unless you can sustain and continue to hold a quality service that is monitored by the service provider to keep you on the best plan.
The Importance Of SEO For Businesses (8)
Topics: Lehigh valley web design, Lehigh Valley SEO, web design agency Today, search engines are the fuel to the fire in publicizing your business. If Google or Bing do not recognize your website, or do not produce your web page as a top search result, you could be in trouble.
Consider The Basics Of Internet Marketing (9)
This content can be shared in many forms, which will be discussed in the following paragraphs. As you're producing this content, you must keep search engine optimization techniques in mind.
SEO Best Practices In The Lehigh Valley (10)
With good web design in the Lehigh Valley and the right SEO techniques, your business should see its search engine rankings rise. Working with a professional web design agency to improve your SEO in the Lehigh Valley is a wise move for your business.
Wordpress SEO - Getting More Out Of Blogging (11)
If you are considering blogging, you'll need to factor in the optimization necessary to make your pages stand out, especially when there are so many competing for a share of the internet's traffic.
The Importance Of Wordpress SEO Today (12)
It has become easier than ever to start a website, blog, or any sort of promotional item on the net. Instead of having to know a lot of code, anyone that can navigate through a few menus can have a domain name and site running with relative ease.
Top Reasons Why Hiring A Professional SEO Company Is A Must For Any Business (13)
Design & Promote is an innovative SEO Company in Chicago that delivers customizes strategies and solutions for optimal online marketing results. Ready to take your business' Internet presence to the next level?
5 Marketing Mistakes That Every Indian Business Is Making (14)
Pravesh Chopra is founder of cravemarketing.in which is a consulting firm and it helps business to grow through innovative and constructive marketing. You can visit his website pvchopra.com or his company site http:cravemarketing.in to know more about their service or product
Advice For A Winning Pay Per Click Advertising (15)
When you have decided on your target market, use the right keywords. When you have researched your target markets demographics, you will have a much better understanding of what keywords they are likely to use to find your website.
Responsive Web Design In The Lehigh Valley (16)
If you are interested in having a Lehigh Valley web design that will provide the best viewing experience to both of these users, you may consider hiring a professional web design agency.
SEO Competition In The Lehigh Valley (17)
Your web design agency can create a brief list of your competitors by simply searching for your keywords on the major commercial search engines such as Google, Yahoo or Bing and taking note of the websites in the results.
7 Ways To Get Massive Amounts Of Free Traffic Through Viral Marketing (Part1) (18)
Your fan page will get yet more exposure. So clearly, using social media to distribute viral reports is a very effective strategy. 2. Secondly, another way to distribute your free report is to write viral articles.
7 Ways To Get Massive Amounts Of Free Traffic Through Viral Marketing (Part 2) (19)
People usually visit these sites to look for helpful free ebooks and there is no reason why you cannot submit your free report if it is of good quality and helps people solve their problems.
3 Ways To Use Resale Rights Products To Speed Up Your Online Business Building Process! (20)
However, if you sell your own resale right product at $47 and keep all the profits, you will still make some reasonable money, especially if your marketing is good. 2.