{"id":3801,"date":"2024-05-17T12:50:32","date_gmt":"2024-05-17T09:50:32","guid":{"rendered":"https:\/\/webanalyst.ro\/?p=3801"},"modified":"2024-05-19T12:59:09","modified_gmt":"2024-05-19T09:59:09","slug":"looker-studio-titluri-si-grafice-noi","status":"publish","type":"post","link":"https:\/\/webanalyst.ro\/blog\/2024\/looker-studio-titluri-si-grafice-noi\/","title":{"rendered":"Looker Studio: Titluri \u0219i grafice noi"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Google Data Studio, mai nou cunoscut drept Google Looker Studio, a introdus recent un nou tip de grafic, dar \u0219i tituluri pentru toate graficele \u0219i tabelele din rapoarte, precum \u0219i alte nout\u0103\u021bi utile, printre care noi integr\u0103ri cu Google Sheets \u0219i Google Analytics 4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Timeline Chart<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Diagram\u0103 cronologic\u0103 sau Timeline chart (\u00een englez\u0103) este noul tip de grafic pe care \u00eel putem folosi \u00een rapoartele din Looker Studio.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cunoa\u0219tem acest tip de grafic de la planificarea proiectelor, \u00eens\u0103 graficul din Looker Studio poate face mult mai mult dec\u00e2t planificare.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\">Pentru a seta un nou Timeline, este nevoie s\u0103 set\u0103m urm\u0103toarele informa\u021bii \u00een zona de Setup a acestui grafic:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Row label<\/strong> &#8211; O dimensiune de tip text (string), care va da numele fiec\u0103rui r\u00e2nd<\/li>\n\n\n\n<li><strong>Start time<\/strong> &#8211; O dimensiune de tip dat\u0103 (date), care va reprezenta \u00eenceputul fiec\u0103rui timeline<\/li>\n\n\n\n<li><strong>End time<\/strong> sau <strong>Duration<\/strong> &#8211; O dimensiune de tip dat\u0103, dar care poate fi \u00eenlocuit\u0103 \u0219i de o dimensiune de tip num\u0103r (number); \u00een cazul \u00een care ambele c\u00e2mpuri sunt folosite, graficul va folosi datele din <em>End time<\/em>, ignor\u00e2nd <em>Duration<\/em><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Mai multe dimensiuni \u00een Timeline<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 vrei ca barele din grafic s\u0103 reprezinte o alt\u0103 valoare dec\u00e2t cea selectat\u0103 \u00een <em>Row label<\/em>, se poate ad\u0103uga o nou\u0103 dimensiune \u00een <strong>Bar label<\/strong>, dup\u0103 care ar trebui bifat\u0103 op\u021biunea <em>Show bar label<\/em>. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Am modificat pu\u021bin exemplul de la \u00eenceputul articolului, de data aceasta pun\u00e2nd numele premierului la <em>Bar label<\/em> \u0219i afilierea politic\u0103 a acestuia la <em>Row label<\/em>. Culorile pot fi setate at\u00e2t dup\u0103 row label, c\u00e2t \u0219i dup\u0103 bar label, a\u0219a cum am setat eu, pentru a diferen\u021bia numele premierilor cu aceea\u0219i afiliere politic\u0103. Dac\u0103 este nevoie, culorile pot fi setate \u0219i manual, oferind astfel o nou\u0103 dimensiune (de exemplu, a\u0219 fi putut s\u0103 le setez \u00een func\u021bie de orientarea politic\u0103 principal\u0103).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1787\" height=\"368\" src=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/primii-premieri-cu-afiliere-politica.png\" alt=\"\" class=\"wp-image-3827\" srcset=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/primii-premieri-cu-afiliere-politica.png 1787w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/primii-premieri-cu-afiliere-politica-300x62.png 300w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/primii-premieri-cu-afiliere-politica-1200x247.png 1200w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/primii-premieri-cu-afiliere-politica-150x31.png 150w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/primii-premieri-cu-afiliere-politica-768x158.png 768w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/primii-premieri-cu-afiliere-politica-1536x316.png 1536w\" sizes=\"auto, (max-width: 1787px) 100vw, 1787px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Observa\u021bii grupate<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen tab-ul <em>Style<\/em> al graficului, avem mai multe op\u021biuni utile. Pe l\u00e2ng\u0103 tipurile de culori \u0219i fonturi folosite, putem alege \u0219i dac\u0103 vrem s\u0103 grup\u0103m datele \u00een func\u021bie de r\u00e2nduri. Op\u021biunea <strong>Group by row label<\/strong> va afi\u0219a pe acela\u0219i r\u00e2nd toate datele pentru aceea\u0219i dimensiune (se poate vedea \u00een graficul de deasupra articolului cum grupeaz\u0103 diverse mandate ale aceluia\u0219i premier \u00eentr-un singur r\u00e2nd, iar \u00een graficul de mai sus gruparea este \u00een func\u021bie de afilierea politic\u0103). F\u0103r\u0103 a activa op\u021biunea de grupare dup\u0103 r\u00e2nduri, fiecare dat\u0103 ar fi avut un r\u00e2nd separat.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Modelul de date folosit \u00een spatele graficelor de tip Timeline ne permite s\u0103 venim cu durate (la plural!) de timp pentru fiecare observa\u021bie, nu doar cu o dat\u0103 static\u0103. Acest lucru ne permite s\u0103 folosim acest tip de grafic pentru mult mai multe lucruri. Am v\u0103zut mai sus grupare, dar poate fi folosit \u0219i la pivotare sau alte reprezent\u0103ri grafice, precum vizualiz\u0103ri simplificate de <em>networks<\/em>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Titluri pentru grafice<\/h2>\n\n\n\n<figure class=\"wp-block-image alignleft size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"209\" height=\"301\" src=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/looker-studio-chart-title-1.png\" alt=\"\" class=\"wp-image-3807\" srcset=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/looker-studio-chart-title-1.png 209w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/looker-studio-chart-title-1-104x150.png 104w\" sizes=\"auto, (max-width: 209px) 100vw, 209px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A\u0219a cum se poate vedea \u00een imaginea de deasupra articolului, am afi\u0219at un grafic Timeline cu titlu.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen zona <em>Style<\/em> din proprietatea fiec\u0103rui grafic, avem la dispozi\u021bie posibilitatea de a ad\u0103uga un titlu, \u00eempreun\u0103 cu op\u021biunile de a alege un font, o culoare, m\u0103rime, aliniere \u0219i pozi\u021bionare.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Este o op\u021biune care este de baz\u0103 \u00een alte instrumente de vizualizare a datelor, precum Microsoft Power BI. Salut\u0103m apari\u021bia acesteia \u0219i \u00een Google Looker Studio.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Rapoarte Looker Studio \u00een Google Sheets<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">O alt\u0103 op\u021biune interesant\u0103 este extensia de Google Sheets, care ne permite crearea unui raport \u00een Looker Studio, atunci c\u00e2nd suntem \u00eentr-un fi\u0219ier din Sheets.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Acesta va folosi datele din respectivul fi\u0219ier \u0219i va \u00eencerca s\u0103 creeze automat un raport \u00een Looker Studio. Este o op\u021biune de \u00eencercat, de\u0219i cel mai probabil va fi nevoie s\u0103 edita\u021bi graficele create de sistem.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"638\" height=\"318\" src=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/extension-sheets-looker.png\" alt=\"\" class=\"wp-image-3809\" srcset=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/extension-sheets-looker.png 638w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/extension-sheets-looker-300x150.png 300w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/extension-sheets-looker-150x75.png 150w\" sizes=\"auto, (max-width: 638px) 100vw, 638px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u0218i dac\u0103 tot suntem la capitolul Google Sheets, trebuie spus c\u0103 \u0219i acesta a primit recent op\u021biunea de a crea Timelines \u00een fi\u0219ierele sale. Da, \u0219i cel de aici are op\u021biunea de <strong>group by<\/strong>. Mai mult, aici putem folosi toate coloanele pentru grupare!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Integrare cu <em>Comparisons<\/em> din GA4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 folosi\u021bi Looker Studio pentru afi\u0219area datelor din Google Analytics 4, avem o veste bun\u0103!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Zilele trecute, Looker Studio a introdus \u0219i dimensiunea <strong>Comparison<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"227\" height=\"169\" src=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/looker-studio-comparison.png\" alt=\"\" class=\"wp-image-3810\" srcset=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/looker-studio-comparison.png 227w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2024\/05\/looker-studio-comparison-150x112.png 150w\" sizes=\"auto, (max-width: 227px) 100vw, 227px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cenc\u0103 nu avem toate detaliile despre cum va func\u021biona, dar cel mai probabil va fi o dimensiune dup\u0103 care vom putea segmenta datele din Google Analytics.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Este o op\u021biune foarte util\u0103, pentru c\u0103 Looker Studio nu st\u0103tea bine la acest capitol. Spre exemplu, \u00een Universal Analytics puteam importa segmente, \u00eens\u0103 fiecare dintre acestea era o surs\u0103 diferit\u0103 de date \u00een LS \u0219i de aici aveam alte probleme.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A\u0219tept\u0103m ca op\u021biunea s\u0103 fie func\u021bional\u0103 \u0219i, dac\u0103 va fi nevoie, voi reveni un un articol dedicat despre Comparisons \u00een Google Analytics 4 \u0219i \u00een Looker Studio.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Data Studio, mai nou cunoscut drept Google Looker Studio, a introdus recent un nou tip de grafic, dar \u0219i tituluri pentru toate graficele \u0219i tabelele din rapoarte, precum \u0219i alte nout\u0103\u021bi utile, printre care noi integr\u0103ri cu Google Sheets \u0219i Google Analytics 4. Timeline Chart Diagram\u0103 cronologic\u0103 sau Timeline chart (\u00een englez\u0103) este noul [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3802,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[867],"tags":[925,897,949,950],"class_list":["post-3801","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-data-studio","tag-ga4","tag-gaaw","tag-google-sheets","tag-google-spreadsheets"],"_links":{"self":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/comments?post=3801"}],"version-history":[{"count":14,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3801\/revisions"}],"predecessor-version":[{"id":3829,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3801\/revisions\/3829"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media\/3802"}],"wp:attachment":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media?parent=3801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/categories?post=3801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/tags?post=3801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}