Want to know more about Grow’s filter and drill features? This article will give you a closer look into how it works.
You are as filterable or drillable as the things you give your metric. The more you give Grow to filter, the more you’ll be able to filter.
Filtering has a specific order of operations:
API → SQL transforms→ Filter button in Edit Metric → What is left is filterable.
We’ll illustrate this with a simple example. Let’s say I want to look at my website traffic by device over the past 6 months through Google Analytics.
- API Level: I pull the data in for 1 year back from Google Analytics.
- SQL Level (advanced options checkbox): I limit the data to the past 6 months.
- Filter button in Edit Metric: The data is currently showing me the past 6 months for mobile, desktop, and tablets, but I don’t want to see tablets, so I use the filter button to filter it out.
The end result is that I see mobile and desktop traffic for the last 6 months. This is all the data that I have the possibility to filter on when my metric is in expanded mode on my dashboard.
What this means:
- I can’t go back more than 1 year, because Google Analytics (API level) only showed me the data for 1 year back.
- I can’t go back more than 6 months, either, since SQL transforms came after the API.
- I won’t be able to show tablets in my filtering and drilling, since I filtered that out using the filter buttons in Edit Metric.
When you get into Edit Metric, if there is a certain field you want to be able to filter on, make sure that box is checked under the Filterable Columns heading. The nice thing about filtering is that even if the metric on your dashboard doesn’t show certain fields, you’ll be able to filter on them if they’ve been selected.
While drilling into your data only gives some actionable insight, it does allow you to ask questions about what is happening. Those questions will then lead into greater insights to your company.
For example, let’s say you are looking at your company’s sales and you notice it spiked one day. Drilling would let you look into it and figure out why they spiked. You can find the value of the sales closed that day, the sales rep that closed them, among other useful information.
With both filtering and drilling, if you want to be able to filter off a certain field, make sure it is part of the report that builds up your final metric. Drilling is based on the order of operations above and then whatever filters you apply in Expanded Mode. If you just expand the metric, don’t apply any filters, then drill into a data point, you will see all of the data for that specific point.
Here’s a quick insight into what filter and drill enables you to do:
- It levels the playing field in your business. The numbers for some reps or sales or other metrics may look large, but filtering and drilling will allow you insights into what is actually happening.
- You don’t have to pack a whole lot of data into one metric. Just make sure it is filterable, and even if it’s not displayed on the metric, you will still be able to see what’s happening.
- You will get to the core a lot faster. Before filter and drill, you may have had to build out many metrics in order to see things you needed to see. Now, with a couple clicks of the mouse, you can quickly answer the questions that you have.
- It empowers even a very basic-level user to answer a lot of questions about the data. It is easy to see, to understand, and then to talk about the score with your company.
Haven't enabled filter and drill on a metric yet? Here's how.
Questions about using filter and drill? Email us at firstname.lastname@example.org or chat in on the site and we’ll be happy to help.