{"id":3018,"date":"2021-12-15T12:17:48","date_gmt":"2021-12-15T10:17:48","guid":{"rendered":"https:\/\/webanalyst.ro\/?p=3018"},"modified":"2021-12-15T16:48:53","modified_gmt":"2021-12-15T14:48:53","slug":"amazon-microsoft-data-studio","status":"publish","type":"post","link":"https:\/\/webanalyst.ro\/blog\/2021\/amazon-microsoft-data-studio\/","title":{"rendered":"Data Studio conectat la Amazon, Microsoft, SQL \u0219i Google"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u00cen urm\u0103 cu exact 12 ani publicam primul meu articol pe acest site. \u00cen prezent, am ajuns la 322 de articole, aceasta fiind a zecea postare din 2021.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">La final de an, vom trece prin conectorii de date ad\u0103uga\u021bi sau actualiza\u021bi anul acesta \u00een Google Data Studio. Pe list\u0103 avem Amazon Redshift, Microsoft SQL Server 2017, MySQL 8, PostgreSQL \u0219i o list\u0103 mai lung\u0103 de produse Google, printre care Analytics, Ads, Maps sau Display &amp; Video 360.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">Conectori noi<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen primul r\u00e2nd, Google extinde Data Studio \u0219i spre surse de date din afara ecosistemului s\u0103u, merg\u00e2nd spre:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Amazon Redshift<\/li><li>Microsoft SQL Server 2017<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Ambii conectori de date au fost lansa\u021bi spre finalul acestui an \u0219i sunt \u00een stadiu beta. Semnalul transmis de Google este c\u0103 vrea s\u0103 fac\u0103 Data Studio disponibil pentru toate sursele majore de date.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Un alt conector nou lansat este cel de <strong>MySQL 8.<\/strong> Data Studio intr\u0103 \u00een normalitate pentru c\u0103 a avut de la \u00eenceput conector de MySQL, dar suporta versiuni mai vechi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pe aceea\u0219i list\u0103 este \u0219i <strong>PostgreSQL<\/strong>, pentru care conectorul a fost actualizat pentru a trece peste diverse bug-uri. Dac\u0103 a\u021bi \u00eencercat s\u0103 lucra\u021bi cu func\u021biile CONTAINS_TEXT, STARTS_WITH, ENDS_WITH, COUNT_DISTINCT sau REGEXP_MATCH pentru PostgreSQL, a\u021bi putea \u00eencerca din nou.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Google BigQuery<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">R\u0103m\u00e2nem \u00een zona de Cloud, dar cu produsul de la Google. La r\u00e2ndul s\u0103u, acest conector a primit c\u00e2teva optimiz\u0103ri:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Parametrii SQL mai buni pentru BiqQuery &#8211; orice parametru SQL poate fi folosit acum, f\u0103r\u0103 s\u0103 mai conteze unde a fost acesta creat<\/li><li>Introducerea manual\u0103 pentru baze de data \u0219i tabeluri \u00een conectorul BigQuery, util\u0103 atunci c\u00e2nd lista lor este lung\u0103<\/li><li>C\u00e2mpurile GEOGRAPHY pot fi v\u0103zute direct \u00een graficele Google Maps, inclusiv ca baloane (<em>bubbles<\/em>). Anterior, datele trebuiau \u00eent\u00e2i convertite ca latitudine \u0219i longitudine<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Google Maps<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 am ajuns la h\u0103r\u021bile de la Google, s\u0103 continu\u0103m cu acestea. Nu este un conector per se, dar este un alt produs care se integreaz\u0103 bine cu Data Studio \u0219i care anul acesta a primit c\u00e2teva nout\u0103\u021bi importante:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Focalizare automat\u0103 pe o zon\u0103 mai mic\u0103 din hart\u0103, dac\u0103 acolo sunt toate punctele de interes<\/li><li>A fost ad\u0103ugat\u0103 <em>Country subdivsion (2nd level)<\/em>, care \u00eenlocuie\u0219te Region; au fost simplificate tipurile de date pentru geoloca\u021bie, acela\u0219i indicator ap\u0103r\u00e2nd dac\u0103 \u00eei scrii numele, codul ISO \u00een 2 sau \u00een 3 litere, precum \u0219i codul din 3 cifre<\/li><li>Google Maps poate fi inclus \u0219i \u00een rapoartele inserate \u00een alte pagini (<em>embedded<\/em>); pot fi incluse gratuit p\u00e2n\u0103 la 30.000 de \u00eenc\u0103rc\u0103ri din hart\u0103, pentru mai mult fiind nevoie de o plat\u0103 la Maps<\/li><li>Limitele pentru Google Maps au fost \u0219i ele m\u0103rite p\u00e2n\u0103 la 100.000 de valori pentru latitudine \u0219i longitudine, iar pentru BigQuery acestea merg p\u00e2n\u0103 la 1.000.000<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Google Search Console<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">S\u0103pt\u0103m\u00e2na trecut\u0103 scriam c\u0103 Search Console a fost <a href=\"https:\/\/webanalyst.ro\/blog\/2021\/ga4-search-console\/\" target=\"_blank\" rel=\"noreferrer noopener\">integrat<\/a> cu Google Analytics 4. Tot anul acesta, el a devenit conector \u0219i pentru Data Studio.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Google Ad Manager<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen schimb, Google Ad Manager era \u0219i \u00eenainte un conector. dar acum avem la dispozi\u021bie mai multe c\u00e2mpuri noi din acesta:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Line item ID<\/li><li>Order ID<\/li><li>Creative ID<\/li><li>Ad unit ID (top level)<\/li><li>Placement ID<\/li><li>Country ID<\/li><li>City ID<\/li><li>Master and Companion creative ID<\/li><li>App ID<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Google Ads<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen cazul conturilor manager (MCC), conturile aflate \u00een diferite monede pot fi convertite \u00een aceea\u0219i moned\u0103. \u00cen acest sens, op\u021biunea <em>Converted Currency<\/em> va face tranzi\u021bia, folosind cursul valutar mediu al lunii.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Din acest motiv, tranzac\u021biile pe mai pu\u021bin de o lun\u0103 s-ar putea s\u0103 nu fie tocmai corecte. Conversiile nu vor func\u021biona cu grafice setate pe All time \u0219i nici pentru tranzac\u021bii mai vechi de luna mai din 2003.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Display &amp; Video 360<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u0218i acest conector a primit c\u00e2teva dimensiuni noi, pe care le vede\u021bi mai jos:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Budget Segment Name<\/li><li>Budget Segment Start Date<\/li><li>Budget Segment End Date<\/li><li>Budget Segment Pacing Percentage<\/li><li>Budget Segment Budget<\/li><li>Line Item Start Date<\/li><li>Line Item End Date<\/li><li>Line Item Budget<\/li><li>Line Item Pacing Percentage<\/li><li>Insertion Order Goal Type<\/li><li>Insertion Order Goal Value<\/li><li>Percentage from Current IO Goal<\/li><li>Budget Type (Segment)<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Google Analytics 4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Conectorul pentru cea mai recent\u0103 versiune de Google Analytics a primit c\u00e2teva actualiz\u0103ri importante \u00een anul 2021.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Surse de trafic<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">De la \u00eenceputul anului, avem c\u00e2mpuri noi la sursele de trafic:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Session Google Ads ad group ID<\/li><li>Session default channel grouping<\/li><li>Session medium<\/li><li>Session campaign<\/li><li>Session source<\/li><li>User Google Ads ad group ID<\/li><li>User Google Ads ad group name<\/li><li>User Google Ads ad network type<\/li><li>User medium<\/li><li>User campaign<\/li><li>User source<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Conversii bazate pe campanii<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Lista de mai sus a fost extins\u0103, cu urm\u0103toarele c\u00e2mpuri pentru care putem vedea conversii \u0219i \u00een Data Studio:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Campaign ID<\/li><li>Campaign<\/li><li>Google Ads account name<\/li><li>Google Ads ad group ID<\/li><li>Google Ads ad group name<\/li><li>Google Ads ad network type<\/li><li>Medium<\/li><li>Source<\/li><li>Traffic origin<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">GA4 Insights<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen Google Analytics 4 avem <em>Automated insights<\/em>, care pot fi acum importate \u0219i \u00een rapoartele din Data Studio.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Ecommerce<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">C\u00e2mpurile de Ecommerce din Google Analytics 4 au fost recent integrate \u00een Data Studio. Iat\u0103 lista acestora:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Item brand<\/li><li>Item category<\/li><li>Item category 2<\/li><li>Item category 3<\/li><li>Item category 4<\/li><li>Item category 5<\/li><li>Item ID<\/li><li>Item name<\/li><li>Item list ID<\/li><li>Item list name<\/li><li>Item promotion creative name<\/li><li>Item promotion ID<\/li><li>Item promotion Name<\/li><li>Order coupon<\/li><li>Transaction ID<\/li><li>Add-to-carts<\/li><li>Checkouts<\/li><li>Ecommerce purchases<\/li><li>Item purchase quantity<\/li><li>Item revenue<\/li><li>Item list clicks<\/li><li>Item list click through rate<\/li><li>Item list views<\/li><li>Item promotion clicks<\/li><li>Item promotion click through rate<\/li><li>Item promotion views<\/li><li>Item views<\/li><li>Cart-to-view rate<\/li><li>Purchase-to-view rate<\/li><li>Total purchasers<\/li><li>First time purchasers<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 a\u021bi \u00eencercat s\u0103 folosi\u021bi c\u00e2mpurile din articolul de mai sus \u0219i nu le avea\u021bi, \u00eencerca\u021bi o actualizare a surselor de trafic din rapoarte.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00cen urm\u0103 cu exact 12 ani publicam primul meu articol pe acest site. \u00cen prezent, am ajuns la 322 de articole, aceasta fiind a zecea postare din 2021. La final de an, vom trece prin conectorii de date ad\u0103uga\u021bi sau actualiza\u021bi anul acesta \u00een Google Data Studio. Pe list\u0103 avem Amazon Redshift, Microsoft SQL Server [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3019,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[867,11],"tags":[],"class_list":["post-3018","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-data-studio","category-noutati"],"_links":{"self":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3018","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=3018"}],"version-history":[{"count":3,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3018\/revisions"}],"predecessor-version":[{"id":3022,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/posts\/3018\/revisions\/3022"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media\/3019"}],"wp:attachment":[{"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/media?parent=3018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/categories?post=3018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webanalyst.ro\/blog\/wp-json\/wp\/v2\/tags?post=3018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}