Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

I don t know where doritos live

11/11/2021 Client: muhammad11 Deadline: 2 Day

Brand Strategy and Super Bowl Twitter Analytics

Image Source: Adweek.com

Twitter popularity as 2nd screen

Infographic Source: Fortune, 2015

About Twitter

3

Twitter Stats (cont’d)

4

About Super Bowl Ads

5

Motivation • Cost per 30 seconds slot – 5 mil (CNNMoney, 2017). • Brand strategy in Super Bowl ads? Enhance & reach.

• The role of IS tools in this strategy? – Analytics of audience (demographics, locations etc.). – Supplementary info for future decision making.

• What is the relationship between Social Media buzz around Super Bowl ads with ad ratings? – Twitter activities surrounding SB ads with USA Today Index ratings (USA Today)?

3 Tweet Examples Those Budweiser commercials had me balling my eyes out!! #Budweiser #SuperBowl #horsepuppy #tearjerker

Thanks #CocaCola & #Cheerios for showing U.S. multicultural families and successfully including diverse markets #adbowl #AmericaIsBeautiful

Scarlett Johansson should realize that the only real flavor of #SodaStream is oppression http://t.co/QLpDD7vkXA #superbowl

Objective • Learn to extract valuable metrics from social media data using MS Excel.

• Know what insights are valuable to brands. • Simple introduction to (review on) descriptive statistics, correlation, charts, regressions, and word clouds.

• Lab instructions become more vague as lab progresses to encourage student self learning.

8

Lab Setup • Download this presentation. • Download the SB 2014 spreadsheet ‐‐ This is a summary of actual tweets *downloaded using PHP and MySQL scripts (done prior).

• Download the doritos.txt tweet text file*. • You will need MS Excel with Data Analysis ToolPak.

• Prepare a Word doc for submission.

Introduction • Start with research question:

– Is social media (Twitter) an effective tool for measuring brand performance (SB ads)?

• How? – Find a relationship between Twitter metrics and SB performance.

– If a relationship exists then social media may be a valuable (real time, low cost) monitoring mechanism in addition to existing tools.

– In addition, social media provides rich feedback (WOM, influencer, competitors, etc.).

Analysis 1. Descriptive Statistics 2. Correlation Analysis 3. Charts (Bar chart and scatter plot) 4. 3 Sets of OLS Regressions 5. Word Cloud diagrams

SB 2014* Dataset

• Super Bowl 2014 Ads • 51 Ads • Contains social media measures and USA Today ratings for each ad.

• Measures extracted from downloading and analyzing tweets for each ad.

*Seattle Seahawks beat Denver Broncos (43‐8) 12

Descriptive Statistics 1. Open MS Excel 2. Open SB 2014 spreadsheet 3. Highlight all the number cells (including titles) but

excluding official# and brand columns. 4. Go to Data > Data Analysis

Descriptive Statistics 5. Select Descriptive Statistics. 6. Select the shown choices below.

Descriptive Statistics 7. Results appear in next Sheet. 8. Copy Result to Word doc.

Descriptive Statistics 9. Discuss result. 10.Focus on average, min, max for

– USA Index – total tweets – brand only tweets – ad only tweets

Correlation Analysis 1. Select Correlation then OK.

2. In the Correlation window click OK.

Correlation Analysis 3. Results will appear in next Sheet. 4. Discuss which variables are highly correlated. Why? 5. Copy Result to Word doc.

Charts (1) • Do a Bar chart of ‘ad tweets’ and discuss. Add the brand names.

Charts (2) • Do a Scatter Plot of ‘Ad Tweet with USA Index’ and discuss. Add the trend line. What does the trend imply?

0.00

1.00

2.00

3.00

4.00

5.00

6.00

7.00

8.00

9.00

0.00 2000.00 4000.00 6000.00 8000.00 10000.00 12000.00

USA Index

What is linear regression? • Linear regression is the most basic and commonly used predictive analysis. Regression estimates are used to describe data and to explain the relationship between one dependent variable (y) and one or more independent variables (x).

• At the center of the regression analysis is the task of fitting a single line through a scatter plot. The simplest form with one dependent and one independent variable is defined by the formula y = a + b*x. 21

3 Sets of Regression • 3 Sets with the following as Y variable

– USA Index – Total Tweets – Brand Tweets

• Each set should have 3 regressions (i.e. version 1,2,3).

• You should end up with a total of 9 regressions.

22

1. Select Data Analysis and run regression. 2. Select the Y (USA Index) and X (all others except

#official and brand). Then click OK.

Regression v 1.0 (USA Index)

3. Copy to Word doc. Regression v 1.0 (USA Index)

4. Discuss Results. What variables can explain Y? You are expected to use your knowledge from your stats class here.

5. What to report? – Adjusted R‐squared – Variables with p value < .10

Regression v 1.0 (USA Index)

1. Copy main sheet to another sheet. 2. Select Y (USA Index). 3. For X, select only brand, ad, total, celebrity,

and pre‐release. Delete other columns. 4. Run regression. 5. Click OK.

Regression v 2.0 (USA Index)

7. Discuss Results. Copy to Word doc. Regression v 2.0 (USA Index)

1. Copy main sheet to another sheet. 2. Select Y (USA Index). 3. For X, select ad, celebrity, and pre‐release.

Delete other columns. 4. Run regression. 5. Click OK.

Regression v 3.0 (USA Index)

7. Discuss Results. Copy to Word doc. Regression v 3.0 (USA Index)

1. Perform another set for ‘total tweets’ as the Y variable.

2. Perform another set for ‘brand tweets’ as the Y variable.

3. Report result to Word doc and discuss. 4. Remember there should be 3 sets of 3

regressions totaling 9 runs.

More Regression Runs

Word Cloud 1. Go to http://www.wordclouds.com/ 2. Upload the ‘doritos’ tweet text file. 3. Discuss word cloud. 4. Why are certain terms

more frequently used?

Summary Paragraph • Write a summary paragraph for lab. • Describe what you have learned. • What IS tools are used? • How does this lab help you to understand the relationship between organizational strategy and IS tools?

• Can this be applied in your future career?

32

Lab Submission • In a Word doc:

1. Descriptive Statistics 2. Correlation 3. 2 Charts 4. 3 Regression Result Sets (USA Index, Total tweets, and

Brand Tweets) [9 total regressions] 5. Word Cloud 6. Summary paragraph

• Organize well to help easier grading == higher scores. • Submit on canvas

END

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Professional Coursework Help
Professional Accountant
Top Grade Essay
Essay & Assignment Help
Calculation Master
Fatimah Syeda
Writer Writer Name Offer Chat
Professional Coursework Help

ONLINE

Professional Coursework Help

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$47 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$15 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$16 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$23 Chat With Writer
Calculation Master

ONLINE

Calculation Master

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$34 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$40 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

What distribution strategy does giant beanstalks use - What is the amount of liquid a bathtub holds - 26610 n longmeadow dr mundelein il 60060 - Bussiness Essay - 6 essay type questions - Controls and variables part 2 worksheet answers - Association of massage therapy - Role and Scope Research 1 - Taylormade r580 xd driver illegal - Ati medication interactions case study - 3racing led light system - Digimon world factorial town - Balanced scorecard for it department - I said a boom chicka boom - Aon network diagram software - St luke's medical centre st albans - Clark rubber traralgon vic - R12000 in dollars - The evening herald plymouth - How secure is your smartphone case study answers - Green computing research project charter - Nike sweatshops behind the swoosh - Www cdc gov immigrantrefugeehealth exams medical examination faqs html 6 - Economics - Lead like jesus ken blanchard pdf - Understanding Terms - Costco case study answers - Assignment 8 - Chords for golden slumbers - Is endocytosis active or passive - Mames restaurant meredith nh - Mkt 571 price and channel strategy - Choosing a performance measurement approach at paychex inc - How would you build a csirt? what are the components to building an effective team? - Apa referencing uq library - Onuf world of our making - Algebra 2 - The danger of a single story questions and answers - Journal- 200 words - Psychographics is the segmentation method that delves into how consumers - Chapter 5 the time value of money - Bartels corp.produces wood carvings - How to write a speech outline template - Death investigation db2 - American cyclopaedia dark ages - Volume that remains in lungs after the most forceful expiration - Psyc 499 liberty university - Mariano vallejo and the absorption of california - Which of the following abbreviations means nothing by mouth - Dmaic project report - Brisbane city council planning applications - 9 4 proportional parts and triangles - Unit 6 using mathematical tools for science answers - There are three basic decision models used in gdss: operational, strategic, and financial. - PM WK 2. - The walt disney company reinforcing culture and values to employees - Metal activity and reactivity oxidation and reduction reactions lab answers - Mountain dew kickstart commercial wiggle wop - Conductivity of strong and weak electrolytes lab report - Strategic Plan Analysis (Vision, mission and objectives part) - Personal soliloquy example - Week 4 Assignment - Essay - Amway weight loss shakes - Sports in society issues and controversies 12th edition citation - Powder by tobias wolff answers - Week 1 Assignment Supporting Diversity through 21st Century Teaching and Learning - ?same-day 0833173182 NORTHAM ABORTION CLINIC // PILLS,,,, - LEADERSHIP AND CREATIVE SOLUTIONS - Centurion media doing the right thing - How to select cells a3 through f3 in excel - Ib economics test your understanding answers macroeconomics - The yellow ribbon story by pete hamill summary - Exponential smoothing problems and solutions - American woodmark cabinet specifications - Controlled ____ makes a relational database work - Incremental analysis ppt - Network management system definition - Half wave rectifier with capacitor - Abaqus mesh element type - Consumer behavior a strategic approach - Strategy formulation and choice - Vroom and yetton decision tree - Jack hartmann the silly pirate song - Successful cinnamon challenge - Direct acting contingency - The Deinsitiutionalization of American Marriage - Sales less sales discounts less sales returns and allowances equals - Introductory circuit analysis 11th edition solution manual pdf - Bernice bobs her hair pdf - Subordination of individual interest to general interest in kfc - Ethica and Legal Aspects of Nursing Practice . Course reflection - Business services training package assessment guidelines - How to use keune hair color - Idiographic vs nomothetic approach - Nursing - West end blues sheet music pdf - What is the fundamental niche of chthamalus - Break glass wiring diagram - Stability strategies in business pros and cons