Level 1 - Question 18 - Conversion

Question

Build a query that calculates a conversion rate that determines the percent of users who have purchased. In this query we will be using multiple measures (3). You can add an additional measure to an Explore query by pressing the + measure button in the query builder.

1. Using number view, measure one should count unique user actors that is filtered to all user actors.

2. Measure two should count unique user actors that is filtered to action that matches purchase.

3. The third measure will use a calculation, in the count node press the = sign like you did in question 13, and divide measure 1 by measure 2. After pressing = enter a square bracket [ to choose your measure, then you can use any mathematical operator you need. (=[measure2]/[measure1]).

Using chart options in the top right of the Explore window will allow you to format measure 3 as a percent, you can also choose which measures you wish to display in the query results.

Take Note:

This question is important in understanding how Scuba allows you to do many different things in the same query. In this example we’re doing a count, a filtered count, and performing a calculation across multiple measures. Multiple measures are commonly used in more advanced queries when you’re trying to compare different things, or build multiple separate components that are later brought together like we did here.