We are tasked with identifying a potential area of growth for Regork, a national grocery chain, aiming to enhance revenue and profits. Our approach involves analyzing market trends, consumer behavior, and internal performance data to pinpoint opportunities.
Recent trends in the grocery sector, highlighted by an insightful analysis of Kroger’s Digital Coupons Page by 84.51°, demonstrate a clear consumer shift towards value-seeking behaviors amidst economic pressures. Key findings include a significant 15% increase in site visits to Kroger’s Digital Coupons page between May and June 2022, and a stark consumer concern about inflation, with 71% expressing extreme worry over rising prices (O’Connell, 2022). These trends underscore a broader movement towards frugality and strategic shopping among consumers, setting the stage for grocery chains like Regork to rethink their promotional strategies and inventory management in alignment with evolving consumer preferences.
In light of these trends, our investigation focuses on:
How can Regork leverage insights from coupon redemption and sales seasonality to improve store performance and inventory management?
This focus paves the way for a deep dive into the data, promising to reveal patterns that could refine the timing and effectiveness of coupons. By examining how coupons influence sales throughout the year, we aim to identify opportunities for boosting sales in slower months and assess the potential impact of coupons on sales, thereby informing smarter inventory and coupon strategy adjustments.
Utilizing exploratory data analysis (EDA), we delve into coupon redemption rates and sales volumes, alongside seasonal trends and product category changes across stores, to offer Regork actionable insights for targeted marketing and optimized inventory planning. The goal is to inform the timing of coupon releases to invigorate sales during slower periods and ensure inventory levels meet anticipated demand patterns, thereby reducing wastage and bolstering profitability.
Through this focused analysis, our goal is to provide the CEO with a clear understanding of the impact and potential of coupon campaigns, particularly how they influence households that frequently use coupons. By extracting insights into which stores these households visit most often, we can better monitor and plan inventory in anticipation of coupon issuance. This approach enables us to align our promotional strategies more closely with consumer behavior, ensuring optimal stock levels and enhancing the overall effectiveness of our coupon campaigns.
library(tidyverse) # Tools for data manipulation and visualization.
library(completejourney) # Provides dataset for this project.
library(dplyr) # Advanced data frame manipulation.
library(lubridate) # Simplifies date and time manipulation.
library(ggplot2) # Static, aesthetic data visualizations.
library(ggrepel) # Prevents text overlap in plots.
For this R project, data is sourced from the CompleteJourney website, encompassing grocery shopping transactions of 2,469 households. This dataset, spanning from January 2017 to December 2017, includes comprehensive details on transactions, demographics, products, coupons, and marketing campaigns among other entities.
# Load the transaction and promotions datasets
transactions <- get_transactions()
promotions <- get_promotions()
# Inner join all the datasets in the completejourney package
full_df <- transactions %>%
inner_join(promotions) %>%
inner_join(demographics ) %>%
inner_join(products) %>%
inner_join(coupon_redemptions) %>%
inner_join(coupons) %>%
inner_join(campaign_descriptions) %>%
inner_join(campaigns)
full_df
# Add the transaction_id column to the transactions dataset
transactions <- transactions %>%
mutate(transaction_id = row_number()) %>%
select(transaction_id, everything())
transactions
# Join the transaction with the demographics and products datasets
transaction_details <- transactions %>%
left_join(demographics) %>%
left_join(products) %>%
mutate(transaction_date = as.Date(transaction_timestamp)) %>%
mutate(month = month(transaction_date)) %>%
select(transaction_id, transaction_date, everything())
transaction_details
# Count the number of unique households in the transaction_details dataset
households_count <- transaction_details %>%
select(household_id) %>%
distinct()
households_count
# Group the transaction_details dataset by household_id, month, and week, and calculate the total sales
households_total_Sales <- transaction_details %>%
group_by(household_id, month, week) %>%
summarise(total_sales = sum(sales_value)) %>%
select(household_id, month, week, total_sales)
households_total_Sales
# Use the coupon_redemptions dataset to count the number of unique households that redeemed coupons
households_redemptions_count <- coupon_redemptions %>%
select(household_id) %>%
distinct()
households_redemptions_count
# Calculate the total sales for each household that redeemed coupons
each_households_redeemed_total_sales <- transaction_details %>%
inner_join(households_redemptions_count) %>%
group_by(household_id, month, week) %>%
summarise(total_sales = sum(sales_value)) %>%
arrange(household_id)
each_households_redeemed_total_sales
# Inner join the campaigns and campaign_descriptions datasets
coupon_offer <- campaigns %>%
inner_join(campaign_descriptions) %>%
inner_join(coupons)
coupon_offer
# Transaction date falls within the start and end date of the coupon offer
coupon_transaction_match <- coupon_offer %>%
inner_join(transaction_details, by = c("household_id", "product_id")) %>%
filter(transaction_date >= start_date, transaction_date <= end_date) %>%
arrange(transaction_id) %>%
distinct(transaction_id, .keep_all = TRUE)
coupon_transaction_match
# Coupon redemptions match the coupon offer and transaction details
coupon_redemptions_match <- coupon_offer %>%
inner_join(transaction_details, by = c("household_id", "product_id")) %>%
inner_join(coupon_redemptions, by = c("household_id", "coupon_upc", "campaign_id")) %>%
filter(transaction_date >= start_date, transaction_date <= end_date) %>%
filter(redemption_date == transaction_date) %>%
arrange(transaction_id) %>%
distinct(transaction_id, .keep_all = TRUE)
coupon_redemptions_match
# Group the transaction_details dataset by household_id
store_id_household <- transaction_details %>%
group_by(household_id) %>%
summarise(
store_id = unique(store_id)
)
store_id_household
# Calculate the total sales for each store by month
store_sales_monthly <- transaction_details %>%
group_by(store_id, month = month(transaction_timestamp)) %>%
summarise(total_sales = sum(sales_value)) %>%
arrange(desc(total_sales))
store_sales_monthly
# Calculate the total sales for month
sales_monthly <- transaction_details %>%
group_by(month = month(transaction_timestamp)) %>%
summarise(total_sales = sum(sales_value)) %>%
arrange(desc(total_sales))
sales_monthly
# Calculate the total sales for each store
store_sales <- transaction_details %>%
group_by(store_id) %>%
summarise(total_sales = sum(sales_value)) %>%
arrange(desc(total_sales))
store_sales
# Calculate the total sales from the transaction_details dataset
total_sales_from_trans <- transaction_details %>%
summarise(total_sales = sum(sales_value))
# Calculate the total sales from the households_total_Sales dataset
total_sales_from_all_households <- households_total_Sales %>%
summarise(total_sales = sum(total_sales)) %>%
summarise(total_sales = sum(total_sales)) %>%
summarise(total_sales = sum(total_sales))
# Calculate the total sales from the coupon_transaction_match dataset
total_sales_from_all_households_redeemed <- each_households_redeemed_total_sales %>%
summarise(total_sales = sum(total_sales)) %>%
summarise(total_sales = sum(total_sales)) %>%
summarise(total_sales = sum(total_sales))
# Calculate the total sales from the coupon_transaction_match dataset
total_sales_from_coupon_transaction_match <- coupon_transaction_match %>%
summarise(total_sales = sum(sales_value))
# Calculate the total sales from the coupon_redemptions_match dataset
total_sales_from_coupon_redemptions_match <- coupon_redemptions_match %>%
summarise(total_sales = sum(sales_value))
We embark on a journey to unravel the intricacies of sales data, dissected by month and store, to unearth patterns and trends pivotal for strategic decision-making. Our analysis is structured into two distinct segments. Initially, we delve into the dynamics of coupon redemption and its repercussions on sales trends. Subsequently, our focus shifts to discerning trends related to stores and products.
Our first step involves visualizing monthly sales to detect seasonal fluctuations and peak selling periods. This foundational analysis aims to shed light on the sales landscape, revealing:
sales_monthly %>%
ggplot(aes(x = month, y = total_sales)) +
geom_line() +
geom_smooth() +
labs(x = "Month",
y = "Total Sales",
title = "Total Sales by Month",
subtitle = "The data indicates peak sales in May, July, October, November, and December,\nlikely influenced by the holiday season.",
caption = "Data Source R Package: completejourney"
) +
theme_minimal() +
scale_x_continuous(breaks = sales_monthly$month) +
scale_y_continuous(labels = scales::dollar) +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10))
The elevated sales observed during May, July, October, November, and December underscore the holiday season’s significant influence on consumer behavior, with a notable surge in the concluding quarter.
Progressing, we assess the efficacy of coupon campaigns by examining issuance and redemption patterns. This analysis is intended to decode the impact of promotional strategies on sales dynamics, revealing:
coupon_offer %>%
group_by(month = month(start_date), household_id, campaign_id) %>%
summarise(campaign_count = n()) %>%
ggplot(aes(x = month, y = campaign_count)) +
geom_col() +
labs(
x = "Month",
y = "Campaign Count",
title = "Campaign Count by Month for Each Household",
subtitle = "May, Aug, and Oct exhibit notably high counts of campaign targeting households.",
caption = "Data Source: R Package completejourney"
) +
theme_minimal() +
scale_x_continuous(breaks = seq(1, 12, by = 1)) +
scale_y_continuous(labels = scales::comma) +
theme(
plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10),
legend.position = "none"
)
The heightened campaign activity in May, August, and October suggests a strategic focus on these periods.
Our investigation extends to the redemption trends by households across different campaigns, illuminating:
coupon_redemptions_match %>%
group_by(household_id) %>%
ggplot(aes(x = household_id, y = month(redemption_date), color = campaign_type)) +
geom_jitter(width = 10) +
coord_flip() +
labs(
x = "Household",
y = "Redemption Month",
title = "Coupon Redemption by Household ID and Campaign Type",
subtitle = "High coupon redemption clusters in May, Jun, Aug, Sept, Nov, and Dec, possibly holiday-driven, \nwith Type A campaigns being most redeemed.",
caption = "Data Source R Package: completejourney"
) +
theme_minimal() +
scale_y_continuous(breaks = seq(1, 12, by = 1)) +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10),
axis.text.y = element_blank(),
axis.ticks.y = element_blank()) +
theme(legend.position = "top")
A correlation emerges between higher redemption rates during May, June, August, September, November, and December, and the observed sales peaks, hinting at the holidays’ role in driving coupon redemptions. This correlation suggests that strategic campaign planning during off-peak months could be a lever to uplift sales.
A comparative analysis of sales involving coupon redemptions versus overall transactions further quantifies coupons’ direct and indirect sales impacts:
total_sales_comparison_d <- data.frame(
Category = c("All Transactions", "Transactions with Coupon Redemption"),
Total_Sales = c(total_sales_from_trans$total_sales, total_sales_from_coupon_redemptions_match$total_sales))
total_sales_comparison_ind <- data.frame(
Category = c("All Transactions", "Transactions with Coupon Redemption"),
Total_Sales = c(total_sales_from_trans$total_sales, total_sales_from_all_households_redeemed$total_sales)
)
total_sales_comparison_combined <- data.frame(
Category = rep("Transactions with Coupon Redemption"),
Total_Sales = c(total_sales_comparison_d$Total_Sales, total_sales_comparison_ind$Total_Sales),
Impact_Type = rep(c("Direct Impact", "Potential Indirect Impact"), each = 2)
)
total_sales_for_bars <- total_sales_comparison_combined %>%
filter(Total_Sales != total_sales_from_trans$total_sales)
ggplot() +
geom_bar(data = total_sales_for_bars, aes(x = Category, y = Total_Sales, fill = Impact_Type),
stat = "identity", position = position_dodge(width = 0.8), color = "black") +
geom_hline(yintercept = total_sales_from_trans$total_sales, color = "black", size = 1) +
geom_text(aes(x = "Transactions with Coupon Redemption", y = total_sales_from_trans$total_sales,
label = scales::dollar(total_sales_from_trans$total_sales)),
vjust = -0.25, size = 3) +
geom_text(data = total_sales_for_bars,
aes(x = Category, y = Total_Sales, label = scales::dollar(Total_Sales), group = Impact_Type),
position = position_dodge(width = 0.8), vjust = -0.25, size = 3.5) +
geom_text(data = total_sales_for_bars,
aes(x = Category, y = Total_Sales,
label = scales::percent(Total_Sales / total_sales_from_trans$total_sales),
group = Impact_Type),
position = position_dodge(width = 0.8), vjust = -1.5, size = 3.5) +
labs(x = "Category", y = "Total Sales",
title = "Direct vs. Indirect Coupon Redemption Impact on Sales",
subtitle = "Despite low direct impact from coupon redemptions, households using coupons potentially\ndrive 35% of sales, indicating significant indirect impact.",
caption = "Data Source: R Package completejourney") +
theme_minimal() +
scale_y_continuous(labels = scales::dollar) +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10),
legend.title = element_blank()) +
theme(legend.position = "top")
Despite the modest direct impact, the substantial indirect influence of coupon-utilizing households, accounting for up to 35% of total sales, highlights the strategic value of well-crafted coupon campaigns.
Shifting our gaze, we now explore trends across stores and products to identify opportunities for targeted promotions and inventory optimization. Our initial focus is on pinpointing the top-performing stores:
store_sales %>%
top_n(10, total_sales) %>%
ggplot(aes(x = reorder(store_id, total_sales), y = total_sales)) +
geom_col() +
coord_flip() +
labs(
x = "Store ID",
y = "Total Sales",
title = "Top 10 Stores with Highest Sales",
subtitle = "Store 367 achieves highest sales, followed by 406 and 429",
caption = "Data Source R Package: completejourney"
) +
theme_minimal() +
scale_y_continuous(labels = scales::dollar) +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10))
This analysis not only distinguishes the frontrunners but also sets the stage for a deeper dive into their operational dynamics.
Further dissecting sales by month and store, we aim to capture the essence of monthly sales variability and consistent performers:
store_sales_monthly %>%
ggplot(aes(x = month, y = total_sales, color = store_id)) +
geom_point() +
geom_text_repel(aes(label = store_id), size = 3) +
labs(
x = "Month",
y = "Total Sales",
title = "Total Sales by Month and Store",
subtitle = "Sales fluctuate monthly; Store 367 consistently outperforms others throughout the year",
caption = "Data Source R Package: completejourney"
) +
theme_minimal() +
scale_x_continuous(breaks = seq(1, 12, by = 1)) +
scale_y_continuous(labels = scales::dollar) +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10)) +
theme(legend.position = "none")
We discover that store 367 consistently outperforms others throughout the year.
Identifying stores with significant household footfall unveils potential hotspots for focused marketing and stock adjustments:
store_id_household %>%
group_by(store_id) %>%
summarise(household_count = n()) %>%
top_n(10, household_count) %>%
ggplot(aes(x = reorder(store_id, household_count), y = household_count)) +
geom_col() +
coord_flip() +
labs(
x = "Store ID",
y = "Household Count",
title = "Top 10 Stores with the highest Household Count",
subtitle = "Store 381, 367, 343 receives the top 3 visits from all households",
caption = "Data Source R Package: completejourney"
) +
theme_minimal() +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10))
Our findings highlight stores 381, 367, and 343 as top performers in both sales and household visits, underscoring their ideal candidacy for targeted coupon campaigns and inventory optimization.
To refine our strategy, we examine the top 10 product categories within the top 10 performing stores and top 3 most household visits store:
coupon_transaction_match %>%
filter(store_id %in% c(367, 406, 429, 361, 343, 356, 292, 381, 31782, 323)) %>%
# Summarize the total sales for each product category
group_by(store_id, product_category) %>%
summarise(total_sales = sum(sales_value)) %>%
slice_max(total_sales, n = 10) %>%
ggplot(aes(x = store_id, y = total_sales, color = product_category)) +
geom_point() +
geom_text_repel(aes(label = product_category), size = 2) +
labs(
x = "Store ID",
y = "Total Sales",
title = "Top 10 Product Categories in Top 10 Highest-Performing Stores",
subtitle = "Beef is the top sales category across stores",
caption = "Data Source R Package: completejourney"
) +
theme_minimal() +
scale_y_continuous(labels = scales::dollar) +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10)) +
theme(legend.position = "none")
We can see that beef is the top sales category across top 10 performing stores.
Next, we examine sales data for the leading product categories across 343, 367, and 381 stores, which are top performers in both sales and household visits:
coupon_transaction_match %>%
filter(store_id %in% c(381, 367, 343)) %>%
group_by(store_id, product_category) %>%
summarise(total_sales = sum(sales_value)) %>%
slice_max(total_sales, n = 10) %>%
ggplot(aes(x = store_id, y = total_sales, color = product_category)) +
geom_point() +
geom_text_repel(aes(label = product_category), size = 2) +
labs(
x = "Store ID",
y = "Total Sales",
title = "Leading Product Sales Across Top 3 Stores",
subtitle = "Beef and Frozen Meat/Meat Dinners are the sales drivers across top 3 stores",
caption = "Data Source R Package: completejourney"
) +
theme_minimal() +
scale_y_continuous(labels = scales::dollar) +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10)) +
theme(legend.position = "none")
We find that beef and frozen meat/meat dinners are the sales drivers across the top 3 stores.
Our final step involves detailed trend analysis for beef and frozen meat/meat dinners across the these stores. This analysis will highlight sales peaks and troughs throughout the year:
transaction_details %>%
filter(store_id %in% c(381, 367, 343)) %>%
filter(product_category == "BEEF") %>%
group_by(store_id, month) %>%
summarise(total_sales = sum(sales_value)) %>%
ggplot(aes(x = month, y = total_sales, color = store_id)) +
geom_line() +
labs(
x = "Month",
y = "Total Sales",
title = "Monthly Beef Sales Trends Across top 3 Stores",
subtitle = "Peak sales in 3, 4, 7, 9 in Store 343\nPeak sales in 4, 7, 12 in Store 367\nPeak sales in 2, 3, 6, 8 in Store 381\n",
caption = "Data Source R Package: completejourney"
) +
theme_minimal() +
scale_x_continuous(breaks = seq(1, 12, by = 1)) +
scale_y_continuous(labels = scales::dollar) +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10)) +
theme(legend.position = "none") +
facet_wrap(~store_id)
transaction_details %>%
filter(store_id %in% c(381, 367, 343)) %>%
filter(product_category == "FRZN MEAT/MEAT DINNERS") %>%
group_by(store_id, month) %>%
summarise(total_sales = sum(sales_value)) %>%
ggplot(aes(x = month, y = total_sales, color = store_id)) +
geom_line() +
labs(
x = "Month",
y = "Total Sales",
title = "Monthly FRZN MEAT/MEAT DINNERS Sales Trends \nAcross top 3 Stores",
subtitle = "Peak sales in 1, 2, 7, 9 in Store 343\nPeak sales in 1, 2, 5, 6, 8 in Store 367\nPeak sales in 1, 3, 5, 6, 8, 10 in Store 381\n",
caption = "Data Source R Package: completejourney"
) +
theme_minimal() +
scale_x_continuous(breaks = seq(1, 12, by = 1)) +
scale_y_continuous(labels = scales::dollar) +
theme(plot.title = element_text(size = 15, face = "bold"),
plot.subtitle = element_text(size = 10),
axis.text.x = element_text(size = 8),
axis.text.y = element_text(size = 8),
axis.title = element_text(size = 10),
strip.text = element_text(size = 10)) +
theme(legend.position = "none") +
facet_wrap(~store_id)
In those peak months, we can focus on beef and frozen meat/meat dinners to optimize stock management and promotional activities. And we could also promote the low sales months to increase sales.
This thorough analysis, spanning coupon redemption to sales trends, grants us profound insights into market dynamics, crucial for refining inventory strategies and boosting promotional campaign efficacy. Aligning with consumer demand and behavior becomes achievable. Extending this analysis to other product categories and less performing stores could further our understanding of market forces, guiding more informed decisions.
Our analysis reveals significant insights into store performance, particularly in relation to households utilizing coupons, offering a robust framework for refining inventory and inventory management strategies. By examining sales and coupon redemption patterns, we’ve identified key trends that can inform targeted promotional campaigns. Notably, the lower coupon issuance and redemption rates observed from January to April correspond with decreased sales volumes, suggesting an opportunity to bolster sales during these periods through strategic campaign designs focused on competitive product categories.
Seasonal Sales Fluctuations: Our analysis revealed significant sales peaks during May, July, October, November, and December, underscoring the holiday season’s substantial influence on consumer behavior.
Coupon Campaigns: Campaign activity was notably high in May, August, and October. This strategic focus aligns with observed peaks in sales and coupon redemption rates, suggesting that these periods are critical for promotional strategies.
Coupon Redemption Trends: Higher redemption rates were observed during May, June, August, September, November, and December. There is a clear correlation between these redemption rates and sales peaks, indicating that holiday seasons play a crucial role in driving coupon redemptions.
Impact on Sales: Despite a modest direct impact from coupon redemptions on overall sales, households utilizing coupons potentially drive up to 35% of total sales. This significant indirect impact highlights the strategic value of well-crafted coupon campaigns.
Top-Performing Stores: Analysis identified the top-performing stores, with Store 367 consistently outperforming others throughout the year. This insight is crucial for targeted promotions and inventory optimization.
Sales Variability by Month and Store: Monthly sales variability and consistent performance by certain stores were noted. Store 367, in particular, demonstrated robust sales across all months.
Household Footfall: Stores 381, 367, and 343 were identified as having significant household footfall, marking them as potential hotspots for focused marketing and stock adjustments.
Product Category Sales: Beef emerged as the top sales category across the top 10 performing stores. Further analysis in top 3 stores (343, 367, 381) also highlighted beef and frozen meat/meat dinners as significant sales drivers.
Detailed Trend Analysis for Key Products: Monthly sales trends for beef and frozen meat/meat dinners were examined across the top 3 stores, revealing specific months where sales peaked, offering insights for targeted stock management and promotional activities.
We propose that the Regork CEO consider these insights to refine the company’s promotional strategies and inventory management, focusing on leveraging seasonal trends and consumer preferences to optimize sales performance.
While our analysis provides valuable insights, it has limitations. The dataset used covers a specific time frame and consumer demographics, which may not fully represent current market conditions, broader consumer behaviors, or geography locations. Additionally, our analysis primarily focused on sales and coupon redemption data without delving into consumer demographics or external factors like economic conditions and competitive strategies.
Moreover, a significant opportunity for improvement has been identified in our data collection and management processes. The current transaction data does not accurately link transactions to the specific coupons used, which limits our ability to measure the direct impact of individual coupon campaigns on sales. We propose a revision in our database design to establish a direct linkage between transactions and the corresponding coupon UPCs. This adjustment would enhance the accuracy of our analyses, enabling more targeted and effective promotional strategies.
Our study offers actionable insights for Regork, highlighting seasonal sales peaks and consumer preferences that are crucial for planning effective promotional campaigns and inventory management. We advise the CEO to capitalize on these findings, particularly by enhancing marketing efforts during low-sales months and focusing on high-demand product categories. Improving data linkage between transactions and coupons will refine this strategy. Despite certain limitations, the analysis provides a solid foundation for bolstering Regork’s sales and operational strategies.
Boehmke, B. (2020, January 16). The Complete Journey User Guide. completejourney.
O’Connell, B. (2022, July 29). Kroger’s discount coupon page tells a lot about the U.S. economy. The Street.