Export data via Performance Analytics

This article will help you to program recurring exports using Performance Analytics.

  • Export Message: get all the statistics of messages sent out the previous day.
  • Export Reaction: used to get all reactions from the previous day.
  • Export Device: used to retrieve device information for all users that opened the app the day before.

First, we will build a customized dashboard in Performance Analytics. This dashboard will be composed of several looks, one for each export.

You can also save each look independently, or save your looks directly in the appropriate dashboard. Note that you have the ability to export each look from the dashboard afterward. In our example, we will create our looks and save them into our demo dashboard.

 

Create custom dashboards

In order to create the look, click on the 4-square-icon > Shared spaces > Explore Glossary (for the US site) or Explore Glossary EUCS (for the UE site).

4.png

 

Look 1. Export Message

Description: get all the statistics of messages sent out the previous day.

To build the first look, choose Engagement in the Explore Glossary.

5.png


Then add the following filters: Query parameters date range “is in the past 1 complete days” // Message delivery Message type filter “is Multiple - Use Message Type Sub Filter // Query Parameters Current Project Only “is Yes”.


And select the following dimensions and measures: Notification ID // Notification Name // Title // Message // Workflow Type // Message Type // Campaign Category or Campaign Category List // Delivery Time // Total Delivery/Impression Count // Uninstall User Count // Attributed Response Count.

You’ll find below more information on some dimensions and measures:

  • Notification Name: applies to Automations, Journey Messages, A/B Tests and scheduled messages only. In order to identify your message on Performance Analytics, we recommend adding a campaign category when creating your message.

  • Message Type Workflow Type

    • Workflow Type indicates with which composer the message was created:

      • Automation

      • A/B Test

      • InApp Automation

      • Journey Message

      • (Standard) Message

      • Unicast

    • Whereas Message Type indicates the type of message sent:

      • Email

      • In-App Impression

      • Message Center

      • Push Notification

      • Web notification

Due to GDPR and other privacy/ security requirements, unicast message content isn’t displayed in Performance Analytics. However, responses and events linked to a unicast message are available in Performance Analytics.

As a reminder, a unicast message is sent to a Named User/ Channel ID on a one-shot basis.

In order to easily identify a unicast message, we encourage using the campaign category feature while creating a message and then select either campaign category or campaign category list as a dimension in Performance Analytics.

  • Campaign Category or Campaign Category List

    • Campaign Category: indicates the campaign associated with a notification

    • Campaign Category List: indicates all campaign categories associated with a notification in alphabetical order.

  • Attributed Response Count: count of total events (direct and indirect) associated with a notification (Direct Response Count + Indirect Response Count)

  • Total Delivery/Impression Count: count of total delivery and impression events. For InApp Impressions, this is the impressions (display) count not the delivery count. This number can be more than the User count, as this field counts the raw events and user count distinguishes individuals. 

  • Uninstall User Count: count of distinct users with uninstall events within time frame after a notification.

Finally, choose the table visualization and save your look by clicking on “Save to Dashboard” in order to create a new Dashboard (“Accengage SFTP Export” for example). You’ll then be able to add the next looks of this article to it.

 

Look 2. Export Reaction (Response)

Description: used to get all responses from the previous day.

To build the second look, stay in the Engagement section of the Explore Glossary.

Then add the following filters: Query parameters date range “is any time” // Message delivery Message type filter “is” “Multiple - Use Message Type Sub Filter // Query Parameters Current Project Only “is Yes” // Message Metrics All Messages Types - Direct Response Time “is in the past 1 complete days”.

Filtering this way will allow you to obtain the reactions of the previous day regardless of the sending date of your message.


And select the following dimensions and measures: Named User // Channel ID // Platform // Notifioncation ID // Notification Name // Message // Workflow Type // Message Type // Campaign Category ou Campaign Category List // Delivery Time // All Messages Types - Direct Response Time // Attributed Response Count // Direct Response Count // Indirect Response Count.

