{"id":20813,"date":"2025-06-11T10:30:23","date_gmt":"2025-06-11T08:30:23","guid":{"rendered":"https:\/\/www.dase-analytics.com\/blog\/?p=20813\/"},"modified":"2025-06-11T10:30:39","modified_gmt":"2025-06-11T08:30:39","slug":"google-search-console-a-bigquery-rozsirene-moznosti-seo-analyzy","status":"publish","type":"post","link":"https:\/\/www.dase-analytics.com\/blog\/sk\/google-search-console-a-bigquery-rozsirene-moznosti-seo-analyzy\/","title":{"rendered":"Google Search Console a BigQuery &#8211; roz\u0161\u00edren\u00e9 mo\u017enosti SEO anal\u00fdzy"},"content":{"rendered":"<p><b>Google Search Console (GSC)<\/b><span style=\"font-weight: 400;\"> patr\u00ed medzi z\u00e1kladn\u00e9 n\u00e1stroje ka\u017ed\u00e9ho SEO \u0161pecialistu, preto\u017ee poskytuje k\u013e\u00fa\u010dov\u00e9 \u00fadaje o tom, ako sa va\u0161a str\u00e1nka zobrazuje vo v\u00fdsledkoch vyh\u013ead\u00e1vania Google. M\u00f4\u017eete v \u0148om sledova\u0165 kliknutia, impresie, CTR, priemern\u00e9 poz\u00edcie a vyh\u013ead\u00e1vacie dopyty, ktor\u00e9 priv\u00e1dzaj\u00fa n\u00e1v\u0161tevn\u00edkov na v\u00e1\u0161 web.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Napriek t\u00fdmto v\u00fdhod\u00e1m m\u00e1 \u0161tandardn\u00e9 rozhranie Search Console nieko\u013eko v\u00fdrazn\u00fdch <\/span><b>obmedzen\u00ed<\/b><span style=\"font-weight: 400;\">:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">zobrazuje maxim\u00e1lne <\/span><b>1 000 riadkov<\/b><span style=\"font-weight: 400;\"> na jeden report (napr. dopyty, str\u00e1nky, krajiny),<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">d\u00e1ta s\u00fa dostupn\u00e9 len <\/span><b>za posledn\u00fdch 16 mesiacov<\/b><span style=\"font-weight: 400;\">,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">m\u00e1 obmedzen\u00e9 mo\u017enosti <\/span><b>reportingu<\/b><span style=\"font-weight: 400;\"> a integr\u00e1cie s in\u00fdmi d\u00e1tov\u00fdmi zdrojmi.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Ak potrebujete detailnej\u0161ie d\u00e1ta, dlh\u0161iu hist\u00f3riu alebo vlastn\u00e9 reporty na mieru, rie\u0161en\u00edm je <\/span><b>bulk export do BigQuery<\/b><span style=\"font-weight: 400;\"> \u2013 funkcionalita, ktor\u00e1 roz\u0161iruje sp\u00f4sob pr\u00e1ce so Search Console d\u00e1tami.<\/span><\/p>\n<h2><b>Pre\u010do exportova\u0165 GSC d\u00e1ta do BigQuery?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Google poskytuje automatick\u00fd denn\u00fd export d\u00e1t zo Search Console do BigQuery u\u017e nieko\u013eko rokov. Otvoril t\u00fdm nov\u00e9 mo\u017enosti pre analytikov aj SEO \u0161pecialistov. Na rozdiel od obmedzen\u00ed klasick\u00e9ho rozhrania GSC poskytuje BigQuery export pr\u00edstup k<\/span><b> detailn\u00fdm d\u00e1tam<\/b><span style=\"font-weight: 400;\"> vr\u00e1tane anonymizovan\u00fdch dopytov. Umo\u017e\u0148uje sledova\u0165 <\/span><b>dlhodob\u00e9 trendy<\/b><span style=\"font-weight: 400;\"> aj nad r\u00e1mec be\u017en\u00e9ho \u010dasov\u00e9ho obmedzenia a vytv\u00e1ra\u0165 <\/span><b>vlastn\u00e9 SQL dopyty<\/b><span style=\"font-weight: 400;\">, ktor\u00e9 pom\u00f4\u017eu odhali\u0165 hlb\u0161ie vzorce a s\u00favislosti v d\u00e1tach.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Navy\u0161e, prostredie BigQuery pon\u00faka priestor pre experimenty s <\/span><b>machine learning modelmi<\/b><span style=\"font-weight: 400;\">, ktor\u00e9 je mo\u017en\u00e9 aplikova\u0165 priamo v SQL \u2013 bez nutnosti ovl\u00e1da\u0165 pokro\u010dil\u00e9 programovanie. Pre t\u00fdch, ktor\u00ed chc\u00fa z vyh\u013ead\u00e1vac\u00edch d\u00e1t vy\u0165a\u017ei\u0165 maximum, ide o v\u00fdrazn\u00fd posun vpred.<\/span><\/p>\n<h2><b>Ako nastavi\u0165 GSC Bulk Export do BigQuery \u2013 krok za krokom<\/b><\/h2>\n<h3><b>\u010co budete potrebova\u0165:<\/b><\/h3>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Overen\u00e9 vlastn\u00edctvo webu v GSC<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Google Cloud \u00fa\u010det s akt\u00edvnou platobnou kartou<\/span><\/li>\n<\/ul>\n<h3><b>Postup:<\/b><\/h3>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V <\/span><b>Google Cloud Console<\/b><span style=\"font-weight: 400;\"> zvo\u013ete projekt, do ktor\u00e9ho chcete exportova\u0165 \u00fadaje. N\u00e1sledne v<\/span><b> BigQuery<\/b><span style=\"font-weight: 400;\"> vytvorte dataset (zvo\u013ete regi\u00f3n).<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V<\/span><b> Search Console <\/b><span style=\"font-weight: 400;\">prejdite do <\/span><i><span style=\"font-weight: 400;\">Settings &gt; Bulk Data export <\/span><\/i><span style=\"font-weight: 400;\">a vypl\u0148te po\u017eadovan\u00e9 \u00fadaje.<\/span> <span style=\"font-weight: 400;\">Pou\u017eite rovnak\u00fd dataset a regi\u00f3n ako v prvom bode.\u00a0 <\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Na druh\u00fd de\u0148 skontrolujte, \u010di v\u0161etko funguje \ud83d\ude42<\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">&#x1f9e0; <\/span><b>Pozn\u00e1mka:<\/b><span style=\"font-weight: 400;\"> Detialn\u00fd popis nastavenia GCS Bulk Export n\u00e1jdete v tejto <\/span><a href=\"https:\/\/support.google.com\/webmasters\/answer\/12917675?hl=en&amp;ref_topic=12917674&amp;sjid=96493653640285108-EU\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">dokument\u00e1cii<\/span><\/a><span style=\"font-weight: 400;\">.\u00a0<\/span><\/p>\n<h2><b>Ak\u00e9 d\u00e1ta z\u00edskate?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Po \u00faspe\u0161nom nastaven\u00ed exportu sa v BigQuery automaticky vytvoria dve hlavn\u00e9 tabu\u013eky: <\/span><span style=\"font-weight: 400;\">searchdata_site_impression<\/span><span style=\"font-weight: 400;\"> a <\/span><span style=\"font-weight: 400;\">searchdata_url_impression<\/span><span style=\"font-weight: 400;\">. Obe poskytuj\u00fa agregovan\u00e9 metriky o v\u00fdkone v\u00e1\u0161ho webu vo vyh\u013ead\u00e1van\u00ed Google, no l\u00ed\u0161ia sa \u00farov\u0148ou detailu.<\/span><\/p>\n<h3><b>searchdata_site_impression<\/b><b> \u2013 \u00fadaje na \u00farovni dom\u00e9ny<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">T\u00e1to tabu\u013eka obsahuje <\/span><b>agregovan\u00e9 d\u00e1ta pre cel\u00fa dom\u00e9nu<\/b><span style=\"font-weight: 400;\">, bez rozl\u00ed\u0161enia na jednotliv\u00e9 str\u00e1nky. Obsahuje nasledovn\u00e9 polia:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Date<\/b><span style=\"font-weight: 400;\"> \u2013 d\u00e1tum, ku ktor\u00e9mu sa metriky via\u017eu<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Country<\/b><span style=\"font-weight: 400;\"> \u2013 krajina pou\u017e\u00edvate\u013ea<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Device<\/b><span style=\"font-weight: 400;\"> \u2013 typ zariadenia (desktop, mobile, tablet)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Search type<\/b><span style=\"font-weight: 400;\"> \u2013 typ vyh\u013ead\u00e1vania (web, image, video, news)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Impressions<\/b><span style=\"font-weight: 400;\"> \u2013 po\u010det zobrazen\u00ed vo v\u00fdsledkoch vyh\u013ead\u00e1vania<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Clicks<\/b><span style=\"font-weight: 400;\"> \u2013 po\u010det kliknut\u00ed na v\u00fdsledok<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Sum of top positions<\/b><span style=\"font-weight: 400;\"> \u2013 s\u00fa\u010det najlep\u0161\u00edch poz\u00edci\u00ed pre kombin\u00e1cie query\u2013page (vhodn\u00e9 na v\u00fdpo\u010det priemernej poz\u00edcie)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">&#x1f449; T\u00e1to tabu\u013eka je vhodn\u00e1 na <\/span><b>sledovanie makro trendov<\/b><span style=\"font-weight: 400;\">, v\u00fdkonnosti naprie\u010d krajinami alebo zariadeniami a porovn\u00e1vanie v\u00fdkonu v \u010dase na \u00farovni cel\u00e9ho webu.<\/span><\/p>\n<h3><b>searchdata_url_impression<\/b><b> \u2013 \u00fadaje na \u00farovni konkr\u00e9tnych str\u00e1nok<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">T\u00e1to tabu\u013eka ide viac do h\u013abky a obsahuje <\/span><b>detailn\u00e9 metriky na \u00farovni jednotliv\u00fdch URL adries<\/b><span style=\"font-weight: 400;\">. Roz\u0161\u00edren\u00e9 polia obsahuj\u00fa:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>URL<\/b><span style=\"font-weight: 400;\"> \u2013 konkr\u00e9tna indexovan\u00e1 URL<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Query<\/b><span style=\"font-weight: 400;\"> \u2013 vyh\u013ead\u00e1vac\u00ed dopyt, ktor\u00fd aktivoval zobrazenie<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Date, Country, Device, Search type<\/b><span style=\"font-weight: 400;\"> \u2013 ako vy\u0161\u0161ie<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Impressions<\/b><span style=\"font-weight: 400;\"> \u2013 po\u010det zobrazen\u00ed tejto URL pre dan\u00fd dopyt<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Clicks<\/b><span style=\"font-weight: 400;\"> \u2013 po\u010det kliknut\u00ed na t\u00fato URL z v\u00fdsledkov vyh\u013ead\u00e1vania<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Sum position<\/b><span style=\"font-weight: 400;\"> \u2013 najvy\u0161\u0161ia poz\u00edcia tejto URL pre dan\u00fd dopyt v konkr\u00e9tny de\u0148<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">&#x1f449; T\u00e1to tabu\u013eka je vhodn\u00e1 na <\/span><b>obsahov\u00e9 audity, anal\u00fdzu k\u013e\u00fa\u010dov\u00fdch slov<\/b><span style=\"font-weight: 400;\">, sledovanie v\u00fdkonu konkr\u00e9tnych str\u00e1nok a identifikovanie pr\u00edle\u017eitost\u00ed na optimaliz\u00e1ciu \u2013 napr\u00edklad str\u00e1nok s vysok\u00fdm po\u010dtom impresi\u00ed, no n\u00edzkym CTR.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Obe tabu\u013eky s\u00fa <\/span><b>denne aktualizovan\u00e9<\/b><span style=\"font-weight: 400;\"> a maj\u00fa konzistentn\u00e9 dimenzie (napr. d\u00e1tum, krajina, zariadenie, typ vyh\u013ead\u00e1vania), v\u010faka \u010domu je mo\u017en\u00e9 ich kombinova\u0165 s in\u00fdmi d\u00e1tami.\u00a0<\/span><\/p>\n<h2><b>Pre\u010do sa l\u00ed\u0161ia d\u00e1ta z Google Search Console a Google Analytics?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Aj ke\u010f <\/span><b>Google Search Console (GSC)<\/b><span style=\"font-weight: 400;\"> a <\/span><b>Google Analytics (GA)<\/b><span style=\"font-weight: 400;\"> meraj\u00fa podobn\u00e9 udalosti, ich metriky sa \u010dasto l\u00ed\u0161ia, \u010do m\u00f4\u017ee p\u00f4sobi\u0165 m\u00e4t\u00faco. D\u00f4vodom s\u00fa z\u00e1sadn\u00e9 rozdiely v tom, <\/span><b>\u010do presne tieto n\u00e1stroje meraj\u00fa, ako a kedy tieto d\u00e1ta zaznamen\u00e1vaj\u00fa, aj ako ich spracov\u00e1vaj\u00fa<\/b><span style=\"font-weight: 400;\">.<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">Tu je stru\u010dn\u00fd preh\u013ead rozdielov:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Oblas\u0165<\/b><\/td>\n<td><b>Search Console (GSC)<\/b><\/td>\n<td><b>Google Analytics (GA)<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>\u010co meria?<\/b><\/td>\n<td><span style=\"font-weight: 400;\">V\u00fdkon vo v\u00fdsledkoch vyh\u013ead\u00e1vania Google (zobrazenia, kliknutia, poz\u00edcie)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Spr\u00e1vanie pou\u017e\u00edvate\u013eov na str\u00e1nke (n\u00e1v\u0161tevy, interakcie, konverzie)<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Ako zaznamen\u00e1va?<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Ka\u017ed\u00fd klik na v\u00fdsledok vyh\u013ead\u00e1vania Google<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Session za\u010d\u00edna a\u017e po na\u010d\u00edtan\u00ed GA trackera na str\u00e1nke<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Zdroje d\u00e1t<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Iba organick\u00e9 v\u00fdsledky vyh\u013ead\u00e1vania Google<\/span><\/td>\n<td><span style=\"font-weight: 400;\">V\u0161etky zdroje n\u00e1v\u0161tev (organick\u00e9, platen\u00e9, referral, direct&#8230;)<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Atrib\u00facia<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Neprira\u010fuje konverzie \u2013 meria len klik ako vstup<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Prira\u010fuje konverzie pod\u013ea zvolen\u00e9ho atribu\u010dn\u00e9ho modelu<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>\u010casov\u00e9 p\u00e1sma<\/b><\/td>\n<td><span style=\"font-weight: 400;\">\u00dadaje s\u00fa zaznamenan\u00e9 pod\u013ea <\/span><b>pacifick\u00e9ho \u010dasu (PST)<\/b><\/td>\n<td><span style=\"font-weight: 400;\">D\u00e1ta s\u00fa zaznamenan\u00e9 pod\u013ea <\/span><b>nastaven\u00e9ho \u010dasov\u00e9ho p\u00e1sma \u00fa\u010dtu<\/b><\/td>\n<\/tr>\n<tr>\n<td><b>Filtrovanie<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Obsahuje aj automatizovan\u00e9 kliky (boty m\u00f4\u017eu by\u0165 pr\u00edtomn\u00e9)<\/span><\/td>\n<td><span style=\"font-weight: 400;\">GA automaticky vylu\u010duje n\u00e1v\u0161tevnos\u0165 zn\u00e1mych botov a crawlerov<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>Presnos\u0165 z\u00e1znamu<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Z\u00e1znam klikov priamo zo serverov Google \u2013 nevy\u017eaduje JavaScript<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Z\u00e1vis\u00ed od na\u010d\u00edtania JavaScript trackera \u2013 m\u00f4\u017ee by\u0165 blokovan\u00fd<\/span><\/td>\n<\/tr>\n<tr>\n<td><b>\u00darove\u0148 d\u00e1t<\/b><\/td>\n<td><span style=\"font-weight: 400;\">Prim\u00e1rne zalo\u017een\u00e9 na URL a dopytoch<\/span><\/td>\n<td><span style=\"font-weight: 400;\">Pracuje so sessions a user ID \u2013 zachyt\u00e1va r\u00f4zne interakcie<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"font-weight: 400;\">Nie v\u0161etky kliknutia, ktor\u00e9 vid\u00edte v Search Console, sa teda musia objavi\u0165 aj ako n\u00e1v\u0161tevy v Google Analytics. D\u00f4vody s\u00fa r\u00f4zne:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">pou\u017e\u00edvate\u013e m\u00f4\u017ee str\u00e1nku r\u00fdchlo opusti\u0165 sk\u00f4r, ne\u017e sa na\u010d\u00edta GA skript,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">adblockery m\u00f4\u017eu zabr\u00e1ni\u0165 zaznamenaniu n\u00e1v\u0161tevy,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">alebo klik poch\u00e1dzal z bota, ktor\u00fd nezalo\u017e\u00ed session v GA.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Preto d\u00e1va v\u00fdznam <\/span><b>kombinova\u0165 d\u00e1ta z GSC a GA cez BigQuery<\/b><span style=\"font-weight: 400;\">. Z\u00edskate t\u00fdm \u0161ir\u0161\u00ed a presnej\u0161\u00ed poh\u013ead na to, <\/span><b>ak\u00e9 vyh\u013ead\u00e1vanie priv\u00e1dza n\u00e1v\u0161tevn\u00edkov na web (GSC)<\/b><span style=\"font-weight: 400;\"> a <\/span><b>\u010do tam n\u00e1sledne robia (GA)<\/b><span style=\"font-weight: 400;\">. Toto prepojenie v\u00e1m m\u00f4\u017ee pom\u00f4c\u0165 odhali\u0165 medzery vo v\u00fdkonnosti a identifikova\u0165 nov\u00e9 pr\u00edle\u017eitosti na optimaliz\u00e1ciu webu aj kampan\u00ed.<\/span><\/p>\n<h2><b>Dva u\u017eito\u010dn\u00e9 SQL dopyty pre SEO analytikov<\/b><\/h2>\n<ol>\n<li><b> Preh\u013ead v\u00fdkonnosti za posledn\u00fdch 30 dn\u00ed<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Tento dopyt poskytuje preh\u013ead o tom, ako si jednotliv\u00e9 URL adresy v\u00e1\u0161ho webu viedli vo v\u00fdsledkoch vyh\u013ead\u00e1vania Google za posledn\u00fdch 30 dn\u00ed. D\u00e1ta s\u00fa rozdelen\u00e9 pod\u013ea str\u00e1nky (URL), krajiny a typu zariadenia (mobil, desktop, tablet).<\/span><\/p>\n<pre style=\"background-color: #f4f4f4; padding: 1em; border-radius: 6px; overflow-x: auto; font-family: monospace; font-size: 14px;\"><code><strong>SELECT<\/strong>\r\n  url,\r\n  country,\r\n  device,\r\n  SUM(impressions) AS total_impressions,\r\n  SUM(clicks) AS total_clicks,\r\n  ROUND(SAFE_DIVIDE(SUM(clicks), SUM(impressions)) * 100, 2) AS ctr_percentage,\r\n  ROUND(SUM(sum_position) \/ SUM(impressions) + 1, 2) AS avg_position\r\n<strong>FROM<\/strong>\r\n  `project_id.dataset_id.searchdata_url_impression`\r\n<strong>WHERE<\/strong>\r\n  data_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) AND CURRENT_DATE()\r\n<strong>GROUP BY\r\n<\/strong>  url, country, device\r\n<strong>HAVING<\/strong>\r\n  total_impressions &gt; 100\r\n<strong>ORDER BY\r\n<\/strong>  total_clicks DESC\r\n<strong>LIMIT<\/strong> 100;\r\n<\/code><\/pre>\n<p><strong>Na \u010do je to u\u017eito\u010dn\u00e9?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Pom\u00f4\u017ee v\u00e1m zisti\u0165:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Najv\u00fdkonnej\u0161ie str\u00e1nky \u2013 zoradenie pod\u013ea po\u010dtu kliknut\u00ed odhal\u00ed, ktor\u00e9 URL prin\u00e1\u0161aj\u00fa najviac n\u00e1v\u0161tev.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">V\u00fdkonnos\u0165 pod\u013ea krajiny a zariadenia \u2013 \u013eahko porovn\u00e1te, ako si rovnak\u00e1 str\u00e1nka vedie napr. na mobile vs. desktope alebo v r\u00f4znych krajin\u00e1ch.<\/span><\/li>\n<\/ul>\n<ol start=\"2\">\n<li><b> Anal\u00fdza vyh\u013ead\u00e1vania a k\u013e\u00fa\u010dov\u00fdch udalost\u00ed<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">Tento dopyt kombinuje d\u00e1ta z dvoch zdrojov:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Google Search Console (GSC): poskytuje inform\u00e1cie o tom, ako \u010dasto sa konkr\u00e9tne str\u00e1nky (landing pages) zobrazuj\u00fa a klikaj\u00fa vo v\u00fdsledkoch vyh\u013ead\u00e1vania, vr\u00e1tane konkr\u00e9tnych vyh\u013ead\u00e1vac\u00edch dopytov.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Google Analytics 4 (GA4): poskytuje d\u00e1ta o skuto\u010dnom spr\u00e1van\u00ed pou\u017e\u00edvate\u013eov po pr\u00edchode na str\u00e1nku, najm\u00e4 o k\u013e\u00fa\u010dov\u00fdch alebo engagement eventoch (napr. scrollovanie, interakcia, \u010das na str\u00e1nke).<\/span><\/p>\n<pre style=\"background-color: #f4f4f4; padding: 1em; border-radius: 6px; overflow-x: auto; font-family: monospace; font-size: 14px;\"><code>\r\nWITH gsc_query_clicks AS (\r\n  SELECT\r\n    query,\r\n    url AS landing_page,\r\n    SUM(clicks) AS total_clicks,\r\n    SUM(impressions) AS total_impressions,\r\n    ROUND(SUM(sum_position) \/ SUM(impressions) + 1, 2) AS avg_position\r\n  FROM\r\n    `project_id.dataset_id.searchdata_url_impression`\r\n  WHERE\r\n    data_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) AND CURRENT_DATE()\r\n  GROUP BY\r\n    query, landing_page\r\n),\r\n\r\nga4_engagements AS (\r\n  SELECT\r\n    ep.value.string_value AS landing_page,\r\n    COUNT(*) AS engagement_events\r\n  FROM\r\n    `project_id.dataset_id.events_*` AS e,\r\n    UNNEST(e.event_params) AS ep\r\n  WHERE\r\n    _TABLE_SUFFIX BETWEEN FORMAT_DATE('%Y%m%d', DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY))\r\n                     AND FORMAT_DATE('%Y%m%d', CURRENT_DATE())\r\n    AND e.event_name IN (\"user_engagement\") -- m\u00f4\u017eete zmeni\u0165 na k\u013e\u00fa\u010dov\u00e9 eventy\r\n    AND ep.key = \"page_location\"\r\n  GROUP BY\r\n    landing_page\r\n)\r\n\r\nSELECT\r\n  g.query,\r\n  g.landing_page,\r\n  g.total_clicks,\r\n  g.total_impressions,\r\n  ROUND(SAFE_DIVIDE(g.total_clicks, g.total_impressions) * 100, 2) AS ctr_percentage,\r\n  g.avg_position,\r\n  COALESCE(e.engagement_events, 0) AS engagement_events\r\nFROM\r\n  gsc_query_clicks g\r\nLEFT JOIN\r\n  ga4_engagements e\r\nON\r\n  g.landing_page = e.landing_page\r\nORDER BY\r\n  g.total_clicks DESC\r\nLIMIT 100;<\/code><\/pre>\n<p><strong>Na \u010do je to u\u017eito\u010dn\u00e9?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Pom\u00f4\u017ee v\u00e1m zisti\u0165:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>efekt\u00edvne vyh\u013ead\u00e1vacie dopyty<\/b><span style=\"font-weight: 400;\">, ktor\u00e9 priv\u00e1dzaj\u00fa n\u00e1v\u0161tevnos\u0165 na konkr\u00e9tne vstupn\u00e9 str\u00e1nky a dosahuj\u00fa vysok\u00fd po\u010det kliknut\u00ed,<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>kvalitu n\u00e1v\u0161tevnosti<\/b><span style=\"font-weight: 400;\">, teda ktor\u00e9 dopyty ved\u00fa nielen k preklikom, ale aj k re\u00e1lnemu zapojeniu pou\u017e\u00edvate\u013eov na str\u00e1nke,<\/span><\/li>\n<\/ul>\n<h1><b>Z\u00e1ver<\/b><\/h1>\n<p><span style=\"font-weight: 400;\">Export d\u00e1t z Google Search Console do BigQuery roz\u0161\u00edri va\u0161e analytick\u00e9 mo\u017enosti. Namiesto obmedzen\u00e9ho 16-mesa\u010dn\u00e9ho historick\u00e9ho poh\u013eadu v \u0161tandardnom rozhran\u00ed budete ma\u0165 neobmedzen\u00fd pr\u00edstup k va\u0161im \u00fadajom o vyh\u013ead\u00e1van\u00ed.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Navy\u0161e prepojen\u00edm s Google Analytics \u010di in\u00fdmi zdrojmi z\u00edskate komplexn\u00fd poh\u013ead na cestu pou\u017e\u00edvate\u013ea &#8211; od vyh\u013ead\u00e1vania a\u017e po konverziu. Pritom nastavenie exportu je jednoduch\u00e9 a zvl\u00e1dnute\u013en\u00e9 aj pre menej technicky zdatn\u00fdch pou\u017e\u00edvate\u013eov.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Vysk\u00fa\u0161ajte, ni\u010d za to ned\u00e1te. &#x270c;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Search Console (GSC) patr\u00ed medzi z\u00e1kladn\u00e9 n\u00e1stroje ka\u017ed\u00e9ho SEO \u0161pecialistu, preto\u017ee poskytuje k\u013e\u00fa\u010dov\u00e9 \u00fadaje o tom, ako&#8230;<\/p>\n","protected":false},"author":78,"featured_media":20819,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[639],"tags":[673,1037],"_links":{"self":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/20813"}],"collection":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/comments?post=20813"}],"version-history":[{"count":5,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/20813\/revisions"}],"predecessor-version":[{"id":20817,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/posts\/20813\/revisions\/20817"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media\/20819"}],"wp:attachment":[{"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/media?parent=20813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/categories?post=20813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dase-analytics.com\/blog\/sk\/wp-json\/wp\/v2\/tags?post=20813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}