{"id":30434,"date":"2020-02-16T21:20:48","date_gmt":"2020-02-16T20:20:48","guid":{"rendered":"https:\/\/wooacademy.sk\/analyza-klucovych-slov-ako-na-to-a-kde-zacat\/"},"modified":"2026-10-07T21:43:22","modified_gmt":"2026-10-07T19:43:22","slug":"keyword-research-how-to-start","status":"publish","type":"post","link":"https:\/\/wooacademy.sk\/en\/keyword-research-how-to-start\/","title":{"rendered":"Keyword Research \u2013 How to Do It and Where to Start"},"content":{"rendered":"<!--themify_builder_content-->\n<div id=\"themify_builder_content-30434\" data-postid=\"30434\" class=\"themify_builder_content themify_builder_content-30434 themify_builder tf_clear\">\n                    <div  data-lazy=\"1\" class=\"module_row themify_builder_row tb_xvv3776 tb_first tf_w\">\n                        <div class=\"row_inner col_align_top tb_col_count_1 tf_box tf_rel\">\n                        <div  data-lazy=\"1\" class=\"module_column tb-column col-full tb_wn4t776 first\">\n                    <!-- module text -->\n<div  class=\"module module-text tb_9kw8841  repeat \" data-lazy=\"1\">\n        <div  class=\"tb_text_wrap\">\n        <p style=\"text-align: center;\"><span style=\"text-align: left;\">Keyword research is the first and most fundamental step in search engine optimization (SEO). Without it, it&#8217;s very hard to do SEO or optimize anything. It&#8217;s optimizing blind.<\/span><\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_lfkh71  repeat \" data-lazy=\"1\" id=\"zapnutie-3\">\n        <div  class=\"tb_text_wrap\">\n        <h2><strong>What is keyword research<\/strong><\/h2>\n<p>It&#8217;s an Excel document containing an exhaustive list of the keywords and phrases people use to search for your products or services.<\/p>\n<p>Based on the data in the keyword research, such as:<\/p>\n<ul>\n<li>monthly and average search volumes for keywords and phrases<\/li>\n<li>keyword competitiveness<\/li>\n<li>landing pages<\/li>\n<li>cost per click (CPC)<\/li>\n<li>classification of keywords into logical categories<\/li>\n<\/ul>\n<p>you can make strategic decisions within your SEO and marketing strategy that can go a long way toward increasing your return on marketing investment.<\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_eazh451  repeat \" data-lazy=\"1\" id=\"zapnutie-2-3\">\n        <div  class=\"tb_text_wrap\">\n        <h3 class=\"LC20lb DKV0Md\" style=\"text-align: center;\"><strong>TIP: what not to do with keyword research<\/strong><\/h3>\n<p>The worst possible scenario with keyword research is this: you pay for it (because companies already know they need this document for online marketing, especially SEO and PPC), the <a href=\"https:\/\/wooacademy.sk\/lektori\/seo-specialista-milan-frano\/\">SEO specialist<\/a> delivers it, but <strong>nothing gets done with it and half a year goes by<\/strong> before anyone in the company even opens it and starts figuring out what to do with it.<\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_drno109  repeat \" data-lazy=\"1\" id=\"zapnutie\">\n        <div  class=\"tb_text_wrap\">\n        <h2><strong>How long does keyword research take<\/strong><\/h2>\n<p>It all depends on:<\/p>\n<ul>\n<li><strong>the quality of the research<\/strong> (I&#8217;ve seen various outputs with zero informational value, where the author just exported Keyword Planner results for a few queries)<\/li>\n<li><strong>the segment the research is for<\/strong> (it makes a difference whether I&#8217;m doing research for an online store with hundreds of categories or a website with five services)<\/li>\n<li><strong>the \u201chonesty\u201d of the SEO specialist<\/strong> (whether they cut corners when cleaning and categorizing\/classifying the data by doing everything automatically without looking at search volumes and the logic of the individual clusters)<\/li>\n<\/ul>\n<p style=\"text-align: center;\">In general, keyword research takes <strong>10 to 40 hours.<\/strong><\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_mcef256  repeat \" data-lazy=\"1\" id=\"zapnutie-6\">\n        <div  class=\"tb_text_wrap\">\n        <h2><strong>The cost of keyword research<\/strong><\/h2>\n<p>The price depends on the SEO specialist, and it ranges (very roughly) from:<\/p>\n<ul>\n<li><strong>\u20ac50\u2013200<\/strong> (on freelance marketplaces such as the Slovak site jasprav\u00edm, for example, there are various \u201cspecialists\u201d who just export keyword suggestions from Keyword Planner and call it done)<\/li>\n<li><strong>\u20ac200\u2013500 <\/strong> (for this amount freelancers can already produce fairly good keyword research or a content gap analysis)<\/li>\n<li><strong>\u20ac500\u20135,000<\/strong> (depending on the agency\/specialist, the scope and the languages of the research)<\/li>\n<\/ul>\n<p> <\/p>\n<p style=\"text-align: center;\">The price of the research largely reflects the time spent on it and the \u201ctechnology\u201d used (as well as the company doing it, although in online marketing especially, more expensive isn&#8217;t always better). If you&#8217;re interested in our prices, you&#8217;ll find them in <strong><a href=\"https:\/\/wooacademy.sk\/marketingove-sluzby\/#seo\">wooacademy services<\/a>.<\/strong><\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_28gs414  repeat \" data-lazy=\"1\" id=\"zapnutie-5\">\n        <div  class=\"tb_text_wrap\">\n        <h2><strong>Who \u201cneeds\u201d keyword research<\/strong><\/h2>\n<p>Keyword research is \u201cneeded\u201d by online projects that plan to:<\/p>\n<ul>\n<li>optimize their website for search engines (<a href=\"https:\/\/wooacademy.sk\/en\/what-is-seo\/\">SEO<\/a>)<\/li>\n<li>run PPC campaigns<\/li>\n<li>modify a website or online store, add new filters and categories, and generally restructure the website<\/li>\n<li>create content (a blog, magazine, news and so on)<\/li>\n<li>define personas and audiences<\/li>\n<li>set marketing budgets and assess market potential (e.g. when expanding abroad, you can estimate market potential based on search volume and competition)<\/li>\n<\/ul>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_3bed607  repeat \" data-lazy=\"1\" id=\"zapnutie-5-3\">\n        <div  class=\"tb_text_wrap\">\n        <h2><strong>Who knows their way around keyword research<\/strong><\/h2>\n<p>Most clients, unless they work directly in online marketing, don&#8217;t really find their way around keyword research. But when this deliverable lands in the hands of the marketing department or external suppliers, they should understand it and know what to do with it. They include:<\/p>\n<ul>\n<li><strong>PPC specialists<\/strong> \u2013 for them it&#8217;s an absolutely essential document and they find their way around it without any problems<\/li>\n<li><strong>SEO specialists<\/strong> \u2013 optimization is very hard to do without keyword research<\/li>\n<li><strong>copywriters<\/strong> \u2013 personally, I often struggle with copywriters here, and I don&#8217;t like working with those who don&#8217;t write articles for SEO (when that&#8217;s the brief) but just to fill one standard page. Copywriters should know how to work with keyword research and even create it themselves (if they don&#8217;t know how, we&#8217;ll happily <a href=\"https:\/\/wooacademy.sk\/kurz\/analyza-klucovych-slov-workshop-bratislava\/\"><strong>teach them<\/strong><\/a> ?)<\/li>\n<li>it may surprise you, but my personal experience is that <strong>product managers<\/strong> and entrepreneurs dealing with expansion abroad know their way around keyword research very well<\/li>\n<\/ul>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_zyk4309  repeat \" data-lazy=\"1\" id=\"zapnutie-5-2-2\">\n        <div  class=\"tb_text_wrap\">\n        <h2><strong>What you&#8217;ll need to create keyword research<\/strong><\/h2>\n<p> <\/p>\n<ul>\n<li><strong>Excel <\/strong> (that&#8217;s probably obvious: you need to put the data somewhere, and Excel is ideal because it has functions that let you keep working with the data and evaluate it)<\/li>\n<li><a href=\"https:\/\/openrefine.org\/download.html\" target=\"_blank\" rel=\"noopener\"><strong>OpenRefine <\/strong><\/a>(a free tool for working with data, cleaning it, classifying it and so on; here you&#8217;ll mainly use the cluster and edit feature, which can merge similar terms)<\/li>\n<li><a href=\"https:\/\/www.marketingminer.com\/\" target=\"_blank\" rel=\"noopener\"><strong>Marketing Miner<\/strong> <\/a>(a paid tool, but worth every euro and absolutely indispensable for keyword research; roughly halfway through this article there&#8217;s a coupon for a 40% discount waiting for you \u2013 I highly recommend it, I work with it every day)<\/li>\n<li>personally, I also use some free online tools to collect data (<a href=\"https:\/\/neilpatel.com\/ubersuggest\/\" target=\"_blank\" rel=\"noopener\">Ubersuggest<\/a>, Google&#8217;s Keyword Planner, occasionally <a href=\"https:\/\/keywordtool.io\/\" target=\"_blank\" rel=\"noopener\">Keywordtool<\/a>, and that&#8217;s about it)<\/li>\n<\/ul>\n<p> <\/p>\n<p>I forgot to mention that you&#8217;ll also need <strong>time<\/strong>, not just for the research itself but also for understanding the client and their products. The first step of the research is understanding the goods or services you&#8217;re creating it for.<\/p>\n<p>When I do keyword research for a client, I also go through their website thoroughly while collecting data, category by category, product by product. I do this to make sure I cover all the relevant keywords, which may be hidden, for example, in a product&#8217;s composition and may form a significant keyword category.<\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_9847872  repeat \" data-lazy=\"1\" id=\"zapnutie-4-2\">\n        <div  class=\"tb_text_wrap\">\n        <h2><strong>How keyword research is done<\/strong><\/h2>\n<p>In general it&#8217;s divided into 5 to 8 main steps:<\/p>\n<ul>\n<li><strong>thoroughly understanding the client&#8217;s portfolio<\/strong><\/li>\n<li><strong>data collection<\/strong><\/li>\n<li><strong>data mining<\/strong><\/li>\n<li><strong>data cleaning<\/strong><\/li>\n<li><strong>data classification \/ categorization<\/strong><\/li>\n<li><strong>creating the deliverable<\/strong><\/li>\n<li><strong>writing a report with recommendations for implementation<\/strong><\/li>\n<li><strong>and, of course, applying the research to strategy and tactics<\/strong><\/li>\n<\/ul>\n<p> <\/p>\n<p>Let&#8217;s take a closer look at what each step involves:<\/p>\n<h3> <\/h3>\n<h3><strong>Understanding the client&#8217;s portfolio<\/strong><\/h3>\n<p>This makes sense, since very few SEO specialists (it would probably be more accurate to say none) know every segment in detail (from automotive through fashion and electronics to dietary supplements) and know which words to use for data collection.<\/p>\n<p>I combine this step with data collection and carefully go through the client&#8217;s portfolio, category by category, product by product, looking for keywords to use in data collection.<\/p>\n<p>The most common misconception I come across when people choose not only an SEO specialist is: \u201c(CLIENT) I need someone who knows our products perfectly and has worked for a similar client for at least 3 years.\u201d<\/p>\n<p>If the specialist (I mean real specialists) is good, it doesn&#8217;t matter that they&#8217;ve never worked for a similar client. They can do the same work at the same quality as a specialist who has already worked in that segment.<\/p>\n<h3> <\/h3>\n<h3><strong>Data collection<\/strong><\/h3>\n<p>Data collection (building the initial data set) means gathering all the keywords and phrases related to the segment you&#8217;re doing the research for, the words people actually search for.<\/p>\n<h4> <\/h4>\n<h4><strong>Where do I get the input data?<\/strong><\/h4>\n<ul>\n<li>Google Analytics<\/li>\n<li>Google Ads<\/li>\n<li>Google Search Console<\/li>\n<li>the client&#8217;s website<\/li>\n<li>competitors&#8217; websites<\/li>\n<li>forums<\/li>\n<li>Keyword Planner<\/li>\n<li>Ubersuggest<\/li>\n<li>and of course my favorite and most-used tool, <strong><a href=\"https:\/\/www.marketingminer.com\/en\/pricing\" target=\"_blank\" rel=\"noopener\">Marketing Miner <\/a><\/strong><\/li>\n<\/ul>\n<p> <\/p>\n<p>This gets you tens of thousands of words (raw data), which you&#8217;ll use in the next steps when cleaning and mining the data. Of course, you need to put all the words from all the tabs neatly into one column in Excel.<\/p>\n<p> <\/p>\n<h3><strong>Data mining<\/strong><\/h3>\n<p>Data mining means obtaining data (extracting data) on search volume, competition, CPC and so on for the words in our data set.<\/p>\n<p>The data set is nicely filled. What next?<\/p>\n<ul>\n<li>remove duplicates (this is step number one; you don&#8217;t need to collect data twice. In Excel I create a column with the keywords stripped of punctuation and then remove the duplicates)<\/li>\n<li>now it&#8217;s <strong>Marketing Miner<\/strong>&#8216;s turn, an irreplaceable helper in data mining. I load the data into Marketing Miner.<\/li>\n<\/ul>\n<p><strong>Note:<\/strong> If you&#8217;re doing keyword research for a segment where the data set has tens of thousands of words or more, sometimes your Marketing Miner plan won&#8217;t be enough, and then you have 2 options: <strong>a) upgrade your plan (recommended)<\/strong> or <strong>b) clean the data before loading it into Miner<\/strong> and throw out groups of words that are completely unrelated to the segment of the research. You can also cluster the data during cleaning in OpenRefine, although personally I wouldn&#8217;t recommend it, because you may lose search volumes for some interesting words you \u201cmerged\u201d.<\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_4m62538  repeat \" data-lazy=\"1\" id=\"zapnutie-4\">\n        <div  class=\"tb_text_wrap\">\n        <h3><strong>Data cleaning<\/strong><\/h3>\n<p>The keywords you&#8217;ve collected also include lots of words that don&#8217;t fit the target segment, and you need to get rid of them so they don&#8217;t \u201cget in the way\u201d. The words to remove also include those with the same meaning but a different form due to inflection or misspelling.<\/p>\n<p> <\/p>\n<p>You can clean the data in <strong>OpenRefine<\/strong> and\/or <strong>Excel<\/strong>.<\/p>\n<p>Imagine the following situation: I find that the keywords contain patterns that don&#8217;t belong in the research. Let&#8217;s say the client offers their products only for women, so I find the word stems for man, men&#8217;s, boy, child, gentleman and throw out all these terms. I use OpenRefine for this, but you can do this step in Excel too.<\/p>\n<p>There are terms I&#8217;m not sure at first whether I can remove. For example, if you were doing keyword research for a client that also runs TV and radio ads (banks, insurance companies and the like), and a certain name comes up often in the research (unknown to me and unrelated to the keywords), I won&#8217;t remove that name or names but put them into some logical category. If it&#8217;s a person, for example, they may have appeared in an ad or be a micro-influencer, so the word may come in handy for other campaigns or collaborations.<\/p>\n<p> <\/p>\n<p>I also need to mention a very important step in OpenRefine: the <strong>Cluster and Edit<\/strong> feature, which can group together words that are inflected, misspelled or have a different word order, and you can then merge them. I can&#8217;t imagine doing keyword research without <strong>Marketing Miner<\/strong> and the <strong>cluster and edit feature<\/strong> in OpenRefine (of course it can be done other ways, but the output may not be relevant).<\/p>\n<p>After cluster and edit you&#8217;ll end up with duplicates that you have to remove, but you mustn&#8217;t forget to add up the search volumes for the individual terms.<\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module video -->\n<div  class=\"module module-video tb_m7mi447 video-top  \" data-lazy=\"1\">\n                    <div class=\"video-wrap-outer\">\n            <div class=\"video-wrap tf_rel tf_overflow\">\n                                    <noscript><iframe data-no-script src=\"https:\/\/www.youtube.com\/embed\/fJ5Q5hJMX70?pip=1&#038;playsinline=1&#038;mute=1\" allow=\"accelerometer;encrypted-media;gyroscope;picture-in-picture;fullscreen\" class=\"tf_abs tf_w tf_h\"><\/iframe><\/noscript>\n                                <\/div>\n            <!-- \/video-wrap -->\n        <\/div>\n        <!-- \/video-wrap-outer -->\n            <\/div>\n<!-- module text -->\n<div  class=\"module module-text tb_ytv0189  repeat \" data-lazy=\"1\" id=\"zapnutie-4-3-2\">\n        <div  class=\"tb_text_wrap\">\n        <h3><strong>Data classification and categorization<\/strong><\/h3>\n<p>You now have a cleaned data set (an Excel spreadsheet of keywords) that, on its own, tells the client who ordered the keyword research very little.<\/p>\n<p>These words need to be divided into categories, subcategories and other logical groups based on the patterns in them.<\/p>\n<p>For example, you find that words related to price come up often, so you filter them in OpenRefine and put them into a specific category (cheap, luxury, expensive, sale, second-hand, deal, discount, etc.).<\/p>\n<p>I try to find as many similar categories as possible, such as location, attributes, questions, purpose (which event or occasion), brand and so on.<\/p>\n<p>Marketing Miner also categorizes the data during data mining. This categorization is a very good aid, but I don&#8217;t rely on it alone and look for as many logical groups as possible to put the keywords into.<\/p>\n<p>Only once you have the words assigned (categorized) can you finalize and evaluate the data (very easily, for example, with pivot tables).<\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module video -->\n<div  class=\"module module-video tb_ue2h627 video-top  \" data-lazy=\"1\">\n                    <div class=\"video-wrap-outer\">\n            <div class=\"video-wrap tf_rel tf_overflow\">\n                                    <noscript><iframe data-no-script src=\"https:\/\/www.youtube.com\/embed\/CYWiOIp4iKo?pip=1&#038;playsinline=1&#038;mute=1\" allow=\"accelerometer;encrypted-media;gyroscope;picture-in-picture;fullscreen\" class=\"tf_abs tf_w tf_h\"><\/iframe><\/noscript>\n                                <\/div>\n            <!-- \/video-wrap -->\n        <\/div>\n        <!-- \/video-wrap-outer -->\n            <\/div>\n<!-- module text -->\n<div  class=\"module module-text tb_2pvy459  repeat \" data-lazy=\"1\" id=\"zapnutie-4-3-3\">\n        <div  class=\"tb_text_wrap\">\n        <h3><strong>Finalizing and creating the final keyword research deliverable<\/strong><\/h3>\n<p>There are certain standards for what keyword research should look like. But every specialist has their own template they use.<\/p>\n<p>The research should be prepared so that even a layperson can find their way around it with a guide and apply the data, for example, to an SEO tactic for changes to a website or online store and to content creation.<\/p>\n<p style=\"text-align: center;\">I won&#8217;t share specific research, but I&#8217;ll teach you how to do it at the <a href=\"https:\/\/wooacademy.sk\/kurz\/analyza-klucovych-slov-workshop-bratislava\/\">keyword research training<\/a>.<\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_bdyq795  repeat \" data-lazy=\"1\" id=\"zapnutie-4-3\">\n        <div  class=\"tb_text_wrap\">\n        <h3>Recommendations accompanying keyword research<\/h3>\n<p>Along with the keyword research, I also hand clients recommendations and a written evaluation of the deliverable. Usually it&#8217;s an evaluation of the pivot table outputs and the content of the Excel file.<\/p>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_qfuh570  repeat \" data-lazy=\"1\" id=\"zapnutie-4-3-4\">\n        <div  class=\"tb_text_wrap\">\n        <h3>Applying keyword research and putting it into practice<\/h3>\n<p>What happens with the keyword research is up to the client. But I definitely recommend:<\/p>\n<ul>\n<li>create content on your website or online store, and also look at words with high search volume, low to medium competition and high CPC<\/li>\n<li>use the research when creating Google ads (PPC)<\/li>\n<li>look at your site structure and, based on search patterns, adjust categories, filters, site structure and navigation<\/li>\n<li>use the research for on-page and off-page SEO<\/li>\n<\/ul>    <\/div>\n<\/div>\n<!-- \/module text --><!-- module text -->\n<div  class=\"module module-text tb_wln2847  repeat \" data-lazy=\"1\">\n        <div  class=\"tb_text_wrap\">\n        <h2><strong>Conclusion<\/strong><\/h2>\n<ul>\n<li>I warmly recommend keyword research if you&#8217;re serious about SEO.<\/li>\n<li>If you need help creating keyword research, don&#8217;t hesitate to contact us at <a href=\"tel:+421940634491\">+421 940 634 491<\/a> or <a href=\"mailto:info@wooacademy.sk\">info@wooacademy.sk<\/a><\/li>\n<li>If you liked the article and found it useful, feel free to share it on Facebook or tell people you know about it.<\/li>\n<li>If you want to learn more about online marketing, choose one of our <a href=\"https:\/\/wooacademy.sk\/kurzy-a-skolenia\/\">courses and workshops in Bratislava.<\/a><\/li>\n<li>You can also order our <a href=\"https:\/\/wooacademy.sk\/marketingove-sluzby\/\">online marketing services<\/a>.<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><strong>We look forward to seeing you at our courses or consultations.<\/strong><\/p>    <\/div>\n<\/div>\n<!-- \/module text -->        <\/div>\n                        <\/div>\n        <\/div>\n        <\/div>\n<!--\/themify_builder_content-->","protected":false},"excerpt":{"rendered":"<p>Keyword research is the first and most fundamental step in search engine optimization (SEO). Without it, it&#8217;s very hard to do SEO or optimize anything. It&#8217;s optimizing blind.<\/p>\n","protected":false},"author":2,"featured_media":18971,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[824],"tags":[828,904,905],"class_list":["post-30434","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-seo","tag-seo-doktor","tag-web","tag-wordpress","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"builder_content":"<p style=\"text-align: center;\">Keyword research is the first and most fundamental step in search engine optimization (SEO). Without it, it's very hard to do SEO or optimize anything. It's optimizing blind.<\/p>\n<p><strong> In short and simplified: impressions, clicks, position<\/strong><\/p> <ul> <li><strong>Impressions: <\/strong>when someone saw a link to your domain (or it was displayed to them \u2013 they didn't necessarily actually see it).<\/li> <li><strong>Clicks: <\/strong>every single click that leads to your domain.<\/li> <li><strong>Position: <\/strong>the position at which your domain was visible (displayed) \u2013 of course, this is the average position in the search results.<\/li> <\/ul>\n<h2><strong>What is keyword research<\/strong><\/h2> <p>It's an Excel document containing an exhaustive list of the keywords and phrases people use to search for your products or services.<\/p> <p>Based on the data in the keyword research, such as:<\/p> <ul> <li>monthly and average search volumes for keywords and phrases<\/li> <li>keyword competitiveness<\/li> <li>landing pages<\/li> <li>cost per click (CPC)<\/li> <li>classification of keywords into logical categories<\/li> <\/ul> <p>you can make strategic decisions within your SEO and marketing strategy that can go a long way toward increasing your return on marketing investment.<\/p>\n<h3 style=\"text-align: center;\"><strong>TIP: what not to do with keyword research<\/strong><\/h3> <p>The worst possible scenario with keyword research is this: you pay for it (because companies already know they need this document for online marketing, especially SEO and PPC), the <a href=\"https:\/\/wooacademy.sk\/lektori\/seo-specialista-milan-frano\/\">SEO specialist<\/a> delivers it, but <strong>nothing gets done with it and half a year goes by<\/strong> before anyone in the company even opens it and starts figuring out what to do with it.<\/p>\n<h2><strong>How long does keyword research take<\/strong><\/h2> <p>It all depends on:<\/p> <ul> <li><strong>the quality of the research<\/strong> (I've seen various outputs with zero informational value, where the author just exported Keyword Planner results for a few queries)<\/li> <li><strong>the segment the research is for<\/strong> (it makes a difference whether I'm doing research for an online store with hundreds of categories or a website with five services)<\/li> <li><strong>the \u201chonesty\u201d of the SEO specialist<\/strong> (whether they cut corners when cleaning and categorizing\/classifying the data by doing everything automatically without looking at search volumes and the logic of the individual clusters)<\/li> <\/ul> <p style=\"text-align: center;\">In general, keyword research takes <strong>10 to 40 hours.<\/strong><\/p>\n<h2><strong>The cost of keyword research<\/strong><\/h2> <p>The price depends on the SEO specialist, and it ranges (very roughly) from:<\/p> <ul> <li><strong>\u20ac50\u2013200<\/strong> (on freelance marketplaces such as the Slovak site jasprav\u00edm, for example, there are various \u201cspecialists\u201d who just export keyword suggestions from Keyword Planner and call it done)<\/li> <li><strong>\u20ac200\u2013500 <\/strong> (for this amount freelancers can already produce fairly good keyword research or a content gap analysis)<\/li> <li><strong>\u20ac500\u20135,000<\/strong> (depending on the agency\/specialist, the scope and the languages of the research)<\/li> <\/ul> <p> <\/p> <p style=\"text-align: center;\">The price of the research largely reflects the time spent on it and the \u201ctechnology\u201d used (as well as the company doing it, although in online marketing especially, more expensive isn't always better). If you're interested in our prices, you'll find them in <strong><a href=\"https:\/\/wooacademy.sk\/marketingove-sluzby\/#seo\">wooacademy services<\/a>.<\/strong><\/p>\n<h2><strong>Who \u201cneeds\u201d keyword research<\/strong><\/h2> <p>Keyword research is \u201cneeded\u201d by online projects that plan to:<\/p> <ul> <li>optimize their website for search engines (<a href=\"https:\/\/wooacademy.sk\/en\/what-is-seo\/\">SEO<\/a>)<\/li> <li>run PPC campaigns<\/li> <li>modify a website or online store, add new filters and categories, and generally restructure the website<\/li> <li>create content (a blog, magazine, news and so on)<\/li> <li>define personas and audiences<\/li> <li>set marketing budgets and assess market potential (e.g. when expanding abroad, you can estimate market potential based on search volume and competition)<\/li> <\/ul>\n<h2><strong>Who knows their way around keyword research<\/strong><\/h2> <p>Most clients, unless they work directly in online marketing, don't really find their way around keyword research. But when this deliverable lands in the hands of the marketing department or external suppliers, they should understand it and know what to do with it. They include:<\/p> <ul> <li><strong>PPC specialists<\/strong> \u2013 for them it's an absolutely essential document and they find their way around it without any problems<\/li> <li><strong>SEO specialists<\/strong> \u2013 optimization is very hard to do without keyword research<\/li> <li><strong>copywriters<\/strong> \u2013 personally, I often struggle with copywriters here, and I don't like working with those who don't write articles for SEO (when that's the brief) but just to fill one standard page. Copywriters should know how to work with keyword research and even create it themselves (if they don't know how, we'll happily <a href=\"https:\/\/wooacademy.sk\/kurz\/analyza-klucovych-slov-workshop-bratislava\/\"><strong>teach them<\/strong><\/a> ?)<\/li> <li>it may surprise you, but my personal experience is that <strong>product managers<\/strong> and entrepreneurs dealing with expansion abroad know their way around keyword research very well<\/li> <\/ul>\n<h2><strong>What you'll need to create keyword research<\/strong><\/h2> <p> <\/p> <ul> <li><strong>Excel <\/strong> (that's probably obvious: you need to put the data somewhere, and Excel is ideal because it has functions that let you keep working with the data and evaluate it)<\/li> <li><a href=\"https:\/\/openrefine.org\/download.html\"><strong>OpenRefine <\/strong><\/a>(a free tool for working with data, cleaning it, classifying it and so on; here you'll mainly use the cluster and edit feature, which can merge similar terms)<\/li> <li><a href=\"https:\/\/www.marketingminer.com\/\"><strong>Marketing Miner<\/strong> <\/a>(a paid tool, but worth every euro and absolutely indispensable for keyword research; roughly halfway through this article there's a coupon for a 40% discount waiting for you \u2013 I highly recommend it, I work with it every day)<\/li> <li>personally, I also use some free online tools to collect data (<a href=\"https:\/\/neilpatel.com\/ubersuggest\/\">Ubersuggest<\/a>, Google's Keyword Planner, occasionally <a href=\"https:\/\/keywordtool.io\/\">Keywordtool<\/a>, and that's about it)<\/li> <\/ul> <p> <\/p> <p>I forgot to mention that you'll also need <strong>time<\/strong>, not just for the research itself but also for understanding the client and their products. The first step of the research is understanding the goods or services you're creating it for.<\/p> <p>When I do keyword research for a client, I also go through their website thoroughly while collecting data, category by category, product by product. I do this to make sure I cover all the relevant keywords, which may be hidden, for example, in a product's composition and may form a significant keyword category.<\/p>\n<h2><strong>How keyword research is done<\/strong><\/h2> <p>In general it's divided into 5 to 8 main steps:<\/p> <ul> <li><strong>thoroughly understanding the client's portfolio<\/strong><\/li> <li><strong>data collection<\/strong><\/li> <li><strong>data mining<\/strong><\/li> <li><strong>data cleaning<\/strong><\/li> <li><strong>data classification \/ categorization<\/strong><\/li> <li><strong>creating the deliverable<\/strong><\/li> <li><strong>writing a report with recommendations for implementation<\/strong><\/li> <li><strong>and, of course, applying the research to strategy and tactics<\/strong><\/li> <\/ul> <p> <\/p> <p>Let's take a closer look at what each step involves:<\/p> <h3> <\/h3> <h3><strong>Understanding the client's portfolio<\/strong><\/h3> <p>This makes sense, since very few SEO specialists (it would probably be more accurate to say none) know every segment in detail (from automotive through fashion and electronics to dietary supplements) and know which words to use for data collection.<\/p> <p>I combine this step with data collection and carefully go through the client's portfolio, category by category, product by product, looking for keywords to use in data collection.<\/p> <p>The most common misconception I come across when people choose not only an SEO specialist is: \u201c(CLIENT) I need someone who knows our products perfectly and has worked for a similar client for at least 3 years.\u201d<\/p> <p>If the specialist (I mean real specialists) is good, it doesn't matter that they've never worked for a similar client. They can do the same work at the same quality as a specialist who has already worked in that segment.<\/p> <h3> <\/h3> <h3><strong>Data collection<\/strong><\/h3> <p>Data collection (building the initial data set) means gathering all the keywords and phrases related to the segment you're doing the research for, the words people actually search for.<\/p> <h4> <\/h4> <h4><strong>Where do I get the input data?<\/strong><\/h4> <ul> <li>Google Analytics<\/li> <li>Google Ads<\/li> <li>Google Search Console<\/li> <li>the client's website<\/li> <li>competitors' websites<\/li> <li>forums<\/li> <li>Keyword Planner<\/li> <li>Ubersuggest<\/li> <li>and of course my favorite and most-used tool, <strong><a href=\"https:\/\/www.marketingminer.com\/en\/pricing\">Marketing Miner <\/a><\/strong><\/li> <\/ul> <p> <\/p> <p>This gets you tens of thousands of words (raw data), which you'll use in the next steps when cleaning and mining the data. Of course, you need to put all the words from all the tabs neatly into one column in Excel.<\/p> <p> <\/p> <h3><strong>Data mining<\/strong><\/h3> <p>Data mining means obtaining data (extracting data) on search volume, competition, CPC and so on for the words in our data set.<\/p> <p>The data set is nicely filled. What next?<\/p> <ul> <li>remove duplicates (this is step number one; you don't need to collect data twice. In Excel I create a column with the keywords stripped of punctuation and then remove the duplicates)<\/li> <li>now it's <strong>Marketing Miner<\/strong>'s turn, an irreplaceable helper in data mining. I load the data into Marketing Miner.<\/li> <\/ul> <p><strong>Note:<\/strong> If you're doing keyword research for a segment where the data set has tens of thousands of words or more, sometimes your Marketing Miner plan won't be enough, and then you have 2 options: <strong>a) upgrade your plan (recommended)<\/strong> or <strong>b) clean the data before loading it into Miner<\/strong> and throw out groups of words that are completely unrelated to the segment of the research. You can also cluster the data during cleaning in OpenRefine, although personally I wouldn't recommend it, because you may lose search volumes for some interesting words you \u201cmerged\u201d.<\/p>\n<h3><strong>Data cleaning<\/strong><\/h3> <p>The keywords you've collected also include lots of words that don't fit the target segment, and you need to get rid of them so they don't \u201cget in the way\u201d. The words to remove also include those with the same meaning but a different form due to inflection or misspelling.<\/p> <p> <\/p> <p>You can clean the data in <strong>OpenRefine<\/strong> and\/or <strong>Excel<\/strong>.<\/p> <p>Imagine the following situation: I find that the keywords contain patterns that don't belong in the research. Let's say the client offers their products only for women, so I find the word stems for man, men's, boy, child, gentleman and throw out all these terms. I use OpenRefine for this, but you can do this step in Excel too.<\/p> <p>There are terms I'm not sure at first whether I can remove. For example, if you were doing keyword research for a client that also runs TV and radio ads (banks, insurance companies and the like), and a certain name comes up often in the research (unknown to me and unrelated to the keywords), I won't remove that name or names but put them into some logical category. If it's a person, for example, they may have appeared in an ad or be a micro-influencer, so the word may come in handy for other campaigns or collaborations.<\/p> <p> <\/p> <p>I also need to mention a very important step in OpenRefine: the <strong>Cluster and Edit<\/strong> feature, which can group together words that are inflected, misspelled or have a different word order, and you can then merge them. I can't imagine doing keyword research without <strong>Marketing Miner<\/strong> and the <strong>cluster and edit feature<\/strong> in OpenRefine (of course it can be done other ways, but the output may not be relevant).<\/p> <p>After cluster and edit you'll end up with duplicates that you have to remove, but you mustn't forget to add up the search volumes for the individual terms.<\/p>\n[embed]https:\/\/youtu.be\/fJ5Q5hJMX70[\/embed]\n<h3><strong>Data classification and categorization<\/strong><\/h3> <p>You now have a cleaned data set (an Excel spreadsheet of keywords) that, on its own, tells the client who ordered the keyword research very little.<\/p> <p>These words need to be divided into categories, subcategories and other logical groups based on the patterns in them.<\/p> <p>For example, you find that words related to price come up often, so you filter them in OpenRefine and put them into a specific category (cheap, luxury, expensive, sale, second-hand, deal, discount, etc.).<\/p> <p>I try to find as many similar categories as possible, such as location, attributes, questions, purpose (which event or occasion), brand and so on.<\/p> <p>Marketing Miner also categorizes the data during data mining. This categorization is a very good aid, but I don't rely on it alone and look for as many logical groups as possible to put the keywords into.<\/p> <p>Only once you have the words assigned (categorized) can you finalize and evaluate the data (very easily, for example, with pivot tables).<\/p>\n[embed]https:\/\/youtu.be\/CYWiOIp4iKo[\/embed]\n<h3><strong>Finalizing and creating the final keyword research deliverable<\/strong><\/h3> <p>There are certain standards for what keyword research should look like. But every specialist has their own template they use.<\/p> <p>The research should be prepared so that even a layperson can find their way around it with a guide and apply the data, for example, to an SEO tactic for changes to a website or online store and to content creation.<\/p> <p style=\"text-align: center;\">I won't share specific research, but I'll teach you how to do it at the <a href=\"https:\/\/wooacademy.sk\/kurz\/analyza-klucovych-slov-workshop-bratislava\/\">keyword research training<\/a>.<\/p>\n<h3>Recommendations accompanying keyword research<\/h3> <p>Along with the keyword research, I also hand clients recommendations and a written evaluation of the deliverable. Usually it's an evaluation of the pivot table outputs and the content of the Excel file.<\/p>\n<h3>Applying keyword research and putting it into practice<\/h3> <p>What happens with the keyword research is up to the client. But I definitely recommend:<\/p> <ul> <li>create content on your website or online store, and also look at words with high search volume, low to medium competition and high CPC<\/li> <li>use the research when creating Google ads (PPC)<\/li> <li>look at your site structure and, based on search patterns, adjust categories, filters, site structure and navigation<\/li> <li>use the research for on-page and off-page SEO<\/li> <\/ul>\n<h2><strong>Conclusion<\/strong><\/h2> <ul> <li>I warmly recommend keyword research if you're serious about SEO.<\/li> <li>If you need help creating keyword research, don't hesitate to contact us at <a href=\"tel:+421940634491\">+421 940 634 491<\/a> or <a href=\"mailto:info@wooacademy.sk\">info@wooacademy.sk<\/a><\/li> <li>If you liked the article and found it useful, feel free to share it on Facebook or tell people you know about it.<\/li> <li>If you want to learn more about online marketing, choose one of our <a href=\"https:\/\/wooacademy.sk\/kurzy-a-skolenia\/\">courses and workshops in Bratislava.<\/a><\/li> <li>You can also order our <a href=\"https:\/\/wooacademy.sk\/marketingove-sluzby\/\">online marketing services<\/a>.<\/li> <\/ul> <p style=\"text-align: center;\"><strong>We look forward to seeing you at our courses or consultations.<\/strong><\/p>","_links":{"self":[{"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/posts\/30434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/comments?post=30434"}],"version-history":[{"count":0,"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/posts\/30434\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/media\/18971"}],"wp:attachment":[{"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/media?parent=30434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/categories?post=30434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wooacademy.sk\/en\/wp-json\/wp\/v2\/tags?post=30434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}