{"id":7229,"date":"2022-12-07T20:55:34","date_gmt":"2022-12-07T20:55:34","guid":{"rendered":"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/"},"modified":"2022-12-07T20:55:34","modified_gmt":"2022-12-07T20:55:34","slug":"3-seo-tools-to-build-for-your-clients-in-looker-studio","status":"publish","type":"post","link":"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/","title":{"rendered":"3 SEO tools to build for your clients in Looker Studio"},"content":{"rendered":"<p>With the wide variety of clients out there, you\u2019re bound to run into the occasional DIY marketer. These marketers prefer that you teach them how to be self-sufficient rather than rely on you for every little question.<\/p>\n<p>These clients can be a blessing but can also be dangerous. The challenging aspect of client management is finding the balance between empowering them to get the data they want without feeling like they don\u2019t need you.<\/p>\n<p>That\u2019s where Google\u2019s <a href=\"https:\/\/searchengineland.com\/google-looker-studio-258871\" target=\"_blank\" rel=\"noopener\">Looker Studio<\/a> tools come into play.<\/p>\n<p>Looker Studio is typically used for general reporting. The real beauty of Looker Studio is that it can be used for so much more.\u00a0<\/p>\n<p>By creating tools for clients, you enable them to do the actual research it takes to accomplish SEO while still providing that much-needed maintenance and guidance that comes with experience.\u00a0<\/p>\n<p>This article illustrates free dashboard templates you can use with your clients.\u00a0<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#How_to_change_the_branding\" >How to change the branding<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#1_Technical_SEO_auditing\" >1. Technical SEO auditing<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#How_to_copy_the_dashboard\" >How to copy the dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#How_to_set_up_the_technical_SEO_tracker_tool\" >How to set up the technical SEO tracker tool<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#2_Keyword_research\" >2. Keyword research<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#Step_One_Setting_up_your_source_data\" >Step One: Setting up your source data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#Step_Two_Copy_the_dashboard\" >Step Two: Copy the dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#Important_features_of_this_Looker_Studio_tool\" >Important features of this Looker Studio tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#Boolean_Buttons\" >Boolean Buttons<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#Custom_search_box\" >Custom search box<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#Intent_dropdown\" >Intent dropdown<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#Funnel\" >Funnel<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#3_Link_building_tracking_tool\" >3. Link building tracking tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/craighordlow.com\/index.php\/2022\/12\/07\/3-seo-tools-to-build-for-your-clients-in-looker-studio\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"How_to_change_the_branding\"><\/span>How to change the branding<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we dive into the specifics, you may want to update the branding and logo of your dashboard. This process could not be easier.<\/p>\n<p>Right-click on your logo, and you will see a menu appear. Near the bottom, select \u201cExtract theme from image.\u201d You will then be presented with three different color scheme options. Select whichever one you feel best represents your brand.<\/p>\n<p>This will automatically change most of the colors and get you most of the way to the finish line of designing in your Looker Studio tool. However, there may still be a few charts or texts you\u2019ll need to update.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"1_Technical_SEO_auditing\"><\/span>1. Technical SEO auditing<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tracking technical SEO efforts can be difficult to visualize. Sure, you can track it in a spreadsheet, but that isn\u2019t client-friendly.\u00a0<\/p>\n<p>For years, SEOs have attempted to make dashboard trackers to help show improvements in site health over time.\u00a0<\/p>\n<p>Luckily, our friends at Screaming Frog have finally cracked the case of the perfect technical SEO dashboard. The best part? The template is free. You can see it <a href=\"https:\/\/datastudio.google.com\/u\/0\/reporting\/de03a6cf-8503-494c-98ea-b6d2162424a8\/page\/rJxg\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_copy_the_dashboard\"><\/span>How to copy the dashboard<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>To copy the dashboard:<\/p>\n<p>Click on the three dots in the top rightSelect make a copySelect your data source (don\u2019t worry, you can update later)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"How_to_set_up_the_technical_SEO_tracker_tool\"><\/span>How to set up the technical SEO tracker tool<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Screaming Frog has published a helpful guide on setting up this Looker Studio tool. What they will walk you through includes:<\/p>\n<p>Setting up a scheduled crawlConfiguring the export to a Google SheetConnecting that Google Sheet to the Looker Studio dashboard<\/p>\n<p>You can find the full tutorial <a href=\"https:\/\/www.screamingfrog.co.uk\/how-to-automate-crawl-reports-in-data-studio\/\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<p><!-- START INLINE FORM --><\/p>\n<div class=\"nl-inline-form border py-2 px-1 my-2\">\n<div class=\"row align-items-center\">\n<div class=\"col-12 col-lg-3 col-xl-4 pe-md-0 pb-2 pb-lg-0\">\n<p class=\"inline-form-text text-center mb-0\">Get the daily newsletter search marketers rely on.<\/p>\n<\/div>\n<div class=\"col-12 col-lg-7 col-xl-6  pe-lg-0\">\n<div class=\"form-nl-inline\">\n<div class=\"row g-0\">\n<div class=\"form-group col-12 col-lg-8 mb-0\"><\/div>\n<div class=\"col-12 col-lg-4 col-xl-4 mb-0\">\n<div class=\"d-none\">\n<p>Processing\u2026Please wait.<\/p>\n<\/div>\n<p>\t\t\t\t\t\t\t<button class=\"btn btn-dark inlineButton w-100 rounded-0 font-weight-bold\">SUBSCRIBE<\/button>\n\t\t\t\t\t\t<\/p><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"col-12 col-lg-2 col-xl-2 ps-1\">\n<p class=\"text-center mb-0\"><a class=\"nl-terms\" href=\"https:\/\/searchengineland.com\/termsofuse\" target=\"_blank\" rel=\"noopener noreferrer\">See terms.<\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><!-- END INLINE FORM --><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Keyword_research\"><\/span>2. Keyword research<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The presentation of keyword research takes many forms. Most recognizable is the simple spreadsheet. Some people create keyword maps for each page or topic, while others with smaller clients have a short list of keywords.<\/p>\n<p>However, Looker Studio can be a powerful analysis tool for larger sites with tens of thousands or millions of keywords.<\/p>\n<p>If you are working with millions of keywords, do not use Google Sheets like this example. I recommend using BigQuery to handle your keywords.<\/p>\n<p>Here&#8217;s the <a href=\"https:\/\/datastudio.google.com\/reporting\/9808f894-75b8-4f0e-9764-82def1b4c144\" target=\"_blank\" rel=\"noopener noreferrer\">link to the dashboard<\/a>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_One_Setting_up_your_source_data\"><\/span>Step One: Setting up your source data<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The first step involves importing your keyword research into a Google Sheet. To use the free template I created, you will need to include the following dimensions and metrics in your Google Sheet:<\/p>\n<p>KeywordPositionPrevious positionSearch VolumeKeyword DifficultyCPCURLKeyword Intents<\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1Xv841QivKm6-OY1kDO3crsmUUcvziEHmLAc-pOmMPFg\/edit\" target=\"_blank\" rel=\"noopener noreferrer\">Here&#8217;s the original data source<\/a> for the dashboard that you can use as an example. All data is from Semrush.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Step_Two_Copy_the_dashboard\"><\/span>Step Two: Copy the dashboard<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>As we learned in the previous dashboard, you&#8217;ll want to make a copy of this dashboard and connect your data source, whether it be Google Sheets or BigQuery.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Important_features_of_this_Looker_Studio_tool\"><\/span>Important features of this Looker Studio tool<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This tool has many unique features that can be used to help drive your on-page SEO strategy. Depending on your strategy, these features can be customized to display different types of data and categories.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Boolean_Buttons\"><\/span>Boolean Buttons<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The three buttons in this tool are based on custom boolean formulas, meaning they work on true\/false statements. Let&#8217;s take a look at one of them.<\/p>\n<p>We&#8217;re creating a function only to display long-tail queries that start with a question word in the formula above. This formula relies on regex, with two very important symbols:<\/p>\n<p><strong>The circumflex (^)<\/strong> is a regex function that essentially means, &#8220;if the keyword starts with this.&#8221;\u00a0<strong>The pipe (|) symbol <\/strong>is another regex function that means &#8220;or.&#8221;<\/p>\n<p>Using this formula, you can create any number of different kinds of checkboxes. I added a few keywords separated by pipes (|) to help display keywords in those categories for the SEO and PPC checkboxes.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Custom_search_box\"><\/span>Custom search box<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The custom search box is a pretty simple but powerful feature of this tool. Not only can it quickly help you narrow down your search to identify keyword opportunities, but it can also use the power of regex to customize your search.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Intent_dropdown\"><\/span>Intent dropdown<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The keyword intent dropdown can help you filter by the intent of each keyword within the search funnel. Pretty simple, right?<\/p>\n<p>Well, this filter can be easily swapped out by any dimension in Looker Studio. So if you want to swap it out for other keyword categories, this can be the perfect filter for you.\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Funnel\"><\/span>Funnel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>This funnel helps visualize the true search funnel by intent. When applying other filters in this tool, the funnel and metrics above automatically update with the intents.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Link_building_tracking_tool\"><\/span>3. Link building tracking tool<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Link building is one of the tensest topics SEOs like to avoid with clients. Links are challenging to earn and often the hardest thing to control.\u00a0<\/p>\n<p>The best way to earn trust with clients and stakeholders is through transparency. Instead of dodging the data around link building, hand over the keys and let them explore the data for themselves.<\/p>\n<p>This is one of the more straightforward Looker Studio tools we can create. You can pair any number of dimensions and metrics to help illustrate your point.\u00a0<\/p>\n<p><a href=\"https:\/\/datastudio.google.com\/u\/0\/reporting\/db7ddfb2-a9b0-47e8-b71c-2c0b0594814d\/page\/zWInC\" target=\"_blank\" rel=\"noopener noreferrer\">Here is a link to the free template<\/a>.<\/p>\n<p>The supporting Google Sheet I&#8217;m using is a simple backlinks analytics report from SEMrush. However, you can use your own link-building tracker to feed the report. Just make sure you add the acquisition date for the date range.<\/p>\n<p>You can view the Google Sheet that&#8217;s feeding the tool <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1n3PrxBEeD2lK4RIifJfKVIxYjQeh6HyyYFyoM_MzMPE\/edit\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Looker Studio is one of the fastest reporting tools to stand up while still having some seriously robust features. The fact that it&#8217;s also free makes it an easy platform of choice.<\/p>\n<p>But that begs the question, why go through all that trouble for clients and other stakeholders?<\/p>\n<p>These tools help create a better sense of transparency, which can help improve trust. Thus, creating a better partnership between you and your stakeholders.\u00a0<\/p>\n<p>One of the most challenging parts of SEO isn&#8217;t the work itself but the communication of value. So from now on, think of new creative ways to demonstrate value to your clients, even if it&#8217;s just making a simple tool in Looker Studio.<\/p>\n<p>The post <a href=\"https:\/\/searchengineland.com\/looker-studio-build-seo-tools-382637\" target=\"_blank\" rel=\"noopener\">3 SEO tools to build for your clients in Looker Studio<\/a> appeared first on <a href=\"https:\/\/searchengineland.com\/\" target=\"_blank\" rel=\"noopener\">Search Engine Land<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>With the wide variety of clients out there, you\u2019re bound to run into the occasional DIY marketer. These marketers prefer that you teach them how to be self-sufficient rather than rely on you for every little question. These clients can be a blessing but can also be dangerous. The challenging aspect of client management is finding the balance between empowering them to get the data they want without feeling like they don\u2019t need you. That\u2019s where Google\u2019s Looker Studio tools come into play. Looker Studio is [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"h5ap_radio_sources":[],"cybocfi_hide_featured_image":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-7229","post","type-post","status-publish","format-standard","hentry","category-best-seo-blogs"],"featured_image_src":null,"featured_image_src_square":null,"author_info":{"display_name":false,"author_link":"https:\/\/craighordlow.com\/author\/"},"_links":{"self":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts\/7229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/comments?post=7229"}],"version-history":[{"count":0,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts\/7229\/revisions"}],"wp:attachment":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/media?parent=7229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/categories?post=7229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/tags?post=7229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}