Question

Build an Explore query using table view that will return an average of age filtered to events with action that matches purchase. Split the results by referrer. Starting 1 month ago and ending now. When the results return use chart options in the top right to format the results as a number.

Take Note:

Notice how this query is returning an average value of age as it did in question 9. However, in this query we are filtering the values of age down to events that have an action value that matches purchase. In the row and column image example below we’ll only be summing and dividing values of age from rows that also have a value of purchase in the action field. Since we’re using split by of referrer we’re further narrowing down the results of measure 1 to different referrers but referrer is not considered when determining which rows to return based on the measure definition. Therefore, each row in the resulting table is returning the average value of age for rows that include a value of purchase for the action field, then it is being visualized in a table split by whatever value of referrer happens to be present.

Click to enlarge

Solution

Note: The numbers and result does not need to be an exact match as the data changes over time. The query construction is what is most important. See images below.

*Click to enlarge*