{"id":11354,"date":"2020-04-24T14:37:02","date_gmt":"2020-04-24T14:37:02","guid":{"rendered":"https:\/\/n404.net\/?p=11354"},"modified":"2026-11-11T15:57:33","modified_gmt":"2026-11-11T15:57:33","slug":"integra-google-sheets-amb-data-studio","status":"publish","type":"post","link":"https:\/\/n404.net\/ca\/blog\/integra-google-sheets-amb-data-studio\/","title":{"rendered":"El poder de Google Sheets amb Data Studio"},"content":{"rendered":"

[et_pb_section fb_built=\u00bb1″ _builder_version=\u00bb4.27.5″ background_color=\u00bbRGBA(255,255,255,0)\u00bb custom_margin=\u00bb0px|0px|0px|0px|false|false\u00bb custom_padding=\u00bb0px|0px|0px|0px|false|false\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_row _builder_version=\u00bb4.16″ background_size=\u00bbinitial\u00bb background_position=\u00bbtop_left\u00bb background_repeat=\u00bbrepeat\u00bb width=\u00bb92%\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.16″ custom_padding=\u00bb|||\u00bb global_colors_info=\u00bb{}\u00bb custom_padding__hover=\u00bb|||\u00bb][et_pb_button button_url=\u00bb\/blog\/\u00bb button_text=\u00bbBlog\u00bb _builder_version=\u00bb4.16″ custom_button=\u00bbon\u00bb button_text_size=\u00bb14px\u00bb button_text_color=\u00bb#000000″ button_bg_color=\u00bb#f5f5f5″ button_border_width=\u00bb0px\u00bb button_border_radius=\u00bb14px\u00bb button_icon=\u00bb#||divi||400″ button_icon_color=\u00bb#000000″ button_icon_placement=\u00bbleft\u00bb button_on_hover=\u00bboff\u00bb global_colors_info=\u00bb{}\u00bb][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=\u00bb1″ _builder_version=\u00bb4.27.5″ hover_enabled=\u00bb0″ global_colors_info=\u00bb{}\u00bb background_color=\u00bbRGBA(255,255,255,0)\u00bb sticky_enabled=\u00bb0″][et_pb_row _builder_version=\u00bb4.16″ background_size=\u00bbinitial\u00bb background_position=\u00bbtop_left\u00bb background_repeat=\u00bbrepeat\u00bb width=\u00bb100%\u00bb max_width=\u00bb650px\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.16″ custom_padding=\u00bb|||\u00bb global_colors_info=\u00bb{}\u00bb custom_padding__hover=\u00bb|||\u00bb][et_pb_text _builder_version=\u00bb4.16″ background_size=\u00bbinitial\u00bb background_position=\u00bbtop_left\u00bb background_repeat=\u00bbrepeat\u00bb header_2_font_size_tablet=\u00bb\u00bb header_2_font_size_phone=\u00bb26px\u00bb header_2_font_size_last_edited=\u00bbon|phone\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Google Data Studio<\/strong> \u00e9s l’eina de Google que et permet visualitzar dades de diferents fonts creant aix\u00ed informes totalment personalitzats que et permeten tenir de manera clara i visual els KPI que m\u00e9s t’interessen.<\/p>\n

Els dissenys dels quadres de comandament s\u00f3n totalment personalitzables i permeten aconseguir un resultat final en l\u00ednia amb la imatge del teu projecte o el del teu client.<\/p>\n

Pots configurar Google Data Studio<\/strong> com a eina de monitoratge i fer-la servir per analitzar dades en temps real. Google Data Studio obt\u00e9 la seva informaci\u00f3 de les pr\u00f2pies aplicacions de Google; actualment es poden fusionar dades des de 17 Google Connectors. <\/strong>Aquests inclouen Google Analytics, Google Ads i Google Sheets, aix\u00ed com dades de Google Ad Manager, Google Cloud SQL o Google Sheets.<\/p>\n

Google Data Studio<\/strong> conven\u00e7, per una banda, pel seu disseny senzill i el seu f\u00e0cil maneig, i per l’altra per la seva \u00e0mplia gamma de funcions i pel grau d’adaptabilitat i individualitzaci\u00f3 de molts elements.<\/p>\n

Aquests informes estan disponibles per a qualsevol persona en qualsevol moment mitjan\u00e7ant l’acc\u00e9s a l’URL.<\/p>\n

En aquest article ens centrarem a integrar les dades de Google Sheets<\/strong>.<\/p>\n

Preparant el document a Google Sheets<\/h2>\n

Per a l’exemple, mostrarem la projecci\u00f3 que fem d’objectius per a alguns dels nostres clients; en aquest cas volem tra\u00e7ar el volum de tr\u00e0nsit org\u00e0nic que esperem aconseguir al llarg de l’any.<\/p>\n

Sempre comparem la xifra que esperem aconseguir i la real.<\/p>\n

La captura seg\u00fcent mostra com s’han de col\u00b7locar les dades a Google Sheets.<\/p>\n

\"Google<\/p>\n

Ara anem a Data Studio<\/h2>\n

Al full del teu Data Studio afegeix un gr\u00e0fic Time Series<\/strong> per visualitzar les teves dades.<\/p>\n

\"time<\/p>\n

 <\/p>\n

[\/et_pb_text][et_pb_text _builder_version=\u00bb4.16″ text_text_color=\u00bb#ffffff\u00bb background_color=\u00bb#3175e4″ custom_padding=\u00bb30px|30px|30px|30px|false|false\u00bb border_radii=\u00bbon|5px|5px|5px|5px\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Nota:<\/strong> algunes vegades cal refrescar el full de Data Studio perqu\u00e8 aparegui el teu Google Sheets. Assegura’t tamb\u00e9 que els permisos del document permetin compartir-lo.<\/p>\n

[\/et_pb_text][et_pb_text _builder_version=\u00bb4.16″ background_size=\u00bbinitial\u00bb background_position=\u00bbtop_left\u00bb background_repeat=\u00bbrepeat\u00bb header_2_font_size_tablet=\u00bb\u00bb header_2_font_size_phone=\u00bb26px\u00bb header_2_font_size_last_edited=\u00bbon|phone\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

Un cop tens el gr\u00e0fic l’has de vincular amb la font de dades que acabes de crear; per fer-ho, fes clic a \u00abSeleccionar font de dades\u00bb<\/strong> al men\u00fa de la dreta. Fes clic al bot\u00f3 \u00abCREAR NOVA FONT DE DADES\u00bb<\/strong>. Selecciona \u00abGoogle Sheets\u00bb<\/strong> i troba el full que acabes de crear. Pots introduir un URL o cercar-lo al teu Google Drive.<\/p>\n

\"\"
\"step2\"<\/p>\n

Ara ja tens vinculat el teu Google Sheet amb el gr\u00e0fic.<\/p>\n

Dimensions i m\u00e8triques<\/h2>\n

Ara nom\u00e9s has de seleccionar la teva Dimensi\u00f3<\/strong> y M\u00e8trica<\/strong>.<\/p>\n

\"metricas\"<\/p>\n

No t’oblidis de donar-li una mica d’estil als teus gr\u00e0fics per personalitzar-los.<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=\u00bb4.16″ background_size=\u00bbinitial\u00bb background_position=\u00bbtop_left\u00bb background_repeat=\u00bbrepeat\u00bb width=\u00bb100%\u00bb max_width=\u00bb950px\u00bb global_colors_info=\u00bb{}\u00bb][et_pb_column type=\u00bb4_4″ _builder_version=\u00bb4.16″ custom_padding=\u00bb|||\u00bb global_colors_info=\u00bb{}\u00bb custom_padding__hover=\u00bb|||\u00bb][et_pb_text _builder_version=\u00bb4.16″ background_size=\u00bbinitial\u00bb background_position=\u00bbtop_left\u00bb background_repeat=\u00bbrepeat\u00bb header_2_font_size_tablet=\u00bb\u00bb header_2_font_size_phone=\u00bb26px\u00bb header_2_font_size_last_edited=\u00bbon|phone\u00bb global_colors_info=\u00bb{}\u00bb]<\/p>\n

\"\"<\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Google Data Studio \u00e9s l’eina de Google que et permet visualitzar dades de diferents fonts creant aix\u00ed informes totalment personalitzats que et permeten tenir de manera clara i visual els KPI que m\u00e9s t’interessen. Els dissenys dels quadres de comandament s\u00f3n totalment personalitzables i permeten aconseguir un resultat final en l\u00ednia amb la imatge del […]<\/p>\n","protected":false},"author":2,"featured_media":11344,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-11354","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sin-categorizar"],"_links":{"self":[{"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/posts\/11354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/comments?post=11354"}],"version-history":[{"count":1,"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/posts\/11354\/revisions"}],"predecessor-version":[{"id":11358,"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/posts\/11354\/revisions\/11358"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/media\/11344"}],"wp:attachment":[{"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/media?parent=11354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/categories?post=11354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/n404.net\/ca\/wp-json\/wp\/v2\/tags?post=11354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}