EN - How to replicate Accengage SFTP on the Airship Platform

Ce contenu est également disponible en français.

 

You’ll find in this article our recommendations to reproduce the SFTP exports from Accengage in Airship. Statistics reports for Airship are generated in our tool called Performance Analytics. If you want to learn more about this tool, you can start by reading our Introduction to Performance Analytics.

If Performance Analytics is not available in your dashboard, please contact your Account Manager.

Accengage

With the Accengage platform, the following reports were available through SFTP:

  • Export Message: get all the statistics of messages sent out the previous day.

1.png
  • Export Reaction: used to get all reactions from the previous day at the device level (user level).

2.png
  • Export Device: used to retrieve device information for all users that opened the app the day before.

3.png

 

Airship

To reproduce these reports in Airship, we will build a customized dashboard in Performance Analytics. This dashboard will be composed of several looks, one for each section of the Accengage 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 // Campaign Category // Campaign Category List // Delivery Time // Total Delivery/Impression Count // Uninstall User Count // Attributed Response Count.

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)

A reaction in Accengage is called response in Airship.

Description: used to get all responses from the previous day at the device level (user level)

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

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

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.

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