You’ll find below more information on some dimensions and measures:

  • Notification Name: applies to Automations, Journey Messages, A/B Tests and scheduled messages only. In order to identify your message on Performance Analytics, we recommend adding a campaign category when creating your message.

  • Message Type Workflow Type

    • Workflow Type indicates with which composer the message was created:

      • Automation

      • A/B Test

      • InApp Automation

      • Journey Message

      • (Standard) Message

      • Unicast

    • Whereas Message Type indicates the type of message sent:

      • Email

      • In-App Impression

      • Message Center

      • Push Notification

      • Web notification

Due to GDPR and other privacy/ security requirements, unicast message content isn’t displayed in Performance Analytics. However, responses and events linked to a unicast message are available in Performance Analytics.

As a reminder, a unicast message is sent to a Named User/ Channel ID on a one-shot basis.

In order to easily identify a unicast message, we encourage using the campaign category feature while creating a message and then select either campaign category or campaign category list as a dimension in Performance Analytics.

  • Campaign Category or Campaign Category List

    • Campaign Category: indicates the campaign associated with a notification

    • Campaign Category List: indicates all campaign categories associated with a notification in alphabetical order.

  • Delivery Time All Messages Types - Direct Response Time
    • Delivery Time: date and hour of message delivery
    • Direct Response Time: date and hour of message response
  • Attributed Response Count: count of total events (direct and indirect) associated with a notification (Direct Response Count + Indirect Response Count)

  • Direct Response Count: count of direct response events (Message Center Reads, Direct Opens, Web Clicks and SMS Short Link Clicks).

  • Indirect Response Count: count of indirect response events within the 12 hours following a push sending (Indirect Opens and Web Session).

 

Finally, choose the table visualization and save your look in the previously created Dashboard.

 

Look 3. Export Device

Description: used to retrieve device information for all users that opened the app the day before

For the third look, change the section of the Explore Glossary to Device Events.

6.png


Then add the following filters: Query parameters date range “is in the past 1 complete days” // Device Events Event Type Filter “is App Session” // Query Parameters Current Project Only “is Yes” // Tag Current #1 Tag Group Filter “is equal to Notification Opt-in” // Tag Current #2 Tag Group Filter “is equal to Language” // Tag Current #3 Tag Group Filter “is equal to Language Country” // Tag Current #4 Tag Group Filter “is equal to Android App Version” // Tag Current #5 Tag Group Filter “is equal to iOs App Version” // Tag Current #6 Tag Group Filter “is equal to Timezone”


And select the following dimensions and measures: Channel ID // Ad ID // Named User // Platform // Install Time // Event Time // #1 Tag Name // #2 Tag Name // #3 Tag Name // #4 Tag Name // #5 Tag Name // #6 Tag Name // App Session Count // Uninstall Count

Finally, choose the table visualization and save your look in the previously created Dashboard.

If you would like to retrieve your users' attributes, you can recover the data in the Audience with attributes Explore. In this board, you can recover up to 3 attributes per type (date, number, text).

 

Performance Analytics isn’t backdated. Therefore, data will be available only for your Airship campaigns (as long as the feature is activated for your project).

 

Export

All data in Performance Analytics can be exported in a number of formats. You can either export Looks or entire Dashboards.

Export Dashboards

To export your data:

  1. Go to Reports > Performance Analytics.

  2. Select the dashboard you want to export.

  3. Click on the gear icon in the top right-hand corner, and select how you want to download the Dashboard data.

7.png

 

Export Looks

  • If you are on a Dashboard, click the 3-dot-icon and select Download Data….

8.png
  • If you clicked the tile to open the report or opened the report from a Space, click Download Results.

See our documentation for more details on this topic.

 

Schedule reports

Both Dashboards and Looks can be scheduled to be exported. There are many options to schedule the exports to fit your need.

You can configure:

  • Destinations (Email / Webhook / Amazon S3…)

  • Format (CSV / JSON / TXT / PNG…)

  • Values (Unformatted / Formatted)

You can send a report if there are results. But you can also send a report if there are no results. This works in both cases. There is even an option that lets you receive emails when the filters of your report are met or not met.

Additionally, you can choose to trigger a report if the results have changed since the report was last exported.

See our documentation for more details on this subject.

Was this article helpful?
0 out of 0 found this helpful
Submit a request