Skip to main content
Gainsight Inc.

Query Builder

This article explains how to configure and use the Query Builder analytics feature for your application.

Overview

Query builder is designed to answer tough product questions. Get the flexibility you need to create custom analytics without having to learn another query language. Compare usage across audiences and group results to gain unprecedented insights.

Example Business Use Cases:

  • Answer tough product questions with flexible query-like language
  • Compare user behavior across different audiences
  • Use different visualization methods to analyze results

Compare Different Audiences

Track specific events and compare any number of different cohorts and behaviors to learn more about a specific behavior or validate a specific hypothesis. 

Gainsight PX allows you to customize the name of the event or audience on the Query Builder filter. This helps you easily understand the events or audience pertaining to the filtered query. The event labels are auto-populated from the last part of the selected feature name and you can modify them. These labels are displayed in the Query Builder chart area as legends, and in the data rows.

Note: Query Builder graphs can now be viewed as Pie Charts.

Group-Specific Events or Attributes

You can use the Group By field to aggregate results based on specific fields. Grouping the analytics data helps you gain insights from multiple custom events and analyze results quickly.   

Event Properties in Query Builder

Users can select the following event properties to analyze the product usage behaviors across audiences and group results to gain granular insights. 

  • Custom Events
  • Feature Events
  • Engagement Events
  • Session Initialization Events
  • Page View Events
  • Mobile Screen Events

Custom Event Properties

You can analyze custom event properties based on property values. This may come in handy when you want to measure the event properties such as video play counts or monetary values you're passing to Gainsight PX through Custom Events. For more information, refer to the Use Custom Event API article from the Additional Resources section.

Query Custom event.png

For more information about all frequently asked questions, refer to the Analytics FAQs article from the Additional Resources section.

When you create a query with numerical attributes of custom events, you can evaluate the results using Property Value aggregations.

Property Values.png

Feature Events

Users can now select events based on channel/feature in the Event dropdown list. The events are grouped into the following categories:

  • Web App Features
  • Mobile Features

Engagement Events

Users can now select engagement events in the Query Builder to create custom analytics and gain deeper insights into audience behaviors. You can further refine your query by selecting the required engagement type and its attributes.

Example Business Usecase: Create a query to find the number of views on a NPS Survey engagement among the android users who has submitted the survey response with a promoter score.

QB 1.png

Session Initialization Events

The Session Init option helps you query on user sessions data along with other query options in the event and audience sections. You can create queries to find out the details of the sessions initialized by users based on the attributes such as Global Context, Inferred LocationDevice, and Platform.

Query Session Init.png

Page View Events

The Page View option helps to query on various page view events using various URL and UTM parameters as given below:

 URL parameters:

  • Hostname identifies the host that holds the resource. 
  • Page Title is a short description of a webpage that appears at the top of a browser window 
  • Path represents a specific section or page of your application or website. 
  • Query Parameter represents a set of parameters added to the base URL (along with a value usually) to get specific content or denote an action from your application or website
  • Referrer is the webpage that sends visitors to your site using a link.
  • Scheme identifies the protocol to be used to access the resource on the Internet. It can be HTTP (without SSL) or HTTPS (with SSL).
  • URI is a sequence of characters that distinguishes one resource from another.

UTM parameters:

  • utm_source: Identifies which site sent the traffic.
  • utm_medium: Identifies what type of link was used, such as cost per click or email.
  • utm_campaign: Identifies a specific product promotion or strategic campaign.
  • utm_term: Identifies the (paid) keyword associated with the traffic
  • utm_content: Identifies what specifically was clicked to bring the user to the site, such as a banner ad or a text link. 

 

Page view qury.png

Mobile Screen Events

Mobile screen events helps you create queries based on the screen events and their attributes such as platform, screen name or screen class. You can also add the Group By attributes to get the required query results.

QB2.png

Export Query Builder Report to CSV

You can export the Query Builder report data as a CSV file to suit your needs of insights or further analysis. To export Query Builder data, click on Export CSV

Query Builder_export.png

Additional Resources

Analytics FAQs
Use Custom Event API

 

  • Was this article helpful?