Description: This project aims to examine Olympics communication (via Twitter) during the COVID-19 pandemic

Description:

This project aims to examine Olympics communication (via Twitter) during the COVID-19 pandemic. All tweets posted and retweeted by the 417 Olympics accounts (please see the excel file for the Twitter handles) from 2/24/2020 to 9/8/2021 were collected via Brandwatch (a social media marketing software).

Files:

Excel file with the 417 Olympics accounts information (https://www.mediafire.com/file/eb4qaaoselzg5ej/Olympics+Twitter+Accounts+2021+(2).xlsx/file)

See attachment

3 Excel files of the data (2/24/20-10/31/20; 11/1/20-6/30/21; 7/1/21-10/15/21)?copy the link to a browser)

https://www.mediafire.com/file/m9ifhkixohk4mdc/Olympics+Jul+01+2021+-+Oct+15+2021.xlsx/file

https://www.mediafire.com/file/bf8b0qlp0i7vwgn/Olympics+Feb+24+2020+-+Oct+31+2020.xlsx/file

https://www.mediafire.com/file/44ruxhz2cu6pv9q/Olympics+Nov+01+2020+-+Jun+30+2021.xlsx/file

Requests:

Clean Data: Only keep the tweets tweeted, replied, or retweeted by the 417 Olympics accounts from 2/24/20 to 9/8/21; and Combine the three data files to one file.

Descriptive Analysis of Existing Data: Sentiment, account type, twitter reply count, twitter retweets, impression, impact, with/without mentions, thread entry type, twitter followers, twitter following, twitter tweets, reach, engagement type

Descriptive Analysis of Existing Data (Cont.): Top 25 authors (most tweeted); Top 25 tweets (by impact)

Flexible Timeline Analysis of Existing Data: Run the descriptive analysis with date… to see if there are any differences throughout the time.

Fixed Timeline Analysis of Existing Data: Run the descriptive analysis with the four time periods listed below.

(1 = 2/24/20-3/23/20; 2 = 3/24/20-7/22/21; 3 = 7/23/21-8/8/21; 4 = 8/9/21-9/8/21)

In-depth Analysis:

Emotions: Anger, anxiety, disgust, fright, joy, sadness, other emotions

Content: Celebration and empowerment, athlete safety, prevention, COVID, postpone Olympics, mental wellness, physical wellness/health

Coping Strategies: Emotional coping, cognitive coping, action

Attribution of responsibility: Individual level, or Organizational level

Crisis Response Stages: Rejection, acceptance, fighting

Tweet Topics: Informing, marketing, activating, personalizing

Relationships: Professional, personal, community

Flexible Timeline Analysis with the In-depth Analysis Results

Fixed Timeline Analysis with the In-depth Analysis Results

Differences between individual and organizational accounts on both descriptive and in-depth analyses

Regression Analysis of Impression and Impact (i.e., Factors that predict Impression and Impact)

Regression Analysis of Impression and Impact with Fixed Timeline

Item