{"id":17408,"date":"2021-05-19T09:55:17","date_gmt":"2021-05-19T07:55:17","guid":{"rendered":"https:\/\/www.dase-analytics.com\/blog\/?p=17408\/"},"modified":"2021-06-24T16:41:13","modified_gmt":"2021-06-24T14:41:13","slug":"10-dovodov-preco-prepoji-google-analytics-4-s-bigquery-este-dnes","status":"publish","type":"post","link":"https:\/\/www.dase-analytics.com\/blog\/sk\/10-dovodov-preco-prepoji-google-analytics-4-s-bigquery-este-dnes\/","title":{"rendered":"10 d\u00f4vodov, pre\u010do prepoji\u0165 Google Analytics 4 s BigQuery e\u0161te dnes"},"content":{"rendered":"

Aj vy m\u00e1te pocit, \u017ee BigQuery<\/a> sa st\u00e1va ak\u00fdmsi buzzwordom v analytickom svete? Ak ste s BigQuery e\u0161te nepracovali, tento pocit m\u00e1te opr\u00e1vnene. BigQuery je proste pojem, o ktorom ka\u017ed\u00fd hovor\u00ed (aj ke\u010f ho mo\u017eno nikto nikdy nevidel). V tomto \u010dl\u00e1nku sa dozviete, pre\u010do je to tak a pre\u010do je dobr\u00fd n\u00e1pad ho za\u010da\u0165 pou\u017e\u00edva\u0165 pr\u00e1ve s Google Analytics 4.<\/strong><\/p>\n

Ak e\u0161te o BigQuery ve\u013ea inform\u00e1ci\u00ed nem\u00e1te, odpor\u00fa\u010dam v\u00e1m tento star\u0161\u00ed \u010dl\u00e1nok od kolegu Pe\u0165a \u0160utar\u00edka<\/a>.<\/p>\n

1. RAW d\u00e1ta k va\u0161im slu\u017eb\u00e1m<\/h2>\n

To \u010do bolo pri Universal Analytics nemyslite\u013en\u00e9, je pri Google Analytics 4 prakticky samozrejmos\u0165ou. BigQuery v\u00e1m umo\u017en\u00ed pristupova\u0165 ku kompletn\u00fdm surov\u00fdm d\u00e1tam na \u00farovni hitu<\/strong>. V\u010faka tomu m\u00f4\u017eete robi\u0165 komplexnej\u0161ie anal\u00fdzy, ktor\u00e9 v rozhraniach Google Analytics, resp. Google Data Studio jednoducho neboli mo\u017en\u00e9.<\/p>\n

Pr\u00edkladom takejto anal\u00fdzy je napr\u00edklad vytvorenie vlastn\u00e9ho atribu\u010dn\u00e9ho modelu<\/a> zalo\u017een\u00e9ho na re\u00e1lnom spr\u00e1van\u00ed u\u017e\u00edvate\u013eov.<\/p>\n

\"behavior<\/a><\/p>\n

2. Bezplatn\u00fd konektor v Data Studiu<\/h2>\n

Ak v\u00e1m SQL query syntax ve\u013ea nehovor\u00ed, potom ur\u010dite ocen\u00edte bezplatn\u00fd konektor pre BigQuery v Google Data Studiu<\/strong>. Pr\u00e1ve v Data Studiu si m\u00f4\u017eete vysklada\u0165 reporty presne pod\u013ea va\u0161ich predst\u00e1v. Ku queries sa v\u0161ak sk\u00f4r \u010di nesk\u00f4r ur\u010dite dostanete. Queries v\u00e1m pom\u00f4\u017eu n\u00e1js\u0165 odpovede na va\u0161e ot\u00e1zky e\u0161te r\u00fdchlej\u0161ie ako Data Studio.<\/p>\n

3. Zabudnite na limity po\u010dtu parametrov a vlastn\u00fdch dimenzi\u00ed<\/h2>\n

Rozhranie Google Analytics 4 umo\u017e\u0148uje moment\u00e1lne spracova\u0165 len 50 vlastn\u00fdch dimenzi\u00ed<\/strong>. Limitovan\u00fd je aj po\u010det vlastn\u00fdch parametrov posielan\u00fdch s jedn\u00fdm hitom, tu je limit nastaven\u00fd na 25. V pr\u00edpade, \u017ee hit bude obsahova\u0165 v\u00e4\u010d\u0161ie mno\u017estvo parametrov, tieto d\u00e1ta Google Analytics 4 s\u00edce neulo\u017e\u00ed, ale do BigQuery odoslan\u00e9 bud\u00fa.<\/p>\n

4. Pr\u00edstup k parametrom aj bez vlastnej dimenzie<\/h2>\n

Ak ste chceli v Analysis Hube v GA4 rozhran\u00ed rie\u0161i\u0165 nejak\u00fa anal\u00fdzu, pri ktorej ste potrebovali pristupova\u0165 k ur\u010dit\u00e9mu parametru, ne\u0161lo to priamo. Najsk\u00f4r ste si museli zaregistrova\u0165 nov\u00fa vlastn\u00fa dimenziu a a\u017e n\u00e1sledne ste s hodnotou parametra (u\u017e vlastnej dimenzie) mohli pracova\u0165. Toto pri BigQuery nehroz\u00ed. M\u00f4\u017eete si filtrova\u0165 hity na z\u00e1klade parametra<\/strong> ako len potrebujete.<\/p>\n

5. Spracovanie ve\u013ek\u00e9ho mno\u017estva d\u00e1t v zlomku sekundy<\/h2>\n

Pri pr\u00e1ci s BigQuery vyu\u017e\u00edvate robustn\u00fa infra\u0161trukt\u00faru Googlu s obrovsk\u00fdm v\u00fdpo\u010dtov\u00fdm v\u00fdkonom. To sa z\u00e1konite prejav\u00ed aj na r\u00fdchlosti<\/strong> odpovede na va\u0161u ot\u00e1zku. T\u00e1 s\u00edce mus\u00ed by\u0165 nap\u00edsan\u00e1 vo forme SQL query, ale toto by ur\u010dite pre v\u00e1s nemala by\u0165 neprekonate\u013en\u00e1 prek\u00e1\u017eka. Druhou mo\u017enos\u0165ou je pou\u017eitie Google Data Studia, ktor\u00e9ho z\u00e1kladnou vlastnos\u0165ou je, \u017ee je pooooomaaaaal\u00e9\u00e9\u00e9\u00e9\u00e9\u00e9\u00e9\u00e9\u00e9\u00e9. Ak va\u0161im d\u00e1tov\u00fdm zdrojom bude BigQuery tabu\u013eka, r\u00fdchlos\u0165 Data Studia bude pre v\u00e1s, naopak, prijemn\u00fdm prekvapen\u00edm.<\/p>\n

6. U\u017e nikdy samplovan\u00e9 d\u00e1ta<\/h2>\n

V Universal Analytics bolo samplovanie d\u00e1t<\/strong> pomerne be\u017en\u00fdm javom aj pri stredne ve\u013ek\u00fdch \u00fa\u010dtoch. Rovnako v Data Studiu bolo niekedy \u0165a\u017ek\u00e9 kv\u00f4li mas\u00edvnemu samplovaniu vyhodnoti\u0165 anal\u00fdzu so 100-percentnou istotou. Google Analytics 4 tento probl\u00e9m vyrie\u0161il, tak\u017ee ak e\u0161te st\u00e1le v\u00e1hate nad migr\u00e1ciou, toto bude ur\u010dite siln\u00fd argument pre kombo Google Analytics 4 a BigQuery.<\/p>\n

7. Oboha\u0165te d\u00e1ta z Google Analytics o vlastn\u00e9 d\u00e1ta<\/h2>\n

Ak ste doteraz chceli prep\u00e1ja\u0165 d\u00e1ta<\/strong> z Google Analytics s d\u00e1tami z reklamn\u00fdch syst\u00e9mov tret\u00edch str\u00e1n, s va\u0161\u00edm CRM, pr\u00edpadne s d\u00e1tami o po\u010das\u00ed, v\u00e4\u010d\u0161inou ste na to museli pou\u017ei\u0165 Google Sheets, alebo Data Blending v Data Studiu. Obe mo\u017enosti maj\u00fa svoje limity a pr\u00e1ca s nimi si vy\u017eaduje mno\u017estvo \u010dasu a \u010dastokr\u00e1t aj nervov. Tabu\u013eka v BigQuery v\u0161ak m\u00f4\u017ee obsahova\u0165 hoci\u010do, \u010do potrebujete. Neexistuje tu limit 5 mili\u00f3nov buniek ako v Google Sheets, alebo piatich d\u00e1tov\u00fdch zdrojov ako v pr\u00edpade Data Blendingu v Data Studiu. Va\u0161e d\u00e1ta tak z\u00edskaj\u00fa \u00faplne nov\u00fd rozmer.<\/p>\n

Google ide e\u0161te \u010falej a u\u017e\u00edvate\u013eom poskytuje bezplatn\u00fd pr\u00edstup k mno\u017estvu verejn\u00fdch datasetov<\/a> – od inform\u00e1ci\u00ed o po\u010das\u00ed, cez finan\u010dn\u00e9 d\u00e1ta, prevodov\u00e9 kurzy a\u017e po r\u00f4zne \u0161tatistick\u00e9 d\u00e1ta.<\/p>\n

8. Vysok\u00e1 bezpe\u010dnos\u0165 ulo\u017een\u00fdch d\u00e1t<\/h2>\n

Dostupnos\u0165 slu\u017eby Google Cloud je garantovan\u00e1 na 99.9% \u010dasu. Mo\u017eno si poviete, \u017ee je to dnes samozrejmos\u0165 aj pri hociktorom lacnom zdie\u013eanom hostingu, ale Google to op\u00e4\u0165 posunul na \u010fal\u0161\u00ed level. Va\u0161e d\u00e1ta s\u00fa nieko\u013ekon\u00e1sobne replikovan\u00e9 a z\u00e1lohovan\u00e9<\/strong> v r\u00f4znych d\u00e1tov\u00fdch centr\u00e1ch, aby ste k nim mali aj v pr\u00edpade pr\u00edrodnej \u010di inej katastrofy pr\u00edstup aj na\u010falej. \u0160ifrovanie v\u0161etk\u00fdch ulo\u017een\u00fdch d\u00e1t je absol\u00fatnou samozrejmos\u0165ou.<\/p>\n

9. Jednoduch\u00e9 prepojenie s Google Analytics 4<\/h2>\n

Ke\u010f\u017ee Big Query aj GA4 s\u00fa n\u00e1stroje od Googlu, ich prepojenie je naozaj jednoduch\u00e9<\/strong>. Pre vytvorenie vlastn\u00e9ho d\u00e1tov\u00e9ho centra by ste norm\u00e1lne potrebovali datab\u00e1zov\u00fdch \u0161pecialistov aj developerov, v pr\u00edpade Google Cloud je \u00favodn\u00e9 nastavenie \u00fa\u010dtu ot\u00e1zkou p\u00e1r min\u00fat.<\/p>\n

10. A to v\u0161etko \u00faplne zadarmo! *<\/h2>\n

Toto m\u00f4\u017ee vyznie\u0165 ako kli\u0161\u00e9 z teleshopingu, ale je to naozaj tak. Big Query, aj ke\u010f sa jedn\u00e1 o platen\u00fa slu\u017ebu od Googlu, je skuto\u010dne lacn\u00e9. Pre ilustr\u00e1ciu: 1 GB priestoru v\u00e1m umo\u017en\u00ed ulo\u017ei\u0165 pribli\u017ene 6 mili\u00f3nov hitov. Ak zaznamen\u00e1vate v Google Analytics 1 mili\u00f3n hitov mesa\u010dne, cena za ich ulo\u017eenie bude cca 0,003 EUR. Trochu drah\u0161ie je procesovanie queries, ale aj v tomto pr\u00edpade ide (pri spr\u00e1vne nap\u00edsan\u00fdch queries) o zanedbate\u013en\u00e9 \u010diastky, konkr\u00e9tne 5 USD za 1 TB<\/strong> sprocesovan\u00fdch d\u00e1t.<\/p>\n

Tak \u010do? E\u0161te st\u00e1le v\u00e1hate? Dohodnite si konzult\u00e1ciu<\/a> s nami, v r\u00e1mci ktorej v\u00e1m radi predstav\u00edme v\u0161etky v\u00fdhody, ktor\u00e9 BigQuery m\u00f4\u017ee prinies\u0165 v\u00e1\u0161mu biznisu.<\/p>\n","protected":false},"excerpt":{"rendered":"

Aj vy m\u00e1te pocit, \u017ee BigQuery sa st\u00e1va ak\u00fdmsi buzzwordom v analytickom svete? Ak ste s BigQuery e\u0161te…<\/p>\n","protected":false},"author":70,"featured_media":17554,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[200],"tags":[673,798],"_links":{"self":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/17408"}],"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=17408"}],"version-history":[{"count":27,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/17408\/revisions"}],"predecessor-version":[{"id":17724,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/17408\/revisions\/17724"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media\/17554"}],"wp:attachment":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media?parent=17408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/categories?post=17408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/tags?post=17408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}