I am grouping users by their earliest event (Month) .I first apply group by users and see the first time of their event then again apply group by [month],and count the number of users.I want to show total money spent by those users in that month.How do i do that,considering amount spent is user property?Can I join two queries?
Best answer by ian
You’re almost there! You can do a join() function on Events() and People() which will allow you to link the user props with the event props (on distinct id).
That said, I have two follow-ups:
- The amount spent being a user property will show the total amount spent and not the amount spent for a specific month. User properties show the current state and unless you have separate properties for each respective month or have the spend amount attached to an event as an event property, then your query won’t get you the monthly spend.
- Have you checked out our first time ever filter? You can check out the doc here but you can essentially apply this filter on Insights and break it down by Date (month) and then by the Spend amount.