Filters
You may add filters to the desired elements (dimensions and/or metrics): click on the element in question, then click the "Add" button in the right-hand panel.
Tip
Filters can be applied independently to each dimension and each metric. Elements that are filtered will be indicated by a small funnel-shaped icon.Two types of filters can be applied to dimensions and metrics: "AND" and "OR". To choose one or the other, click on the "AND" or "OR". You may add up to 30 filters. Please note, you may only choose one type of filter for a single dimension or metric.
Tip
The "AND" filter is useful for making multiple exclusions, as well as for obtaining a "between" concept. For example, obtain visits whose time spent per page is between 10 seconds and 60 seconds.Variations
Click on the metric for which you would like to display variation, and tick the box marked "Activate variations". Then, select the periods you want to compare. You may choose between percentage or value formats.
Tip
Variations are only possible if your template contains at least 2 metrics, with at least one based on the reference period (P1), and if you've set up multiple periods. You may not associate the evolution mode with variation mode.Ratio
Click on the metric you wish to display in ratio format, then select the "Ratio" option. A drop-down menu will appear, from which you can choose on what your ratio should be based:
- On the sum of current page items (10,000 first rows, for example)
- On the sum of all elements in the dataset
- On the sum of all values of the reference site
> More information about the 3 “total” formats is available in the Total section.
Tip
Ratios are not possible when "'Total' rows" are activated.Hide a column
By clicking on a dimension, you can hide the corresponding column. By doing this, this column will not be visible in your results table, enabling you to filter certain elements contained inside.
Then, you may also aggregate your data. This feature is useful when you have several dimensions in your analysis, or if you use filters to focus on a specific element in particular.
Example:
You want to analyse your sources by country. When you select the "Sources" and "Countries" dimensions, you'll get a result similar to this:
| COUNTRIES | SOURCES | VISITS |
| France | Search engine | 50 |
|
France |
Direct traffic | 30 |
| Italy | Search engine | 30 |
| Germany | Direct traffic | 40 |
| France | Sponsored links | 20 |
| Germany | Search engine | 15 |
| Italy | Direct traffic | 18 |
| Germany | Sponsored links | 25 |
| Italy | Sponsored links | 40 |
If you hide the Countries column, the visits from each country will be summed by source type:
| SOURCES | VISITS |
| Search engines | 95 |
| Direct traffic | 58 |
| Sponsored links | 85 |
And inversely, if you hide the Sources column, the sources will be grouped together for each country:
| COUNTRIES | VISITS |
| France | 100 |
| Italy | 88 |
| Germany | 80 |
This feature is especially useful when using filters. In our example, if we want to focus on sources for the country of France, we'll have:
| COUNTRIES | SOURCES | VISITS |
| France | Search engines | 50 |
| France | Direct traffic | 30 |
| France | Sponsored links | 20 |
Here, the Countries column will still contain France; by hiding the Countries column, we can streamline the display of the results set.