Analytics Reporting – Filters

filtersUse this Analytics Edge wizard to define filters to use with the query.

Select a Dimension or Metric, then pick a Comparison operator and enter a Value. Click the Add button. The filter will appear in the list at the bottom.

Use AND or OR logic to join multiple conditions in a single filter.

Note that all the metrics and dimensions used must be valid when used in combination with the metrics and dimensions of the query itself.

Use a Cell Reference

For advanced users, you can use a filter expression stored in a worksheet, BUT the expression must be encoded exactly as the API expects it to be.  See this page for details and examples. For example, to filter for City equals Ottawa, the expression would be ‘ga:city%3D%3DOttawa’.

To use a cell reference, click the button to the right of the entry box, then click the cell in the worksheet where the filter expression is stored. The entry will look like   ‘Sheet1’!P2