To provide a visualization of key data points in the Query Tool, use the charting option. Charts allow you to quickly gain a high-level understanding of your advertising performance. These graphs also represent multiple data elements and identify their trends over time. A chart shows an increasing, decreasing, fluctuating, or remaining "constant rate of change" off of a single base dimension (the first dimension selected in your query.)
Each data element in a line chart is represented by a distinct colored line. Metrics represent the values that you're measuring. For example, you can measure your account performance by looking at your revenue, number of clicks and so on.
Choose metrics for your report
- To display your report results as a chart, click Show trends, above the scorecard. When "Show trends" is activated, the report expands to display the line graph section. When "Hide trends" is activated, the report collapses to conceal the line graph section.
- (Optional) If you prefer to always have the chart in view, click the down arrow to the right of "Show trends" and select Always show charts. The next time you run your query, the chart automatically displays.
- (Optional) After you’ve selected to show trends, you have the option to change the unit of time in the chart. Choose Days, Weeks, or Months. This time unit choice changes the X-axis to match.
If you chose any of the time unit dimensions when defining your query, the dimension is automatically selected.
- Mouse over a metric in the scorecard and click to select. The colored box to the left of the metric becomes fixed, and the graph updates to display the metric in the same color.
A maximum of two metrics can be chosen at any one time; all other metrics are then no longer available for selection. To deselect a metric, simply click the metric in the scorecard again.
X, Y and Y2-axes
To help you read a graph and measure the information, graphs are plotted with the use of X and Y axes.
The X-axis is the line on the graph that runs horizontally from left to right and always shows units of time. As value X increases, the point on the graph moves further right. The Y-axis is the line on the graph that runs vertically from the bottom up and shows the value of the currently selected metric. As the value of Y increases, the point on the graph moves further up.
All measurements start from the value of zero where the X and Y axes intersect. A Y2-axis is displayed as a second vertical line which appears on the right side of the graph. The Y2-axis enables you to see two sets of data (for example, comparing CPM and the relationship to ad impressions over time) on a single graph even when the values measured are different.
- X-axis shows the current date range.
- Y-axis shows the first selected metric.
- Y2-axis uses the second chosen metric as its value.
Read along the X, Y and Y2-axes. If you mouse over a point of intersection in the chart, a statistical bubble appears with information about the metrics you have selected for that specific intersection in the report and the date for that point on the graph.