Overview
Data Explorer empowers you to analyze your product and Segments using visualizations and reports of your data from one location. This allows you to quickly uncover usage behavior and patterns, then utilize these insights to make improvements to your product and customer experience. Additional filters by Segment or Grouping by Visitor or Account metadata further define how your product is being used by different user groups. Visualizations and comparison tools help you compare performance between different segments or different date ranges in your analysis. Download your graphs as images and add them to presentations or download tables as a CSV file for further analysis outside of Pendo. Your Saved Reports can be viewed by anyone in your subscription, shared, or added to your Dashboard for easy access.
Requirements
Any user can build and save reports in Data Explorer except for Read-Only users.
Create a Report in Data Explorer
Data Explorer is in the Behavior section.
You'll start with a fresh new report, ready for you to build your query.
At a minimum, you need to add a Data Source and an object. Data Explorer will look at data daily for Everyone for the last 30 days by default.
For more advanced analysis, you can add up to two Data Sources with 10 total objects. If you use five objects or less, you can compare up to five Segments with one date range, or up to two date ranges with one segment. There may be a cap on each parameter dependent on the other parts of the query.
Build Your Query
Build your query by choosing up to 10 objects from one or two Data Sources, the Measurement of these sources, the Date Range for the analysis, the Segment used to filter the query, and Group By any available metadata. This is a powerful combination of parameters that can compare app usage, Guide usage, events, and user behavior against each other for different Segments, at different times.
Data Sources
Select up to two.
- Any Activity - Any Visitors or Accounts with any events in your application
- Page Views
- Feature Clicks
- Track Events
- Guide Views
Measurements
Select for each Data Source.
- Total - This includes all events.
- Average - This measurement will calculate the average number of views, clicks, or events based on your data sources.
- Median - This measurement will calculate the median number of views, clicks, or events based on your data sources.
- Number of Visitors or Accounts - This includes all unique visitors or accounts.
- This is the only option available for the Any Activity Data Source.
- Percent of Visitors or Accounts - This is a percentage of all unique visitors or accounts who have clicked a feature, viewed a page, or fired a track event versus the number eligible in the Segment.
- This option is not available for Any Activity or Guide Views.
Select App
If you have multiple applications within your Pendo Subscription you can select a different app for each Data Source.
If you use the Any Activity Data Source, you can select up to five apps to query.
Select Date Range
Select a date range, or pick your own custom date range, and select the data breakdown within the date range. The data will be aggregated according to the breakdown frequency in the data visualization.
Date Range Options
- Today
- Yesterday
- Last 7 days
- Last 30 days
- Last 90 days
- Last 180 days
- Custom Date Range (Max 180 days)
Data Breakdown Options
- Hourly - Default one day selection
- Daily - Available for 2 - 59 day date ranges
- Weekly - Available for 14 - 180 day date ranges
- Monthly - Available for 60 - 180 day date ranges
Compare Date Ranges
Comparing date ranges repeats the query for a different time period and allows you to compare your analysis for the same group at different times in one data visualization.
The second date range must be the same duration and breakdown as the first date range. The default selection is the date range immediately before your first date range.
With the second date range drop down you can select other options.
- Previous date range
- Same date range from the previous year
- Custom date range with the same number of days
- Select the date the date range starts or ends on
Note: To use Compare Date Ranges, you can use two Date Sources but only five objects and one Segment. If you have too many objects or Segments selected the Compare Date Ranges button will be grey.
Select Segment or Multiple Segments
Select the Segments to query. The default Segment is Everyone. You can create a new or draft Segment if needed. A new Segment created from the dropdown is added to list of Segments for the subscription. Draft Segments are used to create a Segment for just this report with the option of saving it to the subscription. They can be modified in the report without saving them to the subscription, similar to custom Segments in Guides.
Add Segment to select additional Segments to compare against. The query will be repeated for all additional Segments. You can select up to five Segments if you have five or fewer Data Source objects and one date range. If you select more than five objects, your are limited to two Segments.
Note: To use Multiple Segments, the query can only use one date range. Queries with more than five Date Source objects cannot use more than two Segments. If you have too many objects or date ranges selected the Add Segment button will be grey.
Create Draft Segment
Draft Segments allow you to build a Segment and run your report without adding a new Segment to the subscription or changing an existing Segment in the subscription. The Draft Segment is saved with the Data Explorer report even if the Segment isn't saved to the Subscription. You can add multiple Draft Segments up to 2 or 5 depending on other selections in the query builder.
1. Click Create Draft Segment to open the Draft Segment builder.
- Draft Segment - Default name is Draft Segment A-E for up to five Segments, name can be changed
- Use Existing Segment - Closes the Draft Segment and uses the existing Segment dropdown
- Save Segment - Saves the Draft Segment to the subscription as a new Segment, name and visibility can be changed prior to saving
- Remove - Removes any Segment selection from the query and defaults to Everyone
2. Add Rules to build the Segment. This is the same as building a Segment on the create Segment page.
3. Click Run to run the Data Explorer query with the selected Segment rules. The draft Segment stays open and visible for quick editing.
Select Group By Metadata
Group By clusters data using available metadata. Group By can only use metadata fields with 200 or fewer possible values that is categorized as String or Boolean. Metadata with more than 200 values or categorized as Text, Number, Date, or List do not appear in the dropdown menu. Event Property is only available if a selected Feature Click or Track Event Data Source object has associated Event Properties.
- Visitor Metadata - Additional Visitor level metadata and Account ID
- Available fields are listed in Data Mapping Settings
- Account Metadata - Additional Account level metadata
- Available fields are listed in Data Mapping Settings
- Event Property - Available if a selected Feature Click or Track Event Data Source object has associated Event Properties.
Note: Group By is only available if a single date range and Segment are used. If Compare Date Range or multiple Segments are used the Group By button will be grey.
Run Your Query
Click Run at the bottom of the Query to run your report and create the data visualization and data table. The report takes a few seconds to process depending on the size of the database and complexity of the Query. The Run button is grey when the report is complete but unlocks if any changes are made to the Query.
Visualization and Side Panel
After you Run your Query, the Chart and Breakdown table appear for you to visualize your data and see the raw data used to generate the Chart. The Chart has several customization options to change the data visualization. You can also download the Chart or raw data. A maximum of 10 rows from the Breakdown are visible in the Chart at a time.
Select the Chart Type you want to use for each of your Data Source Types.
- Line
- Area
- Column
- Bar
- Donut
The left and right Y-axis correspond to a Data Source. You may be able to match the Y-axis scale using Chart Options if your Query includes two Data Sources (Page Views, Feature Click, Track Events, Guide Views) that use the exact same Measure (Total, Average, Median, Number of Accounts, Number of Visitors, Percent of Accounts, Number of Visitors),
Hover over a data point to see additional information.
Click on a data point to open the side panel which displays all Visitors or Accounts included in the quantity of that specific data point. The side panel shows data by Visitor ID or Account ID by default.
Export a Comma-Separated Value (CSV) file of the side panel data with any additional metadata fields that you would like to include.
Click Change Metadata to substitute the metadata you want to see in the side panel from Visitor or Account ID to any other available text-based Visitor or Account metadata. This substitutes the Visitor ID or Account ID with the new value and does not recalculate the data or quantities (Feature Clicks, Page Views, etc.) displayed in the side panel. This setting sticks until the report is closed or the metadata field is changed.
Hover over a label to highlight the associated data in the Chart.
Download the Chart as a PNG image file by clicking the Download button on the Chart.
Breakdown Table
The Breakdown table that summarizes your data is below the Chart. All possible values and quantities are shown in raw data, including empty fields.
The Eye indicates which rows display in the Chart or not. 10 rows can be displayed in the Chart at a time. If 10 rows are visible, a row must be hidden before a new row can be selected.
Note: Data sources without any data to display will be hidden from visualization automatically. Click on the eye to show data with no value in the Chart.
Export the full table as a CSV by clicking the Download button on the Breakdown table.
Group By and Segment Interactions
When using Segments and Group By, the Breakdown table returns all possible values of your selected Group By metadata and filters the quantities by Segment. Group By first builds the rows of the table from metadata and the query data is filtered using the Segment to return the number of results.
Example - Group By with Account metadata "plan" and Segment "Gold Customers"
Group By builds the Breakdown table with all metadata values, in this case gold, silver, bronze, and none. The Segment filters anyone who doesn't have "gold" in the "plan" metadata field and does not include those values. The Breakdown table shows rows for all Group By metadata values but only the row for "gold plans" shows data due to the Segment.
Save Your Report
Save the report to access the Query again later. This is helpful for rerunning or sharing the report. Reports that aren't saved are lost as soon as you exit Data Explorer.
Click Save to open the Save Report form.
Name the report and choose the Visibility.
Click Save Report to add the report to Saved Reports for the subscription. Saved Reports are accessed in the Behavior Section.
Saved Reports
After you save your report, you are taken to the Saved Reports page.
Filter the list by changing the dropdown option from Created by anyone to Created by me or search the list.