Level 2 - Question 39

Question

Build an actor property that uses the Actor Property created in question 38 and build a second Actor Property that groups users into high, medium, and low purchase volumes.

Additional Context

Build an Actor Property that uses the Label method. Set 2 values in this Actor property. Label 1 should have the value of High Purchases that looks at user actors with the Actor Property created in question 38 that is greater than or equal to 16. Label 2 should have the value of Medium Purchasers that looks at user actors with the Actor Property created in question 38 that is less than 16 and user actors with the Actor Property created in question 38 that is greater than or equal to 10. In the if not one of the above, then the value should be set to Low Purchases. Name the Actor Property and save it.

Take Note:

Nested Actor Properties are very helpful when you need to add an additional layer of logic, just like in math problems, or multiple select statements in SQL. In this case, we’re taking an actor property that already has the logic of finding out how many purchases users have, and then using it in a second property to define static thresholds related to the purchase behavior uncovered in the first.

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*