Exploring Performance Analytics data

Learn how create custom queries.

Looks are built using queries of the data in your project and displayed according to the visualization format set for the Look, e.g., Table, Timeline, or Single Value. This page explains how to view the queries behind the Looks and the ways you can explore your data.

The Explore view

The base query of a Look is called an Explore. In any Look, hover and click , then select Explore from here. This opens the Explore view, where you can see the selections, entries, and filters used to generate the information included in the query. From here, you can start customizing queries.

The sections you’ll see:

  • Sidebar — At the top is the Explore type, followed by a search field for the DimensionsGenerally, a string field in Performance Analytics. They can be grouped and can act as filters or members of a data set. and MeasuresA numeric field in Performance Analytics — like a count or sum. Measures appear in orange within an explore. grouped in fields below it.

    Selections made here are immediately reflected in the Filters and Data sections. Separate tabs show All Fields and fields that are In Use for the current query.

  • Filters — Use this section to configure the filters in the query.

    You add filters by clicking   for a Measure or Dimension in the sidebar. Click   or   in a filter row to add or remove filters of the same type. Multiple filters of the same type are processed as a boolean OR.

    The default value for the App Name filter is the current Airship project name. Operators and input support vary by field. For example a time dimension supports setting a time range, and text dimensions return matching values as you type.

    To manually add filtering expressions, check the box for Custom Filter to expose the entry field.

    Click Run after making changes. Only rows for which conditions are true will be returned in results.

  • Visualization — The Explore view opens to a default visualization format, one of:

    • Table
    • Column
    • Bar
    • Scatterplot
    • Line
    • Area
    • Pie
    • Map
    • Single Value
    • Static Map (Regions)
    • Static Map (Points)
    • Donut Multiples
    • Single Record

    To view the data in another format, click an icon in the Visualization section header. Hover over an icon to see its label. You may need to click   to expose all options. Click Edit for options specific to the current format.

    Some Visualization types may be incompatible with the currently selected Dimensions and Measures.

  • Data — This section is essentially the Table visualization format. You can set the maximum number of rows to return and whether or not to display totals.

See also: Saving Queries.

 Tip

You can bookmark queries in your web browser after opening the Explore view in a new window.

  • From a Look, hover and click , then hold down Ctrl (Windows) or (Mac) on your keyboard and select Explore from here.
  • From the Explore Glossary, click   next to its name and select Navigate to Explore.

Use your browser’s bookmark feature to save the view.

Example data exploration

Let’s find your app’s in-app impression rate. To do this we need to add two Measures to the Messages Look.

  1. Go to Reports » Performance Analytics and select the Messages Dashboard.
  2. For the Messages Look, click   and select Explore from here.
  3. In the sidebar, go to Message Metrics » Measures » In-App Impression Metrics and click   next to:
    • In-App Impression Rate
    • In-App Dismissed User Rate
  4. Click Run.

For more tutorials, see our directory of Common tasks and queries.

Explore names and glossary

When exploring a Look, the top of the sidebar lists the Explore name. There are two categories of Explores:


In addition to being able to explore any Look, Airship provides a number of additional pre-defined Explores in the Explore Glossary. Go to   » Shared and select Explore Glossary (Explore Glossary EUCS for EU customers) under Looks. To open one in the Explore view, click its name and select Navigate to Explore.

The Explores available in the glossary are named for types of data and tasks, and they are all limited to the data in your currently selected project:

App Explore descriptions

Active Users
Count of the active users in your app.
Audience
Devices that are not marked uninstall, and their active tags.
Audience by Tags
Audience counts by combinations of tag group and tag value. Make sure to leave default values in for unused filters.
Audience Opt In
Metrics about your entire audience, split by opt-in status. This includes any user that currently has an app installed or has opted-in to web notifications.
Automation Message Report
Aggregate performance of automated messages.
Correlated Uninstalls
Messages and their uninstall rates.
Custom Event Cohort
Daily open activity of users performing an activation event (custom event). This helps you understand which goals keep a user retained for longer. See: Custom Events.
Custom Events
User-level behavioral events. Understand how people are interacting with your content. See: Custom Events.
Experiments
A/B Test push notifications.
Funnel
Create a funnel or path based on user behaviors (custom events). See: Custom Events.
Growth by Day
Counts by day of users installing, uninstalling, churning, and reactivating. Typically run for a 7-day period.
In App Message Impressions
Explore the number of users that have seen an In App Message over time.
Inactive Users
Count of inactive users. Export lists of users that have been inactive to target on a different channel, such as email.
Lifespan
Explore the lifecycle of your users from install to uninstall.

Company Explore descriptions

Audience
Your current audience and their active tags.
Experiments
A/B Test performance.
Opens
Your app’s open events.
Tag Events
Tag adds and removals for users over time. Use this information to understand which user properties are increasing or decreasing.
Tags Active by Week
A count of users by active tags per week.

Exploring region events

You can explore your project’s region events using Location Looks. The following are definitions of the filters, Dimensions, and Measures used in Location Looks.

You can not explore this data using the User Locations heat map.

Filter:

Recent Activity Hours
If not selected, this filter will default to 12 hours. If multiple numbers are input, it will use the minimum number. If the filter is selected but no number is input, it will use 1 hour.

Measure:

Direct Open / Indirect Open / Send Count
The number of each event preceding the Arrival.

Dimensions:

Dwell Indicator
Indicates whether an Arrival event has been matched to a Departure event. The events must be consecutive events for the same User in the same Region within 12 hours.
Dwell Time Tier Hours
Buckets Dwells by hours. Tiers are [0,1,2,3,4,5,6]. Dwells are placed into the intervals or 6 hours+.
Dwell Time in Min Tier
Buckets Dwells by minutes. Tiers are [0,1,5,10,30,60]. Dwells are placed into the intervals or 60 minutes+.
Had Direct Open/Indirect Open/Send
For each Arrival event, we look back the number of selected hours (Recent Activity Hours) to see if that Arrival was preceded by the selected action.
Unique Regions Encountered
The number of unique regions encountered by each user, Arrival or Departure.
Unique Regions Encountered Tier
Buckets unique regions. Tiers are [0,5,10,20,40]. Users are placed into the corresponding interval or 40 Regions+.