{"id":18412,"date":"2017-08-08T13:14:35","date_gmt":"2017-08-08T13:14:35","guid":{"rendered":"https:\/\/www.geotelecom.mx\/?p=18412\/"},"modified":"2025-04-02T10:48:53","modified_gmt":"2025-04-02T08:48:53","slug":"metricas-de-facebook-en-data-studio","status":"publish","type":"post","link":"https:\/\/www.geotelecom.mx\/en\/blog\/metrics-facebook-in-data-studio\/","title":{"rendered":"Facebook metrics in Google Data Studio."},"content":{"rendered":"<p class=\"wp-block-paragraph\">Who hasn't spent mornings in the office trying to make a report understandable? Reporting Ninja, Blockspring or Data Studio are some of the thousands of existing tools to create your charts and reports. The latter, Data Studio, allows you to create <strong>dynamic and attractive reports from multiple sources.<\/strong> <\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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 Contents\"><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:\/\/www.geotelecom.mx\/en\/blog\/metrics-facebook-in-data-studio\/#%C2%BFQue_es_Google_Data_Studio\" >What is Google Data Studio?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.geotelecom.mx\/en\/blog\/metrics-facebook-in-data-studio\/#Anade_tus_metricas_de_Facebooky_otras_plataformas\" >Add your metrics from Facebook and other platforms.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.geotelecom.mx\/en\/blog\/metrics-facebook-in-data-studio\/#Las_grandes_ventajas_de_Data_Studio\" >The great advantages of Data Studio.<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n\n<p class=\"wp-block-paragraph\">How many times have you wanted to group all your sources into a single report? Find out how <strong>integrating all your metrics and KPIs<\/strong> in a single document.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%C2%BFQue_es_Google_Data_Studio\"><\/span>What is Google Data Studio?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Last year Google introduced the <strong>free version of Data Studio 360<\/strong>aimed at individuals and small teams dedicated to Marketing. This tool is based on the creation of <strong>dashboards<\/strong> as of <strong>data sources<\/strong> that you are interested in combining. Starting from these sources you can create different <strong>visual content<\/strong> (graphs, tables, etc.) to later share it with clients or colleagues (via Google Docs, PDF,...). <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In short, Google Data Studio is the <strong>data visualization tool<\/strong> that Google makes available to users. Its main objective is to <strong>facilitate data analysis with reports<\/strong> of high visual content. In addition, the platform itself offers customizable templates beyond those created by the user.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Anade_tus_metricas_de_Facebooky_otras_plataformas\"><\/span>Add your metrics from Facebook and other platforms.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n\n\n<p class=\"wp-block-paragraph\">However, if you already use this tool on more than one occasion, you may have needed to incorporate data from your <strong>campaigns on Facebook, Instagram, Bing, Twitter, YouTube or other platforms.<\/strong>\u00a0Going to the specific case of Facebook, how to count your metrics in Data Studio? <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Maybe the first thing you think of is exporting your Facebook stats in <strong>CSV<\/strong> and upload it as <strong>source<\/strong> to Data Studio, right? For a one-off report it might work, but how often would you have to download the CSV and upload it as a source? Keep in mind that every time period analyzed the data will change and you will have no other way to refresh it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Below we share how to solve this 'inconvenience'. Nothing better than a Google tool to complement another Google tool, right? From a <strong>spreadsheet in Drive (Google Sheets)<\/strong> you will be able to obtain the <strong>Supermetrics add-on<\/strong>. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">From here you can access <strong>more than 40 platforms<\/strong> and incorporate their metrics into a single document. However, in this case <strong>separates each platform into different sheets of the same document<\/strong>\u00a0not to cross-reference data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is when you will be able to <strong>incorporate it as a data source in Data Studio<\/strong> from the 'Google Spreadsheets' option. Having the document created in your own Drive, adding it will be quite intuitive. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, going back to the beginning, what happens when you need to refresh the data? As easy as going back to your spreadsheet in Drive and from Supermetrics (in the Plugins menu), click on <em><strong>Refresh All' or schedule when to do it<\/strong><\/em>. This is the best option when you have perfectly configured your spreadsheet. Otherwise you can always check the date ranges on each sheet to make sure.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Las_grandes_ventajas_de_Data_Studio\"><\/span>The great advantages of Data Studio.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As you can see, Data Studio is a versatile tool that is easy and intuitive to use. You can easily connect different sources to transform data into a visual and understandable document. Another strong point is the high degree of customization it allows for each report, which can also be updated in real time. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In short, it saves time and headaches and facilitates communication between partners. Thanks to Data Studio you will be able to share and collaborate with your work team and with your customers. We hope this brief review has been helpful. Now all that's left to do is to play around and test your own dashboards.<strong> Unleash your reports in Data Studio! There's still a lot to explore \ud83d\ude09<\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Who hasn't spent mornings in the office trying to make a report understandable? Reporting Ninja, Blockspring or Data Studio are some of the thousands of existing tools to create your charts and reports. The latter, Data Studio, allows you to create dynamic and attractive reports from multiple sources.\n\n\n\nHow many times have you wanted to group all your sources into a single report? Discover below how to integrate all your metrics and KPIs into a single document.\n\n\n\nWhat is Google Data Studio?\n\n\n\nLast year Google introduced the free version of Data Studio 360, aimed at individuals and small teams dedicated to Marketing. This tool is based on the creation of dashboards from data sources that you are interested in combining. From these sources you can create different visual content (graphs, tables, etc.) and then share it with clients or colleagues (via Google Docs, PDF,...).\n\n\n\nIn short, Google Data Studio is the data visualization tool that Google makes available to users. Its main objective is to facilitate data analysis with highly visual reports. In addition, the platform itself offers customizable templates beyond those created by the user himself.\n\n\n\nAdd your metrics from Facebook and other platforms.\n\n\n\nData Sources in Supermetrics\n\n\n\nHowever, if you already use this tool on more than one occasion you will have needed to incorporate data from your campaigns on Facebook, Instagram, Bing, Twitter, YouTube or other platforms. Going to the specific case of Facebook, how to count on its metrics in Data Studio?\n\n\n\nMaybe the first thing you think of is to export Facebook statistics in CSV and upload it as a source to Data Studio, right? For a one-off report it might work for you, but how often would you have to download the CSV and upload it as a source? Keep in mind that every time period analyzed the data will change and you will have no other way to refresh it.\n\n\n\nBelow we share how to solve this 'inconvenience'. Nothing better than a Google tool to complement another Google tool, right? From a spreadsheet in Drive (Google Sheets) you can get the Supermetrics add-on.\n\n\n\nFrom here you can access more than 40 platforms and incorporate their metrics in the same document. However, in this case, separate each platform in different sheets of the same document to avoid crossing data.\n\n\n\nIt will be here when you will be able to incorporate it as a data source in Data Studio from the 'Google Spreadsheets' option. Having the document created in your own Drive, adding it will be quite intuitive.\n\n\n\nNow, going back to the beginning, what happens when you need to refresh the data? As easy as going back to your spreadsheet in Drive and from Supermetrics (in the Plugins menu), click on 'Refresh All' or schedule when to do it. This is the best option when you have your spreadsheet perfectly configured. Otherwise you can always check the date ranges on each sheet to make sure.\n\n\n\nThe great advantages of Data Studio.\n\n\n\nAs you can see, Data Studio is a versatile tool that is easy and intuitive to use. You can easily connect different sources to transform data into a visual and understandable document. Another strong point is the high degree of customization it allows for each report, which can also be updated in real time.\n\n\n\nIn short, it saves time and headaches and facilitates communication between partners. Thanks to Data Studio you will be able to share and collaborate with your work team and with your clients. We hope this brief review has been helpful. Now all that's left to do is to play around and test your own dashboards - unleash your reports in Data Studio! There is still a lot to explore ;-)<\/p>","protected":false},"author":42,"featured_media":19025,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[44,22,28],"tags":[84,80],"class_list":["post-18412","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-facebook","category-marketing-online","category-social-media","tag-analitica","tag-google"],"_links":{"self":[{"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/posts\/18412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/users\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/comments?post=18412"}],"version-history":[{"count":1,"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/posts\/18412\/revisions"}],"predecessor-version":[{"id":232179,"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/posts\/18412\/revisions\/232179"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/media\/19025"}],"wp:attachment":[{"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/media?parent=18412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/categories?post=18412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.geotelecom.mx\/en\/wp-json\/wp\/v2\/tags?post=18412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}