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)
- You must read the PLR conditions attached to the product very carefully before offering it as a giveaway. Some, though not many, PLR products insist that it is on-sold for a minimum price, rather than being given away.
5 Tips For More Effective Business Social Networking (2)
Only by measuring before and after will you know if social networking is helping you reach your goals. It is often easiest to select just one metric per campaign.
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)
With diligence, your efforts in targeted traffic generation will pay off in terms of conversions, sales and profits! Let us explode your traffic numbers with Portland SEO. Visit www.bizsuccesscenter.com to see the services that we offer.
What You Need To Understand About Maryland SEO Services (5)
With a stiff competition, it may be easy to gain online presence but to maximize your reach is another matter. This is a specific area that SEO providers have taken the time to study and master.
Maryland Search Engine Optimization - Is It Important? (6)
This way, you would be able to get an idea on how good they are at doing the job. Are you looking for more information regarding maryland search engine optimization?
Commit To Continuous Citation Building For Your Business (7)
Otherwise, you will suffer from the slip in the quality and quantity of your citations - and that is exactly what you want to avoid because your business partly depends on these citations.
Make Press Releases A Part Of Your Overall Brand (8)
But don't stop with these aspects either because press releases play an equally important role in building your brand, reinforcing customer loyalty and strengthening your position in the market, among others.
5 Website Design Tips (9)
A nice technique to making a site that is comfortable to read is to limit the amount of colors to use across your site. There are several free color scheme generators that work on your web browser so you can figure out what primary color you wish to use.
Make Ongoing Page Management A Part Of Your Social Media Effort (10)
Start on your page management now and you will soon see why social media is part and parcel of a successful online business! Let us explode your traffic numbers with Beaverton SEO.
4 Tips From A Website Troubleshooter (11)
You are basically taking the battle for the bottom line to your competitors' turf and beating them at their own game. b. Ask other businesses relevant to your own business to carry a review of your products/services and/or a listing for your products/services.
Some Of The Benefits Of Article Distribution Techniques (12)
Expanding the number of backlinks to your website is another way to improve your web presence. When you have articles out there on the Web, each of which has a resource box leading readers to your site, you will see an increase in your traffic.
What Is Blogging? Blog Creation Tips (13)
Try writing for your readers. A blog is generally personal, but if you wish to grow an audience of more than a couple of people, try writing for the readers too.
Importance Of Being Visible On The Web (14)
We know how new patients search for you on the web. Using proven methods to increase web visibility, we will make you a trusted expert in your field. If you have any questions or need help with this, contact us at our office in Metuchen, NJ.
How A Maryland SEO Company Can Help Improve Your Website's Visibility (15)
Around 90 percent of companies and organizations are being reached by people through search results. Keywords play an important role in leading your company on top pages of search engine results.
Canon EOS 5D Mark III Review (16)
With so many additional and better features in the Canon 5D Mark III camera, it is not surprise that it is available at a much higher price than the 5DMark III camera.
Four Must Have WordPress Plugins For Your Website To Make It Succeed Online (17)
If your website is powered by WordPress you may be thinking which plugin to install and which to leave. I have five year experience in WordPress development and has helped hundred of client launch WordPress based website, it is my daily job to help them decide which plugins to use and which to avoid.
How To Find Ways To Earn Money Through The Internet (18)
Regardless of where your interests lie, there is sure to be some profitable endeavor to pursue. For instance, if you like writing there are numerous copy-writing and content writing sites that help to generate marketing materials for businesses.
All About Trade Show Displays And Aluminum Extrusions (19)
This is the main reason the use of aluminum extrusions in exhibit booths is increasingly becoming popular in trade show events and expos. Aluminum extrusions offer numerous advantages when integrated into the design and framework of a trade show display.
Van Graphics - How To Make Your Business Easily Identifiable (20)
The benefits of Van Graphics Putting graphics on vans owned by your company is an excellent strategy. The vehicle graphics ought to contain your business title, logo design and contact information to maximize the advantages.
Newer Articles Highlighter:
Why SEO Matters In The Lehigh Valley (1)
A good web design agency will work with your business to create website content that will rank highly in the major search engines. Lehigh Valley SEO techniques that web design agencies use include keyword research, ranking reports, search engine specific site maps, and other practices that will help increase your businesss ranking and make sure your website connects with your target audience.
SEO In The Lehigh Valley (2)
The Lehigh Valley is full of culture and history, and you can be a part of that. Host to the largest city in Pennsylvania, Allentown, the Lehigh Valley is a melting pot for your local business to thrive with the right marketing strategies.
Keyword Research: What To Know When Sourcing SEO Services For Your Business (3)
When sourcing a reputable and professional SEO services provider, it's important to determine their research process for identifying the most relevant terms for your campaign. While, as an industry expert, you probably have a steady gauge of your niche's most commonly used verbiage, a quality provider will dig a bit deeper; always ensure that your chosen SEO services vendor not only does the needed research based on your identified industry specific terms, but also monitors several online resources to reveal the actual search volumes these popular phrases currently yield as well.
Directing Internet Traffic To Your Company Website (4)
The combination of a great website and strong SEO in the Lehigh Valley will help to bring your business to the forefront of the 3rd largest metropolitan area in Pennsylvania!
Benefits Of Working With A Web Design Agency (5)
Your new business will benefit greatly from working with a professional web design agency. Good Lehigh Valley web design and Lehigh Valley SEO can help make your business a success by ensuring that your site connects with your intended clients and invites them to purchase your products and services.
Unique Marketing Strategies For Businesses (6)
The combination of Lehigh Valley web design and Lehigh Valley SEO will improve publicity for your company. SEO and web design are the two most important tools a web design agency can implement in order to successfully execute your marketing strategy and bring you new business.
How Fast Is Your Internet: Does It Really Matter Or Not? (7)
For modern types of broadband internet, especially wireless internet connections, it is common to be in a situation where in one can find out that the internet speed is really slow during peak hours.
The Importance Of SEO For Businesses (8)
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. In the Lehigh Valley, where most businesses rely on internet marketing, Lehigh Valley web design and SEO in the Lehigh Valley are two crucial practices your business needs to master.
Consider The Basics Of Internet Marketing (9)
Mobile marketing is bringing your business and site onto the mobile browsers, but it's much more than that. You can communicate with your customers while they're on the run via text message, sending text, photos and videos.
SEO Best Practices In The Lehigh Valley (10)
A good web design agency has the knowledge and skill to develop a lasting, effective SEO campaign that will keep your business among the frontrunners in the Lehigh Valley. For More Information on search engine optimization please visit: mosaicwebsite.com.
Wordpress SEO - Getting More Out Of Blogging (11)
Getting proper understanding of how to use this sort of optimization is a matter of looking into tools that can assist you with implementation strategies. One such option is that of SEOPressor plugin, which is an additional plugin that you add to your existing wordpress installation and get all the information you could possibly want in terms of changing the way you blog.
The Importance Of Wordpress SEO Today (12)
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. It's that saturation that is causing a great deal of changes to the blogging world, and more so than ever before, wordpress seo matters.
Top Reasons Why Hiring A Professional SEO Company Is A Must For Any Business (13)
Measurable results and analysis: One of the biggest complaints businesses managing their own online promotional initiatives have is that it's difficult to see what (if any) impact they are making within their targeted demographics.
5 Marketing Mistakes That Every Indian Business Is Making (14)
They will see whether it fits their needs or not. Does that product solve their need quickly? If you want to compete in the long run then selling to your customer's emotion will work much better.
Advice For A Winning Pay Per Click Advertising (15)
After trying out your first Ad, analyze your results. It is not enough to run a pay per click campaign and simply be satisfied that you got a couple leads from it.
Responsive Web Design In The Lehigh Valley (16)
And by using this one type of web design in the Lehigh Valley, your website has the ability to reach a larger audience without your web design agency's workload (or your bill) increasing.
SEO Competition In The Lehigh Valley (17)
In the end, you might determine that your Lehigh Valley SEO competition is unbeatable. But, both you and your web design agency can learn from analyzing your competition. For example, maybe you will find a popular site that you too should get backlinks from.
7 Ways To Get Massive Amounts Of Free Traffic Through Viral Marketing (Part1) (18)
You can find the remaining four in Part 2. Let us get into them! 1. Firstly, you can use social media sites such as Facebook and Twitter.
7 Ways To Get Massive Amounts Of Free Traffic Through Viral Marketing (Part 2) (19)
Why? Because they would have read your viral report and formed the view that you are someone worth doing business with based on the value provided by your report.
3 Ways To Use Resale Rights Products To Speed Up Your Online Business Building Process! (20)
They level the online marketing playing field because even if you cannot or do not want to create your own product, you can still own a profitable online business within a relatively short space of time.