SEO kulcsszó kutatás

Hello again, my name is Lukasz Zelezny and today I wanted to show you how to do better kutatás, in terms of keywords.

Obviously, if we’re talking about keywords we are going to be thinking about Google Keresés Console. The example that I have today is one that I chose completely at random – the website pimlicoplumbers.com. It’s a big plumbing company based in Pimlico, as you can see – the domain name is Pimlico Plumbers, established in 1979. I checked and the domain name was registered in 2002, so that means it’s a pretty hosszú idő és biztosan rengeteg érdekes adat áll rendelkezésre, amit megpróbálhatunk felhasználni, hogy példaként bemutathassam nektek.

Kapcsolódó táblázat

Pillanatkép lap letöltése

I have 3 varieties of software here; the first is Semrush, the second is Searchmetrics and the third is Sistrix – three very powerful tools that I use simultaneously, especially for kulcsszó kutatás.

Let’s imagine hypothetically that the owner of Pimlico Plumbers is coming to me and saying, ‘Hey, Lukas, can you give me some advice on how to leverage my organic traffic and növelje a címet. your organic visibility?’

The first step I would take would be to pull as many keywords as possible. If I don’t have access to Google Keresés konzol, könnyedén felkereshetem a Semrush, a Searchmetrics és a Sistrix weboldalait.

Jelenleg láthatjuk, hogy a Google.co.uk oldalon a Sistrix 1 745 kulcsszót jelenít meg a top 100. Searchmetrics is showing 1,829 and Semrush is showing 3,608. So, let’s see the full report on these keywords here with Semrush… you can also see nice growth, natural growth probably – I don’t know if this is natural or not but I can presume that there are people who are proactively working on the teljesítmény ezen a weboldalon. Itt megtekintheted az összes kulcsszót, URL-ek and lots of other data. We’re going to export them to Excel. Meanwhile, I’m going to Searchmetrics and doing something similar – long tail keywords – I’m going to export them straight away, using the export function. You can see that this is a bit different, but at some points similar. Searchmetrics is asking me how many keywords I would like to export, I’ll export all of them with a click and the export will be ready soon.

Meanwhile I’m going to do the same with Sistrix, and like I said, Sistrix is showing 1,745 keywords. We can use the download function and we would still have 50,000 credits available. (The concept of credit for downloads works pretty similarly with Sistrix and Searchmetrics).

Rendben! Jelenleg a Searchmetrics… jelentéstétel that it is ready, so I’m exporting the keywords from here and from Sistrix. Now we need to open each report and name them Tracker 1 and Tracker 2 – the third one, amely itt van, akkor mi hívja a 3. nyomkövető.

Something here is not quite right, so let’s do text to columns. Okay, we have pretty much mi szükségünk van: URL, verseny, forgalom, költség per click… in this export we don’t have keresési volumen, but it’s alright, it’s not a big deal.

To Tracker 3 we will add Tracker 2, just to show you that each software is collecting data in a different way, and here is Tracker 1. We need to try to make these 3 spreadsheets as similar to each other as possible, so we need Keyword: in all three, Keyword is in column A, so that’s fine. Position, okay, then URL.

‘Previous Position’ we are not interested in, we need Search Volume and that’s pretty much it. I’m just removing everything else that’s here.

Nos! Megvan a KULCSSZÓ : POZÍCIÓ : URL : KERESÉSI VOLUMEN, valamint az a jelölés, amelyből megtudhatjuk, melyik nyomkövető (szoftver) szolgáltatta az adatokat.

Ehhez meg kell cserélnünk az oszlopokat: a POSITION-t ide, a SEARCH VOLUME-ot pedig ide kell tenni, a többit pedig távolítsa el a.

This is the third one… on this one I can’t find Search Volume, so we will put N/A and the rest we can remove.

Most már ezek a megfelelő helyen vannak formátum, you can create another spreadsheet where you will add all of the keywords. That’s pretty much it.

The problem we have here is with the URL – the URL from the first tracker (software) is a bit different to Tracker 2 and 3. You can see that there’s HTTP in Tracker 2 and 3, and – actually there’s no HTTP in Tracker 2 so we would need to add this.

We can see that in two of the cases, Tracker 1 and Tracker 3 is using HTTP so we’ll use a quick trick to replace WWW with HTTP//WWW.

The first one we are replacing is creating a duplicate HTTP but that’s not a problem, we will switch this back too. If there are 2 lots of HTTP then it should be replaced with a single HTTP.

So that’s done and you can see that the URLs are now consistent.

Now, the most important part is to remember that there are 7,183 keywords that we have been able to pull using these 3 types of software. WE can presume there will be a lot of duplication so we need to remove those. There are two ways to do this – I will try with this filter… yes, that’s done, so now we can copy this to one fresh spreadsheet and this is it. We have 5573 keywords here, and now, some simple maths: we had one software, Semrush, which was reporting round 3500 keywords, Searchmetrics was reporting 1800, Sistrix something like 1700 – altogether that was 7183, but when we removed the duplication there are 5573. Technically, only around 2000 keywords in this exports have been duplicated across different software, and that way you can clearly see that using 3 different types of software for the same task gives you an amazing view of all of the keywords that are ranking in your website.

Az utolsó lépés ebben a részben: készíthetek egy egyszerű pivot táblázatot, beilleszthetem a pivotot, és átgondolhatom a következőket: ide tehetek URL-eket, ide és ide is kulcsszavakat, majd ide hozzáadhatom a keresési volumenet. Összecsukjuk ezt a pivotot, és ha például a legmagasabbtól kezdve rendezzük, akkor már működik is, és láthatjuk, hogy a „Pimlico Plumbers” az az URL, amelyik a legtöbb kulcsszót tartalmazza. Néhány másik például a „Rólunk”, Toborzás, Pimlico Apprentice….then below, Service, Electrics and so on…

On the other side you can see the column with the Search Volume which you can also sort, and you can see that obviously that Number Plates is one of the most popular keywords…probably because some of the keywords that we have here in the pivot….yes, Number Plate is there, very very popular.

So, that’s it! Thank you very much for being with me, that was Lukas Zelezny and if you have any comments please don’t forget to use the comment function. If you can share this with your friends on your Facebook or Twitter then I will be very grateful. Once again, thank you very much – see you next time!