{"id":19772,"date":"2024-02-15T15:52:11","date_gmt":"2024-02-15T13:52:11","guid":{"rendered":"https:\/\/www.dase-analytics.com\/blog\/?p=19772\/"},"modified":"2024-02-22T16:28:51","modified_gmt":"2024-02-22T14:28:51","slug":"ako-si-ulozit-data-z-universal-analytics-v-2024","status":"publish","type":"post","link":"https:\/\/www.dase-analytics.com\/blog\/sk\/ako-si-ulozit-data-z-universal-analytics-v-2024\/","title":{"rendered":"Ako si ulo\u017ei\u0165 d\u00e1ta z Universal Analytics v 2024"},"content":{"rendered":"<p><strong>Google po zastaven\u00ed spracov\u00e1vania d\u00e1t od minul\u00e9ho roka u\u017e kone\u010dne ohl\u00e1sil aj odstr\u00e1nenie d\u00e1t z Universal analytics na 30. j\u00fana 2024!<\/strong><\/p>\n<p>Pravdepodobne ste si to v\u0161ak ani nev\u0161imli, ke\u010f\u017ee d\u00e1ta sa do Universal Analytics u\u017e nieko\u013eko mesiacov nesprac\u00favaj\u00fa&#8230;.<\/p>\n<p>Samozrejme, m\u00e1lokto si dnes st\u00edha kontrolova\u0165 performance str\u00e1nky pod\u013ea historick\u00fdch d\u00e1t, ale prep\u00e1snu\u0165 posledn\u00fa \u0161ancu pred ich \u00fapln\u00fdm vymazan\u00edm by\u00a0 mohla by\u0165 chyba. Najm\u00e4 ak m\u00e1te k dispoz\u00edcii roky nameran\u00fdch n\u00e1v\u0161tev a v\u00fdkonnosti va\u0161ich produktov ktor\u00e9 st\u00e1le m\u00f4\u017eu posl\u00fa\u017ei\u0165 ako <strong>benchmarky<\/strong> bud\u00faceho v\u00fdvoja meran\u00ed.<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zaloha-UA.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-19777 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zaloha-UA.png\" alt=\"zaloha UA DASE BLOG\" width=\"1394\" height=\"599\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zaloha-UA.png 1394w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zaloha-UA-300x129.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zaloha-UA-1024x440.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/zaloha-UA-600x258.png 600w\" sizes=\"(max-width: 1394px) 100vw, 1394px\" \/><\/a><\/p>\n<p>Pozrime sa teda spolo\u010dne na to, ako sa od n\u00e1\u0161ho <a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/ako-uchovat-universal-analytics-data\/\" target=\"_blank\" rel=\"noopener\">posledn\u00e9ho \u010dl\u00e1nku<\/a> zmenili inform\u00e1cie a \u010do v\u0161etko m\u00f4\u017eeme dnes archivova\u0165<\/p>\n<h2>1. Ak\u00e9 d\u00e1ta budem potrebova\u0165?<\/h2>\n<p>Ak pravidelne pracujete s meraniami nebude pre v\u00e1s probl\u00e9m vybra\u0165 si aspo\u0148 <strong>3 z\u00e1kladn\u00e9 reporty<\/strong>, ktor\u00e9 pou\u017e\u00edvate naj\u010dastej\u0161ie. Ak by ste s t\u00fdm predsalen mali probl\u00e9m tak v\u00e1m ur\u010dite odpor\u00fa\u010dam pripomen\u00fa\u0165 si <a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/category\/zaklady-analytiky\/\" target=\"_blank\" rel=\"noopener\">z\u00e1klady analytiky<\/a> na na\u0161om blogu.<\/p>\n<p>Vybra\u0165 si m\u00f4\u017eete z takmer v\u0161etk\u00fdch be\u017ene pou\u017e\u00edvan\u00fdch dimenzii a metr\u00edk, vr\u00e1tane vlastn\u00fdch nastaven\u00ed. Ur\u010dite v\u0161ak odpor\u00fa\u010dam si svoj v\u00fdber overi\u0165 v n\u00e1stroji na <a href=\"https:\/\/ga-dev-tools.google\/dimensions-metrics-explorer\/\" target=\"_blank\" rel=\"noopener\">preh\u013ead merac\u00edch prvkov<\/a> pre Universal Analytics<strong>. Ako pr\u00edklad m\u00f4\u017eeme pou\u017ei\u0165 tri najz\u00e1kladnej\u0161ie preh\u013eady, ktor\u00e9 sa u na\u0161ich klientov pou\u017e\u00edvaj\u00fa naj\u010dastej\u0161ie.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>a)<\/strong> Prv\u00fdm z nich je ur\u010dite report n\u00e1v\u0161tevnosti v sekcii <strong>akviz\u00edcie &gt; n\u00e1v\u0161tevnos\u0165 &gt; zdroj\/medium.<\/strong><\/p>\n<p>V tomto pr\u00edpade by som potreboval archivova\u0165 dimenzie zdroj\/medium, kampa\u0148, skupina kan\u00e1lov a vstupn\u00e9 str\u00e1nky. Na reportovanie v\u00fdkonnosti jednotliv\u00fdch zdrojov n\u00e1v\u0161tevnosti mi posta\u010d\u00ed ak archivujem po\u010dty pou\u017e\u00edvate\u013eov, rel\u00e1cii, bounce rate a po\u010det str\u00e1nok na rel\u00e1ciu<\/p>\n<p>&nbsp;<\/p>\n<p><strong>b)<\/strong> \u010eal\u0161\u00edm je nepochybne report obsahu webu v sekcii <strong>spr\u00e1vanie &gt; obsah str\u00e1nky &gt; v\u0161etky str\u00e1nky.<\/strong><\/p>\n<p>Preh\u013ead str\u00e1nok mi poskytuje ucelen\u00fd preh\u013ead o spr\u00e1van\u00ed pou\u017e\u00edvate\u013eov na mojom webe a preto budem chcie\u0165 ulo\u017ei\u0165 dimenzie ako <strong>str\u00e1nka, dom\u00e9na, titulka str\u00e1nky, cesta str\u00e1nky<\/strong> a <strong>obsahov\u00e1 skupina<\/strong> pr\u00edpadne vlastn\u00e9 dimenziu ktor\u00e9 som nastavil na detailn\u00e9 meranie str\u00e1nok a po\u010dty metr\u00edk ako <strong>zobrazenia, vstupy, odchody, zobrazenie na rel\u00e1ciu, jedinne\u010dn\u00e9 zobrazenia<\/strong> a <strong>priemern\u00fd \u010das na str\u00e1nke.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><strong>c)<\/strong> Samozrejme ur\u010dite budeme potrebova\u0165 report v\u00fdkonnosti produktov na str\u00e1nke, pr\u00edpadne nastaven\u00fdch cie\u013eov v sekcii <strong>konverzie &gt; E-commerce &gt; v\u00fdkonnos\u0165 produktov.<\/strong><\/p>\n<p>V tomto pr\u00edpade budem ur\u010dite chcie\u0165 vidie\u0165 <strong>n\u00e1zvy produktov, kateg\u00f3rie, pr\u00edpadne zna\u010dku spolu s metrikami unik\u00e1tne n\u00e1kupy, kvantita produktu pri n\u00e1kupe, pridania do ko\u0161\u00edka, zobrazenia produktu, obrat z predaja produktu.<\/strong><\/p>\n<p>V pr\u00edpade cie\u013eov mi bude sta\u010di\u0165 v\u00fdber dimenzi\u00ed ako <strong>url adresa<\/strong> a <strong>titulka str\u00e1nky<\/strong> na ktorej sa cie\u013e splnil, ako aj metriky <strong>po\u010det splnen\u00fdch cie\u013eov.<\/strong><\/p>\n<h2>2. Za ak\u00e9 \u010dasov\u00e9 obdobie budeme d\u00e1ta archivova\u0165?<\/h2>\n<p>D\u00f4le\u017eit\u00fdm krokom je ur\u010di\u0165 si granularitu d\u00e1t v z\u00e1vislosti od zamerania v\u00e1\u0161ho webu.<\/p>\n<p><strong>V pr\u00edpade \u017ee m\u00e1te men\u0161iu str\u00e1nku ktor\u00e1 m\u00e1 stabiln\u00fd ale men\u0161\u00ed po\u010det pravideln\u00fdch n\u00e1v\u0161tevn\u00edkov va\u0161ich str\u00e1nok, m\u00f4\u017eete vyu\u017ei\u0165 prepo\u010det metr\u00edk na t\u00fd\u017edennom z\u00e1klade. Ak ste naopak market\u00e9rom ve\u013ek\u00e9ho e-shopu s vysokou fluktu\u00e1ciou pou\u017e\u00edvate\u013eov, tak odpor\u00fa\u010dam archivova\u0165 d\u00e1ta v prepo\u010dtoch za jeden de\u0148.<\/strong><\/p>\n<p>V\u00fdber \u010dasov\u00e9ho \u00faseku v ktorom bud\u00fa d\u00e1ta prepo\u010d\u00edtan\u00e9 je na v\u00e1s, ale ur\u010dite berte do \u00favahy ve\u013ekos\u0165 v\u00e1\u0161ho webu a typ pou\u017e\u00edvate\u013ea, ktor\u00fd str\u00e1nky nav\u0161tevuje. Okrem agreg\u00e1cie d\u00e1t treba ur\u010dite uva\u017eova\u0165 aj nad probl\u00e9mami pri exporte d\u00e1t v pr\u00edpade, \u017ee kombin\u00e1cia dimenzi\u00ed alebo metr\u00edk za agregovan\u00e9 obdobie neexistuje, \u010do m\u00f4\u017ee z\u00e1visie\u0165 od v\u00fdberu \u010dasov\u00e9ho rozmedzia.<\/p>\n<p>Pom\u00f4\u017eem si z\u00e1rove\u0148 aj inform\u00e1ciami od m\u00f4jho kolegu <a href=\"https:\/\/www.youtube.com\/playlist?list=PLauFu5nTU1VW52_07KCqxAZpHOI-9pxWk\" target=\"_blank\" rel=\"noopener\">Petra \u0160utar\u00edka<\/a> ktor\u00fd v predch\u00e1dzaj\u00facom texte o archiv\u00e1cii d\u00e1t spomenul aj probl\u00e9m so samplovan\u00edm d\u00e1t najm\u00e4 v pr\u00edpadoch manu\u00e1lneho exportu:<\/p>\n<p><em>\u201cSamozrejme, \u010d\u00edm ni\u017e\u0161ia granularita, t\u00fdm viac mo\u017enost\u00ed \u2013 d\u00e1ta z jednotliv\u00fdch dn\u00ed viete jednoducho agregova\u0165 nad t\u00fd\u017ed\u0148ami, mesiacmi \u010di rokmi. <\/em><em>\u010c\u00edm v\u0161ak za tento detailn\u00fd export zaplat\u00edte je ve\u013ekos\u0165 tak\u00e9hoto exportu, ktor\u00e9ho ve\u013ekos\u0165 sa exponenci\u00e1lne zvy\u0161uje pridan\u00edm ka\u017edej \u010fal\u0161ej dimenzie.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u00a0Uk\u00e1\u017eme si to na pr\u00edklade:<\/strong><\/p>\n<p><em>Chceme exportova\u0165 po\u010det rel\u00e1ci\u00ed za minul\u00fd rok z jednotliv\u00fdch kan\u00e1lov (r\u00e1tajme s 10 r\u00f4znymi zoskupeniami). Ak vyexportujete d\u00e1ta po mesiacoch, v\u00fdsledn\u00e1 tabu\u013eka bude ma\u0165 maxim\u00e1lne 120 riadkov (12 x 10), pri\u010dom ak ich exportujete po jednotliv\u00fdch d\u0148och, v\u00fdsledn\u00e1 tabu\u013eka bude ma\u0165 a\u017e 3650 riadkov (365 x 10). Pridan\u00edm ka\u017edej \u010fal\u0161ej dimenzie v\u00fdsledn\u00fd po\u010det riadkov zn\u00e1sobuje.<\/em><\/p>\n<p><em>V pr\u00edpade niektor\u00fdch n\u00e1strojov v\u00e1m m\u00f4\u017ee ve\u013ek\u00fd po\u010det riadkov sp\u00f4sobova\u0165 tzv. samplovanie d\u00e1t (vzorkovanie, ke\u010f v\u00fdsledn\u00fd export alebo report obsahuje len men\u0161\u00ed subset d\u00e1t) \u2013 viac o samplovan\u00ed a ako ho m\u00f4\u017eete ob\u00eds\u0165, je pop\u00edsan\u00e9 ni\u017e\u0161ie.\u201d<\/em><\/p>\n<h2>3. Ako budeme d\u00e1ta exportova\u0165?<\/h2>\n<p>V pr\u00edpade, \u017ee u\u017e m\u00e1me predstavu ak\u00e9 d\u00e1ta budeme chcie\u0165 archivova\u0165 m\u00f4\u017eeme prejs\u0165 k procesu samotnej archiv\u00e1cie. V tomto momente je dobre si u\u017e aj premyslie\u0165 ako d\u00e1ta uskladn\u00edme aby sme k nim mali efekt\u00edvny pr\u00edstup. Mo\u017enosti ako d\u00e1ta exportova\u0165 sa odli\u0161uj\u00fa pod\u013ea technickej n\u00e1ro\u010dnosti a \u0161k\u00e1lovate\u013enosti v pr\u00edpade v\u00e4\u010d\u0161\u00edch \u010dasov\u00fdch \u00fasekov.<\/p>\n<h3>Manu\u00e1lny export d\u00e1t<\/h3>\n<p>Najz\u00e1kladnej\u0161\u00ed postup ako d\u00e1ta archivova\u0165 je exportom vybran\u00e9ho obdobia v reporte alebo vytvoren\u00edm vlastn\u00e9ho reportu ktor\u00fd bude obsahova\u0165 kombin\u00e1ciu vybran\u00fdch dimenzi\u00ed a metr\u00edk. <strong>Nev\u00fdhodou tohto postupu je najm\u00e4 jeho \u010dasov\u00e1 n\u00e1ro\u010dnos\u0165.<\/strong><\/p>\n<p>Napr\u00edklad v pr\u00edpade, \u017ee by sme chceli d\u00e1ta za posledn\u00fdch 5 rokov pri t\u00fd\u017edennej agreg\u00e1cii by sme museli urobi\u0165 <strong>260<\/strong> samostatn\u00fdch s\u00faborov. Ka\u017ed\u00e1 tak\u00e1to aktivita navy\u0161e predstavuje potencion\u00e1lnu chybu, ktor\u00e1 sa v\u00e4\u010d\u0161inou objav\u00ed a\u017e pri anal\u00fdze d\u00e1t.<\/p>\n<p><strong>a) Vytvorte si vlastn\u00fd report v ktorom nastav\u00edte \u017eelan\u00fa kombin\u00e1ciu dimenzii a metr\u00edk<\/strong><\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-39.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-19773 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-39.png\" alt=\"zaloha UA DASE BLOG2\" width=\"1606\" height=\"627\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-39.png 1606w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-39-300x117.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-39-1024x400.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-39-1536x600.png 1536w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/2-39-600x234.png 600w\" sizes=\"(max-width: 1606px) 100vw, 1606px\" \/><\/a><\/p>\n<p><strong>b) Pri zobrazen\u00ed vlastn\u00e9ho reportu upravte \u010dasov\u00e9 obdobie na \u00farove\u0148 vybranej agreg\u00e1cie<\/strong><\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-32.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-19774 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-32.png\" alt=\"zaloha UA DASE BLOG3\" width=\"1636\" height=\"846\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-32.png 1636w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-32-300x155.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-32-1024x530.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-32-1536x794.png 1536w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/3-32-600x310.png 600w\" sizes=\"(max-width: 1636px) 100vw, 1636px\" \/><\/a><\/p>\n<p><strong>c) V pravom hornom rohu n\u00e1jdete tla\u010didlo <em>\u201cexport\u201d <\/em>pri\u010dom si vyberte typ s\u00faboru<\/strong><\/p>\n<h3>Google Analytics API<\/h3>\n<p>Technicky n\u00e1ro\u010dnej\u0161\u00ed postup je pridanie roz\u0161\u00edrenia v <strong>Google Sheets pre Google Analytics<\/strong> ktor\u00e9 pou\u017e\u00edva API. V\u00fdhodou je automatizovan\u00fd export d\u00e1t priamo do tabu\u013eky, ktor\u00e1 sa d\u00e1 \u010falej prepoji\u0165 napr\u00edklad s n\u00e1strojom <a href=\"https:\/\/www.dase-analytics.com\/sk\/looker-studio-online-kurz\/\" target=\"_blank\" rel=\"noopener\">Looker studio<\/a>.<\/p>\n<p><strong>Pre niektor\u00fdch pou\u017e\u00edvate\u013eov m\u00f4\u017ee v\u0161ak v\u00fdber dimenzi\u00ed a metr\u00edk cez toto roz\u0161\u00edrenie predstavova\u0165 probl\u00e9m,<\/strong> ke\u010f\u017ee je potrebn\u00e9 porozumenie dimenzi\u00e1m a metrik\u00e1m na \u00farovni ich prepo\u010dtov. Z\u00e1rove\u0148 by pou\u017e\u00edvatelia mali by\u0165 vyzbrojen\u00ed trpezlivos\u0165ou ak naraz\u00edte na \u0161pecifick\u00e9 probl\u00e9my ako neval\u00eddne kombin\u00e1cie dimenzi\u00ed a metr\u00edk, alebo ch\u00fdbaj\u00face z\u00e1znamy bez merania.<\/p>\n<p><strong>1. Otvorte si nov\u00fd h\u00e1rok v Google Sheets<\/strong><\/p>\n<p><strong>2. V hornom menu vyberte <em>\u201croz\u0161\u00edrenia\u201d<\/em> a rozkliknite <em>\u201cz\u00edskanie roz\u0161\u00edrenia\u201d<\/em><\/strong><\/p>\n<p><strong>3. Vyh\u013eadajte roz\u0161\u00edrenie Google Analytics a nain\u0161talujte<\/strong><\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-29.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-19775 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-29.png\" alt=\"zaloha UA DASE BLOG4\" width=\"1006\" height=\"890\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-29.png 1006w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-29-300x265.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/4-29-600x531.png 600w\" sizes=\"(max-width: 1006px) 100vw, 1006px\" \/><\/a><\/p>\n<p><strong>4. Spustite n\u00e1stroj z menu <em>\u201croz\u0161\u00edrenia\u201d <\/em>a kliknut\u00edm na <em>\u201cGoogle Analytics\u201d<\/em>\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/5-24.png\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-19776 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/5-24.png\" alt=\"zaloha UA DASE BLOG5\" width=\"1834\" height=\"822\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/5-24.png 1834w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/5-24-300x134.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/5-24-1024x459.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/5-24-1536x688.png 1536w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/5-24-600x269.png 600w\" sizes=\"(max-width: 1834px) 100vw, 1834px\" \/><\/a><\/p>\n<p><strong>5. Vyberte val\u00eddne kombin\u00e1cie dimenzi\u00ed, metr\u00edk a \u010dasov\u00e9ho obdobia<\/strong><\/p>\n<h3>Extern\u00e9 n\u00e1stroje<\/h3>\n<p>Najefekt\u00edvnej\u0161\u00edm sp\u00f4sobom ako d\u00e1ta exportova\u0165 a spracova\u0165 je pou\u017eitie extern\u00e9ho konektoru, napr. Supermetrics. Tie m\u00f4\u017eu d\u00e1ta exportova\u0165 priamo do datab\u00e1zy odkia\u013e sa m\u00f4\u017eu prepoji\u0165 s reportovac\u00edm programom.<\/p>\n<p>Prek\u00e1\u017ekou m\u00f4\u017ee by\u0165 ich cenov\u00e1 dostupnos\u0165 a syst\u00e9m pou\u017eitia. V takom pr\u00edpade v\u00e1m odpor\u00fa\u010dam n\u00e1s kontaktova\u0165 a radi v\u00e1m pom\u00f4\u017ee s procesom z\u00e1lohy od v\u00fdberu dimenzii a metr\u00edk a\u017e po zobrazenie archivovan\u00fdch d\u00e1t v n\u00e1stroji Looker Studio.<\/p>\n<p>Pokojne n\u00e1m nap\u00ed\u0161te \u010do potrebujete na adresu <strong>cibula@dase.sk<\/strong><\/p>\n<h2>4. Kde budeme d\u00e1ta uchov\u00e1va\u0165?<\/h2>\n<p><strong>Ak sme \u00faspe\u0161ne exportovali vybran\u00e9 reporty, mus\u00edme si teraz premyslie\u0165 kde budeme tieto nuly a jednotky skladova\u0165 aby sme ich nesk\u00f4r mohli v pr\u00edpade potreby aj akt\u00edvne analyzova\u0165.<\/strong><\/p>\n<p>Aj v tomto kroku m\u00e1me na v\u00fdber viacero mo\u017enost\u00ed v z\u00e1vislosti od vybran\u00e9ho sp\u00f4sobu exportu d\u00e1t a \u017eelan\u00fdm sp\u00f4sobom ich zobrazenia.<\/p>\n<h3>BigQuery<\/h3>\n<p>Najefekt\u00edvnej\u0161ia mo\u017enos\u0165 ako uchova\u0165 a aj akt\u00edvne vyu\u017ei\u0165 d\u00e1ta z va\u0161ej Universal Analytics property je pr\u00e1ve n\u00e1stroj <a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/zalozenie-bigquery\/\" target=\"_blank\" rel=\"noopener\">BigQuery ktor\u00fd je s\u00fa\u010das\u0165ou Google Cloud<\/a>.<\/p>\n<p>V pr\u00edpade, \u017ee akt\u00edvne spravujete va\u0161e reklamn\u00e9 \u00fa\u010dty a m\u00e1te pr\u00edstup k firemnej karte, nemal by by\u0165 pre v\u00e1s zalo\u017eenie projektu probl\u00e9m. V\u00fdhodou tohto postupu je mo\u017enos\u0165 efekt\u00edvne analyzova\u0165 d\u00e1ta v datab\u00e1ze pomocou programovacieho jazyka<strong> SQL<\/strong>. Z\u00e1rove\u0148 je pri vynalo\u017een\u00ed men\u0161ej n\u00e1mahy mo\u017en\u00e9 prepojenie exportov z GA4 s va\u0161imi archivovan\u00fdmi meraniami.<\/p>\n<h3>Google Sheets<\/h3>\n<p>Ke\u010f\u017ee m\u00e1me viacero mo\u017enost\u00ed ako d\u00e1ta exportova\u0165 do tabu\u013ekov\u00fdch form\u00e1tov asi nikoho neprekvap\u00ed, \u017ee jeden zo sp\u00f4sobov uchovania d\u00e1t je aj n\u00e1stroj Google Sheets.<\/p>\n<p>Ve\u013ekou v\u00fdhodou tohto n\u00e1stroja je jeho pr\u00edstupnos\u0165 aj pre menej technicky zdatn\u00fdch kolegov, ktor\u00fd si v\u0161ak vedia poradi\u0165 s riadkami a st\u013apcami klasickej tabulky, pr\u00edpadne spusti\u0165 pokro\u010dilej\u0161ie funkcie na anal\u00fdzu d\u00e1t.<\/p>\n<p>Pri ve\u013ek\u00fdch exportoch, napr\u00edklad v podobe \u0161irok\u00e9ho \u010dasov\u00e9ho \u00faseku na z\u00e1klade denn\u00fdch prepo\u010dtov, m\u00f4\u017ee vznikn\u00fa\u0165 a\u017e prive\u013ea riadkov ktor\u00e9 m\u00f4\u017eu dokonca aj dosiahnu\u0165 maxim\u00e1lnu kapacitu tabu\u013eky, \u010do vlastne zabra\u0148uje v efekt\u00edvnom spracovan\u00ed t\u00fdchto \u00fadajov.<\/p>\n<h3>D\u00e1tov\u00e9 s\u00fabory<\/h3>\n<p>Najz\u00e1kladnej\u0161\u00edm sp\u00f4sobom ako d\u00e1ta uchova\u0165 je s\u00fabor typu <strong>.csv<\/strong>, <strong>.tsv<\/strong> a podobne.<\/p>\n<p>Prirodzen\u00e1 v\u00fdhoda jednoduchost t\u00fdchto form\u00e1tov je z\u00e1rove\u0148 aj ich men\u0161\u00edm nedostatkom. S\u00fabory toti\u017e musia by\u0165 aj tak\u00a0 niekde ulo\u017een\u00e9, \u010di u\u017e priamo na disku alebo na zdie\u013eanom \u00falo\u017eisku a ich anal\u00fdza si vy\u017eaduje opakovan\u00fd import.<\/p>\n<p>Samozrejme inak pristupujeme k d\u00e1tam ktor\u00e9 m\u00e1me efekt\u00edvne pr\u00edstupn\u00e9 na anal\u00fdzu v porovnan\u00ed so s\u00faborom ktor\u00fd je ulo\u017een\u00fd a zapad\u00e1 prachom na disku.<\/p>\n<h2><strong>Potrebujete pom\u00f4c\u0165?<\/strong><\/h2>\n<p>V\u0161etky vlastn\u00edctva v slu\u017ebe Universal Analytics toti\u017eto bud\u00fa v roku 2024 bez n\u00e1hrady vymazan\u00e9.<\/p>\n<p>V DASE si toto riziko plne uvedomujeme, a tak sme poctivo prist\u00fapili k v\u00fdvoju syst\u00e9mu na z\u00e1lohu d\u00e1t.<\/p>\n<p>Na\u0161e rie\u0161enie je ide\u00e1lne pre v\u0161etk\u00fdch, ktor\u00ed chc\u00fa rie\u0161i\u0165 z\u00e1lohu d\u00e1t z Universal Analytics komplexne, bez potreby zap\u00e1ja\u0165 vlastn\u00fdch d\u00e1tov\u00fdch in\u017einierov, webov\u00fdch analytikov, \u010di developersk\u00fd t\u00edm.<\/p>\n<p>Ak by v\u00e1s zauj\u00edmalo viac, <a href=\"https:\/\/www.dase-analytics.com\/sk\/zalohovanie-dat-z-universal-analytic\" target=\"_blank\" rel=\"noopener\">v\u0161etko info n\u00e1jdete na str\u00e1nke tu.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google po zastaven\u00ed spracov\u00e1vania d\u00e1t od minul\u00e9ho roka u\u017e kone\u010dne ohl\u00e1sil aj odstr\u00e1nenie d\u00e1t z Universal analytics na&#8230;<\/p>\n","protected":false},"author":71,"featured_media":19782,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[803,640],"tags":[779,953,952,948,950,951],"_links":{"self":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/19772"}],"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\/71"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/comments?post=19772"}],"version-history":[{"count":5,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/19772\/revisions"}],"predecessor-version":[{"id":19785,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/19772\/revisions\/19785"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media\/19782"}],"wp:attachment":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media?parent=19772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/categories?post=19772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/tags?post=19772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}