How to Customize Ad Exchange Reports with System Queries

Ad Exchange Ad Optimization
Last updated: August 21, 2019 | by Kean Graham

This post was most recently updated on August 21st, 2019

How to Customize Ad Exchange Reports with System QueriesSystem Queries menu contains the canned reports in Google Ad Exchange. Pre-defined reports are fully customizable to meet your needs. You have the option to make your queries as complex or as simple depending on your preference.

System queries page is your gateway to quickly access some of the basic system query tasks and has the vital query information handy in the form of sortable columns:

 Related Read: How to Define a Query

  1. Name – name, and description of the query
  2. Creation date – the date the query was created and time stamp
  3. Last run – latest date and time the query was successfully ran
  4. RUN NOW – a clickable link to run the query immediately

How to Run System Queries:

  1. Once logged in to Ad Exchange, click “System Queries” from the left sidebar.
  2. When you hover your mouse over the query name, a popup screen will show you the data that query will provide.
  3. Click the query name
  4. Click ‘Edit” for the date range
  5. Select desired date range
  6. Click “Apply”
  7. (Optional) At the bottom of the page, you may click the drop-down button right next to “Run Report” and you may preview the report layout. After checking the preview, click the drop-down again to Run Report.
  8. Click “Run Report”

How to customize Reports with System Queries:

You cannot customize the report while in System Queries page. In order to adjust the report based on your needs, you will have to clone it and do the editing in “My Queries” page. Click “Copy to My Queries” button either by going inside a certain report or choosing one from the list page. You may only clone one query at a time.

Related Read: How to Use the Ad Exchange Query Tool

  1. Go to “My Queries” page to access the System Query you just cloned.
  2. Click the report name
  3. Give it a name
  4. Place a short description (optional)
  5. Edit the date range
  6. (Optional) Add dimension filters to limit the results of your query (e.g. set Cost Type to “CPM” and Branding Type to “Anonymous”). You can add a maximum of 8 dimensions to a single query.
  7. Specify report dimensions (time measurement, categories, buyers data, yield management categories that define the rows and columns in your report, by which you can view and sort data). The order by which you enter dimensions determines the grouping.
    1. Locate the report dimension you want to add
    2. Click >> to add dimension. Selected options will appear on the right. Once selected, it turns gray. You may click-hold-drag dimensions to rearrange their order.
    3. To remove a selection, click “x” to the right of the dimension box.
  8. Customize report metrics (data returned by the report). You may select up to 12 metrics to a single query.
  9. Schedule reporting.
    1. Select “Do not schedule reports” to run the report immediately.
    2. Select “Schedule reports” for Ad Exchange to automatically send reports via email. Select frequency (daily, weekly or monthly) and people to share it with (the individuals must be associated to your Ad Exchange account, in other words, they MUST HAVE login access to your Ad Exchange account. These individuals have the option to unsubscribe at any time from the email.)
  10. Click the drop-down button right next to “Run Report” and you’ll have 3 options:
    1. Save the query and run the report
    2. Save query
    3. Preview report layout

MonetizeMore helps publishers transition to Ad Exchange – the premium version of Adsense. If you would like to get into the exclusive Doubleclick Ad Exchange, sign-up here.


Related Reads:

Ad Ops Tips & Guides, Industry News, Latest Tech and Success Stories - right in your inbox.

We are committed to protecting you Privacy Data

Here’s the course that 300+ pubs used to scale their ad revenue.

Enroll today

Book Banner

Recommended Reading

how-ad-blockers-work
Ad Blocking
November 25, 2022

Simple Strategies For Publishers To Combat Ad Blockers

Read More
best-mobile-ad-sizes
Mobile Ad Optimization
November 24, 2022

Best Mobile Ad Sizes to implement in 2023 [Don’t miss out]

Read More
what-is-ads-txt-1.1
AdTech Industry Definitions
November 22, 2022

Ads.txt 1.1 Publisher Manual: Best Guide To Implementation

Read More
Close

Enjoying this post? Let's put things to action

Get started