{"id":3110,"date":"2015-08-13T15:39:29","date_gmt":"2015-08-13T15:39:29","guid":{"rendered":"http:\/\/blackbeltwhitehat.com\/?p=3110"},"modified":"2015-08-13T15:39:29","modified_gmt":"2015-08-13T15:39:29","slug":"excel-for-seo","status":"publish","type":"post","link":"https:\/\/blackbeltwhitehat.com\/en\/2015\/08\/13\/excel-for-seo\/","title":{"rendered":"Excel for SEO"},"content":{"rendered":"<p>So I made this video, you&#8217;re welcome SEO community; you, are, welcome<\/p>\n<p><span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/93cyPimZDL4?version=3&#038;rel=1&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-GB&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>So I made this video, you&#8217;re welcome SEO community; you, are, welcome<\/p>\n","protected":false},"author":41980142,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_crdt_document":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1958],"tags":[25398,784152943],"class_list":["post-3110","post","type-post","status-publish","format-standard","hentry","category-seo","tag-excel","tag-seo"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Excel for SEO - Fitness &amp; MMA Blog - BlackBeltWhiteHat.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blackbeltwhitehat.com\/en\/2015\/08\/13\/excel-for-seo\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel for SEO - Fitness &amp; MMA Blog - BlackBeltWhiteHat.com\" \/>\n<meta property=\"og:description\" content=\"So I made this video, you&#8217;re welcome SEO community; you, are, welcome\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blackbeltwhitehat.com\/en\/2015\/08\/13\/excel-for-seo\/\" \/>\n<meta property=\"og:site_name\" content=\"Fitness &amp; MMA Blog - BlackBeltWhiteHat.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BlackBeltWhiteHat\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-13T15:39:29+00:00\" \/>\n<meta name=\"author\" content=\"Dave\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MMATraining1980\" \/>\n<meta name=\"twitter:site\" content=\"@MMATraining1980\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dave\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel for SEO - Fitness &amp; MMA Blog - BlackBeltWhiteHat.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blackbeltwhitehat.com\/en\/2015\/08\/13\/excel-for-seo\/","og_locale":"en_GB","og_type":"article","og_title":"Excel for SEO - Fitness &amp; MMA Blog - BlackBeltWhiteHat.com","og_description":"So I made this video, you&#8217;re welcome SEO community; you, are, welcome","og_url":"https:\/\/blackbeltwhitehat.com\/en\/2015\/08\/13\/excel-for-seo\/","og_site_name":"Fitness &amp; MMA Blog - BlackBeltWhiteHat.com","article_publisher":"https:\/\/www.facebook.com\/BlackBeltWhiteHat\/","article_published_time":"2015-08-13T15:39:29+00:00","author":"Dave","twitter_card":"summary_large_image","twitter_creator":"@MMATraining1980","twitter_site":"@MMATraining1980","twitter_misc":{"Written by":"Dave"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blackbeltwhitehat.com\/2015\/08\/13\/excel-for-seo\/#article","isPartOf":{"@id":"https:\/\/blackbeltwhitehat.com\/2015\/08\/13\/excel-for-seo\/"},"author":{"name":"Dave","@id":"https:\/\/blackbeltwhitehat.com\/en\/#\/schema\/person\/f009f75d478333ab9af4d98d1c2d03bd"},"headline":"Excel for SEO","datePublished":"2015-08-13T15:39:29+00:00","mainEntityOfPage":{"@id":"https:\/\/blackbeltwhitehat.com\/2015\/08\/13\/excel-for-seo\/"},"wordCount":20,"commentCount":0,"publisher":{"@id":"https:\/\/blackbeltwhitehat.com\/en\/#organization"},"keywords":["excel","seo"],"articleSection":["seo"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blackbeltwhitehat.com\/2015\/08\/13\/excel-for-seo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blackbeltwhitehat.com\/2015\/08\/13\/excel-for-seo\/","url":"https:\/\/blackbeltwhitehat.com\/2015\/08\/13\/excel-for-seo\/","name":"Excel for SEO - Fitness &amp; MMA Blog - BlackBeltWhiteHat.com","isPartOf":{"@id":"https:\/\/blackbeltwhitehat.com\/en\/#website"},"datePublished":"2015-08-13T15:39:29+00:00","breadcrumb":{"@id":"https:\/\/blackbeltwhitehat.com\/2015\/08\/13\/excel-for-seo\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blackbeltwhitehat.com\/2015\/08\/13\/excel-for-seo\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blackbeltwhitehat.com\/2015\/08\/13\/excel-for-seo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blackbeltwhitehat.com\/"},{"@type":"ListItem","position":2,"name":"Excel for SEO"}]},{"@type":"WebSite","@id":"https:\/\/blackbeltwhitehat.com\/en\/#website","url":"https:\/\/blackbeltwhitehat.com\/en\/","name":"Fitness & MMA Blog - BlackBeltWhiteHat.com","description":"Fitness, MMA and Nutrition Blog UK","publisher":{"@id":"https:\/\/blackbeltwhitehat.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blackbeltwhitehat.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/blackbeltwhitehat.com\/en\/#organization","name":"Fitness & MMA Blog - BlackBeltWhiteHat.com","url":"https:\/\/blackbeltwhitehat.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/blackbeltwhitehat.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/blackbeltwhitehat.com\/wp-content\/uploads\/2019\/06\/cropped-mmabloglogodis-copy.png","contentUrl":"https:\/\/blackbeltwhitehat.com\/wp-content\/uploads\/2019\/06\/cropped-mmabloglogodis-copy.png","width":352,"height":352,"caption":"Fitness & MMA Blog - BlackBeltWhiteHat.com"},"image":{"@id":"https:\/\/blackbeltwhitehat.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/BlackBeltWhiteHat\/","https:\/\/x.com\/MMATraining1980"]},{"@type":"Person","@id":"https:\/\/blackbeltwhitehat.com\/en\/#\/schema\/person\/f009f75d478333ab9af4d98d1c2d03bd","name":"Dave","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/e84bb8dd328aa13877039998cc07d77b62f98c8100dba6c4acb436a41e2a08ac?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e84bb8dd328aa13877039998cc07d77b62f98c8100dba6c4acb436a41e2a08ac?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e84bb8dd328aa13877039998cc07d77b62f98c8100dba6c4acb436a41e2a08ac?s=96&d=identicon&r=g","caption":"Dave"},"description":"North Wales explorer","sameAs":["http:\/\/seoandmma.wordpress.com"],"url":"https:\/\/blackbeltwhitehat.com\/en\/author\/seoandmma\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2Sx3t-Oa","jetpack-related-posts":[{"id":2258,"url":"https:\/\/blackbeltwhitehat.com\/en\/2014\/10\/29\/seo-2014-link-building-video\/","url_meta":{"origin":3110,"position":0},"title":"SEO 2014 Link Building Video","author":"Dave","date":"October 29, 2014","format":false,"excerpt":"Some Link building ideas. White hat link building 2014 https:\/\/www.youtube.com\/watch?v=lnYU0Wu-L_Q","rel":"","context":"In &quot;link building&quot;","block_context":{"text":"link building","link":"https:\/\/blackbeltwhitehat.com\/en\/category\/link-building\/"},"img":{"alt_text":"SEO podcast","src":"https:\/\/i0.wp.com\/blackbeltwhitehat.com\/wp-content\/uploads\/2014\/10\/drewbioitunes.jpg?fit=600%2C600&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blackbeltwhitehat.com\/wp-content\/uploads\/2014\/10\/drewbioitunes.jpg?fit=600%2C600&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/blackbeltwhitehat.com\/wp-content\/uploads\/2014\/10\/drewbioitunes.jpg?fit=600%2C600&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":3310,"url":"https:\/\/blackbeltwhitehat.com\/en\/2015\/12\/30\/seo-december-2015-update\/","url_meta":{"origin":3110,"position":1},"title":"SEO December 2015 Update","author":"Dave","date":"December 30, 2015","format":false,"excerpt":"A summary of Josh Bachynski's video https:\/\/youtu.be\/vsn9kvCJyno \u00a0 To paraphrase\/summarise the video: Do you need canonicals for product variations? Canonicals 'fold' the product variations into one page. If the user searches for product variations, then the product variation needs its own page! My note: This is massive if taken literally.\u2026","rel":"","context":"In &quot;seo&quot;","block_context":{"text":"seo","link":"https:\/\/blackbeltwhitehat.com\/en\/category\/seo\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/blackbeltwhitehat.com\/wp-content\/uploads\/2015\/12\/silo-organization-chart.gif?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blackbeltwhitehat.com\/wp-content\/uploads\/2015\/12\/silo-organization-chart.gif?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/blackbeltwhitehat.com\/wp-content\/uploads\/2015\/12\/silo-organization-chart.gif?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":2264,"url":"https:\/\/blackbeltwhitehat.com\/en\/2014\/11\/04\/cool-slideshare-on-video-content-marketing\/","url_meta":{"origin":3110,"position":2},"title":"Cool SlideShare on Video Content Marketing","author":"Dave","date":"November 4, 2014","format":false,"excerpt":"Video Content & SEO Great bit of content (via slides, kind of ironically) from distilled: \u00a0","rel":"","context":"In &quot;seo&quot;","block_context":{"text":"seo","link":"https:\/\/blackbeltwhitehat.com\/en\/category\/seo\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2262,"url":"https:\/\/blackbeltwhitehat.com\/en\/2014\/11\/03\/allow-googlebot-access-to-your-css-and-javascript-files\/","url_meta":{"origin":3110,"position":3},"title":"Allow GoogleBot access to your CSS and Javascript files","author":"Dave","date":"November 3, 2014","format":false,"excerpt":"The official Google forum\/website has announced that if you do not allow the Googlebot to crawl your CSS and JS files, your rankings could be impacted. This basically means that if you are disallowing the Googlebot in your robots.txt file, you might be impacted. More info here: http:\/\/www.clickthrough-marketing.com\/seo-google-webmaster-guidelines-updated-says-dont-block-javascript-or-css\/","rel":"","context":"In &quot;seo&quot;","block_context":{"text":"seo","link":"https:\/\/blackbeltwhitehat.com\/en\/category\/seo\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4,"url":"https:\/\/blackbeltwhitehat.com\/en\/2012\/11\/08\/seo-and-mma-ebook-available-soon\/","url_meta":{"origin":3110,"position":4},"title":"SEO and MMA ebook available soon!","author":"Dave","date":"November 8, 2012","format":false,"excerpt":"Watch this space!","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":243,"url":"https:\/\/blackbeltwhitehat.com\/en\/2013\/03\/06\/changing-address-with-car-insurance\/","url_meta":{"origin":3110,"position":5},"title":"Changing Address with Hastings Direct Car Insurance","author":"Dave","date":"March 6, 2013","format":false,"excerpt":"","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"SEO blog picture of Captain picard from star trek ","src":"https:\/\/i0.wp.com\/blackbeltwhitehat.com\/wp-content\/uploads\/2013\/03\/whyohwhy.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/blackbeltwhitehat.com\/wp-content\/uploads\/2013\/03\/whyohwhy.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/blackbeltwhitehat.com\/wp-content\/uploads\/2013\/03\/whyohwhy.jpg?resize=525%2C300 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/posts\/3110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/users\/41980142"}],"replies":[{"embeddable":true,"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/comments?post=3110"}],"version-history":[{"count":1,"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/posts\/3110\/revisions"}],"predecessor-version":[{"id":3111,"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/posts\/3110\/revisions\/3111"}],"wp:attachment":[{"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/media?parent=3110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/categories?post=3110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blackbeltwhitehat.com\/en\/wp-json\/wp\/v2\/tags?post=3110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}