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.

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.

Log in to your Ad Exchange account
Go to Performance Reports
On the left sidebar, click “Query Tool Beta”
You will be redirected to another page and you will be presented with a list of queries.
Select one query that you want to copy since you are only allowed to copy one query at a time.
Click the “Make a Copy” button
Update the dimensions and metrics and also the Schedule recurring queries (optional).
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:

Log in to your Ad Exchange account
Go to your “Performance Reports”
Click Query Tool Beta
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.
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:

Log in to your Ad exchange account
Go to “Performance Reports”
Click “Query Tool Beta”
On the query list page, select the best query for you to set as your default.
Click the “set as default query” button. Every time you log in, this default query will automatically run.
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:

Kean Graham

Kean Graham is the CEO and founder of MonetizeMore & a pioneer in the Adtech Industry. He is the resident expert in Ad Optimization, covering areas like Adsense Optimization,GAM Management, and third-party ad network partnerships. Kean believes in the supremacy of direct publisher deals and holistic optimization as keys to effective and consistent ad revenue increases.