AQX allows you to drilldown on top level report results to view figures in detail. (e.g. look at the individual spot level that make up that figure etc) You can drilldown on any figure in a report in AQX including Totals and Grand Totals.
In AQX when you double click on a figure in a cell it will open a drilldown screen that contains four drilldown tabs - each displaying the information in a different format.
You can also highlight certain areas within these drilldowns and create another 'Ad Hoc summary drilldown' based on that information only.
The Options button in the slider bar will allow users to specify what they see in that particular drilldown tab.
The four basic drilldown tabs available when you initially double click on a cell in an AQX report are:
- Summary drilldown - Summarises the spots for that figure by outlet. Shows the summarised expenditure, volume & incidence. See Summary Drilldown for more information.
- Detail Drilldown - lists all the spots that make up that figure in detail. The exact detail differs dependent upon the media type shown and will differ from country to country. If your country and/or data entitlements allow - you can also view Creative in this drilldown. See Detail Drilldown for more information.
- Analysis drilldown - Gives a number of different analyses of the information dependent on media type. Includes Overview, Position In Break (PIB) Analysis, Breakout Analysis. See Analysis Drilldown for more information
- R&F drilldown - If your AQX has Reach & Frequency (R&F) engines for various media types attached - you will also be able to run R&F analyses of the data. See R&F Drilldown for more information
On top of these drilldowns - you can create Ad Hoc Summary drilldowns from within the Detailed Drilldown screen. For instance you might want a summary of the days used, or the products involved etc. See Ad Hoc Summary Drilldowns from Detailed Drilldowns below for more information
Once you have processed a report containing the information you require, select the cell you want by either
- Double clicking on the cell -OR-
- Right click on the cell & select Drilldown from the menu
This will open a Drilldown tab beside the Layout tab and will initially show the Detailed drilldown tab contained within.
If your drilldown contains more than one Media Type you can swap between them by selecting the media you want in the Slider bar at the Options button that has opened.
If you want to move to one of the other drilldown options (Summary, Analysis or R&F) click on the appropriate tab. (See image above)
Once you have processed a report you can select multiple cells to drilldown on by either:
- Dragging your mouse over the cells you wish to select -OR-
- Using your Shift Key and mouse to highlight multiple cells -OR-
- Use your Control (Ctrl) Key and mouse to highlight individual multiple cells
In ALL the cases above once you have highlighted the cells required please right click on one of the highlighted cells and select Drilldown from the menu.
This will open a Drilldown tab beside the layout tab and will initially show the Detailed drilldown tab contained within.
If your drilldown contains more than one Media Type you can swap between them by selecting the media you want in the Slider bar at the Options button that has opened.
If you want to move to one of the other drilldown options (Summary, Analysis or R&F) click on the appropriate tab. (See image above)
Ad Hoc Summary drilldowns from Detail Drilldowns
When you are in a Detailed Drilldown you can create an Ad Hoc Summary drilldown on any field. For instance - you may want a summary of the days in the drilldown, or the products used etc. See Creating an Ad Hoc Summary Drilldown for more information