1. Home
  2. /Guides
  3. /Messaging
  4. /User guide
  5. /Data + Analytics
  6. /Performance Analytics
  7. /Exploring
  8. /Engagement Explore custom queries and reference

Engagement Explore custom queries and reference

Use the Engagement Explore to analyze the performance of your campaigns.

You can get metrics and other information about all the events associated with a message, like TagMetadata 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 AttributeMetadata 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. changes and Custom 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.. Data returned is at the user level.

Data availability depends on your Performance Analytics plan.

To access to the Explore:

  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. Select Engagement, then Navigate to Explore.

For a list of all Explores in the glossary, see Predefined Explores in Exploring Performance Analytics data.

Field categories

The sidebar lists categories for various 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. you can use to explore your data. To see their definitions, hover over an item, then select the “i” icon ().

Field categories in the Engagement Explore:

CategoryDescription
A/B TestingGet data about each variant of an A/B Test.
Attributes CurrentGet Attribute values associated with the channels at the time the report is run.
Attributes RelativeGet Attribute values associated with the channels at the time push notification or Message Center message was sent or when the in-app message was displayed.
Device Properties CurrentGet device property values associated with the channels at the time the report is run.
Device Properties RelativeGet device property values associated with the channels at the time push notification or Message Center message was sent or when the in-app message was displayed.
In-App AutomationGet configuration details about In-App Automations, such as priority, dates, and display type (layout/format).
Message ContentGet the message text and additional details, such as notification ID, title, etc. In the Dimension and Measure names, Journey means SequenceA series of messages that is initiated by a trigger. Airship sends messages in the series based on your timing settings, and you can also set conditions that determine its audience and continuation. Sequences can be connected to each other and to other messaging components to create continuous user experiences in a Journey..
Message DeliveryGet data about sends, such as dates, rates, and counts.
Message MetricsGet performance data, such as response and click rates, including bounce data for email.
Query ParametersTarget all or specific projects, and specify dates and response windows, where relevant.
Response - Custom EventsGet metrics for Custom Events associated with App direct and indirect opens.
Response - Custom Event WindowGet metrics for Custom Events associated with App direct and indirect opens that occurred within one hour of send time.

To set a new time window, go to Query Parameters in the sidebar, then select the Response Window filter and configure the filter. Fractions of an hour are accepted.

Response - Custom Event Window - Time-onlyGet metrics for Custom Events, regardless of attribution, that occurred within one hour of send time.

To set a new time window, go to Query Parameters in the sidebar, then select the Response Window filter and configure the filter. Fractions of an hour are accepted.

Response - Custom Interaction EventsGet metrics for Custom Events associated with an interaction_id.
Response - Events TimesGet metrics for App direct and indirect opens that occurred within a specific number of minutes after send time.

To set a new time window, go to Query Parameters in the sidebar, then select the Response Window filter and configure the filter. Fractions of an hour are accepted.

Response - Tag ChangesGet Tag change events that occurred within one hour of send time.

To set a new time window, go to Query Parameters in the sidebar, then select the Response Window filter and configure the filter. Fractions of an hour are accepted.

Tags CurrentGet Tag values associated with the channels at the time the report is run.
Tags RelativeGet Tag values associated with the channels at the time push notification or Message Center message was sent or when the in-app message was displayed.
Timeframe ComparisonCompare data in Measures for the most recent and prior time frames. Specify time frames in a number of days.
User DetailGet information about the channel that performed the filtered event.
User Detail - DerivedGet historical information about the channel that performed the filtered event.

Default filters

Use filters to reduce the number of records scanned and results returned. Each Explore includes filters that cannot be removed from the query.

The filter name, field category, and usage information for the default filters in the Engagement Explore:

Filter nameField categoryUse the filter to...
Message Type FilterMessage DeliveryReturn results for a specific message type. Default selection: Push Notification. Other possible selections: Message Center, In-App Impression1, Web Notification, SMS notification, Email Notification, or Multiple.

By default, Multiple returns results for all message types, which can result in longer processing time. Add the Message Type Sub Filter so you can specify individual message types. After selecting Multiple:

  1. In the sidebar, select Message Delivery.
  2. Under FILTER-ONLY FIELDS, select Message Type Sub Filter.
  3. In the Filters section, select the entry field next to Message Type Sub Filter and choose which message types to include.
Current Project OnlyQuery ParametersDetermine which projects are included in the query. Default selection: Yes. To include other projects within your company, select No, then:
  1. In the sidebar, select Query Parameters.
  2. Under Dimensions, select the filter icon () next to Project name.
  3. In the Filters section, select the entry field next to the Project Name filter and choose which projects to include.
