Building a Universal Exploration

To illustrate how to use the Universal Exploration template for ad hoc analysis, let's consider a scenario where you want to calculate the total revenue earned per session segmented by the All Actors and Regular Watchers cohorts.

1. On the left panel, click + and choose the Universal template.
2. Give your exploration a name, add a description, if required and choose the destination folder.
3. Now, we add the measures. For the first measure, let's add an Aggregate block to calculate the Revenue. Choose sum as the aggregator and select the Incremental Campaign Revenue derived column as the value. To rename a measure, click the three dots corresponding to each measure and click Edit measure name. Let's name this block Revenue.
4. For the next measure, let us add an Event Aggregate block. Choose Count of unique actors that performed event as the measure and the Sessions dataset as the value. Then, select the event for which you want to measure the activity - here, we choose View ad. Let's call this Sessions.
5. For the third measure, let's add a Formula block to calculate the revenue made per session. The formula is as follows: Revenue / Sessions.
6. Click Run Exploration and your results will be displayed in the visualization window. We name this block $ per session.

7. As the next step, let's perform segmentation. In the Segment by Cohort section, we add 2 cohorts - All Actors and Regular Watchers. Now, when you run the exploration, the segmented results will be displayed.

8. If you want to perform a period-over-period comparison, you can choose a time period using the Compare to drop-down and a dotted line will be displayed in the visualization showing the results over the selected time period.