Recipe Overview
- This template/recipe is for stores, such as apparel brands, that manage customers seasonally.
- Distinguish customers as "new" or "repeat" based on whether they made purchases before the start of each season.
- Further segment customers into those who made multiple purchases within the season and those who made only one purchase.
How to Use
- Real-Time Management: Create this segment group before each season starts to manage seasonal progress in real time.
- Historical Comparison: Create data for past seasons under the same conditions to evaluate the current season’s progress.
- Maximize Sales: Implement targeting strategies for customer segments with only one purchase within the season to maximize sales.
- Product Analysis: Analyze which products are purchased by customers who made multiple purchases within the season using insights such as "most purchased products."
- Post-Season Review: Use insights to analyze data from each segment after the season ends to plan merchandising strategies for the same season next year.
Segment Settings [23AW Season]
Listed in the order created in ECPower. In ECPower, segments are displayed in descending order by creation date (as of June 2024).
🌎 All Customers
- Segment Name: 🌎 All Customers
- Description: All customers.
- Condition Settings: Customers with a total purchase count (F) of 1 or more.
- Tips: The following relationship holds:
- 🌎 All Customers = 🔥 23AW New Customers + 🏅 23AW Repeat Customers + 👻 23AW Non-Purchasers
Create this segment in ECPower
👻23AW Non-Purchasers/No Previous Season Purchase
- Segment Name: 👻 23AW Non-Purchasers/No Previous Season Purchase
- Description: Customers who did not purchase in the 23AW season and did not purchase in the previous 23SS season.
- Condition Settings: Customers whose last purchase date is on or before March 31, 2023.
Create this segment in ECPower
👻23AW Non-Purchasers/Previous Season Purchasers
- Segment Name: 👻 23AW Non-Purchasers/Previous Season Purchasers
- Description: Customers who did not purchase in the 23AW season but made purchases in the previous 23SS season.
- Condition Settings: Customers whose last purchase date is between April 1, 2023, and August 31, 2023.
Create this segment in ECPower
👻 23AW Non-Purchasers
- Segment Name: 👻 23AW Non-Purchasers
- Description: All customers who did not purchase in the 23AW season.
- Condition Settings: Customers whose last purchase date is on or before August 31, 2023.
- Tips: The following relationship holds:
- 👻 23AW Non-Purchasers = 👻 23AW Non-Purchasers/Previous Season Purchasers + 👻 23AW Non-Purchasers/No Previous Season Purchase
Create this segment in ECPower
🏅 23AW Repeat Customers/2+ Purchases
- Segment Name: 🏅 23AW Repeat Customers/2+ Purchases in Season
- Description: Customers who existed before the 23AW season and made 2 or more purchases during the 23AW season.
- Condition Settings: Customers with purchases on or before August 31, 2023, and a total purchase count (F) of 2 or more, with purchase dates between September 1, 2023, and March 31, 2024.
Create this segment in ECPower
🏅 23AW Repeat Customers/1 Purchase
- Segment Name: 🏅 23AW Repeat Customers/1 Purchase in Season
- Description: Customers who existed before the 23AW season and made 1 purchase during the 23AW season.
- Condition Settings: Customers with purchases on or before August 31, 2023, and a total purchase count (F) of 1, with purchase dates between September 1, 2023, and March 31, 2024.
Create this segment in ECPower
🏅 23AW Repeat Customers
- Segment Name: 🏅 23AW Repeat Customers
- Description: Customers who existed before the 23AW season and made purchases during the 23AW season.
- Condition Settings: Customers with purchases on or before August 31, 2023, and a total purchase count (F) of 1 or more, with purchase dates between September 1, 2023, and March 31, 2024.
- Tips: The following relationship holds:
- 🏅 23AW Repeat Customers = 🏅 23AW Repeat Customers/1 Purchase in Season + 🏅 23AW Repeat Customers/2+ Purchases in Season
Create this segment in ECPower
🔥 23AW New Customers/2+ Purchases
- Segment Name: 🔥 23AW New Customers/2+ Purchases in Season
- Description: New customers in the 23AW season with 2 or more purchases.
- Condition Settings: Customers whose first purchase date is between September 1, 2023, and March 31, 2024, with a total purchase count (F) of 2 or more, and purchase dates between September 1, 2023, and March 31, 2024.
Create this segment in ECPower
🔥 23AW New Customers/1 Purchase
- Segment Name: 🔥 23AW New Customers/1 Purchase in Season
- Description: New customers in the 23AW season with 1 purchase.
- Condition Settings: Customers whose first purchase date is between September 1, 2023, and March 31, 2024, with a total purchase count (F) of 1, and purchase dates between September 1, 2023, and March 31, 2024.
Create this segment in ECPower
🔥 23AW New Customers
- Segment Name: 🔥 23AW New Customers
- Description: All new customers in the 23AW season.
- Condition Settings: Customers whose first purchase date is between September 1, 2023, and March 31, 2024, with a total purchase count (F) of 1 or more, and purchase dates between September 1, 2023, and March 31, 2024.
- Tips: The following relationship holds:
- 🔥 23AW New Customers = 🔥 23AW New Customers/1 Purchase in Season + 🔥 23AW New Customers/2+ Purchases in Season
Create this segment in ECPower
🌎 23AW Season Purchasers
- Segment Name: 🌎 23AW Season Purchasers
- Description: All customers who made purchases in the 23AW season.
- Condition Settings: Customers with a total purchase count (F) of 1 or more and purchase dates between September 1, 2023, and March 31, 2024.
- Tips: The following relationship holds:
- 🌎 23AW Season Purchasers = 🔥 23AW New Customers + 🏅 23AW Repeat Customers