หากต้องการพูดคุยและแสดงความคิดเห็นเกี่ยวกับผลิตภัณฑ์ของเรา โปรดเข้าร่วมช่อง Discord อย่างเป็นทางการของ Google Ads ในเซิร์ฟเวอร์ชุมชนการโฆษณาและการวัดผลของ Google
[null,null,["อัปเดตล่าสุด 2025-08-27 UTC"],[[["\u003cp\u003eGoogle Ads scripts reporting uses GAQL to specify the data you want to retrieve, allowing you to access information about various resources like campaigns and ad groups.\u003c/p\u003e\n"],["\u003cp\u003eThere are two primary reporting methods: \u003ccode\u003eAdsApp.report()\u003c/code\u003e, which provides a flat, dictionary-like output suitable for spreadsheets, and \u003ccode\u003eAdsApp.search()\u003c/code\u003e, which returns \u003ccode\u003eGoogleAdsRow\u003c/code\u003e objects for programmatic processing.\u003c/p\u003e\n"],["\u003cp\u003eBoth \u003ccode\u003eAdsApp.report()\u003c/code\u003e and \u003ccode\u003eAdsApp.search()\u003c/code\u003e accept the same GAQL queries but differ in how they present the results, with some fields potentially exclusive to one method.\u003c/p\u003e\n"],["\u003cp\u003eWhile \u003ccode\u003eAdsApp.report()\u003c/code\u003e uses dictionary-like access (e.g., \u003ccode\u003erow["campaign.id"]\u003c/code\u003e), \u003ccode\u003eAdsApp.search()\u003c/code\u003e leverages object properties (e.g., \u003ccode\u003erow.campaign.id\u003c/code\u003e) and uses \u003ccode\u003elowerCamelCase\u003c/code\u003e for field names regardless of the query's casing.\u003c/p\u003e\n"]]],[],null,["# Reporting\n\nReports provide information about all the different resources in your account.\nYou can fetch information about campaigns, ad groups, and their stats, change\nhistory for your account, and more. The reporting infrastructure is backed by\nthe Google Ads API and uses [GAQL](/google-ads/api/docs/query/overview) to specify\nwhat fields, metrics, and conditions you want to set.\n\nReport vs. search\n-----------------\n\nThere are two main mechanisms for reporting. They both accept the same kinds of\nqueries, and differ primarily in how they return the results.\n\nFor both cases, we will use the following query: \n\n SELECT\n campaign.id,\n campaign.status,\n metrics.clicks,\n metrics.impressions,\n customer.id\n FROM campaign\n WHERE\n metrics.impressions \u003e 0\n\n`AdsApp.report()`\n: This will return a flat, dictionary-like representation of your search\n results. You can access fields as if using a dictionary, such as\n `row[\"campaign.id\"]` and `row[\"metrics.impressions\"]` directly. By using this\n format, you can export the results directly to a spreadsheet using the\n `exportToSheet()` method. This is not the native format that results are\n returned in by the Google Ads API, so in some cases some fields may not be available\n in this format. If that is the case, you should use `search` instead.\n\n`AdsApp.search()`\n: This will return a list of `GoogleAdsRow` objects, which have various fields,\n each of which may have sub-fields. So you would access `row.campaign.id` and\n `row.metrics.impressions` to fetch the data. This is generally more useful if\n you plan to process the data programmatically, and some fields may only be\n available in the `search` format if they cannot be converted to a flat\n representation.\n| **Note:** When using `AdsApp.search`, the fields returned will be in `lowerCamelCase` even though they are specified in `underscore_case` in the query. For example, if your field in the query is `campaign.start_date`, then to fetch the result from the row, you would use `campaign.startDate`.\n\nReport Example\n--------------\n\n let report = AdsApp.report(\n \"SELECT \" +\n \" ad_group.id, search_term_view.search_term, metrics.ctr, metrics.cost_micros, metrics.impressions \" +\n \"FROM search_term_view \" +\n \"WHERE metrics.impressions \u003c 10 AND segments.date DURING LAST_30_DAYS\");\n\n let rows = report.rows();\n while (rows.hasNext()) {\n let row = rows.next();\n let query = row[\"search_term_view.search_term\"];\n let impressions = row[\"metrics.impressions\"];\n }\n\nTake a look at the\n[`AdsApp.report`](/google-ads/scripts/docs/reference/adsapp/adsapp#report_query-optArgs)\ndocumentation for full details on using this view.\n\nSearch Example\n--------------\n\n let search = AdsApp.search(\n \"SELECT \" +\n \" ad_group.id, search_term_view.search_term, metrics.ctr, metrics.cost_micros, metrics.impressions \" +\n \"FROM search_term_view \" +\n \"WHERE metrics.impressions \u003c 10 AND segments.date DURING LAST_30_DAYS\");\n\n while (search.hasNext()) {\n let row = search.next();\n let query = row.searchTermView.searchTerm;\n let impressions = row.metrics.impressions;\n }\n\nConsult the full\n[`Adsapp.search`](/google-ads/scripts/docs/reference/adsapp/adsapp#search_query-optArgs)\ndocumentation for all possible settings."]]
