How to Use the Ad Exchange Query Tool

Ad Exchange Ad Optimization
Last updated: September 5, 2019 | by Kean Graham

This post was most recently updated on September 5th, 2019

Each ad network has its own way of presenting their reports and as for the biggest player in this industry, Ad exchange has its own unique reporting system. But before you generate reports you’ll first start with your queries, this is where Ad Exchange query comes in.

Related Read: How to Define a Query with the Ad Exchange Tool

What is the Ad Exchange query tool and how can this help publishers?

This is a tool used by Ad Exchange users to generate reports. This is where you input data such as dates, filter values, metrics, dimensions and etc. Accomplishing such queries will result in a tangible report that you can see on your dashboard or can be exported as a CSV file.

Publishers have all the control on this query tool – from viewing each and every performance metric weekly or daily, to automating the report and generating it into a CSV format. It also allows a preview of the reports which allows you to quickly check them even without running the query.

Related Read: What is the New Ad Exchange Query Tool?

How to manage your query:

If it is your first time creating a query, you will see a “No Queries Found” once you enter the Ad exchange query tool. However, the previous query you made will be automatically saved and will appear every time you log in to the query tool. The queries made will include some vital information such as Name of query and description, creation date, last run, and Run Now link to run the query.

How to copy a query:

Copying a query is as easy as creating it, you just have to tweak something to successfully create a copy of your query.

  1. Log in to your Ad Exchange account
  2. Go to Performance Reports
  3. On the left sidebar, click “Query Tool Beta”
  4. You will be redirected to another page and you will be presented with a list of queries.
  5. Select one query that you want to copy since you are only allowed to copy one query at a time.
  6. Click the “Make a Copy” button
  7. Update the dimensions and metrics and also the Schedule recurring queries (optional).
  8. Before completing your query, you have to choose one of the four options below:
    • Run your report
    • Save your query and run the report
    • Save query but don’t run the report
    • Preview report layout

How to delete a query:

You can also delete your query in a snap:

  1. Log in to your Ad Exchange account
  2. Go to your “Performance Reports”
  3. Click Query Tool Beta
  4. Click the checkbox of the query that you want to delete from the list of queries presented to you. You can also select all by clicking the checkbox at the top of the list.
  5. Click “Delete Queries” button.

How to set a default query:

Setting a default query is like setting it on autopilot. Once you log in to your query, it will automatically run but you can only have one default query at a time. you just have to figure out what query works best for you.

How to create a default query:

  1. Log in to your Ad exchange account
  2. Go to “Performance Reports”
  3. Click “Query Tool Beta”
  4. On the query list page, select the best query for you to set as your default.
  5. Click the “set as default query” button. Every time you log in, this default query will automatically run.
  6. To remove the default query, click the “Remove as Default Query” button

To learn more about ad exchange and query tool, contact us anytime and we are more than willing to help you.

Sign-up for a FREE application to Ad Exchange – the premium version of Adsense.

Related Reads:

More than 1500 publishers see 50-400% ad revenue growth with us.

Don't just take our word for it


Paid to Publishers


Ad Requests Monthly


Happy Publishers

Recommended Reading

April 19, 2024

Navigating the Online Real Estate Marketplace: 8 Tips for Monetized Publishers

Read More
April 17, 2024

ViewBotting: How Bad Bots Affect Publishers?

Read More
Ad Network Reviews, Tips & Guides
April 16, 2024

2024’s Best Video Ad Networks

Read More

Trusted by 1,500+ publishers worldwide

10X your ad revenue with our award-winning solutions.

Let's Talk


Ready to 10X your ad revenue with the #1 ad management partner?

Start Now