November 13, 2023Benjamin O’Daniel
How to research your valuable website keywords
The start of SEO is always: know your keywords. And the right ones.
The website keywords
- that are close to the business
- where you have a chance
- where you have something to say
For that you need: a professional SEO tool. And the right way of working, so that you do not get lost in it.
Keyword research for your website. Easier said than done. We talk about it in this podcast episode and on this page. By the way: for keyword research we have developed our own tool in the ChatGPT environment.

3 common problems with website keywords
No alignment with the company goals
A keyword research project is often tackled across all business areas and topics. That leads to only scratching the surface. In corporate blogs we also often see topics being produced that are very far from the concrete problems of the customers. Yet it is precisely in the concrete questions and problems of the customers that valuable keywords sit. That applies especially to B2B SEO.
Aimless collection of search terms
Once you get into keyword research, you notice quickly: there are thousands of search terms that might be relevant. But which ones do you pick? Some marketing leads pick out only very few terms, and so do not cover the potential even remotely. Others set up numerous sheets in Excel, but then you can hardly run any analysis with them.
No structure in the Excel list
The decisive point in keyword research: the Excel list needs a structure. We usually organize it by topics, keywords, and search volume, and then assign that to certain page types (landing pages, blog, glossary, and so on). That way the list automatically becomes a content plan that you can then implement. With focus keywords and niche keywords.
Keyword research in our SEO Academy
In our SEO Academy we offer a whole set of workshops on this:
- How you research B2B keywords systematically
- Keyword research for a product area in an online shop
- How you build a central Excel list of keywords
In the recorded workshops and tutorials we work with Sistrix, SEMrush, and Mangools, among others. In the workshop on the Excel list we have included a template.
More on the SEO Academy
Here is a screenshot from a tutorial workshop, from our Academy archive. Every time we share our screen and discuss each topic using examples, often from our Academy members.
The valuable website keywords come from the company goals
The first step we recommend: connect the SEO strategy with the central company strategy. That means: which business area is supposed to grow in the future? Where is there a field in which more visibility and more reach should come about?
The focus for the keyword research follows from that. From the first search term on, you are already working in a “valuable” area for the website.
After that it goes into the concrete research, clustering, and sorting in Excel. Important for the work in Excel: all search terms belong in one worksheet if possible. The worksheet is then sorted and structured so that you can filter all the data flexibly, for example by topic, search volume, CPC, and further information.
This central document also produces concrete requirements for the website structure and the website texts.

For many years we have explained in workshops and talks how you approach SEO systematically. It is especially important to us that marketing leads who are not experts also understand what they should watch for, and how they proceed in concrete terms.
We advise marketing leads on SEO

We are Fabian Jaeckert (on the right) and Benjamin O’Daniel. For many years we have worked as consultants for marketing teams. In doing so we connect two worlds: Fabian is the technical expert, Benjamin takes on every topic around content development.
With Jaeckert O’Daniel, it quickly became clear to us that we had made an excellent choice in selecting potential partners for our online marketing project. Their expertise and, above all, their ambition to thoroughly immerse themselves in our specific industry topic to provide us with the best possible support, are precisely what is now propelling us forward.
Tobias ReitmeierF.EE Group
“How can we improve our SEO visibility?”
This fundamental question sits behind every project we are brought on board for.
Often it is about reviewing existing SEO and content strategies from the outside and developing new levers.
That is exactly what we have specialized in.
We develop SEO strategies for companies and present them in focus workshops, in a structured and understandable way, to the people responsible. After that we support the in-house leads through the implementation.
Sound interesting?
We are happy to arrange an SEO intro by video conference (30 min.).
Our conversations with SEO professionals in the industry

SEO quality assurance: How to protect your rankings. Interview with Gianna Brachetti-Truskawa

How Südwestrundfunk (SWR) works on search experience: Interview with Sarah Stein

SEO as a growth strategy: Interview with Kevin Indig

SEO for a software company: Interview with Beat Köck

What does an online shop need in order to rank successfully? Interview with Stefan Vorwerk

How Hansgrohe does SEO in 40 countries: Interview with Jörg Niethammer

The SEO strategy of Hubspot: Interview with Jenny Lapp

How user testing works: Interview with Astrid Kramer on UX and SEO






