{"id":17172,"date":"2021-03-11T13:17:24","date_gmt":"2021-03-11T11:17:24","guid":{"rendered":"https:\/\/www.dase-analytics.com\/blog\/?p=17172\/"},"modified":"2021-10-26T15:35:07","modified_gmt":"2021-10-26T13:35:07","slug":"parametre-v-data-studiu-nova-ficura-ktoru-si-zamilujete","status":"publish","type":"post","link":"https:\/\/www.dase-analytics.com\/blog\/sk\/parametre-v-data-studiu-nova-ficura-ktoru-si-zamilujete\/","title":{"rendered":"Parametre v Data Studiu &#8211; nov\u00e1 fi\u010d\u00fara, ktor\u00fa si zamilujete"},"content":{"rendered":"<p>Zmienku o parametroch, novej in\u0161tancii v Data Studiu sme v\u00e1m priniesli u\u017e <a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/analytics-news-august2020\/\" target=\"_blank\" rel=\"noopener noreferrer\">v augustov\u00fdch NEWS<\/a>. Aj ke\u010f s\u00fa tu s nami parametre u\u017e vy\u0161e pol roka, zatia\u013e si ich pou\u017e\u00edvanie osvojilo len zanedbate\u013en\u00e9 mno\u017estvo pou\u017e\u00edvate\u013eov. Prizn\u00e1m sa, \u017ee my v DASE sme im tie\u017e neprikladali to\u013eko pozornosti ako by si zasl\u00fa\u017eili. Pevne ver\u00edm, \u017ee v\u00e1s parametre zaujm\u00fa nato\u013eko, \u017ee sa stan\u00fa pevnou s\u00fa\u010das\u0165ou va\u0161ich, e\u0161te viac dynamick\u00fdch reportov.<\/p>\n<h2>\u010co s\u00fa to parametre a ako ich pou\u017e\u00edva\u0165<\/h2>\n<p>Parametre si m\u00f4\u017eete predstavi\u0165 ako <strong>premenn\u00fa, ktor\u00e1 uchov\u00e1va ur\u010dit\u00fa, u\u017e\u00edvate\u013eom zadefinovan\u00fa hodnotu<\/strong>. M\u00f4\u017eete si to predstavi\u0165 na hodnote KPI, ktor\u00e1 sa m\u00f4\u017ee \u010dasom meni\u0165. Bez parametrov ste mali dve mo\u017enosti &#8211; bu\u010f prer\u00e1tava\u0165 v\u0161etky kalkulovan\u00e9 metriky fixnou hodnotou, alebo rie\u0161i\u0165 kalkul\u00e1ciu e\u0161te pred vstupom do Data Studia, napr\u00edklad v Google Sheets. Ak sa \u010dasom hodnota KPI zmenila, nastal probl\u00e9m a vy ste museli bu\u010f zmeni\u0165 vzorce pre kalkulovan\u00e9 metriky, alebo upravova\u0165 Google Sheets. Ako to teda automatizova\u0165? Tu\u0161\u00edte spr\u00e1vne &#8211; parametrami.<\/p>\n<p>Toto je v\u0161ak len jedna z mo\u017enost\u00ed, ako parametre pou\u017e\u00edva\u0165. Pod\u013ea m\u00f4jho n\u00e1zoru najjednoduch\u0161ia na pochopenie s naj\u0161ir\u0161\u00edmi mo\u017enos\u0165ami vyu\u017eitia. Vo v\u0161eobecnosti m\u00f4\u017eete <strong>parametre v Data Studiu<\/strong> vyu\u017ei\u0165 na:<\/p>\n<ul>\n<li>dynamick\u00e9 prepo\u010dty s hodnotami, ktor\u00e9 si s\u00e1m u\u017e\u00edvate\u013e zadefinuje (toto je t\u00e9ma tohto blogu)<\/li>\n<li>dynamick\u00e9 prepo\u010dty s hodnotami, ktor\u00e9 s\u00fa zadan\u00e9 v URL adrese reportu<\/li>\n<li>sp\u00e4tn\u00e9 odovzdanie inform\u00e1cie do SQL dotazu pre BigQuery<\/li>\n<li>sp\u00e4tn\u00e9 odovzdanie inform\u00e1cie do komunitn\u00e9ho konektora<\/li>\n<\/ul>\n<h2>Pr\u00edklad pou\u017eitia parametrov: dynamick\u00e1 hodnota KPI<\/h2>\n<p>Aby ste si lep\u0161ie vedeli predstavi\u0165, \u010do vlastne rob\u00edme, za\u010dnime v\u00fdsledkom n\u00e1\u0161ho sna\u017eenia, ktor\u00fdm je tento jednoduch\u00fd report:<\/p>\n<p><a href=\"https:\/\/datastudio.google.com\/reporting\/e629e7e9-16bd-4ebe-a2a2-2af6de8aaaed\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignright wp-image-17182 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/parameters-data-studio.png\" alt=\"Parameters KPI report Data studio\" width=\"1402\" height=\"647\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/parameters-data-studio.png 1402w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/parameters-data-studio-300x138.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/parameters-data-studio-1024x473.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/parameters-data-studio-600x277.png 600w\" sizes=\"(max-width: 1402px) 100vw, 1402px\" \/><\/a><\/p>\n<p>Pou\u017e\u00edvanie je, d\u00fafam, viac ne\u017e intuit\u00edvne. Sta\u010d\u00ed zmeni\u0165 hodnotu KPI a v grafe sa v\u00e1m zv\u00fdraznia tie dni, v ktor\u00fdch bola n\u00e1v\u0161tevnos\u0165 vy\u0161\u0161ia ako vami zadan\u00e9 KPI. Po\u010fme sa pozrie\u0165 na to, ako tak\u00fdto report postavi\u0165.<\/p>\n<h3>1. Vytvorenie parametra KPI<\/h3>\n<p>Parameter vytvor\u00edte, podobne ako vlastn\u00fa kalkulovan\u00fa metriku \u010di dimenziu vo va\u0161om d\u00e1tovom zdroji: <strong>Resource &gt; Manage added data sources<\/strong>, kde n\u00e1jdete v pravom hornom rohu tla\u010didlo <strong>+ ADD A PARAMETER<\/strong>. N\u00e1\u0161 parameter bude vyzera\u0165 takto:<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/parameter-data-studio-setup.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\" img-shadow aligncenter wp-image-17185\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/parameter-data-studio-setup.png\" alt=\"nastavenie parametrov v Data Studiu\" width=\"516\" height=\"391\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/parameter-data-studio-setup.png 565w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/parameter-data-studio-setup-300x227.png 300w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<p>Aby sme docielili vizu\u00e1lny efekt, kedy bud\u00fa hodnoty nad referen\u010dnou \u010diarou zobrazen\u00e9 inou farbou, potrebujeme rozdeli\u0165 na\u0161u metriku, v tomto pr\u00edpade Po\u010det rel\u00e1cii (Sessions) na 2 \u010dasti &#8211; spodn\u00fa pre hodnoty pod referen\u010dnou \u010diarou a horn\u00fa pre hodnoty nad \u0148ou. Toto docielime prostredn\u00edctvom dvoch kalkulovan\u00fdch metr\u00edk.<\/p>\n<h2>2. Spodn\u00e1 \u010das\u0165 pre hodnoty pod referen\u010dnou \u010diarou<\/h2>\n<p>Vlastn\u00fa kalkulovan\u00fa metriku si vytvor\u00edte op\u00e4\u0165 vo va\u0161om d\u00e1tovom zdroji: <strong>Resource &gt; Manage added data sources<\/strong>, kde n\u00e1jdete v pravom hornom rohu tla\u010didlo <strong>+ ADD A FIELD<\/strong>. Pou\u017eijeme jednoduch\u00e9 vo funkcii CASE, kedy budeme porovn\u00e1va\u0165 po\u010det Sessions s hodnotou KPI. Vytvoren\u00e1 metrika bude vyzera\u0165 takto:<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-under.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"img-shadow aligncenter wp-image-17188 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-under.png\" alt=\"sessions under parameter reference line\" width=\"1075\" height=\"613\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-under.png 1075w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-under-300x171.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-under-1024x584.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-under-600x342.png 600w\" sizes=\"(max-width: 1075px) 100vw, 1075px\" \/><\/a><\/p>\n<h2>3. Horn\u00e1 \u010das\u0165 pre hodnoty nad referen\u010dnou \u010diarou<\/h2>\n<p>Analogicky budeme postupova\u0165 aj v pr\u00edpade druhej vlastnej kalkulovanej metriky pre hodnoty nad referen\u010dnou \u010diarou. Kalkulovan\u00e1 metrika bude vyzera\u0165 nasledovne<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-above.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"img-shadow aligncenter wp-image-17191 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-above.png\" alt=\"sessions parameter data studio\" width=\"1075\" height=\"613\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-above.png 1075w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-above-300x171.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-above-1024x584.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/sessions-above-600x342.png 600w\" sizes=\"(max-width: 1075px) 100vw, 1075px\" \/><\/a><\/p>\n<h2>4. Vytvorenie st\u013apcov\u00e9ho grafu<\/h2>\n<p>Teraz m\u00e1me v\u0161etko potrebn\u00e9 na to, aby sme mohli prist\u00fapi\u0165 k vytvoreniu samotn\u00e9ho reportu. Pou\u017eijeme skladan\u00fd st\u013apcov\u00fd graf, pri\u010dom je d\u00f4le\u017eit\u00e9 zachova\u0165 poradie metr\u00edk &#8211; najsk\u00f4r spodn\u00e1 \u010das\u0165 a potom vrchn\u00e1. Referen\u010dn\u00e1 \u010diara sa nastavuje\u00a0 na karte <strong>\u0160t\u00fdl (Style)<\/strong>, kde si zvol\u00edte parameter vytvoren\u00fd v prvom kroku.<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/report-data-studio-parameter.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"img-shadow alignright wp-image-17193 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/report-data-studio-parameter.png\" alt=\"parameter reference line data studio\" width=\"1839\" height=\"732\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/report-data-studio-parameter.png 1839w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/report-data-studio-parameter-300x119.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/report-data-studio-parameter-1024x408.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/report-data-studio-parameter-1536x611.png 1536w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/report-data-studio-parameter-600x239.png 600w\" sizes=\"(max-width: 1839px) 100vw, 1839px\" \/><\/a><\/p>\n<h2>5. Pridanie ovl\u00e1dacieho prvku<\/h2>\n<p>Nakoniec prid\u00e1me ovl\u00e1dac\u00ed prvok typu input box (m\u00f4\u017eete pou\u017ei\u0165 aj Slider) pre nami vytvoren\u00fd parameter, ktor\u00fdm bude u\u017e\u00edvate\u013e ovl\u00e1da\u0165 hodnotu parametra. Ten sa nach\u00e1dza medzi filtrami: <strong>Add a control &gt; Input box<\/strong>, resp. <strong>Add a control &gt; Slider<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-input-box.png\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignright wp-image-17200 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-input-box.png\" alt=\"input box data studio\" width=\"1920\" height=\"716\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-input-box.png 1920w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-input-box-300x112.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-input-box-1024x382.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-input-box-1536x573.png 1536w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/data-studio-input-box-600x224.png 600w\" sizes=\"(max-width: 1920px) 100vw, 1920px\" \/><\/a><\/p>\n<h2>Pre\u010do pou\u017e\u00edva\u0165 parametre?<\/h2>\n<p>Ako vid\u00edte na tomto jednoduchom pr\u00edklade, v\u010faka pou\u017eit\u00e9mu parametru je report interakt\u00edvnej\u0161\u00ed. Samozrejme, mo\u017enosti pou\u017eitia parametrov s\u00fa \u010faleko v\u00e4\u010d\u0161ie, z\u00e1le\u017e\u00ed len na va\u0161ej kreativite a potreb\u00e1ch. Ale o tom u\u017e v niektorom z na\u0161ich \u010fal\u0161\u00edch blogov.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Zmienku o parametroch, novej in\u0161tancii v Data Studiu sme v\u00e1m priniesli u\u017e v augustov\u00fdch NEWS. Aj ke\u010f s\u00fa&#8230;<\/p>\n","protected":false},"author":70,"featured_media":17199,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[639,667],"tags":[],"_links":{"self":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/17172"}],"collection":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/users\/70"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/comments?post=17172"}],"version-history":[{"count":26,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/17172\/revisions"}],"predecessor-version":[{"id":17939,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/17172\/revisions\/17939"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media\/17199"}],"wp:attachment":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media?parent=17172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/categories?post=17172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/tags?post=17172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}