{"id":3569,"date":"2023-10-13T14:43:57","date_gmt":"2023-10-13T11:43:57","guid":{"rendered":"https:\/\/webanalyst.ro\/?p=3569"},"modified":"2023-10-13T14:52:47","modified_gmt":"2023-10-13T11:52:47","slug":"google-analytics-4-in-google-sheets","status":"publish","type":"post","link":"https:\/\/webanalyst.ro\/blog\/2023\/google-analytics-4-in-google-sheets\/","title":{"rendered":"Google Analytics 4 \u00een Google Sheets"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Google a lansat un add-on pentru Google Spreadsheets care \u00eencarc\u0103 datele din cea mai recent\u0103 versiune de Google Analytics \u00een foile de calcul.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>GA4 Reports Builder for Google Analytics\u2122<\/strong> este numele add-on-ului de Google Sheets. Odat\u0103 instalat, \u00eel vom vedea \u00een meniul Extensions, de unde \u00eel putem activa.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1029\" height=\"356\" src=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2023\/10\/ga4-report-builder.png\" alt=\"\" class=\"wp-image-3572\" srcset=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2023\/10\/ga4-report-builder.png 1029w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2023\/10\/ga4-report-builder-300x104.png 300w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2023\/10\/ga4-report-builder-150x52.png 150w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2023\/10\/ga4-report-builder-768x266.png 768w\" sizes=\"auto, (max-width: 1029px) 100vw, 1029px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Voi scrie avantajele \u0219i dezavantajele folosirii acestui mod de raportare \u00een continuarea articolului.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\"><em>Create new report<\/em> este op\u021biunea care va deschide fereastra din care putem seta ce raporte vrem s\u0103 preia din GA4. \u00centre op\u021biuni, avem contul de Google Analytics, proprietatea de GA4, intervalul de timp pentru raport (putem alege un num\u0103r specific de zile din urm\u0103 sau data exact\u0103), dimensiunile \u0219i metricele pe care le vrem \u00een raport.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Interfa\u021ba este simpl\u0103, \u00eens\u0103 nu tocmai prietenoas\u0103. Pentru dimensiuni \u0219i metrice, vom avea de ales dintr-o list\u0103 vertical\u0103 lung\u0103, unde trebuie s\u0103 \u0219tim denumirea API pentru respectivul indicator. De exemplu, pentru <em>Session Source<\/em> va trebui s\u0103 alegem `sessionSource` (dac\u0103 scriem cu spa\u021biu, nu va ap\u0103rea nicio sugestie).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Un alt lucru pu\u021bin ciudat este c\u0103 dup\u0103 alegerea datelor pentru raport, se apas\u0103 butonul <em>Create raport<\/em>, \u00eens\u0103 nu se \u00eent\u00e2mpl\u0103 mai nimic. Mai exact, datele sunt puse \u00een sheet-ul numit <em>Report Configuration<\/em>, dar nu sunt preluate din analytics.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen meniul de sus (care poate fi v\u0103zut \u00een poz\u0103), trebuie s\u0103 alegem <em>Run reports<\/em> \u0219i atunci rapoartele decise de noi se vor popula cu date. Ideea este bun\u0103 atunci c\u00e2nd ai de creat mai multe rapoarte. Setezi ce vrei \u00een fiecare dintre acestea, dup\u0103 care selectezi rularea rapoartelor \u0219i ai datele.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen fiecare raport poate fi setat\u0103 c\u00e2te o prorpietate de analytics din care s\u0103 preia date, \u00eens\u0103 pot fi create \u00een paralel rapoarte din diverse propriet\u0103\u021bi, dup\u0103 care datele pot fi folosite \u00eempreun\u0103 \u00een Sheets.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Un alt lucru util este c\u0103 putem crea rapoarte diferite, cu acelea\u0219i date. De exemplu, am vrut sa compar 2 perioade diferite. A\u0219adar, intervalul de timp a fost singurul lucru pe care l-am schimbat \u00eentre cele 2 rapoarte.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Imaginea de deasupra articolului este cu un raport creat automat \u00een Google Sheets cu acest add-on. Desigur, ratele pot fi exprimate u\u0219or \u00een procente \u00een foile de calcul, dar am vrut s\u0103 ar\u0103t rezultatele ini\u021biale.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Vom face rapoartele \u00een Google Sheets?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Mai sus am prezentat avantajele acestui tip de raportare. Este simplu sa ai datele din analytics direct \u00een Sheets sau \u00een Excel, atunci c\u00e2nd \u0219tii exact ce vrei \u0219i nu este foarte complicat.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pentru toate celelalte lucruri, r\u0103m\u00e2n metodele clasice de p\u00e2n\u0103 acum. \u00cen Google Sheets nu avem filtre. De exemplu, daca vrem date despre un eveniment care nu are o metric\u0103 sau o dimensiune definit\u0103, va trebui s\u0103 cerem date despre toate evenimentele din Google Analytics. Eventual, dup\u0103 aceea le putem edita \u00een Excel, dar nu mi se pare un mod optim de lucru.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A\u0219a cum se poate vedea \u00een raportul generat de mine, \u0219i aceast\u0103 metod\u0103 de a prelua datele din Google Analytics <a href=\"https:\/\/webanalyst.ro\/blog\/2023\/limite-ga4-looker-studio\/\" target=\"_blank\" rel=\"noreferrer noopener\">consum\u0103 tokens din GA<\/a>. Altfel spus, dac\u0103 o vom folosi de multe ori \u00eentr-o zi, ne poate bloca accesul la datele din prorpietatea de analytics. Odat\u0103 blocate, niciun instrument nu va mai avea acces la acestea p\u00e2n\u0103 c\u00e2nd trece perioada de interdic\u021bie.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Personal, voi folosi tot rapoartele create \u00een Google Analytics (<a href=\"https:\/\/webanalyst.ro\/blog\/2022\/explorations-rapoarte-personalizate\/\" target=\"_blank\" rel=\"noreferrer noopener\">Explorations<\/a>), BigQuery sau <a href=\"https:\/\/webanalyst.ro\/blog\/sectiune\/google-data-studio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Data Studio \/ Looker Studio<\/a>. \u00cei \u00een\u021beleg \u0219i pe cei care vor trece la rapoarte completate rapid \u00een Google Sheets prin <a href=\"https:\/\/workspace.google.com\/marketplace\/app\/ga4_reports_builder_for_google_analytics\/589269949355\" target=\"_blank\" rel=\"noreferrer noopener\">GA4 Reports Builder<\/a>, cea din urm\u0103 fiind o solu\u021bie suficient de bun\u0103 \u00een anumite situa\u021bii.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google a lansat un add-on pentru Google Spreadsheets care \u00eencarc\u0103 datele din cea mai recent\u0103 versiune de Google Analytics \u00een foile de calcul. GA4 Reports Builder for Google Analytics\u2122 este numele add-on-ului de Google Sheets. Odat\u0103 instalat, \u00eel vom vedea \u00een meniul Extensions, de unde \u00eel putem activa. Voi scrie avantajele \u0219i dezavantajele folosirii acestui [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3570,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[951,949,950],"class_list":["post-3569","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-analytics","tag-automatizare-rapoarte","tag-google-sheets","tag-google-spreadsheets"],"_links":{"self":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3569","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=3569"}],"version-history":[{"count":5,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3569\/revisions"}],"predecessor-version":[{"id":3578,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3569\/revisions\/3578"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media\/3570"}],"wp:attachment":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media?parent=3569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/categories?post=3569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/tags?post=3569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}