Date RangeQuery ParametersTarget events that occurred on a specific date or within a specific date range.

1. Includes In-App Message (standard)A message that appears inside of your app. You can send in-app messages to your entire app audience, not just users who have opted-in to push notifications. and In-App AutomationMessages 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. only.

Building custom queries

The following sections walk you through using the Engagement Explore to create custom queries that answer:

  • How can I get the list of users who received a specific In-App Automation? Also, how can I determine whether they interacted with it?
  • How can I get complete metrics for the push notifications sent within the last 30 days?

In-App Automation

Follow these steps to get the list of users who received a specific In-App AutomationMessages 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. and determine whether they interacted with it. Users will be identified by Channel IDAn Airship-specific unique identifier used to address a channel instance, e.g., a smartphone, web browser, email address..

First, get the ID of the In-App Automation you want to build a query for. From your Airship project:

  1. Go to Messages, then Messages Overview.
  2. Find your In-App Automation and select the report icon () to open its message report.
  3. In the page URL, copy the section following push detail/. It should look similar to: e68039fc-7c9d-4a49-8a83-d6c8efa0cde6.

Then open the Engagement explore and configure your query:

  1. Set up the filters:

    1. Set the Message Type Filter to In-App Impression.
    2. Set the Date Range filter to the period of time you want to search in.
    3. In the sidebar, select Message Content, then Notification ID Filter.
       Tip

      Instead of navigating to filters, Dimensions, and Measures, you can find them using the search box at the top of the sidebar.

    4. Set the Notification ID Filter to is equal to and enter the notification ID you copied from the message report URL.

  2. In the sidebar, specify values to display:

    1. Select Message Content, then select the Dimensions Notification ID and Notification Name.
    2. Select Message Delivery, then select the Dimensions category Delivery Date, then Date.
    3. Select User Detail, then select the Dimension Channel ID. If you’re using Named UsersA customer-provided identifier used for mapping multiple devices and channels to a specific individual. in your project, you can also add the Dimension Named User to identify these users in your database.

  3. In the sidebar, add measurements to display:

    1. Select Message Delivery, then select the Measures category All Deliveries/Impressions, then Total Delivery/Impression Count.
    2. Select Message Metrics, then select the Measures category In-App Impressions, then In-App Button Click Count and In-App Dismissed Count. These distinguish which users interacted with the a button in the message content from the users who selected the Dismiss button to close the message.

Now you are ready to get your data. Select Run, and you should see results similar to the below image. To save your custom query for later access, follow the steps in Saving Performance Analytics queries.

Engagement Explore custom queries and reference
Creating a custom query from the Engagement Explore

Push notifications

Follow these steps to get the number of push notifications delivered over the past 30 days. We’ll use the default filters and add a filter for platform to get only data for iOS and Android.

First, open the Engagement explore, and then configure your query:

  1. Set up the filters:

    1. Leave Message Type Filter and Current Project Only set to their defaults of Push Notification and Yes.
    2. Set the Date Range filter to is in the past 30 complete days.
    3. In the sidebar, select User Detail, then Platform Filter.
       Tip

      Instead of navigating to filters, Dimensions, and Measures, you can find them using the search box at the top of the sidebar.

    4. Leave the Platform Filter set to is equal to, then select the entry field and select ANDROID and IOS from the list.
  2. Engagement Explore custom queries and reference
    Selecting the option to Pivot data

    In the sidebar, specify values to display:

    1. Select Message Delivery, then select the Dimensions category Delivery Date, then Date.
    2. Select User Detail, select the Dimension Platform, then select the pivot data icon next to Platform. The pivot option adds detailed metrics for each platform and makes it more readable. It can be helpful when using the Graph visualization.

  3. In the sidebar, add measurements to display:

    1. Select Message Delivery, then select the Measures category All Deliveries/Impressions, then Total Delivery/Impression Count.
    2. Select Message Metrics, then select the Measures category Push Metrics, then Attributed Open Count.

Now you are ready to get your data. Select Run, and you should see results similar to the below image.

Engagement Explore custom queries and reference
Creating a custom query from the Engagement Explore

Next, select the down arrow icon () next to Visualization and select the column icon (). Use this format to look for obvious gaps or other changes to help you identify if something is going wrong with your push delivery:

Engagement Explore custom queries and reference
The column visualization of a custom query from the Engagement Explore

To save your custom query for later access, follow the steps in Saving Performance Analytics queries.