{"id":9083,"date":"2023-04-18T13:47:23","date_gmt":"2023-04-18T13:47:23","guid":{"rendered":"https:\/\/craighordlow.com\/index.php\/2023\/04\/18\/use-this-looker-studio-template-to-track-seo-performance\/"},"modified":"2023-04-18T13:47:23","modified_gmt":"2023-04-18T13:47:23","slug":"use-this-looker-studio-template-to-track-seo-performance","status":"publish","type":"post","link":"https:\/\/craighordlow.com\/index.php\/2023\/04\/18\/use-this-looker-studio-template-to-track-seo-performance\/","title":{"rendered":"Use this Looker Studio template to track SEO performance"},"content":{"rendered":"<p>For as long as I\u2019ve been in SEO, I\u2019ve envied my paid media colleagues\u2019 agility and performance tracking. <\/p>\n<p>SEOs typically have had to exercise patience and a lot of manual building to get actionable performance data.<\/p>\n<p>Inspired by a Looker Studio dashboard built by our paid media team, I rolled up my sleeves and constructed one for SEO.\u00a0<\/p>\n<p>The <a href=\"https:\/\/lookerstudio.google.com\/u\/0\/reporting\/55a2794e-f465-4d18-a567-f38bd43e4b6c\/page\/aktJD\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio dashboard<\/a> has been a game-changer for my team, and I\u2019d like to teach others how to build their own.<\/p>\n<p>This article will tackle the biggest insights and benefits of the report, along with the step-by-step process for building the dashboard.<\/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\/2023\/04\/18\/use-this-looker-studio-template-to-track-seo-performance\/#The_Looker_Studio_reports_biggest_insights\" >The Looker Studio report\u2019s biggest insights<\/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\/2023\/04\/18\/use-this-looker-studio-template-to-track-seo-performance\/#The_biggest_benefits_of_the_report\" >The biggest benefits of the report<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/04\/18\/use-this-looker-studio-template-to-track-seo-performance\/#How_to_build_the_report\" >How to build the report<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"The_Looker_Studio_reports_biggest_insights\"><\/span>The Looker Studio report\u2019s biggest insights <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Essentially, the report provides a clear live view of SEO traffic over time, with the ability to segment data (for instance, brand vs. non-brand). <\/p>\n<p>You can compare date ranges like month over month and year over year, build separate reports by geo (e.g., U.S. vs. international), etc.<\/p>\n<p>The biggest insights come from connecting SEO properties (channels, pages, etc.) to acquisition. <\/p>\n<p>What pages and content were useful?<\/p>\n<p>Where did traffic gains\/drops happen? <\/p>\n<p>What was the most common entry point for sign-ups?\u00a0<\/p>\n<p>You can also do a breakout looking at how SEO is compared to other marketing channels (paid and direct, but you can also split out things like PR if it lives separately).\u00a0<\/p>\n<p>It\u2019s a great way to assess where your traffic and conversions are coming from \u2013 and, with enough data,\u00a0 to evaluate where to dig deeper into optimizations and where you\u2019re primed to invest more.\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"The_biggest_benefits_of_the_report\"><\/span>The biggest benefits of the report<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>It\u2019s no news to SEOs that tracking the performance and impact of their efforts can produce a <a href=\"https:\/\/searchengineland.com\/explain-value-seo-proven-methods-395538\" target=\"_blank\" rel=\"noopener\">pretty murky narrative<\/a>.\u00a0<\/p>\n<p>The discipline relies more on the scientific method \u2013 hypothesize, test, measure, tweak \u2013 than other channels with tighter input\/output cycles.\u00a0<\/p>\n<p>In SEO, nobody knows what happens except for what the data and testing show you. That\u2019s why it\u2019s so important to have access to the right data.\u00a0<\/p>\n<p>This report lets you use and present data closest to the source of truth, which is incredibly useful in presenting to internal stakeholders and clients, checking as a touchpoint with your morning coffee, and helping dictate a longer-term strategy.<\/p>\n<p>Another benefit of using Looker instead of third-party tools is connecting directly with Google Analytics and Search Console data.<\/p>\n<p>I\u2019m not trying to shill for Google, but as a direct descendant from Google Data Studio, Looker plays very nicely with our Google data. It comes with a couple of big bonuses, too:\u00a0<\/p>\n<p>It\u2019s free.<\/p>\n<p>It\u2019s very easy to share with clients and teammates without any big log-in workarounds.\u00a0<\/p>\n<p>This means it\u2019s also easy to solicit feedback from SEO stakeholders \u2013 and act on it quickly.\u00a0<\/p>\n<p>And having a shared point of reference enables richer discussions and gives clients awareness and insight into what you\u2019re doing (which is often cited as a challenge in SEO).<\/p>\n<p>Maybe the biggest benefit: once the report is set up, automatically updating, and needs little more than occasional tweaks and optimizations, you and your clients will have more time to talk about strategy and ideas.<\/p>\n<p>Assuming you\u2019re convinced you should have your own version, let\u2019s learn how to set it up.<\/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=\"How_to_build_the_report\"><\/span>How to build the report<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>First, open <a href=\"https:\/\/lookerstudio.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio<\/a> and create a blank report.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Connect Search Console data:<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Find your site under <em>Sites<\/em>, and click <em>URL impression<\/em> &gt; <em>Web<\/em> to connect that data.<\/p>\n<p>To get a picture of traffic over time, click <em>Add a chart<\/em> &gt;<em> Time series<\/em>.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Under<em> Chart<\/em> &gt; <em>Setup<\/em>, go to <em>Dimensions<\/em> and select <em>Date (Year\/Month)<\/em>. Go to <em>Metrics<\/em> and select <em>URL clicks<\/em>.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Under <em>Default data range<\/em>,<em> <\/em>select <em>Custom<\/em> and hit this down arrow:<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>When a side-by-side monthly calendar pops up, hit this arrow and scroll to the bottom of the list to select <em>Advanced<\/em>.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Adjust your ranges by preference. For instance, to compare the last two months:<\/p>\n<p>Select <em>today<\/em>, then <em>minus<\/em>, and <em>2 months<\/em> for a start date.<\/p>\n<p>Select <em>today<\/em>, then <em>minus<\/em>, then <em>1 Month<\/em> for an end date.\u00a0<\/p>\n<p>(Keep in mind that Looker Studio allows you to set custom date ranges \u2013 both start and end \u2013 so play around and find out your favorite look-back windows.)<\/p>\n<p>Next, add a table underneath your graph to layer more nuance into your reporting.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Go to <em>Chart<\/em> &gt; <em>Setup<\/em>, and drag both <em>Query<\/em> and <em>Landing Page<\/em> from the <em>Data<\/em> column into <em>Dimensions<\/em>.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Under <em>Chart<\/em> &gt; <em>Setup<\/em> &gt; <em>Metrics<\/em>, go back to <em>Data<\/em> and drag <em>URL Clicks<\/em>, <em>Average<\/em> <em>Position<\/em>, <em>Impressions<\/em>, and <em>CTR<\/em>:<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>From there, you can adjust things like rows per page (under <em>Chart<\/em> &gt; <em>Setup<\/em>) or footer pagination (under <em>Chart<\/em> &gt; <em>Style<\/em>), etc.<\/p>\n<p>You can manually drag the chart to expand and contract it horizontally and vertically \u2013 everything is flexible.<\/p>\n<p>Now we can make things really interesting: let&#8217;s look at brand vs. non-brand metrics.<\/p>\n<p>Go to <em>Setup<\/em> &gt; <em>Filter<\/em> and <em>Add a filter<\/em>.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Name your filter &#8220;NB filter&#8221; and select <em>Exclude<\/em>, <em>Contains<\/em>, and whatever works with your brand name (in our case, \u201cjordan\u201d of Jordan Digital Marketing). Make sure to save.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>From here, you can apply the non-brand filter to any metric you like \u2013 traffic, clicks, events \u2013 to see performance over time.<\/p>\n<p>To see all traffic, simply click out of the non-brand filter. (Note that adding a brand filter is a great idea as well to see the effects of your branding efforts.) <\/p>\n<p>You can create dashboards for brand, non-brand, blended, side-by-side comparisons, etc.\u00a0<\/p>\n<p>Now let&#8217;s add an important control \u2013 date range.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Click on your table, and go to <em>Setup<\/em> &gt; <em>Comparison date range<\/em>:<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Add whatever date ranges you like, and the data will include a delta showing performance over time.<\/p>\n<p>If there&#8217;s data you&#8217;d like to highlight for a certain date range, you can pin those to the top of your report by clicking on<em> Add a Chart <\/em>&gt; <em>Scorecard<\/em>:<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Click whatever box you like, and drag it to the top of your chart.<\/p>\n<p><strong>Note<\/strong>: Whenever you open your report, your scorecard number will auto-fill for the date range you&#8217;ve selected as a control (although you can adjust that whenever you like).<\/p>\n<p>If you select custom date ranges, those are only good for the working session, while controls are the default view for everyone upon login.<\/p>\n<p>Pin scorecards for different metrics and select year-over-year comparison ranges, month-over-month, etc. Add non-brand filters to analyze non-brand trends if you prefer. The interface is beautifully flexible.<\/p>\n<p>I&#8217;d like to include another step: adding signups (or whatever you&#8217;re naming your key events) to your reporting.<\/p>\n<p>To do this, add Google Analytics as a data source by going to <em>Add data<\/em> &gt; <em>Google Analytics<\/em> (assuming you capture signup data in GA):<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p><strong>Note<\/strong>: Since everyone needs to name their own events in GA (in our case, we&#8217;re using \u201cgenerate_lead\u201d), you&#8217;ll need to cross-reference GA data to ensure you include the right metric on your report. This is a custom name, not an out-of-the-box metric like clicks or impressions.<\/p>\n<p>Find your custom metric in GA4 and write down what you named it.<\/p>\n<p>Go back to your report, and click <em>Data<\/em> &gt; <em>Event count<\/em> to pop a metric into your report:<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Now you need to tell Looker what actual event you&#8217;re tracking. <\/p>\n<p>Add a filter by clicking <em>Chart<\/em> &gt; <em>Setup<\/em> &gt; <em>Add<\/em> <em>a filter<\/em> &gt; <em>Create<\/em> <em>a filter<\/em> (blue box at the bottom of the column). This specifies the custom event you just looked up on GA and will auto-populate GA as the data source for your new filter.<\/p>\n<p>Choose <em>Include<\/em>\u00a0 &gt;\u00a0 <em>Event name<\/em>\u00a0 &gt;\u00a0 <em>Equal to (=)<\/em>, and type in your custom event name.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Go back to your report, and you should see a field with the exact number of events reflected for the same date range in GA4. (If not, double-check your event name.) <\/p>\n<p>Add another date range control with comparison ranges if you&#8217;d like to compare event performance over time.<\/p>\n<p>Now let&#8217;s check out the source of all of these events. Click on <em>Add a chart<\/em> &gt; <em>Pie<\/em>:<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Under <em>Setup<\/em>, select <em>Event count<\/em> for metric and <em>Session default channel grouping<\/em>:\u00a0<\/p>\n<p>This should give you a pie chart showing a source breakdown for all events:<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Apply the custom event filter you created a couple of steps above, and your pie chart should show the custom events driven by each channel.<\/p>\n<p>From there, you can create a regular chart and add dimensions like page path to see journeys to conversion. For instance, this will show how many people visiting your blog eventually convert for a given time range.<\/p>\n<p>By now, you should have the idea: you can slice and dice, compare date ranges, add layers of nuance, segment by brand and non-brand, etc. And each person on the account can do the same thing \u2013 and interact with the reporting as they wish.<\/p>\n<p>What I <strong>haven&#8217;t<\/strong><em> <\/em>shown is something I&#8217;m happy to leave up to you and your brand: how to gussy up the visuals of the report using colors, labels, etc. I like our report&#8217;s looks, but I won&#8217;t presume you&#8217;re here for my design skills.<\/p>\n<p>My final advice: get in, get familiar, play around, and workshop your output with other stakeholders to see what other insights you can come up with. Happy reporting!<\/p>\n<p>The post <a href=\"https:\/\/searchengineland.com\/looker-studio-template-track-seo-performance-395692\" target=\"_blank\" rel=\"noopener\">Use this Looker Studio template to track SEO performance<\/a> appeared first on <a href=\"https:\/\/searchengineland.com\/\" target=\"_blank\" rel=\"noopener\">Search Engine Land<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>For as long as I\u2019ve been in SEO, I\u2019ve envied my paid media colleagues\u2019 agility and performance tracking. SEOs typically have had to exercise patience and a lot of manual building to get actionable performance data. Inspired by a Looker Studio dashboard built by our paid media team, I rolled up my sleeves and constructed one for SEO.\u00a0 The Looker Studio dashboard has been a game-changer for my team, and I\u2019d like to teach others how to build their own. This article will tackle the biggest [&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-9083","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\/9083","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=9083"}],"version-history":[{"count":0,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts\/9083\/revisions"}],"wp:attachment":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/media?parent=9083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/categories?post=9083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/tags?post=9083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}