You're reading...
Websites

Tracking Google SERP

Each week I trawl through loads of material on blogs, newsletters and social media, to keep up with new developments online. Occasionally I find something that makes it all worth it. Here’s one such find.

How to automatically track Google search positions in Excel

This was a fantastic post on Search Engine People’s blog by Yoav Ezer. It’s about a tool he’s made, and provided for free download. It’s an Excel spreadsheet with predefined macros that allow you to track and graph the position of your site in Google’s organic search engine results pages (SERP).

How does that help me?

If you own a website you’re probably interested to know where it appears in Google’s search results when people do relevant searches.

One way to find out is to just do a search and see. That’s ok, but what if you have a large site, with many pages, and you want to track many keywords?

And of course, if you’re tracking something you want to see how it trends over time, so you’ll have to repeat this regularly and record the results.

The manual approach to tracking this soon becomes unmanageable. 

How does this automated tool work?

Basically the macro code in the Excel file is collecting the search results from Google for the keywords entered, then looking within this returned content for specific strings (links with your domain).

But to use it all you need to know is how to download the file and follow some simple instructions in Yoav’s post:

  1. Replace example domain name at the top with your web domain
  2. Enter the keywords you want to track across the columns (as many as you like)
  3. Clear the contents of existing reports
  4. Press Ctrl+Shift+U to update.
Excel spreadsheet

Tracking Google search engine results pages in Excel

If you’re confident editing macros, Yoav provides some background on how these are configured and the potential applications for tweaking the code for other uses as well. 

Once you’ve downloaded this tool and got it working, you may be surprised with the results. Are you even tracking the right keywords?

Using this in conjunction with Google Analytics (which can tell you which keywords are sending people to your site) can allow you to track your ranking for the best performing searches.

Google’s Keyword Search Tool can then help you find new keyword combinations around these words, that you can target in organic or PPC (pay-per-click) campaigns to ensure your site is making the most of search engine traffic.

About these ads

About dalway

Damian Alway has over a decade of experience in print & online publishing. He’s managed several large websites across government, not-for-profit & commercial sectors, worked as a production editor in a print environment & as a freelance publishing services consultant.

Discussion

6 thoughts on “Tracking Google SERP

  1. Hi everyone, it’s my first visit at this site, and article is really fruitful designed for me, keep up posting these articles or reviews.

    Posted by Chloe | December 14, 2012, 12:21 pm
  2. Amazing blog! Do you have any hints for aspiring writers? I’m planning to start my own website soon but I’m a little lost on everything.
    Would you propose starting with a free platform like WordPress or go for a paid option?
    There are so many choices out there that I’m completely overwhelmed .. Any ideas? Thanks!

    Posted by analyze competition | December 30, 2012, 10:07 pm
  3. This design is spectacular! You most certainly know how to keep a reader entertained.
    Between your wit and your videos, I was almost moved to start my own blog (well,
    almost…HaHa!) Excellent job. I really loved
    what you had to say, and more than that, how you presented it.
    Too cool!

    Posted by automatic coffee machine | February 14, 2013, 1:07 pm
  4. Hey, I think your website might be having browser compatibility issues.
    When I look at your blog site in Chrome, it
    looks fine but when opening in Internet Explorer, it has some overlapping.
    I just wanted to give you a quick heads up! Other then that, awesome blog!

    Posted by Assess motel charges | May 3, 2013, 4:52 am
  5. Hiya! I simply wish to give a huge thumbs up for the good information you will
    have here on this post. I will be coming back to your blog for extra soon.

    Posted by SEO收費 | May 27, 2013, 9:01 am
  6. I like what you guys tend to be up too. This kind of
    clever work and exposure! Keep up the very good works guys
    I’ve included you guys to my blogroll.

    Posted by Madeline | August 23, 2013, 10:42 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

Tweets

Error: Twitter did not respond. Please wait a few minutes and refresh this page.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: