{"id":11554,"date":"2024-11-08T12:33:35","date_gmt":"2024-11-08T03:33:35","guid":{"rendered":"https:\/\/www.data-be.at\/magazine\/?p=11554"},"modified":"2025-05-16T17:34:04","modified_gmt":"2025-05-16T08:34:04","slug":"ga4-bigquery","status":"publish","type":"post","link":"https:\/\/www.data-be.at\/magazine\/ga4-bigquery\/","title":{"rendered":"Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b94\uff08GA4\uff09\u3068BigQuery\u9023\u643a\u307e\u3068\u3081\uff01Export\u306e\u65b9\u6cd5\u304b\u3089\u30c7\u30fc\u30bf\u306e\u78ba\u8a8d\u3001\u53ef\u8996\u5316\u307e\u3067\u3092\u8a73\u3057\u304f\u89e3\u8aac"},"content":{"rendered":"<p>2020\u5e7410\u6708\u306b\u30ea\u30ea\u30fc\u30b9\u3055\u308c\u305fGoogle\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u306e\u65b0\u3057\u3044\u898f\u683c\u3067\u3042\u308b\u3001GA4\uff08Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b94\u30d7\u30ed\u30d1\u30c6\u30a3\uff09\u3002GA4\u306f\u3001BigQuery\u3068\u9023\u643a\u3059\u308b\u3053\u3068\u3067\u6d3b\u7528\u306e\u5e45\u3092\u5927\u304d\u304f\u5e83\u3052\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u307e\u305f\u3001UA\uff08\u30e6\u30cb\u30d0\u30fc\u30b5\u30eb\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\uff09\u306f\u30012023\u5e747\u67081\u65e5\u3067Google\u306e\u30b5\u30dd\u30fc\u30c8\u304c\u7d42\u4e86\u3057\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u3092\u30a2\u30af\u30bb\u30b9\u89e3\u6790\u30c4\u30fc\u30eb\u3068\u3057\u3066\u5229\u7528\u3057\u3064\u3065\u3051\u308b\u306b\u306f\u3001GA4\u3078\u306e\u79fb\u884c\u304c\u5fc5\u9808\u3067\u3059\u3002<\/p>\n<p>\u305d\u3053\u3067\u4eca\u56de\u306f\u3001GA4\u3068BigQuery\u306e\u9023\u643a\u65b9\u6cd5\u304b\u3089\u3088\u304f\u4f7f\u3046SQL\u3001\u305d\u3057\u3066Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3092\u6d3b\u7528\u3057\u305f\u53ef\u8996\u5316\u306e\u65b9\u6cd5\u307e\u3067\u3001\u8a73\u3057\u304f\u89e3\u8aac\u3057\u307e\u3059\u3002GA4\u306e\u30c7\u30fc\u30bf\u3092Web\u30b5\u30a4\u30c8\u3084\u30a2\u30d7\u30ea\u306e\u5206\u6790\u3067\u3082\u3063\u3068\u6d3b\u7528\u3057\u3066\u3044\u304d\u305f\u3044\u65b9\u306f\u3001\u305c\u3072\u3054\u89a7\u304f\u3060\u3055\u3044\u3002<\/p>\n<div class=\"ep-box bgc-VPsky\">\u203b\u53c2\u8003\uff1aUA\u304b\u3089GA4\u3078\u306e\u79fb\u884c\u624b\u9806\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3057\u305f\u8a18\u4e8b\u306f\u3053\u3061\u3089<br \/>\n\r\n\t\t\t<div class=\"sitecard\">\r\n\t\t\t\t<div class=\"sitecard__subtitle\">\u95a2\u9023\u8a18\u4e8b<\/div>\r\n\t\t\t\t<div class=\"sitecard__contents\">\r\n\t\t\t\t\t<div class=\"heading heading-secondary\"><a href=\"https:\/\/www.data-be.at\/magazine\/ga4-transition\/\" target=\"_self\">Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b94\uff08GA4\uff09\u79fb\u884c\u30ac\u30a4\u30c9\uff01\u5c0e\u5165\u30e1\u30ea\u30c3\u30c8\u3084\u79fb\u884c\u65b9\u6cd5\u3092\u8a73\u3057\u304f\u89e3\u8aac<\/a><\/div>\r\n\t\t\t\t\t<p class=\"phrase phrase-tertiary\">\u30a2\u30af\u30bb\u30b9\u89e3\u6790\u30c4\u30fc\u30eb\u3068\u3057\u3066\u771f\u3063\u5148\u306b\u601d\u3044\u3064\u304f\u4eba\u6c17\u30c4\u30fc\u30eb\u3067\u3082\u3042\u308b\u300cGoogle\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u300d\u3002\u30e6\u30cb\u30d0\u30fc\u30b5\u30eb\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u306e\u6b21\u4e16\u4ee3\u7248\u3068\u3057\u3066\u767a\u8868\u3055\u308c\u305fGA4\u306f\u3001\u5229\u7528\u8005\u306e\u9593\u3067\u306f\u30cb\u30e5\u30fc\u30b9\u3068\u306a\u308a\u307e\u3057\u305f\u3002\u3057\u304b\u3057\u3001\u73fe\u884c\u306eGA\u3068\u304b\u306a\u308a\u4ed5\u69d8\u304c\u9055\u3046\u306e\u3067\u3001\u304a\u56f0\u308a\u306e\u62c5[\u2026]<\/p>\r\n\t\t\t\t<\/div>\r\n\t\t\t\t<div class=\"eyecatch eyecatch-11\"><a class=\"eyecatch__link eyecatch__link-maskzoomrotate\" href=\"https:\/\/www.data-be.at\/magazine\/ga4-transition\/\" target=\"_self\"><img decoding=\"async\" width=\"375\" height=\"250\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/05\/AdobeStock_286274722_Editorial_Use_Only-375x250.jpeg\" class=\"attachment-icatch375 size-icatch375 wp-post-image\" alt=\"Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b94\uff08GA4\uff09\u79fb\u884c\u30ac\u30a4\u30c9\uff01\u5c0e\u5165\u30e1\u30ea\u30c3\u30c8\u3084\u79fb\u884c\u65b9\u6cd5\u3092\u8a73\u3057\u304f\u89e3\u8aac\" \/><\/a><\/div>\r\n\t\t\t<\/div><\/div>\n<div><a href=\"https:\/\/lp.data-be.at\/free-looker-studio-template?utm_source=media&amp;utm_medium=databeatmagazine&amp;utm_campaign=text&amp;utm_content=template\" target=\"_blank\" rel=\"noopener\">\u3010\u7121\u6599\u3011Looker Studio\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306f\u3053\u3061\u3089\uff1e\uff1e<\/a><\/div>\n<h2>BigQuery\u3068\u306f\uff1f<\/h2>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11560\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/9832d478fd17e7afe3d8610b6c8e6f3d-1024x588.png\" alt=\"BigQuery\u30a4\u30e1\u30fc\u30b8\" width=\"1024\" height=\"588\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/cloud.google.com\/blog\/products\/data-analytics\/google-cloud-a-leader-in-2021-forrester-wave-cloud-data-warehouse?hl=ja\" target=\"_blank\" rel=\"noopener noreferrer\">BigQuery<\/a><\/span><\/p>\n<p>BigQuery\u3068\u306f\u3001Google\u304c\u63d0\u4f9b\u3059\u308b\u30c7\u30fc\u30bf\u30a6\u30a8\u30a2\u30cf\u30a6\u30b9\u88fd\u54c1\u3067\u3059\u3002\u30c7\u30fc\u30bf\u30a6\u30a8\u30a2\u30cf\u30a6\u30b9\u3068\u306f\u5404\u7a2e\u30b7\u30b9\u30c6\u30e0\u304b\u3089\u5206\u6790\u7528\u306b\u53ce\u96c6\u3057\u305f\u81a8\u5927\u306a\u30c7\u30fc\u30bf\u3092\u84c4\u7a4d\u3057\u3066\u304a\u304f\u3001\u5009\u5eab\u306e\u3088\u3046\u306a\u30b7\u30b9\u30c6\u30e0\u3067\u3059\u3002<\/p>\n<p>BigQuery\u306f\u3001<span class=\"marker-thickYellow\"><strong>\u8d85\u9ad8\u901f\u306a\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u7279\u5fb4\u3068\u3057\u3066\u3044\u307e\u3059<\/strong>\u3002<\/span>TB\uff08\u30c6\u30e9\u30d0\u30a4\u30c8\uff09\u3084PB\uff08\u30da\u30bf\u30d0\u30a4\u30c8\uff09\u3001\u3064\u307e\u308a\u6570\u5104\u884c\u4ee5\u4e0a\u306e\u30c7\u30fc\u30bf\u3078\u306e\u30af\u30a8\u30ea\u51e6\u7406\u3092\u6570\u79d2\u304b\u3089\u6570\u5206\u3067\u5b9f\u884c\u3057\u3001\u30e6\u30fc\u30b6\u30fc\u306b\u7d50\u679c\u3092\u8fd4\u3057\u3066\u304f\u308c\u307e\u3059\u3002<\/p>\n<p>\u6709\u511f\u306e\u88fd\u54c1\u3068\u306a\u308a\u307e\u3059\u304c\u3001\u30c7\u30fc\u30bf\u30a6\u30a8\u30a2\u30cf\u30a6\u30b9\u88fd\u54c1\u306e\u4e2d\u3067\u306f\u5b89\u4fa1\u3067\u3042\u308a\u3001\u3044\u307e\u3084\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u5206\u6790\u306e\u73fe\u5834\u3067\u6b20\u304b\u305b\u306a\u3044\u5b58\u5728\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<div><a href=\"https:\/\/lp.data-be.at\/free-looker-studio-template?utm_source=media&amp;utm_medium=databeatmagazine&amp;utm_campaign=text&amp;utm_content=template\" target=\"_blank\" rel=\"noopener\">\u3010\u7121\u6599\u3011Looker Studio\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306f\u3053\u3061\u3089\uff1e\uff1e<\/a><\/div>\n<h2>Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b94\uff08GA4\uff09\u3068BigQuery\u306e\u9023\u643a\u306b\u95a2\u3059\u308b\u57fa\u790e\u77e5\u8b58<\/h2>\n<p>GA4\u3068BigQuery\u306e\u9023\u643a\u306b\u95a2\u3059\u308b\u57fa\u790e\u77e5\u8b58\u3068\u3057\u3066\u3001\u9023\u643a\u306b\u3088\u308a\u5b9f\u73fe\u3067\u304d\u308b\u3053\u3068\u3001GA4\u304b\u3089\u53d6\u5f97\u3067\u304d\u308b\u4e3b\u306a\u30c7\u30fc\u30bf\u3001\u5229\u7528\u6599\u91d1\u306b\u3064\u3044\u3066\u305d\u308c\u305e\u308c\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<h3>GA4\u306e\u30c7\u30fc\u30bf\u3092BigQuery\u306b\u9023\u643a\u3059\u308b\u3053\u3068\u3067\u5b9f\u73fe\u3067\u304d\u308b\u3053\u3068<\/h3>\n<p>GA4\u306e\u30c7\u30fc\u30bf\u3092BigQuery\u306b\u9023\u643a\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u5b9f\u73fe\u3067\u304d\u308b\u3053\u3068\u3068\u3057\u3066\u3001\u4ee3\u8868\u4f8b\u30923\u3064\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<div class=\"ep-box es-BsubTradi bgc-white es-borderSolidM es-radius brc-DPred\" title=\"\u5b9f\u73fe\u3067\u304d\u308b\u3053\u3068\">\n<ol>\n<li>GA4\u306e\u30c7\u30fc\u30bf\u3092SQL\u3067\u5206\u6790\u3067\u304d\u308b<\/li>\n<li>GA4\u306e\u30c7\u30fc\u30bf\u3092\u65e2\u5b58\u30c7\u30fc\u30bf\u3068\u7d71\u5408\u3057\u3066\u5206\u6790\u3067\u304d\u308b<\/li>\n<li>GA4\u306e\u30c7\u30fc\u30bf\u3092\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30ba\u3067\u304d\u308b<\/li>\n<\/ol>\n<\/div>\n<h4 class=\"icon-checkbox-checked\">\u3000\uff11\uff1aGA4\u306e\u30c7\u30fc\u30bf\u3092SQL\u3067\u5206\u6790\u3067\u304d\u308b<\/h4>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11563\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/f1814545c398ced031580100ed0a5372-1024x713.png\" alt=\"Bigquery\u3067\u5b9f\u73fe\u3067\u304d\u308b\u3053\u3068\u2460\" width=\"1024\" height=\"713\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">BigQuery<\/a><\/span><\/p>\n<p><span class=\"marker-thickYellow\"><strong>GA4\u3068BigQuery\u3092\u9023\u643a\u3055\u305b\u308b\u3053\u3068\u3067\u3001GA4\u306e\u751f\u30c7\u30fc\u30bf\u3092SQL\u306b\u3088\u3063\u3066\u81ea\u7531\u306b\u5206\u6790\u3067\u304d\u307e\u3059<\/strong>\u3002<\/span>GA4\u4ee5\u524d\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u3001\u30e6\u30cb\u30d0\u30fc\u30b5\u30eb\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\uff08UA\uff09\u3067\u306f\u6709\u511f\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u306a\u3044\u9650\u308a\u3001\u751f\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/p>\n<p>\u3064\u307e\u308a\u3001UA\u3067\u306f\u30b0\u30e9\u30d5\u3084\u8868\u306a\u3069\u96c6\u8a08\u5f8c\u306e\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u3066\u3082\u3001\u751f\u30c7\u30fc\u30bf\u3092\u76f4\u63a5\u5206\u6790\u3067\u304d\u308b\u6a5f\u4f1a\u306f\u9650\u3089\u308c\u3066\u3044\u305f\u306e\u3067\u3059\u3002\u4e00\u65b9\u3067\u3001<span class=\"marker-thickYellow\"><strong>GA4\u3067\u306f\u751f\u30c7\u30fc\u30bf\u3092BigQuery\u3068\u9023\u643a\u3055\u305b\u308b\u6a5f\u80fd\u304c\u7121\u6599\u3067\u63d0\u4f9b\u3055\u308c\u3066\u3044\u307e\u3059<\/strong>\u3002\uff08\u9023\u643a\u5f8c\u306bBigQuery\u3067\u30c7\u30fc\u30bf\u51e6\u7406\u3092\u884c\u3046\u3068\u5225\u9014\u6599\u91d1\u304c\u767a\u751f\u3057\u307e\u3059\u304c\u3001\u9023\u643a\u81ea\u4f53\u306f\u7121\u6599\u3067\u3067\u304d\u307e\u3059\uff09<\/span><\/p>\n<p>BigQuery\u3068\u9023\u643a\u3057\u305f\u751f\u30c7\u30fc\u30bf\u306f\u3001\u30da\u30fc\u30b8\u30d3\u30e5\u30fc\uff08PV\uff09\u6570\u3084\u96e2\u8131\u6570\u3001\u76f4\u5e30\u6570\u3001\u6ede\u5728\u6642\u9593\u306a\u3069\u306e\u6307\u6a19\u3092\u3055\u307e\u3056\u307e\u306a\u5207\u308a\u53e3\u3067\u3001SQL\u3092\u4f7f\u3063\u3066\u81ea\u5728\u306b\u5206\u6790\u3067\u304d\u307e\u3059\u3002<\/p>\n<h4 class=\"icon-checkbox-checked\">\u3000\uff12\uff1aGA4\u306e\u30c7\u30fc\u30bf\u3092\u65e2\u5b58\u30c7\u30fc\u30bf\u3068\u7d71\u5408\u3057\u3066\u5206\u6790\u3067\u304d\u308b<\/h4>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11564\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/277fc88f33ffac38c002440e80c0cb23.png\" alt=\"Bigquery\u3067\u5b9f\u73fe\u3067\u304d\u308b\u3053\u3068\u2461\" width=\"703\" height=\"588\" \/><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/support.google.com\/analytics\/answer\/9212670?visit_id=637663494502167442-484042448&amp;rd=1\" target=\"_blank\" rel=\"noopener noreferrer\">GA4<\/a><\/span><\/p>\n<p>GA4\u306e\u751f\u30c7\u30fc\u30bf\u3092BigQuery\u306b\u9023\u643a\u3059\u308c\u3070\u3001<span class=\"marker-thickYellow\"><strong>BigQuery\u3067\u65e2\u306b\u7ba1\u7406\u3057\u3066\u3044\u308b\u4ed6\u306e\u30c7\u30fc\u30bf\u3068\u7d71\u5408\u3057\u3066\u5206\u6790\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd<\/strong>\u3068\u306a\u308a\u307e\u3059\u3002<\/span>\u4f8b\u3048\u3070GA4\u304b\u3089\u53d6\u5f97\u3057\u305f\u30b5\u30a4\u30c8\u4e0a\u306e\u95b2\u89a7\u5c65\u6b74\u3068\u3001\u30aa\u30d5\u30e9\u30a4\u30f3\u8cfc\u8cb7\u5c65\u6b74\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u5206\u6790\u3059\u308b\u3068\u3044\u3063\u305f\u3053\u3068\u304c\u5b9f\u73fe\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>GA4\u306e\u30c7\u30fc\u30bf\u304b\u3089\u306f\u3001Web\u3068\u30a2\u30d7\u30ea\u3092\u307e\u305f\u304c\u3063\u305f\u30e6\u30fc\u30b6\u30fc\u306e\u884c\u52d5\u30c7\u30fc\u30bf\u304c\u5f97\u3089\u308c\u307e\u3059\u3002\u305d\u3053\u306b\u30aa\u30d5\u30e9\u30a4\u30f3\u306e\u8cfc\u8cb7\u5c65\u6b74\u3082\u7d10\u4ed8\u3051\u308b\u3053\u3068\u3067\u3001\u30cd\u30c3\u30c8\u3068\u30ea\u30a2\u30eb\u3092\u307e\u305f\u304c\u308b\u3001<span class=\"marker-thickYellow\"><strong>\u3053\u308c\u307e\u3067\u6349\u3048\u304d\u308c\u306a\u304b\u3063\u305f\u30ab\u30b9\u30bf\u30de\u30fc\u30b8\u30e3\u30fc\u30cb\u30fc\u304c\u6d6e\u304b\u3073\u4e0a\u304c\u3063\u3066\u304f\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093<\/strong>\u3002<\/span><\/p>\n<h4 class=\"icon-checkbox-checked\">\u3000\uff13\uff1aGA4\u306e\u30c7\u30fc\u30bf\u3092\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30ba\u3067\u304d\u308b<\/h4>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11565\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/469ba7dfaf24bc776ce4813470671ed2.png\" alt=\"Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\u30a4\u30e1\u30fc\u30b8\" width=\"970\" height=\"720\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6X3kxNHlWcFBrQkU\/page\/LuBV\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>GA4\u306e\u30c7\u30fc\u30bf\u3092BigQuery\u306b\u9023\u643a\u3055\u305b\u308b\u3053\u3068\u3067\u3001<span class=\"marker-thickYellow\"><strong>GA4\u306e\u30c7\u30fc\u30bf\u3092\u30b0\u30e9\u30d5\u3084\u8868\u306b\u53ef\u8996\u5316\u3067\u304d\u307e\u3059<\/strong>\u3002<\/span><strong>BigQuery\u4e0a\u306e\u30c7\u30fc\u30bf\u306fLooker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3092\u306f\u3058\u3081\u3001Tableau\u3084Power BI\u306a\u3069\u306eBI\u30c4\u30fc\u30eb\u3068\u9023\u643a\u3055\u305b\u308b\u3053\u3068\u304c\u53ef\u80fd\u306a\u305f\u3081\u3067\u3059\u3002<\/strong><\/p>\n<p><span class=\"marker-thickYellow\"><strong>\u307e\u305f\u3001BigQuery\u3068BI\u30c4\u30fc\u30eb\u3092\u9023\u643a\u3055\u305b\u308b\u3053\u3068\u3067\u3001GA4\u306e\u30c7\u30fc\u30bf\u3092\u30c9\u30e9\u30c3\u30b0\uff06\u30c9\u30ed\u30c3\u30d7\u306b\u3088\u308b\u76f4\u611f\u7684\u306a\u64cd\u4f5c\u3067\u30d3\u30b8\u30e5\u30a2\u30eb\u5316\u3067\u304d\u307e\u3059<\/strong>\u3002<\/span>\u30b5\u30a4\u30c8\u5185\u306e\u30e6\u30fc\u30b6\u30fc\u306e\u884c\u52d5\u5c65\u6b74\u3092\u3001\u30a8\u30f3\u30c9\u30e6\u30fc\u30b6\u30fc\u304c\u63a2\u7d22\u7684\u306b\u30af\u30ed\u30b9\u96c6\u8a08\u3057\u305f\u308a\u3001\u30b0\u30e9\u30d5\u5316\u3057\u305f\u308a\u3068\u3044\u3063\u305f\u3053\u3068\u304c\u53ef\u80fd\u3068\u306a\u308b\u306e\u3067\u3059\u3002<\/p>\n<p>BI\u30c4\u30fc\u30eb\u306b\u3088\u3063\u3066\u306f\u3001\u30ec\u30dd\u30fc\u30c8\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u9023\u643a\u306e\u8a2d\u5b9a\u3055\u3048\u3059\u308c\u3070\u3059\u3050\u306bGA4\u306e\u30c7\u30fc\u30bf\u3092\u30ec\u30dd\u30fc\u30c8\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n<div class=\"ep-box bgc-VPsky\">\n<p>\u203b\u53c2\u8003\uff1aGA4\u3068Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3057\u305f\u8a18\u4e8b\u306f\u3053\u3061\u3089<\/p>\n\r\n\t\t\t<div class=\"sitecard\">\r\n\t\t\t\t<div class=\"sitecard__subtitle\">\u95a2\u9023\u8a18\u4e8b<\/div>\r\n\t\t\t\t<div class=\"sitecard__contents\">\r\n\t\t\t\t\t<div class=\"heading heading-secondary\"><a href=\"https:\/\/www.data-be.at\/magazine\/ga4-dataportal\/\" target=\"_self\">GA4\u00d7\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff08\u73feLooker Studio\uff09\u6d3b\u7528\u5206\u6790\u30ac\u30a4\u30c9<\/a><\/div>\r\n\t\t\t\t\t<p class=\"phrase phrase-tertiary\">2023\u5e747\u6708\u306b\u5b8c\u5168\u79fb\u884c\u3055\u308c\u305fGA4\uff08Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b94\uff09\u3002\r\n\r\n\u65e7\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u3068\u4ed5\u69d8\u304c\u5927\u304d\u304f\u5909\u5316\u3057\u305f\u305f\u3081\u3001GA4\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u4e8b\u696d\u8005\u306e\u65b9\u306e\u4e2d\u306b\u3001\u6b21\u306e\u3088\u3046\u306a\u60a9\u307f\u3084\u7591\u554f\u3092\u304a\u6301\u3061\u306e\u65b9\u3082\u3044\u3089\u3063\u3057\u3083\u308b\u306e\u3067\u306f\u3042\u308a\u307e\u305b\u3093\u304b\u3002\r\n\r\n\r\n\u300c[\u2026]<\/p>\r\n\t\t\t\t<\/div>\r\n\t\t\t\t<div class=\"eyecatch eyecatch-11\"><a class=\"eyecatch__link eyecatch__link-maskzoomrotate\" href=\"https:\/\/www.data-be.at\/magazine\/ga4-dataportal\/\" target=\"_self\"><img decoding=\"async\" width=\"375\" height=\"211\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/07\/Clean-Work-Place-Blog-Banner-2021-07-16T140804.767-375x211.png\" class=\"attachment-icatch375 size-icatch375 wp-post-image\" alt=\"Google\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b94\uff08GA4\uff09\u306e\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\u3092\u6d3b\u7528\u3057\u305f\u5206\u6790\u30ac\u30a4\u30c9\uff01\u9023\u643a\u65b9\u6cd5\u304b\u3089\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u307e\u3067\u8a73\u3057\u304f\u89e3\u8aac\" \/><\/a><\/div>\r\n\t\t\t<\/div>\n<\/div>\n<h3>BigQuery\u3068\u306e\u9023\u643a\u3067\u53d6\u5f97\u3067\u304d\u308b\u4e3b\u306aGA4\u306e\u30c7\u30fc\u30bf<\/h3>\n<p><span class=\"marker-thickYellow\"><strong>GA4\u3067\u306f\u3001Web\u30b5\u30a4\u30c8\u306e\u30ed\u30b0\u8a08\u6e2c\u6a5f\u80fd\u304c\u5f37\u5316\u3055\u308c\u307e\u3057\u305f<\/strong>\u3002<\/span>UA\u3067\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u8a08\u6e2c\u3055\u308c\u3066\u3044\u305f\u30da\u30fc\u30b8\u30d3\u30e5\u30fc\uff08PV\uff09\u6570\u306f\u3082\u3061\u308d\u3093\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u3092\u30b9\u30a4\u30c3\u30c1\u3092ON\u306b\u3059\u308b\u3060\u3051\u3067\u53d6\u5f97\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<div class=\"ep-box\">\n<ul>\n<li style=\"font-weight: 400;\"><strong>\u30b9\u30af\u30ed\u30fc\u30eb\u6570<\/strong>\uff1a\u30da\u30fc\u30b8\u306e\u4e00\u756a\u4e0b\u307e\u3067\u30b9\u30af\u30ed\u30fc\u30eb\u3055\u308c\u308b\u305f\u3073\u306b\u3001\u30b9\u30af\u30ed\u30fc\u30eb\u30a4\u30d9\u30f3\u30c8\u3092\u8a18\u9332<\/li>\n<li style=\"font-weight: 400;\"><strong>\u96e2\u8131\u30af\u30ea\u30c3\u30af<\/strong>\uff1a\u30e6\u30fc\u30b6\u30fc\u304c\u30c9\u30e1\u30a4\u30f3\u304b\u3089\u79fb\u52d5\u3059\u308b\u30ea\u30f3\u30af\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u305f\u3073\u306b\u3001\u96e2\u8131\u30af\u30ea\u30c3\u30af\u30a4\u30d9\u30f3\u30c8\u3092\u8a18\u9332<\/li>\n<li style=\"font-weight: 400;\"><strong>\u30b5\u30a4\u30c8\u5185\u691c\u7d22<\/strong>\uff1a\u30e6\u30fc\u30b6\u30fc\u304c\u30b5\u30a4\u30c8\u4e0a\u3067\u691c\u7d22\u3092\u884c\u3046\u305f\u3073\u306b\u3001\u691c\u7d22\u7d50\u679c\u306e\u8868\u793a\u30a4\u30d9\u30f3\u30c8\u3092\u8a18\u9332<\/li>\n<li style=\"font-weight: 400;\"><strong>\u52d5\u753b\u30a8\u30f3\u30b2\u30fc\u30b8\u30e1\u30f3\u30c8<\/strong>\uff1a\u30e6\u30fc\u30b6\u30fc\u304c\u30b5\u30a4\u30c8\u306b\u57cb\u3081\u8fbc\u307e\u308c\u305f\u52d5\u753b\u3092\u8996\u8074\u3059\u308b\u3068\u3001\u52d5\u753b\u518d\u751f\u30a4\u30d9\u30f3\u30c8\u3001\u52d5\u753b\u9032\u6357\u30a4\u30d9\u30f3\u30c8\u3001\u52d5\u753b\u5b8c\u5168\u518d\u751f\u30a4\u30d9\u30f3\u30c8\u3092\u8a18\u9332<\/li>\n<li style=\"font-weight: 400;\"><strong>\u30d5\u30a1\u30a4\u30eb\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/strong>\uff1a\u4e00\u822c\u7684\u306a\u6587\u66f8\u3001\u5727\u7e2e\u30d5\u30a1\u30a4\u30eb\u3001\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3001\u52d5\u753b\u3001\u97f3\u58f0\u62e1\u5f35\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\u30ea\u30f3\u30af\u304c\u30af\u30ea\u30c3\u30af\u3055\u308c\u308b\u305f\u3073\u306b\u3001\u30d5\u30a1\u30a4\u30eb\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u30a4\u30d9\u30f3\u30c8\u3092\u8a18\u9332<\/li>\n<\/ul>\n<\/div>\n<p>\u3053\u308c\u3089\u306e\u30c7\u30fc\u30bf\u3092\u3001<span class=\"marker-thickYellow\"><strong>\u8868\u3084\u30b0\u30e9\u30d5\u3068\u3044\u3063\u305f\u96c6\u8a08\u5f8c\u306e\u30c7\u30fc\u30bf\u3067\u306f\u306a\u304f\u3001\u751f\u30c7\u30fc\u30bf\u306e\u304b\u305f\u3061\u3067BigQuery\u306b\u9023\u643a\u3067\u304d\u308b\u3053\u3068\u3082\u30dd\u30a4\u30f3\u30c8<\/strong>\u3067\u3059\u3002<\/span>\u3053\u308c\u306b\u3088\u308a\u3001\u30cb\u30fc\u30ba\u306b\u5fdc\u3058\u305f\u5207\u308a\u53e3\u3067\u3088\u308a\u67d4\u8edf\u306b\u5206\u6790\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b\u304b\u3089\u3067\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u3053\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u3092\u4f7f\u3048\u3070\u3001\u30e6\u30fc\u30b6\u30fc\u304c\u3069\u3053\u304b\u3089\u6d41\u5165\u3057\u3066\u304d\u3066\u3069\u306e\u3088\u3046\u306b\u30da\u30fc\u30b8\u3092\u79fb\u52d5\u3057\u3001\u3069\u3053\u3067\u96e2\u8131\u3057\u305f\u306e\u304b\u3068\u3044\u3063\u305f\u8a73\u7d30\u306a\u884c\u52d5\u3092\u5206\u6790\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3>GA4\u306e\u30c7\u30fc\u30bf\u3092BigQuery\u306b\u9023\u643a\u3059\u308b\u3053\u3068\u3067\u767a\u751f\u3059\u308b\u6599\u91d1<\/h3>\n<p>BigQuery\u306f\u6709\u511f\u306e\u30c7\u30fc\u30bf\u30a6\u30a8\u30a2\u30cf\u30a6\u30b9\u88fd\u54c1\u3067\u3059\u3002\u305d\u306e\u305f\u3081\u3001<span class=\"marker-thickYellow\"><strong>GA4\u3068BigQuery\u306e\u9023\u643a\u6a5f\u80fd\u81ea\u4f53\u306f\u7121\u6599\u3067\u63d0\u4f9b\u3055\u308c\u3066\u3044\u308b\u3082\u306e\u306e\u3001\u9023\u643a\u5f8c\u306b\u306fBigQuery\u5074\u3067\u5229\u7528\u6599\u91d1\u304c\u767a\u751f<\/strong>\u3057\u307e\u3059\u3002<\/span><\/p>\n<p>BigQuery\u306e\u5229\u7528\u6599\u91d1\u306b\u306f\u3001\u4e3b\u3068\u3057\u3066\u4ee5\u4e0b2\u3064\u306e\u8cbb\u76ee\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<div class=\"ep-box\">\n<ul>\n<li style=\"font-weight: 400;\">\u5206\u6790\u6599\u91d1\uff1a\u30af\u30a8\u30ea\u306e\u51e6\u7406\u306b\u304b\u304b\u308b\u8cbb\u7528<\/li>\n<li style=\"font-weight: 400;\">\u30b9\u30c8\u30ec\u30fc\u30b8\u6599\u91d1\uff1aBigQuery\u3078\u306e\u30c7\u30fc\u30bf\u306e\u4fdd\u7ba1\u6599<\/li>\n<\/ul>\n<\/div>\n<p>\u5206\u6790\u6599\u91d1\u3068\u3057\u3066\u306f\u3001\u51e6\u7406\u3057\u305f\u30c7\u30fc\u30bf\u306e\u5206\u3060\u3051\u5f93\u91cf\u8ab2\u91d1\u3055\u308c\u308b\u300c\u30aa\u30f3\u30c7\u30de\u30f3\u30c9\u6599\u91d1\u300d\u3068\u3001\u6708\u984d\u3084\u5e74\u984d\u3067\u652f\u6255\u3046\u300c\u5b9a\u984d\u6599\u91d1\u300d\u306e2\u30d1\u30bf\u30fc\u30f3\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<h4>\uff1cBigQuery \u6599\u91d1\u8868\uff1e<\/h4>\n<table>\n<tbody>\n<tr>\n<th style=\"background-color: #b0c4de;\"><b>\u30aa\u30da\u30ec\u30fc\u30b7\u30e7\u30f3<\/b><\/th>\n<th style=\"background-color: #b0c4de;\"><b>\u6599\u91d1<\/b><\/th>\n<th style=\"background-color: #b0c4de;\"><b>\u8a73\u7d30<\/b><\/th>\n<\/tr>\n<tr>\n<td>\u30af\u30a8\u30ea\uff08\u30aa\u30f3\u30c7\u30de\u30f3\u30c9\uff09<\/td>\n<td>$6.0(\u7d04660\u5186)\/ TB<\/td>\n<td>\u6bce\u67081TB \u307e\u3067\u7121\u6599<\/td>\n<\/tr>\n<tr>\n<td>\u30af\u30a8\u30ea\uff08\u6708\u5b9a\u984d\uff09<\/td>\n<td>$2,400(\u7d0426.4\u4e07\u5186)\/100slots<\/td>\n<td>\u8ffd\u52a0\u306e\u30b9\u30ed\u30c3\u30c8\u306f100\u30b9\u30ed\u30c3\u30c8\u5358\u4f4d\u3067\u8cfc\u5165\u53ef\u80fd<\/td>\n<\/tr>\n<tr>\n<td>\u30af\u30a8\u30ea\uff08\u5e74\u5b9a\u984d\uff09<\/td>\n<td>$2,040 (\u7d0422.4\u4e07\u5186)\/100slots\uff081\u30f6\u6708\u5206\uff09<\/td>\n<td>\u8ffd\u52a0\u306e\u30b9\u30ed\u30c3\u30c8\u306f100\u30b9\u30ed\u30c3\u30c8\u5358\u4f4d\u3067\u8cfc\u5165\u53ef\u80fd<\/td>\n<\/tr>\n<tr>\n<td>\u30a2\u30af\u30c6\u30a3\u30d6\u30b9\u30c8\u30ec\u30fc\u30b8<\/td>\n<td>$0.023 (\u7d042.53\u5186)\/GB<\/td>\n<td>\u6bce\u670810GB\u307e\u3067\u7121\u6599<\/td>\n<\/tr>\n<tr>\n<td>\u9577\u671f\u4fdd\u5b58<\/td>\n<td>$0.016(\u7d041.76\u5186)\/GB<\/td>\n<td>\u6bce\u670810GB\u307e\u3067\u7121\u6599<\/td>\n<\/tr>\n<tr>\n<td>\u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u633f\u5165<\/td>\n<td>$0.012(\u7d041.32\u5186)\/200MB<\/td>\n<td>\u633f\u5165\u306b\u6210\u529f\u3057\u305f\u884c\u304c\u8ab2\u91d1\u5bfe\u8c61\u306b\u306a\u308a\u307e\u3059\u3002\u6700\u5c0f\u30b5\u30a4\u30ba 1KB\u3067\u5404\u884c\u304c\u8a08\u7b97\u3055\u308c\u307e\u3059<\/td>\n<\/tr>\n<tr>\n<td>BigQuery Storage Write API<\/td>\n<td>$0.030(\u7d043.3\u5186)\/1GB<\/td>\n<td>\u6bce\u6708\u6700\u521d\u306e2TB\u307e\u3067\u7121\u6599<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/cloud.google.com\/bigquery\/pricing\/?hl=ja\" target=\"_blank\" rel=\"noopener noreferrer\">BigQuery\u306e\u6599\u91d1<\/a><\/span><\/p>\n<p>\u30b9\u30c8\u30ec\u30fc\u30b8\u6599\u91d1\u306f\u5b89\u4fa1\u3067\u3042\u308b\u305f\u3081\u3001<span class=\"marker-thickYellow\"><strong>\u30af\u30a8\u30ea\u51e6\u7406\u3067\u30b9\u30ad\u30e3\u30f3\u3059\u308b\u30c7\u30fc\u30bf\u91cf\u3092\u6291\u3048\u308b\u3053\u3068\u304c\u91cd\u8981<\/strong>\u3067\u3059\u3002<\/span>\u5fc5\u8981\u306a\u5217\u3084\u884c\u3092\u3001\u5fc5\u8981\u306a\u56de\u6570\u3060\u3051\u53d6\u5f97\u3059\u308b\u3088\u3046\u306b\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u307e\u305f\u3001BigQuery\u5074\u3067\u300c\u8ab2\u91d1\u3055\u308c\u308b\u6700\u5927\u30d0\u30a4\u30c8\u6570\u300d\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u3051\u3070\u3001\u4e0a\u9650\u5024\u3092\u8d85\u3048\u308b\u8ab2\u91d1\u306f\u3055\u308c\u306a\u3044\u306e\u3067\u5b89\u5fc3\u3067\u3059\u3002<\/p>\n<h3>\u3010\u53c2\u8003\u3011BigQuery\u3092\u4f7f\u308f\u305aGA4\u306eLooker Studio\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-18222\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2023\/05\/image3-1024x576.png\" alt=\"GA4\u306eLooker Studio\u30ec\u30dd\u30fc\u30c8\" width=\"1024\" height=\"576\" \/><\/p>\n<p>BigQuery\u306f\u30c7\u30fc\u30bf\u51e6\u7406\u304c\u9ad8\u901f\u3067\u3001\u5fc5\u8981\u306a\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u30fb\u5229\u7528\u3057\u3084\u3059\u3044\u306e\u304c\u30e1\u30ea\u30c3\u30c8\u3067\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001BigQuery\u3092\u5229\u7528\u3057\u305f\u3053\u3068\u304c\u306a\u3044\u65b9\u306e\u306a\u304b\u306b\u306f\u3001\u3044\u304d\u306a\u308a\u8cbb\u7528\u3092\u304b\u3051\u3066\u5229\u7528\u3059\u308b\u3053\u3068\u306b\u62b5\u6297\u3092\u611f\u3058\u308b\u65b9\u3082\u3044\u3089\u3063\u3057\u3083\u308b\u3067\u3057\u3087\u3046\u3002<\/p>\n<p>\u305d\u306e\u3088\u3046\u306a\u5834\u5408\u306f\u3001\u307e\u305aBigQuery\u3092\u4f7f\u308f\u305a\u306bLooker Studio\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u4f7f\u3063\u3066GA4\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u307f\u308b\u306e\u3082\u304a\u3059\u3059\u3081\u3067\u3059\u3002<\/p>\n<p><span class=\"marker-thickYellow\"><strong>GA4\u306eLooker Studio\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u624b\u9806\u3084\u3059\u3050\u306b\u5229\u7528\u3067\u304d\u308b\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306f\u300cDatabeat \u30aa\u30f3\u30e9\u30a4\u30f3\u30b9\u30af\u30fc\u30eb\u300d\u3067\u7121\u6599\u516c\u958b\u3057\u3066\u304a\u308a\u307e\u3059\u306e\u3067\u3001\u305c\u3072\u304a\u6c17\u8efd\u306b\u53d7\u8b1b\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/strong><\/span><\/p>\n<div class=\"btn btn-center\"><strong><a class=\"btn__link btn__link-primary\" href=\"https:\/\/school.data-be.at\/\" target=\"_blank\" rel=\"noopener\">Databeat \u30aa\u30f3\u30e9\u30a4\u30f3\u30b9\u30af\u30fc\u30eb\u306f\u3053\u3061\u3089<\/a><\/strong><\/div>\n<h2>GA4\u30c7\u30fc\u30bf\u306eBigQuery\u3078\u306e\u9023\u643a\uff08BigQuery\u3078\u306eExport\uff09\u65b9\u6cd5<\/h2>\n<p>GA4\u30c7\u30fc\u30bf\u3092BigQuery\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u624b\u9806\u3092\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002GA4\u3068BigQuery\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u6301\u3063\u3066\u3044\u308c\u3070\u3001\u4ee5\u4e0b\u306e\u624b\u9806\u3067\u7c21\u5358\u306b\u8a2d\u5b9a\u3067\u304d\u307e\u3059\u306e\u3067\u305c\u3072\u304a\u8a66\u3057\u304f\u3060\u3055\u3044\u3002<\/p>\n<h3>\u624b\u98061.BigQuery\u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3059\u308b<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11566\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/39f29f5f5b7f3e9a54ecb021fdc47440-1024x539.png\" alt=\"1.\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\" width=\"1024\" height=\"539\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u307e\u305a\u306fGoogle Cloud\u306e\u7ba1\u7406\u753b\u9762\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u307e\u3059\u3002Google Cloud\u3068\u306f\u3001BigQuery\u304c\u63d0\u4f9b\u3055\u308c\u3066\u3044\u308bGoogle\u306e\u30af\u30e9\u30a6\u30c9\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u3059\u3002<\/p>\n<p>Google Cloud\u306eURL\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/console.cloud.google.com\/<\/a><\/p>\n<p>\u30ed\u30b0\u30a4\u30f3\u3057\u305f\u3089\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u9078\u629e\u306e\u753b\u9762\u3092\u958b\u304d\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11567\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/daf3d12ad8f16a10287aedf418a7d720.png\" alt=\"2.\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\" width=\"761\" height=\"599\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u3064\u304e\u306b\u3001\u300c\u65b0\u3057\u3044\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11568\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/530e641635904c109b51a27196500a14.png\" alt=\"3.\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d\u3001ID\u3001\u5834\u6240\u3092\u4efb\u610f\u306b\u7de8\u96c6\" width=\"608\" height=\"477\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u300c\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d\u300d\u3001\u300c\u30d7\u30ed\u30b8\u30a7\u30af\u30c8ID\u300d\u3001\u300c\u5834\u6240\u300d\u3092\u4efb\u610f\u306b\u7de8\u96c6\u3057\u3066\u300c\u4f5c\u6210\u300d\u3092\u62bc\u4e0b\u3057\u307e\u3059\u3002\u4ee5\u4e0a\u3067\u3001BigQuery\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u4f5c\u6210\u306e\u624b\u9806\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n<h3>\u624b\u98062.BigQuery API\u306e\u6709\u52b9\u5316\u3092\u78ba\u8a8d\u3059\u308b<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11569\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/cf71dfbb7427deb318277863ba7cbf9a.png\" alt=\"4.\u5148\u307b\u3069\u4f5c\u6210\u3057\u305f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\" width=\"723\" height=\"485\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u4e0a\u8a18\u306e\u624b\u9806\u3067\u4f5c\u6210\u3057\u305f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11571\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/ea0936407f45c271d837b58344b74cfb.png\" alt=\"6.API\u3068\u30b5\u30fc\u30d3\u30b9\u3001\u30e9\u30a4\u30d6\u30e9\u30ea\" width=\"994\" height=\"640\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u5de6\u5074\u306e\u30e1\u30cb\u30e5\u30fc\u3088\u308a\u3001\u300cAPI\u3068\u30b5\u30fc\u30d3\u30b9\u300d\u21db\u300c\u30e9\u30a4\u30d6\u30e9\u30ea\u300d\u306e\u9806\u306b\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11570\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/b3c4aea8dff39cce0ba708e33d8183b8.png\" alt=\"5.\u30ab\u30c6\u30b4\u30ea\u3001\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\" width=\"966\" height=\"640\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u6b21\u306b\u3001\u300c\u30ab\u30c6\u30b4\u30ea\u300d\u21db\u300c\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u300d\u306e\u9806\u306b\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11572\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/366862bff64725e61b6f0a0e6e45093c-1024x733.png\" alt=\"7.BigqueryAPI\u3092\u9078\u629e\" width=\"1024\" height=\"733\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u300c\u30d3\u30c3\u30b0\u30c7\u30fc\u30bf\u300d\u306e\u753b\u9762\u3067\u3001\u300cBigQuery API\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11573\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/964449726563f9d4fbd727e6d886b395.png\" alt=\"8.API\u6709\u52b9\u78ba\u8a8d\" width=\"950\" height=\"628\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u300cAPI\u304c\u6709\u52b9\u3067\u3059\u300d\u3068\u8868\u793a\u3055\u308c\u3066\u3044\u308c\u3070\u6709\u52b9\u5316\u306e\u78ba\u8a8d\u306f\u5b8c\u4e86\u3067\u3059\u3002\u8868\u793a\u3055\u308c\u3066\u3044\u306a\u3051\u308c\u3070\u3001\u6709\u52b9\u5316\u3057\u307e\u3059\u3002\u4ee5\u4e0a\u3067BigQuery API\u306e\u6709\u52b9\u5316\u78ba\u8a8d\u306e\u624b\u9806\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n<h3>\u624b\u98063.GA4\u3092BigQuery\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u9023\u643a\u3055\u305b\u308b<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11574\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/4713d52ecb00e74e7512bc04eafb11dd-1024x728.png\" alt=\"9.Bigquery\u306e\u30ea\u30f3\u30af\u8a2d\u5b9a\" width=\"1024\" height=\"728\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/analytics.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">GA4<\/a><\/span><\/p>\n<p>GA4\u306e\u7ba1\u7406\u753b\u9762\u3092\u958b\u304d\u3001\u300cBigQuery\u306e\u30ea\u30f3\u30af\u8a2d\u5b9a\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11575\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/44588f9d0952989b5f61f3fe7de04b24-1024x196.png\" alt=\"10.\u30ea\u30f3\u30af\u3092\u9078\u629e\" width=\"1024\" height=\"196\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/analytics.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">GA4<\/a><\/span><\/p>\n<p>\u3064\u304e\u306b\u3001\u300c\u30ea\u30f3\u30af\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11576\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/7daf743b331c8d3934313343312dd6d0-1024x384.png\" alt=\"11.Bigquery\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\" width=\"1024\" height=\"384\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/analytics.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">GA4<\/a><\/span><\/p>\n<p>\u5148\u307b\u3069\u4f5c\u6210\u3057\u305fBigQuery\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11577\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/612d188a463c7a17486bb8ede80cc19c-1024x521.png\" alt=\"12.\u30ed\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u9078\u629e\" width=\"1024\" height=\"521\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/analytics.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">GA4<\/a><\/span><\/p>\n<p>\u300c\u30c7\u30fc\u30bf\u30ed\u30b1\u30fc\u30b7\u30e7\u30f3\u300d\u3092\u300c\u6771\u4eac\u300d\u306a\u3069\u306b\u8a2d\u5b9a\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11578\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/cac23e8683f49ce92072d353d38404c0-1024x569.png\" alt=\"13.\u983b\u5ea6\u3092\u9078\u629e\" width=\"1024\" height=\"569\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/analytics.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">GA4<\/a><\/span><\/p>\n<p>\u6b21\u306b\u300c\u983b\u5ea6\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002\u300c\u6bce\u65e5\u300d\u3042\u308b\u3044\u306f\u300c\u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u300d\u3092\u9078\u3079\u307e\u3059\u3002\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u3067\u306e\u30c7\u30fc\u30bf\u9023\u643a\u304c\u5fc5\u9808\u3067\u306a\u3051\u308c\u3070\u3001\u300c\u30b9\u30c8\u30ea\u30fc\u30df\u30f3\u30b0\u300d\u306e\u30c1\u30a7\u30c3\u30af\u306f\u5916\u3057\u3066\u304a\u3044\u3066\u3088\u3044\u3067\u3057\u3087\u3046\u3002<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11580\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/685d3d3a7deb3713cad011fbd3147368.png\" alt=\"14.\u8a2d\u5b9a\u3057\u305f\u5185\u5bb9\u3092\u78ba\u8a8d\u3057\u3066\u9001\u4fe1\" width=\"814\" height=\"873\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/analytics.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">GA4<\/a><\/span><\/p>\n<p>\u8a2d\u5b9a\u3057\u305f\u5185\u5bb9\u3092\u78ba\u8a8d\u306e\u3046\u3048\u3001\u300c\u9001\u4fe1\u300d\u3092\u62bc\u4e0b\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11581\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/b36b1fc7fae0be8811af3a12c81cbb3b-1024x203.png\" alt=\"\" width=\"1024\" height=\"203\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/analytics.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">GA4<\/a><\/span><\/p>\n<p>\u9001\u4fe1\u3059\u308b\u3068\u3001GA4\u3068BigQuery\u304c\u63a5\u7d9a\u3055\u308c\u307e\u3059\u3002\u63a5\u7d9a\u304c\u5b8c\u4e86\u3059\u308b\u3068\u3001GA4\u306e\u300cBigQuery\u306e\u30ea\u30f3\u30af\u8a2d\u5b9a\u300d\u306b\u9023\u643a\u5148\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002GA4\u306e\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u306f\u3001\u8a2d\u5b9a\u5f8c24\u6642\u9593\u4ee5\u5185\u306bBigQuery\u4e0a\u306b\u53cd\u6620\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u4ee5\u4e0a\u3067\u3001GA4\u304b\u3089BigQuery\u306b\u30c7\u30fc\u30bf\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3059\u308b\u305f\u3081\u306e\u624b\u9806\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>BigQuery\u306b\u9023\u643a\u3057\u305fGA4\u30c7\u30fc\u30bf\u306e\u78ba\u8a8d\u65b9\u6cd5<\/h2>\n<p>\u7d9a\u3044\u3066\u3001BigQuery\u4e0a\u3067GA4\u306e\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002BigQuery\u5074\u3067GA4\u304b\u3089\u9023\u643a\u5bfe\u8c61\u3068\u3057\u3066\u8a2d\u5b9a\u3057\u305f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3>\u624b\u98061.Google Cloud\u306b\u3066\u9023\u643a\u5bfe\u8c61\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u753b\u9762\u3092\u958b\u304f<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11582\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/6f4eb0ea140fc43acfdc966a399db8c3-1024x492.png\" alt=\"16.\u9023\u643a\u5bfe\u8c61\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u753b\u9762\" width=\"1024\" height=\"492\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>Google Cloud\u306e\u7ba1\u7406\u753b\u9762\u306b\u3066\u3001GA4\u3067\u9023\u643a\u5bfe\u8c61\u3068\u3057\u3066\u8a2d\u5b9a\u3057\u305f\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u753b\u9762\u3092\u958b\u304d\u307e\u3059\u3002<\/p>\n<h3>\u624b\u98062.BigQuery\u4e0a\u3067GA4\u304b\u3089\u9023\u643a\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11583\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/b6900fdbff8e941cd55780993b5b3732-1024x629.png\" alt=\"17.Bigquery\u3092\u9078\u629e\" width=\"1024\" height=\"629\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u5de6\u5074\u306e\u30e1\u30cb\u30e5\u30fc\u3088\u308a\u3001\u300cBigQuery\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11659\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/3c8ea4a2853d6d65d7c800644de02f3f-1-1024x557.png\" alt=\"18.\u9023\u643a\u30c7\u30fc\u30bf\u78ba\u8a8d\" width=\"1024\" height=\"557\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>BigQuery\u306e\u753b\u9762\u3067\u3001\u5bfe\u8c61\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\u3059\u308b\u3068\u3001GA4\u306e\u30c7\u30fc\u30bf\u304c\u9023\u643a\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u4e2d\u306b\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u304c\u4f5c\u6210\u3055\u308c\u3001\u305d\u306e\u4e0b\u3067\u65e5\u6b21\u3067\u30c6\u30fc\u30d6\u30eb\u304c\u751f\u6210\u3055\u308c\u308b\u304b\u305f\u3061\u3067\u3059\u3002<\/p>\n<p>\u4ee5\u4e0a\u3067\u3001BigQuery\u4e0a\u3067GA4\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306e\u624b\u9806\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>BigQuery\u3067GA4\u306e\u30c7\u30fc\u30bf\u3092\u6271\u3046\uff01\u3088\u304f\u4f7f\u3046SQL\u30b5\u30f3\u30d7\u30eb<\/h2>\n<p>GA4\u304b\u3089BigQuery\u306b\u30c7\u30fc\u30bf\u3092\u9023\u643a\u3067\u304d\u305f\u3089\u3001SQL\u3092\u4f7f\u3063\u3066\u5206\u6790\u3057\u3066\u3044\u304f\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001\u305d\u306e\u969b\u306b\u3088\u304f\u4f7f\u3046SQL\u306e\u30b5\u30f3\u30d7\u30eb\u3092\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<div class=\"ep-box es-BsubTradi bgc-white es-borderSolidM es-radius brc-DPred\" title=\"\u3088\u304f\u4f7f\u3046SQL\u30b5\u30f3\u30d7\u30eb\">\n<ol>\n<li>\u30d6\u30e9\u30a6\u30b6\u5225\u306e\u5408\u8a08PV\u6570\u3092\u96c6\u8a08\u3059\u308bSQL<\/li>\n<li>\u7d4c\u8def\u5225\u6d41\u5165\u4ef6\u6570\u3068\u5e73\u5747\u76f4\u5e30\u7387\u3092\u96c6\u8a08\u3059\u308bSQL<\/li>\n<li>\u8cfc\u5165\u56de\u6570\u5225\u306e\u5e73\u5747PV\u6570\u3092\u96c6\u8a08\u3059\u308bSQL<\/li>\n<li>\u8cfc\u5165\u30e6\u30fc\u30b6\u30fc\u306e\u5e73\u5747\u30b5\u30a4\u30c8\u6ede\u5728\u6642\u9593\u3092\u96c6\u8a08\u3059\u308bSQL<\/li>\n<li>\u8cfc\u5165\u30e6\u30fc\u30b6\u30fc\u306e\u30da\u30fc\u30b8\u9077\u79fb\u3092\u6642\u7cfb\u5217\u3067\u8868\u793a\u3059\u308bSQL<\/li>\n<\/ol>\n<\/div>\n<h3>\u30d6\u30e9\u30a6\u30b6\u5225\u306e\u5408\u8a08PV\u6570\u3092\u96c6\u8a08\u3059\u308bSQL<\/h3>\n<p>\u30b5\u30a4\u30c8\u306ePV\u6570\u3092\u30d6\u30e9\u30a6\u30b6\u5225\u306b\u96c6\u8a08\u3059\u308bSQL\u3067\u3059\u3002GA4\u304b\u3089\u306e\u9023\u643a\u30c6\u30fc\u30d6\u30eb\u3092\u30d6\u30e9\u30a6\u30b6\u5358\u4f4d\u3067\u30b0\u30eb\u30fc\u30d4\u30f3\u30b0\u3057\u3001PV\u6570\u306eSUM\u3092\u3068\u308a\u307e\u3059\u3002<\/p>\n<div class=\"ep-box es-Bicon icon-tag bgc-VPorange\">\n<p>SELECT<\/p>\n<p>device.browser,<\/p>\n<p>SUM ( totals.pageviews ) AS total_pageviews<\/p>\n<p>FROM `YOUR_TABLE.events_*` &#8212; PLEASE REPLACE WITH YOUR TABLE NAME.<\/p>\n<p>WHERE<\/p>\n<p>_TABLE_SUFFIX BETWEEN &#8216;20170701&#8217; AND &#8216;20170731&#8217;<\/p>\n<p>GROUP BY<\/p>\n<p>device.browser<\/p>\n<p>ORDER BY<\/p>\n<p>total_pageviews DESC<\/p>\n<\/div>\n<h4 class=\"icon-magic-wand\">\u3000\u8868\u793a\u7d50\u679c<\/h4>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11585\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/5bf9e4dfc07c975a7b1243a262cbcdca.png\" alt=\"19.PV\u7d50\u679c\" width=\"535\" height=\"310\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u30d6\u30e9\u30a6\u30b6\u5225\u306e\u5408\u8a08PV\u6570\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<h3>\u7d4c\u8def\u5225\u6d41\u5165\u4ef6\u6570\u3068\u5e73\u5747\u76f4\u5e30\u7387\u3092\u96c6\u8a08\u3059\u308bSQL<\/h3>\n<p>\u5e83\u544a\u30ad\u30e3\u30f3\u30da\u30fc\u30f3\u5225\u306e\u5408\u8a08\u6d41\u5165\u4ef6\u6570\u3068\u3001\u5e73\u5747\u76f4\u5e30\u7387\u3092\u96c6\u8a08\u3059\u308bSQL\u3067\u3059\u3002\u76f4\u5e30\u7387\u306f\u30da\u30fc\u30b8\u30d3\u30e5\u30fc\u304c1\u3064\u3060\u3051\u3060\u3063\u305f\u8a2a\u554f\u306e\u5272\u5408\u3092\u610f\u5473\u3057\u307e\u3059\u3002<\/p>\n<div class=\"ep-box es-Bicon icon-tag bgc-VPorange\">\n<p>SELECT<\/p>\n<p>campaign,<\/p>\n<p>total_visits,<\/p>\n<p>total_no_of_bounces,<\/p>\n<p>( ( total_no_of_bounces \/ total_visits ) * 100 ) AS bounce_rate<\/p>\n<p>FROM (<\/p>\n<p>SELECT<\/p>\n<p>trafficSource.campaign AS campaign,<\/p>\n<p>COUNT ( trafficSource.campaign ) AS total_visits,<\/p>\n<p>SUM ( totals.bounces ) AS total_no_of_bounces<\/p>\n<p>FROM `YOUR_TABLE.events_*` &#8212; PLEASE REPLACE WITH YOUR TABLE NAME.<\/p>\n<p>WHERE<\/p>\n<p>_TABLE_SUFFIX BETWEEN &#8216;20170701&#8217; AND &#8216;20170731&#8217;<\/p>\n<p>GROUP BY<\/p>\n<p>campaign )<\/p>\n<p>ORDER BY<\/p>\n<p>total_visits DESC<\/p>\n<\/div>\n<h4 class=\"icon-magic-wand\">\u3000\u8868\u793a\u7d50\u679c<\/h4>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11586\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/1f7b59a64552803324c8a55717d2ef62.png\" alt=\"20.\u76f4\u5e30\u7387\u7d50\u679c\" width=\"631\" height=\"308\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>total_visits\u304c\u30ad\u30e3\u30f3\u30da\u30fc\u30f3\u5225\u306e\u6d41\u5165\u4ef6\u6570\u3001bounce_rate\u304c\u5e73\u5747\u76f4\u5e30\u7387\u3067\u3059\u3002<\/p>\n<h3>\u8cfc\u5165\u56de\u6570\u5225\u306e\u5e73\u5747PV\u6570\u3092\u96c6\u8a08\u3059\u308bSQL<\/h3>\n<p>\u8cfc\u5165\u56de\u6570\u3067\u30e6\u30fc\u30b6\u30fc\u3092\u30b0\u30eb\u30fc\u30d4\u30f3\u30b0\u3057\u3001\u305d\u308c\u305e\u308c\u306e\u5e73\u5747PV\u6570\u3092\u96c6\u8a08\u3059\u308bSQL\u3067\u3059\u3002<\/p>\n<div class=\"ep-box es-Bicon icon-tag bgc-VPorange\">\n<p>&nbsp;<\/p>\n<p>SELECT<\/p>\n<p>transactions,<\/p>\n<p>( SUM(total_pagesviews_per_user) \/ COUNT(users) ) AS avg_pageviews<\/p>\n<p>FROM<\/p>\n<p>(SELECT<\/p>\n<p>fullVisitorId AS users,<\/p>\n<p>totals.transactions AS transactions,<\/p>\n<p>SUM(totals.pageviews) AS total_pagesviews_per_user<\/p>\n<p>FROM `YOUR_TABLE.events_*` &#8212; PLEASE REPLACE WITH YOUR TABLE NAME.<\/p>\n<p>WHERE<\/p>\n<p>_TABLE_SUFFIX BETWEEN &#8216;20170701&#8217; AND &#8216;20170731&#8217;<\/p>\n<p>GROUP BY<\/p>\n<p>users,totals.transactions)<\/p>\n<p>GROUP BY transactions<\/p>\n<p>ORDER BY transactions<\/p>\n<\/div>\n<h4 class=\"icon-magic-wand\">\u3000\u8868\u793a\u7d50\u679c<\/h4>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11587\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/105bafbc57ed1c26ba5835f3b6bdbb3f.png\" alt=\"21.\u8cfc\u5165\u56de\u6570\u5225\u306ePV\u6570\" width=\"519\" height=\"305\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>transactions\u304c\u8cfc\u5165\u56de\u6570\u3001avg_pageviews\u304c\u5e73\u5747\u5546\u54c1PV\u6570\u3067\u3059\u3002\u8cfc\u5165\u306e\u6709\u7121\u306b\u3088\u3063\u3066PV\u6570\u306b\u5927\u304d\u306a\u5dee\u304c\u51fa\u3066\u3044\u307e\u3059\u3002<\/p>\n<h3>\u8cfc\u5165\u30e6\u30fc\u30b6\u30fc\u306e\u5e73\u5747\u30b5\u30a4\u30c8\u6ede\u5728\u6642\u9593\u3092\u96c6\u8a08\u3059\u308bSQL<\/h3>\n<p>\u5546\u54c1\u3092\u8cfc\u5165\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u304c\u3001\u5e73\u5747\u7684\u306b\u3069\u308c\u304f\u3089\u3044\u30b5\u30a4\u30c8\u306b\u6ede\u5728\u3057\u3066\u3044\u305f\u304b\u3092\u96c6\u8a08\u3059\u308bSQL\u3067\u3059\u3002<\/p>\n<div class=\"ep-box es-Bicon icon-tag bgc-VPorange\">\n<p>SELECT<\/p>\n<p>( SUM(total_timeOnSite_per_user) \/ SUM(total_visits_per_user) ) AS<\/p>\n<p>avg_timeOnSite_per_visit<\/p>\n<p>FROM (<\/p>\n<p>SELECT<\/p>\n<p>fullVisitorId,<\/p>\n<p>SUM( totals.visits ) AS total_visits_per_user,<\/p>\n<p>SUM( totals.timeOnSite ) AS total_timeOnSite_per_user<\/p>\n<p>FROM `YOUR_TABLE.events_*` &#8212; PLEASE REPLACE WITH YOUR TABLE NAME.<\/p>\n<p>WHERE<\/p>\n<p>_TABLE_SUFFIX BETWEEN &#8216;20170701&#8217; AND &#8216;20170731&#8217;<\/p>\n<p>AND<\/p>\n<p>totals.visits &gt; 0<\/p>\n<p>AND totals.transactions &gt;= 1<\/p>\n<p>AND totals.timeOnSite IS NOT NULL<\/p>\n<p>GROUP BY<\/p>\n<p>fullVisitorId )<\/p>\n<\/div>\n<h4 class=\"icon-magic-wand\">\u3000\u8868\u793a\u7d50\u679c<\/h4>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11588\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/9392bae9a5462e68e81d0e704b210b38.png\" alt=\"22.\u8cfc\u5165\u30e6\u30fc\u30b6\u5e73\u5747\u6ede\u5728\u6642\u9593\" width=\"535\" height=\"278\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u5546\u54c1\u3092\u8cfc\u5165\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u306e\u5e73\u5747\u6ede\u5728\u6642\u9593\uff08\u79d2\uff09\u304c\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<h3>\u8cfc\u5165\u30e6\u30fc\u30b6\u30fc\u306e\u30da\u30fc\u30b8\u9077\u79fb\u3092\u6642\u7cfb\u5217\u3067\u8868\u793a\u3059\u308bSQL<\/h3>\n<p>\u5546\u54c1\u3092\u8cfc\u5165\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u304c\u30b5\u30a4\u30c8\u6d41\u5165\u5f8c\u3001\u3069\u306e\u3088\u3046\u306b\u30da\u30fc\u30b8\u3092\u9077\u79fb\u3057\u305f\u304b\u8868\u793a\u3059\u308bSQL\u3067\u3059\u3002<\/p>\n<div class=\"ep-box es-Bicon icon-tag bgc-VPorange\">\n<p>SELECT<\/p>\n<p>fullVisitorId,<\/p>\n<p>visitId,<\/p>\n<p>FORMAT_TIMESTAMP(&#8216;%Y-%m-%d %H:%M:%S&#8217;, TIMESTAMP_SECONDS(visitStartTime), &#8216;Asia\/Tokyo&#8217;),<\/p>\n<p>hits.page.pagePath AS pagePath<\/p>\n<p>FROM `YOUR_TABLE.events_*` &#8212; PLEASE REPLACE WITH YOUR TABLE NAME.,<\/p>\n<p>UNNEST(hits) as hits<\/p>\n<p>WHERE<\/p>\n<p>_TABLE_SUFFIX BETWEEN &#8216;20170701&#8217; AND &#8216;20170731&#8217;<\/p>\n<p>AND<\/p>\n<p>hits.type=&#8221;PAGE&#8221;<\/p>\n<p>AND<\/p>\n<p>totals.transactions &gt;= 1<\/p>\n<p>ORDER BY<\/p>\n<p>fullVisitorId,<\/p>\n<p>visitId,<\/p>\n<p>visitStartTime<\/p>\n<\/div>\n<h4 class=\"icon-magic-wand\">\u3000\u8868\u793a\u7d50\u679c<\/h4>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11589\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/76511f0d9ad12f838ef0cc2022f823d1.png\" alt=\"23.\u8cfc\u5165\u30e6\u30fc\u30b6\u30da\u30fc\u30b8\u9077\u79fb\" width=\"758\" height=\"485\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/console.cloud.google.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Cloud<\/a><\/span><\/p>\n<p>\u8cfc\u5165\u30e6\u30fc\u30b6\u30fc\u306e\u30da\u30fc\u30b8\u9077\u79fb\u304c\u6642\u7cfb\u5217\u3067\u8868\u793a\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u30b3\u30f3\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u81f3\u308b\u307e\u3067\u306e\u30eb\u30fc\u30c8\u3092\u5206\u6790\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>BigQuery\u306eGA4\u30c7\u30fc\u30bf\u3092Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3067\u53ef\u8996\u5316\u3059\u308b\u65b9\u6cd5<\/h2>\n<p>BigQuery\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u305fGA4\u30c7\u30fc\u30bf\u3092\u3001Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3067\u53ef\u8996\u5316\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u3066\u3044\u304d\u307e\u3059\u3002Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3067\u306fBigQuery\u7528\u306e\u30b3\u30cd\u30af\u30bf\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u308b\u305f\u3081\u3001\u7c21\u5358\u306a\u64cd\u4f5c\u3067\u9023\u643a\u3001\u53ef\u8996\u5316\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<h3>Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3068\u306f\uff1f<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11590\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/469ba7dfaf24bc776ce4813470671ed2-1.png\" alt=\"Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\u30a4\u30e1\u30fc\u30b8\" width=\"970\" height=\"720\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3068\u306f\u3001Google\u304c\u63d0\u4f9b\u3059\u308bBI\uff08\u30d3\u30b8\u30cd\u30b9\u30fb\u30a4\u30f3\u30c6\u30ea\u30b8\u30a7\u30f3\u30b9\uff09\u30c4\u30fc\u30eb\u3067\u3059\u3002Google\u306e\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u6301\u3063\u3066\u3044\u308c\u3070\u8ab0\u3067\u3082\u5229\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u30a8\u30f3\u30b8\u30cb\u30a2\u3067\u306a\u304f\u3066\u3082\u3001\u30c9\u30e9\u30c3\u30b0\uff06\u30c9\u30ed\u30c3\u30d7\u306b\u3088\u308b\u76f4\u611f\u7684\u306a\u64cd\u4f5c\u3067\u30c7\u30fc\u30bf\u306e\u53ef\u8996\u5316\u304c\u53ef\u80fd\u3067\u3059\u3002\u307e\u305f\u30ec\u30dd\u30fc\u30c8\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u304c\u8c4a\u5bcc\u306b\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u305d\u306e\u305f\u3081\u3001<span class=\"marker-thickYellow\"><strong>\u30e6\u30fc\u30b6\u30fc\u306f\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u3068\u63a5\u7d9a\u3057\u3066\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u9078\u3076\u3060\u3051\u3067\u3001\u3059\u3050\u306b\u30ec\u30dd\u30fc\u30c6\u30a3\u30f3\u30b0\u696d\u52d9\u3092\u958b\u59cb\u3067\u304d\u308b<\/strong>\u306e\u3067\u3059\u3002<\/span><span class=\"marker-thickYellow\"><strong>\u30ec\u30dd\u30fc\u30c8\u306e\u5171\u6709\u3082\u30ea\u30f3\u30af\u3092\u9001\u308b\u3060\u3051\u3067\u7c21\u5358\u306b\u3067\u304d\u308b\u305f\u3081\u3001\u30c1\u30fc\u30e0\u3067\u306e\u6d3b\u7528\u306b\u5411\u3044\u3066\u3044\u308b<\/strong>\u30c4\u30fc\u30eb\u3067\u3059\u3002<\/span><\/p>\n<p>\u30c7\u30fc\u30bf\u9023\u643a\u306b\u95a2\u3057\u3066\u306f\u3001<span class=\"marker-thickYellow\"><strong>BigQuery\u306a\u3069Google\u306e\u88fd\u54c1\u3092\u4e2d\u5fc3\u306b\u5c02\u7528\u306e\u30b3\u30cd\u30af\u30bf\u304c\u7528\u610f\u3055\u308c\u3066\u304a\u308a\u3001\u30b9\u30e0\u30fc\u30ba\u306a\u63a5\u7d9a\u304c\u53ef\u80fd<\/strong>\u3068\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/span>\u57fa\u672c\u7684\u306b\u306f\u7121\u6599\u3067\u5229\u7528\u3067\u304d\u307e\u3059\u304c\u3001BigQuery\u3068\u3064\u306a\u3044\u3067\u30c7\u30fc\u30bf\u53d6\u5f97\u3092\u30ea\u30af\u30a8\u30b9\u30c8\u3059\u308b\u5834\u5408\u3001\u307e\u305f\u306f\u6709\u6599\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u8cfc\u5165\u3059\u308b\u5834\u5408\u306b\u5225\u9014\u6599\u91d1\u304c\u767a\u751f\u3057\u307e\u3059\u3002<\/p>\n<div class=\"ep-box es-BmarkExcl es-borderSolidS brc-DPred bgc-white es-radius\">Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\u306f\u30012022\u5e7410\u670811\u65e5\u306b\u300cLooker Studio\uff08\u30eb\u30c3\u30ab\u30fc\u30b9\u30bf\u30b8\u30aa\uff09\u300d\u3078\u540d\u79f0\u304c\u5909\u66f4\u3068\u306a\u308a\u307e\u3057\u305f\u3002<\/div>\n<div class=\"ep-box bgc-VPsky\">\u203b\u53c2\u8003\uff1aGoogle\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\u306e\u6599\u91d1\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3057\u305f\u8a18\u4e8b\u306f\u3053\u3061\u3089<br \/>\n\r\n\t\t\t<div class=\"sitecard\">\r\n\t\t\t\t<div class=\"sitecard__subtitle\">\u95a2\u9023\u8a18\u4e8b<\/div>\r\n\t\t\t\t<div class=\"sitecard__contents\">\r\n\t\t\t\t\t<div class=\"heading heading-secondary\"><a href=\"https:\/\/www.data-be.at\/magazine\/google-dataportal-fee\/\" target=\"_self\">Looker Studio\uff08\u65e7\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u306e\u6599\u91d1\u3092\u5fb9\u5e95\u89e3\u8aac\uff01\u6709\u6599\u306b\u306a\u308b\u30b1\u30fc\u30b9\u3001\u8cbb\u7528\u3092\u6291\u3048\u308bTIPS\u3082\u7d39\u4ecb<\/a><\/div>\r\n\t\t\t\t\t<p class=\"phrase phrase-tertiary\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb \uff09\u306f\u3001\u7c21\u5358\u306a\u64cd\u4f5c\u3067\u30c7\u30fc\u30bf\u3092\u30d3\u30b8\u30e5\u30a2\u30eb\u5316\u3067\u304d\u308b\u512a\u308c\u305f\u30c4\u30fc\u30eb\u3067\u3059\u3002\u5c0e\u5165\u3092\u691c\u8a0e\u3055\u308c\u3066\u3044\u308b\u65b9\u3082\u591a\u3044\u3068\u601d\u3044\u307e\u3059\u304c\u3001\u6599\u91d1\u304c\u6c17\u306b\u306a\u308b\u3068\u3053\u308d\u3067\u3059\u3002\r\n\r\n\u305d\u3053\u3067\u4eca\u56de\u306f\u3001Looker Studio\uff08\u65e7[\u2026]<\/p>\r\n\t\t\t\t<\/div>\r\n\t\t\t\t<div class=\"eyecatch eyecatch-11\"><a class=\"eyecatch__link eyecatch__link-maskzoomrotate\" href=\"https:\/\/www.data-be.at\/magazine\/google-dataportal-fee\/\" target=\"_self\"><img decoding=\"async\" width=\"375\" height=\"211\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/08\/AdobeStock_340468118-375x211.jpeg\" class=\"attachment-icatch375 size-icatch375 wp-post-image\" alt=\"Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\u306e\u6599\u91d1\u306b\u95a2\u3059\u308b\u7591\u554f\u3092\u5fb9\u5e95\u89e3\u8aac\uff01\u4ed6\u30b5\u30fc\u30d3\u30b9\u9023\u643a\u3084\u30c6\u30f3\u30d7\u30ec\u306a\u3069\u6709\u6599\u306b\u306a\u308b\u30b1\u30fc\u30b9\u3001\u8cbb\u7528\u3092\u6291\u3048\u308b\u30dd\u30a4\u30f3\u30c8\u3082\u7d39\u4ecb\" \/><\/a><\/div>\r\n\t\t\t<\/div><\/div>\n<h3>\u624b\u98061.Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3068BigQuery\u3068\u9023\u643a\u3055\u305b\u308b<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-17706\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/69d7b1fd14f563f3ac45636ba69afa19-1024x391.png\" alt=\"Looker Studio\" width=\"1024\" height=\"391\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u300c\u4f5c\u6210\u300d\u21db\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u300d\u306e\u9806\u306b\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11592\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/6e69e09dea5e9063e77e5edd73915919.png\" alt=\"25.Bigquery\u3092\u9078\u629e\" width=\"990\" height=\"471\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>\u3064\u304e\u306b\u3001\u300cBigQuery\u300d\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11593\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/6711fc0f4c1daaebb9dedd9468b67769.png\" alt=\"26.\u627f\u8a8d\u3092\u9078\u629e\" width=\"694\" height=\"343\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>\u300c\u627f\u8a8d\u300d\u3092\u62bc\u4e0b\u3059\u308b\u3068\u3001Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u306eBigQuery\u3078\u306e\u30a2\u30af\u30bb\u30b9\u304c\u8a31\u53ef\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11594\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/aa3ed369df5c448b146cac594003fca2-1024x453.png\" alt=\"27.Bigquery\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\" width=\"1024\" height=\"453\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>GA4\u3068\u9023\u643a\u6e08\u306eBigQuery\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u9078\u629e\u3057\u3066\u3001\u300c\u63a5\u7d9a\u300d\u3092\u62bc\u4e0b\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11595\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/2dc0dc993dff1321c8cfc9e2ad149399.png\" alt=\"28.Bigquery\u9805\u76ee\u4e00\u89a7\" width=\"846\" height=\"572\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>\u9023\u643a\u3057\u305fBigQuery\u306e\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306b\u542b\u307e\u308c\u308b\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u4e00\u89a7\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u4ee5\u4e0a\u3067\u3001Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3068BigQuery\u3092\u63a5\u7d9a\u3055\u305b\u308b\u305f\u3081\u306e\u624b\u9806\u306f\u5b8c\u4e86\u3067\u3059\u3002<\/p>\n<h3>\u624b\u98062.Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u4e0a\u3067BigQuery\u4e0a\u306eGA4\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3059\u308b<\/h3>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11596\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/58148c39db7446b14a0dc47afc7ee53a.png\" alt=\"29.\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\" width=\"796\" height=\"325\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u4e00\u89a7\u3092\u78ba\u8a8d\u3057\u305f\u3089\u3001\u753b\u9762\u306e\u53f3\u4e0a\u300c\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u300d\u3092\u62bc\u4e0b\u3057\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11597\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/cfe04da85671f03f0585879fc2e0d3b8.png\" alt=\"29.\u5186\u30b0\u30e9\u30d5\" width=\"844\" height=\"621\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>\u53ef\u8996\u5316\u306e\u624b\u6bb5\u3068\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u3001\u6307\u6a19\u3092\u9078\u3076\u3053\u3068\u3067\u3001\u7c21\u5358\u306b\u30c7\u30fc\u30bf\u3092\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30bc\u30fc\u30b7\u30e7\u30f3\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-large wp-image-11598\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/585d5fa77d7710d67474eb9fdb77467c-1024x264.png\" alt=\"30.\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\" width=\"1024\" height=\"264\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>\u30b0\u30e9\u30d5\u3084\u8868\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u81ea\u5206\u3067\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u304c\u3001Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3067\u306f\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3082\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-11599\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2021\/09\/fce484cd1e72737d8785afb77b25f19c.png\" alt=\"31.\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\" width=\"957\" height=\"724\" \/><\/p>\n<p style=\"text-align: center;\"><span style=\"font-weight: 400; font-size: 8pt;\">\u5f15\u7528\u5143\uff1a<a href=\"https:\/\/datastudio.google.com\/reporting\/0B_U5RNpwhcE6bzVYT2FSNmRBUWc\/page\/MM\/preview\" target=\"_blank\" rel=\"noopener noreferrer\">Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09<\/a><\/span><\/p>\n<p>\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u4e00\u89a7\u304b\u3089\u9069\u3057\u305f\u3082\u306e\u304c\u898b\u3064\u304b\u308c\u3070\u3001\u305c\u3072\u6d3b\u7528\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002\u5404\u7a2e\u30d3\u30b8\u30e5\u30a2\u30eb\u306e\u914d\u7f6e\u3084\u30ec\u30dd\u30fc\u30c8\u306e\u30c7\u30b6\u30a4\u30f3\u3092\u8003\u3048\u308b\u624b\u9593\u304c\u7701\u3051\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<h2>GA4\u3084BigQuery\u3068\u4f75\u305b\u3066\u5229\u7528\u3057\u305f\u3044\u5e83\u544a\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30c4\u30fc\u30eb\u300cDatabeat\u300d<\/h2>\n<p>GA4\u3084BigQuery\u3068\u4f75\u305b\u3066\u5229\u7528\u3057\u305f\u3044\u5e83\u544a\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30c4\u30fc\u30eb\u3068\u3057\u3066\u3001Databeat\u306b\u3064\u3044\u3066\u3054\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<h3>\u300cDatabeat\u300d\u3068\u306f\uff1f<\/h3>\n<p><span class=\"marker-thickYellow\"><strong>Databeat\u306f\u3001\u5e83\u544a\u904b\u7528\u62c5\u5f53\u8005\u306b\u5fc5\u8981\u306a\u30de\u30fc\u30b1\u30c6\u30a3\u30f3\u30b0\u30c7\u30fc\u30bf\u3092\u5e38\u306b\u6700\u65b0\u306e\u72b6\u614b\u3067\u53ef\u8996\u5316\u30fb\u5206\u6790\u3067\u304d\u308b\u696d\u52d9\u52b9\u7387\u5316\u30c4\u30fc\u30eb<\/strong>\u3067\u30012020\u5e742\u67084\u65e5\u3088\u308a\u63d0\u4f9b\u3092\u958b\u59cb\u3057\u3066\u3044\u307e\u3059\u3002<\/span><\/p>\n<p><a href=\"https:\/\/www.data-be.at\/?utm_source=media&amp;utm_medium=databeatmagazine&amp;utm_campaign=screenshot&amp;utm_content=top\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter size-large wp-image-19651\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2024\/11\/4b1f6b066f72daec0a0a60240f584b16-768x434.png\" alt=\"Databeat\" width=\"1024\" height=\"661\" \/><\/a><\/p>\n<h3>\u300cDatabeat\u300d\u3092\u5229\u7528\u3059\u308b3\u3064\u306e\u30e1\u30ea\u30c3\u30c8<\/h3>\n<p>\u5e83\u544a\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30c4\u30fc\u30eb\u300cDatabeat\u300d\u3092\u5229\u7528\u3059\u308b3\u3064\u306e\u30e1\u30ea\u30c3\u30c8\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n<div class=\"ep-box es-BsubTradi bgc-white es-borderSolidM es-radius brc-DPred\" title=\"Databeat\u306e\u30e1\u30ea\u30c3\u30c8\">\n<ol>\n<li>ETL\uff08\u53ce\u96c6\u30fb\u6574\u5f62\u30fb\u51fa\u529b\uff09\u6a5f\u80fd\u304c\u4fbf\u5229<\/li>\n<li>\u5bfe\u5fdc\u5a92\u4f53\u304c\u8c4a\u5bcc<\/li>\n<li>\u5e83\u544a\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3067\u304d\u308b\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u304c\u8c4a\u5bcc<\/li>\n<\/ol>\n<\/div>\n<h4 class=\"icon-checkbox-checked\">\u30001.ETL\uff08\u53ce\u96c6\u30fb\u6574\u5f62\u30fb\u51fa\u529b\uff09\u6a5f\u80fd\u304c\u4fbf\u5229<\/h4>\n<p>\u5e83\u544a\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306e\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u53ce\u96c6\u3057\u3001\u6574\u5f62\u3057\u305f\u72b6\u614b\u3067BigQuery\u306b\u683c\u7d0d\u3057\u307e\u3059\u3002\u683c\u7d0d\u3055\u308c\u305f\u30c7\u30fc\u30bf\u306f\u3001Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u306a\u3069\u306eBI\u30c4\u30fc\u30eb\u3084Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3001Excel\u306a\u3069\u5fc5\u8981\u306a\u5834\u6240\u306b\u51fa\u529b\u3057\u3066\u53ef\u8996\u5316\u3067\u304d\u307e\u3059\u3002<\/p>\n<h4 class=\"icon-checkbox-checked\">\u30002.\u5bfe\u5fdc\u5a92\u4f53\u304c\u8c4a\u5bcc<\/h4>\n<p>Databeat\u306f40\u4ee5\u4e0a\u306e\u5e83\u544a\u5a92\u4f53\u3068\u9023\u643a\u304c\u53ef\u80fd\u3002\u4e3b\u8981\u306a\u5e83\u544a\u5a92\u4f53\u304b\u3089\u30cb\u30c3\u30c1\u306a\u5e83\u544a\u5a92\u4f53\u307e\u3067\u30ab\u30d0\u30fc\u3057\u3066\u3044\u308b\u305f\u3081\u3001Databeat\u3072\u3068\u3064\u3067\u3042\u3089\u3086\u308b\u5e83\u544a\u5a92\u4f53\u306e\u30c7\u30fc\u30bf\u53ce\u96c6\u30fb\u84c4\u7a4d\u30fb\u51fa\u529b\u306b\u95a2\u3059\u308b\u5de5\u6570\u3092\u524a\u6e1b\u3067\u304d\u307e\u3059\u3002<\/p>\n<h4 class=\"icon-checkbox-checked\">\u30003.\u5e83\u544a\u30c7\u30fc\u30bf\u3092\u53ef\u8996\u5316\u3067\u304d\u308b\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u304c\u8c4a\u5bcc<\/h4>\n<p>Excel\u30fbLooker Studio\u306e\u30ec\u30dd\u30fc\u30c8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304c\u8c4a\u5bcc\u306b\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002Databeat\u3067\u53ce\u96c6\u3057\u305f\u30c7\u30fc\u30bf\u3092\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3078\u53cd\u6620\u3059\u308c\u3070\u3001\u793e\u5185\u30fb\u793e\u5916\u5411\u3051\u306e\u30ec\u30dd\u30fc\u30c8\u3068\u3057\u3066\u3059\u3050\u306b\u3054\u6d3b\u7528\u3044\u305f\u3060\u3051\u307e\u3059\u3002<\/p>\n<p>&nbsp;<\/p>\n<div class=\"btn btn-center\"><a class=\"btn__link btn__link-primary\" href=\"https:\/\/www.data-be.at\/?utm_source=media&amp;utm_medium=databeatmagazine&amp;utm_campaign=button&amp;utm_content=top\" target=\"_blank\" rel=\"noopener noreferrer\">Databeat\u30b5\u30fc\u30d3\u30b9\u30b5\u30a4\u30c8<\/a><\/div>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>\u4eca\u56de\u306f\u3001GA4\u3068BigQuery\u3092\u9023\u643a\u3055\u305b\u3066SQL\u3067\u5206\u6790\u3059\u308b\u65b9\u6cd5\u3001\u305d\u3057\u3066Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3068\u3064\u306a\u3044\u3067\u53ef\u8996\u5316\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u89e3\u8aac\u3057\u3066\u304d\u307e\u3057\u305f\u3002Web\u30b5\u30a4\u30c8\u3084\u30a2\u30d7\u30ea\u306b\u84c4\u7a4d\u3055\u308c\u305f\u751f\u30c7\u30fc\u30bf\u3092BigQuery\u306b\u9023\u643a\u3067\u304d\u308b\u6a5f\u80fd\u306f\u3001GA4\u306e\u5927\u304d\u306a\u7279\u5fb4\u3067\u3059\u3002<\/p>\n<p><span class=\"marker-thickYellow\"><strong>GA4\u3092BigQuery\u306b\u9023\u643a\u3055\u305b\u308b\u3053\u3068\u3067\u3001SQL\u3092\u6d3b\u7528\u3057\u3066\u81ea\u7531\u306a\u5207\u308a\u53e3\u3067\u5206\u6790\u3067\u304d\u307e\u3059\u3057\u3001Looker Studio\uff08\u65e7Google\u30c7\u30fc\u30bf\u30dd\u30fc\u30bf\u30eb\uff09\u3092\u306f\u3058\u3081\u3068\u3057\u305fBI\u30c4\u30fc\u30eb\u3082\u6d3b\u7528\u3059\u308c\u3070\u3001\u53ef\u8996\u5316\u3082\u601d\u3044\u901a\u308a<\/strong>\u306b\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n<p>\u305c\u3072\u4eca\u56de\u306e\u8a18\u4e8b\u3092\u3001GA4\u3092\u4f7f\u3063\u305fWeb\u30b5\u30a4\u30c8\u3084\u30a2\u30d7\u30ea\u306e\u5206\u6790\u696d\u52d9\u306b\u304a\u5f79\u7acb\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<div class=\"ep-box\">\n<p style=\"text-align: center;\"><strong><span style=\"font-size: 18pt;\">\u3010\u7121\u6599\u3011Databeat\u30b5\u30fc\u30d3\u30b9\u7d39\u4ecb\u8cc7\u6599<\/span><br \/>\n<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-19403\" src=\"https:\/\/www.data-be.at\/magazine\/wp-content\/uploads\/2024\/10\/51e6b566eeb421e2ae07a13dff2da975.png\" alt=\"\u3010\u7121\u6599\u3011Databeat\u30b5\u30fc\u30d2\u3099\u30b9\u7d39\u4ecb\u8cc7\u6599\u8acb\u6c42\" width=\"960\" height=\"540\" \/><br \/>\n\u5e83\u544a\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30c4\u30fc\u30eb\u300cDatabeat\u300d\u306e\u30b5\u30fc\u30d3\u30b9\u7d39\u4ecb\u8cc7\u6599\u3067\u3059\u3002<\/p>\n<p>\u30fbWeb\u5e83\u544a\u306e\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u5de5\u6570\u3092\u524a\u6e1b\u3057\u305f\u3044<br \/>\n\u30fbLooker Studio\u3068\u9023\u643a\u3067\u304d\u308b\u30ec\u30dd\u30fc\u30c8\u30c4\u30fc\u30eb\u3092\u63a2\u3057\u3066\u3044\u308b<br \/>\n\u30fb\u4f4e\u4fa1\u683c\u3067\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u3092\u81ea\u52d5\u5316\u3057\u305f\u3044<\/p>\n<p>\u4e0a\u8a18\u306e\u3088\u3046\u306a\u8ab2\u984c\u3092\u304a\u6301\u3061\u306e\u65b9\u306f\u3001\u4ee5\u4e0b\u306e\u30d5\u30a9\u30fc\u30e0\u306b\u5fc5\u8981\u306a\u9805\u76ee\u3092\u5165\u529b\u306e\u3046\u3048\u3001\u9001\u4fe1\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\nDatabeat\u306e\u8a73\u7d30\u306a\u8cc7\u6599\u3092\u3054\u89a7\u3044\u305f\u3060\u3051\u307e\u3059\u3002<br \/>\n<script src=\"\/\/js.hsforms.net\/forms\/embed\/v2.js\" type=\"text\/javascript\" charset=\"utf-8\"><\/script><br \/>\n<script>\n  hbspt.forms.create({\n    portalId: \"7766344\",\n    formId: \"da1859f6-4b4b-4501-95d6-29d38508f625\"\n  });\n<\/script><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>2020\u5e7410\u6708\u306b\u30ea\u30ea\u30fc\u30b9\u3055\u308c\u305fGoogle\u30a2\u30ca\u30ea\u30c6\u30a3\u30af\u30b9\u306e\u65b0\u3057\u3044\u898f\u683c\u3067\u3042\u308b\u3001GA4\uff08Google\u30a2 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":11738,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[27],"tags":[],"class_list":["post-11554","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ga4"],"_links":{"self":[{"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/posts\/11554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/comments?post=11554"}],"version-history":[{"count":24,"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/posts\/11554\/revisions"}],"predecessor-version":[{"id":20416,"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/posts\/11554\/revisions\/20416"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/media\/11738"}],"wp:attachment":[{"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/media?parent=11554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/categories?post=11554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.data-be.at\/magazine\/wp-json\/wp\/v2\/tags?post=11554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}