Understanding app activity tables

When an Actito app is set up in a license, two App Activity tables are automatically created:

One for known app activities, linked to the existing profile table.
One for anonymous app activities, linked to a newly created anonymous profile table.

The tables follow this naming convention:

App activities are stored in the appropriate table depending on whether they are identified or anonymous:

Identified app activities: 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 app activities: 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.

tip

When an identified user is created, his app activity will be copied from the corresponding anonymous App Activity table.

Viewing app activities information

App Activity tables information

For each app activity, you have access to the following information:

First installation: the moment where the mobile app/website was first installed
First open: the moment where the mobile app/website was first opened
State of installation (isInstalled): if the mobile app is still installed or not
Last close: the moment where the mobile app/website was last closed
Last installation: the moment where the mobile app/website was last installed
Last session duration (in seconds): the duration in seconds of the user's last session in the mobile app/website
Last upgrade: the moment of the last upgrade of the mobile app/website
Profile id (profileId): the id of the profile linked to the app activity

tip

You have the possibility to use all the information contained in these tables in your targeting.