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.
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.
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.
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 Location, Device, and Platform.
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.
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.
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.
