For SEOgadget clients, most of the SEO work they receive from me is delivered at the end of a heavily data driven process. If you’re feeling a shift towards data driven SEO too, then the chances are using pivot tables and charts in Excel is a near daily part of your SEO consulting activity.
At some point we all have to up our game, especially with Excel and general analysis skills, so at the SEOmoz Pro Training Seminar late last year, I gave a step by step tutorial on how to make a beautiful chart based on an Excel Pivot Table.
![[How to] use tables in MS Excel](http://seogadget.co.uk/wp-content/uploads/2009/10/using-tables-in-MS-Excel.jpg "[How to] use tables in MS Excel")
In my SEOmoz pro session last week I spent some time explaining the benefits of using Tables in Microsoft Excel. Gone are the days of broken formulas that once worked, and extending your cell range references every time you add new data in a spreadsheet.
Using this technique isn’t all that different to using cell references, and the outcome is a more agile and robust Excel, with an ability to manage your data faster making for a more time efficient experience. What’s not to like?
What are Tables?
From Microsoft Office Online [Overview of Excel tables]
On the 24th September 2009, Google announced a revision of their Keyword Tool, the imaginatively titled “Keyword Tool (Beta)”.
As Barry reported that morning at Search Engine Roundtable,
Google has a beta version of a new keyword tool available in the AdWords console. To get to it, login to adwords.google.com, go to a campaign, click on opportunities (if you have that tab), then on the left bar, click on keyword tool. A “beta” link should be available for you to click on in the top paragraph.
Getting traffic to a site through a vast portfolio of traffic driving, high value keywords is at the top of every search engine marketer’s priority list. That said, what if all that traffic is going to the wrong pages on your site?
While researching laptops this afternoon I decided to take a look at the IBM / Lenovo Thinkpads and compare them to some other machines I’d been looking at from HP.
Using the search term “IBM Thinkpad”, I blindly selected the first organic result:
Throughout the next few days I’m going to try to summarise and cover off the key points raised at this years SMX advanced. First session is “Keyword Research Artistry”. I must warn you, last night was a blast and I’m still feeling a little jetlagged, so please forgive any typos!
Keyword Research artistry
I walked into the session a little late, but I think I managed to get a great snapshot of the first presentation. Christine Churchill gave a great summary of some useful tools such as:
Tweetvolume
Has anyone had problems installing MSN’s Adcenter Intelligence plugin for Office Excel 2007?
I’m getting this error on install:
The zip downloaded fully – so the package that cannot be found (vstor.exe) is in the folder. I’ve got the correct version of the MS .net framework and I’m running Office 2007 pro.
Can anyone offer up a solution to this?
Ever needed to compare lists of keywords in different data tables and match corresponding values together? For example, matching keyword volume data to search engine rankings? Today we’re going to take a look at a really simple but powerful query in Microsoft Excel called VLOOKUP which makes that possible.
Here’s the definition of VLOOKUP from office.microsoft.com:
Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array. The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find.
In part 3 of my recruitment SEO guide I talked about a great way to handle your vacancy pages from the point of view of good SEO, traffic generation and conversion.
This post develops the concept, by adding a discussion on how best to handle dynamic meta code templates for each one of your jobs. Could you imagine writing 10,000+ meta titles? I think not! The secret is in a little developer time and some research into your specific industry (perhaps via your deepest, longest tail data in your analytics account?!). I’ve written a similar post before, thing is, it missed a vital concept: candidate search behaviour can vary depending on what industry sector jobs they’re searching for!
Blog RSS Feed
Blog Posts by Email