All Work
AI SystemsAI Platform2025

The Data & AI Backbone Behind PromoShare's Fan-Ambassador Engine

  • Python
  • Apify
  • pandas
  • NumPy
  • Snowflake
  • AWS EC2
  • AWS S3
  • Data Lake
  • AWS Bedrock
  • OpenAI
  • PandasAI
  • GitHub Actions CI/CD
  • ETL Pipeline
  • React Native
  • Instagram + TikTok

The challenge

Fragmented social scrapes: no warehouse, no cross-platform tiering, and no way for non-technical marketers to know which ambassadors, hashtags and events actually drive ticket revenue.

What we built

An Apify-driven IG/TikTok ingestion pipeline into a governed Snowflake warehouse, with OpenAI enrichment, ambassador tiering & fatigue analysis, an NL-query chatbot, and a two-way event matchmaker.

Systems delivered

  • Multi-platform social ingestion pipeline (Apify)
  • Governed Snowflake warehouse & data lake
  • Automated ETL delivery (GitHub Actions CI/CD to AWS)
  • OpenAI event categorization
  • Ambassador tiering & fatigue analysis
  • Natural-language query chatbot (LLM + PandasAI)
  • Bi-directional ambassador-event recommendation engine

Outcome

33x peak fan-campaign ROAS, 60K+ ambassadors mobilized, 6+ MLB clubs plus NHL activated, IG + TikTok unified.

Have a similar product challenge? Let's talk about the right technical path.

Discuss a Similar Build
The Data & AI Backbone Behind PromoShare's Fan-Ambassador Engine | Techlusion Work