In the Report Builder, you can create powerful visualizations using the defined metrics in your account. Combining these metrics in a formula allows you to glean additional insights from your data. In this article, we’ll deep-dive into how formulas can be used in the Report Builder - lets jump in!
In the Report Builder, a formula is just a combination of one or more metrics based on some mathematical logic. A typical example looks like this:
In this example, we’re using a Number of orders metric (A) and a Distinct buyers metric (B), and our goal is to answer the question: what’s the average number of orders my buyers are making each month? The parameters of the formula are:
Now that we’ve covered the basics, lets take a look at some examples.
In this example, we used the Revenue and Revenue (first time orders) metrics. By dividing the Revenue (first time orders)(B) metric by the Revenue metric (A) and setting the return format to Percent, we can find the percent of revenue that can be attributed to first time orders.
In this example, we used the Revenue and Number of orders metrics. The answer to this question involves two steps - dividing Revenue (A) by the Number of orders (B) and setting the return format to Currency. Next, we only allowed the formula result (Avg. Revenue per order) to show and grouped the results by Promo code.
Finding the answer this question involves a few steps:
In our example, we used the Stacked Columns perspective to display the results by month. This allows us to compare the distribution of new customers on a month-to-month basis.
Did you notice in the examples above that the formula’s timestamp, groupings, perspectives, and filters are inherited from its input metrics? Keep in mind that formulas can be leveraged to use perspectives and independent time options, just like metrics can.
If you have any additional questions about using formulas in the Report Builder, use the contact us link to reach out!