/sideline-sprint-tools

Code for the staff internal tools website from my Sideline Sprint project.

Primary LanguagePHPMIT LicenseMIT

Sideline Sprint logo

Sideline Sprint newsletter

Sideline Sprint Tools Website

What was Sideline Sprint?

Sideline Sprint was a daily sports email newsletter. The goal was to deliver the best of the sports world directly to your inbox every weekday morning. Sideline Sprint was in operation from the beginning of 2021 up until March of 2022.

What was my role?

I served as a co-founder & the tech lead for the project (but also took on many other tasks as is often the case in startups).

What did I do?

During my time working on Sideline Sprint, I worked on a variety of unique tasks including but not limited to:

  • Built a website from scratch and leveraged cloud infrastructure
  • Ensured email alignment on DMARC/DKIM/SPF/BIMI to achieve best-in-class deliverability with an average open rate of ~50%
  • Posted all newsletters as articles to our Ghost blog to promote SEO
  • Monitored SEO and improved ranking/clicks drastically over our 1.5 years in operation
  • Built a referral program from scratch so that readers could bring in others at a low cost per acquisition (CPA)
  • Designed the logo and graphics for the website, as well as merchandise for the referral program
  • Created a custom responsive email template and setup a custom newsletter writing platform based on TinyMCE
  • Setup & administered all of the tools listed in the below sections

What does this repo contain?

This repository hosts all of the code for the Sideline Sprint tools website.

Our main infrastructure was made up of two websites:

  • The main website for signups, hosting articles, etc.
  • A second private website with tools built just for newsletter staff

The code in this repo relates to the staff website. I built tools from scratch to manage a variety of functions and increase efficiency of managing the newsletter. These tools included:

  • Overview stats dashboards on campaigns, subscriber lists, and more
  • Custom newsletter editor, based upon TinyMCE
  • Image upload tool
  • Subscriber management tools (search, update values, etc.)
  • Uploading articles to our self-hosted Ghost blog

I found that in-house built tools often fit our use cases better than out-of-the box solutions.

Sensitive information including API keys, logins, etc. have been masked.

Packages used

  • Hashids (generating unique user IDs)
  • Createsend API SDK (interacting with Campaign Monitor via API)
  • Spaces API (interacting with DigitalOcean Spaces via API)
  • Auth0 (user authentication for restricted staff tools)
  • BunnyCDN API (interacting with Bunny CDN via API)
  • Postmark PHP SDK (interacting with Postmark via API for transactional and alerting emails)

Other tools I used

Related works

If you're interested in seeing the other work I did for Sideline Sprint, please take a look at the following repos:

Architecture

Sideline Sprint architecture diagram

Screenshots

Tools Site

Sideline Sprint tools site

Subscriber Overview Dashboard

Sideline Sprint subscriber overview dashboard

Website Article Uploader

Sideline Sprint website article uploader

Image Uploader

Sideline Sprint image uploader

Single Subscriber Search

Sideline Sprint single subscriber search

Bulk Subscriber Search

Sideline Sprint bulk subscriber search