Audience with Attributes Explore custom queries and reference

Use the Audience with Attributes Explore to understand the state of your audience by evaluating device and user data.

You can view your users’ current and past 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..

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 Audience with Attributes, 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 Audience with Attributes Explore:

CategoryDescription
AttributesSet Attribute parameters for the query.
Device PropertiesGet device property values associated with the channels at the time the report is run.
Query ParametersTarget all or specific projects, and specify dates and response windows, where relevant.
Report Over TimeAdd filters and Dimensions to report historical data.
TagsGet Tag values associated with the channels at the time the report is run
User DetailGet 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 Audience with Attributes Explore:

Filter nameField categoryUse the filter to...
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.
Current Audience OnlyReport Over TimeDetermine whether or not to return your audience's current values only. Default selection: Yes. Select No to also return historical values.

Building custom queries

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

Determining audience reach and growth

Follow these steps to view historical user counts you can use to analyze your audience evolution. You can filter by Tag, Attribute, or Device Property. In our example, we add the Device Property Filter for notification opt-ins. User counts are listed per platform.

First, open the Audience with Attributes explore, and then configure your query:

  1. Set up the filters:

    1. Leave Current Project Only set to is Yes.
    2. Set Current Audience Only to is No.
    3. In the sidebar, select Report Over Time, then the filters Number of Days, Weeks or Months to Report and Report over time by Day, Week, or Month.
       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 Number of… and Report over time… filters to the period of time you want to query.
    5. In the sidebar, select Device Properties, then Notification Opt-in Filter.
    6. Set Notification Opt-in Filter to is not null.
  2. In the sidebar, specify the values and measurement to display:

    1. Select Report Over Time, then select the Dimension Date or Month. Our example uses Date.
    2. Select User Detail, then select the Dimension Platform, then select the double-arrow 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. Select User Detail, then select the Measure User Count.

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.

Finding Tags and opt-outs

Follow these steps to find which Tags in a Tag Group users subscribe to the most and how many opted out of push notifications.

First, open the Audience with Attributes explore, and then configure your query:

  1. Set up the filters:

    1. Leave Current Project Only set to is Yes.
    2. Leave Current Audience Only set to is Yes.
    3. In the sidebar, select Device Properties, then Notification Opt-in Filter.
    4. Set Notification Opt-in Filter to is not null.
    5. In the sidebar, select Tags, then #1 Tag Group Filter. Then set it to is equal to and enter the name of the Tag Group you want to return Tags for.
    6. (Optional, to return specific tags in the filtered Tag Group) In the sidebar, select Tags, then #1 Tag Name Filter. Then set it to is equal to and enter the names of Tags in the Tag Group.
  2. In the sidebar, specify values and measurements to display:

    1. Select Tags, then select the Dimensions #1 Tag Group and #1 Tag Name.
    2. Select User Detail, then select the Measure User Count.
    3. Select Device Properties, then select the Dimension Notification Opt-in, then select the double-arrow icon next to Notification Opt-in. The pivot option adds detailed metrics for each platform and makes it more readable.

  3. In the Data header, select the Row Totals check box to display the sum of opted in and opted out channels that have each Tag.

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.