{"id":8712,"date":"2025-10-09T01:48:04","date_gmt":"2025-10-09T01:48:04","guid":{"rendered":"https:\/\/pokecon.jp\/job\/?p=8712"},"modified":"2025-10-09T01:48:04","modified_gmt":"2025-10-09T01:48:04","slug":"google-ad-manager-rest-api-%e3%81%a8-bigquery-%e3%81%ae%e9%80%a3%e6%90%ba%e3%81%ab%e3%82%88%e3%82%8b%e3%83%ac%e3%83%9d%e3%83%bc%e3%83%88%e8%87%aa%e5%8b%95%e5%8c%96%e3%82%b7%e3%82%b9%e3%83%86%e3%83%a0","status":"publish","type":"post","link":"https:\/\/pokecon.jp\/job\/8712\/","title":{"rendered":"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9"},"content":{"rendered":"\n<\/p>\n<div>\n<p><span itemscope=\"\" itemtype=\"http:\/\/schema.org\/Photograph\"><img decoding=\"async\" src=\"https:\/\/cdn-ak.f.st-hatena.com\/images\/fotolife\/a\/aslmyhn\/20251007\/20251007155134.png\" width=\"960\" height=\"540\" loading=\"lazy\" title=\"\" class=\"hatena-fotolife\" itemprop=\"image\"\/><\/span><\/p>\n<h2 id=\"\u306f\u3058\u3081\u306b\">\u306f\u3058\u3081\u306b<\/h2>\n<p>\u3053\u3093\u306b\u3061\u306f\u3001\u30c8\u30e2\u30cb\u30c6\u3067\u958b\u767a\u3092\u62c5\u5f53\u3057\u3066\u3044\u308b\u5409\u7530\u3067\u3059\u3002<br \/>\n\u30c7\u30b8\u30bf\u30eb\u5e83\u544a\u306e\u904b\u7528\u306b\u304a\u3044\u3066\u3001\u5e83\u544a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u5206\u6790\u3068\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u306f\u91cd\u8981\u306a\u696d\u52d9\u306e\u4e00\u3064\u3067\u3059\u3002\u3057\u304b\u3057\u3001\u5f0a\u793e\u3067\u306f\u624b\u52d5\u3067\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u304a\u308a\u3001\u55b6\u696d\u6d3b\u52d5\u306b\u96c6\u4e2d\u3059\u308b\u6642\u9593\u3092\u524a\u3063\u3066\u3057\u307e\u3046\u8ab2\u984c\u304c\u3042\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u672c\u8a18\u4e8b\u3067\u306f\u3001Google Ad Manager\uff08GAM\uff09\u306e REST API \u3068 BigQuery \u3092\u9023\u643a\u3055\u305b\u3001\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u3092\u81ea\u52d5\u5316\u3059\u308b\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9\u4e8b\u4f8b\u306b\u3064\u3044\u3066\u3001\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<h2 id=\"\u80cc\u666f\u30bb\u30fc\u30eb\u30b9\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u306e\u8ab2\u984c\">\u80cc\u666f\uff1a\u30bb\u30fc\u30eb\u30b9\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u306e\u8ab2\u984c<\/h2>\n<h3 id=\"\u30d3\u30b8\u30cd\u30b9\u8ab2\u984c\">\u30d3\u30b8\u30cd\u30b9\u8ab2\u984c<\/h3>\n<p>\u30bb\u30fc\u30eb\u30b9\u30c1\u30fc\u30e0\u304c Google Ad Manager \u306e\u5e83\u544a\u30ec\u30dd\u30fc\u30c8\u3092\u624b\u52d5\u3067\u4f5c\u6210\u3059\u308b\u969b\u3001\u4ee5\u4e0b\u306e\u8ab2\u984c\u306b\u76f4\u9762\u3057\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<ul>\n<li><strong>\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u5de5\u6570\u306e\u5d69\u307f<\/strong>: \u73fe\u72b6 30 \u5206\u301c1 \u6642\u9593\u7a0b\u5ea6\u306e\u5de5\u6570\u304c\u767a\u751f<\/li>\n<li><strong>\u30c7\u30fc\u30bf\u62bd\u51fa\u306e\u8907\u96d1\u3055<\/strong>: GAM \u304b\u3089\u76f4\u63a5\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b\u624b\u9593<\/li>\n<li><strong>\u55b6\u696d\u6d3b\u52d5\u6642\u9593\u306e\u6e1b\u5c11<\/strong>: \u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u306b\u6642\u9593\u3092\u53d6\u3089\u308c\u3001\u55b6\u696d\u6d3b\u52d5\u306b\u96c6\u4e2d\u3067\u304d\u306a\u3044<\/li>\n<\/ul>\n<h3 id=\"\u671f\u5f85\u3055\u308c\u308b\u6210\u679c\">\u671f\u5f85\u3055\u308c\u308b\u6210\u679c<\/h3>\n<p>\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u306e\u81ea\u52d5\u5316\u306b\u3088\u308a\u3001\u4ee5\u4e0b\u306e\u6210\u679c\u3092\u671f\u5f85\u3057\u307e\u3057\u305f\u3002<\/p>\n<ul>\n<li><strong>\u5de5\u6570\u524a\u6e1b<\/strong>: \u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u6642\u9593\u306e\u77ed\u7e2e<\/li>\n<li><strong>\u55b6\u696d\u6d3b\u52d5\u306e\u5f37\u5316<\/strong>: \u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u6642\u9593\u3092\u55b6\u696d\u6d3b\u52d5\u306b\u5145\u3066\u3001\u58f2\u4e0a\u8ca2\u732e\u306e\u5411\u4e0a<\/li>\n<li><strong>\u30c7\u30fc\u30bf\u6d3b\u7528\u306e\u52b9\u7387\u5316<\/strong>: BigQuery \u3067\u306e SQL \u306b\u3088\u308b\u67d4\u8edf\u306a\u30c7\u30fc\u30bf\u62bd\u51fa<\/li>\n<\/ul>\n<h2 id=\"\u6280\u8853\u9078\u5b9aREST-API-\u306e\u63a1\u7528\">\u6280\u8853\u9078\u5b9a\uff1aREST API \u306e\u63a1\u7528<\/h2>\n<h3 id=\"\u65e2\u5b58\u30b7\u30b9\u30c6\u30e0\u306e\u8ab2\u984c\">\u65e2\u5b58\u30b7\u30b9\u30c6\u30e0\u306e\u8ab2\u984c<\/h3>\n<p>\u793e\u5185\u306e\u5225\u30b5\u30fc\u30d3\u30b9\u3067\u306f\u3001Google Ad Manager \u306e SOAP API \u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3057\u305f\u3002\u3057\u304b\u3057\u3001\u4ee5\u4e0b\u306e\u7406\u7531\u304b\u3089 REST API\uff08\u73fe\u5728 Beta \u7248\uff09\u3067\u5b9f\u88c5\u3059\u308b\u3053\u3068\u3092\u6c7a\u5b9a\u3057\u307e\u3057\u305f\u3002<\/p>\n<div class=\"s_table\"><table>\n<thead>\n<tr>\n<th> \u9805\u76ee               <\/th>\n<th> SOAP API                <\/th>\n<th> REST API                       <\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td> \u5b9f\u88c5\u306e\u8907\u96d1\u3055       <\/td>\n<td> XML \u30d9\u30fc\u30b9\u3067\u8907\u96d1        <\/td>\n<td> JSON \u30d9\u30fc\u30b9\u3067\u30b7\u30f3\u30d7\u30eb          <\/td>\n<\/tr>\n<tr>\n<td> \u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0 <\/td>\n<td> \u8907\u96d1\u306a XML \u30d1\u30fc\u30b9\u304c\u5fc5\u8981 <\/td>\n<td> \u6a19\u6e96\u7684\u306a HTTP \u30b9\u30c6\u30fc\u30bf\u30b9\u30b3\u30fc\u30c9 <\/td>\n<\/tr>\n<tr>\n<td> \u30c7\u30d0\u30c3\u30b0\u306e\u5bb9\u6613\u3055   <\/td>\n<td> XML \u30ed\u30b0\u306e\u53ef\u8aad\u6027\u304c\u4f4e\u3044  <\/td>\n<td> JSON \u30ed\u30b0\u3067\u76f4\u611f\u7684              <\/td>\n<\/tr>\n<tr>\n<td> \u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u6027     <\/td>\n<td> \u53e4\u3044\u6280\u8853\u30b9\u30bf\u30c3\u30af        <\/td>\n<td> \u30e2\u30c0\u30f3\u306a\u6280\u8853\u30b9\u30bf\u30c3\u30af           <\/td>\n<\/tr>\n<tr>\n<td> \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8       <\/td>\n<td> \u9650\u5b9a\u7684                  <\/td>\n<td> \u8c4a\u5bcc\u3067\u5206\u304b\u308a\u3084\u3059\u3044             <\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<h3 id=\"REST-API-\u306e\u9078\u629e\u7406\u7531\">REST API \u306e\u9078\u629e\u7406\u7531<\/h3>\n<ol>\n<li><strong>\u958b\u767a\u52b9\u7387\u306e\u5411\u4e0a<\/strong>: JSON \u30d9\u30fc\u30b9\u306e\u30b7\u30f3\u30d7\u30eb\u306a\u5b9f\u88c5<\/li>\n<li><strong>\u4fdd\u5b88\u6027\u306e\u5411\u4e0a<\/strong>: \u30e2\u30c0\u30f3\u306a\u6280\u8853\u30b9\u30bf\u30c3\u30af\u306b\u3088\u308b\u5c06\u6765\u6027<\/li>\n<li><strong>\u30a8\u30e9\u30fc\u51e6\u7406\u306e\u7c21\u7d20\u5316<\/strong>: \u6a19\u6e96\u7684\u306a HTTP \u30ec\u30b9\u30dd\u30f3\u30b9\u306e\u6d3b\u7528<\/li>\n<li><strong>\u30c1\u30fc\u30e0\u958b\u767a\u306e\u52b9\u7387\u5316<\/strong>: \u3088\u308a\u76f4\u611f\u7684\u306a API \u8a2d\u8a08<\/li>\n<\/ol>\n<p><strong>\u6ce8\u610f<\/strong>: Google Ad Manager REST API \u306f\u73fe\u5728 Beta \u7248\u306e\u305f\u3081\u3001\u672c\u756a\u74b0\u5883\u3067\u306e\u4f7f\u7528\u306b\u306f\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002API \u306e\u4ed5\u69d8\u5909\u66f4\u3084\u5236\u9650\u4e8b\u9805\u306b\u3064\u3044\u3066\u3001\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u5b9a\u671f\u7684\u306b\u78ba\u8a8d\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/p>\n<h2 id=\"\u30b7\u30b9\u30c6\u30e0\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3\">\u30b7\u30b9\u30c6\u30e0\u30a2\u30fc\u30ad\u30c6\u30af\u30c1\u30e3<\/h2>\n<h3 id=\"\u5168\u4f53\u69cb\u6210\">\u5168\u4f53\u69cb\u6210<\/h3>\n<ol>\n<li><strong>Cloud Run<\/strong>: \u30e1\u30a4\u30f3\u51e6\u7406\u30b3\u30f3\u30c6\u30ca\n<ul>\n<li>GAM REST API \u3092\u547c\u3073\u51fa\u3057\u3066\u30ec\u30dd\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u53d6\u5f97<\/li>\n<li>\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092 BigQuery \u306b\u683c\u7d0d<\/li>\n<\/ul>\n<\/li>\n<li><strong>GAM REST API<\/strong>: \u5e83\u544a\u30c7\u30fc\u30bf\u306e\u63d0\u4f9b<\/li>\n<li><strong>BigQuery<\/strong>: \u30c7\u30fc\u30bf\u306e\u4fdd\u5b58\u3068\u5206\u6790<\/li>\n<\/ol>\n<h3 id=\"\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc\">\u30c7\u30fc\u30bf\u30d5\u30ed\u30fc<\/h3>\n<ol>\n<li><strong>\u5b9f\u884c\u958b\u59cb<\/strong>: Cloud Run \u304c HTTP \u30ea\u30af\u30a8\u30b9\u30c8\u307e\u305f\u306f\u30a4\u30d9\u30f3\u30c8\u3067\u5b9f\u884c<\/li>\n<li><strong>\u65e5\u4ed8\u62bd\u51fa<\/strong>: \u30ea\u30af\u30a8\u30b9\u30c8\u304b\u3089\u5bfe\u8c61\u65e5\u4ed8\u3092\u53d6\u5f97<\/li>\n<li><strong>\u30ec\u30dd\u30fc\u30c8\u751f\u6210<\/strong>: GAM API \u3092\u4f7f\u7528\u3057\u3066\u30ec\u30dd\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u53d6\u5f97<\/li>\n<li><strong>BigQuery \u633f\u5165<\/strong>: \u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092 BigQuery \u306b\u4fdd\u5b58<\/li>\n<\/ol>\n<h2 id=\"GAM-REST-API-\u306e\u5b9f\u88c5\u8a73\u7d30\">GAM REST API \u306e\u5b9f\u88c5\u8a73\u7d30<\/h2>\n<h3 id=\"API-\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u521d\u671f\u5316\">API \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u521d\u671f\u5316<\/h3>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synPreProc\">from<\/span> google.ads <span class=\"synPreProc\">import<\/span> admanager_v1\n\n\nclient = admanager_v1.ReportServiceClient()\n<\/pre>\n<h3 id=\"\u30ec\u30dd\u30fc\u30c8\u5b9a\u7fa9\u306e\u4f5c\u6210\">\u30ec\u30dd\u30fc\u30c8\u5b9a\u7fa9\u306e\u4f5c\u6210<\/h3>\n<p>GAM REST API \u3067\u306f\u3001\u30ec\u30dd\u30fc\u30c8\u306e\u69cb\u9020\u3092\u8a73\u7d30\u306b\u5b9a\u7fa9\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">create_report_definition<\/span>(target_date: date, dimensions: <span class=\"synIdentifier\">list<\/span>, metrics: <span class=\"synIdentifier\">list<\/span>) -&gt; admanager_v1.Report:\n    <span class=\"synConstant\">\"\"\"GAM\u30ec\u30dd\u30fc\u30c8\u306e\u5b9a\u7fa9\u3092\u4f5c\u6210\"\"\"<\/span>\n    report = admanager_v1.Report()\n\n    \n    report.report_definition.dimensions = dimensions\n    report.report_definition.metrics = metrics\n    report.report_definition.report_type = admanager_v1.types.Report.ReportType.HISTORICAL\n\n    \n    report.report_definition.filters = [\n        admanager_v1.types.Report.Filter(\n            field_filter=admanager_v1.types.Report.Filter.FieldFilter(\n                field=admanager_v1.types.Report.Field(\n                    dimension=admanager_v1.types.Report.Dimension.AD_UNIT_NAME\n                ),\n                operation=admanager_v1.types.Report.Filter.Operation.MATCHES,\n                values=[\n                    admanager_v1.types.Report.Value(string_value=<span class=\"synConstant\">\"PREFIX_.*\"<\/span>)\n                ]\n            )\n        )\n    ]\n\n    \n    report.report_definition.date_range.fixed = admanager_v1.types.Report.DateRange.FixedDateRange(\n        start_date=date_pb2.Date(\n            year=target_date.year,\n            month=target_date.month,\n            day=target_date.day\n        ),\n        end_date=date_pb2.Date(\n            year=target_date.year,\n            month=target_date.month,\n            day=target_date.day\n        )\n    )\n\n    <span class=\"synStatement\">return<\/span> report\n<\/pre>\n<h3 id=\"\u30ec\u30dd\u30fc\u30c8\u306e\u5b9f\u884c\u3068\u30c7\u30fc\u30bf\u53d6\u5f97\">\u30ec\u30dd\u30fc\u30c8\u306e\u5b9f\u884c\u3068\u30c7\u30fc\u30bf\u53d6\u5f97<\/h3>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">create_and_run_report<\/span>(client: admanager_v1.ReportServiceClient, report: admanager_v1.Report) -&gt; <span class=\"synIdentifier\">str<\/span>:\n    <span class=\"synConstant\">\"\"\"GAM\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u5b9f\u884c\"\"\"<\/span>\n    \n    request = admanager_v1.CreateReportRequest(\n        parent=f<span class=\"synConstant\">\"networks\/{NETWORK_ID}\"<\/span>,\n        report=report,\n    )\n    create_response = client.create_report(request=request)\n    report_id = create_response.report_id\n\n    \n    run_request = admanager_v1.RunReportRequest(\n        name=f<span class=\"synConstant\">\"networks\/{NETWORK_ID}\/reports\/{report_id}\"<\/span>\n    )\n    operation = client.run_report(request=run_request)\n    run_result = operation.result()\n\n    <span class=\"synStatement\">return<\/span> run_result.report_result\n<\/pre>\n<h3 id=\"\u30c7\u30fc\u30bf\u306e\u62bd\u51fa\u3068\u5909\u63db\">\u30c7\u30fc\u30bf\u306e\u62bd\u51fa\u3068\u5909\u63db<\/h3>\n<p>GAM API \u304b\u3089\u53d6\u5f97\u3057\u305f\u30c7\u30fc\u30bf\u3092 Pandas DataFrame \u306b\u5909\u63db\u3059\u308b\u51e6\u7406\u3067\u3059\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">extract_dimension_value<\/span>(dim_value) -&gt; <span class=\"synIdentifier\">any<\/span>:\n    <span class=\"synConstant\">\"\"\"\u30c7\u30a3\u30e1\u30f3\u30b7\u30e7\u30f3\u5024\u3092\u62bd\u51fa\"\"\"<\/span>\n    <span class=\"synStatement\">if<\/span> dim_value.string_value:\n        <span class=\"synStatement\">return<\/span> dim_value.string_value\n    <span class=\"synStatement\">elif<\/span> dim_value.int_value:\n        <span class=\"synStatement\">return<\/span> dim_value.int_value\n    <span class=\"synStatement\">elif<\/span> dim_value.double_value:\n        <span class=\"synStatement\">return<\/span> dim_value.double_value\n    \n    <span class=\"synStatement\">else<\/span>:\n        <span class=\"synStatement\">return<\/span> <span class=\"synIdentifier\">None<\/span>\n\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">extract_metric_value<\/span>(primary_value) -&gt; <span class=\"synIdentifier\">any<\/span>:\n    <span class=\"synConstant\">\"\"\"\u30e1\u30c8\u30ea\u30af\u30b9\u5024\u3092\u62bd\u51fa\"\"\"<\/span>\n    <span class=\"synStatement\">if<\/span> primary_value.int_value:\n        <span class=\"synStatement\">return<\/span> <span class=\"synIdentifier\">int<\/span>(primary_value.int_value)\n    <span class=\"synStatement\">elif<\/span> primary_value.double_value:\n        <span class=\"synStatement\">return<\/span> primary_value.double_value\n    <span class=\"synStatement\">else<\/span>:\n        <span class=\"synStatement\">return<\/span> <span class=\"synIdentifier\">None<\/span>\n\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">fetch_report_data<\/span>(client: admanager_v1.ReportServiceClient, report_result_name: <span class=\"synIdentifier\">str<\/span>, column_names: <span class=\"synIdentifier\">list<\/span>[<span class=\"synIdentifier\">str<\/span>]) -&gt; pd.DataFrame:\n    <span class=\"synConstant\">\"\"\"\u30ec\u30dd\u30fc\u30c8\u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3057\u3066DataFrame\u306b\u5909\u63db\"\"\"<\/span>\n    fetch_request = admanager_v1.FetchReportResultRowsRequest(\n        name=report_result_name\n    )\n\n    rows_response = client.fetch_report_result_rows(request=fetch_request)\n\n    rows_list = []\n    <span class=\"synStatement\">for<\/span> row <span class=\"synStatement\">in<\/span> rows_response:\n        row_data = []\n\n        \n        <span class=\"synStatement\">for<\/span> dim_value <span class=\"synStatement\">in<\/span> row.dimension_values:\n            row_data.append(extract_dimension_value(dim_value))\n\n        \n        <span class=\"synStatement\">for<\/span> metric_group <span class=\"synStatement\">in<\/span> row.metric_value_groups:\n            <span class=\"synStatement\">for<\/span> primary_value <span class=\"synStatement\">in<\/span> metric_group.primary_values:\n                row_data.append(extract_metric_value(primary_value))\n\n        rows_list.append(row_data)\n\n    df = pd.DataFrame(rows_list, columns=column_names)\n    <span class=\"synStatement\">return<\/span> df\n<\/pre>\n<h2 id=\"BigQuery-\u3068\u306e\u9023\u643a\u8a2d\u8a08\">BigQuery \u3068\u306e\u9023\u643a\u8a2d\u8a08<\/h2>\n<h3 id=\"\u30b9\u30ad\u30fc\u30de\u8a2d\u8a08\u306e\u8003\u3048\u65b9\">\u30b9\u30ad\u30fc\u30de\u8a2d\u8a08\u306e\u8003\u3048\u65b9<\/h3>\n<p>BigQuery \u3078\u306e\u30c7\u30fc\u30bf\u4fdd\u5b58\u3067\u306f\u3001\u4ee5\u4e0b\u306e\u8a2d\u8a08\u601d\u60f3\u3092\u63a1\u7528\u3057\u307e\u3057\u305f\u3002<\/p>\n<ol>\n<li><strong>\u65e5\u4ed8\u5225\u30c6\u30fc\u30d6\u30eb\u5206\u5272<\/strong>: \u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3068\u30b3\u30b9\u30c8\u6700\u9069\u5316<\/li>\n<li><strong>\u578b\u5b89\u5168\u6027\u306e\u78ba\u4fdd<\/strong>: \u9069\u5207\u306a\u30c7\u30fc\u30bf\u578b\u306e\u8a2d\u5b9a<\/li>\n<li><strong>\u52b9\u7387\u7684\u306a\u30af\u30a8\u30ea<\/strong>: \u5206\u6790\u306b\u9069\u3057\u305f\u30b9\u30ad\u30fc\u30de\u8a2d\u8a08<\/li>\n<\/ol>\n<h3 id=\"\u30b9\u30ad\u30fc\u30de\u5b9a\u7fa9\">\u30b9\u30ad\u30fc\u30de\u5b9a\u7fa9<\/h3>\n<p>\u4ee5\u4e0b\u306e\u30b9\u30ad\u30fc\u30de\u5b9a\u7fa9\u306f\u4e00\u4f8b\u3067\u3059\u3002\u5b9f\u969b\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3067\u306f\u3001\u30d3\u30b8\u30cd\u30b9\u8981\u4ef6\u3084\u5206\u6790\u30cb\u30fc\u30ba\u306b\u5fdc\u3058\u3066\u9069\u5207\u306a\u30ab\u30e9\u30e0\u540d\u3068\u30c7\u30fc\u30bf\u578b\u3092\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\">\nDIMENSION_SCHEMA = [\n    bigquery.SchemaField(<span class=\"synConstant\">\"date\"<\/span>, <span class=\"synConstant\">\"INTEGER\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"advertiser_name\"<\/span>, <span class=\"synConstant\">\"STRING\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"advertiser_id\"<\/span>, <span class=\"synConstant\">\"INTEGER\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"order_name\"<\/span>, <span class=\"synConstant\">\"STRING\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"order_id\"<\/span>, <span class=\"synConstant\">\"INTEGER\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"line_item_type\"<\/span>, <span class=\"synConstant\">\"STRING\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"line_item_name\"<\/span>, <span class=\"synConstant\">\"STRING\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"line_item_id\"<\/span>, <span class=\"synConstant\">\"INTEGER\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"ad_unit\"<\/span>, <span class=\"synConstant\">\"STRING\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"ad_unit_id\"<\/span>, <span class=\"synConstant\">\"INTEGER\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"demand_channel_name\"<\/span>, <span class=\"synConstant\">\"STRING\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"creative_name\"<\/span>, <span class=\"synConstant\">\"STRING\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"creative_id\"<\/span>, <span class=\"synConstant\">\"INTEGER\"<\/span>),\n]\n\n\nMETRICS_SCHEMA = [\n    bigquery.SchemaField(<span class=\"synConstant\">\"total_impressions\"<\/span>, <span class=\"synConstant\">\"INTEGER\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"total_clicks\"<\/span>, <span class=\"synConstant\">\"INTEGER\"<\/span>),\n    bigquery.SchemaField(<span class=\"synConstant\">\"total_ctr\"<\/span>, <span class=\"synConstant\">\"FLOAT\"<\/span>),\n]\n<\/pre>\n<h3 id=\"BigQuery-\u3078\u306e\u30c7\u30fc\u30bf\u633f\u5165\">BigQuery \u3078\u306e\u30c7\u30fc\u30bf\u633f\u5165<\/h3>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">insert_df_to_bigquery<\/span>(df: pd.DataFrame, target_date: date, bigquery_schema: <span class=\"synIdentifier\">list<\/span>[bigquery.SchemaField], table_name: <span class=\"synIdentifier\">str<\/span>):\n    <span class=\"synConstant\">\"\"\"Pandas DataFrame\u3092BigQuery\u306b\u633f\u5165\"\"\"<\/span>\n    client = bigquery.Client()\n\n    job_config = bigquery.LoadJobConfig(\n        schema=bigquery_schema,\n        write_disposition=bigquery.WriteDisposition.WRITE_TRUNCATE,\n    )\n\n    date_str = target_date.strftime(<span class=\"synConstant\">'%Y%m%d'<\/span>)\n    table_id = f<span class=\"synConstant\">\"{PROJECT_ID}.{DATASET}.{table_name}_{date_str}\"<\/span>\n\n    job = client.load_table_from_dataframe(df, table_id, job_config=job_config)\n    job.result()\n<\/pre>\n<h2 id=\"Cloud-Run-\u306e\u5b9f\u88c5\">Cloud Run \u306e\u5b9f\u88c5<\/h2>\n<h3 id=\"\u30e1\u30a4\u30f3\u51e6\u7406\u306e\u5b9f\u88c5\">\u30e1\u30a4\u30f3\u51e6\u7406\u306e\u5b9f\u88c5<\/h3>\n<pre class=\"code lang-python\" data-lang=\"python\" data-unlink=\"\"><span class=\"synPreProc\">@<\/span><span class=\"synIdentifier\">cloud_event<\/span>\n<span class=\"synStatement\">def<\/span> <span class=\"synIdentifier\">main<\/span>(cloud_event: CloudEvent) -&gt; <span class=\"synIdentifier\">None<\/span>:\n    <span class=\"synConstant\">\"\"\"Cloud Run \u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u30dd\u30a4\u30f3\u30c8\"\"\"<\/span>\n    <span class=\"synStatement\">try<\/span>:\n        \n        target_date = extract_target_date(cloud_event)\n\n        \n        df = get_gam_report_data(dimensions, metrics, column_names, target_date)\n\n        \n        insert_df_to_bigquery(df, target_date, schema, table_name)\n\n        <span class=\"synIdentifier\">print<\/span>(<span class=\"synConstant\">\"\u30ec\u30dd\u30fc\u30c8\u51e6\u7406\u304c\u5b8c\u4e86\u3057\u307e\u3057\u305f\"<\/span>)\n\n    <span class=\"synStatement\">except<\/span> <span class=\"synType\">Exception<\/span> <span class=\"synStatement\">as<\/span> e:\n        <span class=\"synIdentifier\">print<\/span>(f<span class=\"synConstant\">\"\u51e6\u7406\u3067\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f: {e}\"<\/span>)\n        <span class=\"synStatement\">raise<\/span> e\n<\/pre>\n<h2 id=\"\u904b\u7528\u9762\u3067\u306e\u5de5\u592b\">\u904b\u7528\u9762\u3067\u306e\u5de5\u592b<\/h2>\n<h3 id=\"Cloud-Run-\u306e\u30c7\u30d7\u30ed\u30a4\u3068\u5b9f\u884c\">Cloud Run \u306e\u30c7\u30d7\u30ed\u30a4\u3068\u5b9f\u884c<\/h3>\n<p>Cloud Run \u306e\u30c7\u30d7\u30ed\u30a4\u306f <code>gcloud<\/code> \u30b3\u30de\u30f3\u30c9\u3067\u884c\u3044\u3001\u4ee5\u4e0b\u306e\u8a2d\u5b9a\u3067\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002<\/p>\n<ul>\n<li><strong>Region<\/strong>: asia-northeast1<\/li>\n<li><strong>Runtime<\/strong>: Python 3.13<\/li>\n<li><strong>Memory<\/strong>: 512MB<\/li>\n<li><strong>Trigger<\/strong>: HTTP<\/li>\n<\/ul>\n<h3 id=\"\u624b\u52d5\u5b9f\u884c\u306e\u305f\u3081\u306e\u30b3\u30de\u30f3\u30c9\">\u624b\u52d5\u5b9f\u884c\u306e\u305f\u3081\u306e\u30b3\u30de\u30f3\u30c9<\/h3>\n<p>\u904b\u7528\u52b9\u7387\u3092\u5411\u4e0a\u3055\u305b\u308b\u305f\u3081\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u624b\u52d5\u5b9f\u884c\u7528\u306e\u30b3\u30de\u30f3\u30c9\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n<ul>\n<li><strong>\u5358\u72ec\u65e5\u4ed8\u6307\u5b9a<\/strong>: \u7279\u5b9a\u306e\u65e5\u4ed8\u306e\u30ec\u30dd\u30fc\u30c8\u3092\u751f\u6210<\/li>\n<li><strong>\u7bc4\u56f2\u6307\u5b9a<\/strong>: \u958b\u59cb\u65e5\u304b\u3089\u7d42\u4e86\u65e5\u307e\u3067\u306e\u671f\u9593\u3067\u30ec\u30dd\u30fc\u30c8\u3092\u4e00\u62ec\u751f\u6210<\/li>\n<\/ul>\n<p>\u3053\u308c\u3089\u306e\u30b3\u30de\u30f3\u30c9\u306b\u3088\u308a\u3001\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u5b9f\u884c\u4ee5\u5916\u306b\u3082\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u67d4\u8edf\u306b\u30ec\u30dd\u30fc\u30c8\u3092\u751f\u6210\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u3002<\/p>\n<h3 id=\"\u30b7\u30b9\u30c6\u30e0\u306e\u5b9f\u884c\u65b9\u5f0f\">\u30b7\u30b9\u30c6\u30e0\u306e\u5b9f\u884c\u65b9\u5f0f<\/h3>\n<p>\u30b7\u30b9\u30c6\u30e0\u306f Cloud Run \u3068\u3057\u3066\u5b9f\u88c5\u3055\u308c\u3066\u304a\u308a\u3001\u69d8\u3005\u306a\u5b9f\u884c\u30d1\u30bf\u30fc\u30f3\u306b\u5bfe\u5fdc\u3067\u304d\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u65b9\u6cd5\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<ul>\n<li><strong>\u624b\u52d5\u5b9f\u884c<\/strong>: HTTP \u30c8\u30ea\u30ac\u30fc\u306b\u3088\u308b\u76f4\u63a5\u5b9f\u884c<\/li>\n<li><strong>\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u5b9f\u884c<\/strong>: Cloud Scheduler \u306b\u3088\u308b\u5b9a\u671f\u5b9f\u884c<\/li>\n<li><strong>\u30a4\u30d9\u30f3\u30c8\u99c6\u52d5<\/strong>: Pub\/Sub \u3084 Eventarc \u3092\u7d4c\u7531\u3057\u305f\u5b9f\u884c<\/li>\n<\/ul>\n<p>\u30d6\u30ed\u30b0\u5185\u3067\u8a00\u53ca\u306f\u3057\u3066\u3044\u307e\u305b\u3093\u304c\u3001\u5f0a\u793e\u3067\u306f Cloud Scheduler \u304b\u3089 Pub\/Sub \u30c8\u30d4\u30c3\u30af\u3092\u8d77\u52d5\u3057\u3001\u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f3\u3092\u901a\u3058\u3066 Cloud Run \u3092\u5b9a\u671f\u5b9f\u884c\u3059\u308b\u4ed5\u7d44\u307f\u3092\u69cb\u7bc9\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u4ed5\u7d44\u307f\u306b\u3088\u308a\u3001\u6bce\u65e5\u6c7a\u307e\u3063\u305f\u6642\u9593\u306b\u30ec\u30dd\u30fc\u30c8\u30c7\u30fc\u30bf\u304c\u81ea\u52d5\u7684\u306b\u66f4\u65b0\u3055\u308c\u3001\u624b\u52d5\u4f5c\u696d\u3092\u5927\u5e45\u306b\u524a\u6e1b\u3067\u304d\u3066\u3044\u307e\u3059\u3002<\/p>\n<h2 id=\"\u5b9f\u88c5\u3067\u5f97\u3089\u308c\u305f\u77e5\u898b\">\u5b9f\u88c5\u3067\u5f97\u3089\u308c\u305f\u77e5\u898b<\/h2>\n<h3 id=\"1-GAM-REST-API-\u306e\u7279\u5fb4\">1. GAM REST API \u306e\u7279\u5fb4<\/h3>\n<p><strong>\u30e1\u30ea\u30c3\u30c8<\/strong>:<\/p>\n<ul>\n<li>JSON \u30d9\u30fc\u30b9\u3067\u76f4\u611f\u7684\u306a\u5b9f\u88c5<\/li>\n<li>\u8c4a\u5bcc\u306a\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3068\u30b5\u30f3\u30d7\u30eb\u30b3\u30fc\u30c9<\/li>\n<li>\u6a19\u6e96\u7684\u306a HTTP \u30a8\u30e9\u30fc\u30cf\u30f3\u30c9\u30ea\u30f3\u30b0<\/li>\n<\/ul>\n<p><strong>\u6ce8\u610f\u70b9<\/strong>:<\/p>\n<ul>\n<li>\u30ec\u30dd\u30fc\u30c8\u5b9f\u884c\u306f\u975e\u540c\u671f\u51e6\u7406\u306e\u305f\u3081\u3001\u5b8c\u4e86\u5f85\u3061\u304c\u5fc5\u8981<\/li>\n<li>\u5927\u91cf\u30c7\u30fc\u30bf\u306e\u5834\u5408\u306f\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3\u304c\u5fc5\u8981<\/li>\n<li>\u30ec\u30fc\u30c8\u5236\u9650\u306b\u6ce8\u610f\u304c\u5fc5\u8981<\/li>\n<\/ul>\n<h3 id=\"2-BigQuery-\u3068\u306e\u9023\u643a\">2. BigQuery \u3068\u306e\u9023\u643a<\/h3>\n<p><strong>\u6700\u9069\u5316\u306e\u30dd\u30a4\u30f3\u30c8<\/strong>:<\/p>\n<ul>\n<li>\u65e5\u4ed8\u5225\u30c6\u30fc\u30d6\u30eb\u5206\u5272\u306b\u3088\u308b\u30af\u30a8\u30ea\u6027\u80fd\u5411\u4e0a<\/li>\n<li>\u9069\u5207\u306a\u30b9\u30ad\u30fc\u30de\u8a2d\u8a08\u306b\u3088\u308b\u30b9\u30c8\u30ec\u30fc\u30b8\u30b3\u30b9\u30c8\u524a\u6e1b<\/li>\n<li>WRITE_TRUNCATE \u30e2\u30fc\u30c9\u306b\u3088\u308b\u51aa\u7b49\u6027\u306e\u78ba\u4fdd<\/li>\n<\/ul>\n<h2 id=\"\u6210\u679c\u3068\u4eca\u5f8c\u306e\u5c55\u671b\">\u6210\u679c\u3068\u4eca\u5f8c\u306e\u5c55\u671b<\/h2>\n<h3 id=\"\u671f\u5f85\u3055\u308c\u308b\u6210\u679c-1\">\u671f\u5f85\u3055\u308c\u308b\u6210\u679c<\/h3>\n<ol>\n<li><strong>\u5de5\u6570\u524a\u6e1b<\/strong>: \u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u6642\u9593\u306e\u77ed\u7e2e\uff08\u73fe\u72b6 30 \u5206\u301c1 \u6642\u9593\uff09<\/li>\n<li><strong>\u55b6\u696d\u6d3b\u52d5\u306e\u5f37\u5316<\/strong>: \u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u6642\u9593\u3092\u55b6\u696d\u6d3b\u52d5\u306b\u5145\u3066\u3001\u58f2\u4e0a\u8ca2\u732e\u306e\u5411\u4e0a<\/li>\n<li><strong>\u30c7\u30fc\u30bf\u6d3b\u7528\u306e\u52b9\u7387\u5316<\/strong>: BigQuery \u3067\u306e SQL \u306b\u3088\u308b\u67d4\u8edf\u306a\u30c7\u30fc\u30bf\u62bd\u51fa<\/li>\n<\/ol>\n<h2 id=\"\u307e\u3068\u3081\">\u307e\u3068\u3081<\/h2>\n<p>Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308a\u3001\u30bb\u30fc\u30eb\u30b9\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u306e\u81ea\u52d5\u5316\u3092\u5b9f\u73fe\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u3053\u306e\u30b7\u30b9\u30c6\u30e0\u306b\u3088\u308a\u3001\u30bb\u30fc\u30eb\u30b9\u30c1\u30fc\u30e0\u304c\u55b6\u696d\u6d3b\u52d5\u306b\u3088\u308a\u591a\u304f\u306e\u6642\u9593\u3092\u5272\u3051\u308b\u3088\u3046\u306b\u306a\u308a\u3001\u7d50\u679c\u3068\u3057\u3066\u58f2\u4e0a\u306e\u5411\u4e0a\u306b\u8ca2\u732e\u3059\u308b\u3053\u3068\u304c\u671f\u5f85\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u540c\u69d8\u306e\u8ab2\u984c\u3092\u62b1\u3048\u3066\u3044\u308b\u7d44\u7e54\u306e\u53c2\u8003\u306b\u306a\u308c\u3070\u5e78\u3044\u3067\u3059\u3002<\/p>\n<h2 id=\"\u53c2\u8003\">\u53c2\u8003<\/h2>\n<p><iframe src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Fdevelopers.google.com%2Fad-manager%2Fapi%2Fbeta%2Fgetting-started%3Fhl%3Dja%26_gl%3D1*15kqz9m*_up*MQ..*_ga*Mjk1NzU0NDA3LjE3NTk4MjYwNzA.*_ga_SM8HXJ53K2*czE3NTk4MjYwNjkkbzEkZzAkdDE3NTk4MjYwNjkkajYwJGwwJGgw\" title=\"\u30b9\u30bf\u30fc\u30c8\u30ac\u30a4\u30c9 \u00a0|\u00a0 Ad Manager API (Beta) \u00a0|\u00a0 Google for Developers\" class=\"embed-card embed-webcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 155px; max-width: 500px; margin: 10px 0px;\" loading=\"lazy\"><\/iframe><cite class=\"hatena-citation\"><a target=\"_blank\" href=\"https:\/\/developers.google.com\/ad-manager\/api\/beta\/getting-started?hl=ja&amp;_gl=1*15kqz9m*_up*MQ..*_ga*Mjk1NzU0NDA3LjE3NTk4MjYwNzA.*_ga_SM8HXJ53K2*czE3NTk4MjYwNjkkbzEkZzAkdDE3NTk4MjYwNjkkajYwJGwwJGgw\">developers.google.com<\/a><\/cite><\/p>\n<p><iframe src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Fgoogleapis.dev%2Fpython%2Fgoogle-ads-admanager%2Flatest%2Fadmanager_v1%2Ftypes_.html\" title=\"Types for Google Ads Admanager v1 API \u2014 google-ads-admanager documentation\" class=\"embed-card embed-webcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 155px; max-width: 500px; margin: 10px 0px;\" loading=\"lazy\"><\/iframe><cite class=\"hatena-citation\"><a target=\"_blank\" href=\"https:\/\/googleapis.dev\/python\/google-ads-admanager\/latest\/admanager_v1\/types_.html\">googleapis.dev<\/a><\/cite><\/p>\n<p><iframe src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Fgoogleapis.dev%2Fpython%2Fgoogle-ads-admanager%2Flatest%2Fadmanager_v1%2Freport_service.html\" title=\"ReportService \u2014 google-ads-admanager documentation\" class=\"embed-card embed-webcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 155px; max-width: 500px; margin: 10px 0px;\" loading=\"lazy\"><\/iframe><cite class=\"hatena-citation\"><a target=\"_blank\" href=\"https:\/\/googleapis.dev\/python\/google-ads-admanager\/latest\/admanager_v1\/report_service.html\">googleapis.dev<\/a><\/cite><\/p>\n<p><iframe src=\"https:\/\/hatenablog-parts.com\/embed?url=https%3A%2F%2Fcloud.google.com%2Fbigquery%2Fdocs%2Fsamples%2Fbigquery-load-table-dataframe%3Fhl%3Dja\" title=\"DataFrame \u304b\u3089\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3080 \u00a0|\u00a0 BigQuery \u00a0|\u00a0 Google Cloud\" class=\"embed-card embed-webcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 155px; max-width: 500px; margin: 10px 0px;\" loading=\"lazy\"><\/iframe><cite class=\"hatena-citation\"><a target=\"_blank\" href=\"https:\/\/cloud.google.com\/bigquery\/docs\/samples\/bigquery-load-table-dataframe?hl=ja\">cloud.google.com<\/a><\/cite><\/p>\n<\/div>\n<p><script>(function(d, s, id) {\n  var js, fjs = d.getElementsByTagName(s)[0];\n  if (d.getElementById(id)) return;\n  js = d.createElement(s); js.id = id;\n  js.src = \"\/\/connect.facebook.net\/ja_JP\/sdk.js#xfbml=1&appId=719729204785177&version=v17.0\";\n  fjs.parentNode.insertBefore(js, fjs);\n}(document, 'script', 'facebook-jssdk'));<\/script><br \/>\n<br \/>\n<br \/><a href=\"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515\">\u5143\u306e\u8a18\u4e8b\u3092\u78ba\u8a8d\u3059\u308b <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"\u306f\u3058\u3081\u306b \u3053\u3093\u306b\u3061\u306f\u3001\u30c8\u30e2\u30cb\u30c6\u3067\u958b\u767a\u3092\u62c5\u5f53\u3057\u3066\u3044\u308b\u5409\u7530\u3067\u3059\u3002 \u30c7\u30b8\u30bf\u30eb\u5e83\u544a\u306e\u904b\u7528\u306b\u304a\u3044\u3066\u3001\u5e83\u544a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u5206\u6790\u3068\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u306f\u91cd\u8981\u306a\u696d\u52d9\u306e\u4e00\u3064\u3067\u3059\u3002\u3057\u304b\u3057\u3001\u5f0a\u793e\u3067\u306f\u624b\u52d5\u3067\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u304a\u308a\u3001\u55b6\u696d\u6d3b\u52d5\u306b\u96c6\u4e2d\u3059\u308b\u6642\u9593 [&hellip;]","protected":false},"author":1,"featured_media":8713,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-8712","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-company-tec"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9 - \u30dd\u30b1\u30b3\u30f3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9 - \u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"og:description\" content=\"\u306f\u3058\u3081\u306b \u3053\u3093\u306b\u3061\u306f\u3001\u30c8\u30e2\u30cb\u30c6\u3067\u958b\u767a\u3092\u62c5\u5f53\u3057\u3066\u3044\u308b\u5409\u7530\u3067\u3059\u3002 \u30c7\u30b8\u30bf\u30eb\u5e83\u544a\u306e\u904b\u7528\u306b\u304a\u3044\u3066\u3001\u5e83\u544a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u5206\u6790\u3068\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u306f\u91cd\u8981\u306a\u696d\u52d9\u306e\u4e00\u3064\u3067\u3059\u3002\u3057\u304b\u3057\u3001\u5f0a\u793e\u3067\u306f\u624b\u52d5\u3067\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u304a\u308a\u3001\u55b6\u696d\u6d3b\u52d5\u306b\u96c6\u4e2d\u3059\u308b\u6642\u9593 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515\" \/>\n<meta property=\"og:site_name\" content=\"\u30dd\u30b1\u30b3\u30f3\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-09T01:48:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1300\" \/>\n\t<meta property=\"og:image:height\" content=\"731\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"info@pokecon.jp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"info@pokecon.jp\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/tech.every.tv\\\/entry\\\/2025\\\/10\\\/09\\\/101515#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/8712\\\/\"},\"author\":{\"name\":\"info@pokecon.jp\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"headline\":\"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9\",\"datePublished\":\"2025-10-09T01:48:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/8712\\\/\"},\"wordCount\":138,\"image\":{\"@id\":\"https:\\\/\\\/tech.every.tv\\\/entry\\\/2025\\\/10\\\/09\\\/101515#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png\",\"articleSection\":[\"\u4f01\u696d\u30c6\u30c3\u30af\"],\"inLanguage\":\"ja\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/8712\\\/\",\"url\":\"https:\\\/\\\/tech.every.tv\\\/entry\\\/2025\\\/10\\\/09\\\/101515\",\"name\":\"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9 - \u30dd\u30b1\u30b3\u30f3\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/tech.every.tv\\\/entry\\\/2025\\\/10\\\/09\\\/101515#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/tech.every.tv\\\/entry\\\/2025\\\/10\\\/09\\\/101515#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png\",\"datePublished\":\"2025-10-09T01:48:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/tech.every.tv\\\/entry\\\/2025\\\/10\\\/09\\\/101515#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/tech.every.tv\\\/entry\\\/2025\\\/10\\\/09\\\/101515\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/tech.every.tv\\\/entry\\\/2025\\\/10\\\/09\\\/101515#primaryimage\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png\",\"contentUrl\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png\",\"width\":1300,\"height\":731},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/tech.every.tv\\\/entry\\\/2025\\\/10\\\/09\\\/101515#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#website\",\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/\",\"name\":\"\u30dd\u30b1\u30b3\u30f3\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/#\\\/schema\\\/person\\\/16c9f07b1ba984d165d9aee259bda997\",\"name\":\"info@pokecon.jp\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g\",\"caption\":\"info@pokecon.jp\"},\"url\":\"https:\\\/\\\/pokecon.jp\\\/job\\\/author\\\/infopokecon-jp\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9 - \u30dd\u30b1\u30b3\u30f3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515","og_locale":"ja_JP","og_type":"article","og_title":"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9 - \u30dd\u30b1\u30b3\u30f3","og_description":"\u306f\u3058\u3081\u306b \u3053\u3093\u306b\u3061\u306f\u3001\u30c8\u30e2\u30cb\u30c6\u3067\u958b\u767a\u3092\u62c5\u5f53\u3057\u3066\u3044\u308b\u5409\u7530\u3067\u3059\u3002 \u30c7\u30b8\u30bf\u30eb\u5e83\u544a\u306e\u904b\u7528\u306b\u304a\u3044\u3066\u3001\u5e83\u544a\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u306e\u5206\u6790\u3068\u30ec\u30dd\u30fc\u30c8\u4f5c\u6210\u306f\u91cd\u8981\u306a\u696d\u52d9\u306e\u4e00\u3064\u3067\u3059\u3002\u3057\u304b\u3057\u3001\u5f0a\u793e\u3067\u306f\u624b\u52d5\u3067\u30ec\u30dd\u30fc\u30c8\u3092\u4f5c\u6210\u3057\u3066\u304a\u308a\u3001\u55b6\u696d\u6d3b\u52d5\u306b\u96c6\u4e2d\u3059\u308b\u6642\u9593 [&hellip;]","og_url":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515","og_site_name":"\u30dd\u30b1\u30b3\u30f3","article_published_time":"2025-10-09T01:48:04+00:00","og_image":[{"width":1300,"height":731,"url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png","type":"image\/png"}],"author":"info@pokecon.jp","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"info@pokecon.jp","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"4\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515#article","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/8712\/"},"author":{"name":"info@pokecon.jp","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"headline":"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9","datePublished":"2025-10-09T01:48:04+00:00","mainEntityOfPage":{"@id":"https:\/\/pokecon.jp\/job\/8712\/"},"wordCount":138,"image":{"@id":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png","articleSection":["\u4f01\u696d\u30c6\u30c3\u30af"],"inLanguage":"ja"},{"@type":"WebPage","@id":"https:\/\/pokecon.jp\/job\/8712\/","url":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515","name":"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9 - \u30dd\u30b1\u30b3\u30f3","isPartOf":{"@id":"https:\/\/pokecon.jp\/job\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515#primaryimage"},"image":{"@id":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515#primaryimage"},"thumbnailUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png","datePublished":"2025-10-09T01:48:04+00:00","author":{"@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997"},"breadcrumb":{"@id":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515#primaryimage","url":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png","contentUrl":"https:\/\/pokecon.jp\/job\/wp-content\/uploads\/2025\/10\/https3A2F2Fcdn-ak.f.st-hatena.com2Fimages2Ffotolife2Fa2Faslmyhn2F202510072F20251007155134.p.png","width":1300,"height":731},{"@type":"BreadcrumbList","@id":"https:\/\/tech.every.tv\/entry\/2025\/10\/09\/101515#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/pokecon.jp\/job\/"},{"@type":"ListItem","position":2,"name":"Google Ad Manager REST API \u3068 BigQuery \u306e\u9023\u643a\u306b\u3088\u308b\u30ec\u30dd\u30fc\u30c8\u81ea\u52d5\u5316\u30b7\u30b9\u30c6\u30e0\u306e\u69cb\u7bc9"}]},{"@type":"WebSite","@id":"https:\/\/pokecon.jp\/job\/#website","url":"https:\/\/pokecon.jp\/job\/","name":"\u30dd\u30b1\u30b3\u30f3","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pokecon.jp\/job\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/pokecon.jp\/job\/#\/schema\/person\/16c9f07b1ba984d165d9aee259bda997","name":"info@pokecon.jp","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b0549cd9f7907c092ca5fbb283baf72337f235726e4b46fa39ec0b701ac2fe2?s=96&d=wavatar&r=g","caption":"info@pokecon.jp"},"url":"https:\/\/pokecon.jp\/job\/author\/infopokecon-jp\/"}]}},"_links":{"self":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/8712","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/comments?post=8712"}],"version-history":[{"count":1,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/8712\/revisions"}],"predecessor-version":[{"id":8714,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/posts\/8712\/revisions\/8714"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media\/8713"}],"wp:attachment":[{"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/media?parent=8712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/categories?post=8712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pokecon.jp\/job\/wp-json\/wp\/v2\/tags?post=8712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}