How Excel Can Help You Build A Successful SEO Campaign
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.
Keywords
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:
Keyword
Local Search Volume
Worldwide Search Volume
Competition
Trend
Additional Notes
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:
Keyword
Month
Google Rank
Yahoo Rank
Bing Rank
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.
Directories
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:
Directory Name
Date Link Submitted
Date Link Confirmed
Pricing
Additional Info
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.
Expenses
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:
Expense
Average Monthly Cost
Annual Cost
Additional Notes
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.
Competitor Analysis
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;
URL
Total Links
Linking Root Domains
Page Authority
Domain Authority
Facebook Shares
Tweets
Google +1’s
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
www.microsofttraining.net
Previous Articles Highlighter:
Four Proven Tactical Ways To Optimize The Size Of Your Email List (1)
This article has barely scraped the surface of what there is to learn about constructing an email list. Do you need further advice on this huge topic, where "doing it wrong" could be a disaster?
5 Tips For More Effective Business Social Networking (2)
One way to keep this simple would be to focus on just one social network. Participate deeply in your chosen network, rather than sporadically across two or more. Given the time-shifted and asynchronous nature of social media, you must network consistently in one place to get the best results.
Search Engines Are Not The Only Path To Targeted Traffic (3)
The freebies can be anything from products and services. Think of free mugs, pens and mouse pads with your business' brand as well as free web seminars, podcasts and online tutorials, all of which can be made for little to no cost.
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)
And this is why they are reliable in providing superb techniques that can effectively help increase your business exposure. More than that, it is not just mere quantity that they aim for.
Maryland Search Engine Optimization - Is It Important? (6)
Just think of it in the same manner you would any brick and mortar business. If clients find it difficult to locate your shop, it is likely that no one or very few would come.
Commit To Continuous Citation Building For Your Business (7)
Like the newly-declared President of the United States, you must also work long and hard to maintain the vote of confidence from your clients, customers and partners in your citation program.
Make Press Releases A Part Of Your Overall Brand (8)
Even the best press releases will be nothing when these are not read by your target readers such as customers, bloggers and industry insiders. You can always use the direct approach like e-mails to journalists, posts on your official websites, and posts on social media accounts.
5 Website Design Tips (9)
Nobody will tell you how good your design should be but if you look at the habits of most online users, these people will only get attracted to the sites that look aesthetically pleasing so you better come up with something good as well.
Make Ongoing Page Management A Part Of Your Social Media Effort (10)
Just make sure to use the right tools so as to avoid letting these fresh posts become buried in the online chatter. - Use the tools on search engines like Google Analytics to identify relevant keywords and write on these topics on your social media accounts.
4 Tips From A Website Troubleshooter (11)
There are other factors involved in ranking websites, of course, but continuous citation building is a must. Why? Each day, hundreds of websites are being launched online with each website having the potential to become a source of citation.
Some Of The Benefits Of Article Distribution Techniques (12)
Resource boxes are a key part of the benefits gained from using this marketing tool. Each of the articles has an associated text box that bring prospective targeted customers back to your website.
What Is Blogging? Blog Creation Tips (13)
Knowing how to use SEO tools is going to help you to have a higher ranked webpage which will bring in more viewers. You will know how to use the correct keywords and where to place them for the most success.
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)
Overall, a professional Maryland SEO company must know exactly how to make your website dominate search results and know just how to have online visitors convinced to do business with them.
Canon EOS 5D Mark III Review (16)
This means that the images shot by this camera at ISO 4000 are as clean the images shot using the Mark II at ISO 1000. It is this feature of the camera that makes it a great option for photographers as it let you capture the light as your eyes see it.
Four Must Have WordPress Plugins For Your Website To Make It Succeed Online (17)
Every website to succeed online in today's competitive world , have to have great content, secure website, with fast loading pages, and properly optimized pages for SEO. Yes WordPress cannot write content for you, but it can help you with other important aspects to make your website speedy, secure and have SEO optimized pages.
How To Find Ways To Earn Money Through The Internet (18)
In fact, many of the businesses that you regularly patronize have websites, blogs and other ways to reach out to customers via the net. Thus, the ability to work for yourself and generate good profits really does exist.
All About Trade Show Displays And Aluminum Extrusions (19)
Trade show events are a great venue for making direct contact with potential consumers. In addition, it gives companies an opportunity to establish collaborative ties with other businesses in the same industry.
Van Graphics - How To Make Your Business Easily Identifiable (20)
Visit our graphics experts for a free estimate for your custom graphics www.jmrgraphics.com. We are going to produce your vinyl graphics according to your specs. We produce pressure sensitive vinyl adhesive and specialize in branding companies of any size.
How To Increase Your Brand Awareness With A Better Website Design (21)
If they do not like what they see, they will simply hit the back button and never return. So branding and good website design are essential to a business.
Dependable And Successful Irvine SEO Company Helps Companies Succeed (22)
Since at a given second their online track record currently exists (or they will soon build it), leading it with a social media marketing program is a very easy and efficient way to keep an eye on a brand's reputation.
Spam Vs Permission Based Email (23)
Place several sign up boxes at strategic locations throughout your site. You may also want to elicit the help of a firm that specializes in permission based email marketing to help you.
Be An Expert In Setting Up Google+ Local For Your Business (24)
All they need to do is hit the "Local" button, type in what they are searching for, and Google will certainly return search outcomes also with assessments and saved suggestions from their pals.
How To Zoom In On Your Visitor? (25)
There are many companies that offer tracking systems where the site owner can look at important statistics like the number of unique visitors and the number of hits. The difference here is that using the untargeted system does not drive a specific clientele base toward your website.
Web Design - Things To Consider In Your Design (26)
If you can think of the acronym, CRAP, (or PARC if you prefer). This stands for Contrast, Repetition, Alignment and Proximity. All four elements applied properly together should give a good looking site.
New, Social, And Worth Investing In (27)
Topics: media training, presentation training Not long ago it was being said that social or new media was just a fad and that it would soon vanish, even more recently the same was being said about Twitter.
The Art Of The Profile Interview (28)
We regularly coach people for profile interviews, preferably before they have wasted a golden opportunity. Lindsay Williams is the MD of The Media Coach. With international experience, her London based firm provides expert media training.
The Every Door Direct Mail And The USPSs Way Of Helping Local Businesses (29)
Make sure to create your mail pieces according to the standard specifications for Every Door Direct Mail. - Step 4: Let them be in charge Bring your mail pieces along with the necessary documentation to the local post office.
Left Brained, Right Brained Or Hair Brained? The Case For More Emotion In Public Communication (30)
Instead of presentations the organisers had devised seven questions which the audience were given the opportunity to vote on using digi-voting equipment. As chairman, I then used these results to prompt further questions which I put to the five panel participants.
The Case For Video: Argument And Evidence (31)
Below (I make no bones about the fact that my able cameraman provided me with the figures) I present a few facts and figures that I wish I had had to hand in that conversation in the city.
Tips For Managing Successful Email Marketing Lists (32)
You don't have to be too pushy to make them respond openly to you. Surveys can help you get answers from them without causing uneasiness or feelings of mistrust.
Newer Articles Highlighter:
Why SEO Matters In The Lehigh Valley (1)
The area is made up of several different cities, the largest being Allentown, and a handful of suburban and rural communities, providing a lot of ground for businesses to cover.
SEO In The Lehigh Valley (2)
Professional web design agencies will enhance your site structure, implement user-friendly navigation, as well as create a great design that encourages customers to visit your website regularly, all while optimizing your SEO in the Lehigh Valley.
Keyword Research: What To Know When Sourcing SEO Services For Your Business (3)
An innovative SEO services firm will also run analysis to see exactly how your closest competitors have been leveraging these terms, and whether the results have been positive. By aligning your online campaign with a competitor's already established and successful initiative, your SEO services provider will be able to help your business make faster online impact and launch your organization as an industry force.
Directing Internet Traffic To Your Company Website (4)
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)
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)
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)
Hiring a web design agency to create a professional website and improve your SEO in the Lehigh Valley is the first step in connecting with your target audience. Today, Lehigh Valley SEO plays an important role in the overall marketing strategy of a business.
Permalink to How Excel Can Help You Build A Successful SEO Campaign