Question

Building off of question 23 that returns the minimum timestamp of purchase events for users. Round those timestamps to day. Return the userids and their timestamps.

Additional Context

Build a query in Explore that uses table view that will return the Minimum value of timestamp filtered to action that matches purchase, starting 14 days ago and ending now. Split the query by user actors and =ROUND_TO_DAY([timestamp]).

Solution

Note: The numbers and result does 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*