{"id":1512,"date":"2025-04-27T03:46:05","date_gmt":"2025-04-26T19:46:05","guid":{"rendered":"https:\/\/www.buygoogle.cc\/blog\/?p=1512"},"modified":"2025-04-27T05:09:06","modified_gmt":"2025-04-26T21:09:06","slug":"%e5%a6%82%e4%bd%95%e5%88%86%e6%9e%90-performance-max-%e6%90%9c%e7%b4%a2%e8%af%8d%e6%b4%9e%e5%af%9f%ef%bc%8c%e4%bb%a5%e5%ae%9e%e7%8e%b0-ppc-%e6%88%90%e5%8a%9f","status":"publish","type":"post","link":"https:\/\/www.buygoogle.cc\/blog\/?p=1512","title":{"rendered":"\u5982\u4f55\u5206\u6790 Performance Max \u641c\u7d22\u8bcd\u6d1e\u5bdf\uff0c\u4ee5\u5b9e\u73b0 PPC \u6210\u529f"},"content":{"rendered":"<div class=\"bialty-container\">\n<p><a href=\"https:\/\/searchengineland.com\/google-performance-max-431821\"><span>\u6548\u679c\u6700\u5927\u5316<\/span><\/a><span>\u5e7f\u544a\u7cfb\u5217\u56e0\u5176\u81ea\u52a8\u5316\u548c\u7b80\u4fbf\u6027\u800c\u5728<\/span><a href=\"https:\/\/searchengineland.com\/guide\/what-is-paid-search\"><span>PPC<\/span><\/a><span>\u5e7f\u544a\u5ba2\u6237\u4e2d\u5e7f\u53d7\u6b22\u8fce\u3002\u7136\u800c\uff0c\u4e00\u4e2a\u6301\u7eed\u5b58\u5728\u7684\u75db\u70b9\u662f\u7f3a\u4e4f\u5bf9\u89e6\u53d1\u5e7f\u544a\u7684\u641c\u7d22\u67e5\u8be2\u7684\u53ef\u89c1\u6027\u3002\u5982\u679c\u6ca1\u6709\u8fd9\u4e9b\u6570\u636e\uff0c<\/span><a href=\"https:\/\/searchengineland.com\/how-to-control-performance-max-campaigns-387424\"><span>\u6548\u679c\u6700\u5927\u5316<\/span><\/a><span>\u5e7f\u544a\u7cfb\u5217\u7684\u4f18\u5316\u5c31\u4f1a\u53d7\u5230\u9650\u5236\u3002\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/developers.google.com\/google-ads\/api\/fields\/v14\/campaign_search_term_insight\" target=\"_blank\" rel=\"noopener\"><span>2023 \u5e74 2 \u6708\uff0c\u8c37\u6b4c\u63a8\u51fa\u4e86campaign_search_term_insight<\/span><\/a><span>\u62a5\u544a\uff0c\u5176\u4e2d\u5305\u542b\u4e00\u4e2a\u5305\u542b\u641c\u7d22\u8bcd\u7684\u5b57\u6bb5\uff0c\u8fd9\u4f3c\u4e4e\u8ba9\u4eba\u677e\u4e86\u4e00\u53e3\u6c14\u3002\u5305\u62ec\u6211\u5728\u5185\u7684\u811a\u672c\u5f00\u53d1\u4eba\u5458\u7acb\u5373\u4f7f\u7528\u8fd9\u4e9b\u65b0\u7684\u641c\u7d22\u8bcd\u6570\u636e\u4e3a Performance Max \u5e7f\u544a\u7cfb\u5217\u6784\u5efa\u4e86\u811a\u672c\u548c\u81ea\u52a8\u5316\u7a0b\u5e8f\u3002\u00a0<\/span><\/p>\n<p><span>\u7136\u800c\uff0c\u5c3d\u7ba1\u8bb8\u591a\u53d1\u5e03\u7684\u811a\u672c\u58f0\u79f0\u5305\u542b\u641c\u7d22\u8bcd\u6570\u636e\uff0c\u4f46\u5b83\u4eec\u5747\u672a\u5305\u542b\u641c\u7d22\u8bcd\u6570\u636e\uff1b\u76f8\u53cd\uff0c\u5b83\u4eec\u4ec5\u9650\u4e8e\u7c7b\u522b\u6807\u7b7e\u3002\u8fd9\u662f\u7531\u4e8e Google \u62a5\u544a\u4e00\u76f4\u5b58\u5728\u9519\u8bef\uff0c\u62d2\u7edd\u5305\u542b\u641c\u7d22\u8bcd\u6570\u636e\u3002<\/span><\/p>\n<p><span>\u611f\u8c22 Mike Rhodes \u76d1\u63a7 Google \u62a5\u544a\u5e76\u544a\u77e5\u6211\u8be5\u9519\u8bef\u6700\u8fd1\u5df2\u5f97\u5230\u89e3\u51b3\u3002\u73b0\u5728\u641c\u7d22\u8bcd\u6570\u636e\u7ec8\u4e8e\u53ef\u4ee5\u5728\u811a\u672c\u4e2d\u4f7f\u7528\u4e86\uff0c\u6211\u5c06\u89e3\u91ca\u5982\u4f55\u8bbf\u95ee\u641c\u7d22\u67e5\u8be2\u6570\u636e\u3001\u5bf9\u5176\u8fdb\u884c\u5206\u6790\u4ee5\u627e\u5230\u4f18\u5316\u673a\u4f1a\u5e76\u6839\u636e\u7ed3\u679c\u91c7\u53d6\u884c\u52a8\u3002<\/span><\/p>\n<h2 id=\"h-what-data-is-now-available\" class=\"wp-block-heading\"><span>\u76ee\u524d\u6709\u54ea\u4e9b\u6570\u636e\u53ef\u7528\uff1f<\/span><\/h2>\n<p><span>2023 \u5e74 2 \u6708\uff0cGoogle \u63a8\u51fa\u4e86\u4e00\u4efd\u65b0\u7684\u6d1e\u5bdf\u62a5\u544a\uff0c\u4e13\u95e8\u7528\u4e8e\u5c55\u793a Performance Max \u641c\u7d22\u5b57\u8bcd\u6570\u636e\u3002\u6b64\u62a5\u544a\u53ef\u8ba9\u60a8\u4e86\u89e3\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><span>\u60a8\u7684\u5e7f\u544a\u5b9e\u9645\u51fa\u73b0\u7684\u641c\u7d22\u67e5\u8be2\u3002<\/span><\/li>\n<li><span>\u5c06\u67e5\u8be2\u5206\u7ec4\u5230\u7684\u641c\u7d22\u7c7b\u522b\u3002<\/span><\/li>\n<li><span>\u70b9\u51fb\u6b21\u6570\u3001\u5c55\u793a\u6b21\u6570\u548c\u5176\u4ed6\u7ee9\u6548\u6307\u6807\u3002<\/span><\/li>\n<\/ul>\n<p><span>\u5b83\u65e0\u6cd5\u63d0\u4f9b\u6210\u672c\u7684\u53ef\u89c1\u6027\u3002\u4f46\u662f\uff0c\u62e5\u6709\u641c\u7d22\u8bcd\u548c\u70b9\u51fb\u91cf\u662f\u4e00\u5927\u8fdb\u6b65\u3002<\/span><\/p>\n<h3 id=\"h-accessing-the-data\" class=\"wp-block-heading\"><span>\u8bbf\u95ee\u6570\u636e<\/span><\/h3>\n<p><span>\u6709\u4ee5\u4e0b\u51e0\u79cd\u65b9\u6cd5\u53ef\u4ee5\u8bbf\u95ee\u65b0\u7684 Performance Max \u641c\u7d22\u6d1e\u5bdf\u62a5\u544a\uff1a<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><span>\u76f4\u63a5\u5728 Google Ads \u754c\u9762\u7684\u5e7f\u544a\u7cfb\u5217\u9875\u9762\u7684<\/span><em><span>Insights\u4e0b\u8fdb\u884c\u3002<\/span><\/em><\/li>\n<li><span>\u901a\u8fc7 Google Ads API\u3002<\/span><\/li>\n<li><span>\u4f7f\u7528\u5229\u7528 API \u62a5\u544a\u7684 Google Ads \u811a\u672c\u3002<\/span><\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-438338 entered lazyloaded\" src=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Search-terms-for-Performance-Max-can-be-found-in-the-Google-Ads-UI.png.webp\" alt=\"\u60a8\u53ef\u4ee5\u5728 Google Ads \u754c\u9762\u4e2d\u627e\u5230\u201cPerformance Max\u201d\u7684\u641c\u7d22\u8bcd\u3002\u4f5c\u8005\u4e8e 2024 \u5e74 3 \u6708\u622a\u53d6\u7684\u5c4f\u5e55\u622a\u56fe\u3002\" width=\"1600\" height=\"769\" data-lazy-srcset=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Search-terms-for-Performance-Max-can-be-found-in-the-Google-Ads-UI.png.webp 1600w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Search-terms-for-Performance-Max-can-be-found-in-the-Google-Ads-UI-600x288.png.webp 600w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Search-terms-for-Performance-Max-can-be-found-in-the-Google-Ads-UI-800x385.png.webp 800w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Search-terms-for-Performance-Max-can-be-found-in-the-Google-Ads-UI-200x96.png.webp 200w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Search-terms-for-Performance-Max-can-be-found-in-the-Google-Ads-UI-768x369.png.webp 768w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Search-terms-for-Performance-Max-can-be-found-in-the-Google-Ads-UI-1536x738.png 1536w\" data-lazy-sizes=\"(max-width: 1600px) 100vw, 1600px\" data-lazy-src=\"https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Search-terms-for-Performance-Max-can-be-found-in-the-Google-Ads-UI.png.webp\" data-ll-status=\"loaded\" \/><figcaption class=\"wp-element-caption\"><em><span>\u60a8\u53ef\u4ee5\u5728 Google Ads \u754c\u9762\u4e2d\u627e\u5230\u201cPerformance Max\u201d\u7684\u641c\u7d22\u8bcd\u3002\u4f5c\u8005\u4e8e 2024 \u5e74 3 \u6708\u622a\u53d6\u7684\u5c4f\u5e55\u622a\u56fe\u3002<\/span><\/em><\/figcaption><\/figure>\n<\/div>\n<p><span>\u4f7f\u7528\u811a\u672c\u7684\u597d\u5904\u662f\u5b83\u53ef\u4ee5\u81ea\u52a8\u5c06\u6570\u636e\u62c9\u5165\u7535\u5b50\u8868\u683c\uff0c\u4ee5\u4fbf\u4e8e\u64cd\u4f5c\u548c\u5206\u6790\u3002\u00a0<\/span><\/p>\n<p><span>\u6211\u521b\u5efa\u4e86\u4e00\u4e2a\u811a\u672c\uff0c\u5c06\u641c\u7d22\u8bcd\u653e\u5165\u7535\u5b50\u8868\u683c\u4e2d\u3002\u53ea\u9700\u8f6c\u5230\u6b64<\/span><a href=\"https:\/\/gist.github.com\/siliconvallaeys\/a579409e0f94d8269744d6460b9cb466\" target=\"_blank\" rel=\"noopener\"><span>\u8981\u70b9 URL<\/span><\/a><span>\u5e76\u590d\u5236\u4ee3\u7801\u5373\u53ef\u3002<\/span><\/p>\n<p><span>\u7136\u540e\u5c06\u5176\u7c98\u8d34\u5230 Google Ads Scripts \u754c\u9762\u3002\u7136\u540e\uff0c\u5b83\u4f1a\u81ea\u52a8\u5c06\u6240\u6709 Performance Max \u5e7f\u544a\u7cfb\u5217\u7684\u641c\u7d22\u8bcd\u6570\u636e\u63d0\u53d6\u5230 Google Sheet \u4e2d\u3002<\/span><\/p>\n<p><span>\u5f53\u60a8\u8fd0\u884c\u811a\u672c\u65f6\uff0c\u5b83\u4f1a\u5c06\u6570\u636e\u6dfb\u52a0\u5230\u7535\u5b50\u8868\u683c\u4e2d\uff0c\u5982\u4e0b\u6240\u793a\uff1a<\/span><\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\">&lt;img class=&quot;wp-image-438339 entered exited&quot; src=&quot;data:;base64,&#8221; alt=&#8221;\u6548\u679c\u6700\u5927\u5316\u641c\u7d22\u5b57\u8bcd\u6570\u636e&#8221; width=&#8221;1600&#8243; height=&#8221;694&#8243; data-lazy-srcset=&#8221;https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-search-terms-data.png.webp 1600w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-search-terms-data-600&#215;260.png.webp 600w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-search-terms-data-800&#215;347.png.webp 800w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-search-terms-data-200&#215;87.png.webp 200w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-search-terms-data-768&#215;333.png.webp 768w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-search-terms-data-1536&#215;666.png 1536w&#8221; data-lazy-sizes=&#8221;(max-width: 1600px) 100vw, 1600px&#8221; data-lazy-src=&#8221;https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-search-terms-data.png.webp&#8221; \/&gt;<\/figure>\n<\/div>\n<p><span>\u6570\u636e\u53ef\u7528\u6027\u4e0e\u5e38\u89c4\u641c\u7d22\u67e5\u8be2\u62a5\u544a\u7c7b\u4f3c\uff0c\u4f46\u6709\u4e00\u4e9b\u9650\u5236\uff1a<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><span>\u6570\u636e\u4ec5\u53ef\u8ffd\u6eaf\u81f3 2023 \u5e74 3 \u6708\u9996\u6b21\u53d1\u5e03\u4e4b\u65f6\u3002<\/span><\/li>\n<li><span>\u5982\u679c\u641c\u7d22\u91cf\u5f88\u5927\uff0c\u53ef\u80fd\u4f1a\u5bf9\u641c\u7d22\u8bcd\u6570\u636e\u8fdb\u884c\u91c7\u6837\u3002<\/span><\/li>\n<\/ul>\n<p><span>\u4e0d\u8fc7\uff0c\u8fd9\u4ecd\u7136\u6bd4\u4e4b\u524d\u7684\u6548\u679c\u6700\u5927\u5316\u5e7f\u544a\u7cfb\u5217\u63d0\u4f9b\u4e86\u66f4\u9ad8\u7684\u53ef\u89c1\u5ea6\u3002<\/span><\/p>\n<h2 id=\"h-analyzing-the-data-nbsp-nbsp\" class=\"wp-block-heading\"><span>\u5206\u6790\u6570\u636e\u00a0\u00a0<\/span><\/h2>\n<p><span>\u73b0\u5728\u60a8\u5df2\u5c06\u6548\u679c\u6700\u5927\u5316\u641c\u7d22\u67e5\u8be2\u6570\u636e\u63d0\u53d6\u5230\u7535\u5b50\u8868\u683c\u4e2d\uff0c\u60a8\u53ef\u4ee5\u83b7\u5f97\u54ea\u4e9b\u89c1\u89e3\uff1f\u4ee5\u4e0b\u662f\u60a8\u53ef\u4ee5\u8fdb\u884c\u7684\u4e00\u4e9b\u5206\u6790\uff1a<\/span><\/p>\n<p><span>\u8bc6\u522b\u89e6\u53d1\u60a8\u7684\u5e7f\u544a\u7684\u4e0d\u76f8\u5173\u641c\u7d22\u8bcd\u3002\u00a0<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><span>\u67e5\u627e\u53ef\u63d0\u9ad8\u8f6c\u5316\u7387\u7684\u9ad8\u6548\u641c\u7d22\u8bcd\u3002\u5bfb\u627e\u673a\u4f1a\u4f18\u5316\u8fd9\u4e9b\u8bcd\u4ee5\u589e\u52a0\u641c\u7d22\u91cf\u3002<\/span><\/li>\n<li><span>\u67e5\u770b\u641c\u7d22\u7c7b\u522b\uff0c\u5bfb\u627e\u5df2\u5728\u8d77\u4f5c\u7528\u7684\u5176\u4ed6\u5173\u952e\u5b57\u521b\u610f\u3002\u00a0<\/span><\/li>\n<li><span>\u6309\u5c55\u793a\u6b21\u6570\u6392\u5e8f\uff0c\u53ef\u4ee5\u627e\u5230\u5c55\u793a\u6b21\u6570\u9ad8\u3001\u70b9\u51fb\u6b21\u6570\u4f4e\u7684\u5b57\u8bcd\uff0c\u8fd9\u4e9b\u5b57\u8bcd\u53ef\u80fd\u8868\u660e\u76f8\u5173\u6027\u8f83\u5dee\uff0c\u5e76\u4e14\u53ef\u4ee5\u4ece\u6807\u9898\u548c\u63cf\u8ff0\u7b49\u66f4\u597d\u7684\u5e7f\u544a\u521b\u610f\u8d44\u4ea7\u4e2d\u53d7\u76ca\u3002<\/span><\/li>\n<\/ul>\n<p><span>\u672c\u8d28\u4e0a\uff0c\u60a8\u6b63\u5728\u5bfb\u627e\u6570\u636e\u4e2d\u7684\u641c\u7d22\u8bcd\u6a21\u5f0f\uff0c\u4ee5\u4fbf\u66f4\u597d\u5730\u4f18\u5316\u5e7f\u544a\u7cfb\u5217\u3002<\/span><\/p>\n<p><span>\u7531\u4e8e\u60a8\u65e0\u6cd5\u5728 Performance Max \u4e2d\u5b9a\u4f4d\u7279\u5b9a\u5173\u952e\u5b57\uff0c\u56e0\u6b64\u8fd9\u5e76\u4e0d\u662f\u8981\u786e\u5b9a\u8981\u6dfb\u52a0\u7684\u5f3a\u6548\u65b0\u5173\u952e\u5b57\u3002\u4e0d\u8fc7\uff0c\u60a8\u53ef\u4ee5\u627e\u5230\u65b0\u5426\u5b9a\u8bcd\u7684\u4fe1\u53f7\uff0c\u5e76\u83b7\u5f97\u6709\u5173\u5982\u4f55\u6539\u8fdb\u5e7f\u544a\u6587\u6848\u6216\u7740\u9646\u9875\u7684\u7075\u611f\u3002\u00a0<\/span><\/p>\n<div class=\"nl-inline-form border py-2 px-1 my-2\">\n<div class=\"row\">\n<div class=\"col-12\"><\/div>\n<\/div>\n<div class=\"row align-items-center nl-inline-container\">\n<div class=\"col-12 col-lg-3 col-xl-4 pe-md-0 pb-2 pb-lg-0\">\n<p class=\"inline-form-text text-center mb-0\"><span>\u83b7\u53d6\u641c\u7d22\u8425\u9500\u4eba\u5458\u6240\u4f9d\u8d56\u7684\u65b0\u95fb\u901a\u8baf\u3002<\/span><\/p>\n<\/div>\n<div class=\"col-12 col-lg-7 col-xl-6  pe-lg-0\">\n<div class=\"form-nl-inline\">\n<div class=\"row g-0\">\n<div class=\"form-group col-12 col-lg-8 mb-0\"><label class=\"visually-hidden\" for=\"nl-inlineEmail\"><span>\u4f01\u4e1a\u7535\u5b50\u90ae\u4ef6\u5730\u5740<\/span><\/label><\/div>\n<div class=\"col-12 col-lg-4 col-xl-4 mb-0\">\n<div id=\"article_inline_captcha\">\n<div><\/div>\n<\/div>\n<p><button id=\"inline-button\" class=\"btn btn-sel inlineButton w-100 rounded-0\" name=\"submit_button\" type=\"submit\"><span>\u4e3a\u6211\u62a5\u540d\uff01<\/span><\/button><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"col-12 col-lg-2 col-xl-2 ps-1\">\n<p class=\"text-center mb-0\"><a class=\"nl-terms\" href=\"https:\/\/searchengineland.com\/termsofuse\" target=\"_blank\" rel=\"noopener\" aria-label=\"\u5728\u65b0\u6807\u7b7e\u9875\u4e2d\u6253\u5f00\"><span>\u67e5\u770b\u6761\u6b3e\u3002<\/span><\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<hr class=\"wp-block-separator has-text-color has-cyan-bluish-gray-color has-css-opacity has-cyan-bluish-gray-background-color has-background\" \/>\n<h2 id=\"h-using-gpt-4-to-analyze-the-data\" class=\"wp-block-heading\"><span>\u4f7f\u7528 GPT-4 \u5206\u6790\u6570\u636e<\/span><\/h2>\n<p><span>\u5728\u8c37\u6b4c\u4fee\u590d\u9519\u8bef\u5e76\u4f7f\u6570\u636e\u6b63\u5e38\u8fd0\u884c\u7684\u4e00\u5e74\u91cc\uff0cGPT \u53d6\u5f97\u4e86\u957f\u8db3\u7684\u8fdb\u6b65\u3002\u56e0\u6b64\uff0c\u6211\u4e0b\u8f7d\u4e86\u811a\u672c\u751f\u6210\u7684\u62a5\u544a\uff0c\u5c06 CSV \u4e0a\u4f20\u5230 GPT-4\uff0c\u5e76\u8be2\u95ee\u5b83\u662f\u5426\u53ef\u4ee5\u5e2e\u52a9\u6211\u627e\u5230\u4f18\u5316\u601d\u8def\u3002<\/span><\/p>\n<p><span>\u6211\u4f7f\u7528\u4e86\u63d0\u793a\uff1a\u00a0<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><em><span>\u201c\u6211\u6709\u4e00\u4e2a\u6587\u4ef6\uff0c\u5176\u4e2d\u5305\u542b\u6211\u5728 Performance Max \u5e7f\u544a\u7cfb\u5217\u4e2d\u6295\u653e\u7684 Google \u5e7f\u544a\u7684\u641c\u7d22\u5b57\u8bcd\u3002\u60a8\u80fd\u5206\u6790\u4e00\u4e0b\u8fd9\u4e9b\u641c\u7d22\u5b57\u8bcd\u5e76\u5206\u4eab\u4e00\u4e9b\u6709\u8da3\u7684\u53d1\u73b0\u5417\uff1f\u201d<\/span><\/em><\/li>\n<\/ul>\n<p><span>\u5b83\u81ea\u52a8\u4f7f\u7528 openAI \u4ee3\u7801\u89e3\u91ca\u5668\u529f\u80fd\u6765\u626b\u63cf\u6587\u4ef6\uff0c\u5e76\u5efa\u8bae\u56db\u4e2a\u6570\u636e\u6bb5\u4f9b\u8fdb\u4e00\u6b65\u8c03\u67e5\uff1a<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><strong><span>\u9ad8\u8f6c\u5316\u7387\u5b57\u8bcd<\/span><\/strong><span>\uff1a\u5e26\u6765\u6700\u591a\u8f6c\u5316\u7684\u641c\u7d22\u5b57\u8bcd\u3002<\/span><\/li>\n<li><strong><span>\u9ad8\u4ef7\u503c\u5b57\u8bcd<\/span><\/strong><span>\uff1a\u8f6c\u5316\u4ef7\u503c\u6700\u9ad8\u7684\u641c\u7d22\u5b57\u8bcd\u3002<\/span><\/li>\n<li><strong><span>\u6548\u7387\u6307\u6807<\/span><\/strong><span>\uff1a\u70b9\u51fb\u6b21\u6570\u4e0e\u5c55\u793a\u6b21\u6570\u4e4b\u6bd4\uff08CTR\uff09\u548c\u8f6c\u5316\u6b21\u6570\u4e0e\u70b9\u51fb\u6b21\u6570\u4e4b\u6bd4\uff08\u8f6c\u5316\u7387\uff09\u6700\u9ad8\u7684\u641c\u7d22\u8bcd\u3002<\/span><\/li>\n<li><strong><span>\u7c7b\u522b\u548c\u5b50\u7c7b\u522b\u6d1e\u5bdf<\/span><\/strong><span>\uff1a\u4e0d\u540c\u7c7b\u522b\u548c\u5b50\u7c7b\u522b\u4e4b\u95f4\u7684\u6027\u80fd\u8d8b\u52bf\u3002<\/span><\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\">&lt;img class=&quot;wp-image-438340 entered exited&quot; src=&quot;data:;base64,&#8221; alt=&#8221;\u4f7f\u7528 GPT-4 \u5206\u6790\u6570\u636e-\u63d0\u793a\u548c\u7ed3\u679c&#8221; width=&#8221;1554&#8243; height=&#8221;1288&#8243; data-lazy-srcset=&#8221;https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Using-GPT-4-to-analyze-the-data-Prompt-and-result.png.webp 1554w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Using-GPT-4-to-analyze-the-data-Prompt-and-result-408&#215;338.png.webp 408w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Using-GPT-4-to-analyze-the-data-Prompt-and-result-724&#215;600.png.webp 724w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Using-GPT-4-to-analyze-the-data-Prompt-and-result-136&#215;113.png.webp 136w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Using-GPT-4-to-analyze-the-data-Prompt-and-result-768&#215;637.png.webp 768w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Using-GPT-4-to-analyze-the-data-Prompt-and-result-1536&#215;1273.png 1536w&#8221; data-lazy-sizes=&#8221;(max-width: 1554px) 100vw, 1554px&#8221; data-lazy-src=&#8221;https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Using-GPT-4-to-analyze-the-data-Prompt-and-result.png.webp&#8221; \/&gt;<\/figure>\n<\/div>\n<p><span>\u5b83\u7acb\u5373\u5f00\u59cb\u5206\u6790\u6211\u4e0a\u4f20\u7684\u5b8c\u6574\u6570\u636e\u96c6\u3002\u7531\u4e8e\u5b83\u4f7f\u7528\u4e86<\/span><a href=\"https:\/\/searchengineland.com\/ppc-chatgpt-advanced-data-analysis-plugin-431103\" target=\"_blank\" rel=\"noopener\"><span>\u9ad8\u7ea7\u6570\u636e\u5206\u6790<\/span><\/a><span>\uff08\u4ee5\u524d\u79f0\u4e3a\u4ee3\u7801\u89e3\u91ca\u5668\uff09\uff0c\u6240\u4ee5\u6211\u53ef\u4ee5\u770b\u5230\u5b83\u6b63\u5728\u4f7f\u7528\u7684 Python \u4ee3\u7801\u3002<\/span><\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\">&lt;img class=&quot;wp-image-438341 entered exited&quot; src=&quot;data:;base64,&#8221; alt=&#8221;\u6548\u679c\u6700\u5927\u5316\u6570\u636e &#8211; \u9ad8\u7ea7\u6570\u636e\u5206\u6790&#8221; width=&#8221;1160&#8243; height=&#8221;1270&#8243; data-lazy-srcset=&#8221;https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-data-Advanced-Data-Analysis.png.webp 1160w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-data-Advanced-Data-Analysis-309&#215;338.png.webp 309w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-data-Advanced-Data-Analysis-548&#215;600.png.webp 548w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-data-Advanced-Data-Analysis-103&#215;113.png.webp 103w,https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-data-Advanced-Data-Analysis-768&#215;841.png.webp 768w&#8221; data-lazy-sizes=&#8221;(max-width: 1160px) 100vw, 1160px&#8221; data-lazy-src=&#8221;https:\/\/searchengineland.com\/wp-content\/seloads\/2024\/03\/Performance-Max-data-Advanced-Data-Analysis.png.webp&#8221; \/&gt;<\/figure>\n<\/div>\n<p><span>\u57fa\u4e8e\u6b64\uff0c\u6211\u53d1\u73b0\u8c37\u6b4c\u5728\u4e0e\u201c\u514d\u8d39\u5e7f\u544a\u201d\u76f8\u5173\u7684\u641c\u7d22\u4e2d\u5927\u91cf\u5c55\u793a\u6211\u7684\u5e7f\u544a\uff0c\u7531\u4e8e\u6211\u5bf9\u6b64\u65e0\u80fd\u4e3a\u529b\uff0c\u5b83\u4e3a\u6211\u63d0\u4f9b\u4e86\u4e00\u4e2a\u65b0\u5e10\u6237\u7ea7\u5426\u5b9a\u5173\u952e\u5b57\u7684\u597d\u4e3b\u610f\u3002\u00a0<\/span><\/p>\n<h2 id=\"h-taking-action-nbsp-nbsp\" class=\"wp-block-heading\"><span>\u91c7\u53d6\u884c\u52a8\u00a0\u00a0<\/span><\/h2>\n<p><span>\u73b0\u5728\u60a8\u5df2\u7ecf\u5206\u6790\u4e86 Performance Max \u641c\u7d22\u5b57\u8bcd\u6570\u636e\uff0c\u6211\u5efa\u8bae\u60a8\u91c7\u53d6\u4ee5\u4e0b\u4e09\u9879\u63aa\u65bd\uff1a<\/span><\/p>\n<ul class=\"wp-block-list\">\n<li><span>\u5c06\u4e0d\u76f8\u5173\u7684\u5b57\u8bcd\u6dfb\u52a0\u4e3a\u5e10\u6237\u7ea7\u5426\u5b9a\u5173\u952e\u5b57\u3002\u60a8\u65e0\u6cd5\u5728\u6548\u679c\u6700\u5927\u5316\u5e7f\u544a\u7cfb\u5217\u7ea7\u522b\u6dfb\u52a0\u5426\u5b9a\u5173\u952e\u5b57\u3002\u4f46\u662f\uff0c\u5c06\u4e0d\u76f8\u5173\u7684\u5b57\u8bcd\u6dfb\u52a0\u4e3a\u5e10\u6237\u5426\u5b9a\u8bcd\u5c06\u963b\u6b62\u5e7f\u544a\u5728\u6574\u4e2a\u5e10\u6237\u4e2d\u9488\u5bf9\u8fd9\u4e9b\u67e5\u8be2\u5c55\u793a\u3002<\/span><\/li>\n<li><span>\u9488\u5bf9\u6548\u679c\u826f\u597d\u7684\u67e5\u8be2\u4f18\u5316\u5e7f\u544a\u548c\u767b\u5f55\u9875\u9762\u3002\u5bfb\u627e\u70b9\u51fb\u7387\u548c\u8f6c\u5316\u7387\u8f83\u9ad8\u7684\u641c\u7d22\u8bcd\u4e3b\u9898\u3002\u7136\u540e\uff0c\u589e\u5f3a\u60a8\u7684\u5e7f\u544a\u6587\u6848\u3001\u4f18\u60e0\u548c\u767b\u5f55\u9875\u9762\uff0c\u4ee5\u66f4\u597d\u5730\u5b9a\u4f4d\u8fd9\u4e9b\u7528\u6237\u3002<\/span><\/li>\n<li><span>\u5229\u7528\u60a8\u4e86\u89e3\u5230\u7684\u4fe1\u606f\u4f18\u5316\u53d7\u4f17\u5b9a\u4f4d\u3002\u641c\u7d22\u67e5\u8be2\u53ef\u8ba9\u60a8\u6df1\u5165\u4e86\u89e3\u7406\u60f3\u53d7\u4f17\u3002\u5bfb\u627e\u53ef\u4f5c\u4e3a\u53d7\u4f17\u76ee\u6807\u6dfb\u52a0\u5230\u5e7f\u544a\u7cfb\u5217\u4e2d\u7684\u4eba\u53e3\u7edf\u8ba1\u6216\u5174\u8da3\u6a21\u5f0f\u3002<\/span><\/li>\n<\/ul>\n<h2 id=\"h-the-script\" class=\"wp-block-heading\"><span>\u811a\u672c<\/span><\/h2>\n<p>&nbsp;<\/p>\n<div id=\"gist128898970\" class=\"gist\">\n<div class=\"gist-file\" data-color-mode=\"light\" data-light-theme=\"light\">\n<div class=\"gist-data\">\n<div class=\"js-gist-file-update-container js-task-list-container\">\n<div id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet\" class=\"file my-2\">\n<div class=\"Box-body p-0 blob-wrapper data type-text  \">\n<div class=\"js-check-bidi js-blob-code-container blob-code-content\">\n<table class=\"highlight tab-size js-file-line-container\" data-hpc=\"\" data-tab-size=\"8\" data-paste-markdown-skip=\"\" data-tagsearch-path=\"PMax Search Terms and Categories in a Spreadsheet\">\n<tbody>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L1\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"1\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC1\" class=\"blob-code blob-code-inner js-file-line\">function main() {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L2\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"2\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC2\" class=\"blob-code blob-code-inner js-file-line\">\/******************************************<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L3\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"3\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC3\" class=\"blob-code blob-code-inner js-file-line\">* PMax Search Terms Report<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L4\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"4\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC4\" class=\"blob-code blob-code-inner js-file-line\">* @version: 1.0<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L5\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"5\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC5\" class=\"blob-code blob-code-inner js-file-line\">* @authors: Frederick Vallaeys (Optmyzr)<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L6\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"6\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC6\" class=\"blob-code blob-code-inner js-file-line\">* &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L7\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"7\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC7\" class=\"blob-code blob-code-inner js-file-line\">* Install this script in your Google Ads account (not an MCC account)<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L8\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"8\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC8\" class=\"blob-code blob-code-inner js-file-line\">* to generate a spreadsheet containing the search terms in your Performance Max campaigns.<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L9\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"9\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC9\" class=\"blob-code blob-code-inner js-file-line\">* The spreadsheet also includes data about category labels (groupings of search terms).<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L10\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"10\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC10\" class=\"blob-code blob-code-inner js-file-line\">* Metrics include conversion value, conversions, clicks, and impressions<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L11\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"11\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC11\" class=\"blob-code blob-code-inner js-file-line\">* &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L12\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"12\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC12\" class=\"blob-code blob-code-inner js-file-line\">* v2 (Mar 14, 2024): adds a new column that says if the search terms exists as a keyword in a search campaign. adds better error handling.<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L13\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"13\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC13\" class=\"blob-code blob-code-inner js-file-line\">* &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L14\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"14\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC14\" class=\"blob-code blob-code-inner js-file-line\">* For more PPC tools and scripts, visit www.optmyzr.com.<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L15\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"15\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC15\" class=\"blob-code blob-code-inner js-file-line\">******************************************\/<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L16\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"16\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC16\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L17\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"17\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC17\" class=\"blob-code blob-code-inner js-file-line\">var minImp = 10; \/\/ Limit the output to only items with at least this many impressions<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L18\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"18\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC18\" class=\"blob-code blob-code-inner js-file-line\">var spreadsheetUrl = &#8220;&#8221;; \/\/ leave blank to generate a new spreadsheet or add your own URL to overwrite the data in an existing spreadsheet<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L19\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"19\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC19\" class=\"blob-code blob-code-inner js-file-line\">var reportLastNDays = 30; \/\/ The number of days to include in the report<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L20\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"20\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC20\" class=\"blob-code blob-code-inner js-file-line\">var EMAILADDRESS = &#8220;&#8221;; \/\/ enter your email address<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L21\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"21\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC21\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L22\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"22\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC22\" class=\"blob-code blob-code-inner js-file-line\">\/\/ Don&#8217;t edit below this line unless you know how to write scripts<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L23\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"23\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC23\" class=\"blob-code blob-code-inner js-file-line\">\/\/&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L24\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"24\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC24\" class=\"blob-code blob-code-inner js-file-line\">let pmaxOnly = 1;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L25\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"25\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC25\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L26\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"26\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC26\" class=\"blob-code blob-code-inner js-file-line\">let allCategoryLabels = [<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L27\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"27\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC27\" class=\"blob-code blob-code-inner js-file-line\">[<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L28\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"28\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC28\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Campaign Name&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L29\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"29\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC29\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Category Label&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L30\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"30\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC30\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Conv Val&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L31\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"31\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC31\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Conv&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L32\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"32\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC32\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Clicks&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L33\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"33\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC33\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Imp&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L34\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"34\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC34\" class=\"blob-code blob-code-inner js-file-line\">],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L35\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"35\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC35\" class=\"blob-code blob-code-inner js-file-line\">];<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L36\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"36\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC36\" class=\"blob-code blob-code-inner js-file-line\">let allSearchTerms = [<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L37\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"37\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC37\" class=\"blob-code blob-code-inner js-file-line\">[<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L38\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"38\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC38\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Campaign Name&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L39\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"39\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC39\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Category Label&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L40\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"40\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC40\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Subcat&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L41\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"41\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC41\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Search Term&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L42\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"42\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC42\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Conv Val&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L43\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"43\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC43\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Conv&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L44\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"44\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC44\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Clicks&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L45\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"45\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC45\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Imp&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L46\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"46\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC46\" class=\"blob-code blob-code-inner js-file-line\">&#8220;Exists as Keyword?&#8221;,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L47\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"47\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC47\" class=\"blob-code blob-code-inner js-file-line\">],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L48\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"48\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC48\" class=\"blob-code blob-code-inner js-file-line\">];<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L49\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"49\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC49\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L50\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"50\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC50\" class=\"blob-code blob-code-inner js-file-line\">let keywordsList = getAllSearchCampaignKeywords();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L51\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"51\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC51\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L52\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"52\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC52\" class=\"blob-code blob-code-inner js-file-line\">var dateRange = getDateRange(reportLastNDays);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L53\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"53\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC53\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L54\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"54\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC54\" class=\"blob-code blob-code-inner js-file-line\">try {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L55\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"55\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC55\" class=\"blob-code blob-code-inner js-file-line\">let baseQuery = `<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L56\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"56\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC56\" class=\"blob-code blob-code-inner js-file-line\">SELECT<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L57\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"57\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC57\" class=\"blob-code blob-code-inner js-file-line\">campaign.id,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L58\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"58\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC58\" class=\"blob-code blob-code-inner js-file-line\">campaign.name,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L59\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"59\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC59\" class=\"blob-code blob-code-inner js-file-line\">metrics.clicks,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L60\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"60\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC60\" class=\"blob-code blob-code-inner js-file-line\">metrics.impressions,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L61\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"61\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC61\" class=\"blob-code blob-code-inner js-file-line\">metrics.conversions,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L62\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"62\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC62\" class=\"blob-code blob-code-inner js-file-line\">metrics.conversions_value<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L63\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"63\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC63\" class=\"blob-code blob-code-inner js-file-line\">FROM campaign<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L64\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"64\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC64\" class=\"blob-code blob-code-inner js-file-line\">WHERE campaign.status != &#8216;REMOVED&#8217;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L65\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"65\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC65\" class=\"blob-code blob-code-inner js-file-line\">AND metrics.impressions &gt; 0<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L66\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"66\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC66\" class=\"blob-code blob-code-inner js-file-line\">AND segments.date BETWEEN ${dateRange}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L67\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"67\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC67\" class=\"blob-code blob-code-inner js-file-line\">AND metrics.impressions &gt;= ${minImp}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L68\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"68\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC68\" class=\"blob-code blob-code-inner js-file-line\">`;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L69\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"69\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC69\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L70\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"70\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC70\" class=\"blob-code blob-code-inner js-file-line\">\/\/ Modify the SQL query if pmaxOnly is true<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L71\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"71\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC71\" class=\"blob-code blob-code-inner js-file-line\">if (pmaxOnly) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L72\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"72\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC72\" class=\"blob-code blob-code-inner js-file-line\">baseQuery +=<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L73\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"73\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC73\" class=\"blob-code blob-code-inner js-file-line\">&#8221; AND campaign.advertising_channel_type = &#8216;PERFORMANCE_MAX&#8217; &#8220;;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L74\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"74\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC74\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L75\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"75\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC75\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L76\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"76\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC76\" class=\"blob-code blob-code-inner js-file-line\">baseQuery += &#8220;ORDER BY metrics.conversions DESC&#8221;;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L77\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"77\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC77\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L78\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"78\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC78\" class=\"blob-code blob-code-inner js-file-line\">let campaignIdsQuery = AdsApp.report(baseQuery);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L79\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"79\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC79\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L80\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"80\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC80\" class=\"blob-code blob-code-inner js-file-line\">let rows = campaignIdsQuery.rows();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L81\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"81\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC81\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L82\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"82\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC82\" class=\"blob-code blob-code-inner js-file-line\">while (rows.hasNext()) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L83\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"83\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC83\" class=\"blob-code blob-code-inner js-file-line\">let campaignRow = rows.next();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L84\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"84\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC84\" class=\"blob-code blob-code-inner js-file-line\">let campaignId = campaignRow[&#8220;campaign.id&#8221;];<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L85\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"85\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC85\" class=\"blob-code blob-code-inner js-file-line\">Logger.log(<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L86\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"86\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC86\" class=\"blob-code blob-code-inner js-file-line\">campaignRow[&#8220;campaign.id&#8221;] + &#8221; &#8221; + campaignRow[&#8220;campaign.name&#8221;]<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L87\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"87\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC87\" class=\"blob-code blob-code-inner js-file-line\">);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L88\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"88\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC88\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L89\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"89\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC89\" class=\"blob-code blob-code-inner js-file-line\">\/\/ Search Labels Report<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L90\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"90\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC90\" class=\"blob-code blob-code-inner js-file-line\">let categoryLabelsQuery = `<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L91\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"91\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC91\" class=\"blob-code blob-code-inner js-file-line\">SELECT<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L92\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"92\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC92\" class=\"blob-code blob-code-inner js-file-line\">campaign_search_term_insight.category_label,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L93\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"93\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC93\" class=\"blob-code blob-code-inner js-file-line\">campaign_search_term_insight.id,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L94\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"94\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC94\" class=\"blob-code blob-code-inner js-file-line\">metrics.clicks,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L95\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"95\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC95\" class=\"blob-code blob-code-inner js-file-line\">metrics.impressions,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L96\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"96\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC96\" class=\"blob-code blob-code-inner js-file-line\">metrics.conversions,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L97\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"97\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC97\" class=\"blob-code blob-code-inner js-file-line\">metrics.conversions_value<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L98\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"98\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC98\" class=\"blob-code blob-code-inner js-file-line\">FROM<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L99\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"99\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC99\" class=\"blob-code blob-code-inner js-file-line\">campaign_search_term_insight<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L100\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"100\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC100\" class=\"blob-code blob-code-inner js-file-line\">WHERE<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L101\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"101\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC101\" class=\"blob-code blob-code-inner js-file-line\">segments.date BETWEEN ${dateRange}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L102\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"102\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC102\" class=\"blob-code blob-code-inner js-file-line\">AND campaign_search_term_insight.campaign_id = &#8216;${campaignId}&#8217;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L103\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"103\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC103\" class=\"blob-code blob-code-inner js-file-line\">AND metrics.impressions &gt;= ${minImp}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L104\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"104\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC104\" class=\"blob-code blob-code-inner js-file-line\">ORDER BY<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L105\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"105\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC105\" class=\"blob-code blob-code-inner js-file-line\">metrics.conversions DESC<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L106\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"106\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC106\" class=\"blob-code blob-code-inner js-file-line\">`;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L107\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"107\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC107\" class=\"blob-code blob-code-inner js-file-line\">let categoryLabelsQueryResult = AdsApp.report(categoryLabelsQuery);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L108\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"108\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC108\" class=\"blob-code blob-code-inner js-file-line\">let categoryLabelsResults = categoryLabelsQueryResult.rows();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L109\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"109\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC109\" class=\"blob-code blob-code-inner js-file-line\">while (categoryLabelsResults.hasNext()) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L110\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"110\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC110\" class=\"blob-code blob-code-inner js-file-line\">let categoryLabelsRow = categoryLabelsResults.next();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L111\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"111\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC111\" class=\"blob-code blob-code-inner js-file-line\">let categoryLabelId =<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L112\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"112\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC112\" class=\"blob-code blob-code-inner js-file-line\">categoryLabelsRow[&#8220;campaign_search_term_insight.id&#8221;];<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L113\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"113\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC113\" class=\"blob-code blob-code-inner js-file-line\">\/\/Logger.log(categoryLabelId + &#8220;. &#8221; + categoryLabelsRow[&#8216;campaign_search_term_insight.category_label&#8217;] + &#8221; &#8221; + categoryLabelsRow[&#8216;metrics.impressions&#8217;]);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L114\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"114\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC114\" class=\"blob-code blob-code-inner js-file-line\">allCategoryLabels.push([<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L115\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"115\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC115\" class=\"blob-code blob-code-inner js-file-line\">campaignRow[&#8220;campaign.name&#8221;],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L116\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"116\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC116\" class=\"blob-code blob-code-inner js-file-line\">categoryLabelsRow[<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L117\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"117\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC117\" class=\"blob-code blob-code-inner js-file-line\">&#8220;campaign_search_term_insight.category_label&#8221;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L118\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"118\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC118\" class=\"blob-code blob-code-inner js-file-line\">],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L119\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"119\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC119\" class=\"blob-code blob-code-inner js-file-line\">categoryLabelsRow[&#8220;metrics.conversions_value&#8221;].toFixed(2),<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L120\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"120\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC120\" class=\"blob-code blob-code-inner js-file-line\">categoryLabelsRow[&#8220;metrics.conversions&#8221;].toFixed(1),<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L121\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"121\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC121\" class=\"blob-code blob-code-inner js-file-line\">categoryLabelsRow[&#8220;metrics.clicks&#8221;],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L122\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"122\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC122\" class=\"blob-code blob-code-inner js-file-line\">categoryLabelsRow[&#8220;metrics.impressions&#8221;],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L123\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"123\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC123\" class=\"blob-code blob-code-inner js-file-line\">]);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L124\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"124\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC124\" class=\"blob-code blob-code-inner js-file-line\">\/\/ Search Terms Report<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L125\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"125\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC125\" class=\"blob-code blob-code-inner js-file-line\">let searchTermsQuery = `<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L126\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"126\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC126\" class=\"blob-code blob-code-inner js-file-line\">SELECT<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L127\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"127\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC127\" class=\"blob-code blob-code-inner js-file-line\">metrics.clicks,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L128\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"128\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC128\" class=\"blob-code blob-code-inner js-file-line\">metrics.impressions,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L129\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"129\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC129\" class=\"blob-code blob-code-inner js-file-line\">metrics.conversions,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L130\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"130\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC130\" class=\"blob-code blob-code-inner js-file-line\">metrics.conversions_value,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L131\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"131\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC131\" class=\"blob-code blob-code-inner js-file-line\">segments.search_term,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L132\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"132\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC132\" class=\"blob-code blob-code-inner js-file-line\">segments.search_subcategory<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L133\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"133\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC133\" class=\"blob-code blob-code-inner js-file-line\">FROM<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L134\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"134\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC134\" class=\"blob-code blob-code-inner js-file-line\">campaign_search_term_insight<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L135\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"135\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC135\" class=\"blob-code blob-code-inner js-file-line\">WHERE<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L136\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"136\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC136\" class=\"blob-code blob-code-inner js-file-line\">segments.date BETWEEN ${dateRange}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L137\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"137\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC137\" class=\"blob-code blob-code-inner js-file-line\">AND campaign_search_term_insight.campaign_id = &#8216;${campaignId}&#8217;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L138\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"138\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC138\" class=\"blob-code blob-code-inner js-file-line\">AND campaign_search_term_insight.id = &#8216;${categoryLabelId}&#8217;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L139\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"139\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC139\" class=\"blob-code blob-code-inner js-file-line\">`;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L140\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"140\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC140\" class=\"blob-code blob-code-inner js-file-line\">let searchTermsQueryResult = AdsApp.report(searchTermsQuery);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L141\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"141\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC141\" class=\"blob-code blob-code-inner js-file-line\">let searchTermsResults = searchTermsQueryResult.rows();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L142\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"142\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC142\" class=\"blob-code blob-code-inner js-file-line\">\/\/ Inside the loop where search terms are being processed<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L143\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"143\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC143\" class=\"blob-code blob-code-inner js-file-line\">while (searchTermsResults.hasNext()) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L144\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"144\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC144\" class=\"blob-code blob-code-inner js-file-line\">let searchTermsRow = searchTermsResults.next();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L145\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"145\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC145\" class=\"blob-code blob-code-inner js-file-line\">if (searchTermsRow[&#8220;metrics.impressions&#8221;] &gt;= minImp) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L146\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"146\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC146\" class=\"blob-code blob-code-inner js-file-line\">let searchTermText = searchTermsRow[<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L147\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"147\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC147\" class=\"blob-code blob-code-inner js-file-line\">&#8220;segments.search_term&#8221;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L148\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"148\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC148\" class=\"blob-code blob-code-inner js-file-line\">].toLowerCase(); \/\/ Normalize search term text for comparison<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L149\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"149\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC149\" class=\"blob-code blob-code-inner js-file-line\">let existsAsKeyword = keywordsList[searchTermText]<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L150\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"150\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC150\" class=\"blob-code blob-code-inner js-file-line\">? &#8220;Yes&#8221;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L151\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"151\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC151\" class=\"blob-code blob-code-inner js-file-line\">: &#8220;No&#8221;;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L152\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"152\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC152\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L153\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"153\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC153\" class=\"blob-code blob-code-inner js-file-line\">allSearchTerms.push([<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L154\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"154\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC154\" class=\"blob-code blob-code-inner js-file-line\">campaignRow[&#8220;campaign.name&#8221;],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L155\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"155\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC155\" class=\"blob-code blob-code-inner js-file-line\">categoryLabelsRow[<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L156\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"156\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC156\" class=\"blob-code blob-code-inner js-file-line\">&#8220;campaign_search_term_insight.category_label&#8221;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L157\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"157\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC157\" class=\"blob-code blob-code-inner js-file-line\">],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L158\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"158\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC158\" class=\"blob-code blob-code-inner js-file-line\">searchTermsRow[&#8220;segments.search_subcategory&#8221;],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L159\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"159\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC159\" class=\"blob-code blob-code-inner js-file-line\">searchTermsRow[&#8220;segments.search_term&#8221;],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L160\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"160\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC160\" class=\"blob-code blob-code-inner js-file-line\">searchTermsRow[&#8220;metrics.conversions_value&#8221;].toFixed(<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L161\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"161\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC161\" class=\"blob-code blob-code-inner js-file-line\">2<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L162\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"162\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC162\" class=\"blob-code blob-code-inner js-file-line\">),<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L163\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"163\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC163\" class=\"blob-code blob-code-inner js-file-line\">searchTermsRow[&#8220;metrics.conversions&#8221;].toFixed(1),<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L164\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"164\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC164\" class=\"blob-code blob-code-inner js-file-line\">searchTermsRow[&#8220;metrics.clicks&#8221;],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L165\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"165\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC165\" class=\"blob-code blob-code-inner js-file-line\">searchTermsRow[&#8220;metrics.impressions&#8221;],<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L166\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"166\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC166\" class=\"blob-code blob-code-inner js-file-line\">existsAsKeyword, \/\/ New column indicating if the search term exists as a keyword<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L167\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"167\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC167\" class=\"blob-code blob-code-inner js-file-line\">]);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L168\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"168\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC168\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L169\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"169\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC169\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L170\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"170\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC170\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L171\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"171\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC171\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L172\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"172\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC172\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L173\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"173\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC173\" class=\"blob-code blob-code-inner js-file-line\">if (!spreadsheetUrl) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L174\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"174\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC174\" class=\"blob-code blob-code-inner js-file-line\">var ss = SpreadsheetApp.create(&#8220;PMax Search Terms&#8221;, 10000, 20);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L175\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"175\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC175\" class=\"blob-code blob-code-inner js-file-line\">var spreadsheetUrl = ss.getUrl();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L176\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"176\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC176\" class=\"blob-code blob-code-inner js-file-line\">} else {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L177\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"177\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC177\" class=\"blob-code blob-code-inner js-file-line\">var ss = SpreadsheetApp.openByUrl(spreadsheetUrl);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L178\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"178\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC178\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L179\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"179\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC179\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L180\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"180\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC180\" class=\"blob-code blob-code-inner js-file-line\">let categoriesSheet = ss.getSheetByName(&#8220;categories&#8221;)<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L181\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"181\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC181\" class=\"blob-code blob-code-inner js-file-line\">? ss.getSheetByName(&#8220;categories&#8221;).clear()<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L182\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"182\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC182\" class=\"blob-code blob-code-inner js-file-line\">: ss.insertSheet(&#8220;categories&#8221;);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L183\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"183\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC183\" class=\"blob-code blob-code-inner js-file-line\">if (allCategoryLabels.length &gt; 1) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L184\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"184\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC184\" class=\"blob-code blob-code-inner js-file-line\">\/\/ Check if there&#8217;s more than just the header row<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L185\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"185\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC185\" class=\"blob-code blob-code-inner js-file-line\">categoriesSheet<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L186\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"186\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC186\" class=\"blob-code blob-code-inner js-file-line\">.getRange(<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L187\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"187\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC187\" class=\"blob-code blob-code-inner js-file-line\">1,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L188\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"188\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC188\" class=\"blob-code blob-code-inner js-file-line\">1,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L189\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"189\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC189\" class=\"blob-code blob-code-inner js-file-line\">allCategoryLabels.length,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L190\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"190\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC190\" class=\"blob-code blob-code-inner js-file-line\">allCategoryLabels[0].length<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L191\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"191\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC191\" class=\"blob-code blob-code-inner js-file-line\">)<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L192\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"192\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC192\" class=\"blob-code blob-code-inner js-file-line\">.setValues(allCategoryLabels);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L193\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"193\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC193\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L194\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"194\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC194\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L195\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"195\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC195\" class=\"blob-code blob-code-inner js-file-line\">let termsSheet = ss.getSheetByName(&#8220;terms&#8221;)<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L196\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"196\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC196\" class=\"blob-code blob-code-inner js-file-line\">? ss.getSheetByName(&#8220;terms&#8221;).clear()<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L197\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"197\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC197\" class=\"blob-code blob-code-inner js-file-line\">: ss.insertSheet(&#8220;terms&#8221;);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L198\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"198\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC198\" class=\"blob-code blob-code-inner js-file-line\">if (allSearchTerms.length &gt; 1) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L199\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"199\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC199\" class=\"blob-code blob-code-inner js-file-line\">\/\/ Check if there&#8217;s more than just the header row<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L200\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"200\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC200\" class=\"blob-code blob-code-inner js-file-line\">termsSheet<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L201\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"201\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC201\" class=\"blob-code blob-code-inner js-file-line\">.getRange(1, 1, allSearchTerms.length, allSearchTerms[0].length)<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L202\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"202\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC202\" class=\"blob-code blob-code-inner js-file-line\">.setValues(allSearchTerms);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L203\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"203\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC203\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L204\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"204\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC204\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L205\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"205\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC205\" class=\"blob-code blob-code-inner js-file-line\">var subject = &#8220;PMax Search Terms Report Ready&#8221;;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L206\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"206\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC206\" class=\"blob-code blob-code-inner js-file-line\">var body =<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L207\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"207\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC207\" class=\"blob-code blob-code-inner js-file-line\">&#8220;The PMax Search Terms Report has been generated and is available at: &#8221; +<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L208\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"208\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC208\" class=\"blob-code blob-code-inner js-file-line\">spreadsheetUrl +<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L209\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"209\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC209\" class=\"blob-code blob-code-inner js-file-line\">&#8220;\\n\\nReport covers the last &#8221; +<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L210\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"210\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC210\" class=\"blob-code blob-code-inner js-file-line\">reportLastNDays +<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L211\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"211\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC211\" class=\"blob-code blob-code-inner js-file-line\">&#8221; days.&#8221; +<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L212\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"212\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC212\" class=\"blob-code blob-code-inner js-file-line\">&#8220;\\n\\nThis is an automated email sent by Google Ads Script.&#8221;;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L213\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"213\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC213\" class=\"blob-code blob-code-inner js-file-line\">} catch (e) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L214\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"214\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC214\" class=\"blob-code blob-code-inner js-file-line\">Logger.log(&#8220;Error: &#8221; + e.message);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L215\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"215\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC215\" class=\"blob-code blob-code-inner js-file-line\">var subject = &#8220;PMax Search Terms Report Failed&#8221;;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L216\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"216\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC216\" class=\"blob-code blob-code-inner js-file-line\">var body =<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L217\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"217\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC217\" class=\"blob-code blob-code-inner js-file-line\">&#8220;The PMax Search Terms Report encountered an error: &#8221; +<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L218\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"218\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC218\" class=\"blob-code blob-code-inner js-file-line\">e +<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L219\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"219\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC219\" class=\"blob-code blob-code-inner js-file-line\">&#8220;\\n\\nThis is an automated email sent by Google Ads Script.&#8221;;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L220\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"220\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC220\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L221\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"221\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC221\" class=\"blob-code blob-code-inner js-file-line\">Logger.log(&#8220;spreadsheet: &#8221; + spreadsheetUrl);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L222\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"222\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC222\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L223\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"223\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC223\" class=\"blob-code blob-code-inner js-file-line\">\/\/ Send the email<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L224\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"224\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC224\" class=\"blob-code blob-code-inner js-file-line\">var recipientEmail = EMAILADDRESS;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L225\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"225\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC225\" class=\"blob-code blob-code-inner js-file-line\">MailApp.sendEmail(recipientEmail, subject, body);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L226\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"226\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC226\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L227\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"227\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC227\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L228\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"228\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC228\" class=\"blob-code blob-code-inner js-file-line\">\/\/ function to get date range<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L229\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"229\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC229\" class=\"blob-code blob-code-inner js-file-line\">function getDateRange(numDays) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L230\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"230\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC230\" class=\"blob-code blob-code-inner js-file-line\">const endDate = new Date();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L231\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"231\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC231\" class=\"blob-code blob-code-inner js-file-line\">const startDate = new Date();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L232\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"232\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC232\" class=\"blob-code blob-code-inner js-file-line\">startDate.setDate(endDate.getDate() &#8211; numDays);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L233\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"233\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC233\" class=\"blob-code blob-code-inner js-file-line\">const format = (date) =&gt;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L234\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"234\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC234\" class=\"blob-code blob-code-inner js-file-line\">Utilities.formatDate(<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L235\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"235\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC235\" class=\"blob-code blob-code-inner js-file-line\">date,<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L236\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"236\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC236\" class=\"blob-code blob-code-inner js-file-line\">AdsApp.currentAccount().getTimeZone(),<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L237\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"237\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC237\" class=\"blob-code blob-code-inner js-file-line\">&#8220;yyyyMMdd&#8221;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L238\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"238\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC238\" class=\"blob-code blob-code-inner js-file-line\">);<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L239\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"239\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC239\" class=\"blob-code blob-code-inner js-file-line\">return `${format(startDate)} AND ${format(endDate)}`;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L240\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"240\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC240\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L241\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"241\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC241\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L242\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"242\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC242\" class=\"blob-code blob-code-inner js-file-line\">function getAllSearchCampaignKeywords() {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L243\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"243\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC243\" class=\"blob-code blob-code-inner js-file-line\">let keywordsList = {};<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L244\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"244\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC244\" class=\"blob-code blob-code-inner js-file-line\">let keywordIterator = AdsApp.keywords()<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L245\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"245\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC245\" class=\"blob-code blob-code-inner js-file-line\">.withCondition(&#8220;Status = ENABLED&#8221;)<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L246\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"246\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC246\" class=\"blob-code blob-code-inner js-file-line\">.withCondition(&#8220;CampaignStatus = ENABLED&#8221;)<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L247\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"247\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC247\" class=\"blob-code blob-code-inner js-file-line\">.withCondition(&#8220;AdGroupStatus = ENABLED&#8221;)<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L248\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"248\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC248\" class=\"blob-code blob-code-inner js-file-line\">.get();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L249\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"249\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC249\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L250\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"250\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC250\" class=\"blob-code blob-code-inner js-file-line\">while (keywordIterator.hasNext()) {<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L251\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"251\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC251\" class=\"blob-code blob-code-inner js-file-line\">let keyword = keywordIterator.next();<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L252\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"252\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC252\" class=\"blob-code blob-code-inner js-file-line\">let keywordText = keyword.getText().toLowerCase(); \/\/ Normalize keyword text for comparison<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L253\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"253\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC253\" class=\"blob-code blob-code-inner js-file-line\">keywordsList[keywordText] = true; \/\/ Use a map for efficient lookup<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L254\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"254\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC254\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L255\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"255\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC255\" class=\"blob-code blob-code-inner js-file-line\"><\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L256\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"256\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC256\" class=\"blob-code blob-code-inner js-file-line\">return keywordsList;<\/td>\n<\/tr>\n<tr>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-L257\" class=\"blob-num js-line-number js-blob-rnum\" data-line-number=\"257\"><\/td>\n<td id=\"file-pmax-search-terms-and-categories-in-a-spreadsheet-LC257\" class=\"blob-code blob-code-inner js-file-line\">}<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"gist-meta\"><a class=\"Link--inTextBlock\" href=\"https:\/\/gist.github.com\/siliconvallaeys\/a579409e0f94d8269744d6460b9cb466\/raw\/de008dcbdbd1552e6ce17201295ffd41c1e44073\/PMax%20Search%20Terms%20and%20Categories%20in%20a%20Spreadsheet\">view raw<\/a><a class=\"Link--inTextBlock\" href=\"https:\/\/gist.github.com\/siliconvallaeys\/a579409e0f94d8269744d6460b9cb466#file-pmax-search-terms-and-categories-in-a-spreadsheet\">PMax Search Terms and Categories in a Spreadsheet\u00a0<\/a>hosted with \u2764 by\u00a0<a class=\"Link--inTextBlock\" href=\"https:\/\/github.com\/\">GitHub<\/a><\/div>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<h2 id=\"h-using-performance-max-search-terms-to-boost-ppc-results\" class=\"wp-block-heading\"><span>\u4f7f\u7528 Performance Max \u641c\u7d22\u8bcd\u6765\u63d0\u5347 PPC \u7ed3\u679c<\/span><\/h2>\n<p><span>Performance Max \u641c\u7d22\u8bcd\u53ef\u89c1\u5ea6\u7684\u53d1\u5e03\u5df2\u7ecf\u915d\u917f\u5df2\u4e45\u3002\u8fd9\u4e9b\u6570\u636e\u6700\u7ec8\u8d4b\u4e88 PPC \u5e7f\u544a\u4e3b\u5bf9\u81ea\u52a8\u5316\u5e7f\u544a\u7cfb\u5217\u66f4\u591a\u7684\u63a7\u5236\u548c\u4f18\u5316\u80fd\u529b\u3002<\/span><\/p>\n<p><span>\u4f5c\u4e3a PPC \u4e13\u5bb6\uff0c\u8bf7\u52a1\u5fc5\u7acb\u5373\u5229\u7528\u8fd9\u4e00\u65b0\u529f\u80fd\u3002\u6309\u7167\u6211\u4eec\u7684\u6307\u5bfc\u8bbf\u95ee\u548c\u5206\u6790\u6570\u636e\uff0c\u7136\u540e\u6839\u636e\u6240\u83b7\u7684\u89c1\u89e3\u91c7\u53d6\u884c\u52a8\u3002\u968f\u7740\u65f6\u95f4\u7684\u63a8\u79fb\uff0c\u60a8\u5c06\u66f4\u6e05\u695a\u5730\u4e86\u89e3\u60a8\u7684 Performance Max \u5e7f\u544a\u8986\u76d6\u4e86\u54ea\u4e9b\u4eba\uff0c\u4ee5\u53ca\u5982\u4f55\u6539\u8fdb\u60a8\u7684\u4fe1\u606f\u4ee5\u5f15\u8d77\u53d7\u4f17\u7684\u5171\u9e23\u3002<\/span><\/p>\n<p><span>\u5176\u7ed3\u679c\u662f\uff0c\u5e7f\u544a\u5c06\u66f4\u5177\u76f8\u5173\u6027\u3001\u6210\u672c\u66f4\u4f4e\uff0c\u800c\u4e14\u6700\u91cd\u8981\u7684\u662f\uff0c\u60a8\u7684\u6548\u679c\u6700\u5927\u5316\u5e7f\u544a\u7cfb\u5217\u5c06\u5e26\u6765\u66f4\u591a\u7684\u8f6c\u5316\u3002<\/span><\/p>\n<p><em><strong><span>\u4f5c\u8005\u9644\u8a00\uff1a<\/span><\/strong><span>\u4e0e\u6240\u6709\u811a\u672c\u4e00\u6837\uff0c\u4e00\u4e9b\u7528\u6237\u62a5\u544a\u4e86\u9519\u8bef\u3002\u6211\u77e5\u9053\u5f53\u5355\u4e2a\u641c\u7d22\u4e3b\u9898\u4e0d\u8fd4\u56de\u4efb\u4f55\u641c\u7d22\u8bcd\u6570\u636e\u65f6\u4f1a\u51fa\u73b0\u9519\u8bef\uff0c\u5e76\u4e14\u6211\u5df2\u4fee\u6539\u5df2\u53d1\u5e03\u7684\u811a\u672c\u4ee5\u6539\u8fdb\u5176\u5904\u7406\u6b64\u7c7b\u9519\u8bef\u7684\u65b9\u5f0f\u3002\u8bf7\u5728\u00a0<\/span><a href=\"https:\/\/gist.github.com\/siliconvallaeys\/a579409e0f94d8269744d6460b9cb466\" target=\"_blank\" rel=\"noopener\"><span>GitHub<\/span><\/a><span>\u4e0a\u7559\u4e0b\u60a8\u5bf9\u6b64\u811a\u672c\u95ee\u9898\u7684\u8bc4\u8bba\u00a0\uff0c\u4ee5\u4fbf\u6211\u5c3d\u529b\u5e2e\u52a9\u60a8\u3002\u201d<\/span><\/em><\/p>\n<\/div>\n<hr \/>\n<p><em><span>\u6211\u4eec\u9080\u8bf7\u6295\u7a3f\u4f5c\u8005\u4e3a Search Engine Land \u64b0\u5199\u5185\u5bb9\uff0c\u5e76\u6839\u636e\u4ed6\u4eec\u7684\u4e13\u4e1a\u77e5\u8bc6\u548c\u5bf9\u641c\u7d22\u793e\u533a\u7684\u8d21\u732e\u8fdb\u884c\u9009\u62e9\u3002\u6211\u4eec\u7684\u6295\u7a3f\u8005\u5728\u7f16\u8f91\u4eba\u5458\u7684\u76d1\u7763\u4e0b\u5de5\u4f5c<\/span><a href=\"https:\/\/searchengineland.com\/staff\/\"><span>\uff0c<\/span><\/a><span>\u5e76\u68c0\u67e5\u6295\u7a3f\u7684\u8d28\u91cf\u548c\u4e0e\u8bfb\u8005\u7684\u76f8\u5173\u6027\u3002\u4ed6\u4eec\u8868\u8fbe\u7684\u89c2\u70b9\u662f\u4ed6\u4eec\u81ea\u5df1\u7684\u3002<\/span><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6548\u679c\u6700\u5927\u5316\u5e7f\u544a\u7cfb\u5217\u56e0\u5176\u81ea\u52a8\u5316\u548c\u7b80\u4fbf\u6027\u800c\u5728PPC\u5e7f\u544a\u5ba2\u6237\u4e2d\u5e7f\u53d7\u6b22\u8fce\u3002\u7136\u800c\uff0c\u4e00\u4e2a\u6301\u7eed\u5b58\u5728\u7684\u75db\u70b9\u662f\u7f3a\u4e4f\u5bf9\u89e6\u53d1\u5e7f\u544a\u7684\u641c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1512","post","type-post","status-publish","format-standard","hentry","category-ppc"],"_links":{"self":[{"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1512"}],"version-history":[{"count":2,"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1512\/revisions"}],"predecessor-version":[{"id":3038,"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1512\/revisions\/3038"}],"wp:attachment":[{"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.buygoogle.cc\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}