Question

Build an event property that groups device types into people who use Google tools (android, chrome), people who use Apple tools (iPhone, iPad, safari), and everyone else.

Additional Context

Build an Event Property that groups device types into people who use google device types (android, chrome) people who use Apple device types (iPhone, iPad, safari), and everyone else. Using the Event Property builder build a new event property using the label method. This Event Property will have 2 labels. Label one should have the value of Google Tools that has events with device_type that matches Android or Chrome. Label 2 can have the value of Apple Tools that has events with device_type that matches iPhone, iPad, and safari. On the bottom in "if not one of the above, then the value is" Other Tools, filtered to all events. Name this EP and save it.

Take Note:

Event properties are great for cleaning up or building new definitions against existing data inside your data sets. This example simply groups users based on device type into a larger parent category. This sort of logic can be applied to anything inside your data, age brackets, regions inside the united states or world, and version control for product releases (14.1, 14.2, 14.3 can all be v14 for example).

Solution

Note: The numbers and result do not need to be an exact match as the data changes over time. The query construction is what is most important. See images below.

*Click to enlarge*