How to Use the Ad Exchange Query Tool

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:

• How to Register to Doubleclick Ad Exchange
• What is the New Ad Exchange Query Tool
• How to Define a Query with the Ad Exchange Query Tool
• Setting up a 100% Fill Ad Network Behind Ad Exchange

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.