{"id":10311,"date":"2025-10-13T17:00:46","date_gmt":"2025-10-13T08:00:46","guid":{"rendered":"https:\/\/help.glu.jp\/ja\/?p=10311"},"modified":"2025-11-28T10:42:40","modified_gmt":"2025-11-28T01:42:40","slug":"bigquery-output","status":"publish","type":"post","link":"https:\/\/help.glu.jp\/ja\/reference\/bigquery\/bigquery-output\/","title":{"rendered":"Google Cloud BigQuery \u3078\u306e\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u51fa\u529b"},"content":{"rendered":"<p>Google Cloud BigQuery\uff08\u4ee5\u4e0b\u3001BigQuery\uff09\u3078\u30ec\u30dd\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u51fa\u529b\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u8a2d\u5b9a\u4e8b\u9805\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002<\/p>\n<h1>glu \u304b\u3089 BigQuery \u3078\u30ec\u30dd\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u51fa\u529b\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u3053\u3068<\/h1>\n<ol class=\" list1\">\n<li><a href=\"#gcp\">Google Cloud \u30b3\u30f3\u30bd\u30fc\u30eb\u4e0a\u306e\u6e96\u5099<\/a><\/li>\n<li><a href=\"#glu\">glu \u7ba1\u7406\u753b\u9762\u4e0a\u306e\u6e96\u5099<\/a><\/li>\n<li><a href=\"#bigquery\">BigQuery \u4e0a\u306e\u51fa\u529b\u72b6\u6cc1\u3092\u78ba\u8a8d<\/a><\/li>\n<\/ol>\n<table bgcolor=\"#f5f5f5\">\n<tbody>\n<tr>\n<td>\n<h4><a href=\"#appendix\">\uff3b\u53c2\u8003\u60c5\u5831\uff3d<\/a><\/h4>\n<ul class=\" list2\">\n<li><a href=\"#template\">\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u30a4\u30e1\u30fc\u30b8<\/a><\/li>\n<li><a href=\"#output\">BigQuery \u306e\u51fa\u529b\u30a4\u30e1\u30fc\u30b8<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"gcp\">1. Google Cloud \u30b3\u30f3\u30bd\u30fc\u30eb\u4e0a\u306e\u4e8b\u524d\u6e96\u5099<\/h2>\n<p>\u30fb\u30d7\u30ed\u30b8\u30a7\u30af\u30c8<br \/>\n\u8cb4\u793e Google Cloud \u30b3\u30f3\u30bd\u30fc\u30eb\u4e0a\u306b\u51fa\u529b\u5148\u3068\u306a\u308b\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u3054\u7528\u610f\u304f\u3060\u3055\u3044\u3002<br \/>\n\u8a73\u7d30\u306f <a href=\"https:\/\/help.glu.jp\/ja\/release_log\/glu-tool\/google-cloud-bigquery\/#preparation\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u3061\u3089<\/a> \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<br \/>\n\u203b \u8907\u6570\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3078\u51fa\u529b\u3059\u308b\u969b\u306f\u3001\u30a2\u30bf\u30e9 \u30b5\u30dd\u30fc\u30c8\u30c1\u30fc\u30e0\u3078\u304a\u77e5\u3089\u305b\u304f\u3060\u3055\u3044\u3002glu \u306e\u300c\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u6761\u4ef6\u300d\u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u6307\u5b9a\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>\u30fb\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8<br \/>\n\u8cb4\u793e Google Cloud \u30b3\u30f3\u30bd\u30fc\u30eb\u4e0a\u306b\u51fa\u529b\u5148\u3068\u3059\u308b\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u3054\u7528\u610f\u304f\u3060\u3055\u3044\u3002<br \/>\n\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306e\u6307\u5b9a\u306f\u3001\u30c0\u30a4\u30b9\u307e\u305f\u306f\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3067\u8abf\u6574\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u203b \u30c0\u30a4\u30b9\u306b\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u540d\u306e\u5165\u529b\u6b04\u3092\u8a2d\u3051\u308b\u3053\u3068\u3067\u540c\u4e00\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3067\u3082\u30c0\u30a4\u30b9\u3054\u3068\u306b\u51fa\u529b\u5148\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u6307\u5b9a\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>\u30fb\u30c6\u30fc\u30d6\u30eb<br \/>\nglu \u5074\u3067\u30c6\u30fc\u30d6\u30eb\u3092\u81ea\u52d5\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u30c6\u30fc\u30d6\u30eb\u306e\u6307\u5b9a\u306f\u3001\u30c0\u30a4\u30b9\u307e\u305f\u306f\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3067\u8abf\u6574\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u30c0\u30a4\u30b9\u306b\u30c6\u30fc\u30d6\u30eb\u540d\u306e\u5165\u529b\u6b04\u3092\u8a2d\u3051\u308b\u3053\u3068\u3067\u540c\u4e00\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3067\u3082\u30c0\u30a4\u30b9\u3054\u3068\u306b\u51fa\u529b\u5148\u30c6\u30fc\u30d6\u30eb\u3092\u6307\u5b9a\u53ef\u80fd\u3067\u3059\u3002<\/p>\n<p>\u30fb\u30d5\u30a3\u30fc\u30eb\u30c9<br \/>\n\u3054\u5e0c\u671b\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3067\u3054\u7528\u610f\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u7a2e\u985e\uff08\u30c7\u30fc\u30bf\u578b\uff09\u306f glu \u5074\u306b\u8fd1\u3057\u3044\u3082\u306e\u3067\u3054\u7528\u610f\u3044\u305f\u3057\u307e\u3059\u3002<br \/>\n\u203b \u3054\u5e0c\u671b\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3001\u7a2e\u985e\uff08\u30c7\u30fc\u30bf\u578b\uff09\u304c\u3042\u308c\u3070\u304a\u805e\u304b\u305b\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u4ee5\u4e0b\u306f\u3001\u30ad\u30e3\u30f3\u30da\u30fc\u30f3\u5225\u30ec\u30dd\u30fc\u30c8\u51fa\u529b\u6642\u306e\u4e00\u4f8b\u3067\u3059\u3002<\/p>\n<table>\n<tbody>\n<tr>\n<td class=\"style_td\" style=\"background-color: #e6e6e6;\" width=\"50\"><strong>\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\uff08field name\uff09<\/strong><\/td>\n<td class=\"style_td\" style=\"background-color: #e6e6e6;\" width=\"50\"><strong>\u7a2e\u985e\uff08type\uff09<\/strong><\/td>\n<td class=\"style_td\" style=\"background-color: #e6e6e6;\" width=\"100\"><strong>\u5099\u8003<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Date<\/td>\n<td>DATE<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Media<\/td>\n<td>STRING<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Account<\/td>\n<td>STRING<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>AccountID<\/td>\n<td>STRING<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Campaign<\/td>\n<td>STRING<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>CampaignID<\/td>\n<td>STRING<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>CampaignType<\/td>\n<td>STRING<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Impressions<\/td>\n<td>INTEGER<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Clicks<\/td>\n<td>INTEGER<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Cost<\/td>\n<td>NUMERIC<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>Conversions<\/td>\n<td>NUMERIC<\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"glu\">2. glu \u7ba1\u7406\u753b\u9762\u4e0a\u306e\u6e96\u5099<\/h2>\n<p>\u30fb\u8a8d\u8a3c\u30b3\u30fc\u30c9\u3092\u8a2d\u5b9a<br \/>\nglu \u7ba1\u7406\u753b\u9762\u3078\u30ed\u30b0\u30a4\u30f3\u3057\u3066 API \u3092\u5229\u7528\u3059\u308b\u305f\u3081\u306e\u8a8d\u8a3c\u30b3\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<br \/>\n\u8a73\u7d30\u306f <a href=\"https:\/\/help.glu.jp\/ja\/release_log\/glu-tool\/google-cloud-bigquery\/#procedure\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u3061\u3089<\/a> \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u30fb\u30a2\u30ab\u30a6\u30f3\u30c8\u63a5\u7d9a<br \/>\n\u30e1\u30c7\u30a3\u30a2\u30fb\u30c4\u30fc\u30eb\u3068\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306e\u60c5\u5831\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<br \/>\n\u8a73\u7d30\u306f <a href=\"https:\/\/help.glu.jp\/ja\/release_log\/glu-media\/glu_media\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u3061\u3089<\/a> \u304b\u3089\u5404\u30e1\u30c7\u30a3\u30a2\u306e\u300c\u8a73\u7d30\u300d\u30da\u30fc\u30b8\u3078\u5165\u308a\u300c\u30a2\u30ab\u30a6\u30f3\u30c8\u63a5\u7d9a\u300d\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u30fb\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u4f5c\u6210<br \/>\n\u521d\u56de\u9023\u643a\u6642\u306f 5 \u3064\u307e\u3067\u3054\u8981\u671b\u306e\u5185\u5bb9\u306b\u4f75\u305b\u305f\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092 \u30a2\u30bf\u30e9 \u30b5\u30dd\u30fc\u30c8\u30c1\u30fc\u30e0 \u304c\u4f5c\u6210\u3057\u307e\u3059\u3002<br \/>\n\u30ec\u30dd\u30fc\u30c8\u9805\u76ee\u3084\u51fa\u529b\u30a4\u30e1\u30fc\u30b8\u3092\u304a\u77e5\u3089\u305b\u304f\u3060\u3055\u3044\u3002\uff08\u4f8b\uff1a\u65e5\u4ed8\u3001\u30ad\u30e3\u30f3\u30da\u30fc\u30f3\u3001\u8868\u793a\u56de\u6570\u3001\u30af\u30ea\u30c3\u30af\u6570\u3001\u3054\u5229\u7528\u91d1\u984d\u3001\u30b3\u30f3\u30d0\u30fc\u30b8\u30e7\u30f3\uff09<\/p>\n<p>\u30fb\u30c0\u30a4\u30b9\u3092\u4f5c\u6210<br \/>\n\uff3b\u30ec\u30dd\u30fc\u30c8\u6848\u4ef6\uff3d\u30d5\u30a9\u30eb\u30c0\u306b\u30c0\u30a4\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<br \/>\n\u521d\u56de\u9023\u643a\u6642\u306f \u30a2\u30bf\u30e9 \u30b5\u30dd\u30fc\u30c8\u30c1\u30fc\u30e0 \u306b\u3066\u5bfe\u5fdc\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u30e6\u30fc\u30b6\u69d8\u5074\u3067\u4f5c\u6210\u3057\u305f\u3044\u5834\u5408\u306f <a href=\"https:\/\/help.glu.jp\/ja\/glulite\/lite_operation\/glu-lite-report\/#dice\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u3061\u3089<\/a> \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u30fb\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u30ea\u30f3\u30af<br \/>\n\u30c0\u30a4\u30b9\u3078\u30a2\u30ab\u30a6\u30f3\u30c8\u3092\u30ea\u30f3\u30af\u3057\u307e\u3059\u3002<br \/>\n\u521d\u56de\u9023\u643a\u6642\u306f \u30a2\u30bf\u30e9 \u30b5\u30dd\u30fc\u30c8\u30c1\u30fc\u30e0 \u306b\u3066\u5bfe\u5fdc\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u30e6\u30fc\u30b6\u69d8\u5074\u3067\u4f5c\u6210\u3057\u305f\u3044\u5834\u5408\u306f <a href=\"https:\/\/help.glu.jp\/ja\/glulite\/lite_operation\/glu-lite-report\/#link\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u3061\u3089<\/a> \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u30fb\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30ea\u30f3\u30af<br \/>\n\u30c0\u30a4\u30b9\u3078\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u30ea\u30f3\u30af\u3057\u307e\u3059\u3002<br \/>\n\u521d\u56de\u9023\u643a\u6642\u306f \u30a2\u30bf\u30e9 \u30b5\u30dd\u30fc\u30c8\u30c1\u30fc\u30e0 \u306b\u3066\u5bfe\u5fdc\u53ef\u80fd\u3067\u3059\u3002<br \/>\n\u30e6\u30fc\u30b6\u69d8\u5074\u3067\u30ea\u30f3\u30af\u3057\u305f\u3044\u5834\u5408\u306f <a href=\"https:\/\/help.glu.jp\/ja\/reference\/auto-report\/auto-rt\/#content_1_9\" target=\"_blank\" rel=\"noopener noreferrer\">\u3053\u3061\u3089<\/a> \u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<h2 id=\"bigquery\">BigQuery \u4e0a\u306e\u51fa\u529b\u72b6\u6cc1\u3092\u78ba\u8a8d<\/h2>\n<p>\u30c0\u30a4\u30b9\u306e\u30bf\u30b9\u30af\u304c\u6b63\u5e38\u7d42\u4e86\u3059\u308b\u3068 glu \u304b\u3089 BigQuery \u3078\u306e\u30ec\u30dd\u30fc\u30c8\u30c7\u30fc\u30bf\u51fa\u529b\u304c\u5b8c\u4e86\u3067\u3059\u3002<br \/>\nBigQuery \u4e0a\u306e\u51fa\u529b\u72b6\u6cc1\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u30c0\u30a4\u30b9\u306e\u30bf\u30b9\u30af\u306f\u4ee5\u4e0b\u3067\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<ol>\n<li>\uff3b\u30ec\u30dd\u30fc\u30c8\u6848\u4ef6\uff3d\u30d5\u30a9\u30eb\u30c0\u306e\uff3b\u30c0\u30a4\u30b9\uff3d\u3092\u9078\u629e<\/li>\n<li>\uff3b\u30bf\u30b9\u30af\uff3d\u30bf\u30d6\u3092\u9078\u629e<\/li>\n<li>\uff3b\u767b\u9332\u65e5\u6642\uff3d\u3092\u9078\u629e<\/li>\n<li>\uff3b\u518d\u8868\u793a\uff3d\u3092\u9078\u629e<\/li>\n<li>\uff3b\u72b6\u614b\uff3d\u304c\uff3b\u6b63\u5e38\u7d42\u4e86\uff3d\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d<\/li>\n<\/ol>\n<table bgcolor=\"#f5f5f5\">\n<tbody>\n<tr>\n<td><strong>\u30bf\u30b9\u30af \u3068\u306f<\/strong><br \/>\n\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u4f5c\u6210\u3001\u901a\u77e5\u306a\u3069 glu \u306e\u51fa\u529b\u64cd\u4f5c\u3067\u3059\u3002<br \/>\n\u30bf\u30b9\u30af\u306e\u72b6\u6cc1\u306b\u3064\u3044\u3066\u304a\u56f0\u308a\u306e\u969b\u306f \u30a2\u30bf\u30e9 \u30b5\u30dd\u30fc\u30c8\u30c1\u30fc\u30e0\u3078\u304a\u77e5\u3089\u305b\u304f\u3060\u3055\u3044\u3002<br \/>\n\u4f8b\uff09<br \/>\n&#8211; \uff3b\u72b6\u614b\uff3d\u304c\u300c\u30a8\u30e9\u30fc\u7d42\u4e86\u300d\u306b\u306a\u3063\u3066\u3044\u308b<br \/>\n&#8211; \uff3b\u72b6\u614b\uff3d\u306f\u300c\u6b63\u5e38\u7d42\u4e86\u300d\u3060\u304c BigQuery \u4e0a\u306e\u5185\u5bb9\u306b\u7570\u5e38\u304c\u3042\u308b<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"has-text-align-right\"><a href=\"#navigator\">\u2191<\/a><\/p>\n<h2 id=\"appendix\">\uff3b\u53c2\u8003\u60c5\u5831\uff3d<\/h2>\n<ul class=\" list1\">\n<li><a href=\"#template\">\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u30a4\u30e1\u30fc\u30b8<\/a><\/li>\n<li><a href=\"#dice\">glu \u7ba1\u7406\u753b\u9762\u4e0a\u306e\u30a4\u30e1\u30fc\u30b8\uff08\u6e96\u5099\u4e2d\uff09<\/a><\/li>\n<li><a href=\"#output\">BigQuery \u306e\u51fa\u529b\u30a4\u30e1\u30fc\u30b8<\/a><\/li>\n<\/ul>\n<h3 id=\"template\">\u30fb\u30ec\u30dd\u30fc\u30c8\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u306e\u30a4\u30e1\u30fc\u30b8<\/h3>\n<h4>CREATE \u6587<\/h4>\n<p>\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u3066\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u8a2d\u5b9a<\/p>\n<table bgcolor=\"#f5f5f5\">\n<tbody>\n<tr>\n<td>${IMC_BEGIN_TAG}<br \/>\n# CREATE<\/p>\n<p>GROUP=report_group_default<br \/>\nPERIOD_START=from,month,1,1<br \/>\nPERIOD_END=from,month,0,-1<\/p>\n<p>ASPECT=report_aspect_none<\/p>\n<p>SEGMENT=<br \/>\nSELECTOR=<br \/>\nFROM_LEVEL=campaigns<br \/>\nDAILY_LEVEL=any<br \/>\nSHOW_HEADER=report_show_header_none<br \/>\nSHOW_ALL_ASPECT_ROWS=false<br \/>\nSUM=report_sum_none<br \/>\nOUTPUT_FORMAT=sql<br \/>\nOUTPUT_CODE=utf8<br \/>\nFLAT=false<\/p>\n<p>TEXT_BODY=${<br \/>\nCREATE TABLE IF NOT EXISTS<br \/>\n`#{@node.bq_dataset_name}.campaigns_daily`<br \/>\n(<br \/>\nDate DATE,<br \/>\nMedia STRING,<br \/>\nAccount STRING,<br \/>\nAccountID STRING,<br \/>\nCampaign STRING,<br \/>\nCampaignID STRING,<br \/>\nCampaignType STRING,<br \/>\nImpressions INT64,<br \/>\nClicks INT64,<br \/>\nCost NUMERIC,<br \/>\nConversions NUMERIC,<br \/>\n)<br \/>\nPARTITION BY `Date`<br \/>\n;<br \/>\n}<br \/>\n${IMC_END_TAG}\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>DELETE \u6587<\/h4>\n<p>\u904e\u53bb 30 \u65e5\u5206\u306e\u30c7\u30fc\u30bf\u3092\u524a\u9664<\/p>\n<table bgcolor=\"#f5f5f5\">\n<tbody>\n<tr>\n<td>\n${IMC_BEGIN_TAG}<\/p>\n<p># DELETE<\/p>\n<p>GROUP=report_group_default<br \/>\nPERIOD_START=from,day,29,0<br \/>\nPERIOD_END=from,day,0,0<\/p>\n<p>ASPECT=report_aspect_daily<br \/>\nSERIES=report_series_none<br \/>\nSEGMENT=report_segment_none<br \/>\nSELECTOR=<br \/>\nFROM_LEVEL=campaigns<br \/>\nDAILY_LEVEL=any<br \/>\nANTE_FILTER=report_ante_filter_none<br \/>\nMEDI_FILTER=report_medi_filter_none<br \/>\nPOST_FILTER=report_post_filter_none<br \/>\nROUND_UP=report_round_up_none<br \/>\nSHOW_HEADER=report_show_header_none<br \/>\nSHOW_SEGMENT=report_show_segment_none_by_aspect<br \/>\nSHOW_SERIES=report_show_series_none<br \/>\nSHOW_ALL_ASPECT_ROWS=false<br \/>\nSHOW_SUM=report_show_sum_none<br \/>\nWRAP_ROWS=false<br \/>\nFLAT=false<\/p>\n<p>OUTPUT_FORMAT=sql<br \/>\nOUTPUT_CODE=utf8<br \/>\nCHUNK_ROWS=1000<\/p>\n<p>TEXT_HEAD=${<br \/>\nDELETE from `#{@node.bq_dataset_name}.campaigns_daily` where date in (<br \/>\n}<br \/>\nTEXT_BODY=${<br \/>\n PARSE_DATE(&#8216;%Y\/%m\/%d&#8217;, #{t @data[0]})<br \/>\n}<br \/>\nTEXT_BCAT=,<br \/>\nTEXT_FOOT=${<br \/>\n);<br \/>\n}<br \/>\n${IMC_END_TAG}\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>INSERT \u6587<\/h4>\n<p>\u904e\u53bb 30 \u65e5\u5206\u306e\u30c7\u30fc\u30bf\u3092\u633f\u5165<\/p>\n<table bgcolor=\"#f5f5f5\">\n<tbody>\n<tr>\n<td>\n${IMC_BEGIN_TAG}<\/p>\n<p># INSERT<\/p>\n<p>GROUP=report_group_default<br \/>\nPERIOD_START=from,day,29,0<br \/>\nPERIOD_END=from,day,0,0<\/p>\n<p>ASPECT=report_aspect_campaigns<br \/>\nSERIES=report_series_daily<\/p>\n<p>SEGMENT=report_segment_none<br \/>\nSELECTOR=<br \/>\nDAILY_LEVEL=any<br \/>\nFROM_LEVEL=campaigns<br \/>\nANTE_FILTER=report_ante_filter_none<br \/>\nMEDI_FILTER=report_medi_filter_none<br \/>\nPOST_FILTER=report_post_filter_custom:&#8221;(SUM(report_imps)>0 OR SUM(report_clicks)>0 OR SUM(report_cost)>0 OR SUM(report_conv_t)>0)&#8221;<br \/>\nROUND_UP=report_round_up_none<br \/>\nSHOW_SEGMENT=report_show_segment_none<br \/>\nSHOW_SERIES=report_show_series_none<br \/>\nSHOW_ALL_ASPECT_ROWS=false<br \/>\nSHOW_SUM=report_show_sum_none<br \/>\nSHOW_HEADER=report_show_header_none<br \/>\nWRAP_ROWS=false<\/p>\n<p>FLAT=true<\/p>\n<p>OUTPUT_FORMAT=sql<br \/>\nOUTPUT_CODE=utf8<br \/>\nCHUNK_ROWS=1000<\/p>\n<p>TEXT_HEAD=${<br \/>\nINSERT `#{@node.bq_dataset_name}.campaigns_daily` (Date,Media,Account,AccountID,Campaign,CampaignID,CampaignType,Impressions,Clicks,Cost,Conversions) VALUES<br \/>\n}<br \/>\nTEXT_BODY=${<br \/>\n(#{t @data[:bq_report_date]},#{t @data[:media_type]},#{t @data[:bq_ac_name]},#{t @data[:account_id]},#{t @data[:bq_cp_name]},#{t @data[:campaign_id]},#{t @data[:cp_type]},#{t @data[:report_imps]},#{t @data[:report_clicks]},#{t @data[:report_cost]},#{t @data[:report_conv_t]})<br \/>\n}<br \/>\nTEXT_BCAT=,<br \/>\nTEXT_FOOT=${<br \/>\n;<br \/>\n}<br \/>\n${IMC_END_TAG}<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p class=\"has-text-align-right\"><a href=\"#navigator\">\u2191<\/a><\/p>\n<h3 id=\"output\">\u30fbBigQuery \u306e\u51fa\u529b\u30a4\u30e1\u30fc\u30b8<\/h3>\n<p>\u4f8b\uff09<br \/>\n\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3054\u3068\u306b\u4f5c\u6210<\/p>\n<figure class=\"wp-block-image\"><a href=\"https:\/\/help.glu.jp\/ja\/wp-content\/uploads\/sites\/2\/2025\/11\/client_bigquery.png\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/help.glu.jp\/ja\/wp-content\/uploads\/sites\/2\/2025\/11\/client_bigquery.png\" alt=\"client\" class=\"borderline01\"><\/a><\/figure>\n<\/p>\n<p>\u4f8b\uff09<br \/>\n\u4e00\u3064\u306e\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3078\u5168\u3066\u306e\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u30c7\u30fc\u30bf\u3092\u5165\u308c\u308b<\/p>\n<figure class=\"wp-block-image\"><a href=\"https:\/\/help.glu.jp\/ja\/wp-content\/uploads\/sites\/2\/2025\/11\/allclient_bigquery.png\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/help.glu.jp\/ja\/wp-content\/uploads\/sites\/2\/2025\/11\/allclient_bigquery.png\" alt=\"allclient\" class=\"borderline01\"><\/a><\/figure>\n<\/p>\n<p class=\"has-text-align-right\"><a href=\"#navigator\">\u2191<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Cloud BigQuery\uff08\u4ee5\u4e0b\u3001BigQuery\uff09\u3078\u30ec\u30dd\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u81ea\u52d5\u51fa\u529b\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u8a2d\u5b9a\u4e8b\u9805\u3092\u8a18\u8f09\u3057\u307e\u3059\u3002 glu \u304b\u3089 BigQuery \u3078\u30ec\u30dd\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u51fa\u529b\u3059\u308b\u305f\u3081\u306b\u5fc5\u8981\u306a\u3053\u3068 Googl [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[226],"tags":[],"class_list":["post-10311","post","type-post","status-publish","format-standard","hentry","category-bigquery"],"_links":{"self":[{"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/posts\/10311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/comments?post=10311"}],"version-history":[{"count":33,"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/posts\/10311\/revisions"}],"predecessor-version":[{"id":10515,"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/posts\/10311\/revisions\/10515"}],"wp:attachment":[{"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/media?parent=10311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/categories?post=10311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.glu.jp\/ja\/wp-json\/wp\/v2\/tags?post=10311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}