Portfolio / SA Footballer AI publishing & CRM
SA Footballer AI publishing & CRM
A fully automated AI system that publishes 300+ match reports a week and runs email campaigns to 2,000+ subscribers.
300+match reports published every week
2,000+subscribers on automated email
68.3%email open rate
The problem
A regional football publication covers hundreds of matches every week across many leagues, and had to keep thousands of subscribers, clubs and sponsors updated. Doing both by hand was impossible.
What I built
- An AI pipeline that writes and publishes match reports straight into the Sanity CMS, in batches
- A PlayHQ fixtures and results sync with throttling and retry logic
- An AI CRM dashboard that segments subscribers into clubs, sponsors and premium members
- Automated email campaigns, weekly newsletters and magazine delivery
- Scheduled cron jobs so everything runs without manual effort after setup
The result
After setup the system needs zero manual work. Segments include 48 clubs, 32 sponsors and 795 premium subscribers, each getting the right content automatically.