2014 SXSW Texas Rangers Presentation

14
Becky Kimbro@BeckyKimbro Sarah Stone @sstone703 BigLeague Business Intelligence: Howthe Texas Rangers are UsingTableau for Business Operations

description

This session will explore how the Texas Rangers have revolutionized the way they measure ticket sales and monitor ballpark operations. From determining how bobblehead giveaways impact attendance, to monitoring gate scan entries on game days, peek inside a baseball front office and learn how Tableau is reshaping the way Texas Rangers see and understand their data. You don’t have to understand sabermetrics to get something out of this session – data lovers and baseball fans of all types are invited to attend and learn how the Texas Rangers drafted a diverse starting lineup of analysts across the company to hit their analytics projects out of the park!

Transcript of 2014 SXSW Texas Rangers Presentation

Page 1: 2014 SXSW Texas Rangers Presentation

Becky Kimbro @BeckyKimbroSarah Stone @sstone703

Big League Business Intelligence:How the Texas Rangers are Using Tableau

for Business Operations

Page 2: 2014 SXSW Texas Rangers Presentation

Measuring Ticket Sales & Monitoring Ballpark Operations

1. How did we start usingTableau?

2. What are we doing inTableau now?

3. What is our plan for the

future?

Page 3: 2014 SXSW Texas Rangers Presentation

Audience Participation:How many baseballgames are there in a

season?

Page 4: 2014 SXSW Texas Rangers Presentation

Total # of Baseball Games

HOME# of Games

81

AWAY# of Games

81Off Days

20

162

HOME AWAY Off DaysApril September

Page 5: 2014 SXSW Texas Rangers Presentation

Must Sell Tickets to 81 Home Games

April May June July August September

PHI HOU SEA CWS OAK COL BOS TOR SEA BAL CLE MIA DET MIN HOU LAA OAK NYY TB LAA KC SEA LAA ATL HOU OAK

0K

10K

20K

30K

40K

Avg. Home Attendance

3 3 4 3 3 2 3 3 2 3 4 2 3 3 3 4

2014 Game Series

Page 6: 2014 SXSW Texas Rangers Presentation

Promotions & GiveawaysApril May June July August September

2 12 14 16 18 20 29 8 10 16 18 21 4 6 8 10 24 26 28 8 10 12 25 27 29 12 14 16 22 24 5 7 10 12 14 23 25 27

0K

10K

20K

30K

40K

50K

60K

70K

80K

90K

100K

Home Attendance

Page 7: 2014 SXSW Texas Rangers Presentation

?What sort of impact do promotionsand giveaways have on attendance?

Page 8: 2014 SXSW Texas Rangers Presentation

Texas Rangers Home Game Attendance

10K

20K

30K

40K

50K

Avg. Attendance

SA

SA

SA

SA

SA

SA

SU

SU SUSU

SU

SU

SU

SU

SU

SUSU

TU

TU

TUTU

TU

TR

TR TR TR

TR

TR

TR

W

W

W

W

W

MM

M

M

MM M

F F

FF

F

F F

F

FF

F

2013 Attendance by Opponent, Day of Week

Day of Week Opponent Rangers Statring Pitcher Temp Promotions1 Result Home

April 5, 2013, Friday LAA Holland 75 Opening Day Concert (Cody Johnson) & Magne.. W

April 6, 2013, Saturday LAA Harrison 75 Concert (Mark McKinney) & Magnetic Schedule.. L

April 7, 2013, Sunday LAA Darvish 73 Batting Helmets W

April 8, 2013, Monday TB Ogando 73 no promo W

April 9, 2013, Tuesday TB Tepesch 79 T-shirt: Yu Darvish W

April 10, 2013, Wednesday TB Holland 39 Dollar Hot Dog L

April 19, 2013, Friday SEA Darvish 62 Fireworks W

April 20, 2013, Saturday SEA Tepesch 68 no promo W

April 21, 2013, Sunday SEA Grimm 69 Ice Cream & T-Shirt: Adrian Beltre W

April 30, 2013, Tuesday CWS Darvish 82 Picnic Blanket W

May 1, 2013, Wednesday CWS Tepesch 81 Autograph Wednesday & Dollar Hot Dog L

48,845

47,201

42,034

27,355

31,398

26,643

36,273

43,025

44,599

40,646

34,677

2013 Home Game Details

Day of Week?All

Starting Pitcher?All

CategoryAll

Promo?All

OpponentAll

TemperatureAll

Year?2013

38,693

Avg. Atten-dance

81

# of Games

Page 9: 2014 SXSW Texas Rangers Presentation

Texas Rangers 2013 - Attendance by Day of Week

39,406

TUESDAYS

Which non-weekend day of the week has drawn the highestaverage attendance in 2013?

Weekend Weekday36,71040,985

2013 Average Attendance

Sunday

Saturday

Friday 40,059

41,441

41,455

Weekends2013 Average Attendance

Tuesday

Wednesday

Thursday

Monday 34,295

34,848

37,421

39,406

Weekdays2013 Average Attendance

0K

20K

40K

Avg. Attend..

Weekends

0K

20K

40K

Avg. Attenda..

Weekdays

2013 Weekends in Red | Weekdays in Blue

11 Tuesday All Fan Giveaways

9 Kids Saturday/Sunday Giveaways4 All Fan Saturday/Sunday Giveaways

Page 10: 2014 SXSW Texas Rangers Presentation

Texas Rangers 2013 - Attendance by Promotion Types

No Promotion Yes Promotion

40,08535,853

2013 Average Attendance

Do games with promotions increase attendance?

2013 Games with Giveaways in Orange

Which type of promotion is most effective?

Giveaways Other Promo No promo

35,85338,97641,564

2013 Average Attendance

Giveaways include caps, t-shirts, bobbleheads, etc.

Other promotions includefireworks, dollar dogs, con-

certs, events, etc.

Games with no pro-motions whatsoever

Page 11: 2014 SXSW Texas Rangers Presentation

Audience Participation:

How many tickets totaldid the average MLBteam sell in 2013?

Page 12: 2014 SXSW Texas Rangers Presentation

The average MLB team sold 2.5 million tickets in 2013

MLS NFL NBA NHL MLB

2,467,563

540,766710,677

316,105

721,083

Lots oftickets tosell!

Average # of Tickets Sold in 2013 for One Team

Page 13: 2014 SXSW Texas Rangers Presentation

Collaboration!

Page 14: 2014 SXSW Texas Rangers Presentation

At this point, we will log onto Tableau Server to demonstrate how we've been usingdifferent dashboards this season:

Ticket Sales Today

Tickets Sold: Actual vs BudgetWalkup Ticket SalesGame Day TurnstilePromo by Buyer TypeBox Office Work StationSales room TV dashboards