Select Interactive
Case Study3 min read

Dave Campbell’s Texas Football: A Case Study

How we helped the Texas high school football icon move off WordPress to a custom platform built for subscriptions, live scoring, real-time rankings, recruiting, and ad management.

Jeremy Burton

Partner, Select Interactive

Ready to truly focus and improve the digital experience for their subscriber base, the Texas high school football icon, Dave Campbell’s Texas Football, reached out to us to discuss their goals, technology limitations, and long term vision.

Running on WordPress for many years, they were unaware of the multitude of options we could provide for administrative access, data organization, real-time updates and more. Working together, we achieved their goals through the following features.

Subscription Services

Dave Campbell’s Texas Football has long been a retail print publication. More recently, they have invested in providing more content to their online subscribers. No longer bound by the number of pages in a magazine, they have a never ending canvas to work with on the web.

Working together, we created a streamlined subscription flow that provides the subscriber with a mailed copy of the print edition, in-depth analysis of high school talent in Texas, access to insider videos and archives, recruiting services, and insider picks of every high school game in Texas.

The biggest goal coming in was to maximize subscriptions, so identifying more ways to surface unique content has been critical to the continued success of the new site.

Live Scoring

As Texans ourselves, we know how important it is to have live scoring updates for Friday night high school games. We designed this feature to withstand high traffic within a short time period.

The first weekend we launched live scoring we saw 29,000 visits to the site overall, with 18,500 visits to the Live Scoring page alone, peaking at 150–300 active users every minute.

During the 2018 playoff games, 42,500 people visited the Live Scoring page in a single day.

How we kept it online under load

To ensure the site could withstand that kind of concentrated traffic, we leaned on Microsoft Azure’s cloud hosting infrastructure.

  • Configured auto-scale capabilities to bring additional servers online, and take them back down, based on current traffic volume
  • Used a load balancer to direct new traffic to the server with the least volume of usage in real time
  • Leaned on SQL database performance reports to constantly improve data organization and query paths as more data became available

Heat Index Rankings

College football is serious business and knowing where your team stands within the rankings during the season is a must. Together with the team at Dave Campbell’s we developed the Texas College Football Heat Index, a ranking that tallies up the results, winning streaks, and point differentials of the last 10 games for every program in the state, from Texas to Navarro.

Using DCTF’s formula, we dynamically generate the Heat Index at the completion of each team’s game, always keeping the index up to date in real time. Our ability to cross-link data throughout the site means those Heat Index rankings update site-wide on team pages as well as the Heat Index itself.

Recruiting Feature

Recruiting talent for college teams used to consist of calling coaches, visiting practices, and watching highlight reels. Today college recruiting has taken on a life of its own, between Twitter, Hudl, and ESPN, recruiting is everywhere.

With continued focus on Texas high school football, DCTF wanted to provide more coverage of the players in your communities and offer something no other service has: player honors and attributes.

Working with Dave Campbell’s we developed a backend recruiting system to help compile all relevant data about a player into one place. Beginning with the class of 2020, DCTF provides:

  • Statewide rankings and positional rankings
  • Star ratings and player descriptions
  • Honors and attributes
  • Colleges of interest and commitment status
  • Highlight videos

Advertising Management System

With pre-existing advertisers in place, the Dave Campbell’s team needed a way to manage the display of those partners without relying on third-party plugins from Google or other advertising engines that wouldn’t play nicely with their existing ad deals.

To achieve this, we built a complete advertising management system. Their marketing team can input graphics and variable metadata such as ad placement within the site, limits on impressions and clicks, and ad prioritization, all without a developer in the loop.

The Result

Moving off WordPress freed Dave Campbell’s Texas Football from the constraints of a generic CMS and let us design every layer, subscriptions, live data, rankings, recruiting, and advertising, around how their team actually works and how Texas football fans actually consume the product.

The platform has continued to evolve season after season, and the same architectural decisions that handled 42,500 playoff visitors in a single day still underpin the site today.

Work With Us

Have a project in mind?

We build the web’s most demanding applications. Let’s talk about yours.

Get in Touch