Appuri Documentation

Welcome to the Appuri Documentation. You'll find comprehensive guides and instructions to help you start working with Appuri as quickly as possible, as well as support if you get stuck.

Documentation

Users and User Details

The Users interface allows viewing individual users and drilling down into User Properties, property history, and user events.

The columns of the Users page are User Properties. Which columns are visible on the Users page can be adjusted by the Column picker, on the top right corner. Additionally on the Users page, Calculated Columns can be created.

Interacting with Users screen

The main content on the Users page is the list of users. This list will continue to load additional rows of Users as you scroll. As mentioned, each column is a User Property, and these columns can have their visibility toggled on or off on the column toggle sidebar, available on the top right.

The count of users is also on the top right. You can download a CSV list of users by clicking the download button. The number of users here will change as new users sign up, or as you filter down the Users on this page.

There are three ways to filter users, and one way to sort users. First, and most simply, you can apply any existing Segment to the Users screen, and only users who belong to that segment will be present. Next, you can filter each User Property by turning on the filters UI by clicking the funnel button on the top right. Now, on each column you can filter one or more columns and only matching users will be present.

What are User Properties?

Each column is a User Property. User Properties are values set on a per user basis. This means that each user will have their own values for each property. A property which has never been set for a given user will have a value of null and will be blank on the Users screen and not present on the User Details screen.

How do I know if it's a property or an event?

If you can say "A user has ...", then it is a property. If you can say "A user did..." then it is an event.
User has an age. This is a property.
User has a balance. This is a property.
User did log out. This is an event.

Common User Properties include

  • Unique identifiers – UDID, email, name, phone number, display name, address, etc
  • Categorical properties – Language, country, region, state, city, etc
  • Source information – campaign, referral, reseller used, mobile platform, etc
  • Monetization status – total purchases, monetized vs unmonetized, subscription status, trial status, payment type, etc
  • Aggregated information – Feature usage, velocity of usage, KPIs, activity in last 30 days, virtual currency amount, etc
  • Progress – total number of sessions, game progression, friends invited, character level, etc

Some of these values are expected to be set once and never updated (UDID, referral) others may be updated rarely (country, email) and some may be updated regularly (activity in the last 30 days, total purchases). The displayed value is always the most current value, and will remain until it is updated with newer information.

Filter options by data type

User Properties can be different data types. Different data types can be sorted and filtered slightly differently.

Data type
Examples
When Sorted
Options when Filtered
Can be used as a KPI?

Number

10,122 or .009

Sorts from highest to lowest, or lowest to highest

Equals Does Not Equal Greater Than Less Than Is Set Is Not Set Above Percentile Below Percentile

Yes

Percentile

42% or 100%

Same as Number (see above)

Same as Number (see above)

Yes

Currency

$1,200 or $4.99

Same as Number (see above)

Same as Number (see above)

Yes

Boolean

true, false or yes, no

Groups by values

Is True Is False Is Set Is Not Set

No

String

info@appuri.com or John called on Oct 1st

alphabetical from A to Z or alphabetical from Z to A

Equals Does Not Equal Contains Does Not Contain Starts With Is Empty Is Set Is Not Set

No

datetime

Sep 23, 2016 4:07 PM

Sort from earliest to latest, or from latest to earliest

After Before Within Last`Equals Does Not Equal Is Set Is Not Set

No

How to differentiate a number from a string

In Appuri, if a field is set to a number, it will include a comma seperating the hundreds place from the thousands place. Thus a user may have a credit balance of 12,244 (Number) and an id of 15333 (String)

User Details

Clicking on each user will bring up the User Details screen. User Details allows you to dive deep on a single user. User Details has all of a user’s properties and events. There are 3 sections to the User Details screen.

First, the top section is for pinned KPIs.
Next, the left section is for User Properties.
Last, the right section is for user events.

Pinning KPis

In the top section, any user property can be pinned. If the user property is a number, percentage, or currency it will show the current value and start building a chart with the historic values of this value as it changes over time. If the user property is a datetime, string, or boolean, Appuri will show the current value.

User Properties

In the left section, User Properties are listed. By hovering over a property, it can be pinned to the top section for every time you come to the User Details page for any user. If you hover over a user property, you may also see a clock symbol if the property has changed at least once for this user. Clicking on the clock symbol will bring up the history of this event property, the dates and updated values. Thus, the history of the property can be seen. If you have many user properties, you can search to find the property you are looking for.

If a user has never had a property set, it will not be present in this user property list.

User Events

In the right section, user events are listed in reverse chronological order, so that newest events are at the top. Each event has 3 values shown by default, first the timestamp associated with the event, second the category of the event (such as the source reporting the event), and lastly the event name. Events from different sources associated with this user will all be present here.

Clicking on any event will reveal event properties, which are per-event specific name/value pairs. For example an event may have a category of stripe payments, an event name of purchase complete, with user properties of amount : 19.99, currency : usd, and type : credit card whereas another event for the same user may have a category of application, an event name of log in with event properties of url : www.example.com/login , name : Leeroy Jenkins, operating system : Windows 10.

Creating new User Properties out of User Events, Event Properties and existing User Properties

User Properties can be set from within a data source, but this often requires code changes and won’t be retroactive, meaning only future users or returning users will have these new user properties set.

There are several advantages User Properties have over Event Properties. User Properties can include aggregates such as the Lifetime Value (LTV) of a customer, the total number of purchases, or average purchase size, or number of events of a specific type in the last 30 days. All of these examples include aggregating multiple User Events into a single User Property.

Additionally, User Properties are visible on the Users page and can be used for filtering, the historic values of user properties are recorded, numeral user properties can be used in KPIs, and User Properties can be used in more ways when defining Segments

There are two ways within Appuri to create new user properties.

  • Create a Calculated Column to use excel-like functions (basic to intermediate users)
  • Create a Job or Query to define a new user property (advanced users)
  • Using either of the above methods can create new user properties visible on both the User Details and Users screen.

What's Next

Create groups of users based on who they or what they have done

Segmenting your Users
Cohorts and Retention Analysis
Calculated Columns
Accounts and Account Details

Users and User Details