Create or edit a query
Define your query
As you set up your query, you must define some basic query information that will prove to be helpful as you build your queries. The query should be assigned a meaningful name to make it easier to identify your query in your list of my queries.
When you add a full description, it enables you to provide a richer definition to the query or include other relevant facts, such as the intended use of the report. You can select your desired date range from preset dates or fixed dates and select dimension filters to further define your query.
Once all of those factors have been chosen, you can begin to build the dimensions and metrics that make up the data of your query.
To create a new query:
- Click on the Query Tool tab.
- Click New query. The "New query" page loads.
Select your report settings
- Enter a meaningful name (maximum of 128 characters).
- (Optional) Enter a description that explains the query’s purpose (maximum of 255 characters).
- To select a date range, click edit.
- Select from a list of "predefined" date ranges (dates on a sliding scale) or "custom" date ranges (fixed dates.) Click Apply.
To view performance comparisons between two specific dates, use the date range comparison feature.
Predefined dates: Reports that use relative dates have rolling results. In other words, if you have a query that generates a report on September 7th with a relative date filter of last 7 days, the report has a start date of September 1st through September 7th. Predefined date ranges always include the current date.
- Last 7 days--(default) To keep the data current, all data is generated using the previous day’s (at least 24 hours) information. If no end date is entered, the query will use the date the query was created.
- Last 30 days
- This month
- Last month
- This quarter
- Last quarter
- This year
- Last year
Custom dates: Use the calendar widgets to select the start and end dates for your query.If you need to generate reports on a recurring basis, choose predefined dates rather than custom dates.
- From the report currency drop-down, select the local currency in which you'd like your report to be displayed. If you view reporting data in a different currency, the currency in which you are paid in is not affected. In other words, a report viewed in another currency does not change the currency associated with your Authorized Buyers account.
Currency data uses the previous day's exchange rates, so there may be some minor discrepancies due to fluctuations in exchange rates.
- Select to include or exclude report data with zero amounts.
- (Optional) To refine your report data, use the filtering options.
- To customize your query, you have the opportunity to select dimensions and metrics. To help you start your query, the "Ad impressions" metric is selected, by default.
- Select whether your report table structure is hierarchical or flat.
- To complete the process, you have four drop-down options: