{"id":6463,"date":"2015-03-16T20:21:26","date_gmt":"2015-03-16T19:21:26","guid":{"rendered":"https:\/\/besteto.pari.cz\/automaticke-reporty-google-docs\/"},"modified":"2021-09-19T18:56:07","modified_gmt":"2021-09-19T16:56:07","slug":"automaticke-reporty-google-docs","status":"publish","type":"post","link":"https:\/\/www.besteto.cz\/automaticke-reporty-google-docs\/","title":{"rendered":"Automatick\u00e9 reporty v Google Docs"},"content":{"rendered":"        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p>Pot\u0159ebujete rychl\u00fd p\u0159ehled, jak si vedou zdroje n\u00e1v\u0161t\u011bvnosti a&nbsp;tr\u017eeb, v&nbsp;porovn\u00e1n\u00ed mezi m\u011bs\u00edci a&nbsp;meziro\u010dn\u011b, bez neust\u00e1l\u00e9ho p\u0159ep\u00edn\u00e1n\u00ed \u010dasov\u00e9ho obdob\u00ed? Nebo v\u00e1m jednodu\u0161e nevyhovuje zobrazen\u00ed dat v&nbsp;Google Analytics (GA)? Zkuste vlastn\u00ed reporty p\u0159\u00edmo v&nbsp;Google Dokumentech (GD). Je to jednoduch\u00e9! Sta\u010d\u00ed si v&nbsp;Google tabulk\u00e1ch p\u0159idat dopln\u011bk <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/google-analytics\/fefimfimnhjjkomigakinmjileehfopp\">Google Analytics<\/a>.<br>A m\u016f\u017eete za\u010d\u00edt. My si takto usnad\u0148ujeme \u017eivot a&nbsp;\u0161et\u0159\u00edme \u010das ji\u017e dlouho.<\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-image my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <div class=\"wp-block-image aligncenter\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.besteto.cz\/wp-content\/uploads\/610_report_ukazka.png\" alt><\/figure><\/div>  <\/div>\n      <\/div>\n        <div class=\"component component-heading my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <h2 class=\"wp-block-heading\">Na co si d\u00e1t&nbsp;pozor<\/h2>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p>Kdy\u017e spou\u0161t\u00edte dopln\u011bk, je pot\u0159eba, abyste m\u011bli nastaveno v&nbsp;nastaven\u00ed tabulky (<em>Soubor &gt; Nastaven\u00ed tabulky\u2026 &gt; N\u00e1rodn\u00ed prost\u0159ed\u00ed<\/em>) zemi, kde se <strong>odd\u011bluje desetinnou te\u010dkou<\/strong> (Spojen\u00e9 st\u00e1ty jsou jistota). Po p\u0159egenerov\u00e1n\u00ed si zase nastavte \u010ceskou republiku.<br>Pokud nasd\u00edl\u00edte p\u0159\u00edstup u\u017eivatel\u016fm, kte\u0159\u00ed nemaj\u00ed p\u0159\u00edstup do dan\u00fdch Analytics, nem\u016f\u017eou si p\u0159egenerovat data.<\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-heading my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <h2 class=\"wp-block-heading\">Prvn\u00ed report<\/h2>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p>Prvn\u00ed report si m\u016f\u017eete vyzkou\u0161et hned po nainstalov\u00e1n\u00ed pomoc\u00ed pr\u016fvodce&nbsp; <em>Dopl\u0148ky &gt; Google Analytics &gt; Create new report.&nbsp;<\/em><\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-html my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <div class=\"aspect-w-16 aspect-h-9\"><iframe title=\"Introduction to the Google Analytics Spreadsheet Add-on\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/azOPpD9yg5Q?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen loading=\"lazy\"><\/iframe><\/div>  <\/div>\n      <\/div>\n        <div class=\"component component-heading my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <h2 class=\"wp-block-heading\">Praktick\u00fd p\u0159ehled zdroj\u016f<\/h2>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p>Zdroje doporu\u010dujeme vyb\u00edrat p\u0159es filtry (\u0159\u00e1dek Filters, segmenty maj\u00ed v\u00edce omezen\u00ed).&nbsp; Po spu\u0161t\u011bn\u00ed report\u016f mus\u00edte d\u00e1t Google trochu \u010dasu, aby data zpracoval, bu\u010fte trp\u011bliv\u00ed. Spu\u0161t\u011bn\u00edm se zpracuj\u00ed v\u0161echny nachystan\u00e9 reporty.<br><img decoding=\"async\" alt src=\"https:\/\/www.besteto.cz\/wp-content\/uploads\/610_reporty.png\"><\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-heading my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <h3 class=\"wp-block-heading\">Povinn\u00e1 pole pro konfiguraci reportu<\/h3>  <\/div>\n      <\/div>\n        <div class=\"component component-list my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <ol class=\"wp-block-list\"><li><em>ID profilu<\/em>, kter\u00e9 v&nbsp;Analytics najdete p\u0159es <em>Spr\u00e1vce &gt; V\u00fdb\u011br dat &gt; Nastaven\u00ed zobrazen\u00ed &gt; ID v\u00fdb\u011bru dat.<\/em><\/li><li><em>Za\u010d\u00e1tek a&nbsp;konec \u010dasov\u00e9ho obdob\u00ed <\/em>(Start Date a&nbsp;End Date), nebo kolik posledn\u00edch dn\u00ed zp\u011bt (Last N&nbsp;Days).<\/li><li><em>Metriky<\/em> (sloupe\u010dky v&nbsp;GA), kter\u00e9 chcete vyt\u00e1hnout (Metrics <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/core\/dimsmets\">https:\/\/developers.google.com\/analytics\/devguides\/reporting\/core\/dimsmets<\/a>)<\/li><\/ol>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p>Doporu\u010dujeme zvolit si i&nbsp;podle jak\u00e9 metriky chcete data \u0159adit (Sort\u2009\u2014\u2009n\u00e1v\u0161t\u011bvnost, tr\u017eby\u2026). Uvid\u00edte nap\u0159\u00edklad, kter\u00e1 jazykov\u00e1 mutace Google v\u00e1m p\u0159in\u00e1\u0161\u00ed nejv\u00edce n\u00e1v\u0161t\u011bv.<\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-image my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <div class=\"wp-block-image aligncenter\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.besteto.cz\/wp-content\/uploads\/610_zdroje.png\" alt><\/figure><\/div>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p>Vysv\u011btlen\u00ed jednotliv\u00fdch \u0159\u00e1dk\u016f pro nastaven\u00ed reportu naleznete zde: <a href=\"https:\/\/developers.google.com\/analytics\/solutions\/google-analytics-spreadsheet-add-on#configuration-parameter-reference\">https:\/\/developers.google.com\/analytics\/solutions\/google-analytics-sprea\u2026<\/a>.<br><br>Po spu\u0161t\u011bn\u00ed (<em>Dopl\u0148ky &gt; Google Analytics &gt; Run reports<\/em>) se v\u00e1m vytvo\u0159\u00ed ve stejn\u00e9m dokumentu nov\u00e9 listy s&nbsp;v\u00fdsledky, a&nbsp;s t\u011bmi u\u017e m\u016f\u017eete pracovat, jak se v\u00e1m zl\u00edb\u00ed. Doporu\u010duji s&nbsp;daty pracovat v&nbsp;nov\u00e9m listu, kter\u00fd si vytvo\u0159\u00edte vy a&nbsp;vygenerovan\u00e9 listy pou\u017e\u00edvat pouze jako zdroj&nbsp;dat.<\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-heading my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <h2 class=\"wp-block-heading\">Podm\u00ednky pro filtrov\u00e1n\u00ed zdroj\u016f<\/h2>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p>Podm\u00ednky m\u016f\u017eete kombinovat.<\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-list my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <ul class=\"wp-block-list\"><li><strong>AND<\/strong> je&nbsp;;<\/li><li><strong>OR<\/strong>&nbsp; je&nbsp;,<\/li><li><strong>Regul\u00e1rn\u00ed v\u00fdraz<\/strong> je =~. P\u0159i vyu\u017e\u00edv\u00e1n\u00ed | m\u016f\u017eete narazit na limit, a&nbsp;tak budete muset podm\u00ednku rozd\u011blit v&nbsp;uk\u00e1zkov\u00e9m reportu nap\u0159. zdroj Referral odkazovan\u00e9 str\u00e1nky.<\/li><li><strong>Negace<\/strong> p\u0159es ! nap\u0159. zdroj neobsahuje krtka a&nbsp;z\u00e1rove\u0148 \u017e\u00ed\u017ealu ano -&gt; <em>ga:source !~ (krtek); ga:source =~ (\u017e\u00ed\u017eala)<\/em><\/li><li><strong>P\u0159esn\u00e1 shoda<\/strong> je&nbsp;==<\/li><\/ul>  <\/div>\n      <\/div>\n        <div class=\"component component-heading my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <h2 class=\"wp-block-heading\">Vzorov\u00fd report<\/h2>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p>V\u00edce odkouk\u00e1te ve vzorov\u00e9m dokument\u016f <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/188OcrolWVgHia4_v8SLv1W3AJNLOjMrZNEs-Df9DjOs\/edit?usp=sharing\">zde<\/a>, kter\u00fd si zkop\u00edrujte (<em>Soubor &gt; Vytvo\u0159it kopii<\/em>) a&nbsp;za\u010dn\u011bte s&nbsp;experimenty&nbsp;;)<\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-image my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <div class=\"wp-block-image aligncenter\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.besteto.cz\/wp-content\/uploads\/610_graf.png\" alt><\/figure><\/div>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p><strong>Seznam prom\u011bnn\u00fdch<\/strong> pou\u017eiteln\u00fdch p\u0159i sestavov\u00e1n\u00ed report\u016f: <a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/core\/dimsmets\">https:\/\/developers.google.com\/analytics\/devguides\/reporting\/core\/dimsmets<\/a><br>Pokud pou\u017eijete posledn\u00edch N&nbsp;dn\u00ed, m\u016f\u017eete vyu\u017e\u00edt mo\u017enosti automatick\u00e9ho spou\u0161t\u011bn\u00ed report\u016f a&nbsp;u\u0161et\u0159\u00edte si \u010das p\u0159egenerov\u00e1v\u00e1n\u00edm.<\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p>Dal\u0161\u00ed inspiraci najdete u&nbsp;<a href=\"http:\/\/blog.adamjurak.cz\/tydenni-smajlikovy-report\/\">Adama Jur\u00e1ka<\/a>.<br><br>Jak si vytvo\u0159it vlastn\u00ed dashboard, ukazuje s\u00e1m Google v&nbsp;tomto videu.<\/p>  <\/div>\n      <\/div>\n        <div class=\"component component-html my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <div class=\"aspect-w-16 aspect-h-9\"><iframe title=\"Building a dashboard with the Google Analytics Spreadsheet Add-on\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/N_Ok0rJwj2U?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen loading=\"lazy\"><\/iframe><\/div>  <\/div>\n      <\/div>\n        <div class=\"component component-paragraph my-6\">\n                  <div class=\"prose prose-lg prose-primary prose-center\">\n  <p><strong>Pou\u017e\u00edv\u00e1te tento dopln\u011bk? Inspirujte n\u00e1s a&nbsp;uka\u017ete n\u00e1m sv\u00e9 automatick\u00e9 reporty a&nbsp;dashboardy.<\/strong><br>&nbsp;<\/p>  <\/div>\n      <\/div>\n","protected":false},"excerpt":{"rendered":"<p>Pot\u0159ebujete rychl\u00fd p\u0159ehled, jak si vedou zdroje n\u00e1v\u0161t\u011bvnosti a&nbsp;tr\u017eeb, v&nbsp;porovn\u00e1n\u00ed mezi m\u011bs\u00edci a&nbsp;meziro\u010dn\u011b, bez neust\u00e1l\u00e9ho p\u0159ep\u00edn\u00e1n\u00ed \u010dasov\u00e9ho obdob\u00ed? Nebo v\u00e1m jednodu\u0161e nevyhovuje zobrazen\u00ed dat v&nbsp;Google Analytics (GA)? Zkuste vlastn\u00ed reporty p\u0159\u00edmo v&nbsp;Google Dokumentech (GD). Je to jednoduch\u00e9! Sta\u010d\u00ed si v&nbsp;Google tabulk\u00e1ch p\u0159idat dopln\u011bk Google Analytics.A m\u016f\u017eete za\u010d\u00edt. My si takto usnad\u0148ujeme \u017eivot a&nbsp;\u0161et\u0159\u00edme \u010das ji\u017e [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":6464,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-6463","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.besteto.cz\/wp-json\/wp\/v2\/posts\/6463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.besteto.cz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.besteto.cz\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.besteto.cz\/wp-json\/wp\/v2\/comments?post=6463"}],"version-history":[{"count":0,"href":"https:\/\/www.besteto.cz\/wp-json\/wp\/v2\/posts\/6463\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.besteto.cz\/wp-json\/wp\/v2\/media\/6464"}],"wp:attachment":[{"href":"https:\/\/www.besteto.cz\/wp-json\/wp\/v2\/media?parent=6463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.besteto.cz\/wp-json\/wp\/v2\/categories?post=6463"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.besteto.cz\/wp-json\/wp\/v2\/tags?post=6463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}