{"id":3603,"date":"2023-10-30T11:43:21","date_gmt":"2023-10-30T09:43:21","guid":{"rendered":"https:\/\/webanalyst.ro\/?p=3603"},"modified":"2023-10-30T11:51:26","modified_gmt":"2023-10-30T09:51:26","slug":"ga4-bigquery-parametri-item","status":"publish","type":"post","link":"https:\/\/webanalyst.ro\/blog\/2023\/ga4-bigquery-parametri-item\/","title":{"rendered":"Parametrii eCommerce Personaliza\u021bi din Google Analytics 4 sunt acum \u0219i \u00een BigQuery"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">C\u00e2nd s-a lansat Google Analytics 4, acesta avea mari lipsuri \u00een zona de raportare (o parte dintre aceste lispuri \u00eenc\u0103 exist\u0103). Google a spus c\u0103 \u00eel putem folosi, pentru c\u0103 avem toate datele \u00een Google BigQuery.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nici acest lucru nu era tocmai adev\u0103rat, \u0219i vedem acest lucru periodic, pe m\u0103sur\u0103 ce Google anun\u021b\u0103 c\u0103 a introdus noi dimensiuni \u0219i metrice pe care le putem accesa din BQ. De exemplu, \u00een luna mai a acestui an au \u00eenceput s\u0103 introduc\u0103 <a href=\"https:\/\/webanalyst.ro\/blog\/2023\/noi-date-ga4-in-bigquery\/\" target=\"_blank\" rel=\"noreferrer noopener\">detalii despre sursele de trafic \u0219i despre utilizatori<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"380\" height=\"208\" src=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2023\/10\/ga4-bigquery-item-params.png\" alt=\"\" class=\"wp-image-3604\" srcset=\"https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2023\/10\/ga4-bigquery-item-params.png 380w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2023\/10\/ga4-bigquery-item-params-300x164.png 300w, https:\/\/webanalyst.ro\/blog\/wp-content\/uploads\/2023\/10\/ga4-bigquery-item-params-150x82.png 150w\" sizes=\"auto, (max-width: 380px) 100vw, 380px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen urm\u0103 cu c\u00e2teva zile, au anun\u021bat introducerea parametrilor defini\u021bi de utlizator \u00een eCommerce. Detalii \u00een continuarea acestui articol.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p class=\"wp-block-paragraph\"><code>items<\/code> este numele tabelului \u00een care putem accesa datele de tip eCommerce ale Google Analytics 4 \u00een BigQuery. Sub acesta, zilele trecute au ad\u0103ugat \u00eenregistr\u0103rile <code>item_params<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Acesta vine cu mai mul\u021bi parametri care pot fi folosi\u021bi \u00een raportare:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>items.item_params.key<\/strong> &#8211; numele parametrului<\/li>\n\n\n\n<li><strong>items.item_params.value.string_value<\/strong> &#8211; valoarea parametrului, \u00een cazul \u00een care este text<\/li>\n\n\n\n<li><strong>items.item_params.value.int_value<\/strong> &#8211; valoarea parametrului, \u00een cazul \u00een care este num\u0103r \u00eentreg<\/li>\n\n\n\n<li><strong>items.item_params.value.double_value<\/strong> &#8211; valoarea parametrului, \u00een cazul \u00een care este num\u0103r cu virgul\u0103<\/li>\n\n\n\n<li><strong>items.item_params.value.float_value<\/strong> &#8211; valoarea parametrului, dac\u0103 este reprezentat\u0103 prin FLOAT (numere cu mai pu\u021bine cifre sau zecimale, comparativ cu cazul anterior)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Pentru a le accesa pe acestea, este nevoie s\u0103 folosi\u021bi clauza <code>UNNEST<\/code> din SQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">De notat c\u0103 noile dimensiuni sunt valabile pentru valorile personalizate pe care le trimitem prin parametrii de produs sau <em>item<\/em>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Informa\u021bii despre <code>item_id<\/code>, <code>item_name<\/code>, <code>item_category<\/code> \u0219i to\u021bi ceilal\u021bi parametri standard erau importa\u021bi \u0219i p\u00e2n\u0103 acum din Google Analytics \u00een BigQuery.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Dimensiuni la nivel de produs \u00een Google BigQuery<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Las mai jos o list\u0103 cu metricele \u0219i dimensiunile de produs pe care le g\u0103sim \u00een BigQuery, dac\u0103 este conectat la Google Analytics 4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cencep cu dimensiunile:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>items.item_id<\/li>\n\n\n\n<li>items.item_name<\/li>\n\n\n\n<li>items.item_brand<\/li>\n\n\n\n<li>items.item_variant<\/li>\n\n\n\n<li>items.item_category<\/li>\n\n\n\n<li>items.item_category2<\/li>\n\n\n\n<li>items.item_category3<\/li>\n\n\n\n<li>items.item_category4<\/li>\n\n\n\n<li>items.item_category5<\/li>\n\n\n\n<li>items.item_params.key<\/li>\n\n\n\n<li>items.coupon<\/li>\n\n\n\n<li>items.affiliation<\/li>\n\n\n\n<li>items.location_id<\/li>\n\n\n\n<li>items.item_list_id<\/li>\n\n\n\n<li>items.item_list_name<\/li>\n\n\n\n<li>items.item_list_index<\/li>\n\n\n\n<li>items.promotion_id<\/li>\n\n\n\n<li>items.promotion_name<\/li>\n\n\n\n<li>items.creative_name<\/li>\n\n\n\n<li>items.creative_slot<\/li>\n\n\n\n<li>items.item_params.key<\/li>\n\n\n\n<li>items.item_params.value.string_value<\/li>\n\n\n\n<li>items.item_params.value.int_value<\/li>\n\n\n\n<li>items.item_params.value.float_value<\/li>\n\n\n\n<li>items.item_params.value.double_value<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Metrice la nivel de produs \u00een Google BigQuery<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Lista metricelor din Google Analytics este mai scurt\u0103:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>items.price_in_usd<\/li>\n\n\n\n<li>items.price<\/li>\n\n\n\n<li>items.quantity<\/li>\n\n\n\n<li>items.item_revenue_in_usd<\/li>\n\n\n\n<li>items.item_revenue<\/li>\n\n\n\n<li>items.item_refund_in_usd<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Este un pas \u00een direc\u021bia cea bun\u0103 pentru Google Analytics 4 \u0219i pentru Google BigQuery. Atunci c\u00e2nd implementezi eCommerce pe un site, este foarte probabil s\u0103 ai nevoie de mai mul\u021bi parametri dec\u00e2t cei defini\u021bi de Google.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 sunte\u021bi la \u00eenceput cu utilizarea BigQuery pentru GA4, v\u0103 recomand articolul de <a href=\"https:\/\/webanalyst.ro\/blog\/2022\/ga4-bigquery\/\" target=\"_blank\" rel=\"noreferrer noopener\">aici<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u00e2nd s-a lansat Google Analytics 4, acesta avea mari lipsuri \u00een zona de raportare (o parte dintre aceste lispuri \u00eenc\u0103 exist\u0103). Google a spus c\u0103 \u00eel putem folosi, pentru c\u0103 avem toate datele \u00een Google BigQuery. Nici acest lucru nu era tocmai adev\u0103rat, \u0219i vedem acest lucru periodic, pe m\u0103sur\u0103 ce Google anun\u021b\u0103 c\u0103 a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3177,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,11],"tags":[540],"class_list":["post-3603","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics","category-noutati","tag-bigquery"],"_links":{"self":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3603","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=3603"}],"version-history":[{"count":6,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3603\/revisions"}],"predecessor-version":[{"id":3611,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3603\/revisions\/3611"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media\/3177"}],"wp:attachment":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media?parent=3603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/categories?post=3603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/tags?post=3603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}