Today we will see how to use the "advanced filters in cascade by a method presented by the excellent blog Lunametrics.

We must first understand that the filters are applied in a certain order, the second applies to the results from the first and so on. For this reason, it is possible to redefine the order of filters in the interface.

Order filters GA

The principle is to create a filter whose output will be stored in one of the fields offered by Google Analytics. Then we will retrieve the values of the fields in a second filter to the restatement, and so on throughout the process filter in place.

In the example below, we will concatenate the values of certain fields of the application to generate a report that will enrich the transaction lines (within the framework of an ecommerce site) with the source data traffic (support, source and terms of campaigns)

The first filter is to concatenate support and source of each visit to the "Field 1":

Filter Type: Custom filter
Option: Advanced
Field A: Campaign Medium
Extract A: (.*)
B Field: Campaign Source
Extract B: (.*)
Output To: Custom Field 1
Manufacturer: $ A1 | $ B1
(tick yes to Field B Required)

The second filter adds custom field 1 to the value of the Term of the campaign, then rebuilt the custom field that takes the values "Support | Source | Term" ( "Organic | google | wagablog," for example).

Filter Type: Custom filter
Option: Advanced
Field A: Custom Field 1
Extract A: (.*)
B Field: Campaign Term
Extract B: (.*)
Output To: Custom Field 1
Manufacturer: $ A1 | $ B1
(not to leave Field B Required)

The third filter is associated with each e-commerce transaction data field, allowing for example to quickly identify keywords and campaigns and media that have generated the commands with the highest amount. This will also generate dashboards faster. Indeed, you can extract it in an Excel table of all transactions of the site for a given period and for each transaction you directly from customers.

Filter Type: Custom filter
Option: Advanced
Field A: Id of the e-commerce transaction
Extract A: (.*)
Field B: Custom Field 1
Extract B: (.*)
Output To: Transaction Id e
Manufacturer: $ A1 | $ B1
(tick yes to Field B Required)

You can stop here, or go even more carefully if you want to separate such "new clients" of the "existing customers". To do this it must first go back to Google Analytics the value of "existing client" or "new customer" for each visitor that you can identify that. This value may be stored in the "Custom Value" through __utmSetVar ( 'value'); you can add to your marker.

Here then is what your report might look like "E-commerce> Transaction:

Report e-commerce - transaction Analytics