Percentage of First Time Buyers

Hello! I know there are a lot of questions about analyzing first-time buyers... what I'm trying to figure out is how I would build a dashboard to analyze the makeup of a particular performance or season: how many first-time buyers vs. returning visitors. Does anyone currently do something like this? And if so could you share your dashboard or setup? Thank you!!

Edited to add I'm hoping there's a non-SQL way to get there :)

Parents Reply
  • Hi all --

    Anh Le -- I created this same dashboard, however, if I'm understanding the formula correctly there's nothing to limit the returning buyers in the same year they first purchased, correct? For example someone could have came for the first time in the 2019 Spring Season, but then returned for the first time in the 2022 Spring season, they would be flagged as a 22 returning buyer, correct? 

Children
No Data