Custom queries and reference for the Audience with Attributes Explore

You can view your users’ current and past device propertyInformation about a channel, such as language and time zone settings, OS and browser versions, and notification opt-in status. Values come from the user’s device when an SDK is present, or are set via the API for channels without one. Each property is automatically made available as an attribute, a tag, or both for audience segmentation. tags and attributes.

Data availability depends on your Performance Analytics plan.

Navigation

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, Dimensions, and Measures you can use to explore your data. To see their definitions, hover over an item, then select the info icon ().

Field categories in the Audience with Attributes Explore:

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:

Building custom queries

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

• How many mobile users can I reach with a push notificationA message that can appear on any screen on a mobile device. Push notifications appear as banners.? And how many with Email or SMS? Is my audience growing?
• Within a tag groupAn array of tags that you can associate with both channels and named users., which tag do users subscribe to the most? Among these users, how many opted out of push notifications?

Determine 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.

Find 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.