Query report - Automate.ax

Use googleAds.queryReport to run one page of a Google Ads Query Language report.

Example

import { automation, onDashboardRun } from "automate.ax"
import { googleAds } from "automate.ax/google-ads"

export default automation("Query report", () => {
  onDashboardRun({ title: "Query report" })

  googleAds.queryReport({
    customerId: "1234567890",
    query:
      "SELECT campaign.id, metrics.clicks FROM campaign WHERE segments.date DURING LAST_30_DAYS",
  })
})

Inputs

Set customerId and a GAQL query. Pass nextPageToken with the identical query to continue. Google fixes search pages at 10,000 rows. All customer-scoped actions accept optional loginCustomerId for manager-account access and a named Google account binding.

Output

Returns raw camelCase GAQL rows, pagination metadata, field mask, and optional summary row.