How to Report on Application, Client, and Device Distribution

When reporting on your recipients and their data, you might want to gain an insight into the types of devices, applications, or clients a recipient uses to access your emails.

This data is available in the form of three Fixed Person Data fields, which are as follows:

• LAST_USED_APP_FOR_EMAIL
• LAST_OPEN_CLIENT
• LAST_OPEN_DEVICE

The above Person Data fields only show the most recently used application, client, or device by the recipients.

These Person Data fields can have a series of values, as specified below.

Table 1: Fixed Person Data fields saving which application, client, or device a recipient most recently used to open an email with

There are numerous ways to report on these Person Data fields. Simply include them when creating a report or creating a Target Group and adding Conditions.

To give some examples, we will walk through two methods in which you can report on these Person Data fields.

• Completing three pie chart reports for an overview of the current popularity of different devices, applications, and clients.
• Exporting all recipients with a value in either LAST_USED_APP_FOR_EMAIL, LAST_OPEN_CLIENT, or LAST_OPEN_DEVICE to analyse the data externally.

How to Report on Application, Client, and Device Distribution with Pie Charts

If you create three pie charts with the Fixed Person Data fields mentioned above, you will get an overview of the most popular applications, clients, and devices across your instance.

1. Log in to Production.
2. Open the Reports module.
3. Create a new Dashboard or navigate to an existing Dashboard.
4. Create a new report.
5. Fill in a name for your report in the 'Name' field.
6. Under 'Select Data' choose 'Person Data'.
7. Drag one of the three Fixed Person Data types to the 'Selected Data' area.
8. Under 'Report Types, select 'Pie Chart'.
9. Check the checkbox for 'recipients with non-empty values'.
10. Click 'Refresh'.
11. Save your Report.
12. Repeat steps 1 to 9 to create pie charts for the two other Person Data fields.

Now, you've created three pie charts to report on the popularity of applications, clients, and devices recently used to access your emails.

A report showing a pie chart of how many recipients last used mobile or desktop to open an email

How to Export Recipient Data on the Application, Client, or Device Most Recently Used to Open an Email With

1. Log in to Production.
2. Open the Reports module.
3. Create a new Dashboard or navigate to an existing Dashboard.
4. Create a new report.
5. Under 'Select Data', choose 'Person Data'.
6. Drag all three Fixed Person Data to the 'Selected Data' area.
7. Select the Report Type 'Recipients Export'.
8. Click 'Refresh'.
9. Click the 'Recipient Export' button.
10. A new window will appear where you can drag the three Person Data fields to the 'Selected Data' area along with any other Person Data fields you want to include in your export.
11. Click the 'Export' button.
12. Your export will save locally on your computer.

Now, you've exported all recipients who have a value in either LAST_USED_APP_FOR_EMAIL, LAST_OPEN_CLIENT, or LAST_OPEN_DEVICE. The data is now ready for you to analyse externally.

A Recipient Export where you're ready to export all recipients who have a value in LAST_USED_APP_FOR_EMAIL, LAST_OPEN_CLIENT, or LAST_OPEN_DEVICE. The export will include the recipient's data for all the Person Data fields in the 'Selected data' area.

Suggested Next Steps

• Understanding Reports
• How to Create a Report
• Understanding Data Import/Export