Create a query

Define the parameters for your report

View related Skillshop training course

How to create a query

  1. Sign in to Google Ad Manager.
  2. Click Reports and then Queries.
  3. Click New query.
  4. Enter a meaningful query name. 
  5. Choose the report type you need:
    • Historical
      View data on clicks, revenue, click-through rate, and total impressions for dates in the past.
    • Ad Exchange historical
      Create and run your Ad Exchange reports from within the Ad Manager reporting tool.
    • Future sell-through
      View data on sell-through rate (STR) and forecasted, available, and reserved impressions for dates in the future.
    • Reach
      View the estimated number of unique visitors exposed to different advertisers, orders, line items, or ad units in your network over a given time period.
    • Data protection (Deprecated)  
      View data on cookies that are detected for each creative added to Ad Manager, broken down by advertiser, order, line item, creative, and the specific technology vendor from which the cookie originated.
    • Sales
      Run reports for Sales management. Sales management must be enabled in your network to see this report type.
    • Partner finance
      This report type only applies to Track assignments and reflects host-partner revenue splits based on advanced financial configuration.
  6. Select the appropriate time zone (only applies to some report types).

    If you've chosen the Ad Exchange historical report type, decide whether or not to use the default Ad Manager network time zone for your report output. If deselected, Pacific Standard Time (PST) is used.

  7. Choose a date range from a preset list of options.

    Select whether you want a Dynamic or Fixed date range type. A "day" in a given report is defined as midnight to midnight in the query's selected timezone. The actual dates used are available in the output of the report. If you select "Last 3 years" or a similar dynamic date range, the current day's data is not included in the report.

    Limit the date range of your reports
    A broad date range selection, such as the dynamic date range of Last 3 years, may unfavorably impact your report performance. We strongly recommend that you choose a specific date range whenever possible.
  8. (Optional) Click Add new filter to refine your report data and include only items you specify.
  9. Choose which data to display in your report by including report dimensions and metrics, and select a report table structure.

    There is a hard maximum of 10 dimensions. Use the "Recently Used" category to view those you most frequently select. Mouse over dimension or metric names to see a definition.

  10. (optional) Choose whether to schedule your query and share results. Only queries with a date range less than 1 year can be scheduled.
  11. (optional) Add other users able to edit your query settings. 
  12. Save and run your query.
    • If you want to run the report later, click Save and give the report a meaningful name. If scheduled, your query will run according to the schedule you've defined. Otherwise, you can come back to run or edit this query in the future.
    • If you want to generate it now, click Run. An Estimated completion time displays to advise on the length of time it will take to complete the report. After your report has loaded, you can edit the report inline, send the report, or export the report.

Find your queries

  1. Sign in to Google Ad Manager.
  2. Click Reports and then Queries.
  3. Click All queries to see queries you own, as well as those shared with you.

Copy or delete a query

  1. Sign in to Google Ad Manager.
  2. Click Reports and then Queries.
  3. Mark the checkbox next to one or more queries.
  4. Click Copy to copy the query, or click Delete to delete the query.
Was this helpful?
How can we improve it?