How to Use the Ad Exchange Query Tool

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:

Kean Graham

CEO and Founder at MonetizeMore

Kean has been a pioneer in the AdTech world since 2010 who believes in the supremacy of direct publisher deals, programmatic advertising, and building ad technology as keys to scaling ad revenue. Here, he provides publisher resources and guides covering areas like website monetization, AdSense optimization, Google Ad Manager, Ad Exchanges, and much more.

Get our latest ad optimization tips delivered to your inbox

Fill out my online form.

Submit a Comment

Your email address will not be published.