163. Introduction to mobile apps

So far when we talked about product analytics we’ve talked mostly about Bindle’s website. The world of mobile apps has a set of drastic differences from the web:

• one need to go to the AppStore. It’s a whole different website and we can’t simply use our own web analytics there.
• one need to download the app to use it. It doesn’t guarantee a signup though
• apps don’t really have a concept of URL. That’s a fundamental difference between web pages and app screens.

These are huge differences . The mobile signup funnel is at least a couple of steps longer than on the web. That’s totally OK though, creativity comes from limitations and now, as we’ve learned the rules of the mobile world, let’s start our first analysis.

Users with mobile app

Remember, in the very beginning of the course, when Bindle launched their website, the first question we asked ourselves was “How many signups do we have?”. Same thing comes to mind when we launched the mobile app. How many users are actually using our app?

To answer this question we need to look at a brand new table in Bindle’s warehouse – devices.

SELECT *
FROM devices

To understand the data model behind this table let’s make a thought experiment. Imagine someone signs up via the Bindle website. When user clicks a “Signup” button the backend of Bindle website will always know that this user is using a browser to signup.

During the signup process a new record inside users table will be created. Additionally, we’ll create a new record inside devices table with device_type equals to browser and connected_at (datetime field) equals to the timestamp of a signup. In case of a browser signup the version column will contain a value of browser’s User Agent.

If a web user installs the iPhone app – a new record will be added to devices table with device_type iphone and connected_at field equals to the timestamp of a login via the app (this is where we know the user_id). The version column for iPhone device contains an iPhone version and iOS version separated by comma.

For each user there’s at least one record in devices table, added when user signs up. Later if user “connects another device” (installs the app, for example) new record with later connected_at column will be added.