{"id":16025,"date":"2020-05-20T09:45:34","date_gmt":"2020-05-20T07:45:34","guid":{"rendered":"https:\/\/www.dase-analytics.com\/blog\/?p=16025\/"},"modified":"2021-10-26T15:20:51","modified_gmt":"2021-10-26T13:20:51","slug":"strava-report-v-data-studiu","status":"publish","type":"post","link":"https:\/\/www.dase-analytics.com\/blog\/sk\/strava-report-v-data-studiu\/","title":{"rendered":"Aplik\u00e1cia Strava v ruk\u00e1ch analytika. Pozrite sa, \u010do sa stane"},"content":{"rendered":"<p><script type=\"text\/javascript\">\n    $(document).ready(function() {\n        var $img = $(\"#cursor\");\n        $img.hide();\n        $('a#comment').mousemove(function(e) {\n            $img.stop(1, 1).fadeIn();\n            $img.offset({\n                top: e.pageY - $img.outerHeight(),\n                left: e.pageX - ($img.outerWidth()\/2)\n            });\n        }).mouseleave(function() {\n            $img.fadeOut();\n        });\n    });\n<\/script><\/p>\n<p>Pravideln\u00fd \u010ditate\u013e n\u00e1\u0161ho blogu m\u00f4\u017ee ve\u013emi \u013eahko nadobudnu\u0165 pocit, \u017ee pre n\u00e1s, DASE\u00e1kov, je najv\u00e4\u010d\u0161\u00edm vzru\u0161en\u00edm nejak\u00e1 nov\u00e1 fi\u010d\u00fara v Google Analytics. Asi v\u00e1s sklamem, ale nie je to celkom tak (<img decoding=\"async\" id=\"cursor\" style=\"position: absolute;\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-komentare-maly.png\" \/><a id=\"comment\" href=\"#\">no dobre, tak je, ale pssst<img \/><\/a>). Pravdu povediac sme \u00faplne oby\u010dajn\u00e1 parti\u010dka mlad\u00fdch \u013eud\u00ed, s \u00faplne oby\u010dajn\u00fdmi kon\u00ed\u010dkami. Horsk\u00e1 cyklistika je jedn\u00fdm z nich, preto je celkom pravdepodobn\u00e9, \u017ee ste sa so mnou, alebo s Majkou u\u017e niekedy stretli. \u017de kde? Na karpatsk\u00fdch singl\u00e1\u010doch, na pivku na Bielom kr\u00ed\u017ei, alebo hoci aj na Strave pri (m\u00e1rnych) pokusoch o zdolanie \u010fal\u0161ieho KOMu. A pr\u00e1ve <a href=\"https:\/\/www.strava.com\/mobile\" target=\"_blank\" rel=\"noopener noreferrer\">aplik\u00e1cia Strava<\/a> bude t\u00e9mou tohto \u010dl\u00e1nku.<\/p>\n<h2>Strava, najpou\u017e\u00edvanej\u0161ia appka na trackovanie tr\u00e9ningov<\/h2>\n<p>Stravu m\u00e1m r\u00e1d. Ve\u013emi priate\u013eskou a nen\u00e1silnou formou ma t\u00e1to aplik\u00e1cia <del>n\u00fati<\/del> motivuje st\u00e1le na sebe pracova\u0165, rovnako ako desiatky mili\u00f3nov \u013eud\u00ed na celom svete. T\u00e1to d\u00e1tovo orientovan\u00e1 aplik\u00e1cia je pre m\u0148a-analytika studnicou in\u0161pir\u00e1cie ako vizualizova\u0165 d\u00e1ta u\u017e\u00edvate\u013esky priate\u013esk\u00fdm sp\u00f4sobom. Ja na Strave sledujem u\u010dite\u013ea, barmana, ved\u00faceho predajne, ale aj YouTubera, jazzov\u00e9ho spev\u00e1ka \u010di lek\u00e1ra. V\u0161etci t\u00edto \u013eudia, nech s\u00fa z ak\u00e9hoko\u013evek prostredia, vedia \u010d\u00edta\u0165 d\u00e1ta na Strave absol\u00fatne bez probl\u00e9mov. Je v\u00f4bec e\u0161te nie\u010do, \u010do sa d\u00e1 na Strave vylep\u0161i\u0165?<\/p>\n<p>Ur\u010dite \u00e1no, inak by ste ne\u010d\u00edtali tento \u010dl\u00e1nok \ud83d\ude42 Priamo v Strave toti\u017e neviete segmentova\u0165 tr\u00e9ningy (napr. pod\u013ea ro\u010dn\u00e9ho obdobia, alebo typu aktivity), vyh\u013ead\u00e1vanie konkr\u00e9tnych tr\u00e9ningov v datab\u00e1ze je priam nemo\u017en\u00e9 a o nejak\u00fdch s\u00fahrnn\u00fdch \u00fadajoch si m\u00f4\u017eete necha\u0165 len sn\u00edva\u0165. Tieto nedostatky ma prin\u00fatili <a href=\"https:\/\/www.marki.sk\/strava-interaktivny-report\/\" target=\"_blank\" rel=\"noopener noreferrer\">vytvori\u0165 si vlastn\u00fd Strava dashboard<\/a> postaven\u00fd na Google Data Studiu. Po\u010fme sa pozrie\u0165, ako si tak\u00fdto dashboard viete vyrobi\u0165 tie\u017e.<\/p>\n<p><a href=\"https:\/\/datastudio.google.com\/reporting\/e9057f0a-4044-4c73-840b-b2c1873ea180\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-16031\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-banner.jpg\" alt=\"Strava dashboard, Srava API, Google Data Studio\" width=\"1000\" height=\"750\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-banner.jpg 1000w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-banner-300x225.jpg 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-banner-600x450.jpg 600w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<h2>Nak\u0155mte svoj Google Sheet cez Strava API<\/h2>\n<p>Prv\u00fdm probl\u00e9mom, s ktor\u00fdm som sa musel popasova\u0165, bolo stiahnutie d\u00e1t zo Stravy do Google Sheet. Existuje s\u00edce <a href=\"https:\/\/github.com\/eric-horvat\/strava-data-connector\" target=\"_blank\" rel=\"noopener noreferrer\">neofici\u00e1lny Strava konektor pre Data Studio<\/a>, ale v tomto pr\u00edpade som sa rozhodol pre vlastn\u00e9 rie\u0161enie, ke\u010f\u017ee d\u00e1ta som potreboval obohati\u0165 o \u010fal\u0161ie \u00fadaje. Ke\u010f\u017ee nie som \u017eiadny <a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/vyraz\/javascript\/\" target=\"_blank\" rel=\"noopener noreferrer\">JavaScript<\/a> guru, celkom som sa pote\u0161il <a href=\"https:\/\/www.benlcollins.com\/spreadsheets\/strava-api-with-google-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">n\u00e1vodu od Bena Colinsa aj so z\u00e1kladn\u00fdm zdroj\u00e1kom<\/a> pre stiahnutie \u00fadajov cez Strava <a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/vyraz\/api-application-programming-interfaces\/\" target=\"_blank\" rel=\"noopener noreferrer\">API<\/a>.<\/p>\n<p>V prvom kroku si mus\u00edte stiahnu\u0165 v\u0161etky historick\u00e9 d\u00e1ta, ktor\u00e9 chcete vizualizova\u0165. <a href=\"https:\/\/developers.strava.com\/docs\/reference\/\" target=\"_blank\" rel=\"noopener noreferrer\">Strava API m\u00e1 kvalitn\u00fa dokument\u00e1ciu<\/a>, tak\u017ee ak m\u00e1te s API sk\u00fasenosti, tento krok v\u00e1m nebude robi\u0165 probl\u00e9m. V druhom kroku potrebujete upravi\u0165 script tak, aby sa v\u00e1m v pravidelnom intervale s\u0165ahovali najnov\u0161ie tr\u00e9ningy a z\u00e1rove\u0148, aby v\u00e1m v Google Sheet datab\u00e1ze nevznikali duplicity.<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-report-google-sheet.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-16033 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-report-google-sheet.png\" alt=\"Strava API google sheet\" width=\"1627\" height=\"850\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-report-google-sheet.png 1627w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-report-google-sheet-300x157.png 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-report-google-sheet-1024x535.png 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-report-google-sheet-1536x802.png 1536w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-report-google-sheet-600x313.png 600w\" sizes=\"(max-width: 1627px) 100vw, 1627px\" \/><\/a><\/p>\n<p>Nakoniec z\u00edskan\u00e9 v\u00fdjazdy rozkategorizujete pod\u013ea va\u0161ich individu\u00e1lnych potrieb. Ja som si vytvoril najm\u00e4 vlastn\u00e9 \u010dasov\u00e9 dimenzie, av\u0161ak iniciat\u00edve sa medze neklad\u00fa. Chcete segmentova\u0165 tr\u00e9ningy pod\u013ea sparring partnera? Alebo pod\u013ea po\u010dasia, d\u0148a v t\u00fd\u017edni, \u010di rozdeli\u0165 tr\u00e9ningy na vytrvalostn\u00e9 a silov\u00e9? Ka\u017edej dimenzii vyhra\u010fte jeden vo\u013en\u00fd st\u013apec, tr\u00e9ningom prira\u010fte kateg\u00f3rie a je to. Teraz m\u00f4\u017eete tabu\u013eku prepoji\u0165 s <a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/vyraz\/google-data-studio\/\" target=\"_blank\" rel=\"noopener noreferrer\">Data Studiom<\/a>.<\/p>\n<h2>Vizualizujte d\u00e1ta v Data Studiu<\/h2>\n<p>Ke\u010f m\u00e1te d\u00e1ta pripraven\u00e9, nasleduje t\u00e1 zauj\u00edmavej\u0161ia \u010das\u0165 &#8211; <strong>vizualiz\u00e1cia d\u00e1t<\/strong>. Nebudem tu rozpisova\u0165, ako ktor\u00fd element v Data Studiu pou\u017e\u00edva\u0165 (to n\u00e1jdete <a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/category\/google-data-studio\/\" target=\"_blank\" rel=\"noopener noreferrer\">v na\u0161om seri\u00e1li o Data Studiu<\/a>), d\u00e1m v\u00e1m v\u0161ak jednu dobr\u00fa radu. V\u017edy sa zamyslite nad t\u00fdm, na ak\u00fa ot\u00e1zku v\u00e1m m\u00e1 report odpoveda\u0165.<\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ak budete chcie\u0165 vidie\u0165 v\u00e1\u0161 progres v \u010dase, pou\u017eite \u010diarov\u00fd graf.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ak chcete pozna\u0165 \u00fadaj o celkovom po\u010dte kilometrov v danom obdob\u00ed, <\/span><a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/google-data-studio-prehlady-scorecards\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"font-weight: 400;\">preh\u013eady (scorecards)<\/span><\/a><span style=\"font-weight: 400;\"> s\u00fa na to ako stvoren\u00e9. <\/span><\/li>\n<li style=\"font-weight: 400;\">Zoznam tr\u00e9ningov najlep\u0161ie zn\u00e1zorn\u00edte v tabu\u013eke a lokalitu tr\u00e9ningov ide\u00e1lne na mape. Google Data Studio najnov\u0161ie podporuje aj Google Mapy, to ste vedeli? Ak nie, sledujte na\u0161e <a href=\"https:\/\/www.dase-analytics.com\/blog\/sk\/category\/novinky\/\" target=\"_blank\" rel=\"noopener noreferrer\">ka\u017edomesa\u010dn\u00e9 NEWS<\/a> a budete v obraze.<\/li>\n<\/ul>\n<h2>Doprajte v\u00e1\u0161mu Strava reportu sexy look<\/h2>\n<p>V prvom rade sa ospravedl\u0148ujem v\u0161etk\u00fdm grafikom, ktor\u00fdm sa mie\u0161am do remesla. Tie\u017e si mysl\u00edm, \u017ee na Photoshop by mali d\u00e1va\u0165 zbrojn\u00fd preukaz&#8230; Preto som tento dizajn vyskladal <strong>v Gimpe<\/strong>. \ud83d\ude00<\/p>\n<p><a href=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-gimp-sablona.jpg\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-16036 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-gimp-sablona.jpg\" alt=\"Gimp \u0161abl\u00f3na Strava reportu\" width=\"1200\" height=\"635\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-gimp-sablona.jpg 1200w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-gimp-sablona-300x159.jpg 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-gimp-sablona-1024x542.jpg 1024w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-gimp-sablona-600x318.jpg 600w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<p>Ak si naozaj na vlastn\u00fa \u0161abl\u00f3nu netr\u00fafate, na internete n\u00e1jdete mno\u017estvo bezplatn\u00fdch \u0161abl\u00f3n, alebo aspo\u0148 in\u0161pir\u00e1cie. Siln\u00fdm spolo\u010dn\u00edkom sa v\u00e1m stane najm\u00e4 form\u00e1t png, ktor\u00fd umo\u017e\u0148uje prieh\u013eadnos\u0165 a ur\u010dit\u00e1 miera priestorovej predstavivosti. V\u010faka tomu m\u00f4\u017eete p\u00f4vodn\u00e9 Data Studio elemetnty v\u010dleni\u0165 do samotn\u00e9ho dizajnu.<\/p>\n<p>Jedna rada na z\u00e1ver &#8211; <strong>stavajte svoj vizu\u00e1l na mrie\u017eke<\/strong> (napr. 12&#215;12 pixelov) a t\u00fato mrie\u017eku pou\u017e\u00edvajte potom aj v Data Studiu. Aj ke\u010f pixel-perfect dizajn v Data Studiu je sk\u00f4r sci-fi (pou\u017ei\u0165 in\u00e9 slovo), u\u0161etr\u00ed v\u00e1m to mno\u017estvo nervov. Len pre zauj\u00edmavos\u0165 &#8211; na vytvorenie tejto \u0161abl\u00f3ny bolo pou\u017eit\u00fdch 124 vrstiev.<\/p>\n<h2>Zhr\u0148me si to<\/h2>\n<p>Nebudem v\u00e1s klama\u0165, pr\u00edprava podobn\u00e9ho reportu je \u010dasovo n\u00e1ro\u010dn\u00e1. Stiahnutie, pre\u010ditstenie a obohatenie d\u00e1t, nap\u00edsanie JavaScriptu, nastavenie automatiz\u00e1cie, v\u00fdroba grafick\u00e9ho n\u00e1vrhu, vyskladanie dashboardu a debugging mi zabrali <strong>okolo 20 hod\u00edn \u010dist\u00e9ho \u010dasu<\/strong>. T\u00fdm v\u00e1s ale nechcem odradi\u0165. Ak ste aj vy v\u00e1\u0161niv\u00fd cyklista, be\u017eec a pou\u017e\u00edvate Stravu, len smelo do toho. A k\u013eudne sa pochv\u00e1\u013ete dole v koment\u00e1roch vlastn\u00fdm reportom, budem sa te\u0161i\u0165. \ud83d\ude42<\/p>\n<p>Ak v\u00e1s t\u00e1to t\u00e9ma zaujala bli\u017e\u0161ie, pozrite si aj tento <a href=\"https:\/\/www.marki.sk\/strava-interaktivny-report\/\" target=\"_blank\" rel=\"noopener noreferrer\">n\u00e1vod na pou\u017e\u00edvanie Strava reportu<\/a> na mojom blogu.<\/p>\n<p><a href=\"https:\/\/datastudio.google.com\/reporting\/e9057f0a-4044-4c73-840b-b2c1873ea180\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-16031 size-full\" src=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-banner.jpg\" alt=\"Strava dashboard, Srava API, Google Data Studio\" width=\"1000\" height=\"750\" srcset=\"https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-banner.jpg 1000w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-banner-300x225.jpg 300w, https:\/\/www.dase-analytics.com\/blog\/wp-content\/uploads\/strava-banner-600x450.jpg 600w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pravideln\u00fd \u010ditate\u013e n\u00e1\u0161ho blogu m\u00f4\u017ee ve\u013emi \u013eahko nadobudnu\u0165 pocit, \u017ee pre n\u00e1s, DASE\u00e1kov, je najv\u00e4\u010d\u0161\u00edm vzru\u0161en\u00edm nejak\u00e1 nov\u00e1&#8230;<\/p>\n","protected":false},"author":70,"featured_media":16070,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[667,638],"tags":[],"_links":{"self":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/16025"}],"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=16025"}],"version-history":[{"count":26,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/16025\/revisions"}],"predecessor-version":[{"id":17932,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/16025\/revisions\/17932"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media\/16070"}],"wp:attachment":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media?parent=16025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/categories?post=16025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/tags?post=16025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}