Assignment 5
Introduction
This document shows analysisof tweets that mention Dunkin vs tweets that mention Starbucks. I’d like to look at the amount of interactions are given to these tweets to gauge popularity, specifically looking at retweets of each tweet. I will also look at the location of the users that tweet, if given to see if there is a concentration in preferences, especially worldwide. I think time could also be telling in terms of the day of the week a customer might tweet about either one. This analysis may provide an insight on which brand is, overall, more popular.
Question I Will Attempt to Answer:
How do the demographics between people who tweet about and, I assume, prefer either Starbucks or Dunkin differ?
Methodology
- I chose to look at 10,000 tweets concerning both brands, using “Starbucks” and “Dunkin” as my search terms, respectively.
- Only 9,965 tweets could be found with Starbucks mentioned.
- I also did not include retweets because when I first ran the query without that condition, a lot of the tweets in the data stemmed from one tweet from a celebrity that was retweeted many times. I want to get as much unique data as possible.
- Neither brand really has a dedicated hashtag that is widely known, so I thought just the name would be a good search.
Packages Installed
library(tidyverse)
library(dplyr)
library(httpuv)
library(rtweet)
library(knitr)
library(kableExtra)Data Import
rtweet_sbucks <- read_csv("https://myxavier-my.sharepoint.com/:x:/g/personal/largentm_xavier_edu/EQ7jJVaZNKRIvQ9s3vRrjB4Bdy7Bv4noqEi1-TMQoTH-WQ?download=1")
rtweet_dunkin <- read_csv("https://myxavier-my.sharepoint.com/:x:/g/personal/largentm_xavier_edu/EY3gVU6sFhFGvZjKIKVYCHgBD453wOAuI4h_q_ZFrHu1Qw?download=1")Question 1
Do tweets about Starbucks or Dunkin have more interaction in terms of retweets?
- Tweets mentioning Starbucks average upwards of 15 more retweets per tweet. This excludes all tweets that did not get any retweets. I think this shows that the tweets including Starbucks either resonate more with the audience and are more engaging, or it is possible that they come from a more popular source than the Dunkin tweets did.
Question 2
Where are the people who tweet about each brand most frequently located?
- Dunkin - Most people who tweet about Dunkin do not share their location, but the majority of tweets come from the US, which makes sense because this is where their largest presence is. Dunkin is only in 36 countries worldwide.
country n NA 9613 United States 328 Indonesia 17 Republic of the Philippines 16 Kingdom of Saudi Arabia 9 Belgium 2 Malaysia 2 United Kingdom 2 Barbados 1 Canada 1 Guam 1 Japan 1 Lebanon 1 Mexico 1 Peru 1 Sweden 1 Thailand 1 The Netherlands 1 United Arab Emirates 1 - Starbucks - They definitely have a wider range of countries as there are tweets from 37 countries compared to 18 for Dunkin. The UK and Canada are also big markets for Starbucks. Starbucks has stores in 77 countries.
country n NA 9344 United States 320 United Kingdom 87 Canada 59 Republic of the Philippines 25 Malaysia 21 Turkey 16 Brazil 11 Indonesia 9 Thailand 8 Japan 7 Republic of Korea 7 Argentina 6 Mexico 6 People’s Republic of China 5 Kuwait 3 Russia 3 Spain 3 Chile 2 India 2 Kingdom of Saudi Arabia 2 Panama 2 Switzerland 2 Cyprus 1 Egypt 1 El Salvador 1 France 1 Germany 1 Hashemite Kingdom of Jordan 1 Italy 1 Malta 1 Oman 1 Singapore 1 South Africa 1 Trinidad and Tobago 1 United Arab Emirates 1 Uruguay 1 Vietnam 1
Question 3
What day of the week did people tweet the most about their brand? 
- Dunkin had the most tweets mentioning it on May 7th and 8th, which are a Thursday and Friday, respectively. Maybe people look forward to the weekend with an iced coffee!
- All of the 9,665 tweets containing Starbucks occurred on May 11. This tells me that it is a more popular brand by users on Twitter, or that there was a news story talking about Starbucks that day which is likely considering they are beginning to open all stores following closures for Coronavirus.
Question 4
Are the brands themselves active on twitter within this data pull from their handles @dunkindonuts and @starbucks?
@dunkindonuts
- It looks like Dunkin tweeted six times from this handle over the period. 3 of those tweets were responding to customers, and two were specifically concerning Mother’s Day.
| screen_name | text | date |
|---|---|---|
| dunkindonuts | @Jen_nayyyyy Hello 👋 Luckily we have Dunkin’ delivery services in a few markets, check out this link to see if it’s available in your area: https://t.co/RdRjm48tsL. If not, we’d reco ordering ahead via the Dunkin’ app for a fast grab & go experience! | 2020-05-11 |
| dunkindonuts | This Mother’s Day give your mom the coffee break she deserves by sending her an e-gift card from https://t.co/JVIKFwoYKw. ❤️☕️For every gift card purchased, we will donate $1, up to $100,000, to the Dunkin’ JICF emergency funds, that help families affected by COVID-19. https://t.co/3Thbzwvghq | 2020-05-08 |
| dunkindonuts | Add some sparkle to your video calls this Mother’s Day with custom Dunkin’ Mother’s Day backgrounds. ✨❤️Download them on our blog: https://t.co/QhztUZtBFH https://t.co/PfP2zwnlIB | 2020-05-09 |
| dunkindonuts | @summerfran14 Hello 👋 To find out if your local Dunkin’ is open, please use the Dunkin’ mobile app for store hours and pick up options. | 2020-05-08 |
| dunkindonuts | With the help from an emergency grant from our Dunkin’ Joy in Childhood Foundation, the Connecticut Food Bank was able to increase its weekly distribution & provide it’s community access to nutritious food & resources they need to stay safe & healthy during this difficult time.❤️ https://t.co/1ckaxc67B3 | 2020-05-08 |
| dunkindonuts | @Miss_AmandaG We apologize for your experience and appreciate all that you do – today, and every day. Today’s National Nurses Day offer is open to ALL healthcare workers who visit participating Dunkin’ restaurants nationwide. Please DM us so we can help make this right. | 2020-05-06 |
@Starbucks
- Comparatively, Starbucks tweeted 36 times and this was just in one day. Based on what they’ve tweeted, it looks like they are much more likely to be responding to customers’ comments/concerns/questions than Dunkin is. Only one of the tweets was not a reply to a customer.
| screen_name | text | date |
|---|---|---|
| Starbucks | @HerScorpioMind 💚 | 2020-05-11 |
| Starbucks | @makboo168 You’re welcome! | 2020-05-11 |
| Starbucks | @noajasmine Your Stars are still yours! The app may be reflecting the wrong Star expiration info. We assure you that your Stars have been extended to June 1st. Sorry for the confusion. | 2020-05-11 |
| Starbucks |
⭐⭐ Double Star Days are back. ⭐⭐ From May 11-15 earn double the Stars when you order ahead or pay using the Starbucks App at participating US stores. To download and start earning Rewards, visit https://t.co/p4IqJLH0Ck. https://t.co/JMhVtURusz |
2020-05-11 |
| Starbucks | @chrissack Hey Christian, please disregard any expiration details as the app may reflect the incorrect Star count. We assure you that no stars will be expiring until June 1st. Sorry for the confusion. | 2020-05-11 |
| Starbucks | @LaurenNicoleS Hey Lauren, we’ve extended your stars to June 1st. Please disregard any incorrect expiration details reflected in the app. Let us know if you have any questions! | 2020-05-11 |
| Starbucks | @glitteryybutt It’s a bite that should be on everyone’s “To Try” list! | 2020-05-11 |
| Starbucks | @50Shades0f_Slay They are totally right! Enjoy every sip. | 2020-05-11 |
| Starbucks | @gregoryc7040 Which sip are you going to reward yourself with? | 2020-05-11 |
| Starbucks | @HerScorpioMind Don’t worry, Maru! You will earn Double Stars on any eligible purchase made 5/11 - 5/15 so you should see a few extra stars today. 😊 | 2020-05-11 |
| Starbucks | @ShelbyyyDafff Now that’s smart thinking! Your taste buds are probably so happy. 😋 | 2020-05-11 |
| Starbucks | @DarkerMichael Of course! We’re happy to help. 🙂 | 2020-05-11 |
| Starbucks | @dwagon Hi! Any Stars set to expire have been extended through June 1st. | 2020-05-11 |
| Starbucks | @rach72675 You’re welcome! | 2020-05-11 |
| Starbucks | @makboo168 We want you to be able to enjoy your Stars which is why we extended them through June 1st. Please disregard any expiration details that reflect in your account. | 2020-05-11 |
| Starbucks | @LaurenNicoleS You too! 🙂 | 2020-05-11 |
| Starbucks | @edbrooke97 They should thank you now! Sounds like a delish at-home sip. 😋 | 2020-05-11 |
| Starbucks | @ShelbyyyDafff Always happy to have your back! 💚 | 2020-05-11 |
| Starbucks | @ItsReallyPoLo Let us know your findings. | 2020-05-11 |
| Starbucks | @dwagon We hear you! We will continue to evaluate this situation and adjust as needed. | 2020-05-11 |
| Starbucks | @gregoryc7040 Delish! | 2020-05-11 |
| Starbucks | @VM1897 We love you too and that’s why we’ve extended your stars through June 1st! Please disregard the app, which isn’t reflecting the correct expiration details. Sorry for the confusion. | 2020-05-11 |
| Starbucks | @1andonlybetty Hello, Star power! ⭐ | 2020-05-11 |
| Starbucks | @ocbeachmommy It isn’t and we apologize for that. Please disregard any star expiration details in the app. We assure you that your Stars have been extended to June 1st. | 2020-05-11 |
| Starbucks | @tarakrane While we don’t have Double Stars in Canada this week, stay tuned to your inbox for awesome offers coming your way! | 2020-05-11 |
| Starbucks | @moncherixxo Both are delicious options! | 2020-05-11 |
| Starbucks |
@rach72675 Hi Rach! We’ve got two options we think would work best for you:
|
2020-05-11 |
| Starbucks | @DarkerMichael We’re sorry about that Michael. Please disregard the expiration details reflected in your app. We assure you no Stars will be expiring between now and June 1. Thank you! | 2020-05-11 |
| Starbucks | @angelseph16 You got this! | 2020-05-11 |
| Starbucks | @Brooke_Criswell Awesome! 💚 | 2020-05-11 |
| Starbucks | @chasingtheSAM Welcome back, Sam! We’ve missed you! | 2020-05-11 |
| Starbucks | @robertmole28 They will be available at select online retailers for the suggested retail price of $9.99 per 10-count sleeve (pricing varies by retailer). https://t.co/8msIghY5IU | 2020-05-11 |
| Starbucks | @villanarei Sorry no. This offer is only available at participating US stores. | 2020-05-11 |
| Starbucks | @IzadorableBrit Hi, Izzie. Your Stars have been extended through June 1 due to COVID-19. If you see a message saying otherwise, please disregard. Your Stars have not expired and are still available for your use. We apologize for any confusion. You can read the alert at https://t.co/Ljhf1RTkPZ | 2020-05-11 |
| Starbucks | @Spike_Chenghan 💚💚 | 2020-05-11 |
| Starbucks | @tarakrane Sorry, Tara. This is only available for participating US stores. | 2020-05-11 |