Understanding devices tables
When a push integration is set up in a license, two Devices tables are automatically created:
- One for known devices, linked to the existing profile table.
- One for anonymous devices, linked to a newly created anonymous profile table.
The tables follow this naming convention:
- Known devices:
Devices - <Application name>
- Anonymous devices:
Devices - <Application name> - Anonymous
Devices are stored in the appropriate table depending on whether they are identified or anonymous:
- Identified devices: these are associated with a known profile in the profile table. This happens when a visitor logs in or registers on your website or app, making them recognizable in your database.
- Anonymous devices: these belong to users who are not identified — for example, if they are not logged in on your app or website, or are unknown in your database.
Viewing device information
For each device, you have access to the following information:
- Device id (deviceId)
- State of the subscription (is subscribed)
- Type of platform (Web, Android, iOS)
- Language attached to the device
- Moment when the device is registered
- Origin: the URL where the web push devices are registered
- Transport: the service used to deliver the push notification
- OS version of the device
- OS string of the device
- Name of the browser
- Version of the browser
- Version of the app
- Device string
- Last moment the device was active: the ISO date of the last interaction
- Region collected from the device or browser
In addition, when a device is transferred from the anonymous profile table to the identified one, 4 specific fields are updated. They are identified by the 'Moved' prefix and display information related to the original profile.
- Moved was subscribed: specifies whether the device was opted-in when it was transferred
- Moved Moment: specifies when the device was transferred, namely when the profile became identified
- Moved User Id: specifies the user id of the profile to which the device was previously associated
- Moved Profile Table: specifies the profile table in which the above user id was present
While the "Moved" attributes are especially used for transfer between the anonymous and the identified tables, they can also be useful when a device is transferred between 2 identified profiles.
Indeed, when a device is shared between different users (a computer owned by a couple, for instance), the device will be tied to the last profile who logged in the website (or app).