{"id":4241,"date":"2022-06-27T19:25:42","date_gmt":"2022-06-27T19:25:42","guid":{"rendered":"https:\/\/www.gemmafontane.com\/uncategorized\/data-seo-project\/"},"modified":"2022-06-27T19:25:43","modified_gmt":"2022-06-27T19:25:43","slug":"data-seo-project","status":"publish","type":"post","link":"https:\/\/www.gemmafontane.com\/en\/seo-strategies\/data-seo-project\/","title":{"rendered":"Data SEO &#8211; Project"},"content":{"rendered":"<p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-1\"><h2>From keyword to business<\/h2>\n<\/div><div class=\"fusion-text fusion-text-2\"><p><strong>Keywords<\/strong> are the different words or concepts that users search for in Internet search engines such as Google, when they have a need, either to solve a doubt, look for more information, buy or acquire a product or service&#8230;<\/p>\n<\/div><div class=\"fusion-text fusion-text-3\"><h2>How do you know if it is a good idea to start a project based on a keyword study?<\/h2>\n<\/div><div class=\"fusion-text fusion-text-4\"><p><strong>Keywords<\/strong> are the different words or concepts that users search for in Internet search engines such as Google, when they have a need, either to solve a question, look for more information, buy or purchase a product or service&#8230;<\/p>\n<p>There are different tools, free or paid, such as <span style=\"font-weight: 400;\"><a href=\"https:\/\/ads.google.com\/intl\/es_es\/home\/\" target=\"_blank\" rel=\"noopener\">Google Ads<\/a> o <a href=\"https:\/\/www.semrush.com\" target=\"_blank\" rel=\"noopener\">Semrush<\/a><\/span>, which allow us to perform <a href=\"https:\/\/www.gemmafontane.com\/en\/seo-strategies\/how-to-do-a-keyword-research\/\">keyword research<\/a>. Through these studies, carried out with different tools, we can know the search volumes of different keywords and know approximately, from different indicators, what competition they have and what is their trend over time, among others.<\/p>\n<p>In the business environment this can offer us different indications <strong>about our products or services<\/strong>, and those of the competition, among others. And it can allow us to draw conclusions that directly and substantially affect our business at a digital level, sometimes even leading us to create new ones.<\/p>\n<p><br style=\"font-weight: 400;\" \/><br style=\"font-weight: 400;\" \/><\/p>\n<\/div><div class=\"fusion-text fusion-text-5\"><h2>Case study: denadal.cat<\/h2>\n<p>Next, we will define how we analyzed, through a keyword study, the feasibility of creating <a href=\"https:\/\/denadal.cat\" target=\"_blank\" rel=\"noopener\">denadal.cat<\/a>&#8216;s own project.<\/p>\n<\/div><div class=\"fusion-image-element in-legacy-container\" style=\"--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><span class=\" fusion-imageframe imageframe-none imageframe-1 hover-type-none\"><img decoding=\"async\" width=\"679\" height=\"622\" alt=\"ecommerce denadal\" title=\"ecommerce denadal\" src=\"https:\/\/www.gemmafontane.com\/wp-content\/uploads\/2022\/02\/ecommerce-denadal.png\" class=\"img-responsive wp-image-4101\" srcset=\"https:\/\/www.gemmafontane.com\/wp-content\/uploads\/2022\/02\/ecommerce-denadal-200x183.png 200w, https:\/\/www.gemmafontane.com\/wp-content\/uploads\/2022\/02\/ecommerce-denadal-400x366.png 400w, https:\/\/www.gemmafontane.com\/wp-content\/uploads\/2022\/02\/ecommerce-denadal-600x550.png 600w, https:\/\/www.gemmafontane.com\/wp-content\/uploads\/2022\/02\/ecommerce-denadal.png 679w\" sizes=\"(max-width: 1025px) 100vw, 679px\" \/><\/span><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-2 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-6\"><h2>1.Objectives<\/h2>\n<\/div><div class=\"fusion-text fusion-text-7\"><p>The first step before starting a digital project is to be clear about the main objectives: Why do we want to sell those products? How will we differentiate ourselves from the competition? Do we have the necessary resources?<\/p>\n<p>In our case, the goal was to become the reference website for selling <strong>Catalan Christmas products<\/strong>, with a special focus on user acquisition through search engines (Google).<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-3 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-8\"><h2>2.Analysis metrics<\/h2>\n<\/div><div class=\"fusion-text fusion-text-9\"><h3>What metrics did we consider to drive the project?<\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Volume of searches for the last two years during a specific period.<\/strong>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\">In this case, from September to December approximately\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Source: Google Trends \/ Keyword Planner de Google Ads \/ Semrush<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Trend<\/strong>: are there more users searching for these concepts every year or less?\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Source: Google \u00a0Trends \/ Keyword Planner de Google Ads \/ Semrush<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Keyword clustering<\/strong>: transactional vs informational\n<ul>\n<li aria-level=\"1\">Grouping of keywords focused on generating transactions (buy + product, sale + product&#8230;). The user wants to generate an action (conversion).<\/li>\n<li aria-level=\"1\">Grouping of keywords focused on providing additional information (history, tradition, origin, when +, how +, which +&#8230;). The user wants the answer to a specific question.<\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Competition\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Total number of pages indexed in Google: approximates how much content we should generate in order to be competitive.\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Type of content: text, images, videos&#8230;\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Source \/ tools: Google \/ Screaming Frog<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Frequency of publication: allows us to know the resources we should allocate to overcome them.\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Source \/ tools: Google<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Total organic visits (Google): allows us to know the total number of visits that you have through Google in an approximate way.\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Source \/ tools: Semrush<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Total keywords in TOP 3-5 positions: allows us to know what competitors we have based on the product and how they are.\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Source \/ tools: Semrush<\/span><\/li>\n<\/ul>\n<\/li>\n<li>Keywords: analysis of what are the main terms that rank in the Google index.\n<ul>\n<li><span style=\"font-weight: 400;\">Source \/ tools: Semrush<\/span><\/li>\n<\/ul>\n<\/li>\n<li>Technical analysis: know how the website is at a technical level (indexing, usability, accessibility&#8230;).\n<ul>\n<li><span style=\"font-weight: 400;\">Source \/ tools:: Semrush \/ Screaming Frog \/ &#8230;<\/span><\/li>\n<\/ul>\n<\/li>\n<li>Links: quantitative and qualitative analysis of the external links of your website.\n<ul>\n<li>It allows us to know who is talking about them, to know potential audiences&#8230;\n<ul>\n<li><span style=\"font-weight: 400;\">Source \/ tools: Semrush <\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-4 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-3 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-10\"><h2>3.Indicators to measure viability<\/h2>\n<\/div><div class=\"fusion-text fusion-text-11\"><h3>How was the feasibility of the project measured by the data?<\/h3>\n<p>How are the metrics and study data interpreted?<\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Keyword research<\/strong>: study on the concepts of interest, search volume, competition and trend.\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Source: Keyword Planner de Google Ads \/ Semrush<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Competitor analysis:<\/strong> study of the main online competitors of the products.\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\"><span style=\"font-weight: 400;\">Source: Keyword Planner de Google Ads \/ Semrush<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><strong>Classification of results based on<\/strong>: previous studies were classified according to different factors.<\/li>\n<\/ol>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Languages: Catalan, Spanish and English.<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Typology of words (transactional vs. informational)\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Filters: Buy \/ Price \/ Sale \/ Online<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Filters: Song \/ History \/ Tradition<\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Typology of products (trees, tions, caganers).<\/li>\n<\/ul>\n<p><strong>4.ROI calculation: <\/strong>to calculate if the project was viable, the ROI of the main keywords was calculated based on different metrics (Google CTR and conversion rate, together with previous studies of competition and keywords).<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\">Include different scenarios\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\">Source: Average CTR top 5 positions: 22.5%.<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"3\">Source: Average % ecommerce conversion: 2%*.\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"3\">Depending on the volume of competition, you can vary<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>Bibliography<\/strong><\/p>\n<ul>\n<li>Sources CTR positions:\n<ul>\n<li><a href=\"https:\/\/ignitevisibility.com\/google-ctr-by-ranking-position\/\" target=\"_blank\" rel=\"noopener\">https:\/\/ignitevisibility.com\/google-ctr-by-ranking-position\/<\/a><\/li>\n<li>Reasons for high CTRs:\u00a0<a href=\"https:\/\/backlinko.com\/google-ctr-stats\" target=\"_blank\" rel=\"noopener\">https:\/\/backlinko.com\/google-ctr-stats<\/a><\/li>\n<li>Own data<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Source percentage of conversions:\n<ul>\n<li>Own data<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><a href=\"https:\/\/www.qualitymarketingcontents.com\/tasa-de-conversion-media-en-un-ecommerce\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/www.qualitymarketingcontents.com\/tasa-de-conversion-media-en-un-ecommerce\/<\/span><\/a><span style=\"font-weight: 400;\">\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><a href=\"https:\/\/marketing4ecommerce.net\/tasa-de-conversion-en-ecommerce-del-sueno-a-la-realidad\/\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/marketing4ecommerce.net\/tasa-de-conversion-en-ecommerce-del-sueno-a-la-realidad\/<\/span><\/a><span style=\"font-weight: 400;\">\u00a0<\/span><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/datastudio.google.com\/u\/0\/reporting\/d588991b-42b1-4a8d-a349-b9e6dd213672\/page\/LuBV\" target=\"_blank\" rel=\"noopener\">Search Intent keyword classifier<\/a>.<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Others: External factors to take into account in digital projects\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Suppliers<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Logistics and distribution<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Web security<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Technical issues<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">&#8230;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div><div class=\"fusion-text fusion-text-12\"><h3>What indicators have been taken into account to monitor the project in real time?<\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Keyword position in the Google index:\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Relationship time of publication vs. time of indexing.<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Specific position of the keyword in the Google index.<\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Pages with more traffic<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Conversions\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Total conversions per country<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Percentage of conversions per country<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div>\n<p>Other considerations:<\/p>\n<p>&#8211; Filter by page and keyword.<br \/>\n&#8211; Filter by page type (<a href=\"https:\/\/lazarinastoy.com\/ultimate-guide-to-custom-dimensions-in-data-studio-for-marketing-analysts\/\" target=\"_blank\" rel=\"noopener\">more information<\/a>).<br \/>\n. Filter by conversion type<br \/>\n&#8211; Filter by ROI \/ profit<\/p>\n<\/div>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-5 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-4 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"--awb-bg-size:cover;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-column-wrapper-legacy\"><div class=\"fusion-text fusion-text-13\"><h2><span style=\"font-weight: 400;\">4.success factors of the project result<\/span><\/h2>\n<h3>Success factors:<\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Long-term data analysis: data history<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Real-time data analysis: real-time performance tracking<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Competitive analysis and detailed keyword study<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\">Industry expertise<\/li>\n<\/ul>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":4195,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50],"tags":[],"class_list":["post-4241","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-seo-strategies"],"_links":{"self":[{"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/posts\/4241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/comments?post=4241"}],"version-history":[{"count":2,"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/posts\/4241\/revisions"}],"predecessor-version":[{"id":4243,"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/posts\/4241\/revisions\/4243"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/media\/4195"}],"wp:attachment":[{"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/media?parent=4241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/categories?post=4241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gemmafontane.com\/en\/wp-json\/wp\/v2\/tags?post=4241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}