Google launches marketer-friendly Google Ads API query builder
The interface makes it easy to build queries for reporting.
What it does. The API uses the new Google Ads Query Language to return results for account resources and metrics.”The language’s syntax allows you to select from all the resources that are available for reporting, and also filter or sort the result set on the server before they are returned to your application,” explained Cory Liseno on the Google Ads API Team.
How it works. Select the “resource” such as campaign, ad group, bid modifier, label, etc., then choose any of the fields and metrics that relate to the resource. You can then apply filters and sorting to the query.
You can then select the query text generated at the bottom of the window and copy and paste that right into the application you’re using.
Why you should care. The Query Builder resides on the Google Ads API Developer site, but you don’t have to be a developer to use it. With the intuitive interface, you don’t have to know how to format queries in the query language to get the reporting you’re looking for. Just about anyone on the team will be able to quickly build reporting queries and either execute them themselves or pass along the proper syntax to their developers.