Product and Design

Product Update: Databox’s New Metric Builder Pulls Custom Metrics from Advanced Analytics Platforms

Our second generation Query Builder let’s you pull custom metrics from Google Analytics, MixPanel, Localytics, Adobe Analytics, Facebook Ads and more.

Gasper Vidovic on May 3, 2017 (last modified on February 23, 2023) • 5 minute read

The Metric Builder is our advanced setup engine that allows you to extract custom metrics, events, goals and data with just a few clicks.

A few years ago, we created Metric Builder so we could build custom integrations for Enterprise clients. Soon after making it available to the public, we realized it was helpful for companies of all sizes. And it became increasingly apparent that some users had complex data demands that could not be handled using predefined metrics.

google-analytics-kpi-dashboard-template-databox

Metric Builder 2.0

Last year, our users made almost 5,000 custom queries.

Our new version addresses feedback we received from these customers. Most of the feedback was how to make it easier to use. We listened and got back to the drawing board. These are the improvements:

  • Supporting multiple time intervals with only one query.
  • Making queries accessible right from the Designer, where customers setup visualizations.
  • Improvements behind the scenes, so users don’t have to set correct data types or metric mappings to get accurate numbers.
  • Making the Metric Builder a robust service that can eventually be an extension to any of our native connectors.

We strongly believe we checked all these boxes and even more.

While the Metric Builder form is different based on each supported connector, let’s take a closer look at how it works for Google Analytics and what has changed:

  • Name your queries. Each query will produce a custom metric that you can name, so it’ll be easier to find it in your query list and within the Designer. In the Designer, all of your queries can be found under the “Custom” tab in the metrics drop down.
  • Multiple time intervals with a single query. Now you don’t need to create multiple queries to cover multiple time intervals. Just select all the time intervals you need and they will be available for that metric.
  • Compare setting. If you want to see the value compared to the previous period or the same period last year, you can now specify that in the Metric Builder. On a Number block, it will appear as a change value beneath the actual value. On a line or bar chart, it will add a second line/bar with values from the compared period.
  • Advanced options. This part of the Metric Builder form is individual to each connector. It allows advanced segmentations, filters and settings to get the data you need.
  • Improved data preview. Once you run the query, you will see the raw data response from the connector below. If you have selected multiple intervals, the results will be split and you can switch between them with tabs. The data preview shows raw data. You can sort by each column and apply a few transformations to the dimensions (we call them ‘Attributes’). Read about some more technical details in our help docs article.

How you can try it out…

The Metric Builder feature is available for all users on the Business plan (free trials included). To try the new Metric Builder:

  • Log in to the Databox webapp,
  • Create a new Datacard/Datawall, or edit an existing one
  • Select the “Visualization Types” datablock menu on the left icon_datablocks and drag & drop an empty visualization (ie. Number, Line chart, Table).
  • Select the data source from the right panel.  (The Metric Builder is supported for: Mixpanel, Google Analytics, Salesforce, Localytics, Zendesk, Adobe Analytics, Facebook Ads and all SQL connectors.)
  • In the Metrics dropdown, switch to ‘Custom‘ and select ‘+ New Custom Query.’ The Metric Builder form will pop up.
  • Once you make a custom query, run it to see the results. If you’re satisfied with the settings, save the Query.
  • Once saved, it will start to fetch data. Wait a moment and you should see the data on the Datablock. You can switch between the time intervals that you selected within the query.

With the Metric Builder, you can now pull the data you need to build advanced reports.

google-analytics-kpi-dashboard-template-databox

We are always eager for feedback, suggestions and ideas on how to improve it further, so feel free to contact us at help@databox.com.

About the author
Gasper Vidovic is Director of Product at Databox. Also a traveler, lawyer & icon enthusiast.

Get practical strategies that drive consistent growth

Read some
You may also like...
Read more

NEW – Databox Performance Screen 

Get quick access to the Metrics and Goals that matter to you the most.

Product and Design   |  Apr 24

Read more

Get Insights on Your Top KPIs with the Metric Detail Page and the Weekly Metric Performance Digest

Dig deeper into each and every metric you are tracking.

Product and Design   |  Nov 18 2022

Read more

New: Connect Your Dashboards Together in Databox Using Looped Databoards

You can now tell the full story of your performance from a variety of sources and viewpoints.

Product and Design   |  Oct 18 2021