Undead SEO | Useful tools, techniques and thoughts for advanced SEO

☠ Undead SEO ☠
Useful tools, techniques and thoughts for advanced SEO

Posts mit dem Label Tools werden angezeigt. Alle Posts anzeigen
Posts mit dem Label Tools werden angezeigt. Alle Posts anzeigen

Mittwoch, 11. Februar 2015

SEOtools for Excel: solutions for loosing installation folder and disappeared ribbon

My installation of SEOTools for Excel on Windows7 x64 / Excel x32 didn't want to cooperate with me from the first step. As first Excel refuses to open seotools.xll properly - it thought always it would be a text file. Then, after try to install SEOTools x64 version as addin, it wasn't not visible in the ribbon at all, but doesn't want to be deinstalled. I was forced to delete it on the hard way. Then, on trying to install SEOTools x32 version, i was pretty near success: i got the strat splash screen from SEOTools, but then an error alert raised, The Ribbon/COM Add-in helper required by add-in SeoTools could not be registered. This is an unexpected error. Error message: Exception has been thrown by the target of an invocation. And nothing more.

After some investigations it becomes clear, that the problem is in the not corresponding versions of the machine (x64), Win7 (x64) and Excel 15 (x32). BTW. if you need to get to know, what is installed on your machine - here are all the places listed, where you get needful information about your hardware, OS and Excel.

Mittwoch, 30. Juli 2014

40 secret keyword research tools to find the million dollar keyword

free keyword research tool
Some of the most popular keywords, which Google suggests, regarding keyword tools are "keyword research", "keyword spy", "keyword generator", "keyword finder", "keyword discovery", "keywords search" and "keywords for SEO". I decided to tell about some tools, which i use for certain aspects of keyword research. The keyword research tools i tell about have all in common, that they aren't well-known as e. g. Übersuggest, but they accomplish exactly so good if not better the same tasks, as established commercial and free tools.

What are the main keyword research tasks a SEO and SEA use to do? The tasks are different (better optimizing, saving money, out-competing of competitor), but the primal goal of keyword research is always the same: to get more cheaper targeted traffic. A SEO is looking for keywords for optimized page or analyzes the competitor's landing page. A SEA is looking for keywords for an ad and for the landing page, or analyzes competitor's ad and landing page. Lets further look, which keyword research tools could be helping in this (only free tools and no affiliate links, promised:)

Samstag, 26. Juli 2014

How to relaunch website avoiding main catches

How to relaunch website keeping ranking and position in SERP

seo-minded website relaunch
In the last time the most interest to the topic "how to relaunch website", as i shortly realized, rises in Germany, whereby i don't think, that this topic is indeed interesting only there.

Fact is: any website relaunch means losses. Losses of traffic, of ranking, of position in SERP, which are finally loss of money. I've seen losses of 4% and 40%, and there aren't the final numbers. The main objective of SEO is to minimize such negative impacts.

In short each website relaunch is a change of design and / or content structure. If content structure changes, with it comes definitely the change of URL structure. So we have generally 2 possible fields, where the new website version could meet a bad acceptance and following loss of traffic:
  • users could dislike the new design
  • search engines could become bitchy on indexing the new URL structure and some pages will be out of searcher's scope.
So how to act on relaunch to come out as a winner from the relaunch battle against our visitors and search engines? Look:

Donnerstag, 24. Juli 2014

How to bulk check pagerank of all internal pages

Although Google means, we shall in general never mind about pagerank (PR). But the substantial part of any OnPage SEO audit is to clarify, whether a site structure is built properly and spreads correctly the link juice. The sign of correct site structure is: important pages inherit PR, not important pages don't. That is the purpose of project-wide PR measuring. Surely, nobody expects to perform such measurements manually cause of eventual links amount - a tool for such mechanical turk's task is a must! I thought... Damn, the search for this tool is on of cases, when i've got demonstrated again, the internet is full of crap and how i hate some SEOs!

Montag, 21. Juli 2014

How to create bulleted lists in Google Plus posts

