{"id":34078,"date":"2021-06-09T12:27:36","date_gmt":"2021-06-09T10:27:36","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=34078"},"modified":"2025-11-18T21:43:16","modified_gmt":"2025-11-18T20:43:16","slug":"modelo-de-kpis-de-marketing-do-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/marketing-templates\/excel-marketing-kpis-template\/","title":{"rendered":"Modelo de KPIs de marketing no Excel"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row _builder_version=&#8221;4.16&#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.16&#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.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>As with many other business areas, the world of marketing is becoming increasingly more data-driven. As a result, the marketing departments that stay up to date with this data revolution benefit from the many advantages it brings. For instance, mining and analyzing customer data lead to an increase in conversion rates and the number of identified prospects if done correctly.<\/p>\n<p>Marketing teams with the most creative content, best designs, and most original advertisement campaigns usually come out on top. However, if those teams do not measure results or analyze data, they are still at a disadvantage in the long term compared to teams that do.<\/p>\n<p>Organizations are result-driven and appreciate marketing managers who present results based on the data they collect and analyze.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2>Key Performance Indicators<\/h2>\n<p>That\u2019s where KPIs (Key Performance Indicators) come in. KPIs measure the extent to which an organization is achieving its objectives. As such, these indicators should only contain the most important metrics. In this case, quality is definitely preferred above quantity.<\/p>\n<p>Besides, KPIs should be S.M.A.R.T: Specific, Measurable, Attainable, Relevant, and Time-bound. A few key metrics in email marketing include the number of emails opened, the number of clicks, the number of conversions, and more. Make sure that KPIs for other areas are equally precise and measurable as these examples.<\/p>\n<p>First, the marketing team decides which metrics to analyze. Next, they start tracking the chosen KPIs. However, the question remains: where do you store this information?<\/p>\n<p>While analysis tools like Google Analytics are popular in many companies, a marketing team with a multi-channel strategy generates a vast amount of data.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/07\/Artboard-\u2013-2.png&#8221; alt=&#8221;Marketing KPI Template Excel cover dashboard 2&#8243; title_text=&#8221;Artboard \u2013 2&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2>Why use an Excel template to track marketing KPIs?<\/h2>\n<ul>\n<li><b>Flexibility<\/b>: Excel spreadsheets can be easily modified and adapted to meet your organization\u2019s specific needs and requirements. As such, there is no need for complicated software solutions or putting pressure on your IT department to build a customized marketing KPI system.<\/li>\n<li><b>Accessibility<\/b>: Whether you are working from a tablet, a desktop, laptop, or smartphone, marketing managers and members of the marketing team always have access to the workflow. As such, they can make changes anywhere they have an Internet connection.<\/li>\n<li><b>Compatibility<\/b>: Microsoft Excel is easily compatible with other software that your organization might be using. Therefore, any marketing-related data you already have is easily imported into Excel spreadsheets.<\/li>\n<li><b>Ease of use<\/b>: Many employees are familiar with spreadsheets and if they are not, it is easy to train them. Indeed, using an Excel-based template is ideal for beginners and advanced users alike.<\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;||30px||false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2>Get the template<\/h2>\nClick the button below to download.[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/drive.google.com\/uc?export=download&#038;id=1XEaKKvXX40SDytsKKhb3a1y1M0DJoceR&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Get template&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|30px|0px|false|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/Marketing-KPI-Template-Excel-Dashboard-SEO-4-1.png&#8221; alt=&#8221;Marketing KPI Template Excel Dashboard SEO 4&#8243; title_text=&#8221;Marketing KPI Template Excel Dashboard SEO 4 (1)&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]These sheets contain sample data to demonstrate how the template works. Delete or overwrite this data. The gray cells contain pre-filled data, so don\u2019t try to alter this information. Enter your data in the white cells.\n\nShare each of the marketing channel spreadsheets with the person responsible for that channel. Click the green <b>Share<\/b> button in Excel. If you prefer working in the Excel application, simply click <b>Open in Desktop App<\/b> and continue working in Excel.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h2>Looking for more Excel templates?<\/h2>\nCheck out this post about Sheetgo&#8217;s <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/expense-tracker-template-excel\/\">Expense tracker template<\/a>.[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;]<h2>Did you like this post?<\/h2>\nIf you found this post helpful or interesting, share it with your colleagues and friends.\n\nTake a look at the following blog post about <a href=\"https:\/\/www.onehourprofessor.com\/best-email-marketing-software-services\/\" target=\"_blank\" rel=\"noopener\">the best marketing email software<\/a> to further optimize and boost your marketing department.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=&#8221;on&#8221; _builder_version=&#8221;4.24.1&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#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.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; text_font_size=&#8221;30px&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_orientation=&#8221;center&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><strong>Start tracking and analyzing your <span style=\"background-color: rgba(41,121,255,0.2);\">marketing KPIs<\/span><\/strong><\/p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/drive.google.com\/uc?export=download&#038;id=1XEaKKvXX40SDytsKKhb3a1y1M0DJoceR&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;Get template&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;25px|0px|25px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>As with many other business areas, the world of marketing is becoming increasingly more data-driven. As a result, the marketing departments that stay up to date with this data revolution benefit from the many advantages it brings. For instance, mining and analyzing customer data lead to an increase in conversion rates and the number of [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":34079,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[40],"tags":[45],"class_list":["post-34078","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-marketing-templates","tag-marketing"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/34078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=34078"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/34078\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/34079"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=34078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=34078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=34078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}