All Collections
Help with DashGoo?
Reports
How do I filter results in my reports?
How do I filter results in my reports?

Learn how to use the filters feature in DashGoo widgets and see some examples

Fernando Vital avatar
Written by Fernando Vital
Updated over a week ago

You can use the filters to hide certain information and display only what you need.

You can use filter to hide an inactive campaign, display a particular ad group, results greater or less than x, values equal to a given number, and a myriad of other combinations.

You can add as many filters as needed to get the result you need. All filters are complementary, that is, if you add multiple filters, the result returned will always be the merge of all the filters together.

The filters are only valid for the widget as they are added. To create a filter, edit the widget you want to apply the filter to and select the Filters tab.

1) In the first field will be listed the dimension and the metrics that you previously selected in the Main Data tab. Select where you want to apply the filter.

2) The second field you define the filter rule:

  • Contains – Will list all records that contain the term. This is a large, active filter where any part of the term is reported. Example: If you have records with the term “Campaign Acme”, the term “acm” would filter this result.

  • Does not contain – Will list all records that do not contain the informed term. Also ample.

  • Greater than – Will list all records that the value is greater than the reported value (used for metrics that return numbers).

  • Less than – Will list all records that the value is less than the reported value (used for metrics that return numbers).

  • Equals – Will list all records where the value or term is identical to the term or value reported. Any difference will not activate the filter.

  • Different from – It will list all records where the value or term is different from the term or value reported.

3) Click save and test the filter. If you need to make any adjustments, just edit the widget again and set the filters again.

To delete a filter or all, click the Remove button next to each filter.

Important informations:

  • Filters are only applicable to charts and tables. It is not applicable to the Overview widget.

  • Filters are not compatible with “Compare Previous Period” option enabled.

  • The filter is applied under the amount of records you set, that is, if it was set in the Advanced Options tab display 15 results, this number will be returned first and the filter will be applied later. If in these 15 results, the filter remove 4 of these results, only 11 results will be listed in your report. If necessary increase the number of results in the respective field to reach the number of results you want:

Filter examples

Here are some examples of what can be done. The combinations are unlimited:

Only show AD campaigns that have the word “HAPPY”

  • Field 1 – Select “Campaigns”

  • Field 2 – Select CONTAINS

  • Field 3 – Type “happy” (without the quotation marks)

Do not view Analytics Sources that start with “Face”

  • Field 1 – Select “Sources”

  • Field 2 – Select DO NOT CONTAIN

  • Field 3 – Type “face” (without the quotation marks)

Only show Facebook Ads Ads from the “ACME FEB.”

The filter is not directly applicable to Facebook Ads ads (first column of the table). Before you can filter your ads by campaign, ad group, or ad name, you’ll need to add the column (which contains the term you want to filter) by selecting it in metrics. If I want to, for example, filter by ad name, you’ll have to include the “Ad Name” metric and filter by it.

  • Add the “Ad set” metric in the Metrics field on the main tab.

  • Field 1 (Filter Tab) – Select “Ad Set”

  • Field 2 – Select IS EQUAL TO (or contains)

  • Field 3 – Type “acme fev.” (Without the quotation marks)

Only display posts (posts) Facebook that contains in the message the hashtag “#happy”

  • Field 1 – Select “Publications”

  • Field 2 – Select CONTAINS

  • Field 3 – Type “#happy” (without the quotation marks)

Do not display keywords (Adwords) in the “MOBILE” ad group

  • Add the “Ad group” metric in the Metrics field on the main tab.

  • Field 1 (Filter tab) – Select “Ad group”

  • Field 2 – Select DO NOT CONTAIN

  • Field 3 – Type “mobile” (without the quotation marks)

Did this answer your question?