Generally, our Google Analytics widgets in Reporting show unfiltered data. For example, this Analytics Data Table widget shows all 'Sources' from GA in a table.
If you want to report on just a subset of this data (like excluding '(direct)' from the widget), you can enable the 'Custom Filters'
Enable Custom Filters
- Select the checkbox "Enable Custom Filters."
- Specify the filter: for example, 'ga:source!=(direct)' (this translates to 'source is not equal to '(direct)').
- Preview the widget.
- Save your Optmyzr report.
Syntax For Google Analytics Widgets
The information available in the Google Analytics widgets comes from the Google Analytics Reporting API.
How you specify the value of the filter, is determined by GA's Filter Syntax described in detail here:
You'll also need to know what the segments and dimensions are so that you can have the correct value on the left side of your equation, as not all segments and dimensions are compatible:
When you filter something, there are two sides to the equation. The left is what metric or dimension you're filtering on, and the right side is what value you'd like to match or exclude. In the middle is the operator (syntax) that specifies what type of match you'd like.
For example, the following says that the medium should include (=@ or "Contains substring") the word 'CPC':
This says that the source should not be (direct):
You can also combine statements by using the 'AND' operator which is written as a semicolon between statements. For example, this says that the source should be Facebook and the medium should be CPC:
And this says that the source could be either facebook or google by placing an 'OR' operator between statements by using a comma:
Syntax For Analytics Assisted Conversions Widget
The information available in the Google Analytics Assisted Conversion widget comes from the Multi-Channel Funnel Report API.
How you specify the value of the filter is determined by GA's Filter Syntax (same as before).
The Query Parameters Summary summarizes all the query parameters accepted by the Multi-Channel Funnels Reporting API.
You'll also need to know what dimensions and metrics are available in the Multi-Channel Funnel report so that you can have the correct value on the left side of your equation, as not all dimensions and metrics are compatible.
For Assisted Conversions, you will need to replace the prefix GA by MCF (Multi-Channel Funnel). For example, the following says that the source is Google and the medium is CPC:
Example of Filtered Data in Charts
Say you want to show a chart of the sessions and bounce rate for visits originating from AdRoll. With Optmyzr's Analytics Time Wise Chart, you're normally charting the sessions and bounce rate for all traffic in the GA view that's connected to the Optmyzr account so it needs to be filtered so you'd see a chart like this one:
To filter it down, first, you need to determine the correct syntax for writing the custom filter. If you know exactly what the source is called in GA, you can write the filter directly in the Chart widget's field for Custom Filters. If you're unsure whether 'AdRoll' is capitalized or not, or if it is specified as 'adroll.com', you can create an unfiltered Analytics Data Table.
Then, look at the preview of this table to find the string that you're trying to filter for. Here you can see it's just 'adroll':
Now you can write the filter with the correct syntax.
For example, write 'ga:source==adroll' if you only want the reporting widget to contain data from when the source is exactly 'adroll' and nothing else, and then the chart will be updated to include just that data like below:
If you're filtering for a campaign name or something where the text contains a space, just leave those spaces. We'll automatically convert it to the correct format to make sure you get the right data back.
So if you're filtering for a campaign called 'hello world', your filter would look like this: