Manage Ad Exchange system queries

To make it easier to generate a basic report, use the canned (system) reports option. With a single click, you can run common reports to access most of your data. When you use a pre-defined report, you also have the option to fully customize the report template to meet your needs. You can make your queries as simple or complex as you want.

This list page provides quick access to some basic system query tasks and displays vital system query information in the form of sortable columns:

  • Name (Name and description of the system query)
    Did you know that when you mouse over the system query name you can see the specific settings of the query?
  • Creation date (Date of system query creation and time stamp)  
  • Last run (Date and time stamp of the last successful query run)
  • RUN NOW link (Immediately run the query)

From the system queries list page, you can perform the following tasks:

Run a system query
If you access this feature from DFP instead of Ad Exchange, select the AdX Query Tool tab and continue with the steps.
  1. From the left sidebar, click System queries.
  2. Locate the query name.
  3. To run the system query, click RUN NOW

(Optional) If you decide to make an adjustment to the report, be aware that you can ONLY edit the date range.

  1. From the left sidebar, click System queries.
  2. Click the query name
  3. Click the date range edit link.
  4. Select your predefined or custom date range.
  5. Click Apply.
  6. (Optional) From the Run report drop-down (bottom of the page), you can preview the report layout before you run the report.
  7. Click Run report
Copy a system query
If you access this feature from DFP instead of Ad Exchange, select the AdX Query Tool tab and continue with the steps.

To customize a system query with your requisites, from the system queries list page:

  1. Select the system query you want to adjust. You can only select to clone one query at a time.
  2. Click Copy to My queriesThe query is saved into the My queries collection.
  3. Update your dimensions and metrics.
    System queries--dimensions and metrics--cannot be edited or deleted.
  4. (Optional) Schedule recurring queries.
  5. To complete the process, you have four drop-down options:

The copied query is listed in the “My queries” section. The date displayed in the cloned query is the date it was added to the system.

Did you know that you can set a default query from the System queries screen? Select any of the predefined queries and click Copy to My queries. Edit the query, if needed, and save. Select the query from the My queries screen and click Default query. This automatically sets the query to run EACH time the Query Tool is accessed.
For more information, watch this video: System Queries (1:55)
Was this article helpful?
How can we improve it?