THE PURPOSE
-To find the categories with the lowest business growth (revenue and profit) in the past 1 year
- To find the catagories need to be depriorized
- To understand the current retention performance and push new initative to boost retention rate.

DATA DICTIONARY
The look is eCommerce clothing site developed by the looker team. The dataset contains information about customers, products, orders, logistics, web events, and digital marketing campaigns. The contents of this dataset are synthetic and are provided to industry practitioners for the purpose of product discovery, testing, and evaluation.

Recommendation:
Jumpsuits & Rompers and Clothing Sets need to be deprioritized because of the low of potential growth and the worst of retention rate.
Holding promotions for old users and collaborating with a public figure to set a new trend can boost the overall retention rate.

For more detail how the query runs, you can see the answer of the purpose on picture below: