Visualize goals from Google Analytics with Query Builder (use-case)

Although the Query Builder is an advanced data analytics tool, it is designed to be as easy as possible to transform your custom data into a beautiful looking KPI dashboard, accessible from anywhere.

Let’s look at an example with Custom Goals from Google Analytics:

 Log in to the Databox web application.
 Create a new Databoard or edit an existing one, wherever you want to see the Goal data.
 Select the empty datablocks menu on the left and drag & drop an empty visualization (ie. Line chart).
 On the right properties panel, select the desired Google Analytics connection (if not connected yet, select Google Analytics and click on the green ‘Connect’ button).
 In the metrics dropdown, scroll to the bottom and select “Custom metric…”. The QueryBuilder will pop out.
 Select the Google Analytics Account, Property and View
 Click on the Metrics input (dropdown) and it will load all the available metrics for you. Select the desired Goal (you can help yourself by searching for it).
 To get historical data right away, choose the Start date ‘60 days ago’ and leave the End date with ‘Today’.

By saving the query, it will close the window and select the newly created custom metric named the same as the Goal.

That’s it! In a few seconds, you should already see the data pulled in. If you want to modify the conditions of the query, you can click on ‘Edit’, which will again open the Query Builder window.

To see an overview of your created custom queries, you can go to ‘Data Manager’ > ‘Query Builder’.
Goals are used to measure how often users complete specific actions. A Goal represents a completed activity, called a conversion, that contributes to the success of your business. Examples of Goals include making a purchase (for an e-commerce site), completing a game level (for a mobile gaming app) or submitting a contact information form (for a marketing or lead generation site). Having properly configured Goals allows Analytics to provide you with critical information, such as the number of conversions and the conversion rate for your site or app. Without this information, it’s almost impossible to evaluate the effectiveness of your online business and marketing campaigns. As Goals are always account-specific, the generic API connector cannot cover it.

But Why Not See for Yourself?!

With the Query Builder, you now have a powerful and highly customizable component, which we will continue to build upon. As we release Query Builder into your hands, we are starving for feedback, suggestions and ideas on how to improve it.

The Query Builder is a feature available to all users on the Business plan. We would love to give you a free test-drive if you are on a different plan, too – just let us know!

Still need help? Contact Us Contact Us