Stay organized with collections
Save and categorize content based on your preferences.
Reports provide information about all the different resources in your account.
You can fetch information about campaigns, ad groups, and their stats, change
history for your account, and more. The reporting infrastructure is backed by
the Google Ads API and uses GAQL to specify
what fields, metrics, and conditions you want to set.
Report vs. search
There are two main mechanisms for reporting. They both accept the same kinds of
queries, and differ primarily in how they return the results.
This will return a flat, dictionary-like representation of your search
results. You can access fields as if using a dictionary, such as
row["campaign.id"] and row["metrics.impressions"] directly. By using this
format, you can export the results directly to a spreadsheet using the
exportToSheet() method. This is not the native format that results are
returned in by the Google Ads API, so in some cases some fields may not be available
in this format. If that is the case, you should use search instead.
AdsApp.search()
This will return a list of GoogleAdsRow objects, which have various fields,
each of which may have sub-fields. So you would access row.campaign.id and
row.metrics.impressions to fetch the data. This is generally more useful if
you plan to process the data programmatically, and some fields may only be
available in the search format if they cannot be converted to a flat
representation.
Report Example
letreport=AdsApp.report("SELECT "+" ad_group.id, search_term_view.search_term, metrics.ctr, metrics.cost_micros, metrics.impressions "+"FROM search_term_view "+"WHERE metrics.impressions < 10 AND segments.date DURING LAST_30_DAYS");letrows=report.rows();while(rows.hasNext()){letrow=rows.next();letquery=row["search_term_view.search_term"];letimpressions=row["metrics.impressions"];}
Take a look at the
AdsApp.report
documentation for full details on using this view.
Search Example
letsearch=AdsApp.search("SELECT "+" ad_group.id, search_term_view.search_term, metrics.ctr, metrics.cost_micros, metrics.impressions "+"FROM search_term_view "+"WHERE metrics.impressions < 10 AND segments.date DURING LAST_30_DAYS");while(search.hasNext()){letrow=search.next();letquery=row.searchTermView.searchTerm;letimpressions=row.metrics.impressions;}
Consult the full
Adsapp.search
documentation for all possible settings.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-20 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,["Reports 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\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 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_2)\ndocumentation for full details on using this view.\n\nSearch Example \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_2)\ndocumentation for all possible settings."]]