Automatically Download Google Search Analytics Data Every Month [Updated for New API]

Google Webmaster Tools (recently renamed Google Search Console) is a treasure trove of data, especially useful keyword information.

Unfortunately, it isn’t stored for a long enough period to be useful for any trending.

If you want to get more use out of Google Webmaster Tools data, it is necessary to store it in a database, which may be challenging for some without a developer background.

I’ve been storing GWMT data ever since (not provided) came into full swing, and I recommend everyone do so as well.

Here is the Python script I have been using to download this data on a monthly basis…

Note: This script has been updated to use the new Search Analytics API.
Click here to jump to the new script.

Continue reading

Get “Natural” Anchor Text from Infographic Embed Codes using JavaScript

State of Infographics and SEO?

Infographics are an excellent part of a well-diversified content marketing arsenal, and although it should not be the sole reason for their creation, offer a great many SEO benefits to your website. In a 2012 interview with Eric Enge, Matt Cutts, Google’s head of webspam, went on foray about infographics:

“There are ways that infographics can be created and that represent an OK form of promotion […] I would not be surprised if at some point in the future we did not start to discount these infographic-type links to a degree. The link is often embedded in the infographic in a way that people don’t realize, vs. a true endorsement of your site.”

Needless to say, the interview made people second guess the SEO value of infographics. Matt Cutts’ statement however, isn’t all that bad and shouldn’t be perceived as an omen that spells the imminent demise of clever data visualization. It can also be interpreted as an affirmation that a correctly managed (non-spammy) infographic campaign will continue to be effective in the future, even if only with a slightly discounted link value. Continue reading

Semantic Keyword Research with KNIME and Social Media Data Mining – #BrightonSEO 2015

I had the opportunity to travel to the UK in April and speak at BrightonSEO, an SEO conference I’ve always admired from afar in the United States.

Needless to say, it was an incredible experience. I return from England having connected with many of my European SEO brethren, a liking of beans for breakfast, and with the word “garbage” stricken from my vocabulary and replaced with “rubbish”.

For those of you who did not make it out to see my presentation, or for those who attended and yearned for greater detail, I present to you this recap of my presentation…

Jump to…

Continue reading

Python Script for Creating an XML Sitemap with rel=”alternate” hreflang=”x”

Google specifies three scenarios for which rel=”alternate” hreflang=”x” is recommended:

  1. You translate only the template of your page, such as the navigation and footer, and keep the main content in a single language. This is common on pages that feature user-generated content, like a forum post.
  2. Your pages have broadly similar content within a single language, but the content has small regional variations. For example, you might have English-language content targeted at readers in the US, GB, and Ireland.
  3. Your site content is fully translated. For example, you have both German and English versions of each page.

via Google Webmaster Tools Help

Similarly, there are three means for which hreflang can be implemented. It can be tagged with the element within the section of each page, expressed through the http header for non-html files, or within your XML sitemap. There is an obvious advantage to applying it within an xml sitemap for enterprise level sites, like the ones I tend to work on. Typically, it is much easier to get an updated xml sitemap uploaded than to apply new tagging to a myriad of pages. However, even when applied within an XML sitemap, it can a be tedious process for large websites. I created a quick python script to help make that process a little bit easier.

hreflang python tool usage

This is script is designed for a website where the alternate language site has an equal number of pages to the primary language. For example, there are the same number of pages for en-uk and en-ca as there are for en-us.
Continue reading

Can I use blackhat article spinning (spintax) for whitehat purposes?

Whilst chatting in our office last week, reminiscing of ye old SEO tactics such as article spinning, automated backlink tools, etc, we started talking about article spinning and how it might have some legitimate value in certain use cases.

But first, let’s just one thing straight: In no way do I / we condone the use of article spinning for the purpose of blog posts, news articles or anything in between. There is a time and a place for everything, and spinning an entire article to get a unique version just isn’t something I’d recommend. On the other hand their are a few uses that I think we could re-examine such as:

  • eCommerce descriptions
  • photo gallery descriptions
  • meta descriptions, in some cases
  • and a few more

Continue reading