{"id":2355,"date":"2024-05-15T10:29:07","date_gmt":"2024-05-15T08:29:07","guid":{"rendered":"https:\/\/wearekemb.com\/?p=2355"},"modified":"2025-03-03T17:27:06","modified_gmt":"2025-03-03T16:27:06","slug":"how-to-easily-track-okrs-in-google-sheets-us","status":"publish","type":"post","link":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/","title":{"rendered":"How to easily track OKRs in Google sheets using Supermetrics"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; custom_padding_last_edited=&#8221;on|tablet&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding_tablet=&#8221;30px||30px||true|false&#8221; custom_padding_phone=&#8221;30px||30px||true|false&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_row _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom 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\"><\/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:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#1_What_are_OKRs_and_why_are_they_important\" >1. What are OKRs and why are they important<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#2_How_to_automate_your_OKRs_using_Google_sheets\" >2. How to automate your OKRs using Google sheets<\/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:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#21_Setting_SMART_Goals\" >2.1\u00a0Setting SMART Goals<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#22_Where_do_you_get_your_data_from\" >2.2\u00a0Where do you get your data from?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#23_Write_your_import_using_Supermetrics_queries\" >2.3\u00a0Write your import using Supermetrics queries<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#24_Link_up_your_cells\" >2.4\u00a0Link up your cells<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#25_Set-up_an_automated_refresh_and_email\" >2.5\u00a0Set-up an automated refresh and email<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#3_How_to_build_a_OKR_dashboards\" >3. How to build a OKR dashboards<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#Getting_started\" >Getting started<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#32_Setting_your_Objectives_Key_Results\" >3.2 Setting your Objectives &amp; Key Results<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#33_Fetching_the_your_data\" >3.3 Fetching the your data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#Link_your_goals_your_actuals\" >Link your goals &amp; your actuals<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#35_Automate_your_weekly_refresh\" >3.5 Automate your weekly refresh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#36_End_of_Quarter_now_what\" >3.6 End of Quarter, now what?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#4_Rolling_out_OKRs_within_your_teams\" >4. Rolling out OKRs within your teams<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#Continuous_Improvements\" >Continuous Improvements<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>* This article was originally posted as a guestpost on the Supermetrics Blog.<\/p>\n<p>OKRs have been a means to put your company goals in an actionable framework that also interlinks the sub-goals of each department and each individual. We at kemb \u2013 a digital marketing agency, have been using OKRs since 2014 and are still highly convinced that they can help every company to not only perform better but also to increase their satisfaction as everyone is working towards the same goals while knowing how they contribute to it. Over time we implemented an infrastructure that helps us discuss our OKRs on a weekly basis without having to manually track all inputs. In this article we want to share our setup and provide you with the means to integrate OKRs seamlessly into your company workflow.<\/p>\n<p>OKRs are awesome! After reading this article you will be able to set up your OKR tracking in no time based on our template and Supermetrics toolset for Google Sheets or Excel.<\/p>\n<p><em><\/em><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; text_font_size_phone=&#8221;12px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"1_What_are_OKRs_and_why_are_they_important\"><\/span>1. What are OKRs and why are they important<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you are familiar with OKRs, you can skip this section and directly go to OKRs (objectives and key results) are a means of managing teams and companies. They have been introduced at Intel by Andy Grove based on management methods such as SMART goals and management by objectives (MBO). The topic got greater recognition when Google took over the concept in the late 90s. Finally John Doerr opened the topic to an even bigger audience with his book \u201cMeasure what matters\u201d which has been the base for most modern adaptations of OKRs currently in practice.<\/p>\n<p>They have been introduced at Intel by Andy Grove based on management methods such as SMART goals and management by objectives (MBO). The topic got greater recognition when Google took over the concept in the late 90s. Finally John Doerr opened the topic to an even bigger audience with his book \u201cMeasure what matters\u201d which has been the base for most modern adaptations of OKRs currently in practice.<\/p>\n<p>OKRs can be seen as a method to break down and align goals for a certain time, most often a quarter, from a company perspective to the individual teams contributing to them as well as the team members on a personal level. In this regard, they work well together with the concept of company vision and mission.<\/p>\n<p>Based on realistic goals for a quarter OKRs are formulated on a company level with objectives being a higher goal like \u201cBecome the number one provider for X in our home market\u201d or \u201cBeing the most attractive employer for software developers in Munich\u201d which is more of an ideal as a measurable goal. To each objective belong 2 to 4 key results which have to be measurable goals that are ideally quantitative in nature so as to break them down into percentages of achievement over the quarter they are tracked. Examples would be \u201cReach 1.0 mio \u20ac in revenue in the home market\u201d or \u201cReceive 25 unsolicited applications in Q1\u201d. For a growing library of OKRs for different departments see some of our OKR examples in<span>\u00a0<\/span><a href=\"https:\/\/wearekemb.com\/en\/okr-templates-a-kickstarter-for-your-departments-okr-process\/\">this articles\u2019 airtable.<\/a><\/p>\n<p>The wider process then includes aligning the OKRs of all teams to check whether there are conflicts of interest which need to be alleviated before the quarter so as to have the whole company work towards the same goals without teams being blocked by other teams capacity or even having misaligned goals that contradict each other. Also OKRs should be formulated as output KPIs so that the means of achieving a goal are not predetermined to do list but provide for flexibility in achieving those goals with smart initiatives. OKRs should also be reasonable in a way that they include the everyday operative tasks of the teams and do not come on top making them hard to achieve to begin with.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/01\/okr-excel-template-article-wearekemb-strategy.png&#8221; title_text=&#8221;okr-excel-template-article-wearekemb-strategy&#8221; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Over the course of the quarter there are regular alignments if the OKRs are on track and exchange on how to better achieve them if a team is behind. On the level of personal OKRs we regularly include means for personal development next to business goals and thus the tool can also be used for people management. It is important to state that OKRs should be followed in some regard by the book meaning how they are set and formulated and how they interact. On the other hand you should adapt the processes so that they work for your company.<\/p>\n<div class=\"wp-block-uagb-marketing-button uagb-marketing-btn__outer-wrap uagb-marketing-btn__align-center uagb-marketing-btn__align-text-center uagb-marketing-btn__icon-before uagb-block-55f4344a\">\n<div class=\"uagb-marketing-btn__wrap\">\n<div class=\"uagb-marketing-btn__title-wrap\">\n<p>&nbsp;<\/p>\n<p>Provided you kicked off OKRs or are already using them how can you make sure not to spend hours weekly to gather all the numbers? Well, here is how we do it at kemb.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_How_to_automate_your_OKRs_using_Google_sheets\"><\/span>2. How to automate your OKRs using Google sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As many of you, we love to automate tedious processes. Manually collecting input numbers for our OKRs is one of those tasks. We are aware that sometimes there is no way to automate data imports, and sometimes manually adding entries is the only way. However, for all other cases, we highly recommend automating your imports.<\/p>\n<p>We suggest discussing your OKRs at least once a week, and therefore have created an easy template which shows your progress on a weekly basis. Now it\u2019s up to you to automate your data collection. This is easily set up using five simple steps<\/p>\n<h3><span class=\"ez-toc-section\" id=\"21_Setting_SMART_Goals\"><\/span><strong>2.1\u00a0Setting SMART Goals<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When setting your goals, make sure you set SMART goals. In this case the \u201cM\u201d for measurable is important when it comes to automation. We have noticed that using OKR automation challenges you in making sure your goals are easily measurable.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"22_Where_do_you_get_your_data_from\"><\/span><strong>2.2\u00a0Where do you get your data from?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Once you know which metrics you need in order to track your key results, it is time to check if you can automatically import these values using Supermetrics queries. You can find a list with all sources here (<a href=\"https:\/\/supermetrics.com\/integrations\">https:\/\/supermetrics.com\/integrations<\/a>)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"23_Write_your_import_using_Supermetrics_queries\"><\/span><strong>2.3\u00a0Write your import using Supermetrics queries<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>We highly suggest using an import tab in which you collect all of your raw data, before importing it into your OKR overview. In our template we use a weekly import in which we fetch our desired data using the date range \u201cyear to date\u201d and split the desired data by \u201cyear &amp; week (Mon\u2013Sun)\u201d.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"24_Link_up_your_cells\"><\/span><strong>2.4\u00a0Link up your cells<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>After we successfully imported the data needed in order to track our OKRs, we need to link up the cells in the overview in order to get your scoring.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"25_Set-up_an_automated_refresh_and_email\"><\/span><strong>2.5\u00a0Set-up an automated refresh and email<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Once your key results are imported and you linked your actuals with your targets, it\u2019s time to set up the weekly refresh. By doing so you make sure that all your key results automatically get updated on a weekly basis. In order to create even more visibility, you can decide to automatically send a weekly update email to your team-members.<\/p>\n<p>This process might seem a little complex at first, however, after having done this exercise once, we see the following advantages:<\/p>\n<ol>\n<li>Large amounts of time saved, due to Supermetrics automatically pulling the required data<\/li>\n<li>More awareness and a better understanding of both team and personal OKRs amongst teams<\/li>\n<li>No more copy and paste errors.<\/li>\n<li>No more weekly meetings with missing numbers<\/li>\n<\/ol>\n<p>Pick the Supermetrics plan that offers the connectors you need. Some examples of the most common tools we\u2019ve used to easily automate OKRs: Marketing performance: Google Analytics, Google Ads, Linkedin Ads, Facebook ads.<\/p>\n<p>In order to get Keyresults such as:<\/p>\n<ol>\n<li><em>1. Grow Organic Website visits from X to Y<\/em><\/li>\n<li>Increase Conversion Rate from LinkedIn Campaigns by 10% from 2.5 to 2.75<\/li>\n<li>Double the Leads from partner webinars from 20 to 40<\/li>\n<\/ol>\n<p>We have collected an even longer list of<span>\u00a0<\/span><a href=\"https:\/\/wearekemb.com\/en\/okr-templates-a-kickstarter-for-your-departments-okr-process\/\">OKR examples split by departments here<\/a>. These we created to help you get new ideas and angles on how to track Objective and Key Results per Department. (feel free to share your suggestions, we will add them to the airtable)<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_How_to_build_a_OKR_dashboards\"><\/span>3. How to build a OKR dashboards<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now we know the basics of OKRs and have discussed the basic concept of tracking your key results, it\u2019s time to build our own OKR dashboards.<\/p>\n<p>As explained earlier we suggest setting OKRs on three levels:<\/p>\n<ol>\n<li><strong>Company OKRs,<\/strong>combining the overall company goals within digestible and clear OKRs<\/li>\n<li><strong>Team OKRs<\/strong>, a subset of objectives that a team is responsible for and which feed into the overall company OKRs<\/li>\n<li><strong>Personal<\/strong>, these are optional, however, a great tool to empower employees to go further. We also suggest mixing subsets of the team OKRs in combination with personal development OKRs.<\/li>\n<\/ol>\n<p>In our template we have created overviews for all 3 of the above, where team and company are one template, and personal also has its own template.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Getting_started\"><\/span>Getting started<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Enough talk, let\u2019s dive right in. We will start with the team\/company OKRs. Step 1: Get your own copy of this Google Sheet. So the first thing you\u2019re going to do is to just to do is make a copy of this<span>\u00a0<\/span><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1_VuEBlymkcd6B8sGGJZUYu7QdEnqtNxbUcl-JGq0drA\/edit#gid=28294529\" target=\"_blank\" rel=\"noreferrer noopener\">OKR Template as a Google Sheet<\/a>, so click File\u2014&gt; \u201cMake a copy\u201d.\u00a0<\/p>\n<p>This new sheet you just downloaded will be your OKR masterfile. Use this as one file where you collect all your OKRs.<span>\u00a0<\/span><strong>Step 2: Duplicate the template tabs for each of your teams and name them.<\/strong><span>\u00a0<\/span>Click on the tabs at the bottom, and select duplicate. By always working with a duplicate you make sure you never end of changing or removing the OKRs of your team members.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/01\/2.-OKR-Template-article-wearekemb.com_-1024&#215;815-1.png&#8221; title_text=&#8221;2.-OKR-Template-article-wearekemb.com_-1024&#215;815&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>Step 3: Setting the date<\/strong><span>\u00a0<\/span>Doubleclick on the cells B2 &amp; D2, and select the first and the last days of the quarter. This we do in order to calculate how many days there are within your selected quarter.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/01\/3.-OKR-Template-article-wearekemb.com_-1024&#215;749-1.png&#8221; title_text=&#8221;3.-OKR-Template-article-wearekemb.com_-1024&#215;749&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>Now the basic setup for your sheet is done, and we are ready to add your objectives and key results.<\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"32_Setting_your_Objectives_Key_Results\"><\/span><strong>3.2 Setting your Objectives &amp; Key Results<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Now we are getting to the part where we add our objectives and key results. Keep in mind that your key results are the elements that make up your objective.<\/p>\n<p>Lets use a simple example to start with, let\u2019s say our objective is to \u201cDouble the number of sales for our company compared to last quarter\u201d, and in order to do so we have defined our first key results as \u201cWe want to grow our organic website to 7.000\u201d. So we fill in our objective and key results in column B.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"33_Fetching_the_your_data\"><\/span><strong>3.3 Fetching the your data<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>As a next step we need to set-up the supermetrics query which gives us our weekly organic website visits.<\/p>\n<p>If you\u2019ve not already done so, now would be the time to install the Supermetrics addon for Google sheets.<\/p>\n<p>In your top navigation click on \u201cAdd-ons\u201d &gt; \u201cGet-Addons\u201d &gt; search for Supermetrics and hit install.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/01\/4.-OKR-Template-article-wearekemb.com_.png&#8221; title_text=&#8221;4.-OKR-Template-article-wearekemb.com_&#8221; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span>If you already have the Supermetrics Add-on installed, launch the sidebar.<\/span><\/p>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/01\/5.-OKR-Template-article-wearekemb.com_-1024&#215;816-1.png&#8221; title_text=&#8221;5.-OKR-Template-article-wearekemb.com_-1024&#215;816&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Now our sidebar is launched we open the \u201cData Import \u2013 Team\/Company\u201d tab and click on cell B8 and start composing our basic query to pull in our weekly organic website visits.<\/p>\n<p>So for our sample query we select the following elements:<\/p>\n<ul><\/ul>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/01\/6.-OKR-Template-article-wearekemb.com_-1024&#215;506-1.png&#8221; title_text=&#8221;6.-OKR-Template-article-wearekemb.com_-1024&#215;506&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<table border=\"1\" style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 29.2035%;\"><strong>Datasource<\/strong><\/td>\n<td style=\"width: 70.5015%;\">Google Analytics<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 29.2035%;\"><strong>Select View<\/strong><\/td>\n<td style=\"width: 70.5015%;\">Select the view you normally use for your reporting<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 29.2035%;\"><strong>Select Dates<\/strong><\/td>\n<td style=\"width: 70.5015%;\">We select year to date, in order to make sure all your data add week by week, giving you some historic data making it easier to validate and match (You could also use other date settings, however, this will require you to Index\/Match your weeks to our OKR overviews)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 29.2035%;\"><strong>Select Metrics<\/strong><\/td>\n<td style=\"width: 70.5015%;\">Sessions<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 29.2035%;\"><strong>Split By<\/strong><\/td>\n<td style=\"width: 70.5015%;\">Year &amp; Week (Mon-sun)<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 29.2035%;\"><strong>Segment<\/strong><\/td>\n<td style=\"width: 70.5015%;\">Here you can use the predefined \u201cOrganic Traffic\u201d segment<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 29.2035%;\"><strong>Filter<\/strong><\/td>\n<td style=\"width: 70.5015%;\">If you want to import any other segments, which are not defined under the Segment tab, you can use Filters to narrow down your data.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 29.2035%;\"><strong>Options<\/strong><\/td>\n<td style=\"width: 70.5015%;\">Make sure you tick on \u201cReplace blank metric values with zeros\u201d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Now click \u201cGet Data to Table\u201d, and your data should be correctly pulled in. After your data is imported we highly suggest checking your imported numbers against the source, to validate that your query is correct.<\/p>\n<p>Repeat this process to collect all data you need in order to measure your OKRs, keep in mind that you could potentially import data for multiple key results from the same source using the \u201cSelect Metrics\u201d and \u201cSplit By\u201d functions.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Link_your_goals_your_actuals\"><\/span>Link your goals &amp; your actuals<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Once you have imported all the data into the \u201cData Import \u2013 Team\/Company\u201d tab, we can match the actuals with your key results. To do this with our example, open the \u201cTeam\/Company (make a copy)\u201d tab and go to Cell E11.<\/p>\n<p>Here we write the following formula in order to 1. Import our values, and 2. To score them against our objective.<\/p>\n<p class=\"has-text-align-center has-blue-dark-color has-text-color\" style=\"text-align: center;\"><span style=\"color: #0000ff;\"><strong>=\u2019Data Import \u2013 Team\/Company\u2019!B9\/7000<\/strong><\/span><br \/><span style=\"color: #0000ff;\"><em>\u00a0\u00a0\u00a0Match the correct weekly value \/ your key result value<\/em><\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/01\/7.-OKR-Template-article-wearekemb.com_-1024&#215;643-1.png&#8221; title_text=&#8221;7.-OKR-Template-article-wearekemb.com_-1024&#215;643&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>This simple formula should give you your current goal achieved based on the actuals vs. your goal.<\/p>\n<p>Now we want to make sure that the data gets displayed for year week by adding two elements:<\/p>\n<p>First we copy the formula from cell E11 to F11<\/p>\n<ol>\n<li>Adding up the cells of the previous week, this we do by adding + =((\u2018Data Import \u2013 Team\/Company\u2019!B9\/7000)+D11))<\/li>\n<li>Make sure that cells that lie in the future do not show any data. This we do by adding an \u201cif\u201d-clause formula that checks if the date is on the future =IF(E$9&gt;=TODAY();\u201d\u201d;((\u2018Data Import \u2013 Team\/Company\u2019!B9\/7000)+D11))<\/li>\n<li>Now we can easily copy the cells through the quarter, making sure that as soon as there is a new weekly value available, your sheet will be showing the weekly numbers.<\/li>\n<li>You can now also drag down the formulas and update the import and goal values. All other parts of the formula you do not have to touch<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/01\/8.-OKR-Template-article-wearekemb.com_-1.gif&#8221; title_text=&#8221;8.-OKR-Template-article-wearekemb.com_-1&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><span class=\"ez-toc-section\" id=\"35_Automate_your_weekly_refresh\"><\/span><strong>3.5 Automate your weekly refresh<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Our ORK report is now ready for use. The last thing we need to do is to make sure that our report refreshes automatically. Keep in mind that this is a feature only available in the paid versions of Supermetrics.<\/p>\n<p>Alternatively you could decide to manually launch a data import refresh in the free version via \u201cAdd-ons\u201d &gt; \u201cSupermetrics\u201d &gt; \u201cRefresh Queries\u201d<\/p>\n<p>Within the paid versions you can use the \u201cSchedule Refresh &amp; Emails\u201d option which can be found under \u201cAdd-ons\u201d &gt; \u201cSupermetrics\u201d &gt; \u201cSchedule refresh &amp; emailing\u201d<a href=\"https:\/\/supermetrics.idevaffiliate.com\/idevaffiliate.php?id=1042=OKR_template_de\"><strong><\/strong><\/a><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/01\/9.-OKR-Template-article-wearekemb.com_.png&#8221; title_text=&#8221;9.-OKR-Template-article-wearekemb.com_&#8221; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Here we suggest running your weekly update early Monday morning, to make sure all your data is complete, whilst still making sure that your document is fully updated first thing Monday morning.<\/p>\n<p>You can also setup email automation which will send you an email as soon as your reports have been refreshed. Here we suggest to not use this function to send emails to all employees, as you might want to evaluate the numbers before they are shared and to tick the box \u201cSend email alerts if queries fail on refresh\u201d, as this will also send you a message if one of your queries fails to run.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"36_End_of_Quarter_now_what\"><\/span><strong>3.6 End of Quarter, now what?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Having followed all of the above steps you should now have a fully automated OKR reporting sheet, which you can use on a company, team and personal level. Once your quarter is over, we suggest fixing all values by \u201cselecting all cells\u201d &gt; \u201ccopy\u201d &gt; \u201cPaste Values Only\u201d This way you fix all the values and you can use your data import sheets for your next quarters OKRs.<\/p>\n<p>This then also gives you a clear archive of previous OKRs and achievements.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span>When you enable the preview mode you will be redirected to the following window<\/span><\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Rolling_out_OKRs_within_your_teams\"><\/span>4. Rolling out OKRs within your teams<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you are done structuring your OKRs and having automated the sheets it is time to roll them out within the company and its teams. For us OKRs have three aspects that make them really powerful if a company is willing to reap all the benefits from them:<\/p>\n<h4><strong>Visibility<\/strong><\/h4>\n<p>OKRs work best when there is a maximum amount of transparency on them. This does not mean that you need to report EBIT margin and cash flow to every intern but that you design your OKRs in a way that every employee understands where the company is developing and which measures are used to grow there.This visibility can be achieved by for example making all team and company OKRs accessible to every (full-time) employee. We even had cases where everyone\u2019s personal OKRs were transparent not to judge each other but to better understand what the individual would prioritize in their everyday work. If you are based on Google Drive, Sheets makes sharing really easy as sharing is just a button click away (given you know who gets to see what).<\/p>\n<h4><strong>Involvement<\/strong><\/h4>\n<p>OKRs are a great means to activate the whole potential of your company. Get input from the team members for the team OKRs, use the personal OKRs to understand where your employee wants to grow to and support them with time for education and conferences. Talk about the other teams OKRs in your team to give them a better understanding of how the company works and how the teams interact to form a whole. We have seen cases where OKRs were beautifully visualized on screens next to the teams and more often than not that led to discussions with team members from other teams that brought to light some new ideas and process improvements.<\/p>\n<h4><strong>Company spirit<\/strong><\/h4>\n<p>Through visibility and involvement you generate a whole new spirit throughout your company. People get a better understanding of their respective colleagues day to day work and how everyone contributes to a shared vision. People feel involved and taken seriously when you celebrate their successes and support them when they should fall short of goals. It is way easier to discuss happenings fact based and blame free when you have a transparency on numbers, a basis for hypotheses why things work out well or don\u2019t and the trust to experiment as the effects can be seen in close to real time. We highly believe that OKRs can help every company to make work feel less like work and more like a shared set of goals.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Continuous_Improvements\"><\/span>Continuous Improvements<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>OKRs become really powerful in the long run.<\/p>\n<p>In most of the setups where we implemented OKRs we saw improvements over time and struggle in the beginning is natural.<\/p>\n<p>. If you are not used to creating OKRs most often you will start off with a couple of input key results that work more like a checklist than goals. Interdependencies between teams are discovered throughout understanding and discussing regularly where there are touchpoints and limits in daily work and for some teams especially in operations like finance and HR it is most often tricky to come up with key results that also reflect the day to day work of accounting or people management.<\/p>\n<p>Especially with OKRs communication is essential. Use the OKRs to align with your team on a regular basis if you are making progress, whether there are limited resources or if there are any blockers.<\/p>\n<p>We made it part of our process to have a quarterly offsite where we block a whole day or two depending on team size to discuss the whole OKRs of the previous and the upcoming quarter. In this offsite we document what went well and what didn\u2019t and give ourselves feedback on the planned OKRs: do we all work towards a shared goal this quarter, did we overload the OKRs, where can we improve?<\/p>\n<p>Most often the initial rounds of OKRs are planned too big and in our experience limiting the scope but excelling in that scope is the main route to go instead of starting 10 initiatives and never finishing one. OKRs should also be about completion.<\/p>\n<p>That concludes our piece on OKRs and how to automate them. If you have any questions feel free to contact us via our<span>\u00a0<\/span><a href=\"https:\/\/wearekemb.com\/en\/contact-us\/\">Contact Form<\/a><span>\u00a0<\/span>or if you need support automating your OKRs with supermetrics we are also happy to help.<\/p>\n<div class=\"is-layout-flow wp-block-group\">\n<div class=\"wp-block-group__inner-container\">\n<p><strong>Thank you for taking the time to read all the way through.\u00a0<\/strong><\/p>\n<\/div>\n<\/div>\n<ol><\/ol>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to set up your OKRs quick and easy using Supermetrics in Google Sheets with just a few clicks. <\/p>\n","protected":false},"author":4,"featured_media":7621,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","content-type":"","inline_featured_image":false,"footnotes":""},"categories":[26,27],"tags":[],"class_list":["post-2355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-reporting-en","category-process-automation-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to easily track OKRs in Google sheets using Supermetrics - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation<\/title>\n<meta name=\"description\" content=\"How to set up your OKRs quick and easy using Supermetrics in Google Sheets with just a few clicks.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to easily track OKRs in Google sheets using Supermetrics - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\" \/>\n<meta property=\"og:description\" content=\"How to set up your OKRs quick and easy using Supermetrics in Google Sheets with just a few clicks.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/\" \/>\n<meta property=\"og:site_name\" content=\"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-15T08:29:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-03T16:27:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wearekemb.com\/wp-content\/uploads\/2020\/04\/14.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2200\" \/>\n\t<meta property=\"og:image:height\" content=\"1500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Martijn Burgman\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Martijn Burgman\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/\"},\"author\":{\"name\":\"Martijn Burgman\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#\\\/schema\\\/person\\\/6a82f14b1a581cef7f084b2f826f9014\"},\"headline\":\"How to easily track OKRs in Google sheets using Supermetrics\",\"datePublished\":\"2024-05-15T08:29:07+00:00\",\"dateModified\":\"2025-03-03T16:27:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/\"},\"wordCount\":4279,\"publisher\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/14.png\",\"articleSection\":[\"Data &amp; reporting\",\"Process &amp; Automation\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/\",\"name\":\"How to easily track OKRs in Google sheets using Supermetrics - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/14.png\",\"datePublished\":\"2024-05-15T08:29:07+00:00\",\"dateModified\":\"2025-03-03T16:27:06+00:00\",\"description\":\"How to set up your OKRs quick and easy using Supermetrics in Google Sheets with just a few clicks.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/14.png\",\"contentUrl\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/14.png\",\"width\":2200,\"height\":1500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/how-to-easily-track-okrs-in-google-sheets-us\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to easily track OKRs in Google sheets using Supermetrics\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/\",\"name\":\"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\",\"description\":\"We help you bring your business to the next level\",\"publisher\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#organization\",\"name\":\"kemb GmbH\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/kemb-logo-512x512-1.png\",\"contentUrl\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/kemb-logo-512x512-1.png\",\"width\":512,\"height\":512,\"caption\":\"kemb GmbH\"},\"image\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/kemb-gmbh\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#\\\/schema\\\/person\\\/6a82f14b1a581cef7f084b2f826f9014\",\"name\":\"Martijn Burgman\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/57e794ad4644a53f5973e144f47cd28a9a5f5c746f5989ed8cc07fdd97b3dcbe?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/57e794ad4644a53f5973e144f47cd28a9a5f5c746f5989ed8cc07fdd97b3dcbe?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/57e794ad4644a53f5973e144f47cd28a9a5f5c746f5989ed8cc07fdd97b3dcbe?s=96&d=mm&r=g\",\"caption\":\"Martijn Burgman\"},\"description\":\"Co-Founder and CMO at Kemb, where he helps B2B companies scale through data-driven marketing strategies and smart automation. With a background in digital consulting and a hands-on approach, he bridges the gap between strategy and execution \u2014 from lead generation to performance analysis.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to easily track OKRs in Google sheets using Supermetrics - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","description":"How to set up your OKRs quick and easy using Supermetrics in Google Sheets with just a few clicks.","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:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/","og_locale":"en_US","og_type":"article","og_title":"How to easily track OKRs in Google sheets using Supermetrics - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","og_description":"How to set up your OKRs quick and easy using Supermetrics in Google Sheets with just a few clicks.","og_url":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/","og_site_name":"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","article_published_time":"2024-05-15T08:29:07+00:00","article_modified_time":"2025-03-03T16:27:06+00:00","og_image":[{"width":2200,"height":1500,"url":"https:\/\/wearekemb.com\/wp-content\/uploads\/2020\/04\/14.png","type":"image\/png"}],"author":"Martijn Burgman","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Martijn Burgman","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#article","isPartOf":{"@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/"},"author":{"name":"Martijn Burgman","@id":"https:\/\/wearekemb.com\/en\/#\/schema\/person\/6a82f14b1a581cef7f084b2f826f9014"},"headline":"How to easily track OKRs in Google sheets using Supermetrics","datePublished":"2024-05-15T08:29:07+00:00","dateModified":"2025-03-03T16:27:06+00:00","mainEntityOfPage":{"@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/"},"wordCount":4279,"publisher":{"@id":"https:\/\/wearekemb.com\/en\/#organization"},"image":{"@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#primaryimage"},"thumbnailUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2020\/04\/14.png","articleSection":["Data &amp; reporting","Process &amp; Automation"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/","url":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/","name":"How to easily track OKRs in Google sheets using Supermetrics - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","isPartOf":{"@id":"https:\/\/wearekemb.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#primaryimage"},"image":{"@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#primaryimage"},"thumbnailUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2020\/04\/14.png","datePublished":"2024-05-15T08:29:07+00:00","dateModified":"2025-03-03T16:27:06+00:00","description":"How to set up your OKRs quick and easy using Supermetrics in Google Sheets with just a few clicks.","breadcrumb":{"@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#primaryimage","url":"https:\/\/wearekemb.com\/wp-content\/uploads\/2020\/04\/14.png","contentUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2020\/04\/14.png","width":2200,"height":1500},{"@type":"BreadcrumbList","@id":"https:\/\/wearekemb.com\/en\/how-to-easily-track-okrs-in-google-sheets-us\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wearekemb.com\/en\/"},{"@type":"ListItem","position":2,"name":"How to easily track OKRs in Google sheets using Supermetrics"}]},{"@type":"WebSite","@id":"https:\/\/wearekemb.com\/en\/#website","url":"https:\/\/wearekemb.com\/en\/","name":"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","description":"We help you bring your business to the next level","publisher":{"@id":"https:\/\/wearekemb.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wearekemb.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/wearekemb.com\/en\/#organization","name":"kemb GmbH","url":"https:\/\/wearekemb.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/wearekemb.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/02\/kemb-logo-512x512-1.png","contentUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/02\/kemb-logo-512x512-1.png","width":512,"height":512,"caption":"kemb GmbH"},"image":{"@id":"https:\/\/wearekemb.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/kemb-gmbh\/"]},{"@type":"Person","@id":"https:\/\/wearekemb.com\/en\/#\/schema\/person\/6a82f14b1a581cef7f084b2f826f9014","name":"Martijn Burgman","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/secure.gravatar.com\/avatar\/57e794ad4644a53f5973e144f47cd28a9a5f5c746f5989ed8cc07fdd97b3dcbe?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/57e794ad4644a53f5973e144f47cd28a9a5f5c746f5989ed8cc07fdd97b3dcbe?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/57e794ad4644a53f5973e144f47cd28a9a5f5c746f5989ed8cc07fdd97b3dcbe?s=96&d=mm&r=g","caption":"Martijn Burgman"},"description":"Co-Founder and CMO at Kemb, where he helps B2B companies scale through data-driven marketing strategies and smart automation. With a background in digital consulting and a hands-on approach, he bridges the gap between strategy and execution \u2014 from lead generation to performance analysis."}]}},"_links":{"self":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/posts\/2355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/comments?post=2355"}],"version-history":[{"count":0,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/posts\/2355\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/media\/7621"}],"wp:attachment":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/media?parent=2355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/categories?post=2355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/tags?post=2355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}