create bullets in Google Plus posts
Google Plus has only 3 documented formats: *bold*, _cursive_ and -strikethrough-. But it's a proven fact, that the one of the best arts to deliver information and to gain its visibility is to structure information into lists.

Good, with ordered lists it is no problem: you number each list line with bolded ascending numbers, *1. * etc. What is with unordered, bulleted lists? How to make bullets in Google Plus posts? For this purpose we utilize the computer's own capacity, namely the possibility to type and print unicode characters. This possibility is limited, but it is fully enough for creating bulleted lists in Google Plus posts. Other valuable usage of unicode characters is surely design of page titles, page descriptions, which are used in SERP as snippets, and ads texts. Designing of such text assets with unicode special characters gains their CTR enormously. About it at the end of article. Now lets create bulleted lists in Google Plus posts:

Freitag, 27. Juni 2014

H for Header: part 1 of the HASCH OnPage SEO framework

Each website begins with the header. There are no minimal or required values inside of it: the header content fully depends from our goals and laziness:) Another cause for poor designed headers is a meaning, that Google doesn't understand meta tags or doesn't take meta tags as a ranking factor. Well, Google says, it understands just a little amount of available meta tags. Here is Google's statement about understanding of meta tags. But i say:
  • use not only meta tags, which Google definitely understands,
  • use meta tags extensively,
  • be redundant in meta tags using.
Why? Just because the web contains much more as only Google and you. There are very much bots and spiders in the internet, their goal is to parse web contents and to create different indexes. The parsing criteria could be a bunch of existing meta tags and the parsing results on their part could be parsed from Googlebot. So Google gets into its index the content from your meta tags, which Google means not to understand.

Good, now we are agreed about benefits of meta tags using. The main SEO point is utilizing header rules to give the searchbot so much information about our site as possible. Now i list meta tags one by one and give the correct syntax, some possible values, and my point of view of the practical SEO effects.

Freitag, 23. Mai 2014

How to surf with US IP address (or IP of any specific country)

It is the common problem: preview of an affiliate offer, which isn't valid in your country. You will be redirected from the offer you want to another offer, which is valid for your country. But you must see it - cause you want decide whether to promote it or not.

The answer is clear: you must look the offer like somebody from a country where this offer is valid. The solution which firstly comes into mind and which i never got to work is to use free proxy. I have never finded any working free proxy. Never. Don't know why. But there are 2 really working tools, which are free and easy to setup and use. They work out of the box:

Freitag, 25. April 2014

2 things i hate on Facebook Ad Manager and Power Editor

facebook ad manager
  1. You can't, under no circumstances, change the ad target url! You create an ad with website conversions objective. You create a bunch of them, the whole ad set with many different targeting options. Then you want just copy this ad set and point it to another target url. And you can't! You must click on EACH ad, then create a similar ad - only so you will be able to change ad target url.
  2. If you want hide your affiliate urls, this works ONLY if you create your ads each one new from scratch! If you create an ad with shorten url as target, then create similar ad and input as target url your next shorten url - you mean it would work? NO, damn! Facebook is smart enough to show in the ad body the original url. And it is funny enough to show the SHORTEN url, if you run with the mouse over the opriginal url. Is it not stupid?

Samstag, 5. April 2014

Shortest URL Shortener ever!

As the title said, http://v.gd is the shortest URL shortener i ever seen (and it can techically exist). I find this service super comfortable and decided to make it even more comfortabler and share the results: restartless Firefox add-on and bookmarklet.

5.04.2014 UPDATE: my Firefox addon "Shortest URL Shortener ever" was even fully approved and now available for download at https://addons.mozilla.org/de/firefox/addon/shortest-url-shortener/ Download and enjoy!

Dienstag, 1. April 2014

30 cheat sheats for successful SEO

cheat sheets for successful seo

What a SEO needs to know?

The web is flooded with infografics and cheat sheets. Somebody meant once, such giveaways are good for SEO as linkbuilding assets and now everybody makes some. At least as copy and share. I will not speculate about whether or how many of them bring real value, imo most of them are redundant, but my personal biggest problem with them was - THE cheat sheet was NEVER present, if it was really needed (at least for me). Indeed, the sense and the convenience of cheat sheets is if they are there just in time, at the moment, whem one needs them. So i decided to create a collection of all cheat sheets i ever used on my SEO activities and share it. This cheat sheets suite is an evergreen knowledge, hints and tricks, which will be always helpful. Surely this knowledge isn't enough to call oneself an expert, but for somebody who does SEO, specially technical SEO and Onpage SEO, these cheat sheets will render a great service. And for somebody who learns SEO at the moment, they will give a great summary of things which must be learned. These cheat sheets cover already all essential knowledge segments a SEO brings daily into action. Befor publishing i reviewed all cheat sheets to find eventuallya fresher version - for some of them i finded one indeed.

Freitag, 28. März 2014

Solution for "Your post was not shared. Please try again" and how to post to multiple communities

Your post was not shared. Please try again
As i was a bloody rookie at Google+ i was affected many times by the "Your post was not shared. Please try again" error. This error alert rises from time to time if one tries to post something in any community. After some researches i guess to determine the problem's cause. The cause of this issue is BTW related to the wish and try to post to multiple communities. Updated at 1.07.2014. Updated at 8.07.2014

Montag, 17. März 2014

How to SEO Joomla? - advanced SEO extensions and workarounds

From all free PHP web CMS i like Joomla more than all other. Why? I can work with it very effectively and get done alone enterprise level projects, which would need e.g. with Drupal or Typo3 about 3 working persons. I started to use Joomla as it was called Mambo and use it still on some projects. With the time it become more and more pleasant to work with - the structure becomes mature and MVC, usability makes fun, extensions repository grows and contains fantastic extensions. And there are too some wonderful tools and workarounds for accomplishing Joomla SEO tasks, speciall OnPage. Some extensions, which i use extensively myself i will introduce below. I will talk only about free or extremely lowcost extensions.

Samstag, 1. Februar 2014

How to minify javascript / css?

We are agreed, that assets like html, css and javascript must be better minified. If not, YSlow, Google Page Speed test and similar tools will give your site less scoring points and advice you to minify. It is enough said about importance of load optimizing for SEO, so lets look, what we can do and what we use to achive best possible result.
I tested 17 free tools to minify JavaScript online: after minifying with the best tool there are ca 43% of code remained,  the "worst" tool (not really worst) remained ca 51% of code. It worth also to minify. To minify CSS gives ca 60% of less code - It worth also to minify too. Read further - i list all tested online minifying tools with stats and a few server-side traffic-saving hints :

Dienstag, 17. Dezember 2013

Schema.org + Notepad++ = 💘

I love Notepad++. Since i use Windows this is my code editor of choice (there are 4 years, befor i was a Mac-fanboy using TextWrangler). It is free, stable, customisable (visually with themas, and with user defined languages), extendable with rich plugin repository, has active development team, so it gets offen updates. One day i thought, there could be something better beside of Notepad++ and searched. What i found, was an article about 15 most popular code editors and a poll - look at the poll results, you know, what was my decision;)

Since 2011 i love Schema.org too. I extensively use microdata on each site i get in my hands - my own record is 125 microdata classes and properties in a single web document (detail page of a books online shop), and no single one is spam, all of them are existing and useful product informations.

Getting married

It was just obvious i decided to optimize my handwork and make Notepad++ and Schema.org vocabulary working together (and, last but not least, to create a free additional value for all, who have similar needs).

Donnerstag, 3. Oktober 2013

Imagemap creation for SEO purposes

It's not a kind of doing, what you can use on each corner. But such hint could help you to diversify and enrich your assets and to gain the spreading of your source. But don't misuse - you could be just quickly abused;) Google doesn't like if you become oversmart. I'm talking about imagemaps, the links inside of imagemaps and making use of imagemaps for SEO purposes.

Donnerstag, 12. September 2013

Advanced image optimization: Exif matters!

You want surely , that your site comes into relevant SERP with its images. There are some technics, which will enrich your images and let them be better indexed. Beside of this we talk about image size optimization - size matters, you know.