Regork: Future Growth Analysis

Introduction

In this study, we utilize Regork’s completejourney dataset, consolidating information across dataframes to enable a comprehensive performance analysis.

Our focus compares coupon redemption behaviors between households with and without children—an essential demographic contrast for targeted promotions. Understanding differences in preferences and purchase drivers between these groups can inform customer-centric marketing. Therefore, drive more effort into the right segment of our coupon campaign and allocate resources toward tailored messaging and offerings that resonate with each audience.

Data Processing

Packages

  • completejourney
  • dplyr
  • ggplot2
  • ggrepel

The code consolidates multiple datasets to enable a comprehensive analysis. It inner_joins the coupons, campaigns, products, transactions, demographics, and coupon_redemptions dataframes.

The columns used for this report in the final merged dataframe include:

  1. “product_type”
  2. “campaign_id”
  3. “product_id”
  4. “household_id”
  5. “kids_count”
  6. “age”
  7. “income”
  8. “redemption_date”
  9. “coupon_upc”
  10. “quantity”
  11. “sales_value”
  12. “transaction_timestamp”

Demographics

This section provides a demographic analysis, specifically investigating coupon redemption behavior between households with children versus those without. The initial visualization compares total coupon redemptions between these two household types in order to determine if having children impacts overall coupon usage patterns.

  • Total Coupon Redemptions by Household

We merge several datasets include: ‘coupons’, ‘campaigns’, ‘products’, ‘transactions’, ‘demographics’, inner_join() them by their common ID. We mutate() a new variable named has_kids, which categorizes households as “With Kids” or “Without Kids” based on the presence of children indicated by the ‘kids_count’.

This visualization provides insights into the difference in coupon redemptions between households with and without kids, facilitating further exploration into the performance of various departments and products within each demographic group.

## # A tibble: 2 × 2
##   has_kids     total_redemptions
##   <chr>                    <int>
## 1 With Kids               395859
## 2 Without Kids            659828

  • We can see that households without kids have a significantly higher total coupon redemption value, surpassing 600,000, compared to households with kids, which stand around 400,000. This suggests that households without kids are more actively engaged in redeeming coupons compared to those with kids.

  • Coupon Redemptions Across Age Groups

The analysis then examines coupon redemption behavior across age groups of households with and without children.

  • For household with kids, the age group spanning from 25 to 54 years have a similar coupon redemption amount, varies around ~110. For household without kids, the positive trend appear and peak at the age group of 45-54 with >200 redemption.

  • Further investigation into the preferences and behaviors of this age cohort could reveal insights into potential barriers or factors influencing coupon redemption in this demographic.

  • Coupon redemptionsacross income levels

This facilitates an analysis of the impact of income on coupon redemption behaviors between these household segments.

  • Interestingly, the middle-income range, spanning from $35,000 to $99,000, demonstrates a higher number of coupon redemptions across both household types. This suggests that households within this income bracket actively seek opportunities to save money through couponing, regardless of whether they have children.

Campaigns

This section analyzes marketing campaign effectiveness between households with and without children. We examine coupon usage trends, demographic distribution, temporal patterns, and most frequently redeemed products for each campaign for these two household segments.

  • Coupon redemptions across campaigns

  • It seems like Campaigns 8, 13, and 18 are the most successful based on the total coupon redemption observed in the chart. These campaigns have demonstrated higher levels of engagement and effectiveness in driving coupon redemption rates compared to others.

  • Top Campaign Timeline:

  • The visualization displays the total revenue growth for Campaigns 8, 13, and 18 over their respective time periods. The upward trajectory of the revenue lines indicates increasing coupon redemptions and consumer engagement with each campaign.

  • Overlaying the peak redemption dates reveals strategic alignment with holidays and seasonal events

    • Campaign 8 leveraged Memorial Day and Father’s Day spending.
    • Campaign 13 capitalized on Labor Day and back-to-school shopping.
    • Campaign 18 coincided with Veterans Day and peak holiday demand.

  • Total revenue between households with and without kids through each campaigns

  • We filter the merged data into specified campaigns, which the dataset is divided into two subsets: one containing data for households with kids and the other for households without kids. Subsequently, the calculated total revenue = sales value * quantity.

  • For Campaign 8, anchored around Memorial Day and Father’s Day, families drove 65% of sales. However, households without kids still contributed a significant 35% revenue share. Campaign 13, aligned with Labor Day and back-to-school shopping, achieved a balanced 50-50 split between households with and without kids. These periods typically witness heightened consumer spending, which can balance revenue distribution between households with and without kids. Campaign 18, launched for Veterans Day and peak holiday shopping, saw families overwhelmingly account for 85% of sales, while childless households contributed 15%.

Next is a list of the top products in each campaign for households with kids or not.

With kids

Campaign 8

Campaign 13

Campaign 18

Based on the graph above for household with kid, we can see the the 3 most popular products are:
1. FLUID MILK WHITE ONLY and MILK
2. YOGURT NOT MULTI-PACKS and YOGURT
3. BANANAS

Insights:
+ Prevalence of convenient frozen foods and juices shows a preference for efficient nutrition and busy meal-solutions.
+ Despite value-orientation, households indulge with premium upgrades during promotions to enhance family dining experiences.
+ Varied economy and frozen entree options highlight the critical role convenience plays with time-constrained families.
+ Specialized baby products validate a focus on age-specific offerings that cater to infant and child needs.

Without Kid

Campaign 8

Campaign 13

Campaign 18

Based on the graph above for household with kid, we can see the the 3 most popular products are:
1. FLUID MILK WHITE ONLY and MILK
2. YOGURT NOT MULTI-PACKS and YOGURT
3. BANANAS

Insights:
+ Dairy, produce, and pantry staples underscore an orientation toward everyday essentials.
+ Prevalence of frozen foods and juices signifies valuing efficiency and convenient nutrition.
+ Diverse frozen and ready-to-eat selections cater to their need for swift meal solutions.
+ Inclusions like eggs point to an interest in versatile ingredients for cooking and baking.

Conclusion

Demographics:

  • Please add in here

Campaign:

  • Both households prioritize essential staples like dairy, yogurt and bananas, indicating the fundamental role these play across segments. Similarly, frozen produce and juices reveal a collective affinity for efficient nutrition.
  • The skew towards budget frozen meals and entrees for families signifies extreme time scarcity, filling nutritional gaps with quick heat-and-eat options.
  • Certain items are unique like baby foods for household with kids or coffee creamers for household without kid.