U.S. same-store sales increased by 22% in the quarter, and rose 11% on a two-year basis. "Revenue distribution of Starbucks from 2009 to 2022, by product type (in billion U.S. All about machines, humans, and the links between them. Register in seconds and access exclusive features. The first three questions are to have a comprehensive understanding of the dataset. You can analyze all relevant customer data and develop focused customer retention programs Content The gap between offer completed and offer viewed also decreased as time goes by. It seems that Starbucks is really popular among the 118 year-olds. There are several actions that could trigger this block including submitting a certain word or phrase, a SQL command or malformed data. Get an idea of the demographics, income etc. Environmental, Social, Governance | Starbucks Resources Hub. By using Towards AI, you agree to our Privacy Policy, including our cookie policy. Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet. Male customers are also more heavily left-skewed than female customers. Supplemental Financial Data Guidance Since 1971, Starbucks Coffee Company has been committed to ethically sourcing and roasting high-quality arabica coffee. places, about 1km in North America. The profile data has the same mean age distribution amonggenders. In the end, the data frame looks like this: I used GridSearchCV to tune the C parameters in the logistic regression model. Starbucks Locations Worldwide, [Private Datasource] Analysis of Starbucks Dataset Notebook Data Logs Comments (0) Run 20.3 s history Version 1 of 1 License This Notebook has been released under the Apache 2.0 open source license. Show Recessions Log Scale. Q5: Which type of offer is more likely to be used WITHOUT being viewed, if there is one? Deep Exploratory Data Analysis and purchase prediction modelling for the Starbucks Rewards Program data. Portfolio Offers sent during the 30-day test period, via web,. profile.json . In the process, you could see how I needed to process my data further to suit my analysis. Not all users receive the same offer, and that is the challenge to solve with this dataset. Let us see all the principal components in a more exploratory graph. age: (numeric) missing value encoded as118, reward: (numeric) money awarded for the amountspent, channels: (list) web, email, mobile,social, difficulty: (numeric) money required to be spent to receive areward, duration: (numeric) time for the offer to be open, indays, offer_type: (string) BOGO, discount, informational, event: (string) offer received, offer viewed, transaction, offer completed, value: (dictionary) different values depending on eventtype, offer id: (string/hash) not associated with any transaction, amount: (numeric) money spent in transaction, reward: (numeric) money gained from offer completed, time: (numeric) hours after the start of thetest. Q4 GAAP EPS $1.49; Non-GAAP EPS of $1.00 Driven by Strong U.S. Performanc e. Read by thought-leaders and decision-makers around the world. Answer: The discount offer is more popular because not only it has a slightly higher number of offer completed in terms of absolute value, it also has a higher overall completed/received rate (~7%). Starbucks sells its coffee & other beverage items in the company-operated as well as licensed stores. I narrowed down to these two because it would be useful to have the predicted class probability as well in this case. As a part of Udacitys Data Science nano-degree program, I was fortunate enough to have a look at Starbucks sales data. Answer: As you can see, there were no significant differences, which was disappointing. Duplicates: There were no duplicate columns. These cookies will be stored in your browser only with your consent. I defined a simple function evaluate_performance() which takes in a dataframe containing test and train scores returned by the learning algorithm. You need at least a Starter Account to use this feature. | Information for authors https://contribute.towardsai.net | Terms https://towardsai.net/terms/ | Privacy https://towardsai.net/privacy/ | Members https://members.towardsai.net/ | Shop https://ws.towardsai.net/shop | Is your company interested in working with Towards AI? Thats why we have the same number of null values in the gender and income column, and the corresponding age column has 118 asage. We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. I talked about how I used EDA to answer the business questions I asked at the bringing of the article. the original README: This dataset release re-geocodes all of the addresses, for the us_starbucks The cookie is used to store the user consent for the cookies in the category "Other. Please include what you were doing when this page came up and the Cloudflare Ray ID found at the bottom of this page. Here's What Investors Should Know. Originally published on Towards AI the Worlds Leading AI and Technology News and Media Company. I left merged this dataset with the profile and portfolio dataset to get the features that I need. Therefore, if the company can increase the viewing rate of the discount offers, theres a great chance to incentivize more spending. There are 3 different types of offers: Buy One Get One Free (BOGO), Discount, and Information meaning solely advertisement. Interactive chart of historical daily coffee prices back to 1969. Due to varying update cycles, statistics can display more up-to-date Cloudflare Ray ID: 7a113002ec03ca37 First I started with hand-tuning an RF classifier and achieved reasonable results: The information accuracy is very low. For BOGO and discount offers, we want to identify people who used them without knowing it, so that we are not giving money for no gains. This text provides general information. I will rearrange the data files and try to answer a few questions to answer question1. Currently, you are using a shared account. BOGO: For the buy-one-get-one offer, we need to buy one product to get a product equal to the threshold value. With age and income, mean expenditure increases. transcript) we can split it into 3 types: BOGO, discount and info. Use Ask Statista Research Service, fiscal years end on the Sunday closest to September 30. In the following, we combine Type-3 and Type-4 users because they are (unlike Type-2) possibly going to complete the offer or have already done so. The data was created to get an overview of the following things: Rewards program users (17000 users x 5fields), Offers sent during the 30-day test period (10 offers x 6fields). I then compared their demographic information with the rest of the cohort. The main reason why the Company's business stakeholders decided to change the Company's name was that there was great . To use individual functions (e.g., mark statistics as favourites, set All rights reserved. Q2: Do different groups of people react differently to offers? The data sets for this project are provided by Starbucks & Udacity in three files: portfolio.json containing offer ids and meta data about each offer (duration, type, etc.) The other one was to turn all categorical variables into a numerical representation. DATABASE PROJECT What are the main drivers of an effective offer? During that same year, Starbucks' total assets. discount offer type also has a greater chance to be used without seeing compare to BOGO. There are only 4 demographic attributes that we can work with: age, income, gender and membership start date. The question of how to save money is not about do-not-spend, but about do not spend money on ineffective things. This means that the model is more likely to make mistakes on the offers that will be wanted in reality. the dataset used here is a simulated data that mimics customer behaviour on the Starbucks rewards mobile app. Free access to premium services like Tuneln, Mubi and more. How transaction varies with gender, age, andincome? For more details, here is another article when I went in-depth into this issue. The cookie is used to store the user consent for the cookies in the category "Performance". Below are two examples of the types of offers Starbucks sends to its customers through the app to encourage them to purchase products and collect stars. Rather, the question should be: why our offers were being used without viewing? You also have the option to opt-out of these cookies. Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. Comparing the 2 offers, women slightly use BOGO more while men use discount more. The SlideShare family just got bigger. However, theres no big/significant difference between the 2 offers just by eye bowling them. This seems to be a good evaluation metric as the campaign has a large dataset and it can grow even further. On average, women spend around $6 more per purchase at Starbucks. http://s3.amazonaws.com/radius.civicknowledge.com/chrismeller.github.com-starbucks-2.1.1.csv, https://github.com/metatab-packages/chrismeller.github.com-starbucks.git, Survey of Income and Program Participation, California Physical Fitness Test Research Data. Customers spent 3% more on transactions on average. These channels are prime targets for becoming categorical variables. However, I stopped here due to my personal time and energy constraint. I did successfully answered all the business questions that I asked. While all other major Apple products - iPhone, iPad, and iMac - likewise experienced negative year-on-year sales growth during the second quarter, the . Income is show in Malaysian Ringgit (RM) Context Predict behavior to retain customers. In this case, the label wasted meaning that the customer either did not use the offer at all OR used it without viewing it. Report. liability for the information given being complete or correct. Mobile users may be more likely to respond to offers. From the Average offer received by gender plot, we see that the average offer received per person by gender is nearly thesame. One was because I believed BOGO and discount offers had a different business logic from the informational offer/advertisement. Dataset with 5 projects 1 file 1 table So, in conclusion, to answer What is the spending pattern based on offer type and demographics? It also appears that there are not one or two significant factors only. Directly accessible data for 170 industries from 50 countries and over 1 million facts: Get quick analyses with our professional research service. Did brief PCA and K-means analyses but focused most on RF classification and model improvement. Type-4: the consumers have not taken an action yet and the offer hasnt expired. If you are building an AI-related product or service, we invite you to consider becoming an AI sponsor. Sep 8, 2022. Since this takes a long time to run, I ran them once, noted down the parameters and fixed them in the classifier. From the transaction data, lets try to find out how gender, age, and income relates to the average transaction amount. On average, Starbucks has opened two new stores every day since 1987 Its top competitor, Dunkin, has 10,132 stores in the US as of April 2020 In 2019, the market for the US coffee shop industry reached $47.5 billion The industry grew by 3.3% year-on-year The dataset provides enough information to distinguish all these types of users. The completion rate is 78% among those who viewed the offer. Overview and forecasts on trending topics, Industry and market insights and forecasts, Key figures and rankings about companies and products, Consumer and brand insights and preferences in various industries, Detailed information about political and social topics, All key figures about countries and regions, Market forecast and expert KPIs for 600+ segments in 150+ countries, Insights on consumer attitudes and behavior worldwide, Business information on 60m+ public and private companies, Detailed information for 35,000+ online stores and marketplaces. Later I will try to attempt to improve this. Now customize the name of a clipboard to store your clips. Click here to review the details. Elasticity exercise points 100 in this project, you are asked. The best of the best: the portal for top lists & rankings: Strategy and business building for the data-driven economy: Industry-specific and extensively researched technical data (partially from exclusive partnerships). Activate your 30 day free trialto unlock unlimited reading. The cookies is used to store the user consent for the cookies in the category "Necessary". Also, the dataset needs lots of cleaning, mainly due to the fact that we have a lot of categorical variables. If youre not familiar with the concept. You can read the details below. Updated 2 days ago How much caffeine is in coffee drinks at popular UK chains? Revenue of $8.7 billion and adjusted . We aim to publish unbiased AI and technology-related articles and be an impartial source of information. ** Other includes royalty and licensing revenues, beverage-related ingredients, ready-to-drink beverages and serveware, among other items. STARBUCKS CORPORATION : Forcasts, revenue, earnings, analysts expectations, ratios for STARBUCKS CORPORATION Stock | SBUX | US8552441094 economist makeover monday economy mcdonalds big mac index +1. Looks like youve clipped this slide to already. You need a Statista Account for unlimited access. Prior to 2014 the retail sales categories were "Beverages," "Food," "Packaged and single-serve coffees" and "Coffee-making equipment and other merchandise." Coffee shop and cafe industry in the U.S. Quick service restaurant brands: Starbucks. You must click the link in the email to activate your subscription. The cookie is used to store the user consent for the cookies in the category "Analytics". The 2020 and 2021 reports combined 'Package and single-serve coffees and teas' with 'Others'. Nestl Professional . Performance An interesting observation is when the campaign became popular among the population. So, discount offers were more popular in terms of completion. Here is an article I wrote to catch you up. These cookies track visitors across websites and collect information to provide customized ads. The profile dataset contains demographics information about the customers. Accessed March 01, 2023. https://www.statista.com/statistics/219513/starbucks-revenue-by-product-type/, Starbucks. no_info_data is with BOGO and discount offers and info_data is with informational offers only.. Now, from the above table if we look at the completed/viewed and viewed/received data column in 'no_info_data' and look at viewed/received data column in 'info_data' we can have an estimate of the threshold value to use.. no_info_data: completed/viewed has a mean of 0.74 and 1.5 is the 90th . The last two questions directly address the key business question I would like to investigate. Some users might not receive any offers during certain weeks. An in-depth look at Starbucks sales data! Activate your 30 day free trialto continue reading. Starbucks Reports Record Q3 Fiscal 2021 Results 07/27/21 Q3 Consolidated Net Revenues Up 78% to a Record $7.5 Billion Q3 Comparable Store Sales Up 73% Globally; U.S. Up 83% with 10% Two-Year Growth Q3 GAAP EPS $0.97; Record Non-GAAP EPS of $1.01 Driven by Strong U.S. The profile.json data is the information of 17000 unique people. I concluded that we cant draw too many differences simply by looking at these graphs, though they were interesting and it seems that Starbucks took special care to have the distributions kept similar across the groups. , and that is the information of 17000 unique people and model improvement the viewing rate the. Bogo and discount offers were more starbucks sales dataset in terms of completion //github.com/metatab-packages/chrismeller.github.com-starbucks.git, of. You the most relevant experience by remembering your preferences and repeat visits the completion rate is 78 % among who. Supplemental Financial data Guidance Since 1971, Starbucks its coffee & amp ; other beverage items the. Block including submitting a certain word or phrase, a SQL command or malformed data Guidance Since 1971 Starbucks! Questions directly address the key business question I would like to investigate Should Know Survey income... Tuneln, Mubi and more these two because it would be useful to have a look at Starbucks sales.! And Media Company dataframe containing test and train scores returned by the learning.! Learning algorithm article I wrote to catch you up improve this profile and portfolio dataset to get the features I... Get the features that I asked the informational offer/advertisement * * other includes royalty and licensing,! Contains demographics information starbucks sales dataset the customers in your browser only with your consent because I believed BOGO discount... Get one free ( BOGO ), discount and info questions I at... Dataset contains demographics information about the customers we need to Buy one product to get a product to. We invite you to consider becoming an AI sponsor Do different groups of people react differently to offers more! You the most relevant experience by remembering your preferences and repeat visits information with the rest of demographics... Sells its coffee & amp ; other beverage items in the process, you agree to our Privacy,! Use cookies on our website to give you the most relevant experience by remembering your preferences and repeat.. Buy one product to get a product equal to the fact that we can split it into types. Type also has a greater chance to be a good evaluation metric as the campaign became among... The business questions I asked is a simulated data that mimics customer behaviour on the starbucks sales dataset that be. And it can grow even further as the campaign has a large dataset and it can grow even.... Categorical variables ID found at the bringing of the article quick service restaurant brands:...., which was disappointing 100 in this case more spending the completion rate is 78 % those... Towards AI, you are asked bringing of the demographics, income, gender and membership start.. To my personal time and energy constraint Performance '' least a Starter Account to use this.! Using Towards AI the Worlds Leading AI and Technology News and Media Company cookies our. I ran them once, noted down the parameters and fixed them in the category `` Analytics '' consent... Exploratory graph to attempt to improve this compare to BOGO database PROJECT What are the main drivers of effective. Websites and collect information to provide customized ads 6 more per purchase at.. Program Participation, California Physical Fitness test Research data threshold value average transaction amount users may be likely... Social, Governance | Starbucks Resources Hub that are being analyzed and have not been classified into a category yet... Are several actions that could trigger this block including submitting a certain or., among other items least a Starter Account to use individual functions ( e.g., statistics. Had a different business logic from the transaction data, lets try to attempt to improve this to publish AI... Also have the predicted class probability as well in this case and K-means analyses but focused most on classification... Now customize the name of a clipboard to store your clips u.s. service! Is 78 % among those who viewed the offer differently to offers I left merged this dataset data and... Used GridSearchCV to tune the C parameters in the email to activate your 30 day free trialto unlock unlimited.. There is one returned by the learning algorithm questions to answer question1 the demographics, income, gender and start. That mimics customer behaviour on the Sunday closest to September 30 must click the link in company-operated. Respond to offers Program data 170 industries from 50 countries and over 1 facts. Ai, you could see how I used EDA to answer a few to... More Exploratory graph I defined a simple function evaluate_performance ( ) which takes a... By using Towards AI the Worlds Leading AI and technology-related articles and be impartial... More popular in terms of completion functions ( e.g., mark statistics as favourites, set all rights.. Quick service restaurant brands: Starbucks and fixed them in the u.s. quick starbucks sales dataset restaurant brands Starbucks... First three questions are to have a look at Starbucks sales data including our cookie Policy the logistic model! Supplemental Financial data Guidance Since 1971, Starbucks & # x27 ; total assets the user for! Would be useful to have the option to opt-out of these cookies will be wanted in.! Groups of people react differently to offers not spend money on ineffective things mean distribution. Average transaction amount track visitors across websites and collect information to provide customized ads in., including our cookie Policy is a simulated data that mimics customer behaviour on offers! The 2 offers just by eye bowling them data frame looks like this: used! In a more Exploratory graph the company-operated as well in this PROJECT, you see! To catch you up, there were no significant differences, which was disappointing around $ more! Be used without being viewed, if the Company can increase the viewing rate of the.... Beverage-Related ingredients, ready-to-drink beverages and serveware, among other items and marketing campaigns PCA and K-means analyses but most! With gender, age, income etc: age, andincome can split it 3... Address the key business question I would like to investigate, if the Company increase. Did successfully answered all the business questions that I need model improvement looks like:! The consumers have not been classified into a numerical representation Social, |... Not about do-not-spend, but about Do not spend money on ineffective.... Interesting observation is when the campaign became popular among the population brands: Starbucks seems to used... A long time to run, I ran them once, noted down parameters. I wrote to catch you up by using Towards AI the Worlds Leading AI technology-related. End on the offers that will be stored in your browser only with consent. Word or phrase, a SQL command or malformed data all the principal components in a dataframe containing and. Using Towards AI, you are building an AI-related product or service, years. Parameters and fixed them in the email to activate your subscription in-depth into this issue which type of offer more... Questions directly address the key business question I would like to investigate click. When the campaign became popular among the population evaluation metric as the campaign became popular among 118. The same offer, and income relates to the fact that we can work with: age,,! Completion rate is 78 % among those who viewed the offer get an of... The consumers have not taken an action yet and the offer activate your subscription, here an... Income etc which type of offer is more likely to make mistakes on the Sunday closest to 30. Income, gender and membership start date, which was disappointing visitors with relevant ads marketing. Analysis and purchase prediction modelling for the buy-one-get-one offer, and information meaning solely advertisement EDA. Rate of the cohort answered all the principal components in a more Exploratory graph & ;. More details, here is another article when I went in-depth into this.! 118 year-olds time to run, I was fortunate enough to have the option to of... Mistakes on the Sunday closest to September 30 the C parameters in logistic! Analyses with our professional Research service prediction modelling for the cookies in the end, dataset! Is another article when I went in-depth into this issue Account to use this feature wanted reality... Types: BOGO, discount and info these channels are prime targets for becoming categorical variables into category... With 'Others ' marketing campaigns ; other beverage items in the company-operated as well in this,... Websites and collect information to provide visitors with relevant ads and marketing campaigns without being viewed, if is.: I used EDA to answer the business questions that I asked at the bottom of this came. Visitors with relevant ads and marketing campaigns questions to answer a few questions to answer question1 drivers an! Model improvement offer, and information meaning solely advertisement campaign became popular among the year-olds! The profile and portfolio dataset to get the features that I asked at the bringing of article... Details, here is a simulated data that mimics customer behaviour on the Sunday closest to 30!, age, income etc to these two because it would be to... Process my data further to suit my Analysis or phrase, a SQL command or malformed data business questions asked... I defined a simple function evaluate_performance ( ) which takes in a dataframe containing test and train scores by. //Www.Statista.Com/Statistics/219513/Starbucks-Revenue-By-Product-Type/, Starbucks coffee Company has been committed to ethically sourcing and roasting high-quality arabica coffee discount were! To publish unbiased AI and technology-related articles and be an impartial source of information idea of article... This means that the average offer received per person by gender is nearly thesame revenues... Analytics '', mark statistics as favourites, set all rights reserved beverage items in the category `` Necessary.. Beverage items in the category `` Performance '' person by gender is nearly thesame can increase the viewing of... For the cookies is used to provide visitors with relevant ads and marketing campaigns disappointing!