{"id":7849,"date":"2023-07-18T10:08:12","date_gmt":"2023-07-18T10:08:12","guid":{"rendered":"https:\/\/afreeurl.com\/?p=7849"},"modified":"2023-07-18T10:08:13","modified_gmt":"2023-07-18T10:08:13","slug":"6-dos-and-donts-for-search-marketers","status":"publish","type":"post","link":"https:\/\/afreeurl.com\/?p=7849","title":{"rendered":"6 Dos and Don&#8217;ts for Search Marketers"},"content":{"rendered":"<p><\/p>\n<p>You&#8217;ve probably used Looker Studio (formerly Google Data Studio) to create reports for stakeholders or clients. <\/p>\n<p>I recently had the pleasure of seeing SearchLab&#8217;s Greg Gifford on &#8220;Freddy Krueger&#8217;s Guide to Good Scary Reporting.&#8221;  He discussed ways to improve Looker Studio reports to make them more useful for clients. <\/p>\n<p>Below are the key learnings from Gifford&#8217;s session in the form of dos and don&#8217;ts, along with some examples of data visualizations that search marketers will find most useful.<\/p>\n<h2 class=\"wp-block-heading\" id=\"h-1-don-t-enter-data-into-a-text-box-manually\">1. Do not enter data into a text box manually<\/h2>\n<p>Work smarter, not harder.  Set up a data source for the platform to pull data instantly.<\/p>\n<p>You can connect it to a specific Google Ads account and report metrics directly from there. <\/p>\n<p>There are many plugins built and supported by Looker Studio. <\/p>\n<p>However, if you want to connect a platform that isn&#8217;t on this list, you can do so using a third-party data integrator like Supermetrics or Funnel.io.<\/p>\n<p>You can export data to a Google Spreadsheet and bring it into Looker Studio that way.<\/p>\n<h2 class=\"wp-block-heading\" id=\"h-2-don-t-include-metrics-without-comparison\">2. Don&#8217;t include metrics without comparison<\/h2>\n<p>Customers pay you to tell them a story, not to spit out numbers that can already be found on their own. <\/p>\n<p>Why are clicks down compared to last month?  Why did the conversion rate drop by a whole percentage?  Last month there were 40 tracks.  How does it compare to last month or this time last year? <\/p>\n<p>Show them what trends you&#8217;re seeing in an easy-to-understand way. <\/p>\n<p>Here is an example.<\/p>\n<p>This is a way to demonstrate month-over-month (MoM) and year-over-year (YoY) changes for specific metrics. <\/p>\n<p>You can add them by clicking on the metric, navigating to the Settings section, and adding a comparison date range. <\/p>\n<p>Looker Studio will automatically calculate the percentage change and turn it green or red based on a positive or negative trend.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"428\" alt=\"Looker studio: changes over a period of time\" class=\"wp-image-429501\" srcset=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-changes-over-a-time-period.png.webp 1600w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-changes-over-a-time-period-600x161.png.webp 600w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-changes-over-a-time-period-800x214.png.webp 800w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-changes-over-a-time-period-200x54.png.webp 200w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-changes-over-a-time-period-768x205.png.webp 768w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-changes-over-a-time-period-1536x411.png 1536w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-changes-over-a-time-period-150x40.png.webp 150w\" data-lazy-sizes=\"(max-width: 1600px) 100vw, 1600px\" src=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-changes-over-a-time-period.png.webp\"\/><\/p>\n<p>This chart provides a visual representation of leads by month over time. <\/p>\n<p>You can easily see month-on-month (MMS) and year-on-year (YoY) changes.  Consider a chart like this for your report.<\/p>\n<h2 class=\"wp-block-heading\" id=\"h-3-don-t-give-them-metrics-that-don-t-tell-them-the-whole-story\">3. Don&#8217;t give them metrics that don&#8217;t tell them the whole story<\/h2>\n<p>Time on site is a commonly reported metric.  It is usually assumed that the more time a user spends on the website, the better. <\/p>\n<p>Gifford challenged that mindset.  Could spending more time on your website mean that people can&#8217;t find what they really need? <\/p>\n<p>If they come to your website, find your contact form, fill out their information, and leave within 45 seconds, that&#8217;s actually a good thing. <\/p>\n<p>As long as they convert, you should be happy (and the faster they convert, the better). <\/p>\n<p>Challenge yourself to choose metrics to report that will give you a more accurate picture of what&#8217;s going on.<\/p>\n<p class=\"inline-form-text text-center mb-0\">Get the daily search newsletter marketers trust.<\/p>\n<p>So now you know what <strong>no<\/strong> do.  Let&#8217;s talk about what to do with your Looker Studio reports.<\/p>\n<h2 class=\"wp-block-heading\" id=\"h-4-do-provide-an-executive-summary-list-of-work-completed-and-list-of-next-steps\">4. Provide an executive summary, a list of work done, and a list of next steps<\/h2>\n<p>This is undoubtedly the most important part of the report. <\/p>\n<p>This should serve as a fact sheet so the client has a place to quickly refer to the most important ideas from this past month. <\/p>\n<p>Everything else in the report is complementary and helps provide additional color to the trends and insights you&#8217;ve provided in your executive summary. <\/p>\n<p>As you think about crafting your executive summaries, ask yourself, &#8220;So what?&#8221; <\/p>\n<p>My client saw 40 leads this month, so what?  Traffic increased by 25% month over month, so what? <\/p>\n<p>Use the executive summary to tell a story to your client and give them the <strong>Because<\/strong>. <\/p>\n<p>Tell them how your traffic increased 25% month over month because the unbranded campaign you restructured performed efficiently and generated 80% of your total leads for the month. <\/p>\n<p>Also, now that you&#8217;ve seen how well your campaign restructuring is working, the next step is to restructure another campaign to further improve performance in the same way. <\/p>\n<p>Boom! <\/p>\n<p>Now you&#8217;ve told your client what happened, why it happened, and what you plan to do next as a result. <\/p>\n<p>See an example executive summary template below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1587\" height=\"1600\" alt=\"Looker studio - executive summary\" class=\"wp-image-429502\" srcset=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary.png.webp 1587w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary-335x338.png.webp 335w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary-595x600.png.webp 595w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary-112x113.png.webp 112w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary-768x774.png.webp 768w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary-1524x1536.png 1524w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary-95x95.png.webp 95w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary-96x96.png.webp 96w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary-150x151.png.webp 150w\" data-lazy-sizes=\"(max-width: 1587px) 100vw, 1587px\" src=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-executive-summary.png.webp\"\/><\/p>\n<h2 class=\"wp-block-heading\" id=\"h-5-do-give-a-visual-representation-of-where-you-are-trending-toward-your-key-performance-indicators-kpis\">5. Give a visual representation of the trend towards your key performance indicators (KPIs)<\/h2>\n<p>It is imperative to align KPIs with your client before creating a report. <\/p>\n<p>If you don&#8217;t have a goal you&#8217;re trying to achieve, how can you prove your value to a client? <\/p>\n<p>Think of it this way:<\/p>\n<p>Put yourself in the customer&#8217;s shoes.  Which one sounds better to you? <\/p>\n<p>&#8220;We generated 40 leads in July.&#8221; <\/p>\n<p>or<\/p>\n<p>&#8220;We generated 40 leads in July, which is double our goal of 20.&#8221; <\/p>\n<p>We bundle all of this into your Looker Studio report. <\/p>\n<p>Show your client that you&#8217;ve exceeded your KPIs, don&#8217;t just tell them. <\/p>\n<p>Below is an example of how to view your KPI progress.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"868\" height=\"626\" alt=\"Looker studio - Trending KPI\" class=\"wp-image-429503\" srcset=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-KPI-trendsa.png.webp 868w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-KPI-trendsa-469x338.png.webp 469w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-KPI-trendsa-800x577.png.webp 800w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-KPI-trendsa-157x113.png.webp 157w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-KPI-trendsa-768x554.png.webp 768w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-KPI-trendsa-150x108.png.webp 150w\" data-lazy-sizes=\"(max-width: 868px) 100vw, 868px\" src=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-KPI-trendsa.png.webp\"\/><\/p>\n<p>The blue bar shows the number of clicks generated in a given time period. <\/p>\n<p>The line shows the click KPI for the given time period. <\/p>\n<p>The customer can now easily see that you have exceeded the target. <\/p>\n<h2 class=\"wp-block-heading\" id=\"h-6-do-pull-together-data-that-will-answer-your-clients-questions\">6. Gather data that answers your customers&#8217; questions<\/h2>\n<p>Think about formatting each chart as if you were answering a customer&#8217;s question, Gifford suggested. <\/p>\n<p>What actions did people take on our website? <\/p>\n<p>Show them data that describes how many phone calls, contact form submissions, visit times, etc.  that they have received from your marketing efforts. <\/p>\n<p>Here&#8217;s an example of how to break down conversions by type for a customer:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1600\" height=\"607\" alt=\"Looker studio - conversion by type\" class=\"wp-image-429504\" srcset=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-conversion-by-type.png.webp 1600w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-conversion-by-type-600x228.png.webp 600w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-conversion-by-type-800x304.png.webp 800w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-conversion-by-type-200x76.png.webp 200w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-conversion-by-type-768x291.png.webp 768w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-conversion-by-type-1536x583.png 1536w,https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-conversion-by-type-150x57.png.webp 150w\" data-lazy-sizes=\"(max-width: 1600px) 100vw, 1600px\" src=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2023\/07\/Looker-studio-conversion-by-type.png.webp\"\/><\/p>\n<p>Another common question we get is, &#8220;So you generated 30 leads for us, but what does that mean for my business?&#8221; <\/p>\n<p>Connecting contact data to sales is powerful for reporting. <\/p>\n<p>Whether it&#8217;s actual revenue (via a CRM import) or estimated revenue (based on average order value), you can unlock additional revenue-based metrics in your reports, such as ROI <\/p>\n<p>You can begin to answer their question by letting them know what percentage of those leads converted to sales, total revenue, and ROI for a given month. <\/p>\n<h2 class=\"wp-block-heading\" id=\"h-creating-useful-client-reports-with-looker-studio\">Creating useful customer reports with Looker Studio<\/h2>\n<p>Looker Studio is an incredibly powerful reporting tool that reduces the time spent manually typing metrics.<\/p>\n<p>It lets you instantly pull together powerful data visualizations to help tell your digital marketing story. <\/p>\n<p>Now, you have a list of dos and don&#8217;ts to help you get started on your way to more valuable customer reports.<\/p>\n<p>The views expressed in this article are those of the guest author and not necessarily Search Engine Land.  Staff authors are listed here.<\/p>\n<p>[ad_2]<br \/>\n<br \/><a href=\"https:\/\/searchengineland.com\/looker-studio-reporting-dos-donts-429498\" target=\"_blank\" rel=\"noopener\">Source link <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You&#8217;ve probably used Looker Studio (formerly Google Data Studio) to create reports for stakeholders or clients. I recently had the pleasure of seeing SearchLab&#8217;s Greg Gifford on &#8220;Freddy Krueger&#8217;s Guide to Good Scary Reporting.&#8221; He discussed ways to improve Looker Studio reports to make them more useful for clients. Below are the key learnings from Gifford&#8217;s session in the form of dos and don&#8217;ts, along with some examples of data visualizations that search marketers will&#8230; <\/p>\n","protected":false},"author":1,"featured_media":7850,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7849","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-seo-news"],"_links":{"self":[{"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/posts\/7849","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7849"}],"version-history":[{"count":1,"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/posts\/7849\/revisions"}],"predecessor-version":[{"id":7851,"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/posts\/7849\/revisions\/7851"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=\/wp\/v2\/media\/7850"}],"wp:attachment":[{"href":"https:\/\/afreeurl.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/afreeurl.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}