ChatGPT Keyword Analysis and Google Sheets Automation
Posted: Mon Dec 09, 2024 6:14 am
In SEO work, keyword research and content planning are the most basic and also the most time-consuming tasks. There is a question that can save us every minute we spend: “How can we automate this?” In this article, we will lay the foundation of keyword research with ChatGPT and try to get keyword ideas about the topic we want to create content from ChatGPT. We also have a surprise for you at the end of the article!
We are talking about a situation where we all spend a lot of time, in fact, similar steps are applied in every keyword analysis and the outputs are similar. The answer to the question of “How do we optimize this when the steps are clear and the outputs are similar?” is to divide it into steps and get output from LLM models with the right prompts. LLM models often produce output with the pattern of words that come one after another in the training data. The important part of this information is the “sequential succession” part. This area actually gives us information about what users are writing and asking. In short, it works logically the same as the part we call “related searches” in SERP. While someone takes into account the word order in their users’ searches, LLM takes into account the order of words or the words that come more consecutively in the dataset.
As a result, since LLM, or ChatGPT, is trained with data overseas chinese in uk data available on the internet, it can very well predict what people will search for and how. What these will be depends on the questions we will ask it.
If everyone has ChatGPT open, let's get started!
ChatGPT Should Act Like an SEO Expert!
Now we will make ChatGPT act like an SEO expert. We need to force ChatGPT to act like an SEO expert so that it can answer all our questions within a certain framework.
Our magic sentence:
Web sitesi optimizasyonu konusunda uzmanlaşmış, arama motoru optimizasyonu ve anahtar kelime araştırması konusunda uzman bir SEO uzmanı olarak hareket etmenizi istiyorum. Bundan sonra soracağım sorulara bu çerçevede cevap vermelisiniz.
Can ChatGPT Generate Keywords Like an SEO Expert?
"How to create content with ChatGPT?" has become a favorite search query for many of us. The only way to find out is to try it. Let's test the prompt I use to make ChatGPT create a subheading that fits the content:
My command to create a subtitle for the content I give to ChatGPT:
"Hamilelik belirtileri" kök anahtar kelimesi ile ilgili anahtar kelime önerilerini göstereceğimiz Türkçe bir tablo düzeni içeren bir anahtar kelime araştırma raporu oluşturun. Tablodaki veriler, kök anahtar kelimeyle ilgili en popüler anahtar kelimeler ve kelime öbekleri hakkında bilgi sağlamayı amaçlamaktadır. Anahtar kelimeler geçmiş arama hacmine göre büyükten küçüğe sıralanmalıdır.
Now Let's Create Subheadings and Determine Keyword Density!
In the first article, we took a superficial look at keyword ideas. These gave us some information about the subject and guided us. Now we need to decide which titles we will talk about in our content. After we have the titles, it will be much easier to decide on keyword density.
The prompt we will use to create subheadings is as follows:
Bu alandaki en iyi web siteleriyle rekabet eden ve Google'da her zaman üst sıralarda yer alan Türkçe içerikler yazdığınızı varsaymanızı istiyorum. Önceki cevabınızda belirlediğiniz anahtar kelimeleri kullanarak alt başlıkları ve Google'da bu anahtar kelimelerle ilgili olarak insanların en sık sorduğu soruların (PAA) ayrıntılı bir listesini de ekleyin.
Determining Keywords According to Subheadings
We now have an idea of what subheadings we will use in our content, and we also learned what questions people will want to find answers to. Our next step is to draft a list of keywords that will match the subheadings and also cover frequently asked questions. We quickly solve this problem with a short prompt.
Our prompt for determining keywords with ChatGPT:
Belirlediğiniz başlıklarda kullanılacak anahtar kelimeleri PAA (People Also Ask - İnsanların En Sık Sorduğu Sorular) kısmını da gözeterek hazırlayın. Anahtar kelimelerin eş anlamlılarının da bizim için önemli olacağını unutmayın. Aranma hacmi en yüksek olacak anahtar kelimeleri, başlıklar ile eşleşecek şekilde hazırlayın.
Our output is exactly as we wanted:
Time to Consolidate All the Data!
The data we have collected so far has been keyword ideas, synonyms, search volume estimates, and the most frequently asked questions people ask about our main keyword. In addition, we have an idea of the subheadings we can use when publishing content.
We will complete our keyword analysis by seeing all of these in a table and making a general comment. The data provided by ChatGPT is generally based on estimates, but it also gives very good ideas.
Now let's run our prompt that will create our table:
Göreviniz, bir anahtar kelime analizi raporu hazırlamak. Görevin detayı: önceki görevde tamamladığınız, belirlediğiniz başlıklarda kullanılacak anahtar kelimeleri PAA (People Al
We are talking about a situation where we all spend a lot of time, in fact, similar steps are applied in every keyword analysis and the outputs are similar. The answer to the question of “How do we optimize this when the steps are clear and the outputs are similar?” is to divide it into steps and get output from LLM models with the right prompts. LLM models often produce output with the pattern of words that come one after another in the training data. The important part of this information is the “sequential succession” part. This area actually gives us information about what users are writing and asking. In short, it works logically the same as the part we call “related searches” in SERP. While someone takes into account the word order in their users’ searches, LLM takes into account the order of words or the words that come more consecutively in the dataset.
As a result, since LLM, or ChatGPT, is trained with data overseas chinese in uk data available on the internet, it can very well predict what people will search for and how. What these will be depends on the questions we will ask it.
If everyone has ChatGPT open, let's get started!
ChatGPT Should Act Like an SEO Expert!
Now we will make ChatGPT act like an SEO expert. We need to force ChatGPT to act like an SEO expert so that it can answer all our questions within a certain framework.
Our magic sentence:
Web sitesi optimizasyonu konusunda uzmanlaşmış, arama motoru optimizasyonu ve anahtar kelime araştırması konusunda uzman bir SEO uzmanı olarak hareket etmenizi istiyorum. Bundan sonra soracağım sorulara bu çerçevede cevap vermelisiniz.
Can ChatGPT Generate Keywords Like an SEO Expert?
"How to create content with ChatGPT?" has become a favorite search query for many of us. The only way to find out is to try it. Let's test the prompt I use to make ChatGPT create a subheading that fits the content:
My command to create a subtitle for the content I give to ChatGPT:
"Hamilelik belirtileri" kök anahtar kelimesi ile ilgili anahtar kelime önerilerini göstereceğimiz Türkçe bir tablo düzeni içeren bir anahtar kelime araştırma raporu oluşturun. Tablodaki veriler, kök anahtar kelimeyle ilgili en popüler anahtar kelimeler ve kelime öbekleri hakkında bilgi sağlamayı amaçlamaktadır. Anahtar kelimeler geçmiş arama hacmine göre büyükten küçüğe sıralanmalıdır.
Now Let's Create Subheadings and Determine Keyword Density!
In the first article, we took a superficial look at keyword ideas. These gave us some information about the subject and guided us. Now we need to decide which titles we will talk about in our content. After we have the titles, it will be much easier to decide on keyword density.
The prompt we will use to create subheadings is as follows:
Bu alandaki en iyi web siteleriyle rekabet eden ve Google'da her zaman üst sıralarda yer alan Türkçe içerikler yazdığınızı varsaymanızı istiyorum. Önceki cevabınızda belirlediğiniz anahtar kelimeleri kullanarak alt başlıkları ve Google'da bu anahtar kelimelerle ilgili olarak insanların en sık sorduğu soruların (PAA) ayrıntılı bir listesini de ekleyin.
Determining Keywords According to Subheadings
We now have an idea of what subheadings we will use in our content, and we also learned what questions people will want to find answers to. Our next step is to draft a list of keywords that will match the subheadings and also cover frequently asked questions. We quickly solve this problem with a short prompt.
Our prompt for determining keywords with ChatGPT:
Belirlediğiniz başlıklarda kullanılacak anahtar kelimeleri PAA (People Also Ask - İnsanların En Sık Sorduğu Sorular) kısmını da gözeterek hazırlayın. Anahtar kelimelerin eş anlamlılarının da bizim için önemli olacağını unutmayın. Aranma hacmi en yüksek olacak anahtar kelimeleri, başlıklar ile eşleşecek şekilde hazırlayın.
Our output is exactly as we wanted:
Time to Consolidate All the Data!
The data we have collected so far has been keyword ideas, synonyms, search volume estimates, and the most frequently asked questions people ask about our main keyword. In addition, we have an idea of the subheadings we can use when publishing content.
We will complete our keyword analysis by seeing all of these in a table and making a general comment. The data provided by ChatGPT is generally based on estimates, but it also gives very good ideas.
Now let's run our prompt that will create our table:
Göreviniz, bir anahtar kelime analizi raporu hazırlamak. Görevin detayı: önceki görevde tamamladığınız, belirlediğiniz başlıklarda kullanılacak anahtar kelimeleri PAA (People Al