In February, 2018 Bindle successfully launched their iOS app.
It was an important strategic move to step into a mobile market. Itâs so clear nowadays that people read not just in front of their laptop but also during commute, while waiting in a line etc.
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:
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.
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.
Hi, itâs Anatoli, the author of SQL Habit.
SQL Habit is a course (or, as some of the students say, âbusiness simulatorâ). Itâs based on a story of a fictional startup called Bindle. Youâll play a role of their Data Analyst and solve real-life challenges from Business, Marketing, and Product Management.
SQL Habit course is made of bite-sized lessons (youâre looking at one atm) and exercises. They always have a real-life setting and detailed explanations. You can immediately apply everything youâve learned at work.