Exploring Performance Analytics data

Learn how to 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, such as 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 select the three dots icon (), 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.

Explore view sections:

SectionDescription and actions
SidebarAt the top is the Explore name, followed by a search field for filters, 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.

FiltersUse this section to configure the filters in the query.

You add filters by selecting the filter icon () for a Measure or Dimension in the sidebar. Select the plus icon () or the "X" icon () 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, select the box for Custom Filter to expose the entry field.

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

VisualizationThe 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, or Single Record.

To view the data in another format, select an icon in the Visualization section header. Hover over an icon to see its label. You may need to select the three dots icon () to expose all options. Select Edit for options specific to the current format.

Some Visualization types may be incompatible with the currently selected Dimensions and Measures.
DataThis 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.

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

  • From a Look, hover and select three dots icon (), then hold down Ctrl (Windows) or Command ⌘ (Mac) on your keyboard and select Explore from here.
  • From the Explore glossary, select the three dots icon () 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, then Performance Analytics, and then select the Messages Dashboard.
  2. For the Messages Look, select the three dots icon (), and then select Explore from here.
  3. In the sidebar, select Message Metrics, then Measures, and then In-App Impression Metrics.
  4. Select the filter icon () next to:
    • In-App Impression Rate
    • In-App Dismissed User Rate
  5. Select Run.

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

Explore definitions

When exploring a Look, the top of the sidebar lists the name of the Explore used as its base query. There are two categories of Explores:

App Explores

Descriptions of app Explores:

Active Users
Count of the active users in your app.
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 also Custom Events.
Custom Events
User-level behavioral events. Understand how people are interacting with your content. See also Custom Events.
A/B Test push notifications.
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.
Explore the lifecycle of your users from install to uninstall.

Company Explores

Descriptions of company Explores:

Your current audience and their active tags.
A/B Test performance.
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.

Predefined Explores

In addition to being able to see which Explore was used as the base query for a Look, Airship provides predefined Explores you can use to build custom queries. To access them:

  1. Go to Reports, then Performance Analytics.
  2. Select the folder icon (), then Shared.
  3. Under Looks, select Explore Glossary (Explore Glossary EUCS for EU customers).
  4. To open one in the Explore view, select its name and then Navigate to Explore.

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

ExploreData queriedReference
Audience with AttributesCurrent user Device PropertiesMetadata representing the default attributes and property tags of a device, such as language and time zone settings, OS and browser versions, and notification opt-in status. Device properties are used for audience segmentation. The data used for the tags and attributes is collected automatically from the Airship SDKs, and are updated daily., TagsMetadata that you can associate with channels or named users for audience segmentation. Generally, they are descriptive terms indicating user preferences or other categorizations, e.g., wine_enthusiast or weather_alerts_los_angeles. Tags are case-sensitive., and AttributesMetadata used for audience segmentation and personalization. They extend the concept of Tags by adding comparison operators and values to determine whether or not to target a user, helping you better evaluate your audience. (except JSON Attributes)Not yet published
Cohort AnalysisDefines a cohort, cohort timelines (users who install per week), and a metric to track (retention by month)Not yet published
Device EventsApp sessions (Open events), Web sessions, installs, and uninstallsNot yet published
Custom EventsCustom EventsEvents that indicate that a user performed a predefined action, such as adding an item to a shopping cart, viewing a screen, or clicking an Unsubscribe button. Custom events can trigger automation, including Sequences, Scenes, and Surveys. You can code them into your app or website, or send them to Airship from an external source using the custom event API. Custom events contain properties that you can use to personalize messages.Not yet published
EngagementMetrics for any and all channelsEngagement Explore custom queries and reference
ScenesScenesMulti-screen experiences that are cached on users’ devices and displayed when your users meet certain conditions within your app, such as viewing a particular screen or opening the app a certain number of times. Scenes can include survey questions or be presented as a story.Not yet published
SurveysSurveysQuestion-and-answer experiences used to collect and aggregate feedback or generate a net promoter score. They are cached on users’ devices and displayed when your users meet certain conditions within your app, such as viewing a particular screen or opening the app a certain number of times.Not yet published
SMS Mobile OriginatedMobile originated inbound SMS messagesNot yet published — See also SMS in Performance Analytics
Tag EventsAdding and removing TagsMetadata that you can associate with channels or named users for audience segmentation. Generally, they are descriptive terms indicating user preferences or other categorizations, e.g., wine_enthusiast or weather_alerts_los_angeles. Tags are case-sensitive. to/from usersTag Events Explore custom queries and reference

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 cannot explore this data using the User Locations heat map.


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.


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


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: 0, 1, 2, 3, 4, 5, 6. Dwells are placed into the intervals or six+ hours.
Dwell Time in Min Tier
Buckets Dwells by minutes. Tiers: 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: 0, 5, 10, 20, 40. Users are placed into the corresponding interval or 40+ Regions.