In the Bindle’s data warehouse all users’ devices are stored in the devices table.
Bindle PMs want to explore what will be the potential reach for a push notification campaign. To answer this we can simply calculate all users who have iPhone devices (to be precise: we’ll calculate the max reach, since some users may changed phones, stopped using Bindle or simply turned off notifications).
The device type is stored in the
version column of the
Devices that use Bindle’s mobile app have
version in this format: iPhone 7 Plus,12.3